生成表格pdf文档

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using TStar.Web;

using System.Data;

using iTextSharp.text;

using System.IO;

using iTextSharp.text.pdf;

namespace WebApp.Admin.Tjbb

{

public partial class cpxs : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

#region页面按钮事件

protected void btnPdf_Click(object sender, EventArgs e)

{

Document document = new Document(PageSize.A4);

string root = Page.Request.PhysicalApplicationPath;

string fileName = "菜品销售统计" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".pdf";

string templateFile = root + "Download\\" + fileName;

try

{

// step 2:

// we create a writer that listens to the document

// and directs a PDF-stream to a file

PdfWriter writer = PdfWriter.getInstance(document, new FileStream(templateFile, FileMode.Create));

// step 3: we open the document

document.Open();

//字体参数设置

BaseFont bfChinese = BaseFont.createFont(@"C:\WINDOWS\Fonts\arialuni.ttf", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED);

//微软雅黑

BaseFont bfChinese1 = BaseFont.createFont(@"C:\WINDOWS\Fonts\MSYHBD.TTF", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED);

Font fontChinese = new Font(bfChinese1, 8, Font.ITALIC, new Color(0x66,

0x66, 0x66));

//Font fontChinese = new Font(bfChinese, 12);

// step 4: we grab the ContentByte and do some stuff with it

PdfContentByte cb = writer.DirectContent;

PdfTemplate template = cb.createTemplate(500, 200);

//添加块

Chunk chunk = new Chunk("", FontFactory.getFont(FontFactory.TIMES_BOLD, 30,

Font.BOLD, new Color(255, 0, 0)));

//添加文字

String stxt = " "+ DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")

+ "菜品销售统计";

Font sfontTitle = new Font(bfChinese1, 22, Font.NORMAL, new Color(0, 0, 0));

Font sfont2Title = new Font(bfChinese, 14, Font.NORMAL, new Color(0, 0, 0));

Font sfont3Title = new Font(bfChinese, 14, Font.NORMAL, new Color(0, 0, 0));

Font sfont4Title = new Font(bfChinese, 12, Font.NORMAL, new Color(0, 0, 0));

document.Add(new Paragraph(stxt, sfontTitle));

////加表格

iTextSharp.text.Table atable = new iTextSharp.text.Table(5);

atable.WidthPercentage = 100;

atable.Spacing = 0; //表格字距;行距

atable.Padding = 3; //表格边距

atable.Cellpadding = 5;//内间距

atable.Cellspacing = 5;//间距

atable.BorderWidth = 1; //边框宽度

//atable.BackgroundColor = new Color(0x77, 0x77, 0x77);

//atable.BorderColor = new Color(255, 255, 255); //边框颜色

//Cell cell = new Cell();//创建一个单元格

//cell.Header = true;//显示表头

//cell.Colspan = 6;//合并单元格

//cell.addElement(new Paragraph("星期一课程表", sfont3Title));

//cell.HorizontalAlignment = Element.ALIGN_CENTER;//设置居中

//atable.addCell(cell);//添加表头单元格到表格

//cell = new Cell();//创建一个单元格

//cell.Rowspan = 2;//合并当前格和第三行的第一列单元格

////cell.BorderColor = new Color(255, 0, 0);//边框颜色

////cell.AddElement(new Paragraph("星期/科目/节次", font));

////cell.AddElement(new

ImgRaw(iTextSharp.text.Image.GetInstance(Server.MapPath("/2.jpg"))));

//atable.addCell(cell);//添加单元格到表格 //添加显示上午的单

元格，合并三列

//cell = new Cell();

//cell.Colspan = 3;//合并三列，为上午的三节课

//cell.addElement(new Paragraph("上午", sfont3Title));

//atable.addCell(cell);//添加到表格

////同样方法添加显示下午的单元格，合并两列

//cell = new Cell();

//cell.Colspan = 2;

//cell.addElement(new Paragraph("下午", sfont3Title));

//atable.addCell(cell);

//第三行添加节次

Cell cell = new Cell();

atable.addCell(new Paragraph("序号", sfont3Title));

atable.addCell(new Paragraph("餐厅名称", sfont3Title));

atable.addCell(new Paragraph("销售日期", sfont3Title));

atable.addCell(new Paragraph("销售数量", sfont3Title));

atable.addCell(new Paragraph("所占比例", sfont3Title));

//从第四行开始写课程，但第一列必须写星期

DataView dv = this.rptResult.DataView;

if (dv != null)

for (int i = 0; i < dv.Count; i++)

{

atable.addCell(new Paragraph((i+1).ToString(), sfont3Title));

atable.addCell(new Paragraph(dv[i]["mc"].ToString(), sfont3Title));

atable.addCell(new Paragraph(dv[i]["jcrq"].ToString(), sfont3Title));

atable.addCell(new Paragraph(dv[i]["sl"].ToString(), sfont3Title));

atable.addCell(new Paragraph(dv[i]["bl"].ToString(), sfont3Title));

}

//atable.addCell(new Paragraph("语文", sfont3Title));

//atable.addCell(new Paragraph("数学", sfont3Title));

//atable.addCell(new Paragraph("英文", sfont3Title));

//atable.addCell(new Paragraph("地理", sfont3Title));

//atable.addCell(new Paragraph("历史", sfont3Title));

document.Add(atable);

}

catch (DocumentException de)

{

Response.Write(de.Message);

}

catch (IOException ioe)

{

Response.Write(ioe.Message);

}

// step 5: we close the document

document.Close();

string downloadFile = "/Download/" + fileName;

JScript.OpenWindow(downloadFile);

}

#endregion

}

}