导出PDF时用到了sourceforge上的 iTextSharp 类;
关于 iTextSharp 类的使用请参见:http://www.codeproject.com/KB/cs/iTextSharpPdfTables.aspx
以下是完整示例代码:
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Xml.Xsl"%>
<%@ Import Namespace="System.Xml"%>
<%@ Import Namespace="System.Linq" %>
<%@ Import Namespace="iTextSharp.text" %>
<%@ Import Namespace="iTextSharp.text.pdf" %>
<%@ Register Assembly="Coolite.Ext.Web" Namespace="Coolite.Ext.Web" TagPrefix="ext" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
private object[] TestData
{
get
{
DateTime now = DateTime.Now;
return new object[]
{
new object[] {"3m Co", 71.72, 0.02, 0.03, now},
new object[] {"Alcoa Inc", 29.01, 0.42, 1.47, now},
new object[] {"Altria Group Inc", 83.81, 0.28, 0.34, now},
new object[] {"American Express Company", 52.55, 0.01, 0.02, now},
new object[] {"American International Group, Inc.", 64.13, 0.31, 0.49, now},
new object[] {"AT&T Inc.", 31.61, -0.48, -1.54, now},
new object[] {"Boeing Co.", 75.43, 0.53, 0.71, now},
new object[] {"Caterpillar Inc.", 67.27, 0.92, 1.39, now},
new object[] {"Citigroup, Inc.", 49.37, 0.02, 0.04, now},
new object[] {"E.I. du Pont de Nemours and Company", 40.48, 0.51, 1.28, now},
new object[] {"Exxon Mobil Corp", 68.1, -0.43, -0.64, now},
new object[] {"General Electric Company", 34.14, -0.08, -0.23, now},
new object[] {"General Motors Corporation", 30.27, 1.09, 3.74, now},
new object[] {"Hewlett-Packard Co.", 36.53, -0.03, -0.08, now},
new object[] {"Honeywell Intl Inc", 38.77, 0.05, 0.13, now},
new object[] {"Intel Corporation", 19.88, 0.31, 1.58, now},
new object[] {"International Business Machines", 81.41, 0.44, 0.54, now},
new object[] {"Johnson & Johnson", 64.72, 0.06, 0.09, now},
new object[] {"JP Morgan & Chase & Co", 45.73, 0.07, 0.15, now},
new object[] {"McDonald/"s Corporation", 36.76, 0.86, 2.40, now},
new object[] {"Merck & Co., Inc.", 40.96, 0.41, 1.01, now},
new object[] {"Microsoft Corporation", 25.84, 0.14, 0.54, now},
new object[] {"Pfizer Inc", 27.96, 0.4, 1.45, now},
new object[] {"The Coca-Cola Company", 45.07, 0.26, 0.58, now},
new object[] {"The Home Depot, Inc.", 34.64, 0.35, 1.02, now},
new object[] {"The Procter & Gamble Company", 61.91, 0.01, 0.02, now},
new object[] {"United Technologies Corporation", 63.26, 0.55, 0.88, now},
new object[] {"Verizon Communications", 35.57, 0.39, 1.11, now},
new object[] {"Wal-Mart Stores, Inc.", 45.45, 0.73, 1.63, now}
};
}
}
protected void Store1_RefreshData(object sender, StoreRefreshDataEventArgs e)
{
this.Store1.DataSource = this.TestData;
this.Store1.DataBind();
}
protected void Store1_RecordUpdated(object sender, AfterRecordUpdatedEventArgs e)
{
// This event is fired once for each Record that is Updated.
var company = new {
Name = e.NewValues["company"],
Price = e.NewValues["price"],
LastChange = e.NewValues["lastChange"]
};
string tpl = "Name: {0}, Price: {1}, LastChange: {2}<br />";
this.Label1.Html += string.Format(tpl, company.Name, company.Price, company.LastChange);
}
protected void Button1_Click(object sender, AjaxEventArgs e)
{
string tpl = "Ext.getDom('{0}').value='{1}';";
this.Button1.AddScript(string.Format(tpl, this.HiddenField1.ClientID, "SomeValue"));
}
protected void Store1_Submit(object sender, StoreSubmitDataEventArgs e)
{
string format = this.FormatType.Value.ToString();
XmlNode xml = e.Xml;
this.Response.Clear();
switch(format)
{
case "xml":
string strXml = xml.OuterXml;
this.Response.AddHeader("Content-Disposition", "attachment; filename=submittedData.xml");
this.Response.AddHeader("Content-Length", strXml.Length.ToString());
this.Response.ContentType = "application/xml";
this.Response.Write(strXml);
break;
case "xls":
this.Response.ContentType = "application/vnd.ms-excel";
this.Response.AddHeader("Content-Disposition", "attachment; filename=submittedData.xls");
XslCompiledTransform xtExcel = new XslCompiledTransform();
xtExcel.Load(Server.MapPath("Excel.xsl"));
xtExcel.Transform(xml, null, Response.OutputStream);
break;
case "csv":
this.Response.ContentType = "application/octet-stream";
this.Response.AddHeader("Content-Disposition", "attachment; filename=submittedData.csv");
XslCompiledTransform xtCsv = new XslCompiledTransform();
xtCsv.Load(Server.MapPath("Csv.xsl"));
xtCsv.Transform(xml, null, Response.OutputStream);
break;
case "pdf":
this.PrintPDF();
break;
}
this.Response.End();
}
private void PrintPDF()
{
System.IO.MemoryStream PDFData = new System.IO.MemoryStream();
Document document = new Document(PageSize.A4.Rotate(), 10, 10, 10, 10);
iTextSharp.text.pdf.PdfWriter PDFWriter = iTextSharp.text.pdf.PdfWriter.GetInstance(document, PDFData);
document.Open();
int NumColumns = 5;
iTextSharp.text.pdf.PdfPTable _table = new iTextSharp.text.pdf.PdfPTable(NumColumns);
_table.DefaultCell.Padding = 4;
_table.WidthPercentage = 100; // percentage
_table.DefaultCell.HorizontalAlignment = Element.ALIGN_CENTER;
_table.DefaultCell.VerticalAlignment = Element.ALIGN_MIDDLE;
_table.DefaultCell.BorderWidth = 1;
_table.DefaultCell.BackgroundColor = new Color(119, 149, 191);
_table.AddCell(new Phrase("Company", FontFactory.GetFont(FontFactory.HELVETICA, 11, Font.BOLD, new Color(255, 255, 255))));
_table.AddCell(new Phrase("Price", FontFactory.GetFont(FontFactory.HELVETICA, 11, Font.BOLD, new Color(255, 255, 255))));
_table.AddCell(new Phrase("Change", FontFactory.GetFont(FontFactory.HELVETICA, 11, Font.BOLD, new Color(255, 255, 255))));
_table.AddCell(new Phrase("Pct Change", FontFactory.GetFont(FontFactory.HELVETICA, 11, Font.BOLD, new Color(255, 255, 255))));
_table.AddCell(new Phrase("Last Change", FontFactory.GetFont(FontFactory.HELVETICA, 11, Font.BOLD, new Color(255, 255, 255))));
_table.HeaderRows = 1; // this is the end of the table header
_table.DefaultCell.BorderWidth = 1;
for (int i = 0; i < this.TestData.Length; i++)
{
_table.DefaultCell.BackgroundColor = (i % 2 == 1) ? new Color(241, 241, 241) : new Color(255, 255, 255);
for (int n = 0; n < NumColumns; n++)
{
_table.DefaultCell.HorizontalAlignment = (n == 0) ? Element.ALIGN_LEFT : Element.ALIGN_CENTER;
object[] o = TestData[i] as object[];
if(o != null) _table.AddCell(new Phrase(o[n].ToString(), FontFactory.GetFont(FontFactory.HELVETICA, 9, Font.NORMAL)));
}
}
document.Add(_table);
document.Close();
Response.ContentType = "application/pdf";
Response.Cache.SetCacheability(System.Web.HttpCacheability.Public);
Response.AppendHeader("Content-Type", "application/pdf");
Response.AppendHeader("Content-Disposition","attachment; filename=testD.pdf");
Response.OutputStream.Write(PDFData.GetBuffer(), 0, PDFData.GetBuffer().Length);
Response.OutputStream.Flush();
Response.OutputStream.Close();
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Export Data from GridPanel into XML, Excel or CSV using an AjaxRequest - Coolite Toolkit Example</title>
<link href="../../../../../resources/css/examples.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
var submitValue = function (grid, hiddenFormat, format) {
hiddenFormat.setValue(format);
grid.submitData(false);
}
var template = '<span style="color:{0};">{1}</span>';
var change = function(value) {
return String.format(template, (value > 0) ? 'green' : 'red', value);
}
var pctChange = function(value) {
return String.format(template, (value > 0) ? 'green' : 'red', value + '%');
}
</script>
</head>
<body>
<form id="form1" runat="server">
<ext:ScriptManager ID="ScriptManager1" runat="server" />
<h1>Export Data from GridPanel into XML, Excel or CSV using an AjaxRequest</h1>
<%--<p>Limitations of ajax file downloading: success/failure events don't fired. Therefore the mask is impossible.</p>--%>
<ext:Hidden ID="FormatType" runat="server" />
<ext:Store
ID="Store1"
runat="server"
OnAfterRecordUpdated="Store1_RecordUpdated"
OnRefreshData="Store1_RefreshData"
OnSubmitData="Store1_Submit"
AutoLoad="true"
RemoteSort="true">
<AjaxEventConfig IsUpload="true" />
<Proxy>
<ext:DataSourceProxy />
</Proxy>
<Reader>
<ext:ArrayReader>
<Fields>
<ext:RecordField Name="company" />
<ext:RecordField Name="price" Type="Float" />
<ext:RecordField Name="change" Type="Float" />
<ext:RecordField Name="pctChange" Type="Float" />
<ext:RecordField Name="lastChange" Type="Date" />
</Fields>
</ext:ArrayReader>
</Reader>
</ext:Store>
<ext:GridPanel
ID="GridPanel1"
runat="server"
StoreID="Store1"
StripeRows="true"
Title="Array Grid"
Width="600"
Height="290"
AutoExpandColumn="Company">
<TopBar>
<ext:Toolbar ID="Toolbar1" runat="server">
<Items>
<ext:ToolbarFill ID="ToolbarFill1" runat="server" />
<ext:Button ID="Button2" runat="server" Text="To XML" Icon="PageCode">
<Listeners>
<Click Handler="submitValue(#{GridPanel1}, #{FormatType}, 'xml');" />
</Listeners>
</ext:Button>
<ext:Button ID="Button3" runat="server" Text="To Excel" Icon="PageExcel">
<Listeners>
<Click Handler="submitValue(#{GridPanel1}, #{FormatType}, 'xls');" />
</Listeners>
</ext:Button>
<ext:Button ID="Button4" runat="server" Text="To CSV" Icon="PageAttach">
<Listeners>
<Click Handler="submitValue(#{GridPanel1}, #{FormatType}, 'csv');" />
</Listeners>
</ext:Button>
<ext:Button ID="Button5" runat="server" Text="To PDF" Icon="PageWhiteAcrobat">
<Listeners>
<Click Handler="submitValue(#{GridPanel1}, #{FormatType}, 'pdf');" />
</Listeners>
</ext:Button>
</Items>
</ext:Toolbar>
</TopBar>
<ColumnModel ID="ColumnModel1" runat="server">
<Columns>
<ext:Column
ColumnID="Company"
Header="Company"
Width="160"
Sortable="true"
DataIndex="company">
<Editor>
<ext:TextField ID="TextField1" runat="server" />
</Editor>
</ext:Column>
<ext:Column Header="Price" Width="75" Sortable="true" DataIndex="price">
<Renderer Format="UsMoney" />
<Editor>
<ext:TextField ID="TextField2" runat="server" />
</Editor>
</ext:Column>
<ext:Column Header="Change" Width="75" Sortable="true" DataIndex="change">
<Renderer Fn="change" />
</ext:Column>
<ext:Column Header="Change" Width="75" Sortable="true" DataIndex="pctChange">
<Renderer Fn="pctChange" />
</ext:Column>
<ext:Column Header="Last Updated" Width="85" Sortable="true" DataIndex="lastChange">
<Renderer Fn="Ext.util.Format.dateRenderer('G:i:s')" />
<Editor>
<ext:DateField ID="DateField1" runat="server" />
</Editor>
</ext:Column>
</Columns>
</ColumnModel>
<SelectionModel>
<ext:RowSelectionModel ID="RowSelectionModel1" runat="server" />
</SelectionModel>
<LoadMask ShowMask="true" />
<BottomBar>
<ext:PagingToolBar ID="PagingToolBar1" runat="server" PageSize="10" StoreID="Store1" />
</BottomBar>
</ext:GridPanel>
<ext:Button ID="Button1" runat="server" Text="Submit">
<AjaxEvents>
<Click OnEvent="Button1_Click" />
</AjaxEvents>
</ext:Button>
<asp:HiddenField ID="HiddenField1" runat="server" />
<ext:Label ID="Label1" runat="server" />
</form>
</body>
</html>