From 438e9cf23ce53d875ba180f16ca3f5513a769910 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期六, 11 五月 2024 15:39:41 +0800
Subject: [PATCH] 销售出库单:下查功能

---
 WebAPI/Controllers/CGGL/Cg_PayableBillController.cs |   23 +++++++++++++++++------
 1 files changed, 17 insertions(+), 6 deletions(-)

diff --git a/WebAPI/Controllers/CGGL/Cg_PayableBillController.cs b/WebAPI/Controllers/CGGL/Cg_PayableBillController.cs
index 2027a30..f6dc975 100644
--- a/WebAPI/Controllers/CGGL/Cg_PayableBillController.cs
+++ b/WebAPI/Controllers/CGGL/Cg_PayableBillController.cs
@@ -151,6 +151,7 @@
                             return objJsonResult;
                         }
                     }
+
                     UserName = oItem.HMaker;  //鍒跺崟浜�
                     oItem.HBillType = "1114";
                     oItem.HBillSubType = "1114";
@@ -173,10 +174,10 @@
                 msg3 = msg3.Replace("\\", "");
                 msg3 = msg3.Replace("\n", "");  //\n
                 //msg2 = msg2.Replace("'", "鈥�");
-                List<Model.ClsCg_PayableBillSub> ls = new List<Model.ClsCg_PayableBillSub>();
-                ls = oListModels.getObjectByJson_Cg_PayableBillSub(msg3);
+                List<Model.ClsCg_PayableSub> ls = new List<Model.ClsCg_PayableSub>();
+                ls = oListModels.getObjectByJson_Cg_PayableSub(msg3);
                 int i = 0;
-                foreach (Model.ClsCg_PayableBillSub oItemSub in ls)
+                foreach (Model.ClsCg_PayableSub oItemSub in ls)
                 {
                     i++;
                     oItemSub.HEntryID = i;
@@ -194,6 +195,7 @@
                 bool bResult;
                 if (refSav == "Add")
                 {
+                 
                     // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
                     bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
                 }
@@ -335,8 +337,14 @@
 
                 oCN.BeginTran();
 
+                //搴斾粯鍗� 鍒犻櫎 鎾ら攢 閲囪喘鍏ュ簱鍗� 鍏宠仈鏁伴噺
+                oCN.RunProc("exec h_p_Cg_UpDateRelation_POStockInToPayable_Del " + HInterID);
+
+                //搴斾粯鍗� 鍒犻櫎 鎾ら攢 閲囪喘璁㈠崟 鍏宠仈鏁伴噺
+                oCN.RunProc("exec h_p_Cg_UpDateRelation_POOrderToPayable_Del " + HInterID);
+
                 oCN.RunProc("delete from Cg_PayableBillMain where HInterID = " + HInterID);
-                oCN.RunProc("delete from Cg_PayableBillSub where HInterID= " + HInterID);
+                oCN.RunProc("delete from Cg_PayableSub where HInterID= " + HInterID);
 
                 ////鍒犻櫎鍚庢帶鍒�==================================================================================      
                 //string sql2 = "exec h_p_Xs_ReceivableBill_AfterDelCtrl " + BillOld.omodel.HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'";
@@ -367,7 +375,7 @@
 
                 objJsonResult.code = "1";
                 objJsonResult.count = 1;
-                objJsonResult.Message = "鎮ㄥ凡鍒犻櫎鍗曟嵁鍙蜂负" + BillOld.omodel.HBillNo + "鐨勫簲鏀跺崟锛�";
+                objJsonResult.Message = "鎮ㄥ凡鍒犻櫎鍗曟嵁鍙蜂负" + BillOld.omodel.HBillNo + "鐨勫簲浠樺崟锛�";
                 objJsonResult.data = null;
                 return objJsonResult;
             }
@@ -382,6 +390,8 @@
             }
         }
         #endregion
+
+
 
         #region 搴斾粯鍗� 瀹℃牳/鍙嶅鏍�
         /// <summary>
@@ -576,7 +586,7 @@
             }
             catch (Exception e)
             {
-                oCN.RollBack();
+                //oCN.RollBack();
 
                 objJsonResult.code = "0";
                 objJsonResult.count = 0;
@@ -587,6 +597,7 @@
         }
         #endregion
 
+
         #region 搴斾粯鍗� 鍏抽棴/鍙嶅叧闂�
         /// <summary>
         /// </summary>

--
Gitblit v1.9.1