public clsChamCong_DTO LayBangChamCong(int Thang, int Nam, string MaPB) { SqlConnection conn = ThaoTacDuLieu.TaoVaMoKetNoi(); string sql = string.Format("SELECT MACC FROM CHAMCONG WHERE THANG = {0} AND NAM = {1} AND PHONG = '{2}'", Thang, Nam, MaPB); SqlCommand cmd = ThaoTacDuLieu.TaoDoiTuongTruyVan(sql, conn); SqlDataReader dr = cmd.ExecuteReader(); clsChamCong_DTO CC = new clsChamCong_DTO(); while (dr.Read()) { if (!dr.IsDBNull(0)) { CC.MaCC = dr.GetString(0); } if (!dr.IsDBNull(1)) { CC.Thang = dr.GetInt32(1); } if (!dr.IsDBNull(2)) { CC.Nam = dr.GetInt32(2); } if (!dr.IsDBNull(3)) { CC.Phong = dr.GetString(3); } } ThaoTacDuLieu.DongKetNoi(conn); return(CC); }
public List <clsChamCong_DTO> LayBangChamCong() { SqlConnection conn = ThaoTacDuLieu.TaoVaMoKetNoi(); string sql = "SELECT * FROM CHAMCONG"; SqlCommand cmd = ThaoTacDuLieu.TaoDoiTuongTruyVan(sql, conn); List <clsChamCong_DTO> lsCC = new List <clsChamCong_DTO>(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { clsChamCong_DTO CC = new clsChamCong_DTO(); if (!dr.IsDBNull(0)) { CC.MaCC = dr.GetString(0); } if (!dr.IsDBNull(1)) { CC.Thang = dr.GetInt32(1); } if (!dr.IsDBNull(2)) { CC.Nam = dr.GetInt32(2); } if (!dr.IsDBNull(3)) { CC.Phong = dr.GetString(3); } lsCC.Add(CC); } ThaoTacDuLieu.DongKetNoi(conn); return(lsCC); }
public bool ThemBangChamCong(clsChamCong_DTO ChamCong) { SqlConnection conn = ThaoTacDuLieu.TaoVaMoKetNoi(); string sql = string.Format("INSERT INTO CHAMCONG(MACC,THANG,NAM,PHONG) VALUES('{0}',{1},{2},'{3}')", ChamCong.MaCC, ChamCong.Thang, ChamCong.Nam, ChamCong.Phong); SqlCommand cmd = ThaoTacDuLieu.TaoDoiTuongTruyVan(sql, conn); int kq = cmd.ExecuteNonQuery(); ThaoTacDuLieu.DongKetNoi(conn); return(kq > 0); }
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)); } }
private void btnLuu_Click(object sender, EventArgs e) { List <clsChamCong_DTO> lsChamCong = new List <clsChamCong_DTO>(); for (int i = 0; i < dgvBangChamCong.Rows.Count; i++) { clsChamCong_DTO ChamCong = new clsChamCong_DTO(); ChamCong.MaNV = dgvBangChamCong.Rows[i].Cells["colMaNV"].Value.ToString(); ChamCong.Thang = ucTL.Thang; ChamCong.Nam = ucTL.Nam; ChamCong.D1 = dgvBangChamCong.Rows[i].Cells["col1"].Value.ToString(); ChamCong.D2 = dgvBangChamCong.Rows[i].Cells["col2"].Value.ToString(); ChamCong.D3 = dgvBangChamCong.Rows[i].Cells["col3"].Value.ToString(); ChamCong.D4 = dgvBangChamCong.Rows[i].Cells["col4"].Value.ToString(); ChamCong.D5 = dgvBangChamCong.Rows[i].Cells["col5"].Value.ToString(); ChamCong.D6 = dgvBangChamCong.Rows[i].Cells["col6"].Value.ToString(); ChamCong.D7 = dgvBangChamCong.Rows[i].Cells["col7"].Value.ToString(); ChamCong.D8 = dgvBangChamCong.Rows[i].Cells["col8"].Value.ToString(); ChamCong.D9 = dgvBangChamCong.Rows[i].Cells["col9"].Value.ToString(); ChamCong.D10 = dgvBangChamCong.Rows[i].Cells["col10"].Value.ToString(); ChamCong.D11 = dgvBangChamCong.Rows[i].Cells["col11"].Value.ToString(); ChamCong.D12 = dgvBangChamCong.Rows[i].Cells["col12"].Value.ToString(); ChamCong.D13 = dgvBangChamCong.Rows[i].Cells["col13"].Value.ToString(); ChamCong.D14 = dgvBangChamCong.Rows[i].Cells["col14"].Value.ToString(); ChamCong.D15 = dgvBangChamCong.Rows[i].Cells["col15"].Value.ToString(); ChamCong.D16 = dgvBangChamCong.Rows[i].Cells["col16"].Value.ToString(); ChamCong.D17 = dgvBangChamCong.Rows[i].Cells["col17"].Value.ToString(); ChamCong.D18 = dgvBangChamCong.Rows[i].Cells["col18"].Value.ToString(); ChamCong.D19 = dgvBangChamCong.Rows[i].Cells["col19"].Value.ToString(); ChamCong.D20 = dgvBangChamCong.Rows[i].Cells["col20"].Value.ToString(); ChamCong.D21 = dgvBangChamCong.Rows[i].Cells["col21"].Value.ToString(); ChamCong.D22 = dgvBangChamCong.Rows[i].Cells["col22"].Value.ToString(); ChamCong.D23 = dgvBangChamCong.Rows[i].Cells["col23"].Value.ToString(); ChamCong.D24 = dgvBangChamCong.Rows[i].Cells["col24"].Value.ToString(); ChamCong.D25 = dgvBangChamCong.Rows[i].Cells["col25"].Value.ToString(); ChamCong.D26 = dgvBangChamCong.Rows[i].Cells["col26"].Value.ToString(); ChamCong.D27 = dgvBangChamCong.Rows[i].Cells["col27"].Value.ToString(); if (DateTime.DaysInMonth(ucTL.Nam, ucTL.Thang) == 28) { ChamCong.D28 = dgvBangChamCong.Rows[i].Cells["col28"].Value.ToString(); } else if (DateTime.DaysInMonth(ucTL.Nam, ucTL.Thang) == 29) { ChamCong.D28 = dgvBangChamCong.Rows[i].Cells["col28"].Value.ToString(); ChamCong.D29 = dgvBangChamCong.Rows[i].Cells["col29"].Value.ToString(); } else if (DateTime.DaysInMonth(ucTL.Nam, ucTL.Thang) == 30) { ChamCong.D28 = dgvBangChamCong.Rows[i].Cells["col28"].Value.ToString(); ChamCong.D29 = dgvBangChamCong.Rows[i].Cells["col29"].Value.ToString(); ChamCong.D30 = dgvBangChamCong.Rows[i].Cells["col30"].Value.ToString(); } else if (DateTime.DaysInMonth(ucTL.Nam, ucTL.Thang) == 31) { ChamCong.D28 = dgvBangChamCong.Rows[i].Cells["col28"].Value.ToString(); ChamCong.D29 = dgvBangChamCong.Rows[i].Cells["col29"].Value.ToString(); ChamCong.D30 = dgvBangChamCong.Rows[i].Cells["col30"].Value.ToString(); ChamCong.D30 = dgvBangChamCong.Rows[i].Cells["col31"].Value.ToString(); } ChamCong.Thang = ucTL.Thang; ChamCong.Nam = ucTL.Nam; lsChamCong.Add(ChamCong); } clsChamCong_BUS BUS = new clsChamCong_BUS(); if (BUS.ThemBangChamCong(DateTime.DaysInMonth(ucTL.Nam, ucTL.Thang), lsChamCong)) { MessageBox.Show("Đã lưu dữ liệu chấm công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); _btnLuu = true; this.Hide(); frm_PhongBan.Close(); } else { MessageBox.Show("Lỗi", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public bool ThemBangChamCong(clsChamCong_DTO ChamCong) { clsChamCong_DAO DAO = new clsChamCong_DAO(); return(DAO.ThemBangChamCong(ChamCong)); }