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