From 22793391f525b8171828a9d01c73e5420c60e772 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期二, 12 九月 2023 11:23:29 +0800 Subject: [PATCH] 生产资源 工艺子路线 权限 物料加字段 --- WebAPI/Controllers/MoveStockBillController.cs | 172 +++++++++++++++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 166 insertions(+), 6 deletions(-) diff --git a/WebAPI/Controllers/MoveStockBillController.cs b/WebAPI/Controllers/MoveStockBillController.cs index 1e612ef..75a5bf1 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,11 @@ 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); + string HCustom1 = "", HCustom2 = ""; + 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, HCustom1, HCustom2); if (WebSoBar == null) { objJsonResult.code = "0"; @@ -572,6 +576,10 @@ { 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); @@ -607,18 +615,50 @@ websLsmain.HBillerID = 0; websLsmain.HExplanation = ""; websLsmain.HInnerBillNo = ""; - websLsmain.HRedBlueFlag = true; + websLsmain.HRedBlueFlag = false; 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.Message = DBUtility.ClsPub.sErrInfo; //鎴愬姛锛� objJsonResult.data = null; return objJsonResult; } @@ -626,7 +666,8 @@ { objJsonResult.code = "99"; objJsonResult.count = 0; - objJsonResult.Message = "涓婁紶澶辫触锛�" + DBUtility.ClsPub.sErrInfo; + objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //澶辫触锛� + //objJsonResult.Message = "涓婁紶澶辫触锛�" + DBUtility.ClsPub.sErrInfo; objJsonResult.data = null; return objJsonResult; } @@ -641,6 +682,123 @@ 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); + // //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.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_PD(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; + // } + //} @@ -700,7 +858,8 @@ { objJsonResult.code = "0"; objJsonResult.count = 1; - objJsonResult.Message = "鐢熸垚璋冩嫧鍗曟垚鍔燂紒鍗曟嵁鍙蜂负锛�"; + objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //鎴愬姛锛� + //objJsonResult.Message = "鐢熸垚璋冩嫧鍗曟垚鍔燂紒鍗曟嵁鍙蜂负锛�"; objJsonResult.data = null; return objJsonResult; } @@ -708,7 +867,8 @@ { objJsonResult.code = "99"; objJsonResult.count = 0; - objJsonResult.Message = "涓婁紶澶辫触锛�" + DBUtility.ClsPub.sErrInfo; + objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //澶辫触锛� + //objJsonResult.Message = "涓婁紶澶辫触锛�" + DBUtility.ClsPub.sErrInfo; objJsonResult.data = null; return objJsonResult; } -- Gitblit v1.9.1