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