using CMS.Plugin.HIAWms.Application.Contracts.Dtos.WmsInOutStockOrderDetail; using CMS.Plugin.HIAWms.Application.Contracts.Services; using CMS.Plugin.HIAWms.Domain.Shared; using CmsQueryExtensions; using CMS.Plugin.HIAWms.Domain.WmsInOutStockOrderDetail; using CmsQueryExtensions.Extension; using System.Linq.Expressions; using Volo.Abp; using Volo.Abp.Application.Dtos; using Volo.Abp.Data; using Volo.Abp.ObjectExtending; using Volo.Abp.ObjectMapping; namespace CMS.Plugin.HIAWms.Application.Implements; /// /// 出入库单据详情应用服务 /// public class WmsInOutStockOrderDetailAppService : CMSPluginAppService, IWmsInOutStockOrderDetailAppService { private readonly IWmsInOutStockOrderDetailRepository wmsInOutStockOrderDetailRepository; /// /// Initializes a new instance of the class. /// /// The task job repository. public WmsInOutStockOrderDetailAppService(IWmsInOutStockOrderDetailRepository _WmsInOutStockOrderDetailRepository) { wmsInOutStockOrderDetailRepository = _WmsInOutStockOrderDetailRepository; } /// /// 获取指定出入库单据详情 /// /// /// public virtual async Task GetAsync(Guid id) { return ObjectMapper.Map(await wmsInOutStockOrderDetailRepository.GetAsync(id)); } /// /// 分页获取出入库单据详情 /// /// /// public virtual async Task> GetListAsync(GetWmsInOutStockOrderDetailInput input) { Check.NotNull(input, nameof(input)); if (input.Sorting.IsNullOrWhiteSpace()) { input.Sorting = nameof(WmsInOutStockOrderDetail.Sort); } #region 动态构造查询条件 //动态构造查询条件 var whereConditions = DynamicGetQueryParams(input); #endregion var count = await wmsInOutStockOrderDetailRepository.GetCountAsync(whereConditions); var list = await wmsInOutStockOrderDetailRepository.GetListAsync(whereConditions, input.Sorting, input.MaxResultCount, input.SkipCount); return new PagedResultDto(count, ObjectMapper.Map, List>(list)); } /// /// 动态构造查询条件 /// /// 输入参数 /// private FunReturnResultModel>> DynamicGetQueryParams(GetWmsInOutStockOrderDetailInput input) { //动态构造查询条件 var whereConditions = WhereConditionsExtensions.GetWhereConditions(input); if (!whereConditions.IsSuccess) { throw new Exception("动态构造查询条件失败:" + whereConditions.ErrMsg); } //也可再次自定义构建查询条件 Expression> extendExpression = a => a.IsDeleted == false; // 使用 System.Linq.PredicateBuilder 的 And var pres = (System.Linq.Expressions.Expression>)(whereConditions.data); whereConditions.data = System.Linq.PredicateBuilder.And(pres, extendExpression); return whereConditions; } /// /// 新建出入库单据详情 /// /// /// /// public virtual async Task CreateAsync(WmsInOutStockOrderDetailCreateDto input) { await CheckCreateOrUpdateDtoAsync(input); var exist = await wmsInOutStockOrderDetailRepository.NameExistAsync(input.MaterialId); if (exist) { throw new UserFriendlyException(L[CMSPluginDomainErrorCodes.NameAlreadyExists, input.MaterialId]); } var maxSort = await wmsInOutStockOrderDetailRepository.GetMaxSortAsync(); var sort = input.Sort ?? maxSort; var insertObj = ObjectMapper.Map(input); insertObj.Sort = sort; input.MapExtraPropertiesTo(insertObj, MappingPropertyDefinitionChecks.None); await wmsInOutStockOrderDetailRepository.InsertAsync(insertObj); //if (input.Sort.HasValue && insertObj.Sort != maxSort) //{ // await AdjustSortAsync(insertObj.Id, insertObj.Sort); //} return ObjectMapper.Map(insertObj); } /// /// 更新出入库单据详情 /// /// /// /// /// public virtual async Task UpdateAsync(Guid id, WmsInOutStockOrderDetailUpdateDto input) { await CheckCreateOrUpdateDtoAsync(input); var updateObj = await wmsInOutStockOrderDetailRepository.GetAsync(id); var exist = await wmsInOutStockOrderDetailRepository.NameExistAsync(input.MaterialId, updateObj.Id); if (exist) { throw new UserFriendlyException(L[CMSPluginDomainErrorCodes.NameAlreadyExists, input.MaterialId]); } updateObj.SetConcurrencyStampIfNotNull(input.ConcurrencyStamp); input.MapExtraPropertiesTo(updateObj, MappingPropertyDefinitionChecks.None); updateObj.OrderNo = input.OrderNo; updateObj.MaterialId = input.MaterialId; updateObj.OrderType = input.OrderType; updateObj.MaterialNo = input.MaterialNo; updateObj.MaterialName = input.MaterialName; updateObj.ContainerNo = input.ContainerNo; updateObj.MaterialModel = input.MaterialModel; updateObj.MaterialBatch = input.MaterialBatch; updateObj.IsDisabled = input.IsDisabled; updateObj.Remark = input.Remark; await wmsInOutStockOrderDetailRepository.UpdateAsync(updateObj); return ObjectMapper.Map(updateObj); } /// /// 克隆出入库单据详情 /// /// /// public async Task> CloneAsync(IEnumerable ids) { //var wmsInOutStockOrderDetails = new List(); //if (ids != null) //{ // var sort = await wmsInOutStockOrderDetailRepository.GetMaxSortAsync(); // foreach (var id in ids) // { // var WmsInOutStockOrderDetail = await wmsInOutStockOrderDetailRepository.FindAsync(id); // if (WmsInOutStockOrderDetail != null) // { // var name = WmsInOutStockOrderDetail.Name + WmsInOutStockOrderDetailConsts.CloneTag; // var notExist = false; // while (!notExist) // { // var exist = await wmsInOutStockOrderDetailRepository.NameExistAsync(name); // if (exist || wmsInOutStockOrderDetails.Any(x => x.Name == name)) // { // name += WmsInOutStockOrderDetailConsts.CloneTag; // continue; // } // notExist = true; // } // //WmsInOutStockOrderDetail = await wmsInOutStockOrderDetailRepository.InsertAsync(WmsInOutStockOrderDetail.Clone(GuidGenerator.Create(), name, sort++)); // wmsInOutStockOrderDetails.Add(WmsInOutStockOrderDetail); // } // } //} //return ObjectMapper.Map, List>(wmsInOutStockOrderDetails); return new List(); } /// /// 删除单个出入库单据详情 /// /// /// public virtual Task DeleteAsync(Guid id) { return wmsInOutStockOrderDetailRepository.DeleteAsync(id); } /// /// 删除多个出入库单据详情 /// /// /// public async Task DeleteManyAsync(IEnumerable ids) { foreach (var id in ids) { await DeleteAsync(id); } } /// /// 调整排序出入库单据详情 /// /// /// /// public virtual async Task AdjustSortAsync(Guid id, int sort) { var list = await wmsInOutStockOrderDetailRepository.GetListAsync(null, nameof(WmsInOutStockOrderDetail.Sort)); if (list != null && list.Any()) { var initSort = 1; list.ForEach(x => x.AdjustSort(initSort++)); var entity = list.FirstOrDefault(x => x.Id == id); if (entity != null) { if (sort == 1) { list.Where(x => x.Id != id).ToList()?.ForEach(x => x.AdjustSort(x.Sort + 1)); } else if (entity.Sort > sort) { list.Where(x => x.Id != id && x.Sort >= sort).ToList()?.ForEach(x => x.AdjustSort(x.Sort + 1)); list.Where(x => x.Id != id && x.Sort < sort).ToList()?.ForEach(x => x.AdjustSort(x.Sort - 1)); } else if (entity.Sort < sort) { list.Where(x => x.Id != id && x.Sort > sort).ToList()?.ForEach(x => x.AdjustSort(x.Sort + 1)); list.Where(x => x.Id != id && x.Sort <= sort).ToList()?.ForEach(x => x.AdjustSort(x.Sort - 1)); } entity.AdjustSort(sort); } } await wmsInOutStockOrderDetailRepository.UpdateManyAsync(list); } /// /// 导入出入库单据详情 /// /// /// /// public async Task ImportAsync(WmsInOutStockOrderDetailsImportModel input) { Check.NotNull(input, nameof(input)); var wmsInOutStockOrderDetailCreateDtos = new List<(int RowIndex, WmsInOutStockOrderDetailCreateDto Item)>(); var wmsInOutStockOrderDetailUpdateDtos = new List<(int RowIndex, Guid Id, WmsInOutStockOrderDetailUpdateDto Item)>(); var importItems = input.WmsInOutStockOrderDetails; if (importItems != null && importItems.Any()) { #region 导入校验 // 判断名称是否重复,并输出第几行重复 var duplicateWmsInOutStockOrderDetails = importItems.GroupBy(x => x.MaterialId).Where(x => x.Count() > 1).ToList(); if (duplicateWmsInOutStockOrderDetails?.Any() == true) { var duplicateWmsInOutStockOrderDetailMsgs = duplicateWmsInOutStockOrderDetails.Select(x => $"第 {string.Join(",", x.Select(x => x.RowIndex))} 行:{x.Key} 名称重复"); var errorMsg = $"导入失败!配置, {string.Join(",", duplicateWmsInOutStockOrderDetailMsgs)},终止导入"; throw new UserFriendlyException(errorMsg); } #endregion foreach (var impItem in importItems) { if (impItem.MaterialId.IsNullOrWhiteSpace()) { continue; } if (impItem.MaterialId.IsNullOrWhiteSpace()) { var errorMsg = $"导入失败!配置,第{impItem.RowIndex}行:WmsInOutStockOrderDetail名称不能为空"; throw new UserFriendlyException(errorMsg); } var oldWmsInOutStockOrderDetail = await wmsInOutStockOrderDetailRepository.FindByNameAsync(impItem.MaterialId); if (oldWmsInOutStockOrderDetail != null) { var wmsInOutStockOrderDetailUpdateDto = new WmsInOutStockOrderDetailUpdateDto { OrderNo = impItem.OrderNo, MaterialId = impItem.MaterialId, OrderType = impItem.OrderType, MaterialNo = impItem.MaterialNo, MaterialName = impItem.MaterialName, ContainerNo = impItem.ContainerNo, MaterialModel = impItem.MaterialModel, MaterialBatch = impItem.MaterialBatch, IsDisabled = impItem.IsDisabled, Remark = impItem.Remark, }; wmsInOutStockOrderDetailUpdateDtos.Add((impItem.RowIndex, oldWmsInOutStockOrderDetail.Id, wmsInOutStockOrderDetailUpdateDto)); } else { var wmsInOutStockOrderDetailCreateDto = new WmsInOutStockOrderDetailCreateDto { OrderNo = impItem.OrderNo, MaterialId = impItem.MaterialId, OrderType = impItem.OrderType, MaterialNo = impItem.MaterialNo, MaterialName = impItem.MaterialName, ContainerNo = impItem.ContainerNo, MaterialModel = impItem.MaterialModel, MaterialBatch = impItem.MaterialBatch, IsDisabled = impItem.IsDisabled, Remark = impItem.Remark, }; wmsInOutStockOrderDetailCreateDtos.Add((impItem.RowIndex, wmsInOutStockOrderDetailCreateDto)); } } } // 新增 foreach (var wmsInOutStockOrderDetailDto in wmsInOutStockOrderDetailCreateDtos) { try { await CreateAsync(wmsInOutStockOrderDetailDto.Item); } catch (Exception e) { var errorMsg = $"导入失败!配置,第{wmsInOutStockOrderDetailDto.RowIndex}行:{e.Message},终止导入"; throw new UserFriendlyException(errorMsg); } } // 更新 foreach (var wmsInOutStockOrderDetailDto in wmsInOutStockOrderDetailUpdateDtos) { try { await UpdateAsync(wmsInOutStockOrderDetailDto.Id, wmsInOutStockOrderDetailDto.Item); } catch (Exception e) { var errorMsg = $"导入失败!配置,第{wmsInOutStockOrderDetailDto.RowIndex}行:{e.Message},终止导入"; throw new UserFriendlyException(errorMsg); } } } /// /// 导出出入库单据详情 /// /// /// public async Task<(Dictionary Sheets, string FileName)> ExportAsync(GetWmsInOutStockOrderDetailInput input) { Check.NotNull(input, nameof(input)); if (input.Sorting.IsNullOrWhiteSpace()) { input.Sorting = nameof(WmsInOutStockOrderDetail.Sort); } #region 动态构造查询条件 //动态构造查询条件 var whereConditions = DynamicGetQueryParams(input); #endregion var list = await wmsInOutStockOrderDetailRepository.GetListAsync(whereConditions, input.Sorting, input.MaxResultCount, input.SkipCount, includeDetails: true); var result = ObjectMapper.Map, List>(list); var sheets = new Dictionary { ["配置"] = ExportHelper.ConvertListToExportData(result), }; var fileName = result.Count > 1 ? "出入库单据详情列表" : result.Count == 1 ? result[0]?.MaterialId : "WmsInOutStockOrderDetail模版"; return (sheets, fileName); } /// /// 校验出入库单据详情,当新建或更新时 /// /// /// protected Task CheckCreateOrUpdateDtoAsync(WmsInOutStockOrderDetailCreateOrUpdateDtoBase input) { Check.NotNull(input, nameof(input)); Check.NotNullOrWhiteSpace(input.OrderNo, "单据编号", 50); Check.NotNullOrWhiteSpace(input.MaterialId, "物料唯一码", 64); Check.NotNull(input.OrderType, "单据类型(枚举值)"); Check.NotNullOrWhiteSpace(input.MaterialNo, "物料件号", 50); return Task.CompletedTask; } }