public Order QueryById(String Id)
{
using (var db = new OrderDB())
{
return(db.Order.Include("Items").SingleOrDefault(order => order.OrderNumber == Id));
}
}
public List <Order> QueryBigOrder()
{
using (var db = new OrderDB())
{
return(db.Order.Include("Items").Where(order => order.TotalPrice > 10000).ToList <Order>());
}
}
public List <Order> QueryByClient(String client)
{
using (var db = new OrderDB())
{
return(db.Order.Include("Items").Where(order => order.Client.Equals(client)).ToList <Order>());
}
}
public List <Order> GetAllOrders()
{
using (var db = new OrderDB())
{
return(db.Order.Include("Items").ToList <Order>());
}
}
public List <Order> QueryByGoods(String product)
{
using (var db = new OrderDB())
{
return(db.Order.Include("Items").Where(order => order.Items.Where(
item => item.Product.Equals(product)).Count() > 0).ToList <Order>());
}
}
public void Add(Order order)
{
using (var db = new OrderDB())
{
db.Entry(order).State = EntityState.Added;
db.SaveChanges();
}
}
//public bool IsOrderExist(string id)
//{
// using (var db = new OrderDB())
// {
// bool flag;
// foreach (Order order in db.Order)
// {
// if(order.Id!=id)
// {
// flag = false;
// }
// else
// {
// flag = true;
// break;
// }
// }
// return flag;
// }
//}
public Order GetOrder(String Id)
{
using (var db = new OrderDB())
{
return(db.Order.Include("OrderItems").
SingleOrDefault(o => o.Id == Id));
}
}
public void Add(Order order)
{
using (var db = new OrderDB())
{
db.Order.Add(order);
db.SaveChanges();
}
}
public void Update(Order order)
{
using (var db = new OrderDB())
{
db.Order.Attach(order);
db.Entry(order).State = EntityState.Modified;
order.Items.ForEach(item => db.Entry(item).State = EntityState.Modified);
db.SaveChanges();
}
}
public void Delete(String orderId)
{
using (var db = new OrderDB())
{
var order = db.Order.Include("Items").SingleOrDefault(o => o.OrderNumber == orderId); //Include()，把指定的外键表信息也读出来
db.OrderItem.RemoveRange(order.Items);
db.Order.Remove(order);
db.SaveChanges();
}
}
public void Delete(String orderId)
{
using (var db = new OrderDB())
{
var order = db.Order.Include("OrderItems").SingleOrDefault(o => o.Id == orderId);
db.OrderItem.RemoveRange(order.OrderItems);
db.Order.Remove(order);
db.SaveChanges();
}
}
