public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
Report_Employee_BirthdayList rpt = new Report_Employee_BirthdayList();
rpt.Site = this.Site;
return(rpt);
}
public override ReportDocument GenerateReport()
{
DataSet.EmployeeDetail ds = new DataSet.EmployeeDetail();
DBFilter empInfoFilter = new DBFilter();
empInfoFilter.add(new Match("empDateOfJoin", "<=", BirthdayTo));
DBFilter empTerminationFilter = new DBFilter();
empTerminationFilter.add(new MatchField(EEmpPersonalInfo.db.dbclass.tableName + ".EmpID", "et.EmpID"));
empTerminationFilter.add(new Match("et.EmpTermLastDate", "<", BirthdayFrom));
empInfoFilter.add(new Exists(EEmpTermination.db.dbclass.tableName + " et", empTerminationFilter, true));
foreach (EEmpPersonalInfo empInfo in empList)
{
if (EEmpPersonalInfo.db.select(dbConn, empInfo))
if (!empInfo.EmpDateOfBirth.Ticks.Equals(0))
{
int yearFrom = Convert.ToInt32(Utility.YearDifference(empInfo.EmpDateOfBirth, BirthdayFrom));
while (empInfo.EmpDateOfBirth.AddYears(yearFrom) < BirthdayFrom)
yearFrom++;
if (empInfo.EmpDateOfBirth.AddYears(yearFrom) <= BirthdayTo)
{
DataSet.EmployeeDetail.employeedetailRow row = ds.employeedetail.NewemployeedetailRow();
row.EmpID = empInfo.EmpID;
row.EmpAlias = empInfo.EmpAlias;
row.EmpChiFullName = empInfo.EmpChiFullName;
row.EmpDateOfBirth = empInfo.EmpDateOfBirth;
row.EmpDateOfJoin = empInfo.EmpDateOfJoin;
row.EmpEngOtherName = empInfo.EmpEngOtherName;
row.EmpEngSurname = empInfo.EmpEngSurname;
row.EmpEngFullName = empInfo.EmpEngFullName;
row.EmpGender = empInfo.EmpGender;
row.EmpNo = empInfo.EmpNo;
row.EmpServiceDate = empInfo.EmpServiceDate;
row.EmpStatus = empInfo.EmpStatus;
ds.employeedetail.Rows.Add(row);
}
}
}
if (reportDocument == null)
{
reportDocument = new ReportTemplate.Report_Employee_BirthdayList();
}
else
{
}
reportDocument.SetDataSource(ds);
reportDocument.SetParameterValue("BirthdayFrom", BirthdayFrom.ToString("yyyy-MM-dd"));
reportDocument.SetParameterValue("BirthdayTo", BirthdayTo.ToString("yyyy-MM-dd"));
reportDocument.SetParameterValue("ShowDisplayOfBirth", ShowDisplayYearOfBirth);
return reportDocument;
}
