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(); } }