private void HienThiChucVuLenCombobox()
{
List <ChucVu_DTO> lstChucVu = ChucVu_BUS.LayChucVu();
cboChucVu.DataSource = lstChucVu;
cboChucVu.DisplayMember = "STenCV";
cboChucVu.ValueMember = "SMaCV";
}
private void LoadChucVu()
{
List <ChucVu_DTO> listChucVu = ChucVu_BUS.LoadChucVu();
cbxChucVu.DataSource = listChucVu;
cbxChucVu.DisplayMember = "StrTenCV";
cbxChucVu.ValueMember = "StrMaCV";
}
private void LoadChucVu()
{
DataTable listChucVu = ChucVu_BUS.LoadChucVu();
cbxChucVu.DataSource = listChucVu;
cbxChucVu.DisplayMember = "TEN_CV";
cbxChucVu.ValueMember = "MA_CV";
}
private void HienThiDSNhanVienLenDatagrid()
{
//dg_col_SMaCV.DataSource = ChucVu_BUS.LayChucVu();
//dg_col_SMaCV.DisplayMember = "STenCV";
//dg_col_SMaCV.ValueMember = "SMaCV";
List <NhanVien_DTO> lstNhanVien = NhanVien_BUS.LayDSNhanVien();
dgDSNhanVien.DataSource = lstNhanVien;
//// thứ tự các cột
//dgDSNhanVien.Columns[0].DataPropertyName = "SMaNV";
//dgDSNhanVien.Columns[1].DataPropertyName = "SHoLot";
//dgDSNhanVien.Columns[2].DataPropertyName = "STen";
//dgDSNhanVien.Columns[3].DataPropertyName = "tencv";
//dgDSNhanVien.Columns[4].DataPropertyName = "SPhai";
//dgDSNhanVien.Columns[5].DataPropertyName = "DtNgaySinh";
dgDSNhanVien.Columns["SMaNV"].HeaderText = "Mã số";
dgDSNhanVien.Columns["SHoLot"].HeaderText = "Họ và lót";
dgDSNhanVien.Columns["STen"].HeaderText = "Tên";
dgDSNhanVien.Columns["SPhai"].HeaderText = "Phái";
dgDSNhanVien.Columns["DtNgaySinh"].HeaderText = "Ngày sinh";
dgDSNhanVien.Columns["SMaCV"].HeaderText = "Mã CV";
dgDSNhanVien.Columns["SMaNV"].Width = 60;
dgDSNhanVien.Columns["SHoLot"].Width = 120;
dgDSNhanVien.Columns["STen"].Width = 50;
dgDSNhanVien.Columns["SPhai"].Width = 50;
dgDSNhanVien.Columns["DtNgaySinh"].Width = 60;
dgDSNhanVien.Columns["SMaCV"].Width = 30;
// mới bổ sung thêm
// Hiển thị tên chức vụ tương ứng
string tenchucvu;
DataGridViewColumn clTenCV = new DataGridViewColumn();
DataGridViewCell cell = new DataGridViewTextBoxCell();
clTenCV.CellTemplate = cell;
clTenCV.Name = "tencv";
clTenCV.HeaderText = "Chức vụ";
clTenCV.Width = 150;
dgDSNhanVien.Columns.Add(clTenCV);
for (int i = 0; i < dgDSNhanVien.RowCount; i++)
{
tenchucvu = ChucVu_BUS.LayTenChucVuTheoMa(dgDSNhanVien.Rows[i].Cells["SMaCV"].Value.ToString());
dgDSNhanVien.Rows[i].Cells["tencv"].Value = tenchucvu;
}
}
private void HienThiDSChucVu()
{
ChucVu_BUS bus = new ChucVu_BUS();
List <clsChucVu_DTO> lstChucVu = bus.LayDanhSachChucVu();
clsChucVu_DTO dtoChucVu = new clsChucVu_DTO();
dtoChucVu.TenChucVu = "Chức vụ";
dtoChucVu.MaChucVu = "";
lstChucVu.Insert(0, dtoChucVu);
cboChucVu.DisplayMember = "TenChucVu";
cboChucVu.ValueMember = "MaChucVu";
cboChucVu.DataSource = lstChucVu;
}
private void frm_bcNhanVien_Load(object sender, EventArgs e)
{
//report viewer
NhanVien_DTOBindingSource.DataSource = NhanVien_BUS.LayDSNhanVien();
this.reportViewer1.RefreshReport();
//combobox chức vụ
List <ChucVu_DTO> lst = ChucVu_BUS.LayChucVu();
cboChucVu.DataSource = lst;
ChucVu_DTO d = new ChucVu_DTO();
d.SMaCV = "TC";
d.STenCV = "Tất cả";
lst.Insert(0, d);
cboChucVu.ValueMember = "SMaCV";
cboChucVu.DisplayMember = "STenCV";
}
private void HienThiDSChucVu(ComboBox cbo)
{
ChucVu_BUS bus = new ChucVu_BUS();
List <clsChucVu_DTO> lstChucVu = bus.LayDanhSachChucVu();
clsChucVu_DTO dtoChucVu = new clsChucVu_DTO();
if (cbo.Name == cboChucVu_TK.Name)
{
dtoChucVu.TenChucVu = "- -Tất cả- -";
dtoChucVu.MaChucVu = "";
lstChucVu.Insert(0, dtoChucVu);
}
cbo.DataSource = lstChucVu;
cbo.DisplayMember = "TenChucVu";
cbo.ValueMember = "MaChucVu";
cbo.SelectedIndex = 0;
}
private void HienThiChucVuLenDataGrid()
{
List <ChucVu_DTO> lstChucVu = ChucVu_BUS.LayChucVu();
dgDSChucVu.DataSource = lstChucVu;
}
private void dgvDSNV_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (dgvDSNV.Columns[e.ColumnIndex].Name == "colAnhNhanVien")
{
try
{
e.Value = new Bitmap(e.Value.ToString());
}
catch
{
}
}
if (dgvDSNV.Columns[e.ColumnIndex].Name == "colNgayVaoLam")
{
if (DateTime.Parse(e.Value.ToString()).ToShortDateString() != "01/01/0001")
{
e.Value = DateTime.Parse(e.Value.ToString()).ToShortDateString();
}
}
if (dgvDSNV.Columns[e.ColumnIndex].Name == "colNgayThoiViec")
{
if (e.Value != null)
{
e.Value = DateTime.Parse(e.Value.ToString()).ToShortDateString();
}
}
if (dgvDSNV.Columns[e.ColumnIndex].Name == "colGioiTinh")
{
if (Convert.ToBoolean(e.Value) == true)
{
e.Value = "Nam";
}
else
{
e.Value = "Nữ";
}
}
if (dgvDSNV.Columns[e.ColumnIndex].Name == "colChucVu")
{
ChucVu_BUS bus = new ChucVu_BUS();
List <clsChucVu_DTO> lstChucVu = bus.LayDanhSachChucVu();
clsChucVu_DTO dtoChucVu = lstChucVu.First(u => u.MaChucVu == e.Value.ToString());
e.Value = dtoChucVu.TenChucVu;
}
if (dgvDSNV.Columns[e.ColumnIndex].Name == "colTrangThai")
{
TrangThaiNV_BUS bus = new TrangThaiNV_BUS();
List <clsTrangThaiNV_DTO> lstTrangThaiNV = bus.LayDanhSachTrangThaiNhanVien();
clsTrangThaiNV_DTO dtoTrangThaiNV = lstTrangThaiNV.First(u => u.MaTrangThaiNV == Convert.ToInt32(e.Value.ToString()));
e.Value = dtoTrangThaiNV.TenTrangThaiNV;
}
foreach (DataGridViewRow r in dgvDSNV.Rows)
{
if (Convert.ToInt32(r.Cells["colTrangThai"].Value) == 2) // Đã nghỉ việc
{
r.DefaultCellStyle.ForeColor = Color.Gray;
}
else if (Convert.ToInt32(r.Cells["colTrangThai"].Value) == 3) // Đang chờ vào làm
{
r.DefaultCellStyle.ForeColor = Color.Blue;
}
else
{
r.DefaultCellStyle.ForeColor = Color.Black;
}
}
}
