public async Task <IActionResult> GetQuestionCollectionListAsync([FromQuery] GetQuestionCollectionListRequestDto requestDto) { var response = await new FaqsQuestionBiz().GetQuestionCollectionListAsync(requestDto, UserID); return(Success(response)); }
/// <summary> /// 获取用户收藏的问题列表 /// </summary> /// <param name="requestDto">分页参数</param> /// <param name="userId">用户guid</param> /// <returns></returns> public async Task <GetQuestionCollectionListResponseDto> GetQuestionCollectionListAsync(GetQuestionCollectionListRequestDto 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 INNER JOIN t_consumer_collection c ON a.question_guid = c.target_guid LEFT JOIN t_utility_hot b ON a.question_guid = b.owner_guid WHERE c.user_guid = '{userId}' AND a.`enable` = 1 and c.`enable`=1 ORDER BY c.creation_date DESC" ; var result = await MySqlHelper.QueryByPageAsync <GetQuestionCollectionListRequestDto, GetQuestionCollectionListResponseDto, GetQuestionCollectionListItemDto>(sql, requestDto); return(result); }