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)); }