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(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> GetAllAsync() { var pagedList = await _repository.GetAllAsync(); var contentDtoList = _mapper.Map>(pagedList.Where(i => i.C_Status == "1").ToList()); return contentDtoList.ToList(); } public async Task> GetConditionAsync(TprdProdSKUSearchModel searchModel) { var predicate = PredicateBuilder.New(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>(list.Rows); return dtoList; } public async Task 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(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 UpdateOneAsync(TprdProdSKUViewModel viewModel, params string[] fields) { throw new NotImplementedException(); } public Task IsExistAsync(string id) { throw new NotImplementedException(); } public Task> GetByConditionAsync(Expression> expression) { throw new NotImplementedException(); } } }