使用HTML作報表

最後更新：2018-12-08 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

NVelocity 可以算上castle一個比較重頭的組件了，TemplateEngine Component 是NVelocity的一個預設的應用實現，使用它可以便於使用HTML作為模板，產生報表。

組件:http://www.castleproject.org/castle/download.html

當然，報表都少不了匯出PDF，這一還要藉助另外一個開源組件：iText, 它的.NET移植版iText.NET 還有一個C#重製版iTextSharp ，iText.NET的作者在項目介紹中還推薦在新項目中使用iTextSharp了。

樣本：

報表模版可以這樣寫：

代碼

<html>
    <head>
    <link rel="stylesheet" type="text/css" href="$CssName">
  </link>
</head>
    <body>
        <div>Header</div>
        <br/>

#foreach ( $dr in $Dt.Rows)
#set($name=$dr.get_Item(3).ToString().Trim().Replace(" ", "%20"))

<tr>
<td style='padding:5px'
onmousedown="window.location.href('$name')"
onmouseover="style.backgroundColor='#DFEEEE';"
onmouseout="style.backgroundColor='#FFFFFF';">
<span style="font-size: 20px; color: #0000FF">Compound Name: </span><span style="font-size: 20px; color: #FF0000">$dr.get_Item(3)</span>
<br/><b><span>Drug Alias: </span></b><span>$dr.get_Item(4)</span>
<br/><b><span>Category: </span></b><span>$dr.get_Item(2)</span>
</td></tr>

#end
</table>
<br/>

        <div>Bottom
        </div>
    </body>
</html>

代碼：

報表預覽：

代碼

    protected void Button2_Click(object sender, EventArgs e)
    {
        DataTable dataTable = GetDataTable();
        string output = ProcessTemplate(dataTable);
        Response.Write(output);
        Response.Flush();
        Response.Close();
    }

    private string ProcessTemplate(DataTable dataTable)
    {
        INVelocityEngine velocityEngine = NVelocityEngineFactory.CreateNVelocityFileEngine(Server.MapPath("~/Templates"), true);
        System.Collections.Hashtable context = new System.Collections.Hashtable();
        context.Add("CssName", ResolveAbsoluteUrl("~/css/default.css"));
        context.Add("Dt", dataTable);
        string output = velocityEngine.Process(context, "temp.htm");
        return output;
    }

    private DataTable GetDataTable()
    {
        DataTable dataTable = new DataTable();
        dataTable.Columns.Add("a");
        dataTable.Columns.Add("b");
        dataTable.Columns.Add("c");
        dataTable.Columns.Add("d");
        dataTable.Columns.Add("e");
        for (int i = 0; i < 10; i++)
        {
            DataRow dataRow = dataTable.NewRow();
            for (int j = 0; j < dataTable.Columns.Count; j++)
            {
                dataRow[j] = string.Format("value: {0}, {1}", i, j);
            }
            dataTable.Rows.Add(dataRow);
        }
        return dataTable;
    }

匯出PDF:

代碼

    protected void Button5_Click(object sender, EventArgs e)
    {
        System.Reflection.Assembly.Load("Apache.Xml.Commons");
        System.Reflection.Assembly.Load("Apache.Crimson");
        System.Reflection.Assembly.Load("iTextAsian");

        DataTable dataTable = GetDataTable();
        string output = ProcessTemplate(dataTable);
        string fileName = Server.MapPath("~/Temp/temp.htm");
        System.IO.File.WriteAllText(fileName, output, System.Text.ASCIIEncoding.ASCII);

        MemoryStream stream = new MemoryStream();
        com.lowagie.text.Document document = new com.lowagie.text.Document(PageSize.A4, 80, 50, 30, 65);
        PdfWriter.getInstance(document, stream);
        HtmlParser.parse(document, fileName);

        document.close();
        stream.Flush();
        byte[] bytes = stream.ToArray();
        if (bytes != null)
        {
            Page.Response.Clear();
            Page.Response.ContentType = "application/pdf";
            Page.Response.AppendHeader("Content-Disposition", "attachment;filename=temp.pdf");
            Page.Response.BinaryWrite(bytes);
            Page.Response.End();
        }
    }

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More

使用HTML作報表

聯繫我們

A Free Trial That Lets You Build Big!

Sales Support

After-Sales Support