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