using CMS.Plugin.HIAWms.Application.Contracts.Dtos.WmsInOutStockRecord; using CMS.Plugin.HIAWms.Application.Contracts.Services; using CMS.Plugin.HIAWms.Domain.Shared; using CmsQueryExtensions; using CMS.Plugin.HIAWms.Domain.WmsInOutStockRecord; 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 WmsInOutStockRecordAppService : CMSPluginAppService, IWmsInOutStockRecordAppService { private readonly IWmsInOutStockRecordRepository wmsInOutStockRecordRepository; /// /// Initializes a new instance of the class. /// /// The task job repository. public WmsInOutStockRecordAppService(IWmsInOutStockRecordRepository _WmsInOutStockRecordRepository) { wmsInOutStockRecordRepository = _WmsInOutStockRecordRepository; } /// /// 获取指定出入库记录 /// /// /// public virtual async Task GetAsync(Guid id) { return ObjectMapper.Map(await wmsInOutStockRecordRepository.GetAsync(id)); } /// /// 分页获取出入库记录 /// /// /// public virtual async Task> GetListAsync(GetWmsInOutStockRecordInput input) { Check.NotNull(input, nameof(input)); if (input.Sorting.IsNullOrWhiteSpace()) { input.Sorting = nameof(WmsInOutStockRecord.Sort); } #region 动态构造查询条件 //动态构造查询条件 var whereConditions = DynamicGetQueryParams(input); #endregion var count = await wmsInOutStockRecordRepository.GetCountAsync(whereConditions); var list = await wmsInOutStockRecordRepository.GetListAsync(whereConditions, input.Sorting, input.MaxResultCount, input.SkipCount); return new PagedResultDto(count, ObjectMapper.Map, List>(list)); } /// /// 动态构造查询条件 /// /// 输入参数 /// private FunReturnResultModel>> DynamicGetQueryParams(GetWmsInOutStockRecordInput 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(WmsInOutStockRecordCreateDto input) { await CheckCreateOrUpdateDtoAsync(input); var exist = await wmsInOutStockRecordRepository.NameExistAsync(input.Id); if (exist) { throw new UserFriendlyException(L[CMSPluginDomainErrorCodes.NameAlreadyExists, input.Id]); } var maxSort = await wmsInOutStockRecordRepository.GetMaxSortAsync(); var sort = input.Sort ?? maxSort; var insertObj = ObjectMapper.Map(input); insertObj.Sort = sort; input.MapExtraPropertiesTo(insertObj, MappingPropertyDefinitionChecks.None); await wmsInOutStockRecordRepository.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, WmsInOutStockRecordUpdateDto input) { await CheckCreateOrUpdateDtoAsync(input); var updateObj = await wmsInOutStockRecordRepository.GetAsync(id); var exist = await wmsInOutStockRecordRepository.NameExistAsync(input.Id, updateObj.Id); if (exist) { throw new UserFriendlyException(L[CMSPluginDomainErrorCodes.NameAlreadyExists, input.Id]); } updateObj.SetConcurrencyStampIfNotNull(input.ConcurrencyStamp); input.MapExtraPropertiesTo(updateObj, MappingPropertyDefinitionChecks.None); updateObj.OrderNo = input.OrderNo; updateObj.MaterialName = input.MaterialName; updateObj.MaterialNo = input.MaterialNo; updateObj.StockType = input.StockType; updateObj.ContainerNo = input.ContainerNo; updateObj.MaterialModel = input.MaterialModel; updateObj.OperateTime = input.OperateTime; updateObj.Remark = input.Remark; updateObj.MaterialId = input.MaterialId; updateObj.TaskNo = input.TaskNo; updateObj.SourcePlace = input.SourcePlace; updateObj.ToPlace = input.ToPlace; updateObj.IsDisabled = input.IsDisabled; await wmsInOutStockRecordRepository.UpdateAsync(updateObj); return ObjectMapper.Map(updateObj); } /// /// 克隆出入库记录 /// /// /// public async Task> CloneAsync(IEnumerable ids) { //var wmsInOutStockRecords = new List(); //if (ids != null) //{ // var sort = await wmsInOutStockRecordRepository.GetMaxSortAsync(); // foreach (var id in ids) // { // var WmsInOutStockRecord = await wmsInOutStockRecordRepository.FindAsync(id); // if (WmsInOutStockRecord != null) // { // var name = WmsInOutStockRecord.Name + WmsInOutStockRecordConsts.CloneTag; // var notExist = false; // while (!notExist) // { // var exist = await wmsInOutStockRecordRepository.NameExistAsync(name); // if (exist || wmsInOutStockRecords.Any(x => x.Name == name)) // { // name += WmsInOutStockRecordConsts.CloneTag; // continue; // } // notExist = true; // } // //WmsInOutStockRecord = await wmsInOutStockRecordRepository.InsertAsync(WmsInOutStockRecord.Clone(GuidGenerator.Create(), name, sort++)); // wmsInOutStockRecords.Add(WmsInOutStockRecord); // } // } //} //return ObjectMapper.Map, List>(wmsInOutStockRecords); return new List(); } /// /// 删除单个出入库记录 /// /// /// public virtual Task DeleteAsync(Guid id) { return wmsInOutStockRecordRepository.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 wmsInOutStockRecordRepository.GetListAsync(null, nameof(WmsInOutStockRecord.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 wmsInOutStockRecordRepository.UpdateManyAsync(list); } /// /// 导入出入库记录 /// /// /// /// public async Task ImportAsync(WmsInOutStockRecordsImportModel input) { Check.NotNull(input, nameof(input)); var wmsInOutStockRecordCreateDtos = new List<(int RowIndex, WmsInOutStockRecordCreateDto Item)>(); var wmsInOutStockRecordUpdateDtos = new List<(int RowIndex, Guid Id, WmsInOutStockRecordUpdateDto Item)>(); var importItems = input.WmsInOutStockRecords; if (importItems != null && importItems.Any()) { #region 导入校验 // 判断名称是否重复,并输出第几行重复 var duplicateWmsInOutStockRecords = importItems.GroupBy(x => x.Id).Where(x => x.Count() > 1).ToList(); if (duplicateWmsInOutStockRecords?.Any() == true) { var duplicateWmsInOutStockRecordMsgs = duplicateWmsInOutStockRecords.Select(x => $"第 {string.Join(",", x.Select(x => x.RowIndex))} 行:{x.Key} 名称重复"); var errorMsg = $"导入失败!配置, {string.Join(",", duplicateWmsInOutStockRecordMsgs)},终止导入"; throw new UserFriendlyException(errorMsg); } #endregion foreach (var impItem in importItems) { if (impItem.Id.IsNullOrWhiteSpace()) { continue; } if (impItem.Id.IsNullOrWhiteSpace()) { var errorMsg = $"导入失败!配置,第{impItem.RowIndex}行:WmsInOutStockRecord名称不能为空"; throw new UserFriendlyException(errorMsg); } var oldWmsInOutStockRecord = await wmsInOutStockRecordRepository.FindByNameAsync(impItem.Id); if (oldWmsInOutStockRecord != null) { var wmsInOutStockRecordUpdateDto = new WmsInOutStockRecordUpdateDto { OrderNo = impItem.OrderNo, MaterialName = impItem.MaterialName, MaterialNo = impItem.MaterialNo, StockType = impItem.StockType, ContainerNo = impItem.ContainerNo, MaterialModel = impItem.MaterialModel, OperateTime = impItem.OperateTime, Remark = impItem.Remark, MaterialId = impItem.MaterialId, TaskNo = impItem.TaskNo, SourcePlace = impItem.SourcePlace, ToPlace = impItem.ToPlace, IsDisabled = impItem.IsDisabled, }; wmsInOutStockRecordUpdateDtos.Add((impItem.RowIndex, oldWmsInOutStockRecord.Id, wmsInOutStockRecordUpdateDto)); } else { var wmsInOutStockRecordCreateDto = new WmsInOutStockRecordCreateDto { OrderNo = impItem.OrderNo, MaterialName = impItem.MaterialName, MaterialNo = impItem.MaterialNo, StockType = impItem.StockType, ContainerNo = impItem.ContainerNo, MaterialModel = impItem.MaterialModel, OperateTime = impItem.OperateTime, Remark = impItem.Remark, MaterialId = impItem.MaterialId, TaskNo = impItem.TaskNo, SourcePlace = impItem.SourcePlace, ToPlace = impItem.ToPlace, IsDisabled = impItem.IsDisabled, }; wmsInOutStockRecordCreateDtos.Add((impItem.RowIndex, wmsInOutStockRecordCreateDto)); } } } // 新增 foreach (var wmsInOutStockRecordDto in wmsInOutStockRecordCreateDtos) { try { await CreateAsync(wmsInOutStockRecordDto.Item); } catch (Exception e) { var errorMsg = $"导入失败!配置,第{wmsInOutStockRecordDto.RowIndex}行:{e.Message},终止导入"; throw new UserFriendlyException(errorMsg); } } // 更新 foreach (var wmsInOutStockRecordDto in wmsInOutStockRecordUpdateDtos) { try { await UpdateAsync(wmsInOutStockRecordDto.Id, wmsInOutStockRecordDto.Item); } catch (Exception e) { var errorMsg = $"导入失败!配置,第{wmsInOutStockRecordDto.RowIndex}行:{e.Message},终止导入"; throw new UserFriendlyException(errorMsg); } } } /// /// 导出出入库记录 /// /// /// public async Task<(Dictionary Sheets, string FileName)> ExportAsync(GetWmsInOutStockRecordInput input) { Check.NotNull(input, nameof(input)); if (input.Sorting.IsNullOrWhiteSpace()) { input.Sorting = nameof(WmsInOutStockRecord.Sort); } #region 动态构造查询条件 //动态构造查询条件 var whereConditions = DynamicGetQueryParams(input); #endregion var list = await wmsInOutStockRecordRepository.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]?.Id : "WmsInOutStockRecord模版"; return (sheets, fileName); } /// /// 校验出入库记录,当新建或更新时 /// /// /// protected Task CheckCreateOrUpdateDtoAsync(WmsInOutStockRecordCreateOrUpdateDtoBase input) { Check.NotNull(input, nameof(input)); Check.NotNullOrWhiteSpace(input.OrderNo, "单据编号", 50); Check.NotNullOrWhiteSpace(input.MaterialNo, "物料件号", 50); Check.NotNull(input.StockType, "操作类型"); Check.NotNullOrWhiteSpace(input.MaterialId, "物料ID", 50); Check.NotNullOrWhiteSpace(input.TaskNo, "任务号", 50); return Task.CompletedTask; } }