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", ""))));
}
}
