private void PayForm_Load(object sender, EventArgs e) { SetUIChanges(); ToUpper(); // this.lblServiceCharge.Text = this.lblServiceCharge.Text + " (" + ConfigurationManager.AppSettings["SeviceCostPercent"] + "%)"; this.lblMoneyVAT.Text = this.lblMoneyVAT.Text + " (" + ConfigurationManager.AppSettings["VAT"] + "%)"; if (ConfigurationManager.AppSettings["DiscountPercent"] == "1") { this.lblDiscount.Text = this.lblDiscount.Text + " (%)"; } if (string.IsNullOrWhiteSpace(tempOrder)) { lblAmt_TotalAmtBeforeTax.Text = double.Parse(Program.lstTempOrder.order.TotalAmountBeforeTax).ToString("0,0"); lblAmt_TotalTax.Text = double.Parse(Program.lstTempOrder.order.TotalTax).ToString("0,0"); lblAmt_TotalAfterTax.Text = double.Parse(Program.lstTempOrder.order.TotalAmmount).ToString("0,0"); lblAmt_TotalAmount.Text = double.Parse(Program.lstTempOrder.order.TotalMoney).ToString("0,0"); } else { OrderBLL orderBLL = new OrderBLL(); orAll = orderBLL.GetOrderInfo(tempOrder); lblAmt_TotalAmtBeforeTax.Text = double.Parse(orAll.order.TotalAmountBeforeTax).ToString("0,0"); lblAmt_TotalTax.Text = double.Parse(orAll.order.TotalTax).ToString("0,0"); lblAmt_TotalAfterTax.Text = double.Parse(orAll.order.TotalMoney).ToString("0,0"); lblAmt_TotalAmount.Text = double.Parse(orAll.order.TotalMoney).ToString("0,0"); } }
public static OrderAll GetOrderInfo(string OrderID) { OrderAll res = new OrderAll(); DataSet ds = new DataSet(); string[][] param = { new string[] { "p_OrderId", OrderID }, }; string errorString = ""; string cnStr = GetConnectionString(); DataStoreProcQuery_Param(cnStr, "spSelect_Order_AllInfo", ref ds, param, ref errorString); if (string.IsNullOrEmpty(errorString) && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; DataRow dr = dt.Rows[0]; Orders rc = new Orders(); rc.OrderId = dr["OrderId"].ToString(); rc.CreatedBy = dr["CreatedBy"].ToString(); rc.CreateDate = dr["CreatedDate"].ToString(); rc.TotalAmountBeforeTax = double.Parse(dr["TotalAmountBeforeTax"].ToString()).ToString("0,0"); rc.TotalTax = double.Parse(dr["TotalTax"].ToString()).ToString("0,0"); rc.TotalMoney = double.Parse(dr["TotalMoney"].ToString()).ToString("0,0"); rc.DisCountAmount = double.Parse(dr["DisCountAmount"].ToString()).ToString("0,0"); res.order = rc; } ///// if (ds.Tables[1].Rows.Count > 0) { DataTable dt = ds.Tables[1]; List <OrderDetails> lst = new List <OrderDetails>(); foreach (DataRow dr in dt.Rows) { OrderDetails rc = new OrderDetails(); rc.OrderId = dr["OrderId"].ToString(); rc.ProductId = dr["ProductId"].ToString(); rc.ProductName = GetProductName(dr["ProductId"].ToString()); rc.Qty = double.Parse(dr["Qty"].ToString()).ToString("0,0"); rc.Price = double.Parse(dr["Price"].ToString()).ToString("0,0"); rc.AmmountBeforeTax = double.Parse(dr["AmmountBeforeTax"].ToString()).ToString("0,0"); rc.TaxAmmount = double.Parse(dr["TaxAmmount"].ToString()).ToString("0,0"); rc.TotalAmount = double.Parse(dr["TotalAmmount"].ToString()).ToString("0,0"); lst.Add(rc); } res.lst_Detail = lst; } } else { res = null; } return(res); }
private static void printDocumentOrder_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e) { // load data hoa don OrderAll rcAll = GetOrderInfo(OrId); int y_p = 0; // Logo string path = HttpContext.Current.Server.MapPath("/"); var imgLogo = System.Drawing.Image.FromFile(path + "Image//ShopImg//logoPrint.png"); Rectangle logo = new Rectangle(5, 10, 60, 40); e.Graphics.DrawImage(imgLogo, logo); /// Rectangle strHoaDon = new Rectangle(130, 5, 165, 20); string data = Common.clsLanguages.GetResource("Order", Language);//"ORDER"; StringFormat strfmt_Left = new StringFormat(); StringFormat strfmt_Center = new StringFormat(); StringFormat strfmt_Right = new StringFormat(); strfmt_Left.LineAlignment = StringAlignment.Near; strfmt_Left.Alignment = StringAlignment.Near; strfmt_Center.LineAlignment = StringAlignment.Center; strfmt_Center.Alignment = StringAlignment.Center; strfmt_Right.LineAlignment = StringAlignment.Far; strfmt_Right.Alignment = StringAlignment.Far; e.Graphics.DrawString(data, new Font("Arial", 12, FontStyle.Bold), Brushes.DarkSlateBlue, strHoaDon, strfmt_Right); //Ngày hóa đơn Rectangle strRec = new Rectangle(120, 25, 175, 15); data = Common.clsLanguages.GetResource("ReceiptDate", Language) + " : " + rcAll.order.CreateDate; //"Ngày :" e.Graphics.DrawString(data, new Font("Arial", 8, FontStyle.Regular), Brushes.DarkSlateBlue, strRec, strfmt_Right); Rectangle RecLine1 = new Rectangle(115, 40, 180, 2); var Line1 = System.Drawing.Image.FromFile(path + "Image//ShopImg//line1.png"); e.Graphics.DrawImage(Line1, RecLine1); Rectangle strRec1 = new Rectangle(120, 42, 175, 18); string strSoHD = rcAll.order.OrderId; int soHD = int.Parse(strSoHD.Substring(10)); data = Common.clsLanguages.GetResource("OrderId", Language) + " : 10#" + soHD.ToString(); //"Số HĐ: " e.Graphics.DrawString(data, new Font("Arial", 8, FontStyle.Italic), Brushes.DarkSlateBlue, strRec1, strfmt_Right); //// Cty.... Rectangle strCty = new Rectangle(5, 50, 140, 20); data = Common.clsLanguages.GetResource("MerchantName", Language);// "Công ty CP Việt Vang"; e.Graphics.DrawString(data, new Font("Arial", 9, FontStyle.Bold), Brushes.DarkSlateBlue, strCty, strfmt_Left); //Địa chỉ Cty Rectangle strDCCty = new Rectangle(5, 70, 160, 50); data = Common.clsLanguages.GetResource("MerchantAddress", Language) + "\n" + Common.clsLanguages.GetResource("MerchantTel", Language) + "\n" + Common.clsLanguages.GetResource("MerchantWeb", Language); e.Graphics.DrawString(data, new Font("Arial", 7, FontStyle.Regular), Brushes.DarkSlateBlue, strDCCty, strfmt_Left); //Headers Rectangle strHD_STT = new Rectangle(3, 120, 30, 18); data = Common.clsLanguages.GetResource("No", Language);// "STT"; e.Graphics.DrawString(data, new Font("Arial", 8, FontStyle.Bold), Brushes.Black, strHD_STT, strfmt_Center); Rectangle strHD_SP = new Rectangle(33, 120, 97, 18); data = Common.clsLanguages.GetResource("Product", Language);//"Sản phẩm "; e.Graphics.DrawString(data, new Font("Arial", 9, FontStyle.Bold), Brushes.Black, strHD_SP, strfmt_Left); Rectangle strHD_SL = new Rectangle(130, 120, 30, 18); data = Common.clsLanguages.GetResource("ReceiptProQty", Language);//"SL"; e.Graphics.DrawString(data, new Font("Arial", 9, FontStyle.Bold), Brushes.Black, strHD_SL, strfmt_Center); Rectangle strHD_DG = new Rectangle(160, 120, 60, 18); data = Common.clsLanguages.GetResource("ReceiptProPrice", Language);//"ĐG"; e.Graphics.DrawString(data, new Font("Arial", 9, FontStyle.Bold), Brushes.Black, strHD_DG, strfmt_Center); Rectangle strHD_TT = new Rectangle(220, 120, 70, 18); data = Common.clsLanguages.GetResource("ReceiptProTotalAfterTax", Language);//"TT + Thuế"; e.Graphics.DrawString(data, new Font("Arial", 9, FontStyle.Bold), Brushes.Black, strHD_TT, strfmt_Center); Rectangle RecLine2 = new Rectangle(5, 138, 290, 2); var Line2 = System.Drawing.Image.FromFile(path + "Image//ShopImg//line2.png"); e.Graphics.DrawImage(Line2, RecLine2); if (rcAll.lst_Detail != null && rcAll.lst_Detail.Count > 0) { y_p = 140; int i = 0; foreach (OrderDetails dtl in rcAll.lst_Detail) { i++; //Headers Rectangle strCT_STT = new Rectangle(5, y_p, 28, 22); data = i.ToString(); e.Graphics.DrawString(data, new Font("Arial", 7, FontStyle.Regular), Brushes.Black, strCT_STT, strfmt_Center); Rectangle strCT_SP = new Rectangle(33, y_p, 97, 22); data = Common.clsLanguages.GetResource("ProductID", Language) + dtl.ProductId + " - " + dtl.ProductName; e.Graphics.DrawString(data, new Font("Arial", 7, FontStyle.Regular), Brushes.Black, strCT_SP, strfmt_Left); Rectangle strCT_SL = new Rectangle(130, y_p, 30, 22); data = dtl.Qty; e.Graphics.DrawString(data, new Font("Arial", 7, FontStyle.Regular), Brushes.Black, strCT_SL, strfmt_Center); Rectangle strTT_DG = new Rectangle(160, y_p, 60, 22); data = double.Parse(dtl.Price.ToString()).ToString("0,0"); e.Graphics.DrawString(data, new Font("Arial", 7, FontStyle.Regular), Brushes.Black, strTT_DG, strfmt_Right); Rectangle strTT_TT = new Rectangle(220, y_p, 70, 22); data = double.Parse(dtl.TotalAmount.ToString()).ToString("0,0"); e.Graphics.DrawString(data, new Font("Arial", 7, FontStyle.Regular), Brushes.Black, strTT_TT, strfmt_Right); Rectangle RecLineCT = new Rectangle(5, y_p + 22, 290, 1); var LineCT = System.Drawing.Image.FromFile(path + "Image//ShopImg//linect.png"); e.Graphics.DrawImage(LineCT, RecLineCT); y_p = y_p + 23; } } ///Tổng tiền trước thuế Rectangle RecTTTT = new Rectangle(90, y_p, 120, 15); data = Common.clsLanguages.GetResource("TotalAmountBeforeTax", Language);//"Tổng tiền trước thuế "; e.Graphics.DrawString(data, new Font("Arial", 8, FontStyle.Regular), Brushes.Black, RecTTTT, strfmt_Right); Rectangle RecTTTT_Val = new Rectangle(210, y_p, 85, 15); data = rcAll.order.TotalAmountBeforeTax; e.Graphics.DrawString(data, new Font("Arial", 8, FontStyle.Bold), Brushes.Black, RecTTTT_Val, strfmt_Right); y_p = y_p + 15; ///Tổng tiền thuế Rectangle RecTTT = new Rectangle(90, y_p, 120, 15); data = Common.clsLanguages.GetResource("TotalTaxAmount", Language);// "Tổng tiền thuế "; e.Graphics.DrawString(data, new Font("Arial", 8, FontStyle.Regular), Brushes.Black, RecTTT, strfmt_Right); Rectangle RecTTT_Val = new Rectangle(210, y_p, 85, 15); data = rcAll.order.TotalTax; e.Graphics.DrawString(data, new Font("Arial", 8, FontStyle.Bold), Brushes.Black, RecTTT_Val, strfmt_Right); y_p = y_p + 15; ///Tổng tiền sau thuế Rectangle RecTTST = new Rectangle(90, y_p, 120, 15); data = Common.clsLanguages.GetResource("TotalAmountAfterTax", Language);//"Tổng tiền sau thuế "; e.Graphics.DrawString(data, new Font("Arial", 8, FontStyle.Regular), Brushes.Black, RecTTST, strfmt_Right); Rectangle RecTTST_Val = new Rectangle(210, y_p, 85, 15); data = rcAll.order.TotalAmmount; e.Graphics.DrawString(data, new Font("Arial", 8, FontStyle.Bold), Brushes.Black, RecTTST_Val, strfmt_Right); y_p = y_p + 15; ///Giảm giá Rectangle RecDIS = new Rectangle(90, y_p, 120, 15); data = Common.clsLanguages.GetResource("TotalDiscountAmount", Language);//"Giảm giá "; e.Graphics.DrawString(data, new Font("Arial", 8, FontStyle.Regular), Brushes.Black, RecDIS, strfmt_Right); Rectangle RecDIS_Val = new Rectangle(210, y_p, 85, 15); data = rcAll.order.DisCountAmount; e.Graphics.DrawString(data, new Font("Arial", 8, FontStyle.Bold), Brushes.Black, RecDIS_Val, strfmt_Right); y_p = y_p + 15; ///Tổng tiền thanh toán Rectangle RecPAY = new Rectangle(90, y_p, 120, 15); data = Common.clsLanguages.GetResource("TotalMoney", Language);//"TC Cần thanh toán"; e.Graphics.DrawString(data, new Font("Arial", 8, FontStyle.Regular), Brushes.Black, RecPAY, strfmt_Right); Rectangle RecPAY_Val = new Rectangle(210, y_p, 85, 15); data = rcAll.order.TotalMoney; e.Graphics.DrawString(data, new Font("Arial", 8, FontStyle.Bold), Brushes.Black, RecPAY_Val, strfmt_Right); y_p = y_p + 15; //// Rectangle RecLine6 = new Rectangle(5, y_p, 290, 2); var Line6 = System.Drawing.Image.FromFile(path + "Image//ShopImg//line1.png"); e.Graphics.DrawImage(Line6, RecLine6); y_p = y_p + 4; Rectangle RecTK = new Rectangle(5, y_p, 190, 18); data = Common.clsLanguages.GetResource("ReceiptFooterText", Language); //"Cám ơn & hẹn gặp lại quý khách !"; e.Graphics.DrawString(data, new Font("Arial", 8, FontStyle.Italic), Brushes.Black, RecTK, strfmt_Left); Rectangle RecPower = new Rectangle(200, y_p, 95, 47); var LineP = System.Drawing.Image.FromFile(path + "Image//VVImg//powered by vv.png"); e.Graphics.DrawImage(LineP, RecPower); y_p = y_p + 47; }
public OrderAll GetOrderInfo(string OrderID) { OrderAll res = new OrderAll(); ProductsBLL productsBLL = new BusinessLayer.ProductsBLL(); DeskBLL deskBLL = new DeskBLL(); DataSet ds = new DataSet(); string[][] param = { new string[] { "p_OrderId", OrderID }, }; string errorString = ""; //string cnStr = GetConnectionString(); Program.destopService.DataStoreProcQuery_Param(Program.Username, Program.Password, "spSelect_Order_AllInfo", ref ds, param, ref errorString); if (string.IsNullOrEmpty(errorString) && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; DataRow dr = dt.Rows[0]; Orders rc = new Orders(); rc.OrderId = dr["OrderId"].ToString(); rc.CreatedBy = dr["CreatedBy"].ToString(); rc.CreateDate = Convert.ToDateTime(dr["CreatedDate"].ToString()).ToString("dd/MM/yy H:s"); rc.TotalAmountBeforeTax = double.Parse(dr["TotalAmountBeforeTax"].ToString()).ToString("0,0"); rc.TotalTax = double.Parse(dr["TotalTax"].ToString()).ToString("0,0"); rc.TotalMoney = double.Parse(dr["TotalMoney"].ToString()).ToString("0,0"); rc.DisCountAmount = double.Parse(dr["DisCountAmount"].ToString()).ToString("0,0"); rc.DeskId = deskBLL.GetDeskNO(dr["DeskId"].ToString()); res.order = rc; } ///// if (ds.Tables[1].Rows.Count > 0) { DataTable dt = ds.Tables[1]; List <OrderDetails> lst = new List <OrderDetails>(); foreach (DataRow dr in dt.Rows) { OrderDetails rc = new OrderDetails(); rc.OrderId = dr["OrderId"].ToString(); rc.ProductId = dr["ProductId"].ToString(); rc.ProductName = productsBLL.GetProductName(dr["ProductId"].ToString()); rc.Qty = double.Parse(dr["Qty"].ToString()).ToString("0,0"); rc.Price = double.Parse(dr["Price"].ToString()).ToString("0,0"); rc.AmmountBeforeTax = double.Parse(dr["AmmountBeforeTax"].ToString()).ToString("0,0"); rc.TaxAmmount = double.Parse(dr["TaxAmmount"].ToString()).ToString("0,0"); rc.TotalAmount = double.Parse(dr["TotalAmmount"].ToString()).ToString("0,0"); rc.Status = dr["Status"].ToString(); rc.Note = dr["Note"].ToString(); lst.Add(rc); } res.lst_Detail = lst; } } else { res = null; } return(res); }
private static void printDocumentOrderKitchen_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e) { // load data hoa don OrderAll rcAll = new OrderAll(); rcAll = GetOrderInfo(OrId); int y_p = 0; string[][] list = new string[rcAll.lst_Detail.Count][]; int j = 0; foreach (OrderDetails dtl in rcAll.lst_Detail) { string[] arr = new string[4]; arr[0] = j.ToString(); //arr[1] = dtl.ProductId + " - " + dtl.ProductName; arr[1] = dtl.ProductName; //TODO: TEMP Comment //arr[2] = dtl.Qty; //arr[3] = dtl.Note;//(dtl.Notes == null) ? "" : dtl.Notes; list[j] = arr; j++; } string data; StringFormat strfmt_Left = new StringFormat(); StringFormat strfmt_Center = new StringFormat(); StringFormat strfmt_Right = new StringFormat(); strfmt_Left.LineAlignment = StringAlignment.Near; strfmt_Left.Alignment = StringAlignment.Near; strfmt_Center.LineAlignment = StringAlignment.Center; strfmt_Center.Alignment = StringAlignment.Center; strfmt_Right.LineAlignment = StringAlignment.Far; strfmt_Right.Alignment = StringAlignment.Far; y_p += 20; Rectangle strDesk = new Rectangle(5, y_p, 250, 22); data = Languages.GetResource("Desk_", Language) + " " + rcAll.order.TableId; e.Graphics.DrawString(data, new Font("Arial", 10, FontStyle.Bold), Brushes.Black, strDesk, strfmt_Left); Rectangle strDate = new Rectangle(5, y_p + 22, 250, 22); data = Languages.GetResource("ReceiptDate", Language) + " " + DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss"); e.Graphics.DrawString(data, new Font("Arial", 10, FontStyle.Bold), Brushes.Black, strDate, strfmt_Left); Rectangle strReceiptId1 = new Rectangle(180, y_p, 100, 30); data = Int32.Parse(rcAll.order.OrderId.Substring(10)).ToString(); e.Graphics.DrawString(data, new Font("Arial", 16, FontStyle.Bold), Brushes.Black, strReceiptId1, strfmt_Right); y_p += 45; Rectangle strReceiptId = new Rectangle(5, y_p, 250, 22); data = Languages.GetResource("OrderIDNo", Language) + " : 10#" + rcAll.order.OrderId.Substring(10); e.Graphics.DrawString(data, new Font("Arial", 10, FontStyle.Bold), Brushes.Black, strReceiptId, strfmt_Left); y_p += 23; Rectangle strHD_STT = new Rectangle(5, y_p, 63, 22); // đổi , 30-28 data = Languages.GetResource("No", Language); e.Graphics.DrawString(data, new Font("Arial", 10, FontStyle.Bold), Brushes.Black, strHD_STT, strfmt_Left); Rectangle strHD_SP = new Rectangle(35, y_p, 220, 22); data = Languages.GetResource("Product", Language);//"Sản phẩm "; e.Graphics.DrawString(data, new Font("Arial", 10, FontStyle.Bold), Brushes.Black, strHD_SP, strfmt_Left); Rectangle strHD_SL = new Rectangle(260, y_p, 45, 22); data = Languages.GetResource("ReceiptProQty", Language);//"SL"; e.Graphics.DrawString(data, new Font("Arial", 10, FontStyle.Bold), Brushes.Black, strHD_SL, strfmt_Left); y_p += 30; for (int i = 0; i < list.Length; i++) { //Headers Rectangle strCT_STT = new Rectangle(5, y_p, 30, 22); data = (i + 1).ToString(); e.Graphics.DrawString(data, new Font("Arial", 14, FontStyle.Regular), Brushes.Black, strCT_STT, strfmt_Left); data = list[i][1]; int heightl = Int32.Parse(Math.Ceiling((double)data.Length / 17).ToString()) * 18 + 5; Rectangle strCT_SP = new Rectangle(35, y_p, 220, heightl); e.Graphics.DrawString(data, new Font("Arial", 14, FontStyle.Regular), Brushes.Black, strCT_SP, strfmt_Left); Rectangle strCT_SL = new Rectangle(260, y_p, 45, 22); data = list[i][2]; e.Graphics.DrawString(data, new Font("Arial", 14, FontStyle.Regular), Brushes.Black, strCT_SL, strfmt_Left); data = list[i][3]; int height = 0; if (!string.IsNullOrEmpty(data)) { height = Int32.Parse(Math.Ceiling((double)data.Length / 17).ToString()) * 18 + 4; Rectangle notes = new Rectangle(5, y_p + heightl, 280, height); e.Graphics.DrawString(data, new Font("Arial", 14, FontStyle.Regular), Brushes.Black, notes, strfmt_Left); } Rectangle RecLineCT = new Rectangle(5, y_p + heightl + height, 280, 22); data = "-----------------------------------------------------------------------"; e.Graphics.DrawString(data, new Font("Arial", 14, FontStyle.Regular), Brushes.Black, RecLineCT, strfmt_Left); y_p = y_p + height + heightl + 20; } }