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