TmtnDevOpsRecordService.cs 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330
  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 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. }
  104. public async Task UpdataDevOpsRecordListAsync(TmtnDevOpsRecordListUpdataModel model)
  105. {
  106. var items = await _tmtnDevOpsRepository.GetByConditionAsync(C => C.C_ID == model.C_DevOpsCode);
  107. var content = items.FirstOrDefault();
  108. if (content == null)
  109. {
  110. throw new Exception("没有此数据");
  111. }
  112. //content.C_Name = model.C_Name;
  113. content.C_Status = model.C_Status;
  114. content.C_LastUpdatedBy = _claims.ApiUserId;
  115. content.D_LastUpdatedOn = DateTime.Now;
  116. _tmtnDevOpsRepository.Update(content);
  117. await _repository.SaveAsync();
  118. //string id = Guid.NewGuid().ToString();
  119. //await _tmtnDevOpsRepository.CreateOneAsync(new TMTN_DevOps
  120. //{
  121. // C_ID = id,
  122. // C_SpotCode = model.C_SpotCode,
  123. // C_Name = model.C_Name,
  124. // C_Remark = model.C_Remark,
  125. // C_CreateBy = _claims.ApiUserId,
  126. // D_CreateOn = DateTime.Now,
  127. // C_Status = "4"
  128. //});
  129. IList<TMTN_DevOpsRecord> devOpsRecordList = new List<TMTN_DevOpsRecord>();
  130. foreach (var item in model.TmtnRecordItemList)
  131. {
  132. //if(string.IsNullOrWhiteSpace(item.C_Record)) { continue; }
  133. TMTN_DevOpsRecord record = new TMTN_DevOpsRecord();
  134. record.C_SpotDevOpsContentCode = item.C_SpotDevOpsContentCode;
  135. record.C_DevOpsCode = model.C_DevOpsCode;
  136. record.C_Record = item.C_Record;
  137. if (item.DevOpsRecordSolidWaste != null)
  138. {
  139. record.C_SolidWaste = JsonConvert.SerializeObject(item.DevOpsRecordSolidWaste);
  140. }
  141. record.C_Remark = item.C_Remark;
  142. record.C_ID = Guid.NewGuid().ToString();
  143. record.C_CreateBy = _claims.ApiUserId;
  144. record.D_CreateOn = DateTime.Now;
  145. record.C_Status = model.C_Status;
  146. devOpsRecordList.Add(record);
  147. if (null != item.FilePaths && item.FilePaths.Any())
  148. {
  149. int i = 0;
  150. foreach (string imgPath in item.FilePaths)
  151. {
  152. if (string.IsNullOrWhiteSpace(imgPath)) { continue; }
  153. await _tmtnDevOpsRecordImageRepository.CreateOneAsync(new TMTN_DevOpsRecordApp
  154. {
  155. C_ID = Guid.NewGuid().ToString(),
  156. C_DevOpsContentCode = record.C_ID,
  157. C_Name = item?.FileNames?.ElementAt<string>(i), //"维保记录"
  158. C_Url = imgPath,
  159. C_Type = "1",
  160. C_Remark = "",
  161. C_CreateBy = _claims.ApiUserId,
  162. D_CreateOn = DateTime.Now,
  163. C_Status = model.C_Status
  164. });
  165. var resultItemImage = await _tmtnDevOpsRecordImageRepository.SaveAsync();
  166. if (!resultItemImage)
  167. {
  168. throw new Exception("创建失败");
  169. }
  170. i++;
  171. }
  172. }
  173. }
  174. var result = await _repository.CreateRangeAsync(devOpsRecordList);
  175. if (result <= 0)
  176. {
  177. throw new Exception("创建失败");
  178. }
  179. }
  180. public async Task<IEnumerable<TmtnDevOpsRecordDetailViewModel>> GetRecordsConditionAsync(TmtnDevOpsRecordDetailSearchModel searchModel)
  181. {
  182. var result = await _repository.GetRecordsConditionAsync(searchModel);
  183. return result;
  184. }
  185. public async Task<IEnumerable<TmtnDevOpsDetailViewModel>> GetDevOpsAsync(TmtnDevOpsDetailSearchModel searchModel)
  186. {
  187. var result = await _repository.GetDevOpsAsync(searchModel);
  188. return result;
  189. }
  190. public async Task<List<List<TmtnDevOpsRecordDetailWithImageViewModel>>> GetRecordItemsGroupByRecordIdAsync(string recordId)
  191. {
  192. var result = await _repository.GetRecordItemsGroupByRecordIdAsync(recordId);
  193. return result;
  194. }
  195. public async Task<IEnumerable<TmtnDevOpsRecordDetailWithImageViewModel>> GetRecordItemsByRecordIdAsync(string recordId)
  196. {
  197. var result = await _repository.GetRecordItemsByRecordIdAsync(recordId);
  198. return result;
  199. }
  200. public async Task DeleteAsync(Guid id)
  201. {
  202. var content = await _repository.GetByIdAsync(id);
  203. if (content == null)
  204. {
  205. throw new Exception("数据库中没有此数据");
  206. }
  207. //_repository.Delete(content);
  208. //var result = await _repository.SaveAsync();
  209. content.C_LastUpdatedBy = _claims.ApiUserId;
  210. content.D_LastUpdatedOn = DateTime.Now;
  211. content.C_Status = "0";
  212. _repository.Update(content);
  213. var result = await _repository.SaveAsync();
  214. if (!result)
  215. {
  216. throw new Exception("删除失败");
  217. }
  218. }
  219. public async Task DeleteAsync(string code)
  220. {
  221. var items = await _repository.GetByConditionAsync(C => C.C_ID == code);
  222. var content = items.FirstOrDefault();
  223. if (content == null)
  224. {
  225. throw new Exception("没有此数据");
  226. }
  227. content.C_LastUpdatedBy = _claims.ApiUserId;
  228. content.D_LastUpdatedOn = DateTime.Now;
  229. content.C_Status = "0";
  230. _repository.Update(content);
  231. var result = await _repository.SaveAsync();
  232. if (!result)
  233. {
  234. throw new Exception("删除失败");
  235. }
  236. }
  237. public async Task<IEnumerable<TmtnDevOpsRecordViewModel>> GetAllAsync()
  238. {
  239. var pagedList = await _repository.GetAllAsync();
  240. var contentDtoList = _mapper.Map<IEnumerable<TmtnDevOpsRecordViewModel>>(pagedList.Where(i => i.C_Status == "1").ToList());
  241. return contentDtoList.ToList();
  242. }
  243. public async Task<IEnumerable<TmtnDevOpsRecordViewModel>> GetConditionAsync(TmtnDevOpsRecordSearchModel searchModel)
  244. {
  245. var predicate = PredicateBuilder.New<TMTN_DevOpsRecord>(true);//查询条件,推荐后台使用这种方式灵活筛选
  246. #region 添加条件查询
  247. //predicate = predicate.And(i => i.C_Status.Equals("1"));
  248. if (!string.IsNullOrEmpty(searchModel.C_SpotDevOpsContentCode))
  249. {
  250. predicate = predicate.And(i => i.C_SpotDevOpsContentCode.Equals(searchModel.C_SpotDevOpsContentCode));
  251. }
  252. if (!string.IsNullOrEmpty(searchModel.C_ID))
  253. {
  254. predicate = predicate.And(i => i.C_ID.Equals(searchModel.C_ID));
  255. }
  256. if (!string.IsNullOrEmpty(searchModel.C_Record))
  257. {
  258. predicate = predicate.And(i => i.C_Record.Contains(searchModel.C_Record));
  259. }
  260. #endregion
  261. var list = await _repository.GetPageAsync(predicate, "C_Name,-D_CreateOn", searchModel.IsPagination, searchModel.PageIndex, searchModel.PageSize);
  262. searchModel.TotalCount = list.Totals;
  263. var dtoList = _mapper.Map<List<TMTN_DevOpsRecord>, List<TmtnDevOpsRecordViewModel>>(list.Rows);
  264. return dtoList;
  265. }
  266. public async Task<TmtnDevOpsRecordViewModel> GetByIdAsync(Guid id)
  267. {
  268. var content = await _repository.GetByIdAsync(id);
  269. var contentDto = _mapper.Map<TmtnDevOpsRecordViewModel>(content);
  270. return contentDto;
  271. }
  272. public async Task UpdateAsync(string code, TmtnDevOpsRecordUpdateModel updateModel)
  273. {
  274. var items = await _repository.GetByConditionAsync(C => C.C_ID == code);
  275. var content = items.FirstOrDefault();
  276. if (content == null)
  277. {
  278. throw new Exception("没有此数据");
  279. }
  280. content.C_LastUpdatedBy = _claims.ApiUserId;
  281. content.D_LastUpdatedOn = DateTime.Now;
  282. _mapper.Map(updateModel, content, typeof(TmtnDevOpsRecordUpdateModel), typeof(TMTN_DevOpsRecord));
  283. _repository.Update(content);
  284. var result = await _repository.SaveAsync();
  285. if (!result)
  286. {
  287. throw new Exception("更新失败");
  288. }
  289. }
  290. public Task<int> UpdateOneAsync(TmtnDevOpsRecordViewModel viewModel, params string[] fields)
  291. {
  292. throw new NotImplementedException();
  293. }
  294. public Task<bool> IsExistAsync(Guid id)
  295. {
  296. throw new NotImplementedException();
  297. }
  298. public Task<IEnumerable<TmtnDevOpsRecordViewModel>> GetByConditionAsync(Expression<Func<TmtnDevOpsRecordViewModel, bool>> expression)
  299. {
  300. throw new NotImplementedException();
  301. }
  302. public Task UpdateAsync(string code, TpntAreaUpdateModel updateModel)
  303. {
  304. throw new NotImplementedException();
  305. }
  306. public Task<IEnumerable<TmtnDevOpsRecordViewModel>> GetConditionAsync(TpntAreaSearchModel searchModel)
  307. {
  308. throw new NotImplementedException();
  309. }
  310. }
  311. }