public async Task <IActionResult> GetOwnedQuestionsPageListAsync([FromQuery] GetOwnedQuestionsPageListRequestDto requestDto)
{
var response = await new FaqsQuestionBiz().GetOwnedQuestionsPageListAsync(requestDto, UserID);
return(Success(response));
}
/// <summary>
/// 获取我的提问分页列表
/// </summary>
/// <param name="requestDto">分页参数</param>
/// <param name="userId">用户guid</param>
/// <returns></returns>
public async Task <GetOwnedQuestionsPageListResponseDto> GetOwnedQuestionsPageListAsync(GetOwnedQuestionsPageListRequestDto requestDto, string userId)
{
var sql = $@"SELECT
a.question_guid,
a.content,
a.creation_date,
a.answer_num,
a.`status`,
ifnull( b.visit_count, 0 ) AS visit_count
FROM
t_faqs_question a
LEFT JOIN t_utility_hot b ON a.question_guid = b.owner_guid
WHERE a.user_guid='{userId}' and a.`enable`=1
ORDER BY
a.creation_date DESC" ;
var result = await MySqlHelper.QueryByPageAsync <GetOwnedQuestionsPageListRequestDto, GetOwnedQuestionsPageListResponseDto, GetOwnedQuestionsPageListItemDto>(sql, requestDto);
return(result);
}
