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