private void loadctrldong()
{
listQLNS.Clear();
dataGridView_gerSRC.DataSource = bLL_Load.BLL_loadNhanVien();
for (int i = 0; i < dataGridView_gerSRC.Rows.Count; i++)
{
DataGridViewRow dataRow = new DataGridViewRow();
dataRow = dataGridView_gerSRC.Rows[i];
if (dataRow.Cells["TINHTRANG"].Value != null)
{
if (dataRow.Cells["TINHTRANG"].Value.ToString() == "Đang làm")
{
string pMaUV = dataRow.Cells["MANV"].Value.ToString();
string pTenUV = dataRow.Cells["HOTEN"].Value.ToString();
string pNgayUV = dataRow.Cells["NGAYVAOLAM"].Value.ToString().Split(' ')[0].ToString();
string pPhongBan = bLL_Load.BLL_loadTenPhongBan(dataRow.Cells["MAPHONGBAN"].Value.ToString().Trim());
string pHoSo = dataRow.Cells["MAHOSO"].Value.ToString();
string pChucVuUV = bLL_Load.BLL_loadTenChucVu(dataRow.Cells["MACHUCVU"].Value.ToString().Trim());
UserControl_Dong_NhanVien usercotrol = new UserControl_Dong_NhanVien(pMaUV, pTenUV, pNgayUV, pPhongBan, pHoSo, pChucVuUV, loadhinh(pMaUV));
listQLNS.Add(usercotrol);
}
}
}
}
private void txt_HoTen_TextChanged(object sender, EventArgs e)
{
if (txt_HoTen.Text.Trim().Length > 0 && cbo_ChucVu.Text.Trim().Length > 0 && cbo_PhongBan.Text.Length > 0)
{
listQLNSSearch.Clear();
dataGridView_gerSRC.DataSource = bLL_Load.BLL_loadNhanVien();
for (int i = 0; i < dataGridView_gerSRC.Rows.Count; i++)
{
DataGridViewRow dataRow = new DataGridViewRow();
dataRow = dataGridView_gerSRC.Rows[i];
if (dataRow.Cells["TINHTRANG"].Value != null)
{
if (dataRow.Cells["TINHTRANG"].Value.ToString() == "Đang làm")
{
string pMaUV = dataRow.Cells["MANV"].Value.ToString();
string pTenUV = dataRow.Cells["HOTEN"].Value.ToString();
string pNgayUV = dataRow.Cells["NGAYVAOLAM"].Value.ToString().Split(' ')[0].ToString();
string pPhongBan = bLL_Load.BLL_loadTenPhongBan(dataRow.Cells["MAPHONGBAN"].Value.ToString().Trim());
string pHoSo = dataRow.Cells["MAHOSO"].Value.ToString();
string pChucVuUV = bLL_Load.BLL_loadTenChucVu(dataRow.Cells["MACHUCVU"].Value.ToString().Trim());
UserControl_Dong_NhanVien usercotrol = new UserControl_Dong_NhanVien(pMaUV, pTenUV, pNgayUV, pPhongBan, pHoSo, pChucVuUV, loadhinh(pMaUV));
if (pTenUV.ToLower().ToString().Contains(txt_HoTen.Text.ToLower().ToString()) == true && pPhongBan.ToLower().ToString().Contains(cbo_PhongBan.Text.ToLower().ToString()) == true && pChucVuUV.ToLower().ToString().Contains(cbo_ChucVu.Text.ToLower().ToString()) == true)
{
listQLNSSearch.Add(usercotrol);
}
}
}
}
sapxep(listQLNSSearch);
}
else
{
if (txt_HoTen.Text.Trim().Length > 0 && cbo_ChucVu.Text.Trim().Length > 0)
{
listQLNSSearch.Clear();
dataGridView_gerSRC.DataSource = bLL_Load.BLL_loadNhanVien();
for (int i = 0; i < dataGridView_gerSRC.Rows.Count; i++)
{
DataGridViewRow dataRow = new DataGridViewRow();
dataRow = dataGridView_gerSRC.Rows[i];
if (dataRow.Cells["TINHTRANG"].Value != null)
{
if (dataRow.Cells["TINHTRANG"].Value.ToString() == "Đang làm")
{
string pMaUV = dataRow.Cells["MANV"].Value.ToString();
string pTenUV = dataRow.Cells["HOTEN"].Value.ToString();
string pNgayUV = dataRow.Cells["NGAYVAOLAM"].Value.ToString().Split(' ')[0].ToString();
string pPhongBan = bLL_Load.BLL_loadTenPhongBan(dataRow.Cells["MAPHONGBAN"].Value.ToString().Trim());
string pHoSo = dataRow.Cells["MAHOSO"].Value.ToString();
string pChucVuUV = bLL_Load.BLL_loadTenChucVu(dataRow.Cells["MACHUCVU"].Value.ToString().Trim());
UserControl_Dong_NhanVien usercotrol = new UserControl_Dong_NhanVien(pMaUV, pTenUV, pNgayUV, pPhongBan, pHoSo, pChucVuUV, loadhinh(pMaUV));
if (pTenUV.ToLower().ToString().Contains(txt_HoTen.Text.ToLower().ToString()) == true && pChucVuUV.ToLower().ToString().Contains(cbo_ChucVu.Text.ToLower().ToString()) == true)
{
listQLNSSearch.Add(usercotrol);
}
}
}
}
sapxep(listQLNSSearch);
}
else
{
if (txt_HoTen.Text.Trim().Length > 0 && cbo_PhongBan.Text.Length > 0)
{
listQLNSSearch.Clear();
dataGridView_gerSRC.DataSource = bLL_Load.BLL_loadNhanVien();
for (int i = 0; i < dataGridView_gerSRC.Rows.Count; i++)
{
DataGridViewRow dataRow = new DataGridViewRow();
dataRow = dataGridView_gerSRC.Rows[i];
if (dataRow.Cells["TINHTRANG"].Value != null)
{
if (dataRow.Cells["TINHTRANG"].Value.ToString() == "Đang làm")
{
string pMaUV = dataRow.Cells["MANV"].Value.ToString();
string pTenUV = dataRow.Cells["HOTEN"].Value.ToString();
string pNgayUV = dataRow.Cells["NGAYVAOLAM"].Value.ToString().Split(' ')[0].ToString();
string pPhongBan = bLL_Load.BLL_loadTenPhongBan(dataRow.Cells["MAPHONGBAN"].Value.ToString().Trim());
string pHoSo = dataRow.Cells["MAHOSO"].Value.ToString();
string pChucVuUV = bLL_Load.BLL_loadTenChucVu(dataRow.Cells["MACHUCVU"].Value.ToString().Trim());
UserControl_Dong_NhanVien usercotrol = new UserControl_Dong_NhanVien(pMaUV, pTenUV, pNgayUV, pPhongBan, pHoSo, pChucVuUV, loadhinh(pMaUV));
if (pTenUV.ToLower().ToString().Contains(txt_HoTen.Text.ToLower().ToString()) == true && pPhongBan.ToLower().ToString().Contains(cbo_PhongBan.Text.ToLower().ToString()) == true)
{
listQLNSSearch.Add(usercotrol);
}
}
}
}
sapxep(listQLNSSearch);
}
else
{
if (cbo_ChucVu.Text.Trim().Length > 0 && cbo_PhongBan.Text.Length > 0)
{
listQLNSSearch.Clear();
dataGridView_gerSRC.DataSource = bLL_Load.BLL_loadNhanVien();
for (int i = 0; i < dataGridView_gerSRC.Rows.Count; i++)
{
DataGridViewRow dataRow = new DataGridViewRow();
dataRow = dataGridView_gerSRC.Rows[i];
if (dataRow.Cells["TINHTRANG"].Value != null)
{
if (dataRow.Cells["TINHTRANG"].Value.ToString() == "Đang làm")
{
string pMaUV = dataRow.Cells["MANV"].Value.ToString();
string pTenUV = dataRow.Cells["HOTEN"].Value.ToString();
string pNgayUV = dataRow.Cells["NGAYVAOLAM"].Value.ToString().Split(' ')[0].ToString();
string pPhongBan = bLL_Load.BLL_loadTenPhongBan(dataRow.Cells["MAPHONGBAN"].Value.ToString().Trim());
string pHoSo = dataRow.Cells["MAHOSO"].Value.ToString();
string pChucVuUV = bLL_Load.BLL_loadTenChucVu(dataRow.Cells["MACHUCVU"].Value.ToString().Trim());
UserControl_Dong_NhanVien usercotrol = new UserControl_Dong_NhanVien(pMaUV, pTenUV, pNgayUV, pPhongBan, pHoSo, pChucVuUV, loadhinh(pMaUV));
if (pPhongBan.ToLower().ToString().Contains(cbo_PhongBan.Text.ToLower().ToString()) == true && pChucVuUV.ToLower().ToString().Contains(cbo_ChucVu.Text.ToLower().ToString()) == true)
{
listQLNSSearch.Add(usercotrol);
}
}
}
}
sapxep(listQLNSSearch);
}
else
{
if (txt_HoTen.Text.Trim().Length > 0)
{
listQLNSSearch.Clear();
dataGridView_gerSRC.DataSource = bLL_Load.BLL_loadNhanVien();
for (int i = 0; i < dataGridView_gerSRC.Rows.Count; i++)
{
DataGridViewRow dataRow = new DataGridViewRow();
dataRow = dataGridView_gerSRC.Rows[i];
if (dataRow.Cells["TINHTRANG"].Value != null)
{
if (dataRow.Cells["TINHTRANG"].Value.ToString() == "Đang làm")
{
string pMaUV = dataRow.Cells["MANV"].Value.ToString();
string pTenUV = dataRow.Cells["HOTEN"].Value.ToString();
string pNgayUV = dataRow.Cells["NGAYVAOLAM"].Value.ToString().Split(' ')[0].ToString();
string pPhongBan = bLL_Load.BLL_loadTenPhongBan(dataRow.Cells["MAPHONGBAN"].Value.ToString().Trim());
string pHoSo = dataRow.Cells["MAHOSO"].Value.ToString();
string pChucVuUV = bLL_Load.BLL_loadTenChucVu(dataRow.Cells["MACHUCVU"].Value.ToString().Trim());
UserControl_Dong_NhanVien usercotrol = new UserControl_Dong_NhanVien(pMaUV, pTenUV, pNgayUV, pPhongBan, pHoSo, pChucVuUV, loadhinh(pMaUV));
if (pTenUV.ToLower().ToString().Contains(txt_HoTen.Text.ToLower().ToString()) == true)
{
listQLNSSearch.Add(usercotrol);
}
}
}
}
sapxep(listQLNSSearch);
}
else
{
if (cbo_ChucVu.Text.Trim().Length > 0)
{
listQLNSSearch.Clear();
dataGridView_gerSRC.DataSource = bLL_Load.BLL_loadNhanVien();
for (int i = 0; i < dataGridView_gerSRC.Rows.Count; i++)
{
DataGridViewRow dataRow = new DataGridViewRow();
dataRow = dataGridView_gerSRC.Rows[i];
if (dataRow.Cells["TINHTRANG"].Value != null)
{
if (dataRow.Cells["TINHTRANG"].Value.ToString() == "Đang làm")
{
string pMaUV = dataRow.Cells["MANV"].Value.ToString();
string pTenUV = dataRow.Cells["HOTEN"].Value.ToString();
string pNgayUV = dataRow.Cells["NGAYVAOLAM"].Value.ToString().Split(' ')[0].ToString();
string pPhongBan = bLL_Load.BLL_loadTenPhongBan(dataRow.Cells["MAPHONGBAN"].Value.ToString().Trim());
string pHoSo = dataRow.Cells["MAHOSO"].Value.ToString();
string pChucVuUV = bLL_Load.BLL_loadTenChucVu(dataRow.Cells["MACHUCVU"].Value.ToString().Trim());
UserControl_Dong_NhanVien usercotrol = new UserControl_Dong_NhanVien(pMaUV, pTenUV, pNgayUV, pPhongBan, pHoSo, pChucVuUV, loadhinh(pMaUV));
if (pChucVuUV.ToLower().ToString().Contains(cbo_ChucVu.Text.ToLower().ToString()) == true)
{
listQLNSSearch.Add(usercotrol);
}
}
}
}
sapxep(listQLNSSearch);
}
else
{
if (cbo_PhongBan.Text.Length > 0)
{
listQLNSSearch.Clear();
dataGridView_gerSRC.DataSource = bLL_Load.BLL_loadNhanVien();
for (int i = 0; i < dataGridView_gerSRC.Rows.Count; i++)
{
DataGridViewRow dataRow = new DataGridViewRow();
dataRow = dataGridView_gerSRC.Rows[i];
if (dataRow.Cells["TINHTRANG"].Value != null)
{
if (dataRow.Cells["TINHTRANG"].Value.ToString() == "Đang làm")
{
string pMaUV = dataRow.Cells["MANV"].Value.ToString();
string pTenUV = dataRow.Cells["HOTEN"].Value.ToString();
string pNgayUV = dataRow.Cells["NGAYVAOLAM"].Value.ToString().Split(' ')[0].ToString();
string pPhongBan = bLL_Load.BLL_loadTenPhongBan(dataRow.Cells["MAPHONGBAN"].Value.ToString().Trim());
string pHoSo = dataRow.Cells["MAHOSO"].Value.ToString();
string pChucVuUV = bLL_Load.BLL_loadTenChucVu(dataRow.Cells["MACHUCVU"].Value.ToString().Trim());
UserControl_Dong_NhanVien usercotrol = new UserControl_Dong_NhanVien(pMaUV, pTenUV, pNgayUV, pPhongBan, pHoSo, pChucVuUV, loadhinh(pMaUV));
if (pPhongBan.ToLower().ToString().Contains(cbo_PhongBan.Text.ToLower().ToString()) == true)
{
listQLNSSearch.Add(usercotrol);
}
}
}
}
sapxep(listQLNSSearch);
}
else
{
sapxep(listQLNS);
}
}
}
}
}
}
}
}
