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