using CMS.Plugin.HIAWms.Application.Contracts.Dtos.WmsMaterial;
|
using CMS.Plugin.HIAWms.Application.Contracts.Services;
|
using CMS.Plugin.HIAWms.Domain.Shared;
|
using CMS.Plugin.HIAWms.Domain.Shared.WmsMaterials;
|
using CMS.Plugin.HIAWms.Domain.WmsMaterials;
|
using CmsQueryExtensions;
|
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;
|
|
/// <inheritdoc />
|
public class WmsMaterialAppService : CMSPluginAppService, IWmsMaterialAppService
|
{
|
private readonly IWmsMaterialRepository _wmsmaterialRepository;
|
|
/// <summary>
|
/// Initializes a new instance of the <see cref="WmsMaterialAppService"/> class.
|
/// </summary>
|
/// <param name="wmsmaterialRepository">The task job repository.</param>
|
public WmsMaterialAppService(IWmsMaterialRepository wmsmaterialRepository)
|
{
|
_wmsmaterialRepository = wmsmaterialRepository;
|
}
|
|
/// <inheritdoc />
|
public virtual async Task<WmsMaterialDto> GetAsync(Guid id)
|
{
|
return ObjectMapper.Map<WmsMaterial, WmsMaterialDto>(await _wmsmaterialRepository.GetAsync(id));
|
}
|
|
/// <inheritdoc />
|
public virtual async Task<PagedResultDto<WmsMaterialDto>> GetListAsync(GetWmsMaterialInput input)
|
{
|
Check.NotNull(input, nameof(input));
|
|
if (input.Sorting.IsNullOrWhiteSpace())
|
{
|
input.Sorting = nameof(WmsMaterial.Sort);
|
}
|
|
#region 动态构造查询条件
|
|
//动态构造查询条件
|
var whereConditions = DynamicGetQueryParams(input);
|
|
#endregion
|
|
var count = await _wmsmaterialRepository.GetCountAsync(whereConditions);
|
var list = await _wmsmaterialRepository.GetListAsync(whereConditions, input.Sorting, input.MaxResultCount, input.SkipCount);
|
|
return new PagedResultDto<WmsMaterialDto>(count, ObjectMapper.Map<List<WmsMaterial>, List<WmsMaterialDto>>(list));
|
}
|
|
/// <summary>
|
/// 动态构造查询条件
|
/// </summary>
|
/// <param name="input">输入参数</param>
|
/// <returns></returns>
|
private FunReturnResultModel<Expression<Func<WmsMaterial, bool>>> DynamicGetQueryParams(GetWmsMaterialInput input)
|
{
|
//动态构造查询条件
|
var whereConditions = WhereConditionsExtensions.GetWhereConditions<WmsMaterial, GetWmsMaterialInput>(input);
|
if (!whereConditions.IsSuccess)
|
{
|
throw new Exception("动态构造查询条件失败:" + whereConditions.ErrMsg);
|
}
|
|
//也可再次自定义构建查询条件
|
Expression<Func<WmsMaterial, bool>> extendExpression = a => a.IsDeleted == false;
|
// 使用 System.Linq.PredicateBuilder 的 And
|
var pres = (System.Linq.Expressions.Expression<Func<WmsMaterial, bool>>)(whereConditions.data);
|
whereConditions.data = System.Linq.PredicateBuilder.And(pres, extendExpression);
|
|
return whereConditions;
|
}
|
|
/// <inheritdoc />
|
public virtual async Task<WmsMaterialDto> CreateAsync(WmsMaterialCreateDto input)
|
{
|
await CheckCreateOrUpdateDtoAsync(input);
|
|
var exist = await _wmsmaterialRepository.NameExistAsync(input.MaterialNo);
|
if (exist)
|
{
|
throw new UserFriendlyException(L[CMSPluginDomainErrorCodes.NameAlreadyExists, input.MaterialNo]);
|
}
|
|
var maxSort = await _wmsmaterialRepository.GetMaxSortAsync();
|
var sort = input.Sort ?? maxSort;
|
|
var wmsmaterial = ObjectMapper.Map<WmsMaterialCreateDto, WmsMaterial>(input);
|
wmsmaterial.Sort = sort;
|
input.MapExtraPropertiesTo(wmsmaterial, MappingPropertyDefinitionChecks.None);
|
|
await _wmsmaterialRepository.InsertAsync(wmsmaterial);
|
|
if (input.Sort.HasValue && wmsmaterial.Sort != maxSort)
|
{
|
await AdjustSortAsync(wmsmaterial.Id, wmsmaterial.Sort);
|
}
|
|
return ObjectMapper.Map<WmsMaterial, WmsMaterialDto>(wmsmaterial);
|
}
|
|
/// <inheritdoc />
|
public virtual async Task<WmsMaterialDto> UpdateAsync(Guid id, WmsMaterialUpdateDto input)
|
{
|
await CheckCreateOrUpdateDtoAsync(input);
|
|
var wmsmaterial = await _wmsmaterialRepository.GetAsync(id);
|
var exist = await _wmsmaterialRepository.NameExistAsync(input.MaterialNo, wmsmaterial.Id);
|
if (exist)
|
{
|
throw new UserFriendlyException(L[CMSPluginDomainErrorCodes.NameAlreadyExists, input.MaterialNo]);
|
}
|
|
wmsmaterial.SetConcurrencyStampIfNotNull(input.ConcurrencyStamp);
|
input.MapExtraPropertiesTo(wmsmaterial, MappingPropertyDefinitionChecks.None);
|
|
wmsmaterial.MaterialName = input.MaterialName;
|
wmsmaterial.PurchaseType = input.PurchaseType;
|
wmsmaterial.MaterialTypeCode = input.MaterialTypeCode;
|
wmsmaterial.PrimaryUnit = input.PrimaryUnit;
|
wmsmaterial.Standard = input.Standard;
|
wmsmaterial.OuterDiameter = input.OuterDiameter;
|
wmsmaterial.WallThickness = input.WallThickness;
|
wmsmaterial.MaterialQuality = input.MaterialQuality;
|
wmsmaterial.Length = input.Length;
|
wmsmaterial.IsMainBranch = input.IsMainBranch;
|
wmsmaterial.Factory = input.Factory;
|
wmsmaterial.MaterialModel = input.MaterialModel;
|
wmsmaterial.Certification = input.Certification;
|
wmsmaterial.MaterialTypeDesc = input.MaterialTypeDesc;
|
await _wmsmaterialRepository.UpdateAsync(wmsmaterial);
|
|
return ObjectMapper.Map<WmsMaterial, WmsMaterialDto>(wmsmaterial);
|
}
|
|
/// <inheritdoc />
|
public async Task<List<WmsMaterialDto>> CloneAsync(IEnumerable<Guid> ids)
|
{
|
//var wmsmaterials = new List<WmsMaterial>();
|
//if (ids != null)
|
//{
|
// var sort = await _wmsmaterialRepository.GetMaxSortAsync();
|
// foreach (var id in ids)
|
// {
|
// var wmsmaterial = await _wmsmaterialRepository.FindAsync(id);
|
// if (wmsmaterial != null)
|
// {
|
// var name = wmsmaterial.Name + WmsMaterialConsts.CloneTag;
|
// var notExist = false;
|
// while (!notExist)
|
// {
|
// var exist = await _wmsmaterialRepository.NameExistAsync(name);
|
// if (exist || wmsmaterials.Any(x => x.Name == name))
|
// {
|
// name += WmsMaterialConsts.CloneTag;
|
// continue;
|
// }
|
|
// notExist = true;
|
// }
|
|
// //wmsmaterial = await _wmsmaterialRepository.InsertAsync(wmsmaterial.Clone(GuidGenerator.Create(), name, sort++));
|
// wmsmaterials.Add(wmsmaterial);
|
// }
|
// }
|
//}
|
|
//return ObjectMapper.Map<List<WmsMaterial>, List<WmsMaterialDto>>(wmsmaterials);
|
return new List<WmsMaterialDto>();
|
}
|
|
/// <inheritdoc />
|
public virtual Task DeleteAsync(Guid id)
|
{
|
return _wmsmaterialRepository.DeleteAsync(id);
|
}
|
|
/// <inheritdoc />
|
public async Task DeleteManyAsync(IEnumerable<Guid> ids)
|
{
|
foreach (var id in ids)
|
{
|
await DeleteAsync(id);
|
}
|
}
|
|
/// <inheritdoc />
|
public virtual async Task AdjustSortAsync(Guid id, int sort)
|
{
|
var list = await _wmsmaterialRepository.GetListAsync(null, nameof(WmsMaterial.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 _wmsmaterialRepository.UpdateManyAsync(list);
|
}
|
|
/// <inheritdoc />
|
public async Task ImportAsync(WmsMaterialImportModels input)
|
{
|
Check.NotNull(input, nameof(input));
|
|
var wmsmaterialCreateDtos = new List<(int RowIndex, WmsMaterialCreateDto Item)>();
|
var wmsmaterialUpdateDtos = new List<(int RowIndex, Guid Id, WmsMaterialUpdateDto Item)>();
|
var wmsmaterials = input.WmsMaterials;
|
|
if (wmsmaterials != null && wmsmaterials.Any())
|
{
|
#region 导入校验
|
|
// 判断名称是否重复，并输出第几行重复
|
var duplicateWmsMaterials = wmsmaterials.GroupBy(x => x.MaterialNo).Where(x => x.Count() > 1).ToList();
|
if (duplicateWmsMaterials?.Any() == true)
|
{
|
var duplicateWmsMaterialMsgs = duplicateWmsMaterials.Select(x => $"第 {string.Join(",", x.Select(x => x.RowIndex))} 行：{x.Key} 名称重复");
|
var errorMsg = $"导入失败！配置， {string.Join(",", duplicateWmsMaterialMsgs)}，终止导入";
|
throw new UserFriendlyException(errorMsg);
|
}
|
|
#endregion
|
|
foreach (var wmsmaterial in wmsmaterials)
|
{
|
if (wmsmaterial.MaterialNo.IsNullOrWhiteSpace() && wmsmaterial.MaterialName.IsNullOrWhiteSpace())
|
{
|
continue;
|
}
|
|
if (wmsmaterial.MaterialNo.IsNullOrWhiteSpace())
|
{
|
var errorMsg = $"导入失败！配置，第{wmsmaterial.RowIndex}行：WmsMaterial名称不能为空";
|
throw new UserFriendlyException(errorMsg);
|
}
|
|
var oldWmsMaterial = await _wmsmaterialRepository.FindByNameAsync(wmsmaterial.MaterialNo);
|
if (oldWmsMaterial != null)
|
{
|
var wmsmaterialUpdateDto = new WmsMaterialUpdateDto
|
{
|
MaterialNo = wmsmaterial.MaterialNo,
|
MaterialName = wmsmaterial.MaterialName,
|
PurchaseType = wmsmaterial.PurchaseType,
|
MaterialTypeCode = wmsmaterial.MaterialTypeCode,
|
MaterialTypeDesc = wmsmaterial.MaterialTypeDesc,
|
PrimaryUnit = wmsmaterial.PrimaryUnit,
|
Standard = wmsmaterial.Standard,
|
OuterDiameter = wmsmaterial.OuterDiameter,
|
WallThickness = wmsmaterial.WallThickness,
|
MaterialQuality = wmsmaterial.MaterialQuality,
|
Length = wmsmaterial.Length,
|
IsMainBranch = wmsmaterial.IsMainBranch,
|
Factory = wmsmaterial.Factory,
|
Certification = wmsmaterial.Certification,
|
Remark = wmsmaterial.Remark,
|
};
|
|
wmsmaterialUpdateDtos.Add((wmsmaterial.RowIndex, oldWmsMaterial.Id, wmsmaterialUpdateDto));
|
}
|
else
|
{
|
var wmsmaterialCreateDto = new WmsMaterialCreateDto
|
{
|
MaterialNo = wmsmaterial.MaterialNo,
|
MaterialName = wmsmaterial.MaterialName,
|
PurchaseType = wmsmaterial.PurchaseType,
|
MaterialTypeCode = wmsmaterial.MaterialTypeCode,
|
MaterialTypeDesc = wmsmaterial.MaterialTypeDesc,
|
PrimaryUnit = wmsmaterial.PrimaryUnit,
|
Standard = wmsmaterial.Standard,
|
OuterDiameter = wmsmaterial.OuterDiameter,
|
WallThickness = wmsmaterial.WallThickness,
|
MaterialQuality = wmsmaterial.MaterialQuality,
|
Length = wmsmaterial.Length,
|
IsMainBranch = wmsmaterial.IsMainBranch,
|
Factory = wmsmaterial.Factory,
|
Certification = wmsmaterial.Certification,
|
Remark = wmsmaterial.Remark,
|
};
|
|
wmsmaterialCreateDtos.Add((wmsmaterial.RowIndex, wmsmaterialCreateDto));
|
}
|
}
|
}
|
|
// 新增
|
foreach (var wmsmaterialDto in wmsmaterialCreateDtos)
|
{
|
try
|
{
|
await CreateAsync(wmsmaterialDto.Item);
|
}
|
catch (Exception e)
|
{
|
var errorMsg = $"导入失败！配置，第{wmsmaterialDto.RowIndex}行：{e.Message}，终止导入";
|
throw new UserFriendlyException(errorMsg);
|
}
|
}
|
|
// 更新
|
foreach (var wmsmaterialDto in wmsmaterialUpdateDtos)
|
{
|
try
|
{
|
await UpdateAsync(wmsmaterialDto.Id, wmsmaterialDto.Item);
|
}
|
catch (Exception e)
|
{
|
var errorMsg = $"导入失败！配置，第{wmsmaterialDto.RowIndex}行：{e.Message}，终止导入";
|
throw new UserFriendlyException(errorMsg);
|
}
|
}
|
}
|
|
/// <summary>
|
/// 导出物料基础信息
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
public async Task<(Dictionary<string, object> Sheets, string FileName)> ExportAsync(GetWmsMaterialInput input)
|
{
|
Check.NotNull(input, nameof(input));
|
|
if (input.Sorting.IsNullOrWhiteSpace())
|
{
|
input.Sorting = nameof(WmsMaterial.Sort);
|
}
|
|
#region 动态构造查询条件
|
|
//动态构造查询条件
|
var whereConditions = DynamicGetQueryParams(input);
|
|
#endregion
|
|
|
|
var list = await _wmsmaterialRepository.GetListAsync(whereConditions, input.Sorting, input.MaxResultCount, input.SkipCount, includeDetails: true);
|
var result = ObjectMapper.Map<List<WmsMaterial>, List<WmsMaterialDto>>(list);
|
|
var sheets = new Dictionary<string, object>
|
{
|
["配置"] = ExportHelper.ConvertListToExportData(result),
|
};
|
|
var fileName = "物料基础";
|
return (sheets, fileName);
|
}
|
|
/// <summary>
|
/// Checks the create or update dto asynchronous.
|
/// </summary>
|
/// <param name="input">The input.</param>
|
protected Task CheckCreateOrUpdateDtoAsync(WmsMaterialCreateOrUpdateDtoBase input)
|
{
|
Check.NotNull(input, nameof(input));
|
Check.NotNullOrWhiteSpace(input.MaterialNo, "编号", WmsMaterialConsts.MaxCodeLength);
|
Check.NotNullOrWhiteSpace(input.MaterialName, "名称", WmsMaterialConsts.MaxNameLength);
|
Check.Length(input.Remark, "备注", WmsMaterialConsts.MaxRemarkLength);
|
return Task.CompletedTask;
|
}
|
}
|
