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