AsposeHelper.cs 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236
  1. using Aspose.Cells;
  2. using Aspose.Words;
  3. using Aspose.Words.Tables;
  4. using System.Collections;
  5. using System.Collections.Generic;
  6. using System.Data;
  7. using System.IO;
  8. using System.Web;
  9. using Ubiety.Dns.Core;
  10. namespace OASystem.API.OAMethodLib.File
  11. {
  12. /// <summary>
  13. /// asponse 文档操作
  14. /// </summary>
  15. public class AsposeHelper
  16. {
  17. public const string asposeKey = "DQo8TGljZW5zZT4NCjxEYXRhPg0KPExpY2Vuc2VkVG8+VGhlIFdvcmxkIEJhbms8L0xpY2Vuc2VkVG8+DQo8RW1haWxUbz5ra3VtYXIzQHdvcmxkYmFua2dyb3VwLm9yZzwvRW1haWxUbz4NCjxMaWNlbnNlVHlwZT5EZXZlbG9wZXIgU21hbGwgQnVzaW5lc3M8L0xpY2Vuc2VUeXBlPg0KPExpY2Vuc2VOb3RlPjEgRGV2ZWxvcGVyIEFuZCAxIERlcGxveW1lbnQgTG9jYXRpb248L0xpY2Vuc2VOb3RlPg0KPE9yZGVySUQ+MjEwMzE2MTg1OTU3PC9PcmRlcklEPg0KPFVzZXJJRD43NDQ5MTY8L1VzZXJJRD4NCjxPRU0+VGhpcyBpcyBub3QgYSByZWRpc3RyaWJ1dGFibGUgbGljZW5zZTwvT0VNPg0KPFByb2R1Y3RzPg0KPFByb2R1Y3Q+QXNwb3NlLlRvdGFsIGZvciAuTkVUPC9Qcm9kdWN0Pg0KPC9Qcm9kdWN0cz4NCjxFZGl0aW9uVHlwZT5Qcm9mZXNzaW9uYWw8L0VkaXRpb25UeXBlPg0KPFNlcmlhbE51bWJlcj4wM2ZiMTk5YS01YzhhLTQ4ZGItOTkyZS1kMDg0ZmYwNjZkMGM8L1NlcmlhbE51bWJlcj4NCjxTdWJzY3JpcHRpb25FeHBpcnk+MjAyMjA1MTY8L1N1YnNjcmlwdGlvbkV4cGlyeT4NCjxMaWNlbnNlVmVyc2lvbj4zLjA8L0xpY2Vuc2VWZXJzaW9uPg0KPExpY2Vuc2VJbnN0cnVjdGlvbnM+aHR0cHM6Ly9wdXJjaGFzZS5hc3Bvc2UuY29tL3BvbGljaWVzL3VzZS1saWNlbnNlPC9MaWNlbnNlSW5zdHJ1Y3Rpb25zPg0KPC9EYXRhPg0KPFNpZ25hdHVyZT5XbkJYNnJOdHpCclNMV3pBdFlqOEtkdDFLSUI5MlFrL2xEbFNmMlM1TFRIWGdkcS9QQ2NqWHVORmp0NEJuRmZwNFZLc3VsSjhWeFExakIwbmM0R1lWcWZLek14SFFkaXFuZU03NTJaMjlPbmdyVW40Yk0rc1l6WWVSTE9UOEpxbE9RN05rRFU0bUk2Z1VyQ3dxcjdnUVYxbDJJWkJxNXMzTEFHMFRjQ1ZncEE9PC9TaWduYXR1cmU+DQo8L0xpY2Vuc2U+DQo=";
  18. #region DownWordToModel
  19. /// <summary>
  20. /// 根据Word模板进行数据的导出Word操作
  21. /// </summary>
  22. /// <param name="tempFileName">模板文件名称</param>
  23. /// <param name="saveFolderName">保存文件夹名称</param>
  24. /// <param name="dic">数据源 key 对应 value</param>
  25. /// <param name="listDt">需要循环的数据DataTable 多个注意DataTableName </param>
  26. /// <returns>返回的文档路径</returns>
  27. public static string ExpertWordToModel(string tempFileName, string saveFolderName, string saveFilName, Dictionary<string, object> dic,
  28. List<DataTable>? listDt)
  29. {
  30. try
  31. {
  32. removeWatermark();//加载监听,用于去除水印
  33. List<string> fieldNames = new List<string>(); //字段名字符串数组
  34. List<object> fieldValues = new List<object>(); //字段值数组
  35. foreach (string key in dic.Keys)
  36. {
  37. fieldNames.Add(key);
  38. fieldValues.Add(dic[key]);
  39. }
  40. string tempPath = string.Format("{0}/Word/Template/{1}", AppSettingsHelper.Get("OfficeTempBasePath"), tempFileName);
  41. //// 将文本编码为字节序列
  42. //byte[] encodedBytes = Encoding.UTF8.GetBytes(tempPath);
  43. //// 解码字节序列为文本
  44. //tempPath = Encoding.UTF8.GetString(encodedBytes);
  45. //载入模板
  46. Document doc = new Document(tempPath);
  47. doc.MailMerge.Execute(fieldNames.ToArray(), fieldValues.ToArray());
  48. //将我们获得的DataTable类型的数据:EduDataTable放入doc方法中做处理
  49. if (listDt != null && listDt.Count > 0)
  50. {
  51. foreach (DataTable dt in listDt)
  52. {
  53. if (dt != null && dt.Rows.Count > 0)
  54. {
  55. doc.MailMerge.ExecuteWithRegions(dt);
  56. }
  57. }
  58. }
  59. //合并模版,相当于页面的渲染
  60. doc.MailMerge.Execute(new[] { "PageCount" }, new object[] { doc.PageCount });
  61. //"OfficeTempBasePath": "C:/Server/File/OA2023/Office/"
  62. //saveFolderName:TencentOCR
  63. string path = string.Format("{0}/Word/{1}", AppSettingsHelper.Get("OfficeTempBasePath"), saveFolderName);
  64. if (!System.IO.Directory.Exists(path))
  65. {
  66. System.IO.Directory.CreateDirectory(path);//不存在就创建文件夹
  67. }
  68. string saveFilePath = string.Format("{0}/{1}", path, saveFilName);
  69. //保存合并后的文档
  70. doc.Save(saveFilePath);
  71. saveFilePath = saveFilePath.Replace("D:/FTP/File/OA2023/", AppSettingsHelper.Get("OfficeBaseUrl")); //返回下载地址
  72. return saveFilePath; //返回下载地址
  73. }
  74. catch (Exception ex)
  75. {
  76. return ex.Message;
  77. }
  78. }
  79. /// <summary>
  80. /// 加载监听,用于去除水印
  81. /// </summary>
  82. public static void removeWatermark()
  83. {
  84. new Aspose.Words.License().SetLicense(new MemoryStream(Convert.FromBase64String("PExpY2Vuc2U+CiAgPERhdGE+CiAgICA8TGljZW5zZWRUbz5TdXpob3UgQXVuYm94IFNvZnR3YXJlIENvLiwgTHRkLjwvTGljZW5zZWRUbz4KICAgIDxFbWFpbFRvPnNhbGVzQGF1bnRlYy5jb208L0VtYWlsVG8+CiAgICA8TGljZW5zZVR5cGU+RGV2ZWxvcGVyIE9FTTwvTGljZW5zZVR5cGU+CiAgICA8TGljZW5zZU5vdGU+TGltaXRlZCB0byAxIGRldmVsb3BlciwgdW5saW1pdGVkIHBoeXNpY2FsIGxvY2F0aW9uczwvTGljZW5zZU5vdGU+CiAgICA8T3JkZXJJRD4yMDA2MDIwMTI2MzM8L09yZGVySUQ+CiAgICA8VXNlcklEPjEzNDk3NjAwNjwvVXNlcklEPgogICAgPE9FTT5UaGlzIGlzIGEgcmVkaXN0cmlidXRhYmxlIGxpY2Vuc2U8L09FTT4KICAgIDxQcm9kdWN0cz4KICAgICAgPFByb2R1Y3Q+QXNwb3NlLlRvdGFsIGZvciAuTkVUPC9Qcm9kdWN0PgogICAgPC9Qcm9kdWN0cz4KICAgIDxFZGl0aW9uVHlwZT5FbnRlcnByaXNlPC9FZGl0aW9uVHlwZT4KICAgIDxTZXJpYWxOdW1iZXI+OTM2ZTVmZDEtODY2Mi00YWJmLTk1YmQtYzhkYzBmNTNhZmE2PC9TZXJpYWxOdW1iZXI+CiAgICA8U3Vic2NyaXB0aW9uRXhwaXJ5PjIwMjEwODI3PC9TdWJzY3JpcHRpb25FeHBpcnk+CiAgICA8TGljZW5zZVZlcnNpb24+My4wPC9MaWNlbnNlVmVyc2lvbj4KICAgIDxMaWNlbnNlSW5zdHJ1Y3Rpb25zPmh0dHBzOi8vcHVyY2hhc2UuYXNwb3NlLmNvbS9wb2xpY2llcy91c2UtbGljZW5zZTwvTGljZW5zZUluc3RydWN0aW9ucz4KICA8L0RhdGE+CiAgPFNpZ25hdHVyZT5wSkpjQndRdnYxV1NxZ1kyOHFJYUFKSysvTFFVWWRrQ2x5THE2RUNLU0xDQ3dMNkEwMkJFTnh5L3JzQ1V3UExXbjV2bTl0TDRQRXE1aFAzY2s0WnhEejFiK1JIWTBuQkh1SEhBY01TL1BSeEJES0NGbWg1QVFZRTlrT0FxSzM5NVBSWmJRSGowOUNGTElVUzBMdnRmVkp5cUhjblJvU3dPQnVqT1oyeDc4WFE9PC9TaWduYXR1cmU+CjwvTGljZW5zZT4=")));
  85. }
  86. ///// <summary>
  87. ///// 加载监听,用于去除水印
  88. ///// </summary>
  89. //public static void removeWatermark()
  90. //{
  91. // new Aspose.Words.License().SetLicense(new MemoryStream(Convert.FromBase64String("PExpY2Vuc2U+CiAgPERhdGE+CiAgICA8TGljZW5zZWRUbz5TdXpob3UgQXVuYm94IFNvZnR3YXJlIENvLiwgTHRkLjwvTGljZW5zZWRUbz4KICAgIDxFbWFpbFRvPnNhbGVzQGF1bnRlYy5jb208L0VtYWlsVG8+CiAgICA8TGljZW5zZVR5cGU+RGV2ZWxvcGVyIE9FTTwvTGljZW5zZVR5cGU+CiAgICA8TGljZW5zZU5vdGU+TGltaXRlZCB0byAxIGRldmVsb3BlciwgdW5saW1pdGVkIHBoeXNpY2FsIGxvY2F0aW9uczwvTGljZW5zZU5vdGU+CiAgICA8T3JkZXJJRD4yMDA2MDIwMTI2MzM8L09yZGVySUQ+CiAgICA8VXNlcklEPjEzNDk3NjAwNjwvVXNlcklEPgogICAgPE9FTT5UaGlzIGlzIGEgcmVkaXN0cmlidXRhYmxlIGxpY2Vuc2U8L09FTT4KICAgIDxQcm9kdWN0cz4KICAgICAgPFByb2R1Y3Q+QXNwb3NlLlRvdGFsIGZvciAuTkVUPC9Qcm9kdWN0PgogICAgPC9Qcm9kdWN0cz4KICAgIDxFZGl0aW9uVHlwZT5FbnRlcnByaXNlPC9FZGl0aW9uVHlwZT4KICAgIDxTZXJpYWxOdW1iZXI+OTM2ZTVmZDEtODY2Mi00YWJmLTk1YmQtYzhkYzBmNTNhZmE2PC9TZXJpYWxOdW1iZXI+CiAgICA8U3Vic2NyaXB0aW9uRXhwaXJ5PjIwMjEwODI3PC9TdWJzY3JpcHRpb25FeHBpcnk+CiAgICA8TGljZW5zZVZlcnNpb24+My4wPC9MaWNlbnNlVmVyc2lvbj4KICAgIDxMaWNlbnNlSW5zdHJ1Y3Rpb25zPmh0dHBzOi8vcHVyY2hhc2UuYXNwb3NlLmNvbS9wb2xpY2llcy91c2UtbGljZW5zZTwvTGljZW5zZUluc3RydWN0aW9ucz4KICA8L0RhdGE+CiAgPFNpZ25hdHVyZT5wSkpjQndRdnYxV1NxZ1kyOHFJYUFKSysvTFFVWWRrQ2x5THE2RUNLU0xDQ3dMNkEwMkJFTnh5L3JzQ1V3UExXbjV2bTl0TDRQRXE1aFAzY2s0WnhEejFiK1JIWTBuQkh1SEhBY01TL1BSeEJES0NGbWg1QVFZRTlrT0FxSzM5NVBSWmJRSGowOUNGTElVUzBMdnRmVkp5cUhjblJvU3dPQnVqT1oyeDc4WFE9PC9TaWduYXR1cmU+CjwvTGljZW5zZT4=")));
  92. //}
  93. #endregion
  94. #region DownExcelToModel
  95. /// <summary>
  96. /// 根据Word模板进行数据的导出Word操作
  97. /// </summary>
  98. /// <param name="tempFileName">Excel模板文件名称</param>
  99. /// <param name="saveFolderName">保存文件夹名称</param>
  100. /// <param name="saveFilName">保存文件名称</param>
  101. /// <param name="dic">数据源 key 对应 value</param>
  102. /// <param name="listDt">需要循环的数据DataTable 多个注意DataTableName </param>
  103. /// <returns>返回的文档路径</returns>
  104. public static string ExpertExcelToModel(string tempFileName, string saveFolderName, string saveFilName, Dictionary<string, object> dic,
  105. List<DataTable>? listDt)
  106. {
  107. try
  108. {
  109. string tempPath = string.Format("{0}/Excel/Template/{1}", AppSettingsHelper.Get("OfficeTempBasePath"), tempFileName);
  110. //载入模板
  111. Workbook wbook = new Workbook(tempPath);
  112. //默认第一个工作表
  113. Worksheet wSheet = wbook.Worksheets[0];
  114. WorkbookDesigner designer = new WorkbookDesigner(wbook);
  115. //数据源 多个
  116. if (listDt != null && listDt.Count > 0)
  117. {
  118. foreach (var item in listDt)
  119. {
  120. if (item.Rows.Count > 0)
  121. {
  122. //designer.SetDataSource(item.TableName, item);
  123. designer.SetDataSource(item);
  124. }
  125. }
  126. }
  127. //报表单位
  128. if (dic.Count > 0)
  129. {
  130. foreach (var item in dic)
  131. {
  132. designer.SetDataSource(item.Key, item.Value);
  133. }
  134. }
  135. designer.Process();
  136. string path = string.Format("{0}/Excel/{1}", AppSettingsHelper.Get("OfficeTempBasePath"), saveFolderName);
  137. if (!System.IO.Directory.Exists(path))
  138. {
  139. System.IO.Directory.CreateDirectory(path);//不存在就创建文件夹
  140. }
  141. string saveFilePath = string.Format("{0}/{1}", path, saveFilName);
  142. //保存合并后的文档
  143. wbook.Save(saveFilePath);
  144. //saveFilePath = saveFilePath.Replace("C:/Server/File/0A2023/", AppSettingsHelper.Get("OfficeBaseUrl")); //返回下载地址
  145. saveFilePath = AppSettingsHelper.Get("OfficeBaseUrl") + "/Office/Excel/" + saveFolderName + "/" + saveFilName;
  146. return saveFilePath; //返回下载地址
  147. }
  148. catch (Exception ex)
  149. {
  150. return ex.Message;
  151. }
  152. }
  153. #endregion
  154. #region Aspose.Words 21.8.0 去水印
  155. /// <summary>
  156. /// Aspose.Words 去水印
  157. /// version 21.8.0
  158. /// </summary>
  159. public static void removewatermark_v2180 ()
  160. {
  161. new Aspose.Words.License().SetLicense(new MemoryStream(Convert.FromBase64String(asposeKey)));
  162. }
  163. #endregion
  164. #region List<T> 转 Datatbale
  165. /// <summary>
  166. /// 将List转换为DataTable
  167. /// </summary>
  168. /// <param name="newTableName">newTableName</param>
  169. /// <param name="list">请求数据</param>
  170. /// <returns></returns>
  171. public static DataTable ListToDataTable<T>(string newTableName, List<T> list)
  172. {
  173. //创建一个名为"tableName"的空表
  174. DataTable dt = new DataTable(newTableName);
  175. //创建传入对象名称的列
  176. foreach (var item in list.FirstOrDefault().GetType().GetProperties())
  177. {
  178. dt.Columns.Add(item.Name);
  179. }
  180. //循环存储
  181. foreach (var item in list)
  182. {
  183. //新加行
  184. DataRow value = dt.NewRow();
  185. //根据DataTable中的值,进行对应的赋值
  186. foreach (DataColumn dtColumn in dt.Columns)
  187. {
  188. int i = dt.Columns.IndexOf(dtColumn);
  189. //基元元素,直接复制,对象类型等,进行序列化
  190. if (value.GetType().IsPrimitive)
  191. {
  192. value[i] = item.GetType().GetProperty(dtColumn.ColumnName).GetValue(item);
  193. }
  194. else
  195. {
  196. value[i] = JsonConvert.SerializeObject(item.GetType().GetProperty(dtColumn.ColumnName).GetValue(item));
  197. }
  198. }
  199. dt.Rows.Add(value);
  200. }
  201. return dt;
  202. }
  203. #endregion
  204. }
  205. }