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