private void DrawHeaderInvoice(XGraphics gfx, PdfPage page, SO curso) { XTextFormatter tf = new XTextFormatter(gfx); XImage image = XImage.FromGdiPlusImage(Image.FromFile(@"\\10.0.0.14\API\Images\Excologo.png")); gfx.DrawImage(image, start_X, start_Y - 10, 130, 40); XRect rect = new XRect(start_X, start_Y + 31, 100, row_headerheight); gfx.DrawRectangle(XBrushes.White, rect); tf.DrawString("Exco Tooling Solutions", font1, XBrushes.Black, rect, XStringFormats.TopLeft); rect = new XRect(start_X + 105, start_Y + 31, 200, 8); gfx.DrawRectangle(XBrushes.White, rect); tf.DrawString("T. 905.477.1208 / 800.461.6298", font1, XBrushes.Black, rect, XStringFormats.TopLeft); rect = new XRect(start_X, start_Y + row_headerheight + 32, 100, 8); gfx.DrawRectangle(XBrushes.White, rect); tf.DrawString("130 Spy Court, 1st Floor", font1, XBrushes.Black, rect, XStringFormats.TopLeft); rect = new XRect(start_X + 105, start_Y + row_headerheight + 32, 200, 8); gfx.DrawRectangle(XBrushes.White, rect); tf.DrawString("F. 905.477.6304 / 877.336.3356", font1, XBrushes.Black, rect, XStringFormats.TopLeft); rect = new XRect(start_X, start_Y + row_headerheight * 2 + 33, 100, 8); gfx.DrawRectangle(XBrushes.White, rect); tf.DrawString("Markham, ON, L3R 5H6", font1, XBrushes.Black, rect, XStringFormats.TopLeft); rect = new XRect(start_X + 105, start_Y + row_headerheight * 2 + 33, 200, 8); gfx.DrawRectangle(XBrushes.White, rect); tf.DrawString("www.etsdies.com", font1, XBrushes.Black, rect, XStringFormats.TopLeft); rect = new XRect(start_X + 270, start_Y + 31, 38, 8); gfx.DrawRectangle(XBrushes.White, rect); tf.DrawString("Remit to:", font1, XBrushes.Black, rect, XStringFormats.TopLeft); rect = new XRect(start_X + 309, start_Y + 31, 120, 8); gfx.DrawRectangle(XBrushes.White, rect); tf.DrawString("Lockbox #15629, TD Bank Tower", font2, XBrushes.Black, rect, XStringFormats.TopLeft); rect = new XRect(start_X + 309, start_Y + row_headerheight + 32, 120, 8); gfx.DrawRectangle(XBrushes.White, rect); tf.DrawString("66 Wellington St. W., Suite 4500", font2, XBrushes.Black, rect, XStringFormats.TopLeft); rect = new XRect(start_X + 309, start_Y + row_headerheight * 2 + 33, 120, 8); gfx.DrawRectangle(XBrushes.White, rect); tf.DrawString("Toronto, Ontario M5K 1E7", font2, XBrushes.Black, rect, XStringFormats.TopLeft); rect = new XRect(start_X + 340, start_Y - 18, 120, 30); gfx.DrawRectangle(XBrushes.White, rect); tf.DrawString("INVOICE", font5, XBrushes.Black, rect, XStringFormats.TopLeft); rect = new XRect(start_X + 470, start_Y - 18, 100, 30); gfx.DrawRectangle(XBrushes.White, rect); tf.DrawString(curso.invoicenumber, font5, XBrushes.Black, rect, XStringFormats.TopLeft); XPen pen = new XPen(Color.Black, 0.5); int cur_Y = 35; gfx.DrawLine(pen, start_X + 470, cur_Y, start_X + 570, cur_Y); gfx.DrawLine(pen, start_X + 470, cur_Y + row_boxheight * 4, start_X + 570, cur_Y + row_boxheight * 4); gfx.DrawLine(pen, start_X + 470, cur_Y, start_X + 470, cur_Y + row_boxheight * 4); gfx.DrawLine(pen, start_X + 570, cur_Y, start_X + 570, cur_Y + row_boxheight * 4); gfx.DrawLine(pen, start_X + 470, cur_Y + row_boxheight, start_X + 570, cur_Y + row_boxheight); gfx.DrawLine(pen, start_X + 470, cur_Y + row_boxheight * 2, start_X + 570, cur_Y + row_boxheight * 2); gfx.DrawLine(pen, start_X + 470, cur_Y + row_boxheight * 3, start_X + 570, cur_Y + row_boxheight * 3); rect = new XRect(start_X + 471, cur_Y + 1, 98, row_boxheight - 2); gfx.DrawRectangle(XBrushes.LightGray, rect); rect = new XRect(start_X + 471, cur_Y + row_boxheight * 2 + 1, 98, row_boxheight - 2); gfx.DrawRectangle(XBrushes.LightGray, rect); rect = new XRect(start_X + 470, cur_Y + 2, 98, row_boxheight); tf.Alignment = XParagraphAlignment.Center; tf.DrawString("INVOICE DATE", font3, XBrushes.Black, rect, XStringFormats.TopLeft); rect = new XRect(start_X + 470, cur_Y + row_boxheight + 2, 98, row_boxheight); tf.Alignment = XParagraphAlignment.Center; tf.DrawString(curso.invoicedate.ToShortDateString(), font4, XBrushes.Black, rect, XStringFormats.TopLeft); rect = new XRect(start_X + 470, cur_Y + row_boxheight * 2 + 2, 98, row_boxheight); tf.Alignment = XParagraphAlignment.Center; tf.DrawString("SHIP DATE", font3, XBrushes.Black, rect, XStringFormats.TopLeft); rect = new XRect(start_X + 470, cur_Y + row_boxheight * 3 + 2, 98, row_boxheight); tf.Alignment = XParagraphAlignment.Center; tf.DrawString(curso.shipdate.ToShortDateString(), font4, XBrushes.Black, rect, XStringFormats.TopLeft); }
private void GetCustInfo() { SqlCommand objCmd = null; using (SqlConnection objConn = new SqlConnection(Global.ConnectionStr)) { objConn.Open(); objCmd = objConn.CreateCommand(); objCmd.CommandText = String.Format( "select a.customercode,a.name,b.name as aname,b.address1,b.address2,b.address3,b.address4,b.postalcode " + " from d_customer as a, d_customeraddress as b where a.customercode=b.customercode and a.customercode='{0}'", custcode); using (SqlDataReader objReader = objCmd.ExecuteReader()) { if (objReader.HasRows) { while (objReader.Read()) { if (objReader["aname"].ToString().Trim() == "SHIPPING") { saddress1 = objReader["address1"].ToString().Trim(); saddress2 = objReader["address2"].ToString().Trim(); saddress3 = objReader["address3"].ToString().Trim(); saddress4 = objReader["address4"].ToString().Trim(); spostalcode = objReader["postalcode"].ToString().Trim(); } else if (objReader["aname"].ToString().Trim() == "BILLING") { baddress1 = objReader["address1"].ToString().Trim(); baddress2 = objReader["address2"].ToString().Trim(); baddress3 = objReader["address3"].ToString().Trim(); baddress4 = objReader["address4"].ToString().Trim(); bpostalcode = objReader["postalcode"].ToString().Trim(); } } } } } using (SqlConnection objConn = new SqlConnection(Global.ConnectionStr)) { objConn.Open(); objCmd = objConn.CreateCommand(); objCmd.CommandText = String.Format( "select a.ordernumber,a.customercode,b.name,b.terms,a.invoicenumber,a.invoicedate,a.shipdate,a.sales," + " a.fasttrackcharge,a.discountamount,a.orderdate,a.note,a.designtype,a.freight,a.freightweight,a.freightcharge,a.customerpo,a.shopdate,b.accountset,a.total,a.steelrate,a.shipvia,b.taxgroup,b.taxcode " + " from d_order as a, d_customer as b " + " where a.customercode = b.customercode " + " and a.ordernumber = '{0}' " //+ " and (a.customerpo not like '%CANCEL%' or a.customerpo is null) " + " order by b.name, a.ordernumber", ordernumber); using (SqlDataReader objReader = objCmd.ExecuteReader()) { if (objReader.HasRows) { while (objReader.Read()) { custcode = objReader["customercode"].ToString().Trim(); custname = objReader["name"].ToString().Trim(); terms = objReader["terms"].ToString().Trim(); accountset = objReader["accountset"].ToString().Trim(); taxgroup = objReader["taxgroup"].ToString().Trim(); taxcode = objReader["taxcode"].ToString().Trim(); newSO = new SO(); newSO.ordernumber = objReader["ordernumber"].ToString().Trim(); newSO.shipvia = objReader["shipvia"].ToString().Trim(); newSO.note = objReader["note"].ToString().Trim(); newSO.designtype = GetDesignType(objReader["designtype"].ToString().Trim()); newSO.invoicenumber = objReader["invoicenumber"].ToString().Trim(); newSO.invoicedate = Convert.ToDateTime(objReader["invoicedate"].ToString()); newSO.shipdate = Convert.ToDateTime(objReader["shipdate"].ToString()); newSO.orderdate = Convert.ToDateTime(objReader["orderdate"].ToString()); newSO.shopdate = Convert.ToDateTime(objReader["shopdate"].ToString()); newSO.customerpo = objReader["customerpo"].ToString().Trim(); newSO.total = Convert.ToDouble(objReader["total"]); newSO.sales = Convert.ToDouble(objReader["sales"]); newSO.steelrate = Convert.ToDouble(objReader["steelrate"]); newSO.freight = Convert.ToDouble(objReader["freight"]); newSO.freightweight = Convert.ToDouble(objReader["freightweight"]); newSO.freightcharge = Convert.ToDouble(objReader["freightcharge"]); newSO.discountamount = Convert.ToDouble(objReader["discountamount"]); newSO.fasttrackcharge = Convert.ToDouble(objReader["fasttrackcharge"]); GetSOInfo(); GetTaxInfo(); } } } } }