/// <summary> /// 查找订单 /// </summary> /// <param name="request"></param> /// <returns></returns> public static SearchOrderResponse SearchOrder(SearchOrderRequest request) { using (JsonServiceClient client = new JsonServiceClient(AppSetting.OrderServiceURL)) { return(client.Send <SearchOrderResponse>(request)); } }
internal SearchOrderResponse SearchOrder(SearchOrderRequest request) { try { return(TripOrderDBFacade.SearchOrder(request)); } catch { throw new AppException(AppErrorEnum.InternalServerError); } }
internal SearchOrderResponse SearchOrder(SearchOrderRequest request) { const string sql = @"SELECT OrderID, OrderStateID, Amount, ProductID, ProductName, MemberID, MemberName, OrderCreatedTime FROM dbo.[Order] WITH(NOLOCK) WHERE OrderID = @OrderID"; using (var connection = new SqlConnection(ConnectionString.TripOrderDB_SELECT)) { connection.Open(); return(connection.QuerySingleOrDefault <SearchOrderResponse>(sql, new { OrderID = request.OrderID })); } }
/// <summary> /// 查询订单 /// </summary> /// <param name="request">查询条件</param> /// <returns></returns> public static SearchOrderResponse SearchOrder(SearchOrderRequest request) { SearchOrderResponse response = new SearchOrderResponse(); try { response = orderLogic.SearchOrder(request); } catch (AppException ex) { response.ErrorCode = ex.Code; response.ErrorMsg = ex.Message; } catch { response.ErrorCode = (int)AppErrorEnum.InternalServerError; response.ErrorMsg = EnumHelper.GetEnumDescription(AppErrorEnum.InternalServerError); } return(response); }
/// <summary> /// 查询订单 /// </summary> /// <param name="request">查询条件</param> /// <returns></returns> public SearchOrderResponse Any(SearchOrderRequest request) { return(BusinessFacade.SearchOrder(request)); }
public async Task <IActionResult> SearchProduct(SearchOrderRequest request) { var data = await _manageOrderService.SearchOrder(request); return(Ok(data)); }
/// <summary> /// 查询订单 /// </summary> /// <param name="request">查询条件</param> /// <returns></returns> public static SearchOrderResponse SearchOrder(SearchOrderRequest request) { return(Query.SearchOrder(request)); }
public async Task <List <OrderViewModel> > SearchOrder(SearchOrderRequest request) { Expression <Func <Order, bool> > expression = x => DateTime.Compare(DateTime.Parse(request.startDate), x.deliveryDate) <= 0 && DateTime.Compare(DateTime.Parse(request.endDate), x.deliveryDate) >= 0; var query = _context.orders.AsQueryable(); if (!string.IsNullOrEmpty(request.keyWord)) { query = query.Where(x => (!string.IsNullOrEmpty(x.guess) ? x.guess : x.user.displayname).Contains(request.keyWord) || x.phone.Contains(request.keyWord) || x.email.Contains(request.keyWord)); } if (!string.IsNullOrEmpty(request.startDate) && !string.IsNullOrEmpty(request.endDate)) { query = query.Where(expression); } //TH là OrderNotConfirm if (request.status == 0) { var list = await query.Where(x => x.status == enums.OrderStatus.NotConfirm).Include(e => e.OrderDetails) .Select(y => new OrderViewModel { id = y.id, address = y.address, createDate = y.createDate, deliveryDate = y.deliveryDate, email = y.email, guess = y.guess, note = y.note, feeShip = y.feeShip, OrderDetails = y.OrderDetails, phone = y.phone, status = y.status, street = y.street, total = y.total, user = y.user, userId = y.userId.Value, }).ToListAsync(); var temp = new List <OrderViewModel>(); foreach (var item in list) { var i = new OrderViewModel { id = item.id, address = item.address, createDate = item.createDate, deliveryDate = item.deliveryDate, email = item.email, guess = item.guess, note = item.note, feeShip = item.feeShip, OrderDetails = item.OrderDetails, phone = item.phone, status = item.status, street = item.street, total = item.total, user = item.user, userId = item.userId, enableOrder = checkEnableOrder(item.id) }; temp.Add(i); } return(temp); } return(await query.Where(z => z.status == request.status).Select(r => new OrderViewModel { id = r.id, address = r.address, createDate = r.createDate, deliveryDate = r.deliveryDate, email = r.email, guess = r.guess, note = r.note, feeShip = r.feeShip, OrderDetails = r.OrderDetails, phone = r.phone, status = r.status, street = r.street, total = r.total, user = r.user, userId = r.userId.Value, } ).ToListAsync()); }
internal SearchOrderResponse SearchOrder(SearchOrderRequest request) { return(TripOrderDBFacade.SearchOrder(request)); }