public static EntidadZones VerificarZoneCodenw(string ZONE)
{
string strError = string.Empty;
DataTable DTZoneCode = twhcol130DAL.VerificarZoneCode(ref ZONE);
EntidadZones ObjZone = new EntidadZones();
if (DTZoneCode.Rows.Count > 0)
{
ObjZone.CWAR = DTZoneCode.Rows[0]["T$CWAR"].ToString();
ObjZone.ZONE = DTZoneCode.Rows[0]["T$ZONE"].ToString();
ObjZone.DSCA = DTZoneCode.Rows[0]["T$DSCA"].ToString();
ObjZone.BALL = DTZoneCode.Rows[0]["T$BALL"].ToString();
ObjZone.BINB = DTZoneCode.Rows[0]["T$BINB"].ToString();
ObjZone.BOUT = DTZoneCode.Rows[0]["T$BOUT"].ToString();
ObjZone.BTRR = DTZoneCode.Rows[0]["T$BTRR"].ToString();
ObjZone.BTRI = DTZoneCode.Rows[0]["T$BTRI"].ToString();
ObjZone.BASS = DTZoneCode.Rows[0]["T$BASS"].ToString();
ObjZone.EMNO = DTZoneCode.Rows[0]["T$EMNO"].ToString();
ObjZone.PRTR = DTZoneCode.Rows[0]["T$PRTR"].ToString();
ObjZone.SLOC = DTZoneCode.Rows[0]["T$SLOC"].ToString();
ObjZone.DSCAW = DTZoneCode.Rows[0]["T$DSCA1"].ToString();
//PDNO, SQNB, MITM, DSCA, CUNI, QTDL, DELE, PRO1, PROC
ObjZone.error = false;
}
else
{
ObjZone.error = true;
ObjZone.typeMsgJs = "label";
ObjZone.errorMsg = Zonecodedoesntexist;
}
return(ObjZone);
}
public static string VerificarPalletID(string PAID, string ZONE)
{
EntidadZones ObjZone = VerificarZoneCodenw(ZONE);
string strError = string.Empty;
PAID = PAID.ToUpper();
DataTable DTPalletID = twhcol130DAL.VerificarPalletIDz(ref PAID);
EntidadPicking ObjPicking = new EntidadPicking();
if (DTPalletID.Rows.Count > 0)
{
ObjPicking.PALLETID = DTPalletID.Rows[0]["PAID"].ToString();
ObjPicking.ITEM = DTPalletID.Rows[0]["ITEM"].ToString();
ObjPicking.DESCRIPTION = DTPalletID.Rows[0]["DSCA"].ToString();
ObjPicking.LOT = DTPalletID.Rows[0]["CLOT"].ToString().Trim();
using (ObjZone)
{
ObjPicking.WRH = ObjZone.CWAR;
ObjPicking.DESCWRH = ObjZone.DSCAW;
PCWAR = ObjZone.CWAR;
PSLOC = ObjZone.SLOC;
}
//if (PCWAR != "")
//{
// ObjPicking.WRH = PCWAR;
// ObjPicking.DESCWRH = PDSCAW;
//}
//else
//{
// ObjPicking.WRH = DTPalletID.Rows[0]["CWAT"].ToString().Trim();
// ObjPicking.DESCWRH = DTPalletID.Rows[0]["DESCAW"].ToString();
//}
ObjPicking.LOCA = DTPalletID.Rows[0]["ACLO"].ToString().Trim();
ObjPicking.QTY = DTPalletID.Rows[0]["QTYT"].ToString();
ObjPicking.UN = DTPalletID.Rows[0]["UNIT"].ToString();
ObjPicking.STAT = DTPalletID.Rows[0]["STAT"].ToString();
if (DTPalletID.Rows[0]["SLOC"].ToString() == "")
{
ObjPicking.SLOC = PSLOC;
}
else
{
ObjPicking.SLOC = DTPalletID.Rows[0]["SLOC"].ToString();
}
//PDNO, SQNB, MITM, DSCA, CUNI, QTDL, DELE, PRO1, PROC
ObjPicking.KLTC = DTPalletID.Rows[0]["KLTC"].ToString();
ObjPicking.error = false;
//if (DTPalletID.Rows[0]["STAT"].ToString() != "7")
//{
// ObjPicking.error = true;
// ObjPicking.typeMsgJs = "label";
// ObjPicking.errorMsg = "Pallet ID doesn´t exist";
//}
}
else
{
ObjPicking.error = true;
ObjPicking.typeMsgJs = "label";
ObjPicking.errorMsg = ThepaletteIDdoesnotexistorisnotlocated;
}
return(JsonConvert.SerializeObject(ObjPicking));
}