/// <summary> /// 获取首页推荐列表 /// </summary> /// <param name="guid"></param> /// <returns></returns> public async Task <IEnumerable <GetHomeRecommendItemDto> > GetHomeRecommendAsync(GetHomeRecommendRequestDto request) { var sql = $@" SELECT A.recommend_guid, A.NAME, A.target, A.remark, A.type, A.Sort , B.accessory_guid, B.base_path, B.relative_path FROM t_manager_recommend A LEFT JOIN t_utility_accessory B ON A.picture_guid = B.accessory_guid WHERE A.ENABLE = @ENABLE ORDER BY A.sort DESC LIMIT {request.Take}" ; using (var conn = MySqlHelper.GetConnection()) { var result = await conn.QueryAsync <RecommendModel, AccessoryModel, GetHomeRecommendItemDto>(sql, (a, b) => { return(new GetHomeRecommendItemDto { Name = a.Name, PictureUrl = $"{b?.BasePath}{b?.RelativePath}", RecommendGuid = a.RecommendGuid, Remark = a.Remark, Sort = a.Sort, Target = a.Target, Type = a.Type }); }, new { enable = true }, splitOn : "accessory_guid"); return(result); } }
public async Task <IActionResult> GetHomeRecommendAsync([FromBody] GetHomeRecommendRequestDto request) { var response = await new RecommendBiz().GetHomeRecommendAsync(request); return(Success(response)); }