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