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