public async Task <GetMerchantOrderDetailPageResponseDto> GetMerchantOrderDetailPageAsync(GetMerchantOrderDetailPageRequestDto request) { var sqlWhere = $@"1=1 and Enable=1"; if (!string.IsNullOrWhiteSpace(request.MerchantGuid)) { sqlWhere = $"{sqlWhere} AND merchant_guid = @MerchantGuid"; } if (request.BeginDate != null) { request.BeginDate = request.BeginDate?.Date; sqlWhere = $"{sqlWhere} AND creation_date > @BeginDate"; } if (request.EndDate != null) { request.EndDate = request.EndDate?.AddDays(1).Date; sqlWhere = $"{sqlWhere} AND creation_date < @EndDate"; } var sql = $@" SELECT * FROM( SELECT a.*, b.merchant_guid, b.category_name, d.user_Name as UserName, c.creation_date AS order_date, c.order_no, c.user_guid FROM t_mall_order_detail a LEFT JOIN t_mall_product b ON a.product_guid = b.product_guid LEFT JOIN t_mall_order c ON c.order_guid = a.order_guid LEFT JOIN t_utility_user d ON c.user_guid = d.user_guid where c.enable=1 ) __t WHERE {sqlWhere} ORDER BY creation_date desc" ; return(await MySqlHelper.QueryByPageAsync <GetMerchantOrderDetailPageRequestDto, GetMerchantOrderDetailPageResponseDto, GetMerchantOrderDetailPageItemDto>(sql, request)); }
public async Task <IActionResult> GetMerchantOrderDetailPageAsync([FromBody] GetMerchantOrderDetailPageRequestDto request) { var response = await new MerchantBiz().GetMerchantOrderDetailPageAsync(request); return(Success(response)); }