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