TdevDevStoreDocController.cs 9.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251
  1. using Microsoft.AspNetCore.Authorization;
  2. using Microsoft.AspNetCore.Mvc;
  3. using Microsoft.Extensions.Logging;
  4. using NPOI.SS.UserModel;
  5. using NPOI.Util;
  6. using NPOI.XSSF.UserModel;
  7. using NPOI.XWPF.UserModel;
  8. using Ropin.Inspection.Api.Common;
  9. using Ropin.Inspection.Api.Controllers;
  10. using Ropin.Inspection.Common.Helper;
  11. using Ropin.Inspection.Model;
  12. using Ropin.Inspection.Model.Common;
  13. using Ropin.Inspection.Service;
  14. using System;
  15. using System.Collections.Generic;
  16. using System.IO.Compression;
  17. using System.IO;
  18. using System.Linq;
  19. using System.Threading.Tasks;
  20. using System.Security.Claims;
  21. using log4net;
  22. namespace Ropin.Inspection.Api
  23. {
  24. public class TdevDevStoreDocController : BaseController
  25. {
  26. private static readonly ILog log = LogManager.GetLogger(typeof(TdevDevStoreDocController));
  27. public ILogger<TdevDevStoreDocController> _logger { get; }
  28. private readonly ITdevDevStoreDocService _TdevDevStoreDocService;
  29. /// <summary>
  30. /// 构造函数
  31. /// </summary>
  32. /// <param name="TdevDevStoreDocService"></param>
  33. /// <param name="logger"></param>
  34. public TdevDevStoreDocController(ITdevDevStoreDocService TdevDevStoreDocService, ILogger<TdevDevStoreDocController> logger)
  35. {
  36. _TdevDevStoreDocService = TdevDevStoreDocService;
  37. _logger = logger;
  38. }
  39. /// <summary>
  40. /// 创建业主设备文档
  41. /// </summary>
  42. /// <param name="content"></param>
  43. /// <returns></returns>
  44. [HttpPost("CreateDevStoreDocAsync")]
  45. public async Task<ApiResult> CreateDevStoreDocAsync(TdevDevStoreDocViewModel content)
  46. {
  47. if (content == null)
  48. {
  49. return new ApiResult(ReturnCode.ArgsError);
  50. }
  51. try
  52. {
  53. await _TdevDevStoreDocService.CreateOneAsync(content);
  54. }
  55. catch (Exception ex)
  56. {
  57. return new ApiResult(ReturnCode.GeneralError, ex.Message);
  58. }
  59. return new ApiResult(ReturnCode.Success);
  60. }
  61. /// <summary>
  62. /// 删除业主设备文档
  63. /// </summary>
  64. /// <param name="id"></param>
  65. /// <returns></returns>
  66. [HttpDelete("DeleteDevStoreDocAsync/{id}")]
  67. public async Task<ApiResult> DeleteDevStoreDocAsync(string id)
  68. {
  69. if (string.IsNullOrEmpty(id))
  70. {
  71. return new ApiResult(ReturnCode.GeneralError);
  72. }
  73. try
  74. {
  75. await _TdevDevStoreDocService.DeleteAsync(id);
  76. }
  77. catch (Exception ex)
  78. {
  79. return new ApiResult(ReturnCode.GeneralError, ex.Message);
  80. }
  81. return new ApiResult(ReturnCode.Success);
  82. }
  83. /// <summary>
  84. /// 更新业主设备文档
  85. /// </summary>
  86. /// <param name="id"></param>
  87. /// <param name="updateModel"></param>
  88. /// <returns></returns>
  89. [HttpPut("UpdateDevStoreDocAsync/{id}")]
  90. [AllowAnonymous]
  91. public async Task<ApiResult> UpdateDevStoreDocAsync(string id, TdevDevStoreDocViewModel updateModel)
  92. {
  93. if (string.IsNullOrEmpty(id))
  94. {
  95. return new ApiResult(ReturnCode.GeneralError);
  96. }
  97. try
  98. {
  99. await _TdevDevStoreDocService.UpdateAsync(id, updateModel);
  100. }
  101. catch (Exception ex)
  102. {
  103. return new ApiResult(ReturnCode.GeneralError, ex.Message);
  104. }
  105. return new ApiResult(ReturnCode.Success);
  106. }
  107. /// <summary>
  108. /// 通过id获取业主设备文档信息
  109. /// </summary>
  110. /// <returns></returns>
  111. [HttpPost("GetDevStoreDocAsync")]
  112. [AllowAnonymous]
  113. public async Task<ApiResult> GetDevStoreDocAsync(TdevDevStoreDocSearchModel searchModel)
  114. {
  115. if (searchModel == null)
  116. {
  117. return new ApiResult(ReturnCode.ArgsError);
  118. }
  119. try
  120. {
  121. //var content = await _TdevDevStoreDocService.GetConditionAsync(new TdevDevStoreDocSearchModel { C_ID = id });
  122. //var dev = content.FirstOrDefault();
  123. //return new ApiResult<TdevDevStoreDocViewModel>(dev);
  124. var contentList = await _TdevDevStoreDocService.GetConditionAsync(searchModel);
  125. return new ApiResult<PagesModel<TdevDevStoreDocViewModel>>(new PagesModel<TdevDevStoreDocViewModel>(contentList, searchModel));
  126. }
  127. catch (Exception ex)
  128. {
  129. return new ApiResult(ReturnCode.GeneralError, ex.Message);
  130. }
  131. }
  132. /// <summary>
  133. /// 获取设备文档(包括关联的模板文档)
  134. /// </summary>
  135. /// <returns></returns>
  136. [HttpPost("GetDevFile")]
  137. [AllowAnonymous]
  138. public async Task<ApiResult> GetDevFile(TdevDevStoreDocSearchModel searchModel)
  139. {
  140. if (searchModel == null)
  141. {
  142. return new ApiResult(ReturnCode.ArgsError);
  143. }
  144. try
  145. {
  146. var contentList = await _TdevDevStoreDocService.GetDevFile(searchModel);
  147. return new ApiResult<PagesModel<TdevDevStoreDocViewModel>>(new PagesModel<TdevDevStoreDocViewModel>(contentList, searchModel));
  148. }
  149. catch (Exception ex)
  150. {
  151. return new ApiResult(ReturnCode.GeneralError, ex.Message);
  152. }
  153. }
  154. /// <summary>
  155. /// 通过业主设备id获取业主设备文档信息
  156. /// </summary>
  157. /// <param name="id"></param>
  158. /// <returns></returns>
  159. [HttpGet("GetDevStoreDocByCodeAsync/{id}")]
  160. [AllowAnonymous]
  161. public async Task<ApiResult> GetDevStoreDocByCodeAsync(string id)
  162. {
  163. if (string.IsNullOrEmpty(id))
  164. {
  165. return new ApiResult(ReturnCode.GeneralError);
  166. }
  167. try
  168. {
  169. var content = await _TdevDevStoreDocService.GetConditionAsync(new TdevDevStoreDocSearchModel { C_DevStoreCode = id });
  170. var dev = content.ToList();
  171. return new ApiResult<IEnumerable<TdevDevStoreDocViewModel>>(new List<TdevDevStoreDocViewModel>(dev));
  172. }
  173. catch (Exception ex)
  174. {
  175. return new ApiResult(ReturnCode.GeneralError, ex.Message);
  176. }
  177. }
  178. /// <summary>
  179. /// 发送邮件(附件设备文档)
  180. /// </summary>
  181. /// <param name="searchModel"></param>
  182. /// <returns></returns>
  183. [HttpPost("SendDevStoreDocToEmail")]
  184. public async Task SendDevStoreDocToEmail(SendDevStoreDocToEmailModel searchModel)
  185. {
  186. log.Info("设备文档导出压缩文件");
  187. if (searchModel == null || string.IsNullOrEmpty(searchModel.C_DevStoreCode))
  188. {
  189. return;
  190. }
  191. try
  192. {
  193. var contentList = await _TdevDevStoreDocService.GetDevFile(searchModel);
  194. if (contentList==null|| contentList.Count()==0)
  195. {
  196. return;
  197. }
  198. string zip = @"wwwroot\\ZipFile";
  199. if (!System.IO.Directory.Exists(zip))
  200. {
  201. Directory.CreateDirectory(zip);
  202. }
  203. string zipPaht = zip + "\\规范标准文档_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".zip";
  204. using (ZipArchive zipArchive = ZipFile.Open(zipPaht, ZipArchiveMode.Create))
  205. {
  206. foreach (var item in contentList)
  207. {
  208. if (item != null)
  209. {
  210. var direPath = Directory.GetCurrentDirectory();
  211. var fileUrl = direPath + item.C_Url;//Path.Combine(direPath, item.C_Url);
  212. log.Info($"设备文档导出压缩文件,项目路径{direPath},文件全路径地址:{fileUrl}");
  213. if (System.IO.File.Exists(fileUrl))
  214. {
  215. log.Info($"设备文档导出压缩文件,文件地址:{fileUrl},判断为存在");
  216. string fileName = Path.GetFileName(fileUrl);
  217. zipArchive.CreateEntryFromFile(fileUrl, fileName);
  218. }
  219. }
  220. }
  221. }
  222. var zipFile1 = new FileStream(zipPaht, FileMode.Open);
  223. string emailName = $"{searchModel.DevName}规范标准文档";
  224. EmailHelper.SendEmail(searchModel.Mails, emailName, "", "报表见附件", $"{emailName}.zip", "application/zip", zipFile1);
  225. System.IO.File.Delete(zipPaht);
  226. }
  227. catch (Exception ex)
  228. {
  229. throw;
  230. }
  231. }
  232. }
  233. }