public void AddOrder(Order order)
{
using (var db = new OrderDB())
{
db.Orders.Add(order);
db.SaveChanges();
}
}
//按客户删除订单
public void DeleteByCliend(string client)
{
using (var db = new OrderDB())
{
var order = db.Orders.Include("OrderDetails").SingleOrDefault(o => o.CustomerName == client);
db.OrderDetails.RemoveRange(order.OrderDetails);
db.Orders.Remove(order);
db.SaveChanges();
}
}
//按订单号删除订单
public void RemoveOrder(string orderId)
{
using (var db = new OrderDB())
{
db.OrderDetails.Include("Goods").ToList <OrderDetails>();
db.OrderDetails.Include("Customers").ToList <OrderDetails>();
var order = db.Orders.Include("OrderDetails").SingleOrDefault(o => o.OrderId == orderId);
db.OrderDetails.RemoveRange(order.OrderDetails);
db.Orders.Remove(order);
db.SaveChanges();
}
}