Exemple #1
0
        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));
        }
Exemple #2
0
        public async Task <IActionResult> GetOrderDetailPageAsync([FromBody] GetOrderDetailPageRequestDto request)
        {
            var response = await new UserBiz().GetOrderDetailPageAsync(request);

            return(Success(response));
        }