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