public async Task <IActionResult> GetHomeGroupbuyAsync([FromBody] GetHomeGroupbuyRequestDto request)
{
var response = await new GroupbuyBiz().GetHomeGroupbuyAsync(request);
return(Success(response));
}
/// <summary>
/// 获取首页团购
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public async Task <IEnumerable <GetHomeGroupbuyItemDto> > GetHomeGroupbuyAsync(GetHomeGroupbuyRequestDto request)
{
var sql = $@"
SELECT
A.*,
B.product_name,
B.standerd,
CONCAT( C.base_path, C.relative_path ) AS PictureUrl
FROM
t_mall_groupbuy A
LEFT JOIN t_mall_product B ON B.product_guid = A.product_guid
LEFT JOIN t_utility_accessory C ON C.accessory_guid = B.picture_guid
WHERE
A.end_date >= now( )
AND A.ENABLE =1
ORDER BY
A.sort DESC
LIMIT {request.Take}
";
using (var conn = MySqlHelper.GetConnection())
{
var result = await conn.QueryAsync <GetHomeGroupbuyItemDto>(sql);
return(result);
}
}
