protected void Page_Load(object sender, EventArgs e)
{
string PO = "";
// Get our current Vendor #
VendorList = DataClass.GetVendorList();
lblVendorList.Text = VendorList.ToString();
// Check Query Strings
if (Request.QueryString["PO"] != null)
{
PO = Request.QueryString["PO"];
}
if (!IsPostBack)
{
#if DEBUG
#else
IronPdf.License.LicenseKey = "IRONPDF-1279607F8E-533141-55638E-E43834FE2B-E70C669F-UExAE84B49B1D649D8-GLOBALINDUSTRIES.IRO200713.6800.41122.PRO.1DEV.1YR.SUPPORTED.UNTIL.14.JUL.2021";
#endif
// if (!IronPdf.License.IsValidLicense("IRONPDF-1279607F8E-533141-55638E-E43834FE2B-E70C669F-UExAE84B49B1D649D8-GLOBALINDUSTRIES.IRO200713.6800.41122.PRO.1DEV.1YR.SUPPORTED.UNTIL.14.JUL.2021"))
if (!IronPdf.License.IsLicensed)
{
lblMessage.Text = "License error with PDF Add-in.";
}
txtSearch.Text = "";
if (PO.Length > 0)
{
txtSearch.Text = PO;
ReadHeader(PO);
}
sdsDetail.SelectCommand = string.Concat("Select * from SL_Detail where LineType in ('H', 'I') and (Vendor=", VendorList, ") and PO='", txtSearch.Text.Trim(), "' order by Line");
sdsDetail.Select(DataSourceSelectArguments.Empty);
gvItems.DataBind();
CheckReady();
}
else
{
lblMessage.Text = "";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string PO = "";
VendorList = DataClass.GetVendorList();
// Check Query Strings
if (Request.QueryString["PO"] != null)
{
PO = Request.QueryString["PO"];
}
else
{
lblMessage.Text = "Missing PO #";
return;
}
// Update the return to main screen hyperlink
hlPOByItem.NavigateUrl = string.Concat("./Default.aspx?PO=", PO);
LastSN = 0;
if (!IsPostBack)
{
// Populate header fields
lblPO.Text = PO;
//sdsLabels.SelectCommand = string.Concat("SELECT SL_Labels.LabelSN, SL_Labels.SkidSN, SL_Labels.PackingSeq, SL_Labels.PO, SL_Labels.Description, SL_Labels.Seq, SL_Labels.Skid, SL_Labels.Carton, SL_Labels.Status, SL_Labels.PrintStatus, SL_Labels.Line, SL_Packing.Component, SL_Packing.Item, SL_Packing.ShipQty, SL_Packing.BOMQty FROM SL_Labels FULL OUTER JOIN SL_Packing ON SL_Labels.PackingSeq = SL_Packing.Seq WHERE((SL_Labels.Vendor=", VendorList, ") and SL_Labels.PO = '", lblPO.Text, "') ORDER BY SL_Labels.LabelSN");
//gvLabels.DataBind();
// Check if this item has components
sdsPrinting.SelectCommand = string.Concat("SELECT SL_Packing.PO, SL_Packing.Line, SL_Packing.Seq, SL_Packing.ShipQty, SL_Packing.BOMQty, SL_Packing.Item, SL_Packing.Component, SL_Labels.Description, SL_Labels.Carton, SL_Labels.BulkCarton, SL_Labels.Skid, SL_Labels.LabelSN, SL_Labels.BulkSN, SL_Labels.SkidSN, SL_Labels.PackingSeq, SL_Labels.Status, SL_Labels.PrintStatus FROM SL_Packing FULL OUTER JOIN SL_Labels ON SL_Packing.Vendor = SL_Labels.Vendor and SL_Packing.PO = SL_Labels.PO and SL_Packing.Line = SL_Labels.Line and SL_Packing.Carton = SL_Labels.Carton WHERE (SL_Labels.Vendor=", VendorList, ") and SL_Labels.PO='", lblPO.Text, "' ORDER BY Line,Carton");
// sdsPrinting.SelectCommand = string.Concat("SELECT SL_Labels.LabelSN, SL_Labels.SkidSN, SL_Labels.PackingSeq, SL_Labels.PO, SL_Labels.Description, SL_Labels.Seq, SL_Labels.Skid, SL_Labels.Carton, SL_Labels.Status, SL_Labels.PrintStatus, SL_Packing.Line, SL_Packing.Component, SL_Packing.Item, SL_Packing.ShipQty, SL_Packing.BOMQty FROM SL_Labels FULL OUTER JOIN SL_Packing ON SL_Labels.PackingSeq = SL_Packing.Seq WHERE((SL_Labels.Vendor=", VendorList, ") and SL_Labels.PO = '", lblPO.Text, "') ORDER BY SL_Labels.Seq");
gvPrinting.DataBind();
// lbPrintAll.OnClientClick = string.Concat("PrintLabel(null, ", gvLabels.Rows.Count,");");
// hlPOByItem.NavigateUrl = string.Concat("/Default.aspx?PO=", PO);
}
else
{
lblMessage.Text = "";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string PO = "";
string Line = "";
string Item = "";
string Qty = "0";
VendorList = DataClass.GetVendorList();
// Check Query Strings
if (Request.QueryString["PO"] != null)
{
PO = Request.QueryString["PO"];
}
else
{
lblMessage.Text = "Missing PO #";
return;
}
if (Request.QueryString["Line"] != null)
{
Line = Request.QueryString["Line"];
}
else
{
// lblMessage.Text = "Missing Line #";
// return;
}
if (!IsPostBack)
{
// Populate header fields
lblPO.Text = PO;
lblLineNo.Text = Line;
// Are we packing a specific line?
if (Line.Trim() == "")
{
sdsPacking.SelectCommand = string.Concat("SELECT SL_Detail.PO, SL_Detail.Line, SL_Detail.Item, SL_Detail.Description, SL_Detail.ShipQty, SL_Packing.Carton, SL_Packing.BulkCarton, SL_Packing.Skid FROM SL_Packing INNER JOIN SL_Detail ON SL_Packing.Vendor = SL_Detail.Vendor and SL_Packing.PO = SL_Detail.PO AND SL_Packing.Line = SL_Detail.Line WHERE (SL_Detail.LineType = 'I') and (SL_Detail.PO='", PO, "') GROUP BY SL_Detail.PO, SL_Detail.Line, SL_Detail.Item, SL_Detail.ShipQty, SL_Detail.Description, SL_Packing.Carton, SL_Packing.BulkCarton, SL_Packing.Skid order by SL_Packing.Carton");
}
else
{
sdsPacking.SelectCommand = string.Concat("SELECT SL_Detail.PO, SL_Detail.Line, SL_Detail.Item, SL_Detail.Description, SL_Detail.ShipQty, SL_Packing.Carton, SL_Packing.BulkCarton, SL_Packing.Skid FROM SL_Packing INNER JOIN SL_Detail ON SL_Packing.Vendor = SL_Detail.Vendor and SL_Packing.PO = SL_Detail.PO AND SL_Packing.Line = SL_Detail.Line WHERE (SL_Detail.LineType = 'I') and (SL_Detail.PO='", PO, "') and (SL_Detail.Line='", Line, "') GROUP BY SL_Detail.PO, SL_Detail.Line, SL_Detail.Item, SL_Detail.ShipQty, SL_Detail.Description, SL_Packing.Carton, SL_Packing.BulkCarton, SL_Packing.Skid order by SL_Packing.Carton");
}
// Check if this item has components
// sdsPacking.SelectCommand = string.Concat("SELECT SL_Detail.PO, SL_Detail.Line, SL_Detail.Item, SL_Detail.Description, SL_Detail.ShipQty, SL_Packing.Carton, SL_Packing.BulkCarton, SL_Packing.Skid FROM SL_Packing INNER JOIN SL_Detail ON SL_Packing.Vendor = SL_Detail.Vendor and SL_Packing.PO = SL_Detail.PO AND SL_Packing.Line = SL_Detail.Line WHERE (SL_Detail.LineType = 'I') and (SL_Detail.PO='", PO, "') and (SL_Detail.Line='", Line, "') GROUP BY SL_Detail.PO, SL_Detail.Line, SL_Detail.Item, SL_Detail.ShipQty, SL_Detail.Description, SL_Packing.Carton, SL_Packing.BulkCarton, SL_Packing.Skid order by SL_Packing.Carton");
DataView dv = (DataView)sdsPacking.Select(DataSourceSelectArguments.Empty);
if (dv.Count != 0)
{
}
else
{
lblMessage.Text = "No packing information found.";
}
gvPacking.DataBind();
hlComponents.NavigateUrl = string.Concat("./Components.aspx?PO=", PO, "&Line=", Line);
hlPOByItem.NavigateUrl = string.Concat("./Default.aspx?PO=", PO);
}
else
{
// Make sure select command is up to date
// Are we packing a specific line?
if (Line.Trim() == "")
{
sdsPacking.SelectCommand = string.Concat("SELECT SL_Detail.PO, SL_Detail.Line, SL_Detail.Item, SL_Detail.Description, SL_Detail.ShipQty, SL_Packing.Carton, SL_Packing.BulkCarton, SL_Packing.Skid FROM SL_Packing INNER JOIN SL_Detail ON SL_Packing.Vendor = SL_Detail.Vendor and SL_Packing.PO = SL_Detail.PO AND SL_Packing.Line = SL_Detail.Line WHERE (SL_Detail.LineType = 'I') and (SL_Detail.PO='", PO, "') GROUP BY SL_Detail.PO, SL_Detail.Line, SL_Detail.Item, SL_Detail.ShipQty, SL_Detail.Description, SL_Packing.Carton, SL_Packing.BulkCarton, SL_Packing.Skid order by SL_Packing.Carton");
}
else
{
sdsPacking.SelectCommand = string.Concat("SELECT SL_Detail.PO, SL_Detail.Line, SL_Detail.Item, SL_Detail.Description, SL_Detail.ShipQty, SL_Packing.Carton, SL_Packing.BulkCarton, SL_Packing.Skid FROM SL_Packing INNER JOIN SL_Detail ON SL_Packing.Vendor = SL_Detail.Vendor and SL_Packing.PO = SL_Detail.PO AND SL_Packing.Line = SL_Detail.Line WHERE (SL_Detail.LineType = 'I') and (SL_Detail.PO='", PO, "') and (SL_Detail.Line='", Line, "') GROUP BY SL_Detail.PO, SL_Detail.Line, SL_Detail.Item, SL_Detail.ShipQty, SL_Detail.Description, SL_Packing.Carton, SL_Packing.BulkCarton, SL_Packing.Skid order by SL_Packing.Carton");
}
// sdsPacking.SelectCommand = string.Concat("SELECT SL_Detail.PO, SL_Detail.Line, SL_Detail.Item, SL_Detail.Description, SL_Detail.ShipQty, SL_Packing.Carton, SL_Packing.BulkCarton, SL_Packing.Skid FROM SL_Packing INNER JOIN SL_Detail ON SL_Packing.Vendor = SL_Detail.Vendor and SL_Packing.PO = SL_Detail.PO AND SL_Packing.Line = SL_Detail.Line WHERE (SL_Detail.LineType = 'I') and (SL_Detail.PO='", lblPO.Text, "') and (SL_Detail.Line='", lblLineNo.Text, "') GROUP BY SL_Detail.PO, SL_Detail.Line, SL_Detail.Item, SL_Detail.ShipQty, SL_Detail.Description, SL_Packing.Carton, SL_Packing.BulkCarton, SL_Packing.Skid order by SL_Packing.Carton");
lblMessage.Text = "";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string PO = "";
string Line = "";
string Item = "";
int Qty = 0;
VendorList = DataClass.GetVendorList();
// Check Query Strings
if (Request.QueryString["PO"] != null)
{
PO = Request.QueryString["PO"];
}
else
{
lblMessage.Text = "Missing PO #";
return;
}
if (Request.QueryString["Line"] != null)
{
Line = Request.QueryString["Line"];
}
else
{
lblMessage.Text = "Missing Line #";
return;
}
if (!IsPostBack)
{
DataClass.GetLineInfo(PO, Line, ref Item, ref Qty);
// Populate header fields
lblPO.Text = PO;
lblLineNo.Text = Line;
lblItemNo.Text = Item;
lblPOQty.Text = Qty.ToString();
ShowNextCarton();
// If we are looking at a component line, select the components for display
if (DataClass.CheckComponents(Item))
{
lblItemType.Text = "C";
// Added LineType 'W' 3/8/2020 for WriteIns
gvPacking.Columns[2].Visible = false;
gvPacking.Columns[3].Visible = true;
lbWriteIn.Visible = true;
}
else
{
lblItemType.Text = "I";
gvPacking.Columns[2].Visible = true;
gvPacking.Columns[3].Visible = false;
lbWriteIn.Visible = false;
}
SetupSelect();
lblCalcCartons.Text = "0";
gvPacking.DataBind();
hlPOByItem.NavigateUrl = string.Concat("./Default.aspx?PO=", PO);
hlPOBySkid.NavigateUrl = string.Concat("./LinePacking.aspx?PO=", PO, "&Line=", Line);
}
else
{
lblMessage.Text = "";
SetupSelect();
}
}