qlhb/Ropin.Inspection.Service/PRD/TprdProdSKUService.cs

using AutoMapper;
using LinqKit;
using Ropin.Inspection.Common.Accessor.Interface;
using Ropin.Inspection.Model;
using Ropin.Inspection.Model.Entities;
using Ropin.Inspection.Repository;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using System.Text;
using System.Threading.Tasks;

namespace Ropin.Inspection.Service
{
    public class TprdProdSKUService : ITprdProdSKUService
    {
        private readonly ITprdProdSKURepository _repository;
        private readonly IMapper _mapper;
        private readonly IClaimsAccessor _claims;
        public TprdProdSKUService(IClaimsAccessor claims, ITprdProdSKURepository repository, IMapper mapper)
        {
            _repository = repository;
            _mapper = mapper;
            _claims = claims;
        }
        public async Task CreateOneAsync(TprdProdSKUViewModel viewModel)
        {
            var content = _mapper.Map<TPRD_ProdSKU>(viewModel);
            content.C_SKUCode = Guid.NewGuid().ToString();
            content.C_CreateBy = _claims.ApiUserId;
            content.D_CreateOn = DateTime.Now;
            content.C_Status = "1";
            _repository.Create(content);
            var result = await _repository.SaveAsync();
            if (!result)
            {
                throw new Exception("创建失败");
            }
        }

        public async Task DeleteAsync(string id)
        {
            //var item = await _repository.GetByConditionAsync(i=>i.C_SKUCode == id);
            //var content = item.FirstOrDefault();
            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<IEnumerable<TprdProdSKUViewModel>> GetAllAsync()
        {
            var pagedList = await _repository.GetAllAsync();
            var contentDtoList = _mapper.Map<IEnumerable<TprdProdSKUViewModel>>(pagedList.Where(i => i.C_Status == "1").ToList());
            return contentDtoList.ToList();
        }
        public async Task<IEnumerable<TprdProdSKUViewModel>> GetConditionAsync(TprdProdSKUSearchModel searchModel)
        {
            var predicate = PredicateBuilder.New<TPRD_ProdSKU>(true);//查询条件,推荐后台使用这种方式灵活筛选
            #region 添加条件查询
            //predicate = predicate.And(i => i.C_Status.Equals("1"));
            
             if (null != searchModel.C_TypeCode && Guid.Empty.Equals(searchModel.C_TypeCode))
            {
                predicate = predicate.And(i => i.C_TypeCode.Equals(searchModel.C_TypeCode));
            }
            if (!string.IsNullOrEmpty(searchModel.C_Name))
            {
                predicate = predicate.And(i => i.C_Name.Contains(searchModel.C_Name));
            }
            if (!string.IsNullOrEmpty(searchModel.C_Spec))
            {
                predicate = predicate.And(i => i.C_Spec.Contains(searchModel.C_Spec));
            }
            if (!string.IsNullOrEmpty(searchModel.C_Brand))
            {
                predicate = predicate.And(i => i.C_Brand.Contains(searchModel.C_Brand));
            }
            if (!string.IsNullOrEmpty(searchModel.C_Vender))
            {
                predicate = predicate.And(i => i.C_Vender.Contains(searchModel.C_Vender));
            }
            if (!string.IsNullOrEmpty(searchModel.C_ProdArea))
            {
                predicate = predicate.And(i => i.C_ProdArea.Contains(searchModel.C_ProdArea));
            }
                    #endregion
            var list = await _repository.GetPageAsync(predicate, "C_Name,-D_CreateOn", searchModel.IsPagination, searchModel.PageIndex, searchModel.PageSize);
            searchModel.TotalCount = list.Totals;
            var dtoList = _mapper.Map<List<TPRD_ProdSKU>, List<TprdProdSKUViewModel>>(list.Rows);
            return dtoList;
        }

        public async Task<TprdProdSKUViewModel> GetByIdAsync(string id)
        {
            var item = await _repository.GetByConditionAsync(i => i.C_SKUCode == id);
            var content = item.FirstOrDefault();
            //var content = await _repository.GetByIdAsync(id);
            if (null == content)
                return null;
            var contentDto = _mapper.Map<TprdProdSKUViewModel>(content);
            return contentDto;
        }


        public async Task UpdateAsync(string id, TprdProdSKUUpdateModel updateModel)
        {
            var content = await _repository.GetByIdAsync(id);
            if (content == null)
            {
                throw new Exception("没有此数据");
            }
            content.C_LastUpdatedBy = _claims.ApiUserId;
            content.D_LastUpdatedOn = DateTime.Now;
            _mapper.Map(updateModel, content, typeof(TprdProdSKUUpdateModel), typeof(TPRD_ProdSKU));
            _repository.Update(content);
            var result = await _repository.SaveAsync();
            if (!result)
            {
                throw new Exception("更新失败");
            }
        }

        public Task<int> UpdateOneAsync(TprdProdSKUViewModel viewModel, params string[] fields)
        {
            throw new NotImplementedException();
        }

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

        public Task<IEnumerable<TprdProdSKUViewModel>> GetByConditionAsync(Expression<Func<TprdProdSKUViewModel, bool>> expression)
        {
            throw new NotImplementedException();
        }
    }
}