public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
Report_Employee_List rpt = new Report_Employee_List();
rpt.Site = this.Site;
return(rpt);
}
public override ReportDocument GenerateReport()
{
if (EmpList.Count > 0)
{
DataSet.EmployeeDetail ds = new DataSet.EmployeeDetail();
foreach (int EmpID in EmpList)
{
EmployeeDetailProcess.ImportEmployeeDetailRow(dbConn, ds.employeedetail, EmpID, AppUtils.ServerDateTime().Date);
}
//System.Data.DataTable table = null;
//foreach (int EmpID in EmpList)
//{
// string select = "P.*,EmpPos.*,Pos.*,Comp.* ";
// string from = "from EmpPersonalInfo P LEFT JOIN EmpPositionInfo EmpPos ON P.EmpID=EmpPos.EmpID AND EmpPos.EmpPosEffTo IS NULL LEFT JOIN Position Pos ON EmpPos.PositionID=Pos.PositionID LEFT JOIN Company Comp ON EmpPos.CompanyID=Comp.CompanyID";
// DBFilter filter = new DBFilter();
// OR or = new OR();
// filter.add(new Match("P.EmpID", EmpID));
// System.Data.DataTable resulttable = filter.loadData(null, select, from);
// if (table == null)
// table = resulttable;
// else
// table.Merge(resulttable);
//}
//DBAESEncryptStringFieldAttribute.decode(table, "EmpHKID", true);
//DBAESEncryptStringFieldAttribute.decode(table, "EmpPassportNo", false);
if (reportDocument == null)
{
reportDocument = new ReportTemplate.Report_Employee_List();
}
else
{
}
reportDocument.SetDataSource(ds);
return(reportDocument);
}
else
{
return(null);
}
}
