TmtnDevOpsRecordService.cs 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336
  1. using AutoMapper;
  2. using LinqKit;
  3. using Newtonsoft.Json;
  4. using Ropin.Inspection.Common.Accessor.Interface;
  5. using Ropin.Inspection.Model;
  6. using Ropin.Inspection.Model.Entities;
  7. using Ropin.Inspection.Repository;
  8. using Ropin.Inspection.Repository.Interface;
  9. using System;
  10. using System.Collections.Generic;
  11. using System.Linq;
  12. using System.Linq.Expressions;
  13. using System.Security.Policy;
  14. using System.Text;
  15. using System.Threading.Tasks;
  16. using System.Xml.Linq;
  17. namespace Ropin.Inspection.Service
  18. {
  19. public class TmtnDevOpsRecordService : ITmtnDevOpsRecordService
  20. {
  21. private readonly ITmtnDevOpsRecordRepository _repository;
  22. private readonly ITmtnDevOpsRecordAppRepository _tmtnDevOpsRecordImageRepository;
  23. private readonly ITmtnDevOpsRepository _tmtnDevOpsRepository;
  24. private readonly IMapper _mapper;
  25. private readonly IClaimsAccessor _claims;
  26. public TmtnDevOpsRecordService(IClaimsAccessor claims, ITmtnDevOpsRepository tmtnDevOpsRepository, ITmtnDevOpsRecordRepository repository, ITmtnDevOpsRecordAppRepository tmtnDevOpsRecordImageRepository, IMapper mapper)
  27. {
  28. _repository = repository;
  29. _tmtnDevOpsRecordImageRepository = tmtnDevOpsRecordImageRepository;
  30. _tmtnDevOpsRepository = tmtnDevOpsRepository;
  31. _mapper = mapper;
  32. _claims = claims;
  33. }
  34. public async Task CreateOneAsync(TmtnDevOpsRecordViewModel viewModel)
  35. {
  36. var content = _mapper.Map<TMTN_DevOpsRecord>(viewModel);
  37. content.C_ID = Guid.NewGuid().ToString();
  38. content.C_CreateBy = _claims.ApiUserId;
  39. content.D_CreateOn = DateTime.Now;
  40. content.C_Status = "1";
  41. _repository.Create(content);
  42. var result = await _repository.SaveAsync();
  43. if (!result)
  44. {
  45. throw new Exception("创建失败");
  46. }
  47. }
  48. public async Task<string> CreateDevOpsRecordListAsync(TmtnDevOpsRecordListCreateModel model)
  49. {
  50. string id = Guid.NewGuid().ToString();
  51. await _tmtnDevOpsRepository.CreateOneAsync(new TMTN_DevOps
  52. {
  53. C_ID = id,
  54. C_SpotCode = model.C_SpotCode,
  55. C_Name = model.C_Name,
  56. C_Remark = model.C_Remark,
  57. C_CreateBy = _claims.ApiUserId,
  58. D_CreateOn = DateTime.Now,
  59. C_Status = "1"
  60. });
  61. IList<TMTN_DevOpsRecord> devOpsRecordList = new List<TMTN_DevOpsRecord>();
  62. foreach (var item in model.TmtnRecordItemList)
  63. {
  64. TMTN_DevOpsRecord record = new TMTN_DevOpsRecord();
  65. record.C_SpotDevOpsContentCode = item.C_SpotDevOpsContentCode;
  66. record.C_DevOpsCode = id;
  67. record.C_Record = item.C_Record;
  68. record.C_Remark = item.C_Remark;
  69. record.C_ID = Guid.NewGuid().ToString();
  70. record.C_CreateBy = _claims.ApiUserId;
  71. record.D_CreateOn = DateTime.Now;
  72. record.C_Status = "1";
  73. devOpsRecordList.Add(record);
  74. if (null != item.FilePaths && item.FilePaths.Any())
  75. {
  76. foreach (string imgPath in item.FilePaths)
  77. {
  78. await _tmtnDevOpsRecordImageRepository.CreateOneAsync(new TMTN_DevOpsRecordApp
  79. {
  80. C_ID = Guid.NewGuid().ToString(),
  81. C_DevOpsContentCode = record.C_ID,
  82. C_Name = "维保记录",
  83. C_Url = imgPath,
  84. C_Type = "1",
  85. C_Remark = "",
  86. C_CreateBy = _claims.ApiUserId,
  87. D_CreateOn = DateTime.Now,
  88. C_Status = "1"
  89. });
  90. var resultItemImage = await _tmtnDevOpsRecordImageRepository.SaveAsync();
  91. if (!resultItemImage)
  92. {
  93. throw new Exception("创建失败");
  94. }
  95. }
  96. }
  97. }
  98. var result = await _repository.CreateRangeAsync(devOpsRecordList);
  99. if (result<=0)
  100. {
  101. throw new Exception("创建失败");
  102. }
  103. return id;
  104. }
  105. public async Task UpdataDevOpsRecordListAsync(TmtnDevOpsRecordListUpdataModel model)
  106. {
  107. var items = await _tmtnDevOpsRepository.GetByConditionAsync(C => C.C_ID == model.C_DevOpsCode);
  108. var content = items.FirstOrDefault();
  109. if (content == null)
  110. {
  111. throw new Exception("没有此数据");
  112. }
  113. //content.C_Name = model.C_Name;
  114. content.C_Status = model.C_Status;
  115. content.C_LastUpdatedBy = _claims.ApiUserId;
  116. content.D_LastUpdatedOn = DateTime.Now;
  117. if (model.C_Status=="2"|| model.C_Status == "5")
  118. {
  119. content.C_ExamineBy= _claims.ApiUserId;
  120. content.C_ExamineOn=DateTime.Now;
  121. }
  122. _tmtnDevOpsRepository.Update(content);
  123. await _repository.SaveAsync();
  124. //string id = Guid.NewGuid().ToString();
  125. //await _tmtnDevOpsRepository.CreateOneAsync(new TMTN_DevOps
  126. //{
  127. // C_ID = id,
  128. // C_SpotCode = model.C_SpotCode,
  129. // C_Name = model.C_Name,
  130. // C_Remark = model.C_Remark,
  131. // C_CreateBy = _claims.ApiUserId,
  132. // D_CreateOn = DateTime.Now,
  133. // C_Status = "4"
  134. //});
  135. IList<TMTN_DevOpsRecord> devOpsRecordList = new List<TMTN_DevOpsRecord>();
  136. foreach (var item in model.TmtnRecordItemList)
  137. {
  138. //if(string.IsNullOrWhiteSpace(item.C_Record)) { continue; }
  139. TMTN_DevOpsRecord record = new TMTN_DevOpsRecord();
  140. record.C_SpotDevOpsContentCode = item.C_SpotDevOpsContentCode;
  141. record.C_DevOpsCode = model.C_DevOpsCode;
  142. record.C_Record = item.C_Record;
  143. if (item.DevOpsRecordSolidWaste != null)
  144. {
  145. record.C_SolidWaste = JsonConvert.SerializeObject(item.DevOpsRecordSolidWaste);
  146. }
  147. record.C_Remark = item.C_Remark;
  148. record.C_ID = Guid.NewGuid().ToString();
  149. record.C_CreateBy = _claims.ApiUserId;
  150. record.D_CreateOn = DateTime.Now;
  151. record.C_Status = model.C_Status;
  152. devOpsRecordList.Add(record);
  153. if (null != item.FilePaths && item.FilePaths.Any())
  154. {
  155. int i = 0;
  156. foreach (string imgPath in item.FilePaths)
  157. {
  158. if (string.IsNullOrWhiteSpace(imgPath)) { continue; }
  159. await _tmtnDevOpsRecordImageRepository.CreateOneAsync(new TMTN_DevOpsRecordApp
  160. {
  161. C_ID = Guid.NewGuid().ToString(),
  162. C_DevOpsContentCode = record.C_ID,
  163. C_Name = item?.FileNames?.ElementAt<string>(i), //"维保记录"
  164. C_Url = imgPath,
  165. C_Type = "1",
  166. C_Remark = "",
  167. C_CreateBy = _claims.ApiUserId,
  168. D_CreateOn = DateTime.Now,
  169. C_Status = model.C_Status
  170. });
  171. var resultItemImage = await _tmtnDevOpsRecordImageRepository.SaveAsync();
  172. if (!resultItemImage)
  173. {
  174. throw new Exception("创建失败");
  175. }
  176. i++;
  177. }
  178. }
  179. }
  180. var result = await _repository.CreateRangeAsync(devOpsRecordList);
  181. if (result <= 0)
  182. {
  183. throw new Exception("创建失败");
  184. }
  185. }
  186. public async Task<IEnumerable<TmtnDevOpsRecordDetailViewModel>> GetRecordsConditionAsync(TmtnDevOpsRecordDetailSearchModel searchModel)
  187. {
  188. var result = await _repository.GetRecordsConditionAsync(searchModel);
  189. return result;
  190. }
  191. public async Task<IEnumerable<TmtnDevOpsDetailViewModel>> GetDevOpsAsync(TmtnDevOpsDetailSearchModel searchModel)
  192. {
  193. var result = await _repository.GetDevOpsAsync(searchModel);
  194. return result;
  195. }
  196. public async Task<List<List<TmtnDevOpsRecordDetailWithImageViewModel>>> GetRecordItemsGroupByRecordIdAsync(string recordId)
  197. {
  198. var result = await _repository.GetRecordItemsGroupByRecordIdAsync(recordId);
  199. return result;
  200. }
  201. public async Task<IEnumerable<TmtnDevOpsRecordDetailWithImageViewModel>> GetRecordItemsByRecordIdAsync(string recordId)
  202. {
  203. var result = await _repository.GetRecordItemsByRecordIdAsync(recordId);
  204. return result;
  205. }
  206. public async Task DeleteAsync(Guid id)
  207. {
  208. var content = await _repository.GetByIdAsync(id);
  209. if (content == null)
  210. {
  211. throw new Exception("数据库中没有此数据");
  212. }
  213. //_repository.Delete(content);
  214. //var result = await _repository.SaveAsync();
  215. content.C_LastUpdatedBy = _claims.ApiUserId;
  216. content.D_LastUpdatedOn = DateTime.Now;
  217. content.C_Status = "0";
  218. _repository.Update(content);
  219. var result = await _repository.SaveAsync();
  220. if (!result)
  221. {
  222. throw new Exception("删除失败");
  223. }
  224. }
  225. public async Task DeleteAsync(string code)
  226. {
  227. var items = await _repository.GetByConditionAsync(C => C.C_ID == code);
  228. var content = items.FirstOrDefault();
  229. if (content == null)
  230. {
  231. throw new Exception("没有此数据");
  232. }
  233. content.C_LastUpdatedBy = _claims.ApiUserId;
  234. content.D_LastUpdatedOn = DateTime.Now;
  235. content.C_Status = "0";
  236. _repository.Update(content);
  237. var result = await _repository.SaveAsync();
  238. if (!result)
  239. {
  240. throw new Exception("删除失败");
  241. }
  242. }
  243. public async Task<IEnumerable<TmtnDevOpsRecordViewModel>> GetAllAsync()
  244. {
  245. var pagedList = await _repository.GetAllAsync();
  246. var contentDtoList = _mapper.Map<IEnumerable<TmtnDevOpsRecordViewModel>>(pagedList.Where(i => i.C_Status == "1").ToList());
  247. return contentDtoList.ToList();
  248. }
  249. public async Task<IEnumerable<TmtnDevOpsRecordViewModel>> GetConditionAsync(TmtnDevOpsRecordSearchModel searchModel)
  250. {
  251. var predicate = PredicateBuilder.New<TMTN_DevOpsRecord>(true);//查询条件,推荐后台使用这种方式灵活筛选
  252. #region 添加条件查询
  253. //predicate = predicate.And(i => i.C_Status.Equals("1"));
  254. if (!string.IsNullOrEmpty(searchModel.C_SpotDevOpsContentCode))
  255. {
  256. predicate = predicate.And(i => i.C_SpotDevOpsContentCode.Equals(searchModel.C_SpotDevOpsContentCode));
  257. }
  258. if (!string.IsNullOrEmpty(searchModel.C_ID))
  259. {
  260. predicate = predicate.And(i => i.C_ID.Equals(searchModel.C_ID));
  261. }
  262. if (!string.IsNullOrEmpty(searchModel.C_Record))
  263. {
  264. predicate = predicate.And(i => i.C_Record.Contains(searchModel.C_Record));
  265. }
  266. #endregion
  267. var list = await _repository.GetPageAsync(predicate, "C_Name,-D_CreateOn", searchModel.IsPagination, searchModel.PageIndex, searchModel.PageSize);
  268. searchModel.TotalCount = list.Totals;
  269. var dtoList = _mapper.Map<List<TMTN_DevOpsRecord>, List<TmtnDevOpsRecordViewModel>>(list.Rows);
  270. return dtoList;
  271. }
  272. public async Task<TmtnDevOpsRecordViewModel> GetByIdAsync(Guid id)
  273. {
  274. var content = await _repository.GetByIdAsync(id);
  275. var contentDto = _mapper.Map<TmtnDevOpsRecordViewModel>(content);
  276. return contentDto;
  277. }
  278. public async Task UpdateAsync(string code, TmtnDevOpsRecordUpdateModel updateModel)
  279. {
  280. var items = await _repository.GetByConditionAsync(C => C.C_ID == code);
  281. var content = items.FirstOrDefault();
  282. if (content == null)
  283. {
  284. throw new Exception("没有此数据");
  285. }
  286. content.C_LastUpdatedBy = _claims.ApiUserId;
  287. content.D_LastUpdatedOn = DateTime.Now;
  288. _mapper.Map(updateModel, content, typeof(TmtnDevOpsRecordUpdateModel), typeof(TMTN_DevOpsRecord));
  289. _repository.Update(content);
  290. var result = await _repository.SaveAsync();
  291. if (!result)
  292. {
  293. throw new Exception("更新失败");
  294. }
  295. }
  296. public Task<int> UpdateOneAsync(TmtnDevOpsRecordViewModel viewModel, params string[] fields)
  297. {
  298. throw new NotImplementedException();
  299. }
  300. public Task<bool> IsExistAsync(Guid id)
  301. {
  302. throw new NotImplementedException();
  303. }
  304. public Task<IEnumerable<TmtnDevOpsRecordViewModel>> GetByConditionAsync(Expression<Func<TmtnDevOpsRecordViewModel, bool>> expression)
  305. {
  306. throw new NotImplementedException();
  307. }
  308. public Task UpdateAsync(string code, TpntAreaUpdateModel updateModel)
  309. {
  310. throw new NotImplementedException();
  311. }
  312. public Task<IEnumerable<TmtnDevOpsRecordViewModel>> GetConditionAsync(TpntAreaSearchModel searchModel)
  313. {
  314. throw new NotImplementedException();
  315. }
  316. }
  317. }