public LoadTenderDetailDataset GetLoadTenderDetails(string loadNumber) { //Get load tender details LoadTenderDetailDataset lts = null; try { lts = new LoadTenderDetailDataset(); DataSet ds = new DataService().FillDataset(SQL_CONNID, USP_LOADTENDERDETAILS, TBL_LOADTENDERDETAILS, new object[] { loadNumber }); if (ds != null && ds.Tables[TBL_LOADTENDERDETAILS].Rows.Count > 0) { lts.Merge(ds); } } catch (Exception ex) { throw new ApplicationException(ex.Message); } return(lts); }
//Members //Interface protected void Page_Load(object sender, EventArgs e) { //Event handler for form load event Response.Write("<html>"); Response.Write("<head runat='server'>"); Response.Write("<title>Load Tender Detail</title>"); Response.Write("<style> HR { page-break-after: always; } </style>"); Response.Write("<link href=\"App_Themes/Argix/Argix.css\" rel=\"stylesheet\" type=\"text/css\" />"); Response.Write("</head>"); Response.Write("<body>"); LoadTenderDetailDataset ds = (LoadTenderDetailDataset)Session["LoadTenderDetail"]; int i = 0; string load = "", nextLoad = ""; while (i < ds.LoadTenderDetailTable.Rows.Count) { load = ds.LoadTenderDetailTable[i].Load; Response.Write("<table width=\"100%\" border=\"0\"><tr><td>"); Response.Write("<div style=\"float:left; width:400px; margin:0 0 20px 50px\">"); Response.Write("<table>"); Response.Write("<tr><td align=\"right\"><b>Load#:</b></td><td><span style=\"color:Black;\">" + ds.LoadTenderDetailTable[i].Load + "</span></td></tr>"); Response.Write("<tr><td align=\"right\"><b>Reference#:</b></td><td><span style=\"color:Black;\">" + ds.LoadTenderDetailTable[i].ReferenceNumber + "</span></td></tr>"); Response.Write("<tr><td align=\"right\"><b>Location#:</b></td><td><span style=\"color:Black;\">" + ds.LoadTenderDetailTable[i].LocationNumber + "</span></td></tr>"); Response.Write("<tr><td align=\"right\"><b>Location ID:</b></td><td><span style=\"color:Black;\">" + ds.LoadTenderDetailTable[i].LocationID + "</span></td></tr>"); Response.Write("<tr><td align=\"right\"><b>PO#:</b></td><td><span style=\"color:Black;\">" + ds.LoadTenderDetailTable[i].PONumber + "</span></td></tr>"); Response.Write("</table>"); Response.Write("</div>"); Response.Write("<div style=\"float:left; width:400px; margin:0 0 20px 50px\">"); Response.Write("<table>"); Response.Write("<tr><td align=\"right\"><b>Client:</b></td><td><span style=\"color:Black;\">" + ds.LoadTenderDetailTable[i].Client + "</span> - <span style=\"color:Black;\">" + ds.LoadTenderDetailTable[i].ClientName + "</span>, Store# <span style=\"color:Black;\">" + ds.LoadTenderDetailTable[i].StoreNumber + "</span></td></tr>"); Response.Write("<tr><td align=\"right\"><b>Location:</b></td><td><span style=\"color:Black;\">" + ds.LoadTenderDetailTable[i].Location + "</span></td></tr>"); Response.Write("<tr><td align=\"right\"><b>Address:</b></td><td><span style=\"color:Black;\">" + ds.LoadTenderDetailTable[i].AddressLine1 + "</span></td></tr>"); Response.Write("<tr><td align=\"right\"> </td><td><span style=\"color:Black;\">" + ds.LoadTenderDetailTable[i].AddressLine2 + "</span></td></tr>"); Response.Write("<tr><td align=\"right\"> </td><td><span style=\"color:Black;\">" + ds.LoadTenderDetailTable[i].City + "</span>, <span style=\"color:Black;\">" + ds.LoadTenderDetailTable[i].StateOrProvince + "</span> <span style=\"color:Black;\">" + ds.LoadTenderDetailTable[i].PostalCode + "</span></td></tr>"); Response.Write("</table>"); Response.Write("</div>"); Response.Write("</td>"); Response.Write("</tr>"); Response.Write("<tr>"); Response.Write("<td>"); Response.Write("<div style=\"width:400px; margin:0 0 0px 6px\">Load Tender Details</div>"); Response.Write("<div style=\"width:900px; margin:0 0 0px 0px\">"); Response.Write("<table cellspacing=\"0\" cellpadding=\"2\" rules=\"all\" border=\"1\" style=\"background-color:White;border-width:1px;border-style:Inset;font-size:0.9em;width:100%;border-collapse:collapse;\">"); Response.Write("<tr style=\"color:buttontext;background-color:buttonface;border-color:window;border-width:0px;border-style:None;\"><th scope=\"col\" style=\"width:75px;\">Item#</th><th scope=\"col\" style=\"width:200px;\">Item Desc</th><th scope=\"col\" style=\"width:75px;\">Qty</th><th scope=\"col\" style=\"width:100px;\">Units</th><th scope=\"col\" style=\"width:150px;\">Sorted Item#</th><th scope=\"col\" style=\"width:150px;\">Sorted PO#</th><th scope=\"col\" style=\"width:75px;\">Sorted?</th></tr>"); do { Response.Write("<tr style=\"color:Black;background-color:White;border-width:0px;border-style:None;white-space:nowrap;\"><td>" + ds.LoadTenderDetailTable[i].ItemNumber + "</td><td>" + ds.LoadTenderDetailTable[i].ItemDescription + "</td><td>" + ds.LoadTenderDetailTable[i].QuantityOrdered + "</td><td>" + ds.LoadTenderDetailTable[i].UOM + "</td><td>" + ds.LoadTenderDetailTable[i].SortedItemNumber + "</td><td>" + ds.LoadTenderDetailTable[i].SortedPONumber + "</td><td>" + ds.LoadTenderDetailTable[i].Sorted + "</td></tr>"); i++; nextLoad = i < ds.LoadTenderDetailTable.Rows.Count ? ds.LoadTenderDetailTable[i].Load : ""; } while (nextLoad == load); Response.Write("</table>"); Response.Write("</div>"); Response.Write("</td>"); Response.Write("</tr>"); Response.Write("</table>"); Response.Write("<br />"); Response.Write("<hr />"); } Response.Write("</body>"); Response.Write("</html>"); }