private void CTHD_HOADON_Load(object sender, EventArgs e) { comboBox1.DataSource = KhachHang_BLL.KhachHang_Select(); comboBox1.DisplayMember = "HoTenKH"; comboBox1.ValueMember = "MaKH"; cbnhanvien.DataSource = nhanVien_BLL.SinhVien_Select(); cbnhanvien.DisplayMember = "TenNV"; cbnhanvien.ValueMember = "MaNV"; cbhanghoa.DataSource = hangHoa_BLL.HangHoa_Select(); cbhanghoa.DisplayMember = "TenHangHoa"; cbhanghoa.ValueMember = "MaHangHoa"; datahoadon.DataSource = HoaDon_BLL.HoaDon_SelectPROVIP(); CTHD = new DataTable(); CTHD.Columns.Add("Mã Hàng", typeof(string)); CTHD.Columns.Add("Tên Hàng Hóa", typeof(string)); CTHD.Columns.Add("ĐVT", typeof(string)); CTHD.Columns.Add("Đơn Giá", typeof(string)); CTHD.Columns.Add("Số Lượng", typeof(string)); CTHD.Columns.Add("Thành Tiền", typeof(string)); dataCTHD.DataSource = CTHD; }
private void butcapnhapHD_Click(object sender, EventArgs e) { var HoaDon_BLL = new HoaDon_BLL(); string MaKH = comboBox1.SelectedValue.ToString(); string MaNV = cbnhanvien.SelectedValue.ToString(); datahoadon.DataSource = HoaDon_BLL.HoaDon_Update(txtsoHD.Text, MaKH, MaNV, DateTime.Parse(dateTimePicker1.Value.ToString()), "Khó Quá", "Tiền Mặt"); datahoadon.DataSource = HoaDon_BLL.HoaDon_SelectPROVIP(); txtsoHD.Enabled = false; foreach (DataRow dr in CTHD.Rows) { var CTHD_BLL = new CTHD_BLL(); dataCTHD.DataSource = CTHD_BLL.CTHD_Update(txtsoHD.Text, dr[0].ToString(), int.Parse(txtsoluong.Text)); dataCTHD.DataSource = CTHD_BLL.CTHD_SelectPROVIP(); } foreach (DataRow dr in CTHD.Rows) { var CTHD_BLL = new CTHD_BLL(); dataCTHD.DataSource = CTHD_BLL.CTHD_Delete(dr[0].ToString()); dataCTHD.DataSource = CTHD_BLL.CTHD_SelectPROVIP(); } CTHD.Clear(); CTHD_HOADON_Load(sender, e); }