派生自 MES-WEB-API
WebAPI/Controllers/ProductInController.cs
@@ -127,6 +127,89 @@ } //刷新表体 返回出入库条码临时表（领料出库简洁版） [Route("ProductIn/DisBillEntryList_Webs_New_Json1")] [HttpGet] public object DisBillEntryList_Webs_New_Json1(long HBillID, string HBillNo, string HBillType, string sMouldManagerCtl, string sFIFOCtl) { try { WebS.WebService1 oWebs = new WebS.WebService1(); ds = oWebs.GetBillEntry_TmpList(HBillID, HBillNo, HBillType, ref sMouldManagerCtl, ref sFIFOCtl, ref DBUtility.ClsPub.sErrInfo); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！"; objJsonResult.data = null; return objJsonResult; //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning); } else { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = new { list = ds.Tables[0], list2 = ds.Tables[4] }; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } //缓存列表查询功能 [Route("ProductInBillList/list1")] [HttpGet] public object list1(string BillType, string HBillNo, string HSourceBillNo) { try { if (HSourceBillNo == null) { HSourceBillNo = ""; } WebS.WebService1 oWebs = new WebS.WebService1(); ds = oWebs.GetKf_ICStockBillQueryList(BillType, HBillNo, HSourceBillNo); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！"; objJsonResult.data = null; return objJsonResult; //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning); } else { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } /// <summary> /// 其他出库校验扫描单据号/直接调用webservice /// </summary> @@ -165,6 +248,80 @@ } /// <summary> /// 生产领料校验扫描单据号/直接调用webservice /// </summary> /// <returns></returns> //[Route("OtherOutBill_Check_New/BillNo")] [Route("MateBill/BillNo1")] [HttpGet] public Object BillNo1(string HBillNo, string HBillType, string HMaker, Int64 HOwnerID) { //if (sRedBlue == true) //{ // HBillType = "1245"; //} //oBar = webserver.get_CheckTypeByBarCode(sCode, sInterID, sBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, ref DBUtility.ClsPub.sErrInfo); WebS.WebService1 oWebs = new WebS.WebService1(); WebS.ClsKf_ICStockBill_WMS WebSoBar = new WebS.ClsKf_ICStockBill_WMS(); string sExpressNumber = ""; //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_BillBarCode_MateOutCheck(HBillNo, HBillType, HMaker, HOwnerID, ref DBUtility.ClsPub.sErrInfo); if (WebSoBar == null) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = DBUtility.ClsPub.sErrInfo; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = DBUtility.ClsPub.sErrInfo; objJsonResult.data = WebSoBar; return objJsonResult; } } /// <summary> /// 直接调拨单校验扫描单据号/直接调用webservice /// </summary> /// <returns></returns> //[Route("OtherOutBill_Check_New/BillNo")] [Route("MoveStockBill/BillNo2")] [HttpGet] public Object BillNo2(string HBillNo, string HBillType, string HMaker, Int64 HOwnerID) { //if (sRedBlue == true) //{ // HBillType = "1245"; //} //oBar = webserver.get_CheckTypeByBarCode(sCode, sInterID, sBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, ref DBUtility.ClsPub.sErrInfo); WebS.WebService1 oWebs = new WebS.WebService1(); WebS.ClsKf_ICStockBill_WMS WebSoBar = new WebS.ClsKf_ICStockBill_WMS(); string sExpressNumber = ""; //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_BillBarCode_MoveStockCheck(HBillNo, HBillType, HMaker, HOwnerID, ref DBUtility.ClsPub.sErrInfo); if (WebSoBar == null) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = DBUtility.ClsPub.sErrInfo; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = DBUtility.ClsPub.sErrInfo; objJsonResult.data = WebSoBar; return objJsonResult; } } /// <summary> /// 其他出库校验扫描条码/直接调用webservice /// </summary> /// <returns></returns> @@ -177,6 +334,38 @@ string sExpressNumber = ""; //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_CheckTypeByBarCode_BillCheck(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, sQty, HOWNERID, ref DBUtility.ClsPub.sErrInfo); if (WebSoBar == null) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = DBUtility.ClsPub.sErrInfo; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = DBUtility.ClsPub.sErrInfo; objJsonResult.data = WebSoBar; return objJsonResult; } } /// <summary> /// 直接调拨校验扫描条码/直接调用webservice /// </summary> /// <returns></returns> [Route("MoveStockBill_Check_New/get_InfoByBarCode_Source_Json1")] [HttpGet] public Object get_InfoByBarCode_Source_Json1(string sCode, Int64 sInterID, string HBillType, string sBillNo, string sMaker, Int64 WhID, Int64 SPID, Int64 SCWhID, Int64 SCSPID, Int64 sQty, Int64 HOWNERID) { WebS.WebService1 oWebs = new WebS.WebService1(); WebS.ClsKf_ICStockBill_WMS WebSoBar = new WebS.ClsKf_ICStockBill_WMS(); string sExpressNumber = ""; //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_MoveStockBillCheck(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, SCWhID, SCSPID, sQty, HOWNERID, ref DBUtility.ClsPub.sErrInfo); if (WebSoBar == null) { objJsonResult.code = "0"; @@ -491,7 +680,17 @@ { try { ds = webserver.GetBarCode_Temp(HInterID, HMaterID, HAuxPropID, HMTONo, HWhID, HSPID, HSCWhID, HSCSPID, HBatchNo, HSourceInterID, HSourceEntryID, sBillType, sWhere); if (HMTONo == null) { HMTONo = ""; } if (HBatchNo == null) { HBatchNo = ""; } WebS.WebService1 oWebs = new WebS.WebService1(); ds = oWebs.GetBarCode_Temp(HInterID, HMaterID, HAuxPropID, HMTONo, HWhID, HSPID, HSCWhID, HSCSPID, HBatchNo, HSourceInterID, HSourceEntryID, sBillType, sWhere); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objJsonResult.code = "0"; @@ -520,6 +719,47 @@ return objJsonResult; } } #region 点击编辑按钮返回参数信息 /// <summary> /// 点击编辑按钮返回参数信息 ///参数：string sql。 ///返回值：object。 /// </summary> [Route("Kf_BarCodeEditDlg/Kf_BarCodeEditDlg_Json")] [HttpGet] public object Kf_BarCodeEditDlg_Json(string sWhere) { DataSet ds; try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql1 = "select * from KF_PonderationBillMain_Temp Where HQty<>0 "; string sql = sql1 + sWhere + " order by hinterid desc"; ds = oCN.RunProcReturn(sql, "KF_PonderationBillMain_Temp"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion //点击编辑 公用窗体删除方法 [Route("Kf_BarCodeEditDlg/DeltetBill")] @@ -645,7 +885,6 @@ [HttpGet] public object set_SavePonderationBillMain_Temp_Source_Fast_Json(string HSourceBillType, string HSourceBillNo, Int64 sInterID, string sBillNo) { string aa = ""; try { // DataSet ds = new DataSet(); @@ -653,10 +892,9 @@ string sWhere = " Where 单据号 like '%" + HSourceBillNo.Trim() + "%'"; if (HSourceBillType == "3710") { aa = "执行了"; ds = webserver.GetSc_ICMOBillList(sWhere + " "); } if (HSourceBillType == "3711") else if (HSourceBillType == "3711") { ds = webserver.GetSc_ICMOReportBillList(sWhere + " "); } @@ -664,7 +902,7 @@ { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录,源单类型有错误！"+aa; objJsonResult.Message = "没有返回任何记录,源单类型有错误！"; objJsonResult.data = null; return objJsonResult; ; } @@ -929,6 +1167,7 @@ websLsmain.HWHID = lsmain[0].HWHID; websLsmain.HSupID = lsmain[0].HSupID; websLsmain.HExplanation = lsmain[0].HExplanation; websLsmain.HBillType = "1202";//固定值 if (webserver.set_SaveProductInBill_New(websLsmain, sSourceBillType, ref DBUtility.ClsPub.sErrInfo)) @@ -998,6 +1237,133 @@ objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "其他出库单校验成功！单据号为："; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "上传失败！" + DBUtility.ClsPub.sErrInfo; objJsonResult.data = null; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "上传失败！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } /// <summary> /// 生产领料校验 /// </summary> /// <returns></returns> [Route("MateOutBill_Check_New/set_SaveMateOutBill_Check_New_Json")] [HttpPost] public object set_SaveMateOutBill_Check_New_Json([FromBody] JObject oMain) { var _value = oMain["oMain"].ToString(); string msg1 = _value.ToString(); //List<Model.ClsKf_ProductInBillMain> lsmain = new List<Model.ClsKf_ProductInBillMain>(); //ListModels oListModels = new ListModels(); //lsmain = oListModels.getProductInBillMainByJson(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_ProductInBill bll = new BLL.ClsKf_ProductInBill(); //return bll.set_SaveProductInBill_New(lsmain[0], sSourceBillType, ref DBUtility.ClsPub.sErrInfo); try { List<Model.ClsKf_MateOutBillMain> lsmain = new List<Model.ClsKf_MateOutBillMain>(); ListModels oListModels = new ListModels(); lsmain = oListModels.getMateOutBillMainByJson(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; WebAPI.WebS.ClsKf_MateOutBillMain websLsmain = new WebS.ClsKf_MateOutBillMain(); websLsmain.HInterID = lsmain[0].HInterID; websLsmain.HBillNo = lsmain[0].HBillNo; websLsmain.HBillType = "1204"; WebS.WebService1 oWebs = new WebS.WebService1(); if (oWebs.set_SaveMateOutBill_BillCheck(websLsmain, ref DBUtility.ClsPub.sErrInfo)) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "生产领料单校验成功！单据号为："; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "上传失败！" + DBUtility.ClsPub.sErrInfo; objJsonResult.data = null; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "上传失败！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } /// <summary> /// 生产调拨校验 /// </summary> /// <returns></returns> [Route("MoveStockBill_Check_New/set_SaveMoveStockBill_Check_Json")] [HttpPost] public object set_SaveMoveStockBill_Check_Json([FromBody] JObject oMain) { var _value = oMain["oMain"].ToString(); string msg1 = _value.ToString(); //List<Model.ClsKf_ProductInBillMain> lsmain = new List<Model.ClsKf_ProductInBillMain>(); //ListModels oListModels = new ListModels(); //lsmain = oListModels.getProductInBillMainByJson(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_ProductInBill bll = new BLL.ClsKf_ProductInBill(); //return bll.set_SaveProductInBill_New(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; WebAPI.WebS.ClsKf_MoveStockBillMain websLsmain = new WebS.ClsKf_MoveStockBillMain(); websLsmain.HInterID = lsmain[0].HInterID; websLsmain.HBillNo = lsmain[0].HBillNo; websLsmain.HBillType = "1207"; WebS.WebService1 oWebs = new WebS.WebService1(); if (oWebs.set_SaveMoveStockBill_BillCheck(websLsmain, ref DBUtility.ClsPub.sErrInfo)) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "直接调拨单校验成功！单据号为："; objJsonResult.data = null; return objJsonResult; } @@ -1204,6 +1570,92 @@ } /// <summary> /// 条码编辑界面 编辑按钮方法 /// </summary> /// <returns></returns> [Route("Kf_BarCodeEditDlg/GetCheckQtyByBarCodeBill")] [HttpGet] public object GetCheckQtyByBarCodeBill(Int64 HInterID, string HBillType, string sBatchNo,string sBarCode,Int64 sSCWhID ,Int64 sSCSPID, Int64 sAuxPropID,string sMTONo,double iQty,Int64 HMaterID ,Int64 sWhID,Int64 sSPID,Int64 HSourceInterID,Int64 HSourceEntryID, double EndQty, double sQty) { try { if (sBatchNo == null) { sBatchNo = ""; } if (sMTONo == null) { sMTONo = ""; } if ( HBillType == "1204" || HBillType == "1205" || HBillType == "1206" || HBillType == "1211" || HBillType == "1213") { WebS.WebService1 oWebs = new WebS.WebService1(); if (webserver.Get_CheckQtyByBarCode(sBarCode, sWhID, sSPID, sAuxPropID, sBatchNo, sMTONo, iQty, ref sRelQty)) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "库存足够！"; objJsonResult.data = null; return objJsonResult; } else if (sRelQty == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无库存！"; objJsonResult.data = null; return objJsonResult; } else { EndQty = sRelQty - sQty; objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "库存不足，已获取实际库存数量！"; objJsonResult.data = null; return objJsonResult; } } else if (HBillType == "1203" || HBillType == "1205" || HBillType == "1202") { WebS.WebService1 oWebs = new WebS.WebService1(); if (oWebs.set_SavePonderationBillMain_Temp_ChangGui(HInterID, HMaterID, sAuxPropID, sMTONo, sWhID, sSPID, sSCWhID, sSCSPID, sBatchNo, HSourceInterID, HSourceEntryID, sBarCode, HBillType, EndQty, ref DBUtility.ClsPub.sErrInfo)) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "调整成功"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "调整失败" + DBUtility.ClsPub.sErrInfo; objJsonResult.data = null; return objJsonResult; } } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } } }
