链接参数值上的子报表 [英] Linking a subreport on a Parameter Value

问题描述

public DataTable LINQToDataTable<t>(IEnumerable<t> varlist)
    {
        DataTable dtReturn = new DataTable();

        // column names 
        PropertyInfo[] oProps = null; //using System.Reflection;

        if (varlist == null) return dtReturn;

        foreach (T rec in varlist)
        {
            // Use reflection to get property names, to create table, Only first time, others  
            if (oProps == null)
            {
                oProps = ((Type)rec.GetType()).GetProperties();
                foreach (PropertyInfo pi in oProps)
                {
                    Type colType = pi.PropertyType;

                    if ((colType.IsGenericType) && (colType.GetGenericTypeDefinition()
                    == typeof(Nullable<>)))
                    {
                        colType = colType.GetGenericArguments()[0];
                    }

                    dtReturn.Columns.Add(new DataColumn(pi.Name, colType));
                }
            }

            DataRow dr = dtReturn.NewRow();

            foreach (PropertyInfo pi in oProps)
            {
                dr[pi.Name] = pi.GetValue(rec, null) == null ? DBNull.Value : pi.GetValue
                (rec, null);
            }

            dtReturn.Rows.Add(dr);
        }
        return dtReturn;
    }

    protected void btnPreview_Click(object sender, EventArgs e)
    {
        ReportDocument rptDoc = new ReportDocument();
        DataTable dtable = new DataTable();

        RLMemberDBEntities db = new RLMemberDBEntities();

        String fromid, toid;
        fromid = Convert.ToString(cboFromCustomer.SelectedValue);
        Session["customer"] = fromid;
        toid = Convert.ToString(cboToCustomer.SelectedValue);
        var customer = from customertable in db.CSR_CU_ACNT
                      where (customertable.CU_ACNT_NUM == fromid )
                      //orderby 
                      select new { customertable.CU_ACNT_NUM, customertable.CUST_FRST_NM, customertable.ENC_CTZ_CORP_NUM, customertable.CUST_TYP_CD, customertable.BIRTH_DT};
        DataTable dt = new DataTable();
        dt = LINQToDataTable(customer);

        var service = from servicetable in db.CUS_SERVICE
                      where (servicetable.CU_ACNT_NUM == fromid)
                      select new {servicetable.CUS_SRV_ACNT,servicetable.SVR_PLAN,servicetable.ATV_DATE };

        DataTable dtsub = new DataTable();
        dtsub = LINQToDataTable(service);

        rptDoc.Load(Server.MapPath("~\\Reports\\CustomerReportNService - Copy.rpt"));//show 

        rptDoc.SetDataSource(dt);



        rptDoc.SetParameterValue("ReportTitle", "Customer Report");
        rptDoc.SetParameterValue("From", Session["customer"]);

        Session["Report"] = rptDoc;
        CrystalReportViewer1.ReportSource = rptDoc;
        //
        

    }

推荐答案

使用System;

使用System.Collections.Generic;

使用System。 Linq;

使用System.Web;

使用System.Web.UI;

使用System.Web.UI.WebControls;



使用CrystalDecisions.CrystalReports.Engine;

使用System.Data;

使用RLMemberDBModel;

使用System.Reflection;



公共部分类Reports_MemberReport：System.Web.UI.Page

{

#region帮助方法

public DataTable LINQToDataTable< t>（IEnumerable< t> varlist）

{

DataTable dtReturn = new DataTable（ ）;



//列名

PropertyInfo [] oProps = null; //使用System.Reflection;



if（varlist == null）return dtReturn;



foreach （T rec in varlist）

{

//使用反射来获取属性名称，创建表格，只有第一次，其他人才会关注

if（oProps == null）

{

oProps =（（Type）rec.GetType（））。GetProperties（）;

foreach（oProps中的PropertyInfo pi）

{

类型colType = pi.PropertyType;



if（（ colType.IsGenericType）&&（colType.GetGenericTypeDefinition（）

== typeof（Nullable<>）））

{

colType = colType.GetGenericArguments（）[0];

}



dtReturn.Columns.Add（new DataColumn（pi.Na）我，colType））;

}

}



DataRow dr = dtReturn.NewRow（）;



foreach（oProps中的PropertyInfo pi）

{

dr [pi.Name] = pi.GetValue（ rec，null）== null？ DBNull.Value：pi.GetValue

（rec，null）;

}



dtReturn.Rows。添加（博士）;

}

返回dtReturn;

}

#endregion帮助方法

protected void Page_Load（object sender，EventArgs e）

{

// if（Session [CurrentUser] == null）

// {

// Response.Redirect（〜/ LoginForm.aspx）;

//}

}

protected void btnPreview_Click（object sender，EventArgs e）

{

ReportDocument rptDoc = new ReportDocument（）;

DataTable dtable = new DataTable（）;



RLMemberDBEntities db = new RLMemberDBEntities（）;

Int32 fromid，toid;

//// fromid = Convert.ToInt32（cboFromMember.SelectedValue）;

//// toid = Convert.ToInt32（cboToPartner .SelectedValue）;

var member =来自db.vw_MembersReport中的表

//其中（table.CUS_CARD_ID> = fromid&& table.PartnerID< = toid）

// orderby

选择新{table.CUS_CARD_ID，table.CU_ACNT_NUM，table.CUST_FRST_NM，table.ENC_CTZ_CORP_NUM，table.CUST_TYP_CD， table.BIRTH_DT，table.Member_Type，table.ISS_DATE，table.VLD_DATE};

DataTable dt = new DataTable（）;

dt = LINQToDataTable（member）;



var service =来自db.CUS_SERVICE中的servicetable

//其中（servicetable.CU_ACNT_NUM == fromid）

选择新的{servicetable.CUS_SRV_ACNT，servicetable.CU_ACNT_NUM，servicetable.SVR_PLAN，servicetable.ATV_DATE};

DataTable dtsub = new DataTable（）;

dtsub = LINQToDataTable（service） ;



// dtable = departmentcontroller.DepartmentListReport（cboFromDepartment.SelectedValue，cboToDepartment.SelectedValue）;



rptDoc.Load（Server.M apPath（〜\\Reports\\Member18Sep.rpt））;

rptDoc.SetDataSource（dt）;



rptDoc.OpenSubreport（subServicePlan）。SetDataSource（dtsub）;



rptDoc.SetParameterValue（ReportTitle，Members List Report）;

//rptDoc.SetParameterValue(\"From，cboFromPartner.SelectedItem.Text）;

//rptDoc.SetParameterValue(\"To，cboToPartner.SelectedItem.Text）;



会话[报告] = rptDoc;

//CrystalReportViewer1.ReportSource = rptDoc;

ClientScript.RegisterStartupScript（这个.GetType（），key，window.open（'LargeSizeViewer.aspx'）;，true）;

}



}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

using CrystalDecisions.CrystalReports.Engine;
using System.Data;
using RLMemberDBModel;
using System.Reflection;

public partial class Reports_MemberReport : System.Web.UI.Page
{
#region Help methods
public DataTable LINQToDataTable<t>(IEnumerable<t> varlist)
{
DataTable dtReturn = new DataTable();

// column names
PropertyInfo[] oProps = null; //using System.Reflection;

if (varlist == null) return dtReturn;

foreach (T rec in varlist)
{
// Use reflection to get property names, to create table, Only first time, others will follow
if (oProps == null)
{
oProps = ((Type)rec.GetType()).GetProperties();
foreach (PropertyInfo pi in oProps)
{
Type colType = pi.PropertyType;

if ((colType.IsGenericType) && (colType.GetGenericTypeDefinition()
== typeof(Nullable<>)))
{
colType = colType.GetGenericArguments()[0];
}

dtReturn.Columns.Add(new DataColumn(pi.Name, colType));
}
}

DataRow dr = dtReturn.NewRow();

foreach (PropertyInfo pi in oProps)
{
dr[pi.Name] = pi.GetValue(rec, null) == null ? DBNull.Value : pi.GetValue
(rec, null);
}

dtReturn.Rows.Add(dr);
}
return dtReturn;
}
#endregion help methods
protected void Page_Load(object sender, EventArgs e)
{
//if (Session["CurrentUser"] == null)
//{
// Response.Redirect("~/LoginForm.aspx");
//}
}
protected void btnPreview_Click(object sender, EventArgs e)
{
ReportDocument rptDoc = new ReportDocument();
DataTable dtable = new DataTable();

RLMemberDBEntities db = new RLMemberDBEntities();
Int32 fromid, toid;
////fromid = Convert.ToInt32(cboFromMember.SelectedValue);
////toid = Convert.ToInt32(cboToPartner.SelectedValue);
var member = from table in db.vw_MembersReport
//where (table.CUS_CARD_ID >= fromid && table.PartnerID <= toid)
//orderby
select new { table.CUS_CARD_ID, table.CU_ACNT_NUM, table.CUST_FRST_NM, table.ENC_CTZ_CORP_NUM, table.CUST_TYP_CD, table.BIRTH_DT, table.Member_Type, table.ISS_DATE,table.VLD_DATE };
DataTable dt = new DataTable();
dt = LINQToDataTable(member);

var service = from servicetable in db.CUS_SERVICE
//where (servicetable.CU_ACNT_NUM == fromid)
select new { servicetable.CUS_SRV_ACNT, servicetable.CU_ACNT_NUM, servicetable.SVR_PLAN, servicetable.ATV_DATE };
DataTable dtsub = new DataTable();
dtsub = LINQToDataTable(service);

//dtable = departmentcontroller.DepartmentListReport(cboFromDepartment.SelectedValue, cboToDepartment.SelectedValue);

rptDoc.Load(Server.MapPath("~\\Reports\\Member18Sep.rpt"));
rptDoc.SetDataSource(dt);

rptDoc.OpenSubreport("subServicePlan").SetDataSource(dtsub);

rptDoc.SetParameterValue("ReportTitle", "Members List Report");
//rptDoc.SetParameterValue("From", cboFromPartner.SelectedItem.Text);
//rptDoc.SetParameterValue("To", cboToPartner.SelectedItem.Text);

Session["Report"] = rptDoc;
//CrystalReportViewer1.ReportSource = rptDoc;
ClientScript.RegisterStartupScript(this.GetType(), "key", "window.open('LargeSizeViewer.aspx');", true);
}

}

这篇关于链接参数值上的子报表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！