private void QuayHang_Load(object sender, EventArgs e)
{
funcShare.loadGridView("quay", dataGridView2);
funcShare.autoID(label_id, "quay");
dbAccess.FillCombo("select id from nhan_vien", cbMaNhanVien, "id", "id");
cbMaNhanVien.SelectedIndex = -1;
cbBox_Suggest(cbMaNhanVien, "select distinct id from nhan_vien");
}
private void PhieuNhap_Load(object sender, EventArgs e)
{
this.gridView.Columns[2].DefaultCellStyle.Format = "dd'/'MM'/'yyyy";
funcShare.loadGridView("phieu_nhap,nha_cung_cap,nhan_vien where ncc_id=nha_cung_cap.id and nhan_vien_id=nhan_vien.id"
, "phieu_nhap.id,nha_cung_cap.ten,ngay_nhap,nhan_vien.ten", gridView);
funcShare.autoID(label_id, "phieu_nhap");
}
private void QLXuat_Load(object sender, EventArgs e)
{
funcShare.loadGridView("phieu_xuat", dataGridView1);
funcShare.autoID(label_id, "phieu_xuat");
dbAccess.FillCombo("select id from quay", cbMaQuay, "id", "id");
cbMaQuay.SelectedIndex = -1;
//đổ dl vào mã Nhân viên
dbAccess.FillCombo("select id from nhan_vien", cbMaNhanVien, "id", "id");
cbMaNhanVien.SelectedIndex = -1;
//đổ dl voà loại
dbAccess.FillCombo("select id,ten from loai_hang", cbLoaiHang, "id", "ten");
cbLoaiHang.SelectedIndex = -1;
//gợi ý nhập mã quầy
cbBox_Suggest(cbMaQuay, "select distinct id from quay");
//gợi ý nhập loại hàng
cbBox_Suggest(cbLoaiHang, "select distinct ten from loai_hang");
//gợi ý nhập mã nhân viên
cbBox_Suggest(cbMaNhanVien, "select distinct id from nhan_vien");
}
private void LoaiHang_Load(object sender, EventArgs e)
{
funcShare.loadGridView("loai_hang", dataGridView2);
funcShare.autoID(label_id, "loai_hang");
}
private void NhaCungCap_Load(object sender, EventArgs e)
{
funcShare.loadGridView("nha_cung_cap", gridView);
funcShare.autoID(label_id, "nha_cung_cap");
}
private void FillData()
{
funcShare.loadGridView("nhan_vien", gridView);
funcShare.autoID(label_id, "nhan_vien");
}
private void LoadPhieuNhap()
{
// funcShare.loadGridView("phieu_nhap,nha_cung_cap,nhan_vien where ncc_id=nha_cung_cap.id and nhan_vien_id=nhan_vien.id"
// , "phieu_nhap.id,nha_cung_cap.ten,ngay_nhap,nhan_vien.ten", gridView);
funcShare.loadGridView("phieu_nhap", gridView);
}
