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 comboBoxMaNV_SelectedIndexChanged(object sender, EventArgs e)
{
string MaNV = comboBoxMaNV.SelectedItem.ToString();
string query = "SELECT * FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'";
database.loadDataGridView(dataGridView, query);
}
private void buttonSearch_Click(object sender, EventArgs e)
{
string search = textBoxSearch.Text.Trim();
if (search.Length != 0)
{
if (check == 0)
{
MessageBox.Show("Vui lòng chọn kiểu tìm kiếm!", "", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
else if (check == 1)
{
try
{
string MaNV = textBoxSearch.Text.Trim();
string timkiem = "EXEC.TimKiemMaNV @MaNV=N'" + MaNV + "'";
db.loadDataGridView(dataGridView1, timkiem);
textBoxSearch.Text = "";
}
catch
{
}
}
else if (check == 2)
{
try
{
string PB = textBoxSearch.Text.Trim();
bool temp = db.Check(PB, "SELECT * FROM dbo.PhongBan WHERE MaPB = N'" + PB + "'");
//MessageBox.Show(temp.ToString());
if (temp == false)
{
db.loadDataGridView(dataGridView1, "SELECT * FROM dbo.PhongBan WHERE TenPB LIKE N'%" + PB + "%'");
textBoxSearch.Text = "";
}
else
{
db.loadDataGridView(dataGridView1, "SELECT * FROM dbo.PhongBan WHERE MaPB = N'" + PB + "'");
textBoxSearch.Text = "";
}
}
catch
{
}
}
else
{
db.loadDataGridView(dataGridView1, "SELECT * FROM dbo.HoSoNV WHERE TenNV LIKE N'%" + search + "%'");
textBoxSearch.Text = "";
}
}
else
{
MessageBox.Show("Vui lòng nhập khóa để tìm kiếm", "", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
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 comboBoxMaNV1_SelectedIndexChanged(object sender, EventArgs e)
{
Reset();
string MaNV = comboBoxMaNV1.SelectedItem.ToString();
db.loadTextBox(textBoxMaLuong1, "SELECT MaLuong FROM dbo.HoSoNV WHERE MaNV=N'" + MaNV + "'");
db.loadTextBox(textBoxTenNV1, "SELECT TenNV FROM dbo.HoSoNV WHERE MaNV=N'" + MaNV + "'");
string ten = textBoxTenNV1.Text.Trim();
db.loadTextBox(textBoxTenNV1, "SELECT HoDemNV FROM dbo.HoSoNV WHERE MaNV=N'" + MaNV + "'");
string ho = textBoxTenNV1.Text.Trim();
string HoTenNV = ho + " " + ten;
textBoxTenNV1.Text = HoTenNV;
db.loadDataGridView(dataGridViewBH, "SELECT * FROM dbo.CDBaoHiemXaHoi WHERE MaNV=N'" + MaNV + "'");
try
{
db.loadTextBox(textBoxMaBHXH, "SELECT MaBHXH FROM dbo.CDBaoHiemXaHoi WHERE MaNV='" + MaNV + "'");
}
catch
{
}
}
private void Form1_Load(object sender, EventArgs e)
{
viTriBanDau();
user = UI.FormLOGIN.useraccount;
string loichao = "Hello " + user + "!";
labelChao.Text = loichao;
int toado = 787 - 10 * user.Length;
labelChao.Location = new Point(toado, 50);
string query = "SELECT * FROM dbo.HoSoNV";
database.loadDataGridView(dataGridView1, query);
}
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 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 comboBoxMaPB_SelectedIndexChanged(object sender, EventArgs e)
{
string MaPB = comboBoxMaPB.SelectedItem.ToString();
db.loadDataGridView(dataGridView, "SELECT * FROM dbo.PhongBan WHERE MaPB=N'" + MaPB + "'");
}
private void comboBoxBacLuong_SelectedIndexChanged(object sender, EventArgs e)
{
string MaLuong = comboBoxBacLuong.Text.TrimEnd();
db.loadDataGridView(dataGridView1, "SELECT * FROM dbo.Luong WHERE MaLuong='" + MaLuong + "'");
}
