public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { Report_Employee_YearOfServiceList rpt = new Report_Employee_YearOfServiceList(); rpt.Site = this.Site; return(rpt); }
public override ReportDocument GenerateReport() { if (values.Count > 0) { DataSet.EmployeeDetail ds = new DataSet.EmployeeDetail(); DataSet.EmployeeDetail.HierarchyLevelDataTable HierarchyLevelTable = ds.HierarchyLevel; DBFilter hierarchyLevelFilter = new DBFilter(); hierarchyLevelFilter.add("HLevelSeqNo", true); ArrayList HierarchyLevelList = EHierarchyLevel.db.select(dbConn, hierarchyLevelFilter); foreach (EHierarchyLevel HierarchyLevel in HierarchyLevelList) { DataSet.EmployeeDetail.HierarchyLevelRow row = HierarchyLevelTable.NewHierarchyLevelRow(); row.HLevelCode = HierarchyLevel.HLevelCode; row.HLevelDesc = HierarchyLevel.HLevelDesc; row.HLevelID = HierarchyLevel.HLevelID; row.HLevelSeqNo = HierarchyLevel.HLevelSeqNo; HierarchyLevelTable.Rows.Add(row); } int currentDummyPosID = 0; int currentDummyHierarchyID = 0; foreach (int EmpID in values) { EmployeeDetailProcess.ImportEmployeeDetailRow(dbConn, ds.employeedetail, EmpID, AsOfDate); { DataSet.EmployeeDetail.EmpPositionInfoDataTable empPosTable = ds.EmpPositionInfo; EEmpPositionInfo empPos = AppUtils.GetLastPositionInfo(dbConn, AsOfDate, EmpID); if (empPos == null) { currentDummyPosID--; DataSet.EmployeeDetail.EmpPositionInfoRow row = empPosTable.NewEmpPositionInfoRow(); row.EmpPosID = currentDummyPosID; row.EmpID = EmpID; empPosTable.AddEmpPositionInfoRow(row); DataSet.EmployeeDetail.EmpHierarchyDataTable empHierarchyTable = ds.EmpHierarchy; foreach (EHierarchyLevel hLevel in HierarchyLevelList) { currentDummyHierarchyID--; DataSet.EmployeeDetail.EmpHierarchyRow empHierarchyRow = empHierarchyTable.NewEmpHierarchyRow(); empHierarchyRow.EmpHierarchyID = currentDummyHierarchyID; empHierarchyRow.EmpID = EmpID; empHierarchyRow.EmpPosID = currentDummyPosID; empHierarchyRow.HLevelID = hLevel.HLevelID; empHierarchyRow.HLevelSeqNo = hLevel.HLevelSeqNo; empHierarchyTable.AddEmpHierarchyRow(empHierarchyRow); } } else { DataSet.EmployeeDetail.EmpPositionInfoRow row = empPosTable.NewEmpPositionInfoRow(); row.CompanyID = empPos.CompanyID; row.EmpID = empPos.EmpID; row.EmpPosEffFr = empPos.EmpPosEffFr; row.EmpPosEffTo = empPos.EmpPosEffTo; row.EmpPosID = empPos.EmpPosID; row.LeavePlanID = empPos.LeavePlanID; row.PayGroupID = empPos.PayGroupID; EPosition position = new EPosition(); position.PositionID = empPos.PositionID; if (EPosition.db.select(dbConn, position)) { row.PositionCode = position.PositionCode; row.PositionDesc = position.PositionDesc; row.PositionID = position.PositionID; } ERank rank = new ERank(); rank.RankID = empPos.RankID; if (ERank.db.select(dbConn, rank)) { row.RankCode = rank.RankCode; row.RankDesc = rank.RankDesc; row.RankID = rank.RankID; } row.StaffTypeID = empPos.StaffTypeID; empPosTable.AddEmpPositionInfoRow(row); DataSet.EmployeeDetail.EmpHierarchyDataTable empHierarchyTable = ds.EmpHierarchy; foreach (EHierarchyLevel hLevel in HierarchyLevelList) { DBFilter empHierarchyFilter = new DBFilter(); empHierarchyFilter.add(new Match("EmpPosID", empPos.EmpPosID)); empHierarchyFilter.add(new Match("HLevelID", hLevel.HLevelID)); ArrayList empHierarchyList = EEmpHierarchy.db.select(dbConn, empHierarchyFilter); DataSet.EmployeeDetail.EmpHierarchyRow empHierarchyRow = empHierarchyTable.NewEmpHierarchyRow(); empHierarchyRow.EmpID = EmpID; empHierarchyRow.EmpPosID = empPos.EmpPosID; empHierarchyRow.HLevelID = hLevel.HLevelID; empHierarchyRow.HLevelSeqNo = hLevel.HLevelSeqNo; if (empHierarchyList.Count > 0) { EEmpHierarchy empHierarchy = (EEmpHierarchy)empHierarchyList[0]; empHierarchyRow.EmpHierarchyID = empHierarchy.EmpHierarchyID; EHierarchyElement hElement = new EHierarchyElement(); hElement.HElementID = empHierarchy.HElementID; EHierarchyElement.db.select(dbConn, hElement); empHierarchyRow.HElementCode = hElement.HElementCode; empHierarchyRow.HElementDesc = hElement.HElementDesc; empHierarchyRow.HElementID = hElement.HElementID; } else { currentDummyHierarchyID--; empHierarchyRow.EmpHierarchyID = currentDummyHierarchyID; } empHierarchyTable.AddEmpHierarchyRow(empHierarchyRow); } } } } DataSet.EmployeeDetail.PayrollGroupDataTable payrollGroupTable = ds.PayrollGroup; ArrayList payrollGroupList = EPayrollGroup.db.select(dbConn, new DBFilter()); foreach (EPayrollGroup payrollGroup in payrollGroupList) { DataSet.EmployeeDetail.PayrollGroupRow row = payrollGroupTable.NewPayrollGroupRow(); row.PayGroupCode = payrollGroup.PayGroupCode; row.PayGroupDesc = payrollGroup.PayGroupDesc; row.PayGroupID = payrollGroup.PayGroupID; payrollGroupTable.Rows.Add(row); } DataSet.EmployeeDetail.PositionDataTable PositionTable = ds.Position; ArrayList PositionList = EPosition.db.select(dbConn, new DBFilter()); foreach (EPosition Position in PositionList) { DataSet.EmployeeDetail.PositionRow row = PositionTable.NewPositionRow(); row.PositionCode = Position.PositionCode; row.PositionDesc = Position.PositionDesc; row.PositionID = Position.PositionID; PositionTable.Rows.Add(row); } DataSet.EmployeeDetail.BankListDataTable BankListTable = ds.BankList; ArrayList BankListList = EBankList.db.select(dbConn, new DBFilter()); foreach (EBankList BankList in BankListList) { DataSet.EmployeeDetail.BankListRow row = BankListTable.NewBankListRow(); row.BankCode = BankList.BankCode; row.BankName = BankList.BankName; BankListTable.Rows.Add(row); } //System.Data.DataSet ds = new System.Data.DataSet(); //string select; //string from; //DBFilter filter; //OR or; //foreach (int EmpID in values) //{ //from = "from EmpPersonalInfo e LEFT JOIN EmpTermination et ON et.EmpID=e.EmpID "; //select = " e.*, et.EmpTermLastDate"; //filter = new DBFilter(); //filter.add(new Match("e.EmpID", EmpID)); //filter.loadData(ds, "employeedetail", null, select, from, null); //from = "from EmpPositionInfo ";//EmpPos ON P.EmpID=EmpPos.EmpID AND EmpPos.EmpPosEffTo IS NULL LEFT JOIN Position Pos ON EmpPos.PositionID=Pos.PositionID"; //select = "* "; //filter = new DBFilter(); //filter.add(new Match("EmpPosEffFr", "<=", AsOfDate)); //OR orEffToFilter = new OR(); //orEffToFilter.add(new Match("EmpPosEffTo", ">=", AsOfDate)); //orEffToFilter.add(new NullTerm("EmpPosEffTo")); //filter.add(orEffToFilter); //filter.add(new Match("EmpID", EmpID)); //filter.loadData(ds, "EmpPositionInfo", null, select, from, null); //from = "from EmpRecurringPayment erp, PaymentCode pc";//EmpPos ON P.EmpID=EmpPos.EmpID AND EmpPos.EmpPosEffTo IS NULL LEFT JOIN Position Pos ON EmpPos.PositionID=Pos.PositionID"; //select = "* "; //filter = new DBFilter(); //filter.add(new MatchField("erp.PayCodeID", "pc.PaymentCodeID")); //filter.add(new Match("pc.PaymentTypeID", EPaymentType.SystemPaymentType.BasicSalaryPaymentType(dbConn).PaymentTypeID)); //filter.add(new Match("erp.EmpRPEffFr", "<=", AsOfDate)); //orEffToFilter = new OR(); //orEffToFilter.add(new Match("erp.EmpRPEffTo", ">=", AsOfDate)); //orEffToFilter.add(new NullTerm("erp.EmpRPEffTo")); //filter.add(orEffToFilter); //filter.add(new Match("EmpID", EmpID)); //filter.loadData(ds, "EmpRecurringPayment", null, select, from, null); //} //from = " from PayrollGroup ";//EmpPos ON P.EmpID=EmpPos.EmpID AND EmpPos.EmpPosEffTo IS NULL LEFT JOIN Position Pos ON EmpPos.PositionID=Pos.PositionID"; //select = "* "; //filter = new DBFilter(); //filter.loadData(ds, "PayrollGroup", null, select, from, null); //from = " from Position ";//EmpPos ON P.EmpID=EmpPos.EmpID AND EmpPos.EmpPosEffTo IS NULL LEFT JOIN Position Pos ON EmpPos.PositionID=Pos.PositionID"; //select = "* "; //filter = new DBFilter(); //filter.loadData(ds, "Position", null, select, from, null); //from = "from EmpHierarchy eh Left Join HierarchyElement he ON eh.HElementID=he.HElementID LEFT JOIN HierarchyLevel hl on hl.HLevelID=eh.HLevelID";//EmpPos ON P.EmpID=EmpPos.EmpID AND EmpPos.EmpPosEffTo IS NULL LEFT JOIN Position Pos ON EmpPos.PositionID=Pos.PositionID"; //select = " eh.*, he.HElementCode, he.HElementDesc, hl.HLevelSeqNo"; //filter = new DBFilter(); //filter.add("HLevelSeqNo", true); //filter.loadData(ds, "EmpHierarchy", null, select, from, null); foreach (System.Data.DataRow row in ds.Tables["EmpHierarchy"].Rows) { if (row.IsNull("HElementDesc")) { row["HElementDesc"] = "-"; } if (string.IsNullOrEmpty(row["HElementDesc"].ToString())) { row["HElementDesc"] = "-"; } } //from = "from HierarchyLevel hl ";//EmpPos ON P.EmpID=EmpPos.EmpID AND EmpPos.EmpPosEffTo IS NULL LEFT JOIN Position Pos ON EmpPos.PositionID=Pos.PositionID"; //select = " hl.* "; //filter = new DBFilter(); //filter.add("HLevelSeqNo", true); //filter.loadData(ds, "HierarchyLevel", null, select, from, null); if (reportDocument == null) { reportDocument = new ReportTemplate.Report_Employee_YearOfServiceList(); } else { } reportDocument.SetDataSource(ds); reportDocument.SetParameterValue("AsOfDate", AsOfDate); return(reportDocument); } else { return(null); } }