using Admin.NET.Core.Service;
using Admin.NET.Application.Entity;
using Microsoft.AspNetCore.Http;
namespace Admin.NET.Application;
///
/// 物料类型表服务
///
[ApiDescriptionSettings(ApplicationConst.WmsBaseGroupName, Order = 100)]
public class WmsMaterialTypeService : IDynamicApiController, ITransient
{
private readonly SqlSugarRepository _wmsMaterialRep;
private readonly SqlSugarRepository _rep;
public WmsMaterialTypeService(SqlSugarRepository rep,
SqlSugarRepository wmsMaterialRep
)
{
_rep = rep;
_wmsMaterialRep = wmsMaterialRep;
}
///
/// 分页查询物料类型表
///
///
///
[HttpPost]
[ApiDescriptionSettings(Name = "Page")]
public async Task> Page(WmsMaterialTypeInput input)
{
var query = _rep.AsQueryable()
.WhereIF(!string.IsNullOrWhiteSpace(input.SearchKey), u =>
u.MaterialTypeCode.Contains(input.SearchKey.Trim())
|| u.MaterialTypeName.Contains(input.SearchKey.Trim())
)
.WhereIF(input.IsDisabled != null, u => u.IsDisabled == input.IsDisabled) //ly-0612下拉数据用
.WhereIF(!string.IsNullOrWhiteSpace(input.MaterialTypeCode), u => u.MaterialTypeCode.Contains(input.MaterialTypeCode.Trim()))
.WhereIF(!string.IsNullOrWhiteSpace(input.MaterialTypeName), u => u.MaterialTypeName.Contains(input.MaterialTypeName.Trim()))
.Select();
return await query.OrderBuilder(input).ToPagedListAsync(input.Page, input.PageSize);
}
///
/// 增加物料类型表
///
///
///
[ApiDescriptionSettings(Name = "Add")]
public async Task Add(AddWmsMaterialTypeInput input)
{
var entity = input.Adapt();
//验重
await CheckExisit(entity);
await _rep.InsertAsync(entity);
return entity.Id;
}
///
/// 删除物料类型表
///
///
///
[HttpPost]
[ApiDescriptionSettings(Name = "Delete")]
public async Task Delete(DeleteWmsMaterialTypeInput input)
{
var materialTypeModel = await _rep.AsQueryable().FirstAsync(p =>p.Id == input.Id);
var Model = await _wmsMaterialRep.AsQueryable().FirstAsync(p => p.MaterialTypeCode == materialTypeModel.MaterialTypeCode);
if (Model != null) throw Oops.Oh("该物料类型有关联物料不可删除");
var entity = await _rep.GetFirstAsync(u => u.Id == input.Id) ?? throw Oops.Oh(ErrorCodeEnum.D1002);
//await _rep.FakeDeleteAsync(entity); //假删除
await _rep.DeleteAsync(entity); //真删除
}
///
/// 更新物料类型表
///
///
///
[HttpPost]
[ApiDescriptionSettings(Name = "Update")]
public async Task Update(UpdateWmsMaterialTypeInput input)
{
var entity = input.Adapt();
//验重
await CheckExisit(entity,true);
await _rep.AsUpdateable(entity).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommandAsync();
}
///
/// 获取物料类型表
///
///
///
[HttpGet]
[ApiDescriptionSettings(Name = "Detail")]
public async Task Detail([FromQuery] QueryByIdWmsMaterialTypeInput input)
{
return await _rep.GetFirstAsync(u => u.Id == input.Id);
}
///
/// 获取物料类型表列表
///
///
///
[HttpGet]
[ApiDescriptionSettings(Name = "List")]
public async Task> List([FromQuery] WmsMaterialTypeInput input)
{
return await _rep.AsQueryable().Select().ToListAsync();
}
#region 私有方法
///
/// 根据联合主键验证数据是否已存在-数据库
///
///
///
///
private async Task CheckExisit(WmsBaseMaterialType input, bool isEdit = false)
{
//输出数据已存在错误
ErrorCodeItemMetadataAttribute metadata = ErrorCodeEnum.D1006.GetErrorCodeItemMetadata();
WmsBaseMaterialType _existItem = null;
if (!isEdit)//新增
{
_existItem = await _rep.GetFirstAsync(u => u.MaterialTypeCode.Equals(input.MaterialTypeCode));
if (_existItem != null) throw Oops.Oh($"类型编号[{input.MaterialTypeCode}]{metadata.ErrorMessage}");
_existItem = await _rep.GetFirstAsync(u => u.MaterialTypeName.Equals(input.MaterialTypeName));
if (_existItem != null) throw Oops.Oh($"类型名称[{input.MaterialTypeName}]{metadata.ErrorMessage}");
}
else//编辑
{
//当前编辑数据以外是否存在重复
_existItem = await _rep.GetFirstAsync(u => u.Id != input.Id && u.MaterialTypeCode.Equals(input.MaterialTypeCode));
if (_existItem != null) throw Oops.Oh($"类型编号[{input.MaterialTypeCode}]{metadata.ErrorMessage}");
_existItem = await _rep.GetFirstAsync(u => u.Id != input.Id && u.MaterialTypeName.Equals(input.MaterialTypeName));
if (_existItem != null) throw Oops.Oh($"类型名称[{input.MaterialTypeName}]{metadata.ErrorMessage}");
}
}
#endregion
}