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