From c7489d4f0fd834c5ea9a191ea2dd5a392d07bc94 Mon Sep 17 00:00:00 2001 From: 王 垚 <1402714037@qq.com> Date: 星期五, 12 八月 2022 18:14:11 +0800 Subject: [PATCH] 优化 --- WebAPI/Controllers/POOrderController.cs | 3 --- WebAPI/Controllers/POInStockController.cs | 35 ++++++++--------------------------- WebAPI/Controllers/Xt_grdAlignment_WMESController.cs | 5 ----- 3 files changed, 8 insertions(+), 35 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 = "鎿嶄綔鎴愬姛!"; diff --git a/WebAPI/Controllers/POOrderController.cs b/WebAPI/Controllers/POOrderController.cs index f1b0b27..59f6b8d 100644 --- a/WebAPI/Controllers/POOrderController.cs +++ b/WebAPI/Controllers/POOrderController.cs @@ -186,9 +186,6 @@ return objjson; } } - - - [Route("POOrderAccept")] [HttpGet] /// <summary> diff --git a/WebAPI/Controllers/Xt_grdAlignment_WMESController.cs b/WebAPI/Controllers/Xt_grdAlignment_WMESController.cs index 434ba0e..c0f49ba 100644 --- a/WebAPI/Controllers/Xt_grdAlignment_WMESController.cs +++ b/WebAPI/Controllers/Xt_grdAlignment_WMESController.cs @@ -55,7 +55,6 @@ public string HSortFlag; public string HSelTotal; public string HColumnWidth; - } public class grdAlignmentSub { @@ -101,8 +100,6 @@ string user = sArray[4].ToString(); try { - - omdelMian = Newtonsoft.Json.JsonConvert.DeserializeObject<grdAlignment>(msg2); omdelsub = Newtonsoft.Json.JsonConvert.DeserializeObject<List<grdAlignmentSub>>(msg3); @@ -124,7 +121,6 @@ ",0,'" + omdelMian.HSortFlag + "','" + omdelMian.HSelTotal + "'" + ","+ (omdelMian.HColumnWidth == "" ? "0" : omdelMian.HColumnWidth) + ")"); - objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = null; @@ -140,7 +136,6 @@ return objJsonResult; } } - #endregion } } \ No newline at end of file -- Gitblit v1.9.1