using iTextSharp.text;
using iTextSharp.text.pdf;
//导出PDF
public ActionResult ImportFile(string date)
{
try
{
List<IncomingHeatVal> list = null;
string typeData = "日";
string typeData2 = "月";
DateTime dateTT;
try
{
dateTT = Convert.ToDateTime(date);
}
catch (Exception)
{
return Content("<script>alert('日期格式不正确');</script>");
}
//导出日报
string date1 = dateTT.ToString("yyyyMM") + "01";
string date2 = Convert.ToDateTime(date).ToString("yyyyMMdd");
list = new IncomingHeatDao().GetReportData(date1, date2);
//字体读取的是windows系统宋体
BaseFont basefont = BaseFont.CreateFont("C:/Windows/Fonts/simsun.ttc,0", BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
iTextSharp.text.Font font = new Font(basefont, 10);//设置字体为宋体和大小
iTextSharp.text.Font font2 = new Font(basefont, 9);//设置字体为宋体和大小
//font.Color = BaseColor.BLUE;//字体颜色
iTextSharp.text.Document document = new iTextSharp.text.Document(PageSize.A4.Rotate(), 15, 15, 15, 15);
System.IO.MemoryStream stream = new System.IO.MemoryStream();
PdfWriter.GetInstance(document, stream);
document.Open();
document.AddTitle("入厂入炉热值差" + typeData + "报表");
Paragraph element = new Paragraph("入厂入炉热值差" + typeData + "报表", new Font(basefont, 16));
element.SpacingAfter = 10; //设置离后面内容的间距
element.Alignment = Element.ALIGN_CENTER;
document.Add(element);
//打印时间
Paragraph element2 = new Paragraph("打印时间:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm"), new Font(basefont, 6));
element2.SpacingAfter = 5; //设置离后面内容的间距
document.Add(element2);
PdfPTable table = new PdfPTable(15);
table.WidthPercentage = 100;//设置表格宽度占用百分比
//table.SetTotalWidth(new float[] { 90f, 90f, 150f, 90f, 150f, 90f, 150f, 90f, 150f, 90f, 150f, 90f, 150f, 150f, 150f });
#region 表头
//第一行表头
PdfPCell cell = new PdfPCell(new Paragraph("时间", font));
cell.Rowspan = 3;
cell.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell);
cell = new PdfPCell(new Paragraph("入厂煤", font));
cell.Colspan = 4; //定义一个表格单元的跨度
cell.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell);
cell = new PdfPCell(new Paragraph("入炉煤", font));
cell.Colspan = 8;//定义一个表格单元的跨度
cell.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell);
cell = new PdfPCell(new Paragraph("入厂入炉热值差", font));
cell.Colspan = 2;//定义一个表格单元的跨度
cell.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
//cell.FixedHeight = 130f;//设置高度
table.AddCell(cell);
//第二行
cell = new PdfPCell(new Paragraph("全厂当" + typeData, font));
cell.Colspan = 2;//定义一个表格单元的跨度
cell.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell);
cell = new PdfPCell(new Paragraph("全厂" + typeData2 + "累计", font));
cell.Colspan = 2;//定义一个表格单元的跨度
cell.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell);
cell = new PdfPCell(new Paragraph("一二期入炉", font));
cell.Colspan = 2;//定义一个表格单元的跨度
cell.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell);
cell = new PdfPCell(new Paragraph("三期入炉", font));
cell.Colspan = 2;//定义一个表格单元的跨度
cell.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell);
cell = new PdfPCell(new Paragraph("全厂当" + typeData, font));
cell.Colspan = 2;//定义一个表格单元的跨度
cell.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell);
cell = new PdfPCell(new Paragraph("全厂" + typeData2 + "累计", font));
cell.Colspan = 2;//定义一个表格单元的跨度
cell.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell);
cell = new PdfPCell(new Paragraph("全厂当" + typeData, font));
cell.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell);
cell = new PdfPCell(new Paragraph("全厂" + typeData2 + "累计", font));
cell.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell);
string[] titleArr = { "吨量(t)", "热值(kj/kg)", "吨量(t)", "热值(kj/kg)", "吨量(t)", "热值(kj/kg)", "吨量(t)", "热值(kj/kg)", "吨量(t)", "热值(kj/kg)", "吨量(t)", "热值(kj/kg)", "热值(kj/kg)", "热值(kj/kg)" };
foreach (var item in titleArr)
{
cell = new PdfPCell(new Paragraph(item, font2));
cell.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell);
}
#endregion
#region 数据载入
foreach (var item in list)
{
PdfPCell cell_data = new PdfPCell(new Paragraph(item.date, font));//时间
cell_data.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell_data.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell_data);
cell_data = new PdfPCell(new Paragraph(item.qcdd_wt.ToString(), font));//全厂当日吨量
cell_data.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell_data.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell_data);
cell_data = new PdfPCell(new Paragraph(item.qcdd_qr.ToString(), font));//全厂当日热值
cell_data.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell_data.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell_data);
cell_data = new PdfPCell(new Paragraph(item.qcmmsum_wt.ToString(), font));//全厂当月累计吨量
cell_data.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell_data.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell_data);
cell_data = new PdfPCell(new Paragraph(item.qcmmsum_qr.ToString(), font));//全厂当月累计热值
cell_data.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell_data.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell_data);
cell_data = new PdfPCell(new Paragraph(item.rulu12_wt.ToString(), font));//一二期入炉吨量
cell_data.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell_data.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell_data);
cell_data = new PdfPCell(new Paragraph(item.rulu12_qr.ToString(), font));//一二期入炉热值
cell_data.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell_data.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell_data);
cell_data = new PdfPCell(new Paragraph(item.rulu3_wt.ToString(), font));//三期入炉吨量
cell_data.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell_data.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell_data);
cell_data = new PdfPCell(new Paragraph(item.rulu3_qr.ToString(), font));//三期入炉热值
cell_data.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell_data.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell_data);
cell_data = new PdfPCell(new Paragraph(item.ruluqcddsum_wt.ToString(), font));//全厂当日入炉吨量
cell_data.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell_data.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell_data);
cell_data = new PdfPCell(new Paragraph(item.ruluqcddsum_qr.ToString(), font));//全厂当日入炉热值
cell_data.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell_data.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell_data);
cell_data = new PdfPCell(new Paragraph(item.ruluqcmmsum_wt.ToString(), font));//全厂月累计入炉吨量
cell_data.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell_data.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell_data);
cell_data = new PdfPCell(new Paragraph(item.ruluqcmmsum_qr.ToString(), font));//全厂月累计入炉热值
cell_data.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell_data.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell_data);
cell_data = new PdfPCell(new Paragraph(item.qccha_qr1.ToString(), font));//入厂入炉热值差,全厂当日
cell_data.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell_data.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell_data);
cell_data = new PdfPCell(new Paragraph(item.qccha_qr2.ToString(), font));//入厂入炉热值差,全厂月累计
cell_data.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; //垂直居中
cell_data.HorizontalAlignment = PdfPCell.ALIGN_CENTER;//水平居中
table.AddCell(cell_data);
}
#endregion
document.Add(table);
document.Close();
byte[] fileBytes = stream.GetBuffer();
stream.Close();
stream.Dispose();
return File(fileBytes, "application/pdf", DateTime.Now.ToString("yyyyMMddHHmmss") + ".pdf");
}
catch (Exception ex)
{
string msg = string.Empty;
if (ex.InnerException != null)
{
msg = ex.InnerException.Message;
}
else
{
msg = ex.Message;
}
return Content("<script>alert(\"异常:" + msg + "\");</script>");
}
}
C#用iTextSharp导出PDF到页面
最新推荐文章于 2024-08-15 11:28:31 发布