public bool ThemChiTietChamCong(clsChiTietChamCong_DTO ChiTiet) { SqlConnection conn = ThaoTacDuLieu.TaoVaMoKetNoi(); string sql = string.Format("INSERT INTO CHITIETCHAMCONG(MACC,MANV) VALUES('{0}','{1}')", ChiTiet.MaCC, ChiTiet.MaNV); 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)); } }
//public int LaySoLuong() //{ // clsChiTietChamCong_DAO DAO = new clsChiTietChamCong_DAO(); // return DAO.LaySoLuong(); //} //public bool ThemBangChamCong(clsChamCong_DTO lsChamCong) //{ // clsChiTietChamCong_DAO DAO = new clsChiTietChamCong_DAO(); // return DAO.ThemBangChamCong(lsChamCong); //} //public int LaySoLuongBangChamCong() //{ // clsChiTietChamCong_DAO DAO = new clsChiTietChamCong_DAO(); // return DAO.LaySoLuongBangChamCong(); //} public bool ThemChiTietChamCong(clsChiTietChamCong_DTO ChiTiet) { clsChiTietChamCong_DAO DAO = new clsChiTietChamCong_DAO(); return(DAO.ThemChiTietChamCong(ChiTiet)); }
public List <clsChiTietChamCong_DTO> LayChiTiet(string MaCC) { SqlConnection conn = ThaoTacDuLieu.TaoVaMoKetNoi(); string sql = string.Format("SELECT HO,TEN,NHANVIEN.MANV,PHONG,D1,D2,D3,D4,D5,D6,D7,D8,D9,D10,D11,D12,D13,D14,D15,D16,D17,D18,D19,D20,D21,D22,D23,D24,D25,D26,D27,D28,D29,D30,D31 FROM CHITIETCHAMCONG,NHANVIEN WHERE NHANVIEN.MANV = CHITIETCHAMCONG.MANV AND MACC = '{0}' AND TRANGTHAI = 1", MaCC); SqlCommand cmd = ThaoTacDuLieu.TaoDoiTuongTruyVan(sql, conn); SqlDataReader dr = cmd.ExecuteReader(); List <clsChiTietChamCong_DTO> lsCT = new List <clsChiTietChamCong_DTO>(); while (dr.Read()) { clsChiTietChamCong_DTO CT = new clsChiTietChamCong_DTO(); clsNhanVien_DTO NV = new clsNhanVien_DTO(); if (!dr.IsDBNull(0)) { NV.Ho = dr.GetString(0); } if (!dr.IsDBNull(1)) { NV.Ten = dr.GetString(1); } if (!dr.IsDBNull(2)) { NV.MaNV = dr.GetString(2); } if (!dr.IsDBNull(3)) { NV.PhongBan = dr.GetString(3); } if (!dr.IsDBNull(4)) { CT.D1 = dr.GetString(4); } if (!dr.IsDBNull(5)) { CT.D2 = dr.GetString(5); } if (!dr.IsDBNull(6)) { CT.D3 = dr.GetString(6); } if (!dr.IsDBNull(7)) { CT.D4 = dr.GetString(7); } if (!dr.IsDBNull(8)) { CT.D5 = dr.GetString(8); } if (!dr.IsDBNull(9)) { CT.D6 = dr.GetString(9); } if (!dr.IsDBNull(10)) { CT.D7 = dr.GetString(10); } if (!dr.IsDBNull(11)) { CT.D8 = dr.GetString(11); } if (!dr.IsDBNull(12)) { CT.D9 = dr.GetString(12); } if (!dr.IsDBNull(13)) { CT.D10 = dr.GetString(13); } if (!dr.IsDBNull(14)) { CT.D11 = dr.GetString(14); } if (!dr.IsDBNull(15)) { CT.D12 = dr.GetString(15); } if (!dr.IsDBNull(16)) { CT.D13 = dr.GetString(16); } if (!dr.IsDBNull(17)) { CT.D14 = dr.GetString(17); } if (!dr.IsDBNull(18)) { CT.D15 = dr.GetString(18); } if (!dr.IsDBNull(19)) { CT.D16 = dr.GetString(19); } if (!dr.IsDBNull(20)) { CT.D17 = dr.GetString(20); } if (!dr.IsDBNull(21)) { CT.D18 = dr.GetString(21); } if (!dr.IsDBNull(22)) { CT.D19 = dr.GetString(22); } if (!dr.IsDBNull(23)) { CT.D20 = dr.GetString(23); } if (!dr.IsDBNull(24)) { CT.D21 = dr.GetString(24); } if (!dr.IsDBNull(25)) { CT.D22 = dr.GetString(25); } if (!dr.IsDBNull(26)) { CT.D23 = dr.GetString(26); } if (!dr.IsDBNull(27)) { CT.D24 = dr.GetString(27); } if (!dr.IsDBNull(28)) { CT.D25 = dr.GetString(28); } if (!dr.IsDBNull(29)) { CT.D26 = dr.GetString(29); } if (!dr.IsDBNull(30)) { CT.D27 = dr.GetString(30); } if (!dr.IsDBNull(31)) { CT.D28 = dr.GetString(31); } if (!dr.IsDBNull(32)) { CT.D29 = dr.GetString(32); } if (!dr.IsDBNull(33)) { CT.D30 = dr.GetString(33); } if (!dr.IsDBNull(34)) { CT.D31 = dr.GetString(34); } CT.NhanVien = NV; lsCT.Add(CT); } ThaoTacDuLieu.DongKetNoi(conn); return(lsCT); }