|
namespace WCS.Application;
|
|
/// <summary>
|
/// 设备工位服务
|
/// </summary>
|
[ApiDescriptionSettings(ApplicationConst.GroupName, Order = 100)]
|
public class WcsPositionService : IDynamicApiController, ITransient
|
{
|
private readonly SqlSugarRepository<WcsPosition> _WcsPositionRep;
|
private readonly SqlSugarRepository<WcsPlc> _wcsPlcRep;
|
public WcsPositionService(SqlSugarRepository<WcsPosition> WcsPositionRep, SqlSugarRepository<WcsPlc> wcsPlcRep)
|
{
|
_WcsPositionRep = WcsPositionRep;
|
_wcsPlcRep = wcsPlcRep;
|
}
|
|
/// <summary>
|
/// 分页查询设备工位
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[ApiDescriptionSettings(Name = "Page")]
|
[DisplayName("分页查询设备工位")]
|
public async Task<SqlSugarPagedList<WcsPositionOutput>> Page(PageWcsPositionInput input)
|
{
|
if (input.Field.IsNullOrEmpty())
|
{
|
input.Field = "u.Id";
|
input.Order = "desc";
|
}
|
input.SearchKey = input.SearchKey?.Trim();
|
var query = _WcsPositionRep.AsQueryable()
|
.WhereIF(!string.IsNullOrEmpty(input.SearchKey), u =>
|
u.Text.Contains(input.SearchKey)
|
|| u.StationNum.Contains(input.SearchKey)
|
)
|
.WhereIF(input.DeviceId > 0, u => u.DeviceId == input.DeviceId)
|
.WhereIF(!string.IsNullOrWhiteSpace(input.Text), u => u.Text.Contains(input.Text.Trim()))
|
//处理外键和TreeSelector相关字段的连接
|
.LeftJoin<WcsDevice>((u, deviceid) => u.DeviceId == deviceid.Id)
|
.Select((u, deviceid) => new WcsPositionOutput
|
{
|
Id = u.Id,
|
DeviceId = u.DeviceId,
|
DeviceIdText = deviceid.Text,
|
StationNum = u.StationNum,
|
PlcPos = u.PlcPos,
|
PosType = u.PosType,
|
StringLength = u.StringLength,
|
LedIP = u.LedIP,
|
Text = u.Text,
|
CreateUserId = u.CreateUserId,
|
CreateUserName = u.CreateUserName,
|
CreateTime = u.CreateTime,
|
UpdateUserId = u.UpdateUserId,
|
UpdateUserName = u.UpdateUserName,
|
UpdateTime = u.UpdateTime,
|
});
|
return await query.OrderBuilder(input).ToPagedListAsync(input.Page, input.PageSize);
|
}
|
|
/// <summary>
|
/// 增加设备工位
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[ApiDescriptionSettings(Name = "Add")]
|
[DisplayName("增加设备工位")]
|
public async Task<long> Add(AddWcsPositionInput input)
|
{
|
var entity = input.Adapt<WcsPosition>();
|
await _WcsPositionRep.InsertAsync(entity);
|
return entity.Id;
|
}
|
|
/// <summary>
|
/// 删除设备工位
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[ApiDescriptionSettings(Name = "Delete")]
|
[DisplayName("删除设备工位")]
|
public async Task Delete(DeleteWcsPositionInput input)
|
{
|
var entity = await _WcsPositionRep.GetFirstAsync(u => u.Id == input.Id) ?? throw Oops.Oh(ErrorCodeEnum.D1002);
|
await _WcsPositionRep.FakeDeleteAsync(entity); //假删除
|
//await _WcsPositionRep.DeleteAsync(entity); //真删除
|
}
|
|
/// <summary>
|
/// 更新设备工位
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[ApiDescriptionSettings(Name = "Update")]
|
[DisplayName("更新设备工位")]
|
public async Task Update(UpdateWcsPositionInput input)
|
{
|
var entity = input.Adapt<WcsPosition>();
|
await _WcsPositionRep.AsUpdateable(entity).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommandAsync();
|
}
|
|
/// <summary>
|
/// 获取设备工位
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet]
|
[ApiDescriptionSettings(Name = "Detail")]
|
[DisplayName("获取设备工位")]
|
public async Task<WcsPosition> Detail([FromQuery] QueryByIdWcsPositionInput input)
|
{
|
return await _WcsPositionRep.GetFirstAsync(u => u.Id == input.Id);
|
}
|
|
/// <summary>
|
/// 获取设备工位列表
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet]
|
[ApiDescriptionSettings(Name = "List")]
|
[DisplayName("获取设备工位列表")]
|
public async Task<List<WcsPositionOutput>> List([FromQuery] PageWcsPositionInput input)
|
{
|
return await _WcsPositionRep.AsQueryable().Select<WcsPositionOutput>().ToListAsync();
|
}
|
|
/// <summary>
|
/// 获取设备ID列表
|
/// </summary>
|
/// <returns></returns>
|
[ApiDescriptionSettings(Name = "WcsDeviceDeviceIdDropdown"), HttpGet]
|
[DisplayName("获取设备ID列表")]
|
public async Task<dynamic> WcsDeviceDeviceIdDropdown()
|
{
|
return await _WcsPositionRep.Context.Queryable<WcsDevice>()
|
.Select(u => new
|
{
|
Label = u.Text,
|
Value = u.Id
|
}
|
).ToListAsync();
|
}
|
|
/// <summary>
|
/// 获取设备ID列表
|
/// </summary>
|
/// <returns></returns>
|
[ApiDescriptionSettings(Name = "WcsPlcIdDropdown"), HttpGet]
|
[DisplayName("获取设备ID列表")]
|
public async Task<dynamic> WcsPlcIdDropdown()
|
{
|
return await _wcsPlcRep.Context.Queryable<WcsPlc>()
|
.Select(u => new
|
{
|
Label = u.Text,
|
Value = u.Id
|
}
|
).ToListAsync();
|
}
|
|
|
}
|
