大家好,又见面了,我是你们的朋友全栈君。
1.更新T_modulelist的StorageProductAfterSave值 UPDATE T_ModuleList SET StorageProductAfterSave=‘SaveLetterOfAdviceAfter’ where modulename=‘出运通知’ 2.创建存储过程 CREATE PROC SaveLetterOfAdviceAfter(@SerialNum varchar(30)) As Begin –写你的逻辑,其中参数@SerialNum是出运通知单据号 Update ufdata_999_2019.dbo.DispatchLists set ufdata_999_2019.dbo.DispatchLists.cItemCode=T_LetterOfAdviceProduct.cItemCode, ufdata_999_2019.dbo.DispatchLists.cItemName=T_LetterOfAdviceProduct.cItemName From T_LetterOfAdviceProduct Where T_LetterOfAdviceProduct.SerialNum=@SerialNum and T_LetterOfAdviceProduct.isdel=0 and ufdata_999_2019.dbo.DispatchLists.cDefine31=T_LetterOfAdviceProduct.GUID end
1.更新T_modulelist的StorageProductAfterSave值 UPDATE T_ModuleList SET StorageProductAfterSave=‘SaveSCOrderAfter’ where modulename=‘下达生产’ 2.创建存储过程 CREATE PROC SaveSCOrderAfter(@PactNum varchar(30)) As Begin …写你的逻辑,其中参数@PactNum是单据号,跟mom_order的自定义项10对应 end
利润结算获取外销合同费用 1.打开数据库,选择对应账套,打开存储过程,点击新建存储过程
2.输入以下sql语句 CREATE PROCEDURE [dbo].[SaveInvoiceDOCAfter](@InvoiceNum varchar(30)) As Begin if(exists(select * from T_InvoiceDOC where InvoiceNum=@InvoiceNum and isdel=0 and InvoiceDOCComplete=‘已完成’)) begin delete T_InvoiceDOCInFee WHERE InvoiceNum=@InvoiceNum and isdel=0 insert into T_InvoiceDOCInFee(InvoiceNum,ISDel,SortID,InFeeDesc,Curr,Fee,RMBFee,Remark,RMBRate,GUID,Rate) select @InvoiceNum, ISDel,SortID,InFeeDesc,Curr,Fee,RMBFee,Remark,RMBRate,GUID,Rate from T_ExpPactInFee where ISDel =0 and pactnum in (select exppactnum from T_InvoiceDOCProduct where ISDel=0 and InvoiceNum=@InvoiceNum) end end
3.执行该语句
4.新建查询,执行以下语句 UPDATE T_ModuleList SET StorageProductAfterSave=‘SaveInvoiceDocAfter’ where modulename=‘议付单证’
版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 举报,一经查实,本站将立刻删除。
发布者:全栈程序员栈长,转载请注明出处:https://javaforall.cn/191113.html原文链接:https://javaforall.cn