public OrderDetailViewModel.OrderListResult GetAllOrderDetail()
{
//放入OrderVMList
List <OrderDetailViewModel.OrderSingleResult> OrderDetailVMList;
OrderDetailVMList = (
from OrderDetail in _dbRepository.GetAll <OrderDetail>()
//join Order in _dbRepository.GetAll<Order>()
//on OrderDetail.OrderId equals Order.OrderId
join Product in _dbRepository.GetAll <Product>()
on OrderDetail.ProductId equals Product.ProductId
//orderby Order.OrderDate descending
select new OrderDetailViewModel.OrderSingleResult()
{
OrderDetailId = OrderDetail.OrderDetailId,
OrderId = OrderDetail.OrderId, //join OrderId
Quantity = OrderDetail.Quantity,
ProductId = OrderDetail.ProductId, //join Product
ProductName = Product.ProductName,
UnitPrice = Product.UnitPrice,
SpecialPrice = OrderDetail.SpecialPrice,
}).ToList();
var result = new OrderDetailViewModel.OrderListResult();
result.OrderDetailList = OrderDetailVMList;
return(result);
}
public OrderViewModel.OrderListResult GetTodayOrderPrice()
{
var today = DateTime.Now.Day;
//放入OrderVMList
List <OrderViewModel.OrderSingleResult> OrderVMList;
OrderVMList = (from Order in _dbRepository.GetAll <Order>().Where(x => x.CreateTime.Day == today)
join Member in _dbRepository.GetAll <Member>()
on Order.MemberId equals Member.MemberId
orderby Order.OrderDate descending
select new OrderViewModel.OrderSingleResult()
{
OrderId = Order.OrderId,
ShippingDate = Order.ShippingDate,
OrderDate = Order.OrderDate,
MemberId = Order.MemberId,
MemberUserName = Member.MemberUserName,
ShipName = Order.ShipName,
ShipCity = Order.ShipCity,
ShipRegion = Order.ShipRegion,
ShipAddress = Order.ShipAddress,
ShipPostalCode = Order.ShipPostalCode,
InvoiceType = Order.InvoiceType,
InvoiceInfo = Order.InvoiceInfo,
CreateTime = Order.CreateTime,
UpdateTime = Order.UpdateTime,
PaymentType = Order.PaymentType,
PaymentState = Order.PaymentState,
}).ToList();
OrderDetailViewModel.OrderListResult OrderDetailVMList = GetAllOrderDetail();
foreach (var OrderVM in OrderVMList)
{
OrderVM.OrderDetailList =
OrderDetailVMList.OrderDetailList
.Where(OrderDetail => OrderDetail.OrderId == OrderVM.OrderId)
.ToList();
}
var result = new OrderViewModel.OrderListResult();
result.OrderList = OrderVMList;
return(result);
}
