站长论坛

标题: ASP.NET应用XML技术实现Web报表打印 [打印本页]

---

作者: superadmin    时间: 2009-5-12 10:21
标题: ASP.NET应用XML技术实现Web报表打印
XML主要用来描述打印报表的名称，数据来源，格式，分页打印等信息，具体标签可自己定义，下面是笔者针对会员管理系统报表打印所制定的XML文档：

Memberlist.xml

〈xml version="1.0" encoding="utf-8" >

〈XmlReport>

〈Page>

〈Title>Member information〈/Title>
〈ApplyXSLT>〈/ApplyXSLT>

〈/Page>

〈Report>

〈Title>Member list〈/Title>

〈TableName>Memberlist〈/TableName>

〈SQLdataConnection>Data Source=localhost;User ID=sa;password=;Initial Catalog=XMLReport;〈/SQLdataConnection>

〈OleDbConnection>〈/OleDbConnection>

〈Sql>Select MemberID, prefix+'. '+ firstname+' '+ surname AS [Member Name],CityOrTown,State,PostCode, '$'+convert(varchar(12),FeesPaid) As Fees From Members;〈/Sql>

〈PageSize>10〈/PageSize>

〈/Report>

〈Report>

〈Title>Member Summary〈/Title>

〈TableName>MemberSummary〈/TableName>

〈SQLdataConnection>Data Source=localhost;User ID=sa;password=;Initial Catalog=XMLReport;〈/SQLdataConnection>

〈OleDbConnection>〈/OleDbConnection>

〈Sql>Select Count(MemberID) As [Member Count], '$'+convert(varchar(12),Sum(FeesPaid)) As [Fees Total] From Members;〈/Sql>

〈PageSize>〈/PageSize>

〈/Report>

〈/XmlReport>



标签说明：

Page Title:报表标题

ApplyXSLT:应用样式表定制报表

SQLdaraConnection: 数据源连接字串，数据提供者为SQL server

OleDbConnection:数据源连接字串，数据提供者为OleDb

Sql:选取报表数据的sql语句

PageSize:分页打印，每页显示的记录条数

读者还可以自定义一些更精

---

作者: superadmin    时间: 2009-5-12 10:24
确的标签来控制报表。

3.2 创建通用打印页面

page_load时读取要打印的报表名

以下为引用的内容：

xmlFile = Request.QueryString["report"].ToString() + ".xml";

private void BindReports()

{

DataSet dsXml = new DataSet();

try

{

dsXml.ReadXml(Server.MapPath("Reports\\" + xmlFile));

DataTable dtPage = dsXml.Tables["Page"];

DataTable dtReport = dsXml.Tables["Report"];

labelPageTitle.Text = dtPage.Rows[0]["Title"].ToString();

for(int i = 0;i 〈 dtReport.Rows.Count; i++)

{

GetLabel(i).Text = dtReport.Rows["Title"].ToString();

if(dtReport.Rows["SQLdataConnection"].ToString() != String.Empty dtReport.Rows["Sql"].ToString() != String.Empty dtReport.Rows["OleDbConnection"].ToString() != String.Empty)

{

DataGrid dg = GetDataGrid(i);

if(dtReport.Rows["PageSize"].ToString() != String.Empty)

{

//分页打印

dg.AllowPaging = true;

dg.PagerStyle.Mode = PagerMode.NumericPages;

dg.PagerStyle.PageButtonCount = 10;

dg.PageSize = Convert.ToInt32(dtReport.Rows["PageSize"].ToString());

}

DataSet ds = new DataSet();

//从Report.xml读取数据源信息

if(dtReport.Rows["SQLdataConnection"].ToString() != String.Empty)


{

//数据提供者为SQL Server

SqlConnection Conn = new SqlConnection(dtReport.Rows["SQLdataConnection"].ToString());

SqlDataAdapter myDataAdapt = new SqlDataAdapter(dtReport.Rows["Sql"].ToString(),Conn);

myDataAdapt.Fill(ds,dtReport.Rows["TableName"].ToString());


}

else if(dtReport.Rows["OleDbConnection"].ToString() != String.Empty)

{

//数据提供者为OLE DB

OleDbConnection Conn = new OleDbConnection(dtReport.Rows["OleDbConnection"].ToString());

OleDbDataAdapter myDataAdapt = new OleDbDataAdapter(dtReport.Rows["Sql"].ToString(),Conn);

myDataAdapt.Fill(ds,dtReport.Rows["TableName"].ToString());

}

//用通用页面显示报表

dg.DataSource = ds;

dg.DataBind();

}  

}
}

catch

{

labelPageTitle.Text = "The requested report could not be found";

}

}




3.3 创建定制打印页面

需要在XML文档ApplyXSLT标签内添加对应的xslt文件名，并制作相应的样式表放在项目的xslt文件夹下即可。如下代码添加到通用打印程序中。

---

欢迎光临 站长论坛 (http://tzlink.com/bbs/)

Powered by Discuz! X3.2