|
楼主 |
发表于 2025-6-16 18:47:11
|
显示全部楼层
CREATE Proc Proc_RS_UpdateDisiTaxRate
@Dlid nvarchar(200),
@iTaxRate decimal(32,4)
As
update DispatchList set iTaxRate=@iTaxRate Where DLID=@Dlid
update DispatchLists set iTaxRate=@iTaxRate Where DLID=@Dlid
update DispatchLists set iMoney=cast(iSum/((100+iTaxRate)/100) as decimal(32,2)) Where DLID=@Dlid
update DispatchLists set iTax=iSum-iMoney Where DLID=@Dlid
update DispatchLists set iUnitPrice=cast(iMoney/iquantity as decimal(32,6)) Where DLID=@Dlid
update DispatchLists set iNatMoney=cast(iNatSum/((100+iTaxRate)/100) as decimal(32,2)) Where DLID=@Dlid
update DispatchLists set iNatTax=iNatSum-iNatMoney Where DLID=@Dlid
update DispatchLists set iNatUnitPrice=cast(iNatMoney/iquantity as decimal(32,6)) Where DLID=@Dlid
delete from zhrs_t_cdms_need_record where type='发货单' and id=@dlid
|
|