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