From cb53926b8f36c4e036d7065c6992a4c7a7da3cce Mon Sep 17 00:00:00 2001 From: cwjbxqmz <1134865194@qq.com> Date: 星期二, 14 十一月 2023 11:06:24 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/SCGL/Sc_ICMOChangeBillController.cs | 15 ++++++++------- 1 files changed, 8 insertions(+), 7 deletions(-) diff --git a/WebAPI/Controllers/SCGL/Sc_ICMOChangeBillController.cs b/WebAPI/Controllers/SCGL/Sc_ICMOChangeBillController.cs index e404a26..5d28711 100644 --- a/WebAPI/Controllers/SCGL/Sc_ICMOChangeBillController.cs +++ b/WebAPI/Controllers/SCGL/Sc_ICMOChangeBillController.cs @@ -48,12 +48,12 @@ if (sWhere == null || sWhere.Equals("")) { - ds = oCN.RunProcReturn("select * from h_v_Sc_ICMOChangeBillList_Query order by 鍗曟嵁鍙� ", "h_v_Sc_ICMOChangeBillList_Query"); + ds = oCN.RunProcReturn("select * from h_v_Sc_ICMOChangeBillList_Query order by 鍗曟嵁鍙� desc", "h_v_Sc_ICMOChangeBillList_Query"); } else { string sql1 = "select * from h_v_Sc_ICMOChangeBillList_Query where 1 = 1 "; - string sql = sql1 + sWhere + " order by 鍗曟嵁鍙� "; + string sql = sql1 + sWhere + " order by 鍗曟嵁鍙� desc"; ds = oCN.RunProcReturn(sql, "h_v_Sc_ICMOChangeBillList_Query"); } @@ -487,8 +487,7 @@ return objJsonResult; } - //鍙嶅啓婧愬崟鏁版嵁 - oCN.BeginTran(); + //妫�鏌ユ簮鍗曟槸鍚﹀瓨鍦� string sql = "select * from Sc_ICMOBillSub where HInterID = " + oBill.omodel.HMainSourceInterID + " and HEntryID =" + oBill.omodel.HMainSourceEntryID; ds = oCN.RunProcReturn(sql, "Sc_ICMOBillSub"); if(ds==null || ds.Tables[0].Rows.Count == 0) @@ -499,12 +498,14 @@ objJsonResult.data = null; return objJsonResult; } - sql = "update Sc_ICMOBillSub set HQty = " + oBill.DetailColl[0].HQty_New + " where HInterID = " + oBill.omodel.HMainSourceInterID + " and HEntryID =" + oBill.omodel.HMainSourceEntryID; - oCN.RunProc(sql); - + //瀹℃牳鎻愪氦 if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) { + //鍙嶅啓婧愬崟鏁版嵁 + oCN.BeginTran(); + sql = "exec h_p_Sc_ICMOBill_ReWriteByICMOChangeBill " + oBill.omodel.HInterID; + oCN.RunProc(sql); oCN.Commit(); objJsonResult.code = "1"; -- Gitblit v1.9.1