private void comboBoxMaNV_SelectedIndexChanged(object sender, EventArgs e)
{
string MaNV = cbbMaNV.SelectedItem.ToString();
//Reset();
//dgvTTCN.DataSource = "";
//database.loadDataGridView(dgvTTCN, "SELECT * FROM dbo.TTNhanVienCoBan WHERE MaNV='" + MaNV + "'");
database.loadTextBox(txtChucVu, "SELECT ChucVu FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'");
database.loadTextBox(txtPhongBan, "SELECT MaPB FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'");
}
private void comboBoxMaNV_SelectedIndexChanged(object sender, EventArgs e)
{
string MaNV = comboBoxMaNV.SelectedItem.ToString();
Reset();
dataGridView1.DataSource = "";
database.loadDataGridView(dataGridView1, "SELECT * FROM dbo.TTNhanVienCoBan WHERE MaNV='" + MaNV + "'");
database.loadTextBox(textBoxTenNV, "SELECT TenNV FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'");
database.loadTextBox(textBoxHoNV, "SELECT HoDemNV FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'");
database.loadTextBox(textBoxChucVu, "SELECT ChucVu FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'");
database.loadTextBox(textBoxPhongBan, "SELECT MaPB FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'");
}
private void comboBoxMaNV_SelectedIndexChanged(object sender, EventArgs e)
{
string MaNV = cbbMaNV.SelectedItem.ToString();
database.loadTextBox(txtTenNV, "SELECT TenNV FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'");
database.loadTextBox(txtHoNV, "SELECT HoDemNV FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'");
database.loadTextBox(txtChucVu, "SELECT ChucVu FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'");
//database.loadComboBox_Show(comboBoxMaPB, "SELECT MaPB FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'");
//database.loadComboBox_Show(comboBoxLuong, "SELECT MaLuong FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'");
//string query = "SELECT * FROM dbo.HoSoNV WHERE MaNV='"+MaNV+"'";
//database.loadDataGridView(dataGridView, query);
}
private void comboBoxMaNV1_SelectedIndexChanged(object sender, EventArgs e)
{
Reset();
string MaNV = cbbMaNV1.SelectedItem.ToString();
db.loadTextBox(txtMaLuong1, "SELECT MaLuong FROM dbo.HoSoNV WHERE MaNV=N'" + MaNV + "'");
db.loadTextBox(txtTenNV1, "SELECT TenNV FROM dbo.HoSoNV WHERE MaNV=N'" + MaNV + "'");
string ten = txtTenNV1.Text.Trim();
db.loadTextBox(txtTenNV1, "SELECT HoDemNV FROM dbo.HoSoNV WHERE MaNV=N'" + MaNV + "'");
string ho = txtTenNV1.Text.Trim();
string HoTenNV = ho + " " + ten;
txtTenNV1.Text = HoTenNV;
//db.loadTextBox(textBoxGhiChu1, "SELECT GhiChu FROM dbo.HoSoNV WHERE MaNV=N'" + MaNV + "'");
//db.loadDataGridView(dataGridViewBH, "SELECT * FROM dbo.CDBaoHiemXaHoi WHERE MaNV=N'" + MaNV + "'");
try
{
db.loadTextBox(txtMaBHXH, "SELECT MaBHXH FROM dbo.CDBaoHiemXaHoi WHERE MaNV='" + MaNV + "'");
}
catch
{
}
}
