public async Task <GetMemberOrderPageResponseDto> GetMemberOrderPageAsync(GetMemberOrderPageRequestDto request)
{
var sqlWhere = $@"1 = 1 and enable=1 and user_Guid=@UserGuid";
var sqlOrderBy = "creation_date desc";
var sql = $@"
SELECT * FROM(
SELECT
a.*,
b.merchant_name
FROM
t_mall_order a
LEFT JOIN t_merchant b ON a.merchant_guid = b.merchant_guid
)___T
WHERE
{sqlWhere}
ORDER BY
{sqlOrderBy}" ;
return(await MySqlHelper.QueryByPageAsync <GetMemberOrderPageRequestDto, GetMemberOrderPageResponseDto, GetMemberOrderPageItemDto>(sql, request));
}
public async Task <IActionResult> GetMemberOrderPageAsync([FromBody] GetMemberOrderPageRequestDto request)
{
var response = await new UserBiz().GetMemberOrderPageAsync(request);
return(Success(response));
}
