From c7489d4f0fd834c5ea9a191ea2dd5a392d07bc94 Mon Sep 17 00:00:00 2001 From: 王 垚 <1402714037@qq.com> Date: 星期五, 12 八月 2022 18:14:11 +0800 Subject: [PATCH] 优化 --- WebAPI/Controllers/POInStockController.cs | 35 ++++++++--------------------------- 1 files changed, 8 insertions(+), 27 deletions(-) diff --git a/WebAPI/Controllers/POInStockController.cs b/WebAPI/Controllers/POInStockController.cs index f73fa4b..611ffa6 100644 --- a/WebAPI/Controllers/POInStockController.cs +++ b/WebAPI/Controllers/POInStockController.cs @@ -289,10 +289,6 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); - //LogService.Write("msg1:" + msg1); - //LogService.Write("msg2:" + msg2); - //LogService.Write("msg3:" + msg3); - string UserName = ""; ListModels oListModels = new ListModels(); try @@ -372,25 +368,12 @@ objJsonResult.data = 1; return objJsonResult; } - if (FCusName == "瀹夌憺鍖荤枟") //绯荤粺鍙傛暟 瀹㈡埛瀹氬埗鍖栧悕绉� 绌虹櫧涓洪�氱敤 - { - if (DBUtility.ClsPub.isStrNull(oItemSub.HBatChNo) == "") - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "淇濆瓨澶辫触锛佺" + i.ToString() + "琛屾湭濉啓鎵瑰彿锛�"; - objJsonResult.data = 1; - return objJsonResult; - } - } - oItemSub.HEntryID = i; oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); oItemSub.HRemark = ""; oItemSub.HCloseMan = ""; oItemSub.HCloseType = false; oBill.DetailColl.Add(oItemSub); - } //淇濆瓨鍓嶅垽鏂�(鍗曟嵁鍙烽噸澶嶏紝绗斿綍椤圭洰) //淇濆瓨 @@ -398,7 +381,6 @@ bool bResult; if (oBill.omodel.HInterID == 0) { - // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); } else @@ -1205,7 +1187,6 @@ objJsonResult.data = null; return objJsonResult; } - try { //閲囪喘璁㈠崟涓嬫帹鐢熸垚閫佽揣鍗� 鏃跺�� 鍒ゆ柇鏄惁鏈夌敓鎴愰噰璐鍗曞彉鏇村崟 濡傛灉鏈変笖鍙樻洿鍗曠姸鎬佷笉涓哄凡瀹℃牳 闄愬埗涓嬫帹 @@ -1213,27 +1194,27 @@ if (objJsonResult.code == "0") return objJsonResult; - string HinterID = ""; for (int i = 0; i < mylist.Count; i++) { //鏇存柊鍏宠仈鏁伴噺 - HinterID = mylist[i].ToString(); - oCn.RunProc("exec h_p_SRM_UpDatePPBomRelationQty '" + HinterID + "'"); + var HinterID = mylist[i].ToString(); + oCn.RunProc($"exec h_p_SRM_UpDatePPBomRelationQty {HinterID}"); //鍒ゆ柇鏈叧鑱旀暟閲忔槸鍚︿负0 - DataSet ds = oCn.RunProcReturn("select * from H_v_SRM_POOrderBillList where hmainid='" + HinterID + "'", "H_v_SRM_POOrderBillList"); - if (ds != null || ds.Tables[0].Rows.Count > 0) + DataSet ds = oCn.RunProcReturn("select * from H_v_SRM_POOrderBillList where hmainid='" + HinterID + "'", "H_v_SRM_POOrderBillList"); + DataTable dt = ds.Tables[0]; + if (dt.Rows.Count > 0) { - if (ds.Tables[0].Rows[0]["鏈叧鑱旀暟閲�"].ToString() == "0") + DataRow[] dr = dt.Select("鏈叧鑱旀暟閲� = " + 0); + if (dr.Count() > 0) { objJsonResult.code = "0"; objJsonResult.count = 0; - objJsonResult.Message = "鍗曟嵁鍙凤細" + ds.Tables[0].Rows[0]["鍗曟嵁鍙�"].ToString() + "宸插叏閮ㄧ敓鎴愰�佽揣鍗曪紒"; + objJsonResult.Message = "鍗曟嵁鍙凤細" + dr[0]["鍗曟嵁鍙�"].ToString() + "鏈叧鑱旀暟閲忎负0锛屽凡鍏ㄩ儴鐢熸垚閫佽揣鍗曪紒"; objJsonResult.data = null; return objJsonResult; } } } - objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "鎿嶄綔鎴愬姛!"; -- Gitblit v1.9.1