public string LoadData_Show_ChamCong(ChamCongDTO chamCongDTO)
{
string sql = @"select a.BoPhanID, a.NhanVienID, b.MaNV, b.TenNV, c.ChamCongID,c.NgayChamCong, c.NgayCongChuan,c.NgayDiLam,c.NgayKhongLuong, c.NgayNghiLe, c.NgayNghiPhepTinhLuong, c.NgayTinhLuong,
c.ChamCongID, c.GhiChu, c.TrangThai, c.Thang
from NhanVienBoPhan a inner join NhanVien b on a.NhanVienID = b.NhanVienID
left join ChamCong c on c.BoPhanID = a.BoPhanID and c.NhanVienID = a.NhanVienID and c.Thang = '" + chamCongDTO.Thang + @"'
Where a.BoPhanID = '" + chamCongDTO.BoPhanID + "'";
return(sql);
}
private void btnHienThi_Click(object sender, EventArgs e)
{
try
{
ChamCongDTO chamCongDTO = new ChamCongDTO();
chamCongDTO.Thang = dtpThang.Value.ToString("yyyyMM");
chamCongDTO.BoPhanID = int.Parse(cmbBoPhan.SelectedValue.ToString());
DataTable dt = ChamCongBUS.Instance.LoadData_Show_ChamCong(chamCongDTO);
bindingSource1.DataSource = dt;
// Customize Cell Status
}
catch (Exception)
{
MessageBox.Show("Lỗi khi hiển thị danh sách chấm công!");
}
}
public DataTable LoadData_Show_ChamCong(ChamCongDTO chamCongDTO)
{
DataTable dt = Core.GetData(ChamCongDAO.Instance.LoadData_Show_ChamCong(chamCongDTO));
return(dt);
}
//Xóa
public string DeleteChamCong(ChamCongDTO chamcong)
{
return(cc.DeleteChamCong(chamcong));
}
//Sửa
public string UpdateChamCong(ChamCongDTO chamcong)
{
return(cc.UpdateChamCong(chamcong));
}
//thêm
public string InsertChamCong(ChamCongDTO chamcong)
{
return(cc.InsertChamCong(chamcong));
}
//Xóa phòng thông tin chấm công
public string DeleteChamCong(ChamCongDTO chamcong)
{
string Query = "delete ChamCong where MaNV='" + chamcong._MaNV + "'";
return(Query);
}
//Sửa thông tin cá nhân
public string UpdateChamCong(ChamCongDTO chamcong)
{
string query = "update ChamCong set MaNV='" + chamcong._MaNV + "',Thang='" + chamcong._Thang + "', Nam='" + chamcong._Nam + "',SoNgayCong='" + chamcong._SoNgayCong + "',SoNgayNghi='" + chamcong._SoNgayNgi + "' where MaNV='" + chamcong._MaNV + "' ";
return(query);
}
//Thêm thông tin chấm công
public string InsertChamCong(ChamCongDTO chamcong)
{
string query = "insert into ChamCong(MaNV,Thang, Nam, SoNgayCong, SoNgayNghi) values('" + chamcong._MaNV + "','" + chamcong._Thang + "','" + chamcong._Nam + "','" + chamcong._SoNgayCong + "','" + chamcong._SoNgayNgi + "') ";
return(query);
}
