VmcCameraService.cs 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254
  1. using AutoMapper;
  2. using Ropin.Core.Common;
  3. using Ropin.Inspection.Common.Accessor.Interface;
  4. using Ropin.Inspection.Model.Entities;
  5. using Ropin.Inspection.Model.SearchModel.VMC;
  6. using Ropin.Inspection.Model.ViewModel.VMC;
  7. using Ropin.Inspection.Repository.VMC.Interface;
  8. using Ropin.Inspection.Service.VMC.Interface;
  9. using System;
  10. using System.Collections.Generic;
  11. using System.Linq;
  12. using System.Text;
  13. using System.Threading.Tasks;
  14. namespace Ropin.Inspection.Service.VMC
  15. {
  16. public class VmcCameraService: IVmcCameraService
  17. {
  18. private readonly IVmcCameraRepository _repository;
  19. private readonly IVmcCameraMigrateRepository _vmcCameraMigrateRepository;
  20. private readonly IVMCDevCameraRepository _vmcDevCameraRepository;
  21. private readonly IMapper _mapper;
  22. private readonly IClaimsAccessor _claims;
  23. private readonly InspectionDbContext _sqlDBContext;
  24. public VmcCameraService(IClaimsAccessor claims, InspectionDbContext sqlDBContext, IVmcCameraRepository repository, IMapper mapper, IVmcCameraMigrateRepository vmcCameraMigrateRepository, IVMCDevCameraRepository vmcDevCameraRepository)
  25. {
  26. _repository = repository;
  27. _vmcCameraMigrateRepository = vmcCameraMigrateRepository;
  28. _mapper = mapper;
  29. _claims = claims;
  30. _sqlDBContext = sqlDBContext;
  31. _vmcDevCameraRepository = vmcDevCameraRepository;
  32. }
  33. public async Task<IEnumerable<VmcCameraViewModel>> GetConditionAsync(VmcCameraSearch searchModel)
  34. {
  35. var list = await _repository.GetConditionAsync(searchModel);
  36. return list;
  37. }
  38. public async Task<IEnumerable<VmcCameraMigrateViewModel>> GetCameraMigrateConditionAsync(VmcCameraMigrateSearch searchModel)
  39. {
  40. var list = await _vmcCameraMigrateRepository.GetConditionAsync(searchModel);
  41. return list;
  42. }
  43. public async Task<IEnumerable<VmcDevCameraViewModel>> GetDevCameraConditionAsync(VmcDevSearch searchModel)
  44. {
  45. var list = await _vmcDevCameraRepository.GetConditionAsync(searchModel);
  46. return list;
  47. }
  48. public async Task CreateCameraMigrate(TVMC_CameraMigrate content)
  49. {
  50. var models = await _repository.GetByIdAsync(content.C_CameraCode);
  51. if (models == null)
  52. {
  53. throw new Exception("没有找到该摄像头数据");
  54. }
  55. content.C_ID = Guid.NewGuid().ToString();
  56. content.C_CreateBy = _claims.ApiUserId.ToString();
  57. content.D_CreateOn = DateTime.Now;
  58. _vmcCameraMigrateRepository.Create(content);
  59. var result = await _vmcCameraMigrateRepository.SaveAsync();
  60. if (result)
  61. {
  62. models.C_StoreCode = content.C_CurrentStoreCode;
  63. models.C_LastUpdatedBy = _claims.Linsence == null ? _claims.ApiUserId.ToString() : "6e864cbc-5252-11ec-8681-fa163e02b3e4";
  64. models.D_LastUpdatedOn = DateTime.Now;
  65. _repository.Update(models);
  66. var result1 = await _repository.SaveAsync();
  67. if (!result1)
  68. {
  69. throw new Exception("数据迁移失败");
  70. }
  71. }
  72. if (!result)
  73. {
  74. throw new Exception("创建失败");
  75. }
  76. }
  77. public async Task CreateDevCamera(TVMC_DevCamera content)
  78. {
  79. content.C_ID = Guid.NewGuid().ToString();
  80. content.C_CreateBy = _claims.ApiUserId.ToString();
  81. content.D_CreateOn = DateTime.Now;
  82. content.C_Creator=_claims.ApiUserName.ToString();
  83. _vmcDevCameraRepository.Create(content);
  84. var result = await _vmcDevCameraRepository.SaveAsync();
  85. if (!result)
  86. {
  87. throw new Exception("创建失败");
  88. }
  89. }
  90. public async Task CreateDevCameraList(VmcDevCamera model)
  91. {
  92. List<TVMC_DevCamera> list = new List<TVMC_DevCamera>();
  93. bool bol = await _vmcDevCameraRepository.DeleteBYDevStoreCode(model.C_DevStoreCode);
  94. if (model.CameraList != null && model.CameraList.Count > 0)
  95. {
  96. if (bol)
  97. {
  98. foreach (var item in model.CameraList)
  99. {
  100. TVMC_DevCamera content = new TVMC_DevCamera();
  101. content.C_DevStoreCode = model.C_DevStoreCode;
  102. content.C_CameraCode = item.C_CameraId;
  103. content.F_ShootingTime = item.F_ShootingTime;
  104. content.C_Status = (string.IsNullOrEmpty(item.C_Status) ? "1" : item.C_Status);
  105. content.C_ID = Guid.NewGuid().ToString();
  106. content.C_CreateBy = _claims.ApiUserId.ToString();
  107. content.D_CreateOn = DateTime.Now;
  108. content.C_Creator = _claims.ApiUserName.ToString();
  109. list.Add(content);
  110. }
  111. var result = await _vmcDevCameraRepository.CreateRangeAsync(list) > 0;
  112. if (!result)
  113. {
  114. throw new Exception("创建失败");
  115. }
  116. }
  117. else
  118. {
  119. throw new Exception("关联失败");
  120. }
  121. }
  122. else
  123. {
  124. if (!bol)
  125. {
  126. throw new Exception("删除失败");
  127. }
  128. }
  129. }
  130. public async Task CreateOneAsync(VmcCameraViewModel viewModel)
  131. {
  132. var content = _mapper.Map<TVMC_Camera>(viewModel);
  133. content.C_ID = Guid.NewGuid().ToString();
  134. var path = QRCoderHelper.RenderQrCode(content.C_ID, "M", _claims.Linsence);
  135. content.C_QRCode = path;
  136. content.C_CreateBy = _claims.ApiUserId.ToString();
  137. content.D_CreateOn = DateTime.Now;
  138. content.C_RunStatus = string.IsNullOrEmpty(content.C_RunStatus) ? "2" : content.C_RunStatus;
  139. content.C_Status =string.IsNullOrEmpty(content.C_Status)? "1": content.C_Status;
  140. _repository.Create(content);
  141. var result = await _repository.SaveAsync();
  142. if (!result)
  143. {
  144. throw new Exception("创建失败");
  145. }
  146. }
  147. public async Task DeleteAsync(string id)
  148. {
  149. var content = await _repository.GetByIdAsync(id);
  150. if (content == null)
  151. {
  152. throw new Exception("数据库中没有此数据");
  153. }
  154. _repository.Delete(content);
  155. var result = await _repository.SaveAsync();
  156. if (!result)
  157. {
  158. throw new Exception("删除失败");
  159. }
  160. }
  161. public async Task DeleteDevCameraAsync(string id)
  162. {
  163. var content = await _vmcDevCameraRepository.GetByIdAsync(id);
  164. if (content == null)
  165. {
  166. throw new Exception("数据库中没有此数据");
  167. }
  168. _vmcDevCameraRepository.Delete(content);
  169. var result = await _vmcDevCameraRepository.SaveAsync();
  170. if (!result)
  171. {
  172. throw new Exception("删除失败");
  173. }
  174. }
  175. public async Task ForbiddenAsync(string id)
  176. {
  177. var content = await _repository.GetByIdAsync(id);
  178. if (content == null)
  179. {
  180. throw new Exception("数据库中没有此数据");
  181. }
  182. content.C_LastUpdatedBy = _claims.ApiUserId.ToString();
  183. content.D_LastUpdatedOn = DateTime.Now;
  184. content.C_Status = "0";
  185. _repository.Update(content);
  186. var result = await _repository.SaveAsync();
  187. if (!result)
  188. {
  189. throw new Exception("禁用失败");
  190. }
  191. }
  192. public async Task<VmcCameraViewModel> GetByIdAsync(string id)
  193. {
  194. VmcCameraSearch searchModel = new VmcCameraSearch();
  195. searchModel.IsPagination = false;
  196. searchModel.C_ID = id;
  197. var list = await _repository.GetConditionAsync(searchModel);
  198. return list?.FirstOrDefault();
  199. }
  200. public async Task UpdateAsync(VmcCameraViewModel viewModel, string Id)
  201. {
  202. var content = await _repository.GetByIdAsync(Id);
  203. if (content == null)
  204. {
  205. throw new Exception("没有此数据");
  206. }
  207. _mapper.Map(viewModel, content, typeof(VmcCameraViewModel), typeof(TVMC_Camera));
  208. content.C_LastUpdatedBy = _claims.Linsence == null ? _claims.ApiUserId.ToString() : "6e864cbc-5252-11ec-8681-fa163e02b3e4";
  209. content.D_LastUpdatedOn = DateTime.Now;
  210. _repository.Update(content);
  211. var result = await _repository.SaveAsync();
  212. if (!result)
  213. {
  214. throw new Exception("更新失败");
  215. }
  216. }
  217. public Task<bool> IsExistAsync(string id)
  218. {
  219. throw new NotImplementedException();
  220. }
  221. public Task<int> UpdateOneAsync(VmcCameraViewModel viewModel, params string[] fields)
  222. {
  223. throw new NotImplementedException();
  224. }
  225. /// <summary>
  226. /// 根据C_Serial获取摄像头绑定的设备
  227. /// </summary>
  228. /// <returns></returns>
  229. public async Task<List<string>> GetCameraByTDH(string AIBoxID)
  230. {
  231. var cameras = await _repository.GetByConditionAsync(x => x.C_Serial == AIBoxID);
  232. var camerIds = cameras.Select(x => x.C_ID).ToList();
  233. var devCameras = await _vmcDevCameraRepository.GetByConditionAsync(x => camerIds.Contains(x.C_CameraCode));
  234. var result = devCameras.Select(x => x.C_DevStoreCode).ToList();
  235. //var result = await _vmcDevCameraRepository.GetDevStoreCodeByAIBoxId(AIBoxID);
  236. return result;
  237. }
  238. /// <summary>
  239. /// 根据C_Serial获取摄像头名称
  240. /// </summary>
  241. /// <param name="serial"></param>
  242. /// <returns></returns>
  243. public async Task<TVMC_Camera> GetCameraEntity(string serial)
  244. {
  245. var cameras = await _repository.GetByConditionAsync(x => x.C_Serial == serial);
  246. return cameras.FirstOrDefault();
  247. }
  248. }
  249. }