private void DataGridView1Config(TreeNode node) { ATINChamCongEntities context = new ATINChamCongEntities(); if ((node.Tag as PhongBan).MaPhongBan == 0 && node.Text.Trim() == "Nhân viên mới") { var lstNguoi = context.spGetAllNguoi().Where(x => x.TrangThaiHoatDong == 2).ToList(); dataGridView1.DataSource = lstNguoi; if (lstNguoi.Count < 1) { return; } } if ((node.Tag as PhongBan).MaPhongBan == 0 && node.Text.Trim() == "ATI") { var lstNguoi = context.spGetAllNguoi().ToList(); dataGridView1.DataSource = lstNguoi; if (lstNguoi.Count < 1) { return; } } if ((node.Tag as PhongBan).MaPhongBan == 0 && node.Text.Trim() == "Văn phòng") { var lstNguoi = context.spGetAllNguoi().Where(x => x.TrangThaiHoatDong == 1).ToList(); dataGridView1.DataSource = lstNguoi; if (lstNguoi.Count < 1) { return; } } else if ((node.Tag as PhongBan).MaPhongBan != 0) { var lstNguoi = context.spGetAllNguoi().Where(x => (x.TrangThaiHoatDong == 1) && (x.MaPhongBan == (node.Tag as PhongBan).MaPhongBan)).ToList(); dataGridView1.DataSource = lstNguoi; if (lstNguoi.Count < 1) { return; } } dataGridView1.Columns["MaDinhDanh"].Visible = false; dataGridView1.Columns["MaPhongBan"].Visible = false; dataGridView1.Columns["MaChucVu"].Visible = false; dataGridView1.Columns["MaKhuVuc"].Visible = false; dataGridView1.Columns["NgaySinh"].Visible = false; dataGridView1.Columns["MaGioiTinh"].Visible = false; dataGridView1.Columns["SoDienThoai"].Visible = false; dataGridView1.Columns["Email"].Visible = false; dataGridView1.Columns["AnhDaiDien"].Visible = false; dataGridView1.Columns["MaTrinhDo"].Visible = false; dataGridView1.Columns["SoTheCanCuoc"].Visible = false; dataGridView1.Columns["NgayCapTCC"].Visible = false; dataGridView1.Columns["NoiCapTCC"].Visible = false; dataGridView1.Columns["MaDanToc"].Visible = false; dataGridView1.Columns["MaTonGiao"].Visible = false; dataGridView1.Columns["MaQuocTich"].Visible = false; dataGridView1.Columns["TinhTrangHonNhan"].Visible = false; dataGridView1.Columns["DiaChiThuongTru"].Visible = false; dataGridView1.Columns["DiaChiTamTru"].Visible = false; dataGridView1.Columns["NgayNhanViec"].Visible = false; dataGridView1.Columns["NgayThoiViec"].Visible = false; dataGridView1.Columns["SuDungVanTay"].Visible = false; dataGridView1.Columns["SuDungTheTu"].Visible = false; dataGridView1.Columns["SuDungKhuonMat"].Visible = false; dataGridView1.Columns["ThoiGianDangKy"].Visible = false; dataGridView1.Columns["ThoiGianCapNhat"].Visible = false; dataGridView1.Columns["GhiChu"].Visible = false; dataGridView1.Columns["TrangThaiHoatDong"].Visible = false; dataGridView1.Columns["ChamCongs"].Visible = false; dataGridView1.Columns["ChucVu"].Visible = false; dataGridView1.Columns["DangKyNghiPheps"].Visible = false; dataGridView1.Columns["DangKyTangCas"].Visible = false; dataGridView1.Columns["KhuonMats"].Visible = false; dataGridView1.Columns["PhongBan"].Visible = false; dataGridView1.Columns["NhatKies"].Visible = false; dataGridView1.Columns["SapXepLichTrinhs"].Visible = false; dataGridView1.Columns["TheTus"].Visible = false; dataGridView1.Columns["VanTays"].Visible = false; dataGridView1.Columns["SapXepLichTrinhTams"].Visible = false; dataGridView1.Columns["Checkbox"].DisplayIndex = 0; dataGridView1.Columns["MaNguoi"].DisplayIndex = 1; dataGridView1.Columns["HoTen"].DisplayIndex = 2; }
private void DataGridView1Config(TreeNode node) { ATINChamCongEntities context = new ATINChamCongEntities(); if ((node.Tag as PhongBan).MaPhongBan == 0 && node.Text.Trim() == "Nhân viên mới") { var lstNguoi = context.spGetAllNguoi().Where(x => x.TrangThaiHoatDong == 2).ToList(); List <ViewSapXepLichTrinh> viewSapXepLichTrinhs = new List <ViewSapXepLichTrinh>(); foreach (var nguoi in lstNguoi) { viewSapXepLichTrinhs.Add(context.spGetViewSapXepLichTrinhByNguoi(nguoi.MaNguoi).FirstOrDefault()); } dataGridView1.DataSource = viewSapXepLichTrinhs; if (viewSapXepLichTrinhs.Count < 1) { return; } barEditItem3.EditValue = viewSapXepLichTrinhs.Count.ToString(); } if ((node.Tag as PhongBan).MaPhongBan == 0 && node.Text.Trim() == "ATI") { var lstNguoi = context.spGetAllNguoi().ToList(); List <ViewSapXepLichTrinh> viewSapXepLichTrinhs = new List <ViewSapXepLichTrinh>(); foreach (var nguoi in lstNguoi) { viewSapXepLichTrinhs.Add(context.spGetViewSapXepLichTrinhByNguoi(nguoi.MaNguoi).FirstOrDefault()); } dataGridView1.DataSource = viewSapXepLichTrinhs; if (viewSapXepLichTrinhs.Count < 1) { return; } barEditItem3.EditValue = viewSapXepLichTrinhs.Count.ToString(); } if ((node.Tag as PhongBan).MaPhongBan == 0 && node.Text.Trim() == "Văn phòng") { var lstNguoi = context.spGetAllNguoi().Where(x => x.TrangThaiHoatDong == 1).ToList(); List <ViewSapXepLichTrinh> viewSapXepLichTrinhs = new List <ViewSapXepLichTrinh>(); foreach (var nguoi in lstNguoi) { viewSapXepLichTrinhs.Add(context.spGetViewSapXepLichTrinhByNguoi(nguoi.MaNguoi).FirstOrDefault()); } dataGridView1.DataSource = viewSapXepLichTrinhs; if (viewSapXepLichTrinhs.Count < 1) { return; } barEditItem3.EditValue = viewSapXepLichTrinhs.Count.ToString(); } else if ((node.Tag as PhongBan).MaPhongBan != 0) { var lstNguoi = context.spGetAllNguoi().Where(x => (x.TrangThaiHoatDong == 1) && (x.MaPhongBan == (node.Tag as PhongBan).MaPhongBan)).ToList(); List <ViewSapXepLichTrinh> viewSapXepLichTrinhs = new List <ViewSapXepLichTrinh>(); foreach (var nguoi in lstNguoi) { viewSapXepLichTrinhs.Add(context.spGetViewSapXepLichTrinhByNguoi(nguoi.MaNguoi).FirstOrDefault()); } dataGridView1.DataSource = viewSapXepLichTrinhs; if (viewSapXepLichTrinhs.Count < 1) { return; } barEditItem3.EditValue = viewSapXepLichTrinhs.Count.ToString(); } dataGridView1.Columns["MaSapXep"].Visible = false; dataGridView1.Columns["Checkbox"].DisplayIndex = 0; dataGridView1.Columns["MaNguoi"].DisplayIndex = 1; dataGridView1.Columns["MaChamCong"].DisplayIndex = 2; dataGridView1.Columns["HoTen"].DisplayIndex = 3; //dataGridView1.Columns["MaLichTrinh"].Visible = false; dataGridView1.Columns["col"].DisplayIndex = 4; dataGridView1.Refresh(); }