private void FormCheDo_Load(object sender, EventArgs e) { dataGridViewTS.AllowUserToResizeColumns = true; dataGridViewBH.AllowUserToResizeColumns = true; db.loadComboBox(comboBoxMaNV1, "SELECT MaNV FROM dbo.HoSoNV"); db.loadComboBox(comboBoxMaNV2, "SELECT HS.MaNV FROM dbo.HoSoNV HS, dbo.TTNhanVienCoBan TT WHERE HS.MaNV = TT.MaNV AND TT.GioiTinh = N'Nữ'"); }
private void FormCheDo_Load(object sender, EventArgs e) { dgvTS.AllowUserToResizeColumns = true; dgvBH.AllowUserToResizeColumns = true; db.loadDataGridView(dgvTS, "SELECT * FROM dbo.CDThaiSan"); db.loadDataGridView(dgvBH, "SELECT * FROM dbo.CDBaoHiemXaHoi"); db.loadComboBox(cbbMaNV1, "SELECT MaNV FROM dbo.HoSoNV"); db.loadComboBox(cbbMaNV2, "SELECT HS.MaNV FROM dbo.HoSoNV HS, dbo.TTNhanVienCoBan TT WHERE HS.MaNV = TT.MaNV AND TT.GioiTinh = N'Nữ'"); }
private void FormHoSoNV_Load(object sender, EventArgs e) { database.loadComboBox(cbbMaPB, "SELECT MaPB FROM dbo.PhongBan"); database.loadComboBox(cbbLuong, "SELECT MaLuong FROM dbo.Luong"); database.loadComboBox(cbbMaNV, "SELECT MaNV FROM dbo.HoSoNV"); database.loadDataGridView(dgvHoSo, "SELECT * FROM dbo.HoSoNV"); }
private void FormTTCaNhan_Load(object sender, EventArgs e) { database.loadComboBox(cbbMaNV, "SELECT MaNV FROM dbo.HoSoNV"); database.loadDataGridView(dgvTTCN, "SELECT * FROM dbo.TTNhanVienCoBan"); }
private void FormBacLuong_Load(object sender, EventArgs e) { db.loadComboBox(cbbBacLuong, "SELECT MaLuong FROM dbo.Luong"); db.loadDataGridView(dgvBacLuong, "SELECT * FROM dbo.Luong"); }
private void FormPhongBan_Load(object sender, EventArgs e) { db.loadComboBox(cbbMaPB, "SELECT MaPB FROM dbo.PhongBan"); db.loadComboBox(cbbMaTruongPhong, "SELECT MaNV FROM dbo.HoSoNV"); db.loadDataGridView(dgvPhongBan, "SELECT * FROM dbo.PhongBan"); }
private void FormPhongBan_Load(object sender, EventArgs e) { db.loadComboBox(comboBoxMaPB, "SELECT MaPB FROM dbo.PhongBan"); db.loadComboBox(comboBoxMaTruongPhong, "SELECT MaNV FROM dbo.HoSoNV"); }
private void FormBacLuong_Load(object sender, EventArgs e) { db.loadComboBox(comboBoxBacLuong, "SELECT MaLuong FROM dbo.Luong"); }
private void FormHoSoNV_Load(object sender, EventArgs e) { database.loadComboBox(comboBoxMaPB, "SELECT MaPB FROM dbo.PhongBan"); database.loadComboBox(comboBoxLuong, "SELECT MaLuong FROM dbo.Luong"); database.loadComboBox(comboBoxMaNV, "SELECT MaNV FROM dbo.HoSoNV"); }
private void FormTTCaNhan_Load(object sender, EventArgs e) { database.loadComboBox(comboBoxMaNV, "SELECT MaNV FROM dbo.HoSoNV"); }