From e440f44371a7f9812003a97249c642060e0bfbf5 Mon Sep 17 00:00:00 2001 From: YL <YL@LAPTOP-SE03PLUR> Date: 星期五, 04 三月 2022 17:40:25 +0800 Subject: [PATCH] 采购订单下推送货单更新关联数量判断放到后台 --- WebAPI/Controllers/EntrustOrderController.cs | 94 +++++++++++++++++++++++++++++++++-------------- 1 files changed, 66 insertions(+), 28 deletions(-) diff --git a/WebAPI/Controllers/EntrustOrderController.cs b/WebAPI/Controllers/EntrustOrderController.cs index 71eb83b..ab022cb 100644 --- a/WebAPI/Controllers/EntrustOrderController.cs +++ b/WebAPI/Controllers/EntrustOrderController.cs @@ -18,6 +18,7 @@ { private JsonResult objJsonResult = new JsonResult(); private json objjson = new json(); + SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM(); /// <summary> /// 閲囪喘鍗曞垪琛� @@ -224,48 +225,85 @@ { objJsonResult.code = "0"; objJsonResult.count = 0; - objJsonResult.Message = "鎺ュ彈澶辫触锛�"+e.ToString(); + objJsonResult.Message = "鎺ュ彈澶辫触锛�" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } - [Route("EntrustOrderRefuse")] - [HttpGet] - /// <summary> - /// 璁㈠崟鎷掔粷 - /// </summary> - /// <param name="HInterID"></param> - /// <returns></returns> + [Route("EntrustOrderRefuse")] + [HttpGet] + /// <summary> + /// 璁㈠崟鎷掔粷 + /// </summary> + /// <param name="HInterID"></param> + /// <returns></returns> public object EntrustOrderRefuse(string HInterID, string HBillNo, string HUser, string HBackRemark) + { + try { - try - { - if (DBUtility.ClsPub.isLong(HInterID) == 0) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "澶辫触锛�"; - objJsonResult.data = null; - return objJsonResult; - } - DAL.ClsWW_EntrustOrderBill oBill = new DAL.ClsWW_EntrustOrderBill(); - oBill.WebRefuse(DBUtility.ClsPub.isLong(HInterID), DBUtility.ClsPub.isStrNull(HBillNo), DBUtility.ClsPub.isStrNull(HUser), DBUtility.ClsPub.isStrNull(HBackRemark), ref DBUtility.ClsPub.sExeReturnInfo); - objJsonResult.code = "0"; - objJsonResult.count = 1; - objJsonResult.Message = "鎷掔粷鎴愬姛锛�"; - objJsonResult.data = 1; - return objJsonResult; - } - catch (Exception e) + if (DBUtility.ClsPub.isLong(HInterID) == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; - objJsonResult.Message = "澶辫触锛�" + e.ToString(); + objJsonResult.Message = "澶辫触锛�"; objJsonResult.data = null; return objJsonResult; } + DAL.ClsWW_EntrustOrderBill oBill = new DAL.ClsWW_EntrustOrderBill(); + oBill.WebRefuse(DBUtility.ClsPub.isLong(HInterID), DBUtility.ClsPub.isStrNull(HBillNo), DBUtility.ClsPub.isStrNull(HUser), DBUtility.ClsPub.isStrNull(HBackRemark), ref DBUtility.ClsPub.sExeReturnInfo); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鎷掔粷鎴愬姛锛�"; + objJsonResult.data = 1; + return objJsonResult; } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "澶辫触锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + [Route("EntrustOrderBack")] + [HttpGet] + /// <summary> + /// 璁㈠崟鍙嶉鐘舵�� + /// </summary> + /// <param name=""></param> + /// <returns></returns> + public object EntrustOrderBack(string HmainidList, string OrderBackId) + { + try + { + string sql = ""; + for (int i = 0; i < HmainidList.Split(',').Length; i++) + { + var Hmainid = HmainidList.Split(',')[i]; + sql = string.Format(@" + update WW_EntrustOrderBillSub set + HFeedback ='{0}' + where HInterID = '{1}' and HEntryID = '{2}' ", OrderBackId, Hmainid.Split('-')[0], Hmainid.Split('-')[1]); + oCn.RunProc(sql); + } + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鎿嶄綔鎴愬姛锛�"; + //objJsonResult.Message = string.Join(",", HmainidList.ToArray()); + objJsonResult.data = 1; + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "澶辫触锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } } } \ No newline at end of file -- Gitblit v1.9.1