public async Task <List <MachineryInfo> > GetListAsync([FromQuery] MachineryInfoSearchRequest request)
{
_logger.Info(new LogInfo()
{
Method = nameof(GetListAsync), Argument = new { request }, Description = "获取客户地址列表"
});
var userIdClaim = User.Claims.FirstOrDefault(t => t.Type == JwtRegisteredClaimNames.Sid);
Guid?userId = userIdClaim != null ? (Guid?)Guid.Parse(userIdClaim.Value) : null;
if (!request.UserId.HasValue)
{
request.UserId = userId;
}
return(await _MachineryInfoService.GetListAsync(request));
}
private Tuple <string, DynamicParameters> GetWhere(MachineryInfoSearchRequest request, DynamicParameters parameters)
{
StringBuilder sbWhere = new StringBuilder();
if (request.UserId.HasValue)
{
sbWhere.Append(" AND UserId = @UserId ");
parameters.Add("@UserId", request.UserId.Value);
}
if (request.PurchaseDate.HasValue)
{
sbWhere.Append(" AND PurchaseDate = @PurchaseDate ");
parameters.Add("@PurchaseDate", request.PurchaseDate.Value);
}
return(new Tuple <string, DynamicParameters>(sbWhere.ToString(), parameters));
}
public async Task <List <MachineryInfo> > GetListAsync(MachineryInfoSearchRequest request)
{
StringBuilder sbSql = new StringBuilder();
DynamicParameters parameters = new DynamicParameters();
sbSql.Append(" SELECT * FROM machineryinfo WHERE IsDeleted = 0 ");
var where = this.GetWhere(request, parameters);
if (where?.Item1?.Length > 0)
{
sbSql.Append(where.Item1);
}
//添加排序
sbSql.Append(" Order By CreationTime DESC ");
using (ReadConnection)
{
var r1 = await ReadConnection.QueryAsync <MachineryInfo>(sbSql.ToString(), parameters);
return(r1.ToList());
}
}
/// <summary>
/// 查询客户机器
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public async Task <List <MachineryInfo> > GetListAsync(MachineryInfoSearchRequest request)
{
return(await MachineryInfoRep.GetListAsync(request));
}
