测试

最新推荐文章于 2024-12-19 10:11:44 发布

转载最新推荐文章于 2024-12-19 10:11:44 发布 · 174 阅读

java基础专栏收录该内容

1 篇文章

订阅专栏

本文介绍如何在ASP.NET应用程序中使用ReportViewer控件加载报告，并设置参数及数据源。通过实例展示了如何从查询字符串获取ID，设置公司名称等参数，并从数据库获取打印订单和租赁信息的数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
            {
                strRentDateCode = Request.QueryString["ID"].ToString();
            }
            BindData();
            BindPrintOrder();
            string CompanyName=Session["Member"].ToString();
            QueryParam queryparam = new QueryParam();
            if (!string.IsNullOrEmpty(CompanyName))
                queryparam.Add("CompanyName", QueryParam.RELATION.EQ, "'" + CompanyName + "'");
            memberModel = member.GetMemberModel(CompanyName);
            DataTable dtPrintOrder = GetPrintOrderData();
            DataTable dtRentInfo = GetRentInfoData();
            ReportViewer1.LocalReport.ReportPath = "Report.rdlc";
            Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1_PrintOrder", dtPrintOrder);
            Microsoft.Reporting.WebForms.ReportDataSource rds2 = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet2_RentInfo", dtRentInfo);         
           ReportViewer1.LocalReport.DataSources.Clear();
            List<ReportParameter> para = new List<ReportParameter>();      
            para.Add(new ReportParameter("RentDate", strRentDateCode));
            para.Add(new ReportParameter("Person", memberModel.Person));
            para.Add(new ReportParameter("Phone", memberModel.Phone));
            para.Add(new ReportParameter("Count", dtPrintOrder.Rows.Count.ToString()));
            this.ReportViewer1.LocalReport.SetParameters(para);
            ReportViewer1.LocalReport.DataSources.Add(rds);
            ReportViewer1.LocalReport.DataSources.Add(rds2);  
            this.ReportViewer1.ZoomMode = Microsoft.Reporting.WebForms.ZoomMode.Percent;
            this.ReportViewer1.ZoomPercent = 100;
            ReportViewer1.LocalReport.Refresh();
        }
    }

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
{
strRentDateCode = Request.QueryString["ID"].ToString();
}

BindData();
BindPrintOrder();

string CompanyName=Session["Member"].ToString();
QueryParam queryparam = new QueryParam();

if (!string.IsNullOrEmpty(CompanyName))
queryparam.Add("CompanyName", QueryParam.RELATION.EQ, "'" + CompanyName + "'");

memberModel = member.GetMemberModel(CompanyName);

DataTable dtPrintOrder = GetPrintOrderData();
DataTable dtRentInfo = GetRentInfoData();

ReportViewer1.LocalReport.ReportPath = "Report.rdlc";
Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1_PrintOrder", dtPrintOrder);
Microsoft.Reporting.WebForms.ReportDataSource rds2 = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet2_RentInfo", dtRentInfo);

//ReportParameter rptParaA = new ReportParameter("rptParaA", "申请日期");
//ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rptParaA });

//ReportParameter rptParaB = new ReportParameter("rptParaB", "公司名称");
//ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rptParaB });

ReportViewer1.LocalReport.DataSources.Clear();
List<ReportParameter> para = new List<ReportParameter>();
//这里是添加两个字段
para.Add(new ReportParameter("RentDate", strRentDateCode));
para.Add(new ReportParameter("CompanyName", memberModel.CompanyName));

para.Add(new ReportParameter("Address", memberModel.Address));
para.Add(new ReportParameter("Person", memberModel.Person));

para.Add(new ReportParameter("Phone", memberModel.Phone));
para.Add(new ReportParameter("Email", memberModel.Email));

para.Add(new ReportParameter("Count", dtPrintOrder.Rows.Count.ToString()));

this.ReportViewer1.LocalReport.SetParameters(para);
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.LocalReport.DataSources.Add(rds2);

this.ReportViewer1.ZoomMode = Microsoft.Reporting.WebForms.ZoomMode.Percent;
this.ReportViewer1.ZoomPercent = 100;

ReportViewer1.LocalReport.Refresh();

//方法一按钮画图事件，当按下去鼠标形状改变成画笔，Mousedown后创建新控件：
private void buttonC_Click(Object sender,MouseEvent e)
{
   //选中颜色变化
   buttonC.backColor=color...;
}
private void panel1_MouseDown(Object sender,MouseEvent e)
{
   //如果控件编辑状态颜色变化，那么就可以编辑
    if(buttonC.BackColor=Color....)
    {
       UserControl1 us=new UserControl1();
       us.Width=...;
       us.Height=...;
       //...
       us.Left=...;
       us.Top=...;
       panel1.Controls.Add(us);
       //完成后颜色恢复
       buttonC.BackColor=Color.White;
    }
}

}
}