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