| | |
| | | /// <returns></returns> |
| | | [Route("MoveStockBill/get_InfoByBarCode_Source_Json")] |
| | | [HttpGet] |
| | | public object get_InfoByBarCode_Source_Json(string sCode, Int64 sInterID, string sBillNo, Double sQty, Int64 HWHID, Int64 HSPID, Int64 SCWhID, Int64 SCSPID) |
| | | public object get_InfoByBarCode_Source_Json(string sCode, Int64 sInterID, string sBillNo, Double sQty, Int64 HWHID, Int64 HSPID, Int64 SCWhID, Int64 SCSPID, string HMaker, Int64 HOrgID) |
| | | { |
| | | try |
| | | { |
| | |
| | | dal.GetInfoByNumber_View(sCode); |
| | | if (dal.omodel_View.HBarCodeType != "托盘条码") |
| | | { |
| | | return get_InfoByBarCode_Source_Json_s(sCode, sInterID, sBillNo, sQty, HWHID, HSPID, SCWhID, SCSPID); |
| | | return get_InfoByBarCode_Source_Json_s(sCode, sInterID, sBillNo, sQty, HWHID, HSPID, SCWhID, SCSPID, HMaker, HOrgID); |
| | | } |
| | | else |
| | | { |
| | |
| | | for (int i = 0; i < dsTBarCode.Tables[0].Rows.Count; i++) |
| | | { |
| | | sBarCode_MX = DBUtility.ClsPub.isStrNull(dsTBarCode.Tables[0].Rows[i]["HBarCodeMX"]); |
| | | objJsonResult = (JsonResult)get_InfoByBarCode_Source_Json_s(sBarCode_MX, sInterID, sBillNo, sQty, HWHID, HSPID, SCWhID, SCSPID); |
| | | objJsonResult = (JsonResult)get_InfoByBarCode_Source_Json_s(sBarCode_MX, sInterID, sBillNo, sQty, HWHID, HSPID, SCWhID, SCSPID, HMaker,HOrgID); |
| | | if (objJsonResult.code == "0") |
| | | { |
| | | return objJsonResult; |
| | |
| | | } |
| | | } |
| | | |
| | | public object get_InfoByBarCode_Source_Json_s(string sCode, Int64 sInterID, string sBillNo, Double sQty, Int64 HWHID, Int64 HSPID, Int64 SCWhID, Int64 SCSPID) |
| | | public object get_InfoByBarCode_Source_Json_s(string sCode, Int64 sInterID, string sBillNo, Double sQty, Int64 HWHID, Int64 HSPID, Int64 SCWhID, Int64 SCSPID, string HMaker,Int64 HOrgID) |
| | | { |
| | | try |
| | | { |
| | |
| | | model.HInterID = DBUtility.ClsPub.isLong(sInterID); |
| | | model.HBillNo = DBUtility.ClsPub.isStrNull(sBillNo); |
| | | model.HBillType = this.HBillType; |
| | | model.HMaker = DBUtility.ClsPub.CurUserName; |
| | | model.HMaker = HMaker; |
| | | // |
| | | model.HMaterID = oView.HMaterID; |
| | | model.HAuxPropID = oView.HAuxPropID; |
| | |
| | | model.HBarCode = oView.HBarCode; |
| | | model.HBatchNo = oView.HBatchNo; |
| | | model.HMTONo = oView.HMTONo; |
| | | model.HMaker = oView.HMaker; |
| | | |
| | | model.HWhID = DBUtility.ClsPub.isLong(HWHID); |
| | | model.HStockPlaceID = DBUtility.ClsPub.isLong(HSPID); |
| | |
| | | model.HSourceBillType = oView.HSourceBillType; |
| | | model.HRedBlueFlag = false; |
| | | model.HPieceQty = 1; |
| | | //model.HSTOCKORGID = DBUtility.ClsPub.HORGANIZATIONSID; |
| | | //model.HOWNERID = DBUtility.ClsPub.HORGANIZATIONSID; |
| | | model.HSTOCKORGID = HOrgID; |
| | | model.HOWNERID = HOrgID; |
| | | |
| | | WebS.WebService1 oWebs = new WebS.WebService1(); |
| | | //if (webserver.set_SavePonderationBillMain_Temp_Qty(model, sQty, ref DBUtility.ClsPub.sErrInfo)) |
| | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "2-无库存!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "2-库存不足!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | websLsmain.HStockStyle = ""; |
| | | websLsmain.HBillType = "1207"; |
| | | websLsmain.HSupID = 0; |
| | | websLsmain.HGroupID = lsmain[0].HGroupID; |
| | | //websLsmain.HGroupID = lsmain[0].HGroupID; |
| | | |
| | | if (webserver.set_SaveMoveStockBill(websLsmain, "-1", ref DBUtility.ClsPub.sErrInfo)) |
| | | { |
| | |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 生成分布式调出单 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("MoveStockStepOutBill/set_SaveMoveStockStepOutBill_Json")] |
| | | [HttpPost] |
| | | public object set_SaveMoveStockStepOutBill_Json([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_MoveStockStepOutBillMain> lsmain = new List<Model.ClsKf_MoveStockStepOutBillMain>(); |
| | | ListModels oListModels = new ListModels(); |
| | | lsmain = oListModels.getMoveStockStepOutBillMainByJson(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_MoveStockStepOutBillMain websLsmain = new WebS.ClsKf_MoveStockStepOutBillMain(); |
| | | 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 = "1250"; |
| | | websLsmain.HSupID = 0; |
| | | //websLsmain.HGroupID = lsmain[0].HGroupID; |
| | | |
| | | if (webserver.set_MoveStockStepOutBill(websLsmain, "-1", ref DBUtility.ClsPub.sErrInfo)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "生成调拨单成功!单据号为:"; |
| | | 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> |
| | |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 写入临时表 扫源单的方法 |
| | | /// </summary> |
| | | /// <param name="HSourceBillNo"></param> |
| | | /// <returns></returns> |
| | | [Route("MoveStockStepOutBill/set_sourcebill")] |
| | | [HttpGet] |
| | | public object set_sourcebill(string HSourceBillType, string HSourceBillNo, Int64 sInterID, string sBillNo) |
| | | { |
| | | try |
| | | { |
| | | // DataSet ds = new DataSet(); |
| | | // WebServer webserver = new WebServer(); |
| | | string sWhere = " Where 单据号 like '%" + HSourceBillNo.Trim() + "%'"; |
| | | ds = webserver.GetXs_SeOutStockBillList(sWhere); |
| | | 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 |
| | | { |
| | | //HSupID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HSupID"]); |
| | | //HSupName = Convert.ToString(ds.Tables[0].Rows[0]["HSupName"]); |
| | | HDeptID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HDeptID"]); |
| | | HDeptName = Convert.ToString(ds.Tables[0].Rows[0]["HDeptName"]); |
| | | if (webserver.set_SavePonderationBillMain_Temp_Source_Fast(sInterID, sBillNo, HBillType, HSourceBillNo, HSourceBillType, "蓝字", 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 ex) |
| | | { |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没有返回任何记录!" + ex.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 分布式调出单扫码/扫条码/直接调用webservice |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("MoveStockStepOutBill/get_CheckTypeByBarCode_Json")] |
| | | [HttpGet] |
| | | public Object get_CheckTypeByBarCode_Json(string sCode, Int64 sInterID, string sBillNo, string sBillType, string sMaker, Int64 WhID, Int64 SPID, Double sQty, bool sRedBlue, bool SourceFlag, string sSourceBillNo, string sSourceType, 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_CheckTypeByBarCode_All(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, sExpressNumber, 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; |
| | | } |
| | | } |
| | | |
| | | |
| | | //删除记录 |
| | | [Route("MoveStock/Delete_Json")] |
| | | [HttpGet] |