From 9a75f7db9431032c0f1ecc64be4966a25c74bafa Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期二, 05 十一月 2024 16:48:12 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs | 21 +++++++++++++++++++++ 1 files changed, 21 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs b/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs index 4cb3ccf..e8cb406 100644 --- a/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs +++ b/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs @@ -627,6 +627,27 @@ sw.Stop();//缁撴潫璁℃椂 LogService.Write($"11.鍙傛暟鏌ヨ缁撴潫,鏂板缁撴潫锛岀敤鏃�" + sw.Elapsed); LogService.Write("END--鍑虹珯鍗曟嵁淇濆瓨缁撴潫锛屽嚭绔欏崟鍙凤細" + HBillNo); + + //娴嬭瘯璇彞=========================================================================================================== + string msg_str = ""; + string sql_str = "select a.HQty HQty_Main,b.HQty HQty_Sub " + + "from Sc_ProcessExchangeBillMain as a " + + "inner join Sc_ProcessExchangeBillSub as b on a.HInterID = b.HInterID " + + "where a.HInterID = " + HProcExchInterID; + DataSet ds_str = oCN.RunProcReturn(sql_str, "Sc_ProcessExchangeBillMain"); + if (ds_str.Tables[0].Rows.Count > 0) + { + msg_str = "HQty_Main:" + ds_str.Tables[0].Rows[0]["HQty_Main"].ToString() + ";HQty_Sub:"; + for (int j = 0; j < ds_str.Tables[0].Rows.Count; j++) + { + msg_str += ds_str.Tables[0].Rows[j]["HQty_Sub"].ToString() + ","; + } + } + + oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "淇敼宸ュ簭鍑虹珯鍗曟嵁锛�" + HBillNo + "[宸ュ簭娴佽浆鍗″彿锛�" + HProcExchBillNo + "]" + msg_str + "','LMES-宸ュ簭鍑虹珯妯″潡','" + DBUtility.ClsPub.IPAddress + "','鏂板鎴栦慨鏀瑰崟鎹�'", ref DBUtility.ClsPub.sExeReturnInfo); + //============================================================================================================== + + objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "鏂板鍗曟嵁鎴愬姛锛�"; -- Gitblit v1.9.1