ASP.NET 利用第三方插件DocX产生Word 转换为PDF打印

时间： 2016/11/13 17:06:21

客户需求：

　　上两篇博客主要介绍了通过Word进行费用报销凭证的打印及批量打印。

　　虽然可以进行打印，但是还是存在问题，有的客户机器MS Office 安装会有问题，那么通过DocX产生的Word在客户机器上无法打开，所以还是有些瑕疵。

　　还有一个问题，就是这样的打印体验很不好，因为每次打印要把word下载下来进行打印，所以，用户体验不是很好。

　　之前，有想过通过office控件进行处理，但是由于每个客户端的浏览器不同对插件的支持程度不同，所以这方案很快被否掉了。

　　最后，决定将Word在服务端转换成PDF，然后在线打开PDF进行凭证的打印。

解决方案：

　　将Word在服务端转换成PDF，然后在线打开PDF进行凭证的打印。

　　在此使用的第三方插件为NETOffice。

　　.NET包装程序集件，用于访问以下MS Office应用程序：　Office，Excel，Word，Outlook，PowerPoint，Visio

　　Office集成，无版本限制

　　包括Office版本2000,2002,2003,2007,2010,2013的所有功能

　　具体介绍请参考官网：http://netoffice.codeplex.com/

Demo程式代码：

　　demo界面：

　　生产Word程式代码：

  1  private void ExportWord()
  2     {
  3 
  4 
  5         //模板路径
  6         string mWordTemplateSrc = Request.PhysicalPath.Replace("ExportWordAPI.aspx", "ExportWordTemplate.docx");
  7 
  8         //Word文件路径
  9         string mGuid = System.Guid.NewGuid().ToString();
 10         string mWordSrc = Request.PhysicalPath.Replace("ExportWord\\ExportWordAPI.aspx", "WordToPDF\\Temp\\" + mGuid + ".docx");
 11         string IsPDF = Request.QueryString["IsPDF"];
 12 
 13         MemoryStream stream = new MemoryStream();
 14         using (DocX docPrint = DocX.Create(stream, DocumentTypes.Template))
 15         {
 16             DocX doc;
 17             string mIds = Request.QueryString["SheetNo"];
 18             string[] mSheets = mIds.Split(''|'');
 19             //int iLength = 0;
 20             int iPrintCount = 0;
 21             int mParagraphsIndex = 0;
 22             foreach (string sheetNo in mSheets)
 23             {
 24                 //iLength++;
 25                 if (string.IsNullOrEmpty(sheetNo.Trim())) continue;
 26 
 27                 iPrintCount++;
 28 
 29                 //加载模板
 30                 doc = DocX.Load(mWordTemplateSrc);
 31                 //输出打印内容到模板
 32                 ExportWord(ref doc, "FYBX", sheetNo);
 33 
 34                 if (iPrintCount > 1)
 35                 {
 36                     mParagraphsIndex = docPrint.Paragraphs.Count - 1;
 37                     docPrint.Paragraphs[mParagraphsIndex].InsertPageBreakAfterSelf();
 38                     mParagraphsIndex = docPrint.Paragraphs.Count - 1;
 39                     docPrint.Paragraphs[mParagraphsIndex].SetLineSpacing(LineSpacingType.Line, 0);
 40                     docPrint.Paragraphs[mParagraphsIndex].SetLineSpacing(LineSpacingType.Before, 0);
 41                     docPrint.Paragraphs[mParagraphsIndex].SetLineSpacing(LineSpacingType.After, 0);
 42                 }
 43                 //将打印内容插入打印word中
 44                 docPrint.InsertDocument(doc, true);
 45             }
 46             if (IsPDF == "Y")
 47             {
 48                 docPrint.SaveAs(mWordSrc);
 49             }
 50             else
 51             {
 52                 docPrint.Save();
 53             }
 54         }
 55 
 56 
 57         if (IsPDF == "Y")
 58         {
 59             Response.Redirect("../WordToPDF/WordToPDF.aspx?guid=" + mGuid);
 60         }
 61         else
 62         {
 63             byte[] tAryByte = stream.ToArray();
 64             Response.Clear();
 65             Response.AddHeader("Content-Length", tAryByte.Length.ToString());
 66             Response.AppendHeader("Content-Disposition", string.Format("attachment;filename=ExportWord_{0}.docx", DateTime.Now.ToString("yyMMddHHmmss")));
 67             Response.ContentType = "application/vnd.openxmlformats-officedocument.wordprocessingml.document";
 68             Response.BinaryWrite(tAryByte);
 69             Response.Flush();
 70             Response.End();
 71         }
 72     }
 73 
 74     private void ExportWord(ref DocX doc, string pFormID, string pSheetNO)
 75     {
 76         IDictionary par = new Dictionary<string, object>();
 77         string sql = "SELECT * FROM  head WHERE head001=@head001 AND head002=@head002  ";
 78         par.Clear();
 79         par.Add("head001", pFormID);
 80         par.Add("head002", pSheetNO);
 81         DataTable dtHead = SqlDBHelper.ExecuteDataTable(this.SqlServerConnection, sql, par);//单头数据
 82 
 83         sql = "SELECT * FROM  body WHERE body001=@body001 AND body002=@body002 ";//单身数据
 84         par.Clear();
 85         par.Add("body001", pFormID);
 86         par.Add("body002", pSheetNO);
 87         DataTable dtBody = SqlDBHelper.ExecuteDataTable(this.SqlServerConnection, sql, par);
 88 
 89 
 90         thisReplaceText(ref doc, "head002", dtHead.Rows[0]["head002"].ToString());
 91         thisReplaceText(ref doc, "head003", dtHead.Rows[0]["head003"].ToString());
 92         thisReplaceText(ref doc, "head004", dtHead.Rows[0]["head004"].ToString());
 93         thisReplaceText(ref doc, "head005", dtHead.Rows[0]["head005"].ToString());
 94         thisReplaceText(ref doc, "head006", dtHead.Rows[0]["head006"].ToString());
 95         thisReplaceText(ref doc, "head008", dtHead.Rows[0]["head008"].ToString());
 96         thisReplaceText(ref doc, "head009", dtHead.Rows[0]["head009"].ToString());
 97         thisReplaceText(ref doc, "M", dtHead.Rows[0]["head010"].ToString());
 98 
 99         int bodyRowIndex = 0;
100 
101         int rowLength = 8;
102         Row insertRow = doc.Tables[0].Rows[rowLength];
103 
104         int mRowsLength = 0;
105         foreach (DataRow dr in dtBody.Rows)
106         {
107             mRowsLength += 1;
108             if (mRowsLength <= 5)
109             {
110                 doc.Tables[0].Rows[2 + mRowsLength].Cells[0].Paragraphs[0].Append(dr["body003"].ToString());
111                 doc.Tables[0].Rows[2 + mRowsLength].Cells[1].Paragraphs[0].Append(dr["body004"].ToString());
112                 doc.Tables[0].Rows[2 + mRowsLength].Cells[2].Paragraphs[0].Append(dr["body005"].ToString());
113             }
114             else
115             {
116                 //获取到模板行的对象（一般是一个空行，只有架子没有数据的）
117                 doc.Tables[0].Rows[rowLength + bodyRowIndex].Xml.AddAfterSelf(insertRow.Xml);
118                 bodyRowIndex += 1;
119                 doc.Tables[0].Rows[rowLength + bodyRowIndex].Cells[0].Paragraphs[0].Append(dr["body003"].ToString());
120                 doc.Tables[0].Rows[rowLength + bodyRowIndex].Cells[1].Paragraphs[0].Append(dr["body004"].ToString());
121                 doc.Tables[0].Rows[rowLength + bodyRowIndex].Cells[2].Paragraphs[0].Append(dr["body005"].ToString());
122             }
123         }
124         //删除模板行，要不然会有一个空行
125         doc.Tables[0].RemoveRow(rowLength);
126     }
127 
128     private void thisReplaceText(ref DocX document, string o, string n)
129     {
130         string OO = "[" + o + "]";
131         document.ReplaceText(OO, n, false, System.Text.RegularExpressions.RegexOptions.None, null, null, MatchFormattingOptions.SubsetMatch, true, false);
132     }

View Code

　　Word转换成PDF代码：

 1 string guid = Request.QueryString["guid"];
 2 
 3         //模板路径
 4         string mWordSrc = Request.PhysicalPath.Replace("WordToPDF.aspx", "\\Temp\\" + guid + ".docx");
 5         string mPDFSrc = Request.PhysicalPath.Replace("WordToPDF.aspx", "\\Temp\\" + guid + ".pdf");
 6 
 7         try
 8         {
 9             Word.Application wordApplication = new Word.Application();
10             Word.Document pDoc = wordApplication.Documents.Open(mWordSrc);
11             pDoc.Activate();
12          
13             pDoc.SaveAs(mPDFSrc, WdSaveFormat.wdFormatPDF);
14             wordApplication.Quit();
15             wordApplication.Dispose();
16 
17             if (System.IO.File.Exists(mPDFSrc))
18             {
19                 byte[] tAryByte = System.IO.File.ReadAllBytes(mPDFSrc);
20                 Response.Clear();
21                 Response.AddHeader("Content-Length", tAryByte.Length.ToString());
22                 Response.AppendHeader("Content-Disposition", string.Format("inline;filename=ExportWord2PDF_{0}.docx", DateTime.Now.ToString("yyMMddHHmmss")));
23                 Response.ContentType = "application/pdf";
24                 Response.BinaryWrite(tAryByte);
25                 Response.Flush();
26                 Response.End();
27 
28             }
29         }
30         catch (Exception ex)
31         {
32             Response.Clear();
33             Response.Write(ex.Message);
34             Response.Flush();
35             Response.End();
36         }
37         finally
38         {
39             //删除缓存文件
40             if (System.IO.File.Exists(mPDFSrc)) System.IO.File.Delete(mPDFSrc);  
41             if (System.IO.File.Exists(mWordSrc)) System.IO.File.Delete(mWordSrc);  
42 
43         }

View Code

代码地址： http://pan.baidu.com/s/1sltlp5j

上一篇：使用ServiceStack缓存技术

下一篇： asp.net dataTable转换成Json格式