public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReportSalarySheet rpt = new CrystalReportSalarySheet(); rpt.Site = this.Site; return(rpt); }
private void btnSearch_Click(object sender, EventArgs e) { //是否为空 if (cmbYear.SelectedIndex == -1 || cmbMonth.SelectedIndex == -1 || cmbDepartment.SelectedIndex == -1) { CommonHelper.FailedReply("不能为空!"); return; } int year = int.Parse(cmbYear.Text); int month = int.Parse(cmbMonth.Text); Guid depId = (Guid)cmbDepartment.SelectedValue; Guid id = ss.GetSalarySheetId(year, month, depId); if (id == Guid.Empty) { //生成新的工资单 CommonHelper.FailedReply("没有工资单,请先生成工资单!"); return; } else { DataTable dt = ss.GetSalarySheetItems(id); List <SalarySheetItemReport> items = new List <SalarySheetItemReport>(); SalarySheetItemReport item; foreach (DataRow dr in dt.Rows) { item = new SalarySheetItemReport(); item.EmployeeName = dr["姓名"].ToString(); item.BaseSalary = (decimal)dr["基本工资"]; item.Bonus = (decimal)dr["奖金"]; item.Fine = (decimal)dr["罚款"]; item.Other = (decimal)dr["其他"]; items.Add(item); } CrystalReportSalarySheet report = new CrystalReportSalarySheet(); report.SetDataSource(items); report.SetParameterValue("Y", year); report.SetParameterValue("M", month); report.SetParameterValue("D", cmbDepartment.Text); CrystalReportViewer.ReportSource = report; } }