void LoadData()
{
try
{
DvgKho.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
DvgKho.Enabled = true;
//
dtKho = new DataTable();
dtKho.Clear();
//
dtKho = dbKho.LayBangKho();
DvgKho.DataSource = dtKho;
//
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.txtDiaChi.Enabled = false;
this.txtTenKho.Enabled = false;
this.txtMaKho.Enabled = false;
//
this.txtMaCN.Enabled = false;
//
DvgKho_CellClick(null, null);
this.txtMaKho.Focus();
//
LoadMaKho(cbMaKho);
}
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 ??");
}
}
void LoadMaKho(ComboBox cb)
{
cbKho.DataSource = dbKho.LayBangKho();
cbKho.ValueMember = "MaKho";
cbKho.DropDownStyle = ComboBoxStyle.DropDownList;
}
