private string ReturnSelModel(HttpContext context) { try { string _tyreno = context.Request["TYRENO"].Trim(); DataTable dt = dal.GetModel(_tyreno); if (dt == null) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("444", "未查询到成品胎入库的信息!"))); } else { WIP0010 wip0010 = new WIP0010Dal().GetEntityById(_tyreno); if (!string.IsNullOrEmpty(wip0010.TYRENO)) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("444", "成品胎已经退回本地库,请勿重复操作!"))); } else { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("0", xml.ReadLandXml("0"), dt))); } } } 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 GetUpdateVulBarcodeChange(HttpContext context) { try { string oldCode = context.Request["oldCode"].Trim(); string newCode = context.Request["newCode"].Trim(); string name = context.Request["name"].Trim(); string login = context.Request["login"].Trim(); string barcode = context.Request["barcode"].Trim(); WIP0010 wip0010 = new WIP0010Dal().GetEntityById(oldCode); if (wip0010.STA == "4") { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("1", xml.ReadLandXml("5")))); } if (wip0010.LOCKYN == "Y") { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("1", xml.ReadLandXml("4")))); } if (dal.GetUpdateVulBarcodeChange(oldCode, newCode, name, login, barcode) > 0) { 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", "")))); } }
private string AddCargoCage(HttpContext context) { try { string _warehousereceipt = context.Request["wh"].Trim(); string _TYRENO = context.Request["TYRENO"].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 (string.IsNullOrEmpty(_Storehouse)) { _Storehouse = dal.CheckSTC0044_WareHouse(_warehousereceipt); } //验证软控报警胎 string _alarm = new LogisticsLaunchVerificationDal().ALARM(_TYRENO); if (!string.IsNullOrWhiteSpace(_alarm)) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("444", _alarm))); } //MES综合验证 string strMes = dal.GetScanLocalWarehousChecking(_TYRENO, _LOGINNAM, _FAC, _ENAM, _Storehouse); if (!string.IsNullOrEmpty(strMes)) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("444", strMes))); } STC0045 stc0045 = dal.GetSTC0045_ITNBR(_warehousereceipt); if (!string.IsNullOrEmpty(stc0045.ITNBR)) { WIP0010 wip0010 = new WIP0010Dal().GetEntityById(_TYRENO); if (!stc0045.ITNBR.Equals(wip0010.ITNBR)) { string mess = "此轮胎规格[{0}]与当前货架轮胎规格[{1}]不同,不允许入本地库!"; return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("444", string.Format(mess, wip0010.ITDSC, stc0045.ITDSC)))); } } if (dal.AddCargoCage(_warehousereceipt, _TYRENO, _Storehouse, _LOGINNAM, _ENAM)) { return(JsonHelper <Messaging <string> > .EntityToJson(new Messaging <string>("0", "入库完成!", dal.GetSubList(_warehousereceipt)))); } 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 _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", "")))); } }