public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
Report_Employee_HeadCount rpt = new Report_Employee_HeadCount();
rpt.Site = this.Site;
return(rpt);
}
// End 0000185, KuangWei, 2015-05-05
// Start 0000185, KuangWei, 2015-05-05
public override ReportDocument GenerateReport()
{
if (CurrentDate.Ticks != 0 && ReferenceDate.Ticks != 0)
{
dataSet = new DataSet.HeadCountSummarySet();
// Get Total PreviousCount
DBFilter EmpReferencePosFilter = new DBFilter();
EmpReferencePosFilter.add(new Match("EmpPosEffFr", "<=", ReferenceDate));
OR orReferencePosEffToDate = new OR();
orReferencePosEffToDate.add(new Match("EmpPosEffTo", ">=", ReferenceDate));
orReferencePosEffToDate.add(new NullTerm("EmpPosEffTo"));
EmpReferencePosFilter.add(orReferencePosEffToDate);
DBFilter empReferenceTerminationFilter = new DBFilter();
empReferenceTerminationFilter.add(new Match("EmpTermLastDate", "<", ReferenceDate));
EmpReferencePosFilter.add(new IN("not empid", "Select empid from EmpTermination", empReferenceTerminationFilter));
ArrayList empReferenceDatePosList = EEmpPositionInfo.db.select(dbConn, EmpReferencePosFilter);
foreach (EEmpPositionInfo empPos in empReferenceDatePosList)
{
foreach (EEmpPersonalInfo obj in empList)
{
if (obj.EmpID == empPos.EmpID)
{
EEmpPersonalInfo empInfo = new EEmpPersonalInfo();
empInfo.EmpID = empPos.EmpID;
if (EEmpPersonalInfo.db.select(dbConn, empInfo))
{
if (empInfo.EmpGender.Equals(Gender) || Gender.Equals(string.Empty))
{
DataSet.HeadCountSummarySet.HeadCountSummaryRow row = CreateHeadCountRow(empPos.CompanyID, empPos.EmpPosID);
row.PreviousCount = 1;
dataSet.HeadCountSummary.Rows.Add(row);
}
}
}
}
}
// Get Total CurrentCount
DBFilter EmpCurrentPosFilter = new DBFilter();
EmpCurrentPosFilter.add(new Match("EmpPosEffFr", "<=", CurrentDate));
OR orCurrentPosEffToDate = new OR();
orCurrentPosEffToDate.add(new Match("EmpPosEffTo", ">=", CurrentDate));
orCurrentPosEffToDate.add(new NullTerm("EmpPosEffTo"));
EmpCurrentPosFilter.add(orCurrentPosEffToDate);
DBFilter empCurrentTerminationFilter = new DBFilter();
empCurrentTerminationFilter.add(new Match("EmpTermLastDate", "<", CurrentDate));
EmpCurrentPosFilter.add(new IN("not empid", "Select empid from EmpTermination", empCurrentTerminationFilter));
ArrayList empCurrentDatePosList = EEmpPositionInfo.db.select(dbConn, EmpCurrentPosFilter);
foreach (EEmpPositionInfo empPos in empCurrentDatePosList)
{
foreach (EEmpPersonalInfo obj in empList)
{
if (obj.EmpID == empPos.EmpID)
{
EEmpPersonalInfo empInfo = new EEmpPersonalInfo();
empInfo.EmpID = empPos.EmpID;
if (EEmpPersonalInfo.db.select(dbConn, empInfo))
{
if (empInfo.EmpGender.Equals(Gender) || Gender.Equals(string.Empty))
{
DataSet.HeadCountSummarySet.HeadCountSummaryRow row = CreateHeadCountRow(empPos.CompanyID, empPos.EmpPosID);
row.CurrentCount = 1;
dataSet.HeadCountSummary.Rows.Add(row);
}
}
}
}
}
// Get New Join Count and transfer count
DBFilter EmpNewPosFilter = new DBFilter();
EmpNewPosFilter.add(new Match("EmpPosEffFr", ">", ReferenceDate));
EmpNewPosFilter.add(new Match("EmpPosEffFr", "<=", CurrentDate));
ArrayList empNewPosList = EEmpPositionInfo.db.select(dbConn, EmpNewPosFilter);
foreach (EEmpPositionInfo empPos in empNewPosList)
{
foreach (EEmpPersonalInfo obj in empList)
{
if (obj.EmpID == empPos.EmpID)
{
EEmpPersonalInfo empInfo = new EEmpPersonalInfo();
empInfo.EmpID = empPos.EmpID;
if (EEmpPersonalInfo.db.select(dbConn, empInfo))
{
if (empInfo.EmpGender.Equals(Gender) || Gender.Equals(string.Empty))
{
DataSet.HeadCountSummarySet.HeadCountSummaryRow row = CreateHeadCountRow(empPos.CompanyID, empPos.EmpPosID);
// check2 if have previous position change
{
DBFilter previousEmpPosFilter = new DBFilter();
previousEmpPosFilter.add(new Match("EmpID", empPos.EmpID));
previousEmpPosFilter.add(new Match("EmpPosEffTo", "<", empPos.EmpPosEffFr));
previousEmpPosFilter.add("EmpPosEffFr", false);
ArrayList previousEmpPosList = EEmpPositionInfo.db.select(dbConn, previousEmpPosFilter);
if (previousEmpPosList.Count > 0)
{
EEmpPositionInfo empPreviousPos = (EEmpPositionInfo)previousEmpPosList[0];
EHierarchyElement hPreviousElement = getFirstLevelHierarchyElement(empPos.EmpPosID);
//if (row.HElementID > 0)
if (empPos.CompanyID != empPreviousPos.CompanyID || row.HElementID != hPreviousElement.HElementID)
{
row.TransferInCount = 1;
if (empPreviousPos.EmpPosEffFr <= (CurrentDate < ReferenceDate ? CurrentDate : ReferenceDate))
{
DataSet.HeadCountSummarySet.HeadCountSummaryRow previousrow = CreateHeadCountRow(empPreviousPos.CompanyID, empPreviousPos.EmpPosID);
previousrow.TransferOutCount = 1;
dataSet.HeadCountSummary.Rows.Add(previousrow);
}
}
}
else
{
row.NewJoinCount = 1;
}
}
// check if have next position change
if (empPos.EmpPosEffFr < empPos.EmpPosEffTo)
{
DBFilter nextEmpPosFilter = new DBFilter();
nextEmpPosFilter.add(new Match("EmpID", empPos.EmpID));
nextEmpPosFilter.add(new Match("EmpPosEffFr", ">", empPos.EmpPosEffTo));
nextEmpPosFilter.add(new Match("EmpPosEffFr", "<=", CurrentDate));
nextEmpPosFilter.add("EmpPosEffFr", true);
ArrayList nextEmpPosList = EEmpPositionInfo.db.select(dbConn, nextEmpPosFilter);
if (nextEmpPosList.Count > 0)
{
EEmpPositionInfo empNextPos = (EEmpPositionInfo)nextEmpPosList[0];
EHierarchyElement hNextElement = getFirstLevelHierarchyElement(empPos.EmpPosID);
//if (row.HElementID != 0)
if (empPos.CompanyID != empNextPos.CompanyID || row.HElementID != hNextElement.HElementID)
{
row.TransferOutCount = 1;
if (empNextPos.EmpPosEffTo.Ticks.Equals(0) || empNextPos.EmpPosEffTo > (CurrentDate > ReferenceDate ? CurrentDate : ReferenceDate))
{
DataSet.HeadCountSummarySet.HeadCountSummaryRow nextRow = CreateHeadCountRow(empNextPos.CompanyID, empNextPos.EmpPosID);
nextRow.TransferInCount = 1;
dataSet.HeadCountSummary.Rows.Add(nextRow);
}
}
}
}
dataSet.HeadCountSummary.Rows.Add(row);
}
}
}
}
}
// Get Terminated Count
DBFilter empTerminationFilter = new DBFilter();
empTerminationFilter.add(new Match("EmpTermLastDate", ">=", ReferenceDate));
empTerminationFilter.add(new Match("EmpTermLastDate", "<", CurrentDate));
ArrayList empTerminationList = EEmpTermination.db.select(dbConn, empTerminationFilter);
if (empTerminationList.Count > 0)
{
foreach (EEmpTermination empTermination in empTerminationList)
{
foreach (EEmpPersonalInfo obj in empList)
{
if (obj.EmpID == empTermination.EmpID)
{
EEmpPersonalInfo empInfo = new EEmpPersonalInfo();
empInfo.EmpID = empTermination.EmpID;
if (EEmpPersonalInfo.db.select(dbConn, empInfo))
{
if (empInfo.EmpGender.Equals(Gender) || Gender.Equals(string.Empty))
{
DBFilter empTerminationPosFilter = new DBFilter();
empTerminationPosFilter.add(new Match("EmpID", empTermination.EmpID));
empTerminationPosFilter.add(new Match("EmpPosEffFr", "<=", empTermination.EmpTermLastDate));
OR orEmpTerminationPosEffToDate = new OR();
orEmpTerminationPosEffToDate.add(new Match("EmpPosEffTo", ">=", empTermination.EmpTermLastDate));
orEmpTerminationPosEffToDate.add(new NullTerm("EmpPosEffTo"));
empTerminationPosFilter.add(orEmpTerminationPosEffToDate);
empTerminationPosFilter.add("EmpPosEffFr", false);
ArrayList empTerminationPosList = EEmpPositionInfo.db.select(dbConn, empTerminationPosFilter);
if (empTerminationPosList.Count > 0)
{
EEmpPositionInfo empPos = (EEmpPositionInfo)empTerminationPosList[0];
DataSet.HeadCountSummarySet.HeadCountSummaryRow row = CreateHeadCountRow(empPos.CompanyID, empPos.EmpPosID);
row.TerminateCount = 1;
dataSet.HeadCountSummary.Rows.Add(row);
}
}
}
}
}
}
}
if (reportDocument == null)
{
reportDocument = new ReportTemplate.Report_Employee_HeadCount();
}
else
{
}
reportDocument.SetDataSource(dataSet);
reportDocument.SetParameterValue("CurrentDate", CurrentDate);
reportDocument.SetParameterValue("ReferenceDate", ReferenceDate);
if (Gender.Equals("M"))
{
reportDocument.SetParameterValue("Gender", "Male");
}
else if (Gender.Equals("F"))
{
reportDocument.SetParameterValue("Gender", "Female");
}
else
{
reportDocument.SetParameterValue("Gender", "All");
}
// rpt.SetDataSource((DataTable)mpfTable);
return(reportDocument);
}
else
{
return(null);
}
}