ProductList.cs
// // This code is part of Document Solutions for PDF demos. // Copyright (c) MESCIUS inc. All rights reserved. // using System; using System.IO; using System.Drawing; using System.Text; using System.Data; using System.Linq; using System.Collections.Generic; using GrapeCity.Documents.Pdf; using GrapeCity.Documents.Text; using GrapeCity.Documents.Html; namespace DsPdfWeb.Demos { // This sample shows how to render a report (the list of products // from the standard NWind sample database) using an HTML string // as a template. The report is created by looping over the data records // and building up the resulting HTML from table row template filled with // the actual data. The generated HTML string is then passed to GcHtmlRenderer // to create the PDF. // // Please see notes in comments at the top of HelloWorldHtml // sample code for details on adding DsHtml to your projects. public class ProductList { public void CreatePDF(Stream stream) { const string TTAG = "___TABLE___"; // HTML page template: const string tableTpl = "<!DOCTYPE html>" + "<html>" + "<head>" + "<style>" + "html * {" + " font-family: 'Trebuchet MS', Arial, Helvetica, sans-serif !important;" + "}" + "h1 {" + " color: #1a5276;" + " background-color: #d2b4de;" + " text-align: center;" + " padding: 6px;" + "}" + "thead {display: table-header-group;}" + "#products {" + " font-family: 'Trebuchet MS', Arial, Helvetica, sans-serif;" + " border-collapse: collapse;" + " width: 100%;" + "}" + "#products td, #products th {" + " border: 1px solid #ddd;" + " padding: 8px;" + "}" + "#products tr:nth-child(even){background-color: #f2f2f2;}" + "#products tr:hover {background-color: #ddd;}" + "#products th {" + " padding-top: 12px;" + " padding-bottom: 12px;" + " text-align: left;" + " background-color: #a569bd;" + " color: white;" + "}" + "</style>" + "</head>" + "<body>" + TTAG + "</body>" + "</html>"; const string tableHead = "<h1>Product Price List</h1>"; const string tableFmt = "<table id='products'>" + " <thead>" + " <th>Product ID</th>" + " <th>Description</th>" + " <th>Supplier</th>" + " <th>Quantity Per Unit</th>" + " <th>Unit Price</th>" + " </thead>" + "{0}" + "</table>"; const string dataRowFmt = " <tr>" + " <td>{0}</td>" + " <td>{1}</td>" + " <td>{2}</td>" + " <td>{3}</td>" + " <td align='right'>{4:C}</td>" + " </tr>"; using var ds = new DataSet(); ds.ReadXml(Path.Combine("Resources", "data", "DsNWind.xml")); DataTable dtProds = ds.Tables["Products"]; DataTable dtSupps = ds.Tables["Suppliers"]; var products = from prod in dtProds.Select() join supp in dtSupps.Select() on prod["SupplierID"] equals supp["SupplierID"] orderby prod["ProductName"] select new { ProductID = prod["ProductID"], ProductName = prod["ProductName"], Supplier = supp["CompanyName"], QuantityPerUnit = prod["QuantityPerUnit"], UnitPrice = prod["UnitPrice"] }; var sb = new StringBuilder(); sb.AppendLine(tableHead); foreach (var prod in products) sb.AppendFormat(dataRowFmt, prod.ProductID, prod.ProductName, prod.Supplier, prod.QuantityPerUnit, prod.UnitPrice); var html = tableTpl.Replace(TTAG, string.Format(tableFmt, sb.ToString())); using var browser = Common.Util.NewHtmlBrowser(); using var htmlPage = browser.NewPage(html); // PdfOptions specifies options for HTML to PDF conversion: var pdfOptions = new PdfOptions() { Margins = new PdfMargins(0.2f, 1, 0.2f, 1), DisplayHeaderFooter = true, HeaderTemplate = "<div style='color:#1a5276; font-size:12px; width:1000px; margin-left:0.2in; margin-right:0.2in'>" + "<span style='float:left;'>Product Price List</span>" + "<span style='float:right'>Page <span class='pageNumber'></span> of <span class='totalPages'></span></span>" + "</div>", FooterTemplate = "<div style='color: #1a5276; font-size:12em; width:1000px; margin-left:0.2in; margin-right:0.2in;'>" + "<span>(c) MESCIUS inc. All Rights Reserved.</span>" + "<span style='float:right'>Generated on <span class='date'></span></span></div>" }; // Render the source Web page to the temporary file: var tmp = Path.GetTempFileName(); htmlPage.SaveAsPdf(tmp, pdfOptions); // Copy the created PDF from the temp file to target stream: using (var ts = File.OpenRead(tmp)) ts.CopyTo(stream); // Clean up: File.Delete(tmp); // Done. } } }