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