4,816
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using Epower.ITSM.SqlDAL.InsertInfo;
using Microsoft.Reporting.WebForms;
namespace Epower.ITSM.Web.DeptForms.report
{
public partial class qiyeinfo : System.Web.UI.Page
{
DataTable dt2 = null;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
InitiliazeYear();
}
private void InitiliazeYear()
{
for (int i = 2010; i < 2050; i++)
{
ddlTime.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
}
private void BindData()
{
DataTable dt = QiyeReportService.getQiye(this.ddlTime.SelectedValue);
reportView.Reset();
reportView.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
reportView.LocalReport.ReportPath = Server.MapPath("../report/ReportTemplate/ZhuReport.rdlc");
reportView.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("Epower_ITSM_SqlDAL_InsertModel_QiyeReport", dt));
reportView.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
reportView.LocalReport.Refresh();
}
protected void btnQuery_Click(object sender, EventArgs e)
{
BindData();
}
private void LocalReport_SubreportProcessing(object sender, Microsoft.Reporting.WebForms.SubreportProcessingEventArgs e)
{
if (dt2 == null)
dt2 = So_ProductsServices.getSo_Products();
e.DataSources.Add(new ReportDataSource("Epower_ITSM_SqlDAL_InsertModel_So_Products", dt2));
}
}
}
public partial class Form2 : Form
{
DataTable dt2;
public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
ReportViewer reportViewer = new ReportViewer();
reportViewer.ProcessingMode = ProcessingMode.Local;
reportViewer.LocalReport.ReportPath = "Report1.rdlc";
reportViewer.LocalReport.SubreportProcessing += new Microsoft.Reporting.WinForms.SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
reportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1_DataTable1", loadData1()));
reportViewer.Dock = DockStyle.Fill;
this.Controls.Add(reportViewer);
reportViewer.RefreshReport();
}
private void LocalReport_SubreportProcessing(object sender, Microsoft.Reporting.WinForms.SubreportProcessingEventArgs e)
{
if (dt2 == null)
dt2 = loadData2();
e.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1_DataTable2", dt2));
}
private DataTable loadData1()
{
DataSet1.DataTable1DataTable dt = new DataSet1.DataTable1DataTable();
DataRow dr1 = dt.NewRow();
dr1["姓名"] = "王三";
dr1["日期"] = DateTime.Now.ToShortDateString();
dr1["金额"] = 130.45;
dr1["余额"] = 1234.33;
dt.Rows.Add(dr1);
DataRow dr2 = dt.NewRow();
dr2["姓名"] = "李四";
dr2["日期"] = DateTime.Now.ToShortDateString();
dr2["金额"] = 111.33;
dr2["余额"] = 22.3;
dt.Rows.Add(dr2);
return dt;
}
private DataTable loadData2()
{
DataSet1.DataTable2DataTable dt2 = new DataSet1.DataTable2DataTable();
DataRow d1 = dt2.NewRow();
d1["姓名"] = "王三";
d1["编号"] = "0001";
d1["名称"] = "床位费";
d1["价格"] = 10;
d1["数量"] = 1;
d1["金额"] = 10;
dt2.Rows.Add(d1);
DataRow d2 = dt2.NewRow();
d2["姓名"] = "王三";
d2["编号"] = "0002";
d2["名称"] = "护理费";
d2["价格"] = 8;
d2["数量"] = 3;
d2["金额"] = 24;
dt2.Rows.Add(d2);
DataRow d3 = dt2.NewRow();
d3["姓名"] = "李四";
d3["编号"] = "0002";
d3["名称"] = "注射费";
d3["价格"] = 8;
d3["数量"] = 3;
d3["金额"] = 24;
dt2.Rows.Add(d3);
return dt2;
}