public async Task <GetOrderDetailPageResponseDto> GetOrderDetailPageAsync(GetOrderDetailPageRequestDto request)
{
var sqlWhere = $@"1 = 1 and enable=1 and order_Guid=@OrderGuid";
var sqlOrderBy = "creation_date desc";
var sql = $@"
SELECT * FROM(
SELECT
a.* ,
b.category_name
FROM
t_mall_order_detail a
LEFT JOIN t_mall_product b ON a.product_guid = b.product_guid
)___T
WHERE
{sqlWhere}
ORDER BY
{sqlOrderBy}" ;
return(await MySqlHelper.QueryByPageAsync <GetOrderDetailPageRequestDto, GetOrderDetailPageResponseDto, GetOrderDetailPageItemDto>(sql, request));
}
public async Task <IActionResult> GetOrderDetailPageAsync([FromBody] GetOrderDetailPageRequestDto request)
{
var response = await new UserBiz().GetOrderDetailPageAsync(request);
return(Success(response));
}