From 180fc079a7f4e450b305e90688847649435f7ef1 Mon Sep 17 00:00:00 2001 From: wtt <1985833171@qq.com> Date: 星期三, 26 二月 2025 08:46:14 +0800 Subject: [PATCH] 退料通知单,采购退料单添加删除时回填关联数量的存储过程 --- WebAPI/Controllers/CGGL/Kf_POStockInBackBillController.cs | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/CGGL/Kf_POStockInBackBillController.cs b/WebAPI/Controllers/CGGL/Kf_POStockInBackBillController.cs index 5a5df2f..6ea0851 100644 --- a/WebAPI/Controllers/CGGL/Kf_POStockInBackBillController.cs +++ b/WebAPI/Controllers/CGGL/Kf_POStockInBackBillController.cs @@ -238,6 +238,8 @@ + ",HAddress='" + HAddress + "'where HInterID=" + HInterID; oCN.RunProc(sql); + //閲囪喘閫�鏂欏垹闄ゅ洖濉��鏂欓�氱煡鍗曞叧鑱旀暟閲� + oCN.RunProc("exec h_p_Kf_UpDateRelation_POStockInBackToPOInStockBack_Del " + HInterID); //鍒犻櫎瀛愯〃 oCN.RunProc("delete from Kf_ICStockBillSub where HInterID='" + HInterID + "'"); } @@ -445,6 +447,8 @@ string sReturn = ""; oCN.BeginTran(); + //閲囪喘閫�鏂欏垹闄ゅ洖濉��鏂欓�氱煡鍗曞叧鑱旀暟閲� + oCN.RunProc("exec h_p_Kf_UpDateRelation_POStockInBackToPOInStockBack_Del " + HInterID); oCN.RunProc("Delete From Kf_ICStockBillMain where HInterID = " + HInterID); oCN.RunProc("Delete From Kf_ICStockBillSub where HInterID = " + HInterID); oCN.Commit(); -- Gitblit v1.9.1