void LoadData()
{
try
{
DvgNhap.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
DvgNhap.Enabled = true;
//
dtNhap = new DataTable();
dtNhap.Clear();
//
dtNhap = dbPhieuNhap.LayBangPhieuNhap();
DvgNhap.DataSource = dtNhap;
//
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.txtMaPN.Enabled = false;
this.txtSoLuong.Enabled = false;
this.cbMaNCC.Enabled = false;
this.cbMaHH.Enabled = false;
this.cbMaNV.Enabled = false;
this.cbXuLy.Enabled = false;
this.rtxtGhiChu.Enabled = false;
this.txtNgayNhap.Enabled = false;
//
LoadNgay(cbNgay);
//
cbNgay.Enabled = true;
btnThongke.Enabled = true;
//
DvgNhap_CellClick(null, null);
this.txtMaPN.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 ??");
}
}
