Coolite GridPanel 导出(包含xls、csv、xml、pdf)

来源：互联网发布：jq 数组包含字符串编辑：程序博客网时间：2024/05/16 06:53

导出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">

    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);
        }