private string ScanningInsert(HttpContext context) { try { string OUTNUMBER = context.Request["OUTNUMBER"] as string; string BARCODE = context.Request["BARCODE"] as string; string ENAM = context.Request["ENAM"] as string; string LOGINNAM = context.Request["LOGINNAM"] as string; if (!dal.BarcodeExist(BARCODE.Trim())) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "该条码信息的轮胎不在库存中!"))); } if (!dal.CheckBarcode(OUTNUMBER.Trim(), BARCODE.Trim())) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "该条码信息的轮胎已经扫描过!"))); } if (!dal.CheckUserBarcode(BARCODE.Trim())) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "该条码信息的轮胎已经被别人扫描过!"))); } STC0025 stc0025 = dal.GetByModel(OUTNUMBER.Trim()); QMB0101 qmb0101 = new QMB0101Dal().GetByModel(BARCODE.Trim()); //检查扫描的规格是否和SAP发货规格相同 DataTable dt = dal.GetDetailedList(OUTNUMBER.Trim()); int countNum = (int)dt.Compute("Count(*)", string.Format(@"ITNBR='{0}'", qmb0101.ITNBR)); ComUtilDal.SqlRecord(countNum.ToString()); if (0 == countNum) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "扫描的轮胎规格和SAP出库单规格不符!"))); } //END if ("1" == stc0025.DIV) { if ("1" != qmb0101.QCSTATE) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "合格品出库单不能扫描出库废次品轮胎!"))); } } else { if ("1" == qmb0101.QCSTATE) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "废次品出库单不能扫描出库合格品轮胎!"))); } } if (dal.ScanningInsert(OUTNUMBER.Trim(), BARCODE.Trim(), ENAM.Trim(), LOGINNAM.Trim())) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("0", xml.ReadLandXml("0")))); } else { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("1", xml.ReadLandXml("1")))); } } catch (Exception ex) { SystemErrorPlug.ErrorRecord(ex.ToString()); return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("500", ex.Message.ToString().Trim().Replace("\r\n", "")))); } }
/// <summary> /// /// </summary> /// <param name="context"></param> /// <returns></returns> private string ScanningInsert(HttpContext context) { try { string _BARCODE = context.Request["BARCODE"] as string; string _RefundNUM = context.Request["RefundNUM"] as string; string _ENAM = context.Request["ENAM"] as string; string _LOGINNAME = context.Request["LOGINNAME"] as string; if (!dal.CheckUserBarcode(_BARCODE)) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "改条码信息的轮胎正在扫描退库中!"))); } if (dal.ExistStock(_BARCODE)) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "改条码信息的轮胎已经在库存中!"))); } QMB0101 qmb0101 = new QMB0101Dal().GetByModel(_BARCODE.Trim()); STC0028 stc0028 = new STC0028 { BARCODE = _BARCODE.Trim(), RefundNUM = _RefundNUM.Trim(), Grade = qmb0101.QCSTATE, ENAM = _ENAM.Trim(), LOGINNAM = _LOGINNAME.Trim(), DBRES = qmb0101.DBRES }; if (dal.ScanningInsert(stc0028)) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("0", xml.ReadLandXml("0")))); } else { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("1", xml.ReadLandXml("1")))); } } catch (Exception ex) { SystemErrorPlug.ErrorRecord(ex.ToString()); return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("500", ex.Message.ToString().Trim().Replace("\r\n", "")))); } }
/// <summary> /// 通过条码查询相对应的产品信息 /// </summary> /// <param name="context"></param> /// <returns></returns> private string Create(HttpContext context) { try { string _EqID = context.Request["EqID"].Trim(); string _BARCODE = context.Request["BARCODE"].Trim(); string _LNO = context.Request["LNO"].Trim(); string _Storehouse = context.Request["Storehouse"].Trim(); string _LOGINNAM = context.Request["LOGINNAM"].Trim(); string _ENAM = context.Request["ENAM"].Trim(); string _FAC = context.Request["FAC"].Trim(); //限制只能扫描镂空条码 if (_BARCODE.Length != 11) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("444", "请扫描镂空硫化条码!"))); } //软控货架验证 /*string mess = new MESNACMESDal().GetShelfInfo(_BARCODE); * if (!string.IsNullOrWhiteSpace(mess)) * { * return JsonHelper<Messaging<string>>.EntityToJson(new Messaging<string>("444", mess)); * }*/ //验证软控报警胎 string _alarm = new LogisticsLaunchVerificationDal().ALARM(_BARCODE); if (!string.IsNullOrWhiteSpace(_alarm)) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("444", _alarm))); } //MES综合验证 string strMes = dal.GetScanShelfChecking(_LNO, _BARCODE, _LOGINNAM, _FAC, _ENAM, _Storehouse); if (!string.IsNullOrEmpty(strMes)) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("444", strMes))); } //如果多个货架为空优先使用最新的 string newLNO = dal.GetNewestLnoNum(_EqID.Trim()); if (!string.IsNullOrWhiteSpace(newLNO)) { _LNO = newLNO; } QMB0101 qmb0101 = new QMB0101Dal().GetByModel(_BARCODE); STC0009 stc0009 = dal.GetBySTC0009Model(qmb0101.ITNBR, _EqID, _level); //同一个规格默认装载一个货笼 if (!string.IsNullOrWhiteSpace(stc0009.LNO)) { _LNO = stc0009.LNO; } else { string derLno = dal.GetFirstCargoASC(_EqID); if (!string.IsNullOrEmpty(derLno)) { _LNO = derLno; } } STC0009 stc9 = new STC0009 { BARCODE = qmb0101.BARCODE, DBRES = qmb0101.DBRES, Grade = qmb0101.QCSTATE, ITDSC = qmb0101.ITDSC, ITNBR = qmb0101.ITNBR, LEVEL = _level, LNO = _LNO, LOGINNAM = _LOGINNAM, Storehouse = _Storehouse, TyreNo = qmb0101.TYRENO, EQUIPID = _EqID }; if (dal.Create(stc9)) { dal.DeleteCage(stc9.LNO, stc9.EQUIPID, _level); return(JsonHelper <Messaging <STC0009> > .EntityToJson(new Messaging <STC0009>("0", xml.ReadLandXml("0"), dal.GetDataList(stc9.LNO, stc9.EQUIPID, _level)))); } else { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "轮胎上架货笼失败!"))); } } catch (Exception ex) { SystemErrorPlug.ErrorRecord(ex.ToString()); return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("500", ex.Message.ToString().Trim().Replace("\r\n", "")))); } }
/// <summary> /// 通过条码查询相对应的产品信息 /// </summary> /// <param name="context"></param> /// <returns></returns> private string Create(HttpContext context) { try { string _barcode = context.Request["BARCODE"] as string; string _LNO = context.Request["LNO"] as string; string _Storehouse = context.Request["Storehouse"] as string; string _LOGINNAM = context.Request["LOGINNAM"] as string; string _ENAM = context.Request["ENAM"] as string; string _BARCODE = _barcode.Trim(); string LNO = _LNO.Trim(); string Storehouse = _Storehouse.Trim(); string LOGINNAM = _LOGINNAM.Trim(); string ENAM = _ENAM.Trim(); WIP0010 model = new WIP0010Dal().GetEntityById(_BARCODE); if (string.IsNullOrEmpty(model.BARCODE)) { //扫描异常轮胎报警 //dal.CallPolice(_BARCODE, ENAM, LOGINNAM, Storehouse); return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "该条码信息的轮胎不在车间库存中!"))); } if (dal.CheckSTC0017BarCode(model.BARCODE.Trim()) > 0) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "该条码已经扫描上架!"))); } if (dal.CheckUpCage17(LNO) > 0) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "货笼已经使用!"))); } if (model.LOCKYN == "Y") { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "该条码信息的轮胎在库存中已经锁定!"))); } if (model.STA != "1") { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "该条码信息的轮胎在库存中处于、不良、保留或者报废状态!"))); } QMB0101 qmb0101 = new QMB0101Dal().GetByModel(model.BARCODE); if (qmb0101.QCSTATE.Trim() == "1") { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "该条码信息的轮胎是合格品,无法上架操作!"))); } int barCodeCount = dal.GetBarCodeCount(model.BARCODE); if (barCodeCount > 0) { STC0009 stc09 = dal.GetBySTC0009(model.BARCODE, LOGINNAM, _level); return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "该条码信息的轮胎已经在[" + stc09.LNO + "]货架上!"))); } int count = dal.GetCount(LNO, model.ITNBR, "", _level); int num = dal.GetCargoCageQuantity(model.ITNBR); if (0 != num) { if (count > num) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "该货笼已经达到最大装胎数量,无法在装笼操作!"))); } } else { num = 30; if ("03" == model.FAC || "01" == model.FAC) { num = 9; } if (count > num) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "该货笼已经达到最大装胎数量,无法在装笼操作!"))); } } STC0009 stc9 = new STC0009 { BARCODE = model.BARCODE, DBRES = qmb0101.DBRES, Grade = qmb0101.QCSTATE, ITDSC = model.ITDSC, ITNBR = model.ITNBR, LEVEL = _level, LNO = LNO, LOGINNAM = LOGINNAM, Storehouse = Storehouse, TyreNo = qmb0101.TYRENO, QRCode = "", RfidCode = "" }; if (dal.Create(stc9)) { dal.DeleteCage(stc9.LNO, stc9.LOGINNAM, _level); return(JsonHelper <Messaging <STC0009> > .EntityToJson(new Messaging <STC0009>("0", xml.ReadLandXml("0"), dal.GetDataList(LNO, LOGINNAM, _level)))); } else { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "轮胎上架货笼失败!"))); } } catch (Exception ex) { SystemErrorPlug.ErrorRecord(ex.ToString()); return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("500", ex.Message.ToString().Trim().Replace("\r\n", "")))); } }
private string ScanningInsert(HttpContext context) { try { string _putstornum = context.Request["PN"] as string; string _barcode = context.Request["BARCODE"] as string; string _reservoirarea = context.Request["Reservoirarea"] as string; string _warehouselocation = context.Request["Warehouselocation"] as string; string _enam = context.Request["ENAM"] as string; string _loginnam = context.Request["LOGINNAM"] as string; //------------------------------------------------------------------------------------- string _putstorNUM = _putstornum.Trim(); string _BARCODE = _barcode.Trim(); string _Reservoirarea = _reservoirarea.Trim(); string _Warehouselocation = _warehouselocation.Trim(); string _ENAM = _enam.Trim(); string _LOGINNAM = _loginnam.Trim(); WIP0010 model = new WIP0010Dal().GetEntityById(_BARCODE); if (model.LOCKYN == "Y") { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "该条码信息的轮胎在库存中已经锁定!"))); } if (model.STA != "1") { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "该条码信息的轮胎在库存中处于不良、保留或者报废状态!"))); } if (string.IsNullOrEmpty(model.BARCODE)) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "该条码信息的轮胎不在车间库存中!"))); } string _itnbr = dal.VerifySpecificationUniqueness(_putstorNUM); if (!string.IsNullOrEmpty(_itnbr)) { if (_itnbr != model.ITNBR) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "同一个入库单不能装两种规格的轮胎!"))); } } if (!dal.ExistCheck(_BARCODE, _putstorNUM)) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "该条码信息的轮胎已经扫描过!"))); } if (!dal.QueryCheck(_BARCODE)) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "该条码信息的轮胎已经被别人扫描过!"))); } STC0022 stc0022 = dal.GetByModel(_putstorNUM); QMB0101 qmb0101 = new QMB0101Dal().GetByModel(_BARCODE); if ("1" == stc0022.TYPE) { if ("1" != qmb0101.QCSTATE) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "合格品入库单不能扫描入库废次品轮胎!"))); } } else { if ("1" == qmb0101.QCSTATE) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("2", "废次品入库单不能扫描入库合格品轮胎!"))); } } STC0023 stc0023 = new STC0023 { BARCODE = _BARCODE.Trim(), putstorNUM = _putstorNUM.Trim(), Grade = qmb0101.QCSTATE, Reservoirarea = _Reservoirarea.Trim(), Warehouselocation = _Warehouselocation.Trim(), ENAM = _ENAM.Trim(), LOGINNAM = _LOGINNAM.Trim(), DBRES = qmb0101.DBRES }; if (dal.ScanningInsert(stc0023)) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("0", xml.ReadLandXml("0")))); } else { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("1", xml.ReadLandXml("1")))); } } catch (Exception ex) { SystemErrorPlug.ErrorRecord(ex.ToString()); return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("500", ex.Message.ToString().Trim().Replace("\r\n", "")))); } }