qlhb/Ropin.Inspection.Service/TdevBoxService.cs

using AutoMapper;
using LinqKit;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.NodeServices;
using Microsoft.EntityFrameworkCore;
using Newtonsoft.Json;
using Ropin.Core.Common;
using Ropin.Inspection.Common;
using Ropin.Inspection.Common.Accessor.Interface;
using Ropin.Inspection.Common.Helper;
using Ropin.Inspection.Model;
using Ropin.Inspection.Model.Entities;
using Ropin.Inspection.Repository;
using Ropin.Inspection.Repository.Interface;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Linq.Expressions;
using System.Reflection;
using System.Security.Cryptography;
using System.Text;
using System.Threading.Tasks;
using System.Xml.Linq;
using static System.Net.Mime.MediaTypeNames;

namespace Ropin.Inspection.Service
{
    public class TdevBoxService : ITdevBoxService
    {
        private readonly ITdevBoxRepository _repository;
        private readonly IMapper _mapper;
        private readonly IClaimsAccessor _claims;
        private readonly InspectionDbContext _sqlDBContext;
        private readonly ITmtnDevOpsRecordRepository _tmtnDevOpsRecordRepository;
        private readonly IUnitOfWork _unitOfWork;
        private readonly ITdevBoxDevSpotRepository _devBoxDevSpotRepository;
        public TdevBoxService(ITmtnDevOpsRecordRepository tmtnDevOpsRecordRepository,IClaimsAccessor claims, InspectionDbContext sqlDBContext, ITdevBoxRepository repository, IMapper mapper,IUnitOfWork unitOfWork, ITdevBoxDevSpotRepository devBoxDevSpotRepository)
        {
            _repository = repository;
            _mapper = mapper;
            _claims = claims;
            _sqlDBContext = sqlDBContext;
            _tmtnDevOpsRecordRepository = tmtnDevOpsRecordRepository;
            _unitOfWork = unitOfWork;
            _devBoxDevSpotRepository = devBoxDevSpotRepository;
        }

        public async Task CreateOneAsync(TdevBoxViewModel viewModel)
        {
            var datas = await _repository.GetByConditionAsync(t=>t.C_BoxNo==viewModel.C_BoxNo);
            if (datas.Count()>0&&datas.FirstOrDefault()!=null)
            {
                throw new Exception("网关编号已存在！");
            }
            var id = Guid.NewGuid().ToString();
            var path = QRCoderHelper.RenderQrCode(id, "M", _claims.Linsence);
            var content = _mapper.Map<TDEV_Box>(viewModel);
            content.C_ID = id;
            content.C_CreateBy = _claims.ApiUserId;
            content.D_CreateOn = DateTime.Now;
            content.C_Status = "1";
            content.C_QRCode = path;
            _repository.Create(content);
            var result = await _repository.SaveAsync();
            if (!result)
            {
                throw new Exception("创建失败");
            }
        }
        /// <summary>
        /// 业主盒子-拷贝
        /// </summary>
        /// <param name="oldId"></param>
        /// <returns></returns>
        /// <exception cref="Exception"></exception>
        public async Task CopyCreateAsync(string oldId)
        {
            TDEV_Box content = await _repository.GetByIdAsync(oldId);
            if (content == null)
            {
                throw new Exception("没有此数据");
            }
            bool result = false;
            _unitOfWork.BeginTransaction();
            try
            {
                string newId = Guid.NewGuid().ToString();
                var path = QRCoderHelper.RenderQrCode(newId, "M", _claims.Linsence);
                content.C_ID = newId;
                content.C_Name = content.C_Name + "-拷贝";
                content.C_CreateBy = _claims.ApiUserId;
                content.D_CreateOn = DateTime.Now;
                content.C_Status = "1";
                content.C_QRCode = path;
                content.C_LastUpdatedBy = null;
                content.D_LastUpdatedOn = null;
                result = await _unitOfWork.RegisterNew(content);
                if (result)
                {
                    var devBoxDevSpot = await _devBoxDevSpotRepository.GetByConditionAsync(t => t.C_BoxCode == oldId);
                    List<TDEV_BoxDevSpot> boxDevList = new List<TDEV_BoxDevSpot>();
                    foreach (var item in devBoxDevSpot)
                    {
                        if (item != null)
                        {
                            TDEV_BoxDevSpot tDEV_Web = new TDEV_BoxDevSpot();
                            tDEV_Web = item;
                            tDEV_Web.C_ID = Guid.NewGuid().ToString();
                            tDEV_Web.C_BoxCode = content.C_ID;
                            tDEV_Web.C_LastUpdatedBy = null;
                            tDEV_Web.D_LastUpdatedOn = null;
                            tDEV_Web.C_CreateBy = _claims.ApiUserId;
                            tDEV_Web.D_CreateOn = DateTime.Now;
                            boxDevList.Add(tDEV_Web);
                        }
                    }
                    if (boxDevList != null && boxDevList.Count > 0)
                    {
                        result = await _unitOfWork.RegisterRangeNew(boxDevList.ToList());
                    }
                }
            }
            catch
            {
                result = false;
                throw;
            }
            finally
            {
                if (result)
                    await _unitOfWork.CommitAsync();
                else
                    _unitOfWork.Rollback();
            }
        }
        public async Task DeleteAsync(string id)
        {
            var content = await _repository.GetByIdAsync(id);
            if (content == null)
            {
                throw new Exception("数据库中没有此数据");
            }
            content.C_LastUpdatedBy = _claims.ApiUserId;
            content.D_LastUpdatedOn = DateTime.Now;
            content.C_Status = "0";
            _repository.Update(content);
            var result = await _repository.SaveAsync();
            if (!result)
            {
                throw new Exception("删除失败");
            }
        }

        public async Task UpdateAsync(string code, TdevBoxUpdateModel updateModel)
        {
            var items = await _repository.GetByConditionAsync(C => C.C_ID == code);
            var content = items.FirstOrDefault();
            if (content == null)
            {
                throw new Exception("没有此数据");
            }
            var datas = await _repository.GetByConditionAsync(t => t.C_BoxNo == updateModel.C_BoxNo&&t.C_ID!= code);
            if (datas.Count() > 0 && datas.FirstOrDefault() != null)
            {
                throw new Exception("网关编号已存在！");
            }
            content.C_LastUpdatedBy = _claims.Linsence == null ? _claims.ApiUserId : Guid.Parse("6e864cbc-5252-11ec-8681-fa163e02b3e4");
            content.D_LastUpdatedOn = DateTime.Now;
            _mapper.Map(updateModel, content, typeof(TdevBoxUpdateModel), typeof(TDEV_Box));
            _repository.Update(content);
            var result = await _repository.SaveAsync();
            if (!result)
            {
                throw new Exception("更新失败");
            }
        }

        public async Task<IEnumerable<TdevBoxViewModel>> GetConditionAsync(TdevBoxSearchModel searchModel)
        {
            return await _repository.GetConditionAsync(searchModel);
            //var predicate = PredicateBuilder.New<TDEV_Box>(true);//查询条件,推荐后台使用这种方式灵活筛选
            //#region 添加条件查询
            //if (!string.IsNullOrEmpty(searchModel.C_Status))
            //{
            //    predicate = predicate.And(i => i.C_Status.Equals(searchModel.C_Status));
            //}
            //else
            //{
            //    predicate = predicate.And(i => !i.C_Status.Equals("0"));
            //}
            //if (!string.IsNullOrEmpty(searchModel.C_ID))
            //{
            //    predicate = predicate.And(i => i.C_ID.Equals(searchModel.C_ID));
            //}
            //if (!string.IsNullOrEmpty(searchModel.C_Name))
            //{
            //    predicate = predicate.And(i => i.C_Name.Contains(searchModel.C_Name));
            //}
            //if (!string.IsNullOrEmpty(searchModel.C_StoreCode))
            //{
            //    predicate = predicate.And(i => i.C_StoreCode == searchModel.C_StoreCode);
            //}
            //#endregion
            //var list = await _repository.GetPageAsync(predicate, "I_Sort", searchModel.IsPagination, searchModel.PageIndex, searchModel.PageSize);//C_Name,-D_CreateOn
            //searchModel.TotalCount = list.Totals;
            //var dtoList = _mapper.Map<List<TDEV_Box>, List<TdevBoxViewModel>>(list.Rows);
            //return dtoList;
        }
        
        public async Task<TdevBoxViewModel> GetConditionByIdAsync(string code)
        {
            var items = await _repository.GetByConditionAsync(C => C.C_ID == code);
            var content = items.FirstOrDefault();
            if (content != null)
            {
                var entity = _mapper.Map<TDEV_Box, TdevBoxViewModel>(content);
                return entity;
            }
            else
            {
                return null;
            }
        }
        public Task<int> UpdateOneAsync(TdevBoxViewModel viewModel, params string[] fields)
        {
            throw new NotImplementedException();
        }

        public Task<TdevBoxViewModel> GetByIdAsync(string id)
        {
            throw new NotImplementedException();
        }

        public Task<bool> IsExistAsync(string id)
        {
            throw new NotImplementedException();
        }
    }
}