public static List <DTO.DTO_HoaDon> GetAllHoaDon(int maTiecCuoi)
{
List <DTO.DTO_HoaDon> hoaDons = null;
String sqlCommand = String.Format(@"Select * from HOADON where MaTiecCuoi = {0}", maTiecCuoi);
DataTable dataTable = DatabaseHelper.GetData(sqlCommand);
if (dataTable != null)
{
if (dataTable.Rows.Count > 0)
{
hoaDons = new List <DTO.DTO_HoaDon>();
int size = dataTable.Rows.Count;
for (int i = 0; i < size; i++)
{
DTO.DTO_HoaDon hoaDon = new DTO.DTO_HoaDon();
DataRow dataRow = dataTable.Rows[i];
hoaDon.SoHoaDon = int.Parse(dataRow["SoHoaDon"].ToString());
hoaDon.MaTiecCuoi = int.Parse(dataRow["MaTiecCuoi"].ToString());
hoaDon.TongTienDichVu = decimal.Parse(dataRow["TongTienDichVu"].ToString());
hoaDon.TongTienBan = decimal.Parse(dataRow["TongTienBan"].ToString());
hoaDon.TongTienHoaDon = decimal.Parse(dataRow["TongTienHoaDon"].ToString());
hoaDon.TienDaThanhToan = decimal.Parse(dataRow["TienDaThanhToan"].ToString());
hoaDon.NgayThanhToan = DateTime.Parse(dataRow["NgayThanhToan"].ToString()).ToString("MM/dd/yyyy");
hoaDon.ConLai = decimal.Parse(dataRow["ConLai"].ToString());
hoaDons.Add(hoaDon);
}
}
}
return(hoaDons);
}
public form_XemHD(int ID)
{
InitializeComponent();
this.ID = ID;
DTO.DTO_HoaDon HD = BLL.BLL_HoaDon.layHoaDon(ID);
txt_MaHD.Text = "Mã hóa đơn: " + ID;
txt_HoTenKH.Text = "Khách hàng: " + HD.KHACHHANG_TENKH;
txt_NgayLap.Text = "Ngày lập: " + HD.HOADON_NGAYLAPPHIEU;
txt_NgayGiao.Text = "Ngày giao: " + HD.HOADON_NGAYGIAO;
for (int i = 0; i < HD.HOADON_ChiTietHD.Count(); ++i)
{
listView1.Items.Add(HD.HOADON_ChiTietHD[i].CHITIETHD_TENTB);
listView1.Items[i].SubItems.Add(HD.HOADON_ChiTietHD[i].CHITIETHD_GIA.ToString());
listView1.Items[i].SubItems.Add(HD.HOADON_ChiTietHD[i].CHITIETHD_SOLUONG.ToString());
listView1.Items[i].SubItems.Add((HD.HOADON_ChiTietHD[i].CHITIETHD_GIA * HD.HOADON_ChiTietHD[i].CHITIETHD_SOLUONG).ToString());
}
int tongTien = HD.tinhTongTien();
txt_TongTien.Text = "Tổng tiền: " + tongTien + " VND";
txt_GiamGia.Text = "Giảm giá: " + HD.HOADON_GIAMGIA + " VND";
int tienTra = tongTien - HD.HOADON_GIAMGIA;
txt_TienTra.Text = "Tiền trả: " + tienTra + " VND";
this.hienTinhTrang(HD.HOADON_TINHTRANG);
}
public static bool UpdateHoaDon(DTO.DTO_HoaDon hoaDon)
{
String sqlCommand = String.Format("UPDATE HOADON set MATIECCUOI = {0}, NgayThanhToan = '{1}', TongTienBan = {2}, TongTienDichVu = {3}, TongTienHoaDon = {4}, TienDaThanhToan = {5}, ConLai = {6} WHERE SoHoaDon = {6}", hoaDon.MaTiecCuoi, hoaDon.NgayThanhToan, hoaDon.TongTienBan, hoaDon.TongTienDichVu, hoaDon.TongTienHoaDon, hoaDon.ConLai, hoaDon.TienDaThanhToan, hoaDon.SoHoaDon);
if (DatabaseHelper.ExcuteSql(sqlCommand) > 0)
{
return(true);
}
return(false);
}
public static bool InsertHoaDon(DTO.DTO_HoaDon hoaDon)
{
String sqlCommand = String.Format(@"INSERT INTO HOADON (MaTiecCuoi, NgayThanhToan, TongTienBan, TongTienDichVu, TongTienHoaDon, TienDaThanhToan, ConLai)" +
"VALUES ({0}, '{1}', {2}, {3}, {4}, {5}, {6})", hoaDon.MaTiecCuoi, hoaDon.NgayThanhToan, hoaDon.TongTienBan, hoaDon.TongTienDichVu, hoaDon.TongTienHoaDon, hoaDon.TienDaThanhToan, hoaDon.ConLai);
if (DatabaseHelper.ExcuteSql(sqlCommand) == 1)
{
return(true);
}
return(false);
}
public static bool UpdateHoaDon(DTO.DTO_HoaDon hoaDon)
{
return(DAO.DAO_HoaDon.UpdateHoaDon(hoaDon));
}
public static bool InsertHoaDon(DTO.DTO_HoaDon hoaDon)
{
return(DAO.DAO_HoaDon.InsertHoaDon(hoaDon));
}
//public static DTO.DTO_TiecCuoi GetTiecCuoi(String tenChuRe, String tenCoDau)
//{
// return DAO.DAO_LapHoaDonThanhToan.GetTiecCuoi(tenChuRe, tenCoDau);
//}
public static bool UpdateSoTienConLai(DTO.DTO_HoaDon hoaDon)
{
return(DAO.DAO_LapHoaDonThanhToan.UpdateSoTienConLai(hoaDon));
}