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