From b51ed3cea777b1809afe07db7314b0e0a8c0e9b8 Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期三, 22 二月 2023 11:15:25 +0800 Subject: [PATCH] 工序出站-保存屏蔽包装标识,员工同步更改 --- WebAPI/Controllers/MoveStockBillController.cs | 160 ++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 158 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/MoveStockBillController.cs b/WebAPI/Controllers/MoveStockBillController.cs index 1e612ef..fa54883 100644 --- a/WebAPI/Controllers/MoveStockBillController.cs +++ b/WebAPI/Controllers/MoveStockBillController.cs @@ -46,6 +46,7 @@ public ClsKF_PonderationBillMain_Temp model = new ClsKF_PonderationBillMain_Temp(); private JsonResult objJsonResult = new JsonResult(); private json objjson = new json(); + private object oCn; /// <summary> /// 璋冩嫧鍗�/杩斿洖鍑哄叆搴撴潯鐮佷复鏃惰〃/鐩存帴璋冪敤webservice @@ -542,8 +543,10 @@ WebS.WebService1 oWebs = new WebS.WebService1(); WebS.ClsKf_ICStockBill_WMS WebSoBar = new WebS.ClsKf_ICStockBill_WMS(); string sExpressNumber = ""; + + var sJXCode = POStockInBillController.JX_Json(sCode, sInterID, HBillType, HStockOutOrgID, sBillNo,sMaker); //WebSoBar = oWebs.get_CheckTypeByBarCode_All(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, sExpressNumber, ref DBUtility.ClsPub.sErrInfo); - WebSoBar = oWebs.get_BarCode_MoveStock(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, HSCWhID, HSCSPID, sQty, SourceFlag, sSourceBillNo, sHSourceBillType, HStockInOrgID,HStockOutOrgID,HScanStyle, ref DBUtility.ClsPub.sErrInfo); + WebSoBar = oWebs.get_BarCode_MoveStock(sJXCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, HSCWhID, HSCSPID, sQty, SourceFlag, sSourceBillNo, sHSourceBillType, HStockInOrgID,HStockOutOrgID,HScanStyle, ref DBUtility.ClsPub.sErrInfo); if (WebSoBar == null) { objJsonResult.code = "0"; @@ -572,6 +575,128 @@ { var _value = oMain["oMain"].ToString(); string msg1 = _value.ToString(); + + + + + //List<Model.ClsKf_MoveStockBillMain> lsmain = new List<Model.ClsKf_MoveStockBillMain>(); + //ListModels oListModels = new ListModels(); + //lsmain = oListModels.getMoveStockBillMainByJson(msg1); + //lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); + //lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); + //string sSourceBillType = lsmain[0].HBillType; + //BLL.ClsKf_MoveStockBill bll = new BLL.ClsKf_MoveStockBill(); + //return bll.set_SaveMoveStockBill(lsmain[0], sSourceBillType, ref DBUtility.ClsPub.sErrInfo); + try + { + List<Model.ClsKf_MoveStockBillMain> lsmain = new List<Model.ClsKf_MoveStockBillMain>(); + ListModels oListModels = new ListModels(); + lsmain = oListModels.getMoveStockBillMainByJson(msg1); + lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); + lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); + string sSourceBillType = lsmain[0].HBillType; + //string sSourceBillType = "-1"; + + + WebAPI.WebS.ClsKf_MoveStockBillMain websLsmain = new WebS.ClsKf_MoveStockBillMain(); + websLsmain.HInterID = lsmain[0].HInterID; + websLsmain.HDate = lsmain[0].HDate; + websLsmain.HBillNo = lsmain[0].HBillNo; + websLsmain.HDeptID = lsmain[0].HDeptID; + websLsmain.HEmpID = lsmain[0].HEmpID; + websLsmain.HRemark = lsmain[0].HRemark; + websLsmain.HMaker = lsmain[0].HMaker; + websLsmain.HWHID = lsmain[0].HWHID; + websLsmain.HSCWHID = lsmain[0].HSCWHID; + websLsmain.HKeeperID = lsmain[0].HKeeperID; + websLsmain.HSecManagerID = lsmain[0].HSecManagerID; + websLsmain.HManagerID = 0; + websLsmain.HBillerID = 0; + websLsmain.HExplanation = ""; + websLsmain.HInnerBillNo = ""; + websLsmain.HRedBlueFlag = true; + websLsmain.HMainSourceBillType = "-1"; + websLsmain.HStockStyle = ""; + websLsmain.HBillType = "1207"; + websLsmain.HBillSubType = lsmain[0].HBillSubType; + websLsmain.HSupID = 0; + //websLsmain.HGroupID = lsmain[0].HGroupID; + string sErrMsg = ""; + //涓婁紶鍓嶅垽鏂� + SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); + DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_BeforeUpload_MoveStockBill_AR " + websLsmain.HInterID.ToString() + ",'" + websLsmain.HBillNo + "','" + websLsmain.HBillType + "'", "h_p_WMS_BeforeUpload_MoveStockBill_AR"); + if (Ds == null || Ds.Tables[0].Rows.Count == 0) + { + sErrMsg = "鏍¢獙涓婁紶鍓嶅垽鏂紝鍙戠敓閿欒锛�"; + //return false; + + objJsonResult.code = "99"; + objJsonResult.count = 0; + objJsonResult.Message = "涓婁紶澶辫触锛�" + sErrMsg; + objJsonResult.data = null; + return objJsonResult; + } + else + { + if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 1) + { + sErrMsg = "鍗曟嵁鍙凤細" + websLsmain.HBillNo + "锛屽崟鎹甀D锛�" + websLsmain.HInterID + "锛�" + DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]); + //return false; + objJsonResult.code = "99"; + objJsonResult.count = 0; + objJsonResult.Message = "涓婁紶澶辫触锛�" + sErrMsg; + objJsonResult.data = null; + return objJsonResult; + + } + } + + + + if (webserver.set_SaveMoveStockBill(websLsmain, sSourceBillType, ref DBUtility.ClsPub.sErrInfo)) + { + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = DBUtility.ClsPub.sErrInfo; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "99"; + objJsonResult.count = 0; + objJsonResult.Message = "涓婁紶澶辫触锛�" + DBUtility.ClsPub.sErrInfo; + objJsonResult.data = null; + return objJsonResult; + } + } + catch (Exception e) + { + + objJsonResult.code = "3"; + objJsonResult.count = 0; + objJsonResult.Message = "涓婁紶澶辫触锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + + + + /// <summary> + /// 瀹夌憺鐩樼偣鍗� + /// </summary> + /// <returns></returns> + [Route("MoveStockBill/set_SaveMoveStockBill_PD")] + [HttpPost] + public object set_SaveMoveStockBill_PD([FromBody] JObject oMain) + { + var _value = oMain["oMain"].ToString(); + string msg1 = _value.ToString(); + + + + //List<Model.ClsKf_MoveStockBillMain> lsmain = new List<Model.ClsKf_MoveStockBillMain>(); //ListModels oListModels = new ListModels(); //lsmain = oListModels.getMoveStockBillMainByJson(msg1); @@ -613,8 +738,39 @@ websLsmain.HBillType = "1207"; websLsmain.HSupID = 0; //websLsmain.HGroupID = lsmain[0].HGroupID; + //string sErrMsg = ""; + //涓婁紶鍓嶅垽鏂� + //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); + //DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_BeforeUpload_MoveStockBill_AR " + websLsmain.HInterID.ToString() + ",'" + websLsmain.HBillNo + "','" + websLsmain.HBillType + "'", "h_p_WMS_BeforeUpload_MoveStockBill_AR"); + //if (Ds == null || Ds.Tables[0].Rows.Count == 0) + //{ + // sErrMsg = "鏍¢獙涓婁紶鍓嶅垽鏂紝鍙戠敓閿欒锛�"; + // //return false; - if (webserver.set_SaveMoveStockBill(websLsmain, sSourceBillType, ref DBUtility.ClsPub.sErrInfo)) + // objJsonResult.code = "99"; + // objJsonResult.count = 0; + // objJsonResult.Message = "涓婁紶澶辫触锛�" + sErrMsg; + // objJsonResult.data = null; + // return objJsonResult; + //} + //else + //{ + // if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 1) + // { + // sErrMsg = "鍗曟嵁鍙凤細" + websLsmain.HBillNo + "锛屽崟鎹甀D锛�" + websLsmain.HInterID + "锛�" + DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]); + // //return false; + // objJsonResult.code = "99"; + // objJsonResult.count = 0; + // objJsonResult.Message = "涓婁紶澶辫触锛�" + sErrMsg; + // objJsonResult.data = null; + // return objJsonResult; + + // } + //} + + + + if (webserver.set_SaveMoveStockBill_PD(websLsmain, sSourceBillType, ref DBUtility.ClsPub.sErrInfo)) { objJsonResult.code = "0"; objJsonResult.count = 1; -- Gitblit v1.9.1