/// <summary> /// 常见问题列表 /// </summary> /// <returns></returns> public async Task <GetHelpPageResponseDto> GetHelpPageAsync(GetHelpPageRequestDto request) { var sqlWhere = $@"1 = 1"; if (!string.IsNullOrWhiteSpace(request.Question)) { sqlWhere = $"{sqlWhere} and question like @Question"; } var sqlOrderBy = "sort desc"; var sql = $@" SELECT * FROM t_utility_help WHERE {sqlWhere} ORDER BY {sqlOrderBy}" ; request.Question = $"%{request.Question}%"; return(await MySqlHelper.QueryByPageAsync <GetHelpPageRequestDto, GetHelpPageResponseDto, GetHelpPageItemDto>(sql, request)); }
public async Task <IActionResult> GetHelpPageAsync([FromBody] GetHelpPageRequestDto request) { var response = await new HelpBiz().GetHelpPageAsync(request); return(Success(response)); }