From ffa387e35fb64107c944508c1131046d9e6b564d Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期二, 27 二月 2024 13:55:36 +0800 Subject: [PATCH] 凯贝奈特新增收料单单据类型 --- WebAPI/Controllers/POOrderController.cs | 65 ++++++++++++++++++++++++++++++-- 1 files changed, 60 insertions(+), 5 deletions(-) diff --git a/WebAPI/Controllers/POOrderController.cs b/WebAPI/Controllers/POOrderController.cs index 8692984..d7f9490 100644 --- a/WebAPI/Controllers/POOrderController.cs +++ b/WebAPI/Controllers/POOrderController.cs @@ -55,8 +55,8 @@ //Int64 RowTotal = Common.GetRowTotal("H_v_SRM_POOrderBillList", VsWhere, ref DBUtility.ClsPub.sExeReturnInfo); //鑾峰彇杩斿洖鏁版嵁 //sql = "exec H_P_REALESEPOORDER"; - sql = "exec H_P_REALESEPOORDER"; - oCn.RunProc(sql); + //sql = "exec H_P_REALESEPOORDER"; + //oCn.RunProc(sql); sql = "exec H_p_SRM_POOrderBillList '" + PcWhere + "'"; //LogService.WriteAsync(sql); ds = oCn.RunProcReturn("exec H_p_SRM_POOrderBillList '" + PcWhere + "'", "H_p_SRM_POOrderBillList"); @@ -188,17 +188,25 @@ } } [Route("POOrderAccept")] - [HttpGet] + [HttpPost] /// <summary> /// 璁㈠崟鎺ュ彈 /// </summary> /// <param name="HInterID"></param> /// <returns></returns> - public object POOrderAccept(string HInterID, string HBillNo, string HUser) + public object POOrderAccept([FromBody] JObject oData) { + var _value = oData["oData"].ToString(); + string msg1 = _value.ToString(); + string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + string HInter = sArray[0].ToString(); + string HInterID = HInter.Replace("\"", ""); //鍐呯爜 + string HBillNo = sArray[1].ToString().Replace("\"", ""); + string HUser = sArray[2].ToString(); //鐢ㄦ埛鍚� + try { - if (DBUtility.ClsPub.isLong(HInterID) == 0) + if (DBUtility.ClsPub.isStrNull(HInterID) == "") { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -206,6 +214,7 @@ objJsonResult.data = null; return objJsonResult; } + DAL.ClsCg_POOrderBill oBill = new DAL.ClsCg_POOrderBill(); oBill.WebAccept(DBUtility.ClsPub.isLong(HInterID), DBUtility.ClsPub.isStrNull(HBillNo), DBUtility.ClsPub.isStrNull(HUser), ref DBUtility.ClsPub.sExeReturnInfo); objJsonResult.code = "0"; @@ -297,5 +306,51 @@ return objJsonResult; } } + + [Route("Cg_Poorder/UpdateSupSendGoodsDateRemark")] + [HttpGet] + /// <summary> + /// 鏇存柊鍥炲浜ゆ湡 -- 鍑礉濂堢壒 + /// </summary> + /// <param name=""></param> + /// <returns></returns> + public object UpdateSupSendGoodsDateRemark(string HInterID, string HEntryID,string HSupSendGoodsDateRemark) + { + try + { + if (HInterID == null || HInterID == "" || HInterID == "undefined" || HEntryID == null || HEntryID == "" || HEntryID == "undefined") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鎿嶄綔澶辫触锛佷富鍐呯爜鎴栧瓙鍐呯爜涓虹┖"; + objJsonResult.data = 1; + return objJsonResult; + } + + string sql = ""; + + sql = "update Cg_POOrderBillSub set HSupSendGoodsDateRemark = '" + HSupSendGoodsDateRemark + "' where HInterID = " + HInterID + " and HEntryID = " + HEntryID; + oCn.RunProc(sql); + + //鍑礉濂堢壒 + sql = "update AIS20210820164804..T_PUR_POORDERENTRY set F_aaaa_gysjqhf = '" + HSupSendGoodsDateRemark + "' where FID = " + HInterID + " and FENTRYID = " + HEntryID; + oCn.RunProc(sql); + + objJsonResult.code = "1"; + 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; + } + } + } } \ No newline at end of file -- Gitblit v1.9.1