public void showBill(int id)
{
lvBill.Items.Clear();
List <BillInfo> listBillInfo = new List <BillInfo>();
//label1.Text = billID.ToString();
string query = "select f.id, f.name, bi.count, f.price, (f.price*bi.count*(100-f.discount))/100 as totalPrice, f.discount from Bill as b, BillInfo as bi, Food as f where bi.idBill = b.id and bi.idFood = f.id and b.status = 0 and b.idTable = " + id;
DataTable dataBillInfo = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow row in dataBillInfo.Rows)
{
BillInfo info = new BillInfo(row);
listBillInfo.Add(info);
}
float totalPrice = 0;
foreach (BillInfo item in listBillInfo)
{
ListViewItem lvItem = new ListViewItem(item.NameFood.ToString());
lvItem.SubItems.Add(item.Count.ToString());
lvItem.SubItems.Add(item.Price.ToString());
lvItem.SubItems.Add(item.Discount.ToString());
lvItem.SubItems.Add(item.TotalPrice.ToString());
lvItem.SubItems.Add(item.IdFood.ToString());
totalPrice += item.TotalPrice;
lvBill.Items.Add(lvItem);
}
CultureInfo culture = new CultureInfo("vi-VN");
txtTotalPrice.Text = totalPrice.ToString("c", culture);
TongTienThanhToan = totalPrice;
//DataTable dataBillInfo = DataProvider.Instance.ExecuteQuery("select * from BillInfo where idBill = " + billID);
//foreach (DataRow row in dataBillInfo.Rows)
//{
// BillInfo info = new BillInfo(row);
// listBillInfo.Add(info);
//}
//foreach (BillInfo item in listBillInfo)
//{
// ListViewItem lvItem = new ListViewItem(item.IdFood.ToString());
// lvItem.SubItems.Add(item.Count.ToString());
// lvBill.Items.Add(lvItem);
//}
}
private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
e.Graphics.DrawString("HÓA ĐƠN BÁN HÀNG", new Font("Segoe UI", 21, FontStyle.Bold), Brushes.Black, new Point(270, 100));
e.Graphics.DrawString("Ngày bán: " + DateTime.Now.ToString(), new Font("Arial", 15, FontStyle.Regular), Brushes.Black, new Point(50, 200));
e.Graphics.DrawString("HĐ: " + idBill, new Font("Arial", 15, FontStyle.Regular), Brushes.Black, new Point(700, 200));
e.Graphics.DrawString("______________________________________________________________", new Font("Arial", 15, FontStyle.Regular), Brushes.Black, new Point(50, 270));
e.Graphics.DrawString("Mặt hàng", new Font("Arial", 15, FontStyle.Bold), Brushes.Black, new Point(50, 320));
e.Graphics.DrawString("SL", new Font("Arial", 15, FontStyle.Bold), Brushes.Black, new Point(250, 320));
e.Graphics.DrawString("Đơn giá", new Font("Arial", 15, FontStyle.Bold), Brushes.Black, new Point(350, 320));
e.Graphics.DrawString("KM (%)", new Font("Arial", 15, FontStyle.Bold), Brushes.Black, new Point(530, 320));
e.Graphics.DrawString("Thành tiền", new Font("Arial", 15, FontStyle.Bold), Brushes.Black, new Point(680, 320));
List <BillInfo> listBillInfo = new List <BillInfo>();
//label1.Text = billID.ToString();
string query = "select f.id, f.name, bi.count, f.price, (f.price*bi.count*(100-f.discount))/100 as totalPrice, f.discount from Bill as b, BillInfo as bi, Food as f where bi.idBill = b.id and bi.idFood = f.id and b.status = 0 and b.idTable = " + QuanLyBanHang.IDTable;
DataTable dataBillInfo = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow row in dataBillInfo.Rows)
{
BillInfo info = new BillInfo(row);
listBillInfo.Add(info);
}
int point = 320;
foreach (BillInfo item in listBillInfo)
{
point += 50;
e.Graphics.DrawString(item.NameFood.ToString(), new Font("Arial", 15, FontStyle.Regular), Brushes.Black, new Point(50, point));
e.Graphics.DrawString(item.Count.ToString(), new Font("Arial", 15, FontStyle.Regular), Brushes.Black, new Point(250, point));
e.Graphics.DrawString(item.Price.ToString(), new Font("Arial", 15, FontStyle.Regular), Brushes.Black, new Point(350, point));
e.Graphics.DrawString(item.Discount.ToString(), new Font("Arial", 15, FontStyle.Regular), Brushes.Black, new Point(530, point));
e.Graphics.DrawString(item.TotalPrice.ToString(), new Font("Arial", 15, FontStyle.Regular), Brushes.Black, new Point(680, point));
}
point += 50;
e.Graphics.DrawString("______________________________________________________________", new Font("Arial", 15, FontStyle.Regular), Brushes.Black, new Point(50, point));
point += 50;
e.Graphics.DrawString("TỔNG TIỀN PHẢI THANH TOÁN", new Font("Arial", 15, FontStyle.Bold), Brushes.Black, new Point(50, point));
e.Graphics.DrawString(txtTienPhaiThanhToan.Text.ToString(), new Font("Arial", 15, FontStyle.Regular), Brushes.Black, new Point(680, point));
point += 50;
e.Graphics.DrawString("TIỀN KHÁCH TRẢ", new Font("Arial", 15, FontStyle.Bold), Brushes.Black, new Point(50, point));
e.Graphics.DrawString(txtTienKhachTra.Text.ToString(), new Font("Arial", 15, FontStyle.Regular), Brushes.Black, new Point(680, point));
point += 50;
e.Graphics.DrawString("TIỀN TRẢ LẠI", new Font("Arial", 15, FontStyle.Bold), Brushes.Black, new Point(50, point));
e.Graphics.DrawString((float.Parse(txtTienKhachTra.Text) - float.Parse(txtTienPhaiThanhToan.Text)).ToString(), new Font("Arial", 15, FontStyle.Regular), Brushes.Black, new Point(680, point));
point += 100;
e.Graphics.DrawString("CẢM ƠN QUÝ KHÁCH VÀ HẸN GẶP LẠI", new Font("Segoe UI", 18, FontStyle.Bold), Brushes.Black, new Point(195, point));
}
