private void dgvChamCong_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (dgvChamCong.Columns[e.ColumnIndex].Name == "colTenBangChamCong")
{
dgvChamCong.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = "Bảng chấm công tháng " + dgvChamCong.Rows[e.RowIndex].Cells[1].Value.ToString() + " năm " + dgvChamCong.Rows[e.RowIndex].Cells[2].Value.ToString();
}
if (dgvChamCong.Columns[e.ColumnIndex].Name == "colPhong")
{
clsPhongBan_DTO PB = lsPB.First(u => u.MAPB == e.Value.ToString());
e.Value = PB.TENPB;
}
}
private void ucTinhLuong_Load(object sender, EventArgs e)
{
clsPhongBan_BUS BUSPB = new clsPhongBan_BUS();
List <clsPhongBan_DTO> lsPhongBan = BUSPB.LayDanhSachPhongBan();
clsPhongBan_DTO pb = new clsPhongBan_DTO();
pb.TENPB = "Tất cả";
pb.MAPB = "0";
lsPhongBan.Insert(0, pb);
cboPhongBan.DataSource = lsPhongBan;
cboPhongBan.DisplayMember = "TENPB";
cboPhongBan.ValueMember = "MAPB";
}
private void dgvBangChamCong_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (dgvBangChamCong.Columns[e.ColumnIndex].Name == "colMaPB")
{
clsPhongBan_DTO PB = lsPB.First(u => u.MAPB == e.Value.ToString());
e.Value = PB.TENPB;
}
if (dgvBangChamCong.Columns[e.ColumnIndex].Name != "colMaNV" && dgvBangChamCong.Columns[e.ColumnIndex].Name != "ColHo" && dgvBangChamCong.Columns[e.ColumnIndex].Name != "colTen" && dgvBangChamCong.Columns[e.ColumnIndex].Name != "colMaPB" && dgvBangChamCong.Columns[e.ColumnIndex].Name != "colMaCC")
{
int Ngay = Convert.ToInt32(dgvBangChamCong.Columns[e.ColumnIndex].Name.ToString().Replace("col", ""));
DateTime dt = new DateTime(ucTL.Nam, ucTL.Thang, Ngay);
//if (dgvBangChamCong.Columns[e.ColumnIndex].ReadOnly == true)
//{
// dgvBangChamCong.Columns[e.ColumnIndex].DefaultCellStyle.BackColor = Color.Gray;
//}
if (dt.DayOfWeek == 0)
{
dgvBangChamCong.Columns[e.ColumnIndex].DefaultCellStyle.ForeColor = Color.Red;
dgvBangChamCong.Columns[e.ColumnIndex].DefaultCellStyle.BackColor = Color.Honeydew;
dgvBangChamCong.Columns[e.ColumnIndex].ReadOnly = true;
}
//if (dt.DayOfWeek != 0)
if (dt.DayOfWeek != 0 && dgvBangChamCong.Columns[e.ColumnIndex].ReadOnly == false)
{
// Nếu nghỉ có phép hoặc không phép
if (Convert.ToString(e.Value) == "P" || Convert.ToString(e.Value) == "K")
{
dgvBangChamCong.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.BackColor = Color.Purple;
dgvBangChamCong.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.ForeColor = Color.Wheat;
}
if (Convert.ToString(e.Value) == "")
{
dgvBangChamCong.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.BackColor = Color.Green;
dgvBangChamCong.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.ForeColor = Color.Black;
}
//Regex invalidCharsRegex = new Regex(@"(?<=^| )\d+(\.\d+)?(?=$| )|(?<=^| )\.\d+(?=$| )");
//if (invalidCharsRegex.IsMatch(Convert.ToString(e.Value)))
//{
// dgvBangChamCong.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.BackColor = Color.Green;
// dgvBangChamCong.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.ForeColor = Color.White;
//}
}
//else
// dgvBangChamCong.Rows[e.RowIndex].Cells[e.ColumnIndex].ReadOnly = true;
}
//clsPhongBan_BUS BUSPB = new clsPhongBan_BUS();
//List<clsPhongBan_DTO> lsPB = BUSPB.LayDanhSachPhongBan();
//clsPhongBan_DTO dtoPB = lsPB.First(u => u.MAPB == e.Value);
//e.Value = dtoPB.TENPB;
}
private void btnDongY_Click(object sender, EventArgs e)
{
clsChamCong_BUS BUSCC = new clsChamCong_BUS();
clsNhanVien_BUS BUSNV = new clsNhanVien_BUS();
clsChiTietChamCong_BUS BUSCTCC = new clsChiTietChamCong_BUS();
clsChamCong_DTO ChamCong = new clsChamCong_DTO();
List <clsNhanVien_DTO> lsNhanVien = new List <clsNhanVien_DTO>();
DataGridViewRow r = dgvPhongBan.CurrentRow;
ChamCong.MaCC = "CC" + (BUSCC.LaySoLuong() + 1).ToString();
ChamCong.Thang = ucTL.Thang;
ChamCong.Nam = ucTL.Nam;
ChamCong.Phong = r.Cells[0].Value.ToString();
//Thêm dữ liệu vào CHAMCONG
if (BUSCC.KiemTraPhongChamCong(ChamCong.Thang, ChamCong.Nam, ChamCong.Phong) == false)
{
BUSCC.ThemBangChamCong(ChamCong);
DataGridView dgvChamCong = ucTL.Controls.Find("dgvChamCong", true).FirstOrDefault() as DataGridView;
dgvChamCong.DataSource = BUSCC.LayBangChamCong();
// Lấy phòng ban vừa được chọn để chấm công
clsPhongBan_DTO PB = new clsPhongBan_DTO();
PB.MAPB = ChamCong.Phong;
List <clsPhongBan_DTO> lsPB = new List <clsPhongBan_DTO>();
lsPB.Add(PB);
//Lấy danh sách nhân viên theo phòng ban
lsNhanVien = BUSNV.LayDanhSachNhanVienCC(lsPB);
for (int i = 0; i < lsNhanVien.Count; i++)
{
clsChiTietChamCong_DTO ChiTietCC = new clsChiTietChamCong_DTO();
ChiTietCC.MaCC = ChamCong.MaCC;
ChiTietCC.MaNV = lsNhanVien[i].MaNV;
BUSCTCC.ThemChiTietChamCong(ChiTietCC);
this.Close();
}
clsNhatKy_BUS BUSNK = new clsNhatKy_BUS();
BUSNK.ThemNhatKy(Program.NhanVien_Login.TaiKhoan, DateTime.Now, string.Format("{0} đã tạo bảng chấm công {1}", Program.NhanVien_Login.TaiKhoan, ChamCong.MaCC));
}
else
{
MessageBox.Show(string.Format("Đã chấm công cho phòng {0} tháng {1} năm {2}", r.Cells[1].Value.ToString(), ChamCong.Thang, ChamCong.Nam));
}
}
public List <clsPhongBan_DTO> LayDanhSachPhongBan()
{
SqlConnection conn = ThaoTacDuLieu.TaoVaMoKetNoi();
string sql = "SELECT * FROM PHONGBAN ";
SqlCommand cmd = ThaoTacDuLieu.TaoDoiTuongTruyVan(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
List <clsPhongBan_DTO> lsPhongBan = new List <clsPhongBan_DTO>();
while (dr.Read())
{
clsPhongBan_DTO PhongBan = new clsPhongBan_DTO();
if (!dr.IsDBNull(0))
{
PhongBan.MAPB = dr.GetString(0);
}
if (!dr.IsDBNull(1))
{
PhongBan.TENPB = dr.GetString(1);
}
lsPhongBan.Add(PhongBan);
}
ThaoTacDuLieu.DongKetNoi(conn);
return(lsPhongBan);
}
private void LoadCbo()
{
//Tỉnh
clsTinhQuanHuyen_BUS BUSQH = new clsTinhQuanHuyen_BUS();
cboTinh.DataSource = BUSQH.LayDanhSachTinhThanh();
cboTinh.DisplayMember = "TENTINH";
cboTinh.ValueMember = "MATINH";
cboTinh.SelectedIndex = 0;
//Quận Huyện
clsTinhQuanHuyen_BUS BUSTT = new clsTinhQuanHuyen_BUS();
cboQuanHuyen.DataSource = BUSTT.LayDanhSachQuanHuyen(cboTinh.SelectedValue.ToString());
cboQuanHuyen.DisplayMember = "TENQH";
cboQuanHuyen.ValueMember = "MAQH";
//quốc tịch
clsQuocTich_BUS BUSQT = new clsQuocTich_BUS();
cboQuocTich.DataSource = BUSQT.LayDSQuocTich();
cboQuocTich.DisplayMember = "TENQT";
cboQuocTich.ValueMember = "MAQT";
//tôn giáo
clsTonGiao_BUS BUSTG = new clsTonGiao_BUS();
cboTonGiao.DataSource = BUSTG.LayDanhSachTonGiao();
cboTonGiao.DisplayMember = "TENTG";
cboTonGiao.ValueMember = "MATG";
cboTonGiao.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cboTonGiao.AutoCompleteSource = AutoCompleteSource.ListItems;
//Mối quan hệ
clsMoiQuanHe_BUS BUSMQH = new clsMoiQuanHe_BUS();
//Phòng Ban
clsPhongBan_BUS BUSPB = new clsPhongBan_BUS();
cboPhongBan.DataSource = BUSPB.LayDanhSachPhongBan();
cboPhongBan.DisplayMember = "TENPB";
cboPhongBan.ValueMember = "MAPB";
//tìm kiếm
List <clsPhongBan_DTO> lsPhongBan_TK = BUSPB.LayDanhSachPhongBan();
clsPhongBan_DTO pb = new clsPhongBan_DTO();
pb.TENPB = "Tất cả";
pb.MAPB = "0";
lsPhongBan_TK.Insert(0, pb);
cboPhongBan_TK.DataSource = lsPhongBan_TK;
cboPhongBan_TK.DisplayMember = "TENPB";
cboPhongBan_TK.ValueMember = "MAPB";
//chức vụ
clsChucVu_BUS BUSCV = new clsChucVu_BUS();
cboChucVu.DataSource = BUSCV.LayDanhSachChucVu();
cboChucVu.DisplayMember = "TENCV";
cboChucVu.ValueMember = "MACV";
//Học Vấn
clsBangCap_BUS BUSBC = new clsBangCap_BUS();
cboTrinhDo.DataSource = BUSBC.LayDanhSachBangCap();
cboTrinhDo.DisplayMember = "TENBC";
cboTrinhDo.ValueMember = "MABC";
//bacluong
clsBacLuong_BUS BUSBACLUONG = new clsBacLuong_BUS();
cboBacLuong.DataSource = BUSBACLUONG.LayDSBacLuong();
cboBacLuong.ValueMember = "BAC";
cboBacLuong.DisplayMember = "TENBAC";
//dân tộc
clsDanToc_BUS BUSDT = new clsDanToc_BUS();
cboDanToc.DataSource = BUSDT.LayDSDanToc();
cboDanToc.ValueMember = "MaDT";
cboDanToc.DisplayMember = "TenDT";
cboDanToc.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cboDanToc.AutoCompleteSource = AutoCompleteSource.ListItems;
}
