void LoadData() { try { DvgPhieuXH.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; DvgPhieuXH.Enabled = true; // dtXuat = new DataTable(); dtXuat.Clear(); // dtXuat = dbPhieuXuat.LayBangPhieuXuat(); DvgPhieuXH.DataSource = dtXuat; // this.btnHuy.Enabled = false; this.btnLuu.Enabled = false; // this.btnSua.Enabled = true; this.btnTaiLai.Enabled = true; this.btnThem.Enabled = true; this.btnTroVe.Enabled = true; this.btnXoa.Enabled = true; // this.txtGia.Enabled = false; this.txtMaPX.Enabled = false; this.txtSoLuong.Enabled = false; this.cbMaKH.Enabled = false; this.cbMaHH.Enabled = false; this.cbMaNV.Enabled = false; this.cbXuLy.Enabled = false; this.rtxtGhiChu.Enabled = false; this.txtNgayXuat.Enabled = false; // cbNgay.Enabled = true; btnThongke.Enabled = true; LoadNgay(cbNgay); // DvgPhieuXH_CellClick(null, null); this.txtMaPX.Focus(); } catch (SqlException) { MessageBox.Show("Lỗi Rồi! Không Load Được Bảng", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void BtnHT_Click(object sender, EventArgs e) { //LoadData(); if (cbTable.SelectedValue.ToString() == "CHINHANH") { LoadData(); dvgShowTable.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dt = dbChiNhanh.LayBangChiNhanh(); dvgShowTable.DataSource = dt; dvgShowTable.Rows[0].Selected = false; } else if (cbTable.SelectedValue.ToString() == "NHANVIEN") { LoadData(); dvgShowTable.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; dt = dbNhanVien.LayBangNhanVien(); dvgShowTable.DataSource = dt; dvgShowTable.Rows[0].Selected = false; } else if (cbTable.SelectedValue.ToString() == "PHIEUNHAPHANG") { LoadData(); dvgShowTable.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; dt = dbPhieuNhap.LayBangPhieuNhap(); dvgShowTable.DataSource = dt; dvgShowTable.Rows[0].Selected = false; } else if (cbTable.SelectedValue.ToString() == "KHO") { LoadData(); dvgShowTable.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dt = dbKho.LayBangKho(); dvgShowTable.DataSource = dt; dvgShowTable.Rows[0].Selected = false; } else if (cbTable.SelectedValue.ToString() == "HANGHOA") { LoadData(); dvgShowTable.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; dt = dbHangHoa.LayBangHangHoa(); dvgShowTable.DataSource = dt; dvgShowTable.Rows[0].Selected = false; } else if (cbTable.SelectedValue.ToString() == "NHACUNGCAP") { LoadData(); dvgShowTable.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dt = dbNhaCungCap.LayBangNhaCungCap(); dvgShowTable.DataSource = dt; dvgShowTable.Rows[0].Selected = false; } else if (cbTable.SelectedValue.ToString() == "PHIEUXUATHANG") { LoadData(); dvgShowTable.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; dt = dbPhieuXuat.LayBangPhieuXuat(); dvgShowTable.DataSource = dt; dvgShowTable.Rows[0].Selected = false; } else if (cbTable.SelectedValue.ToString() == "KHACHHANG") { LoadData(); dvgShowTable.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; dt = dbKhachHang.LayBangKhachHang(); dvgShowTable.DataSource = dt; dvgShowTable.Rows[0].Selected = false; } else { MessageBox.Show("Chưa Chọn bảng ??"); } }