public void AddOrder(Order order)
{
using (var db = new OrderDB())
{
db.Order.Add(order);
db.SaveChanges();
}
}
//按订单号删除
public void RemoveOrder(string onum)
{
using (var db = new OrderDB())
{
var order = db.Order.Include("oDlist").SingleOrDefault(o => o.ONum == onum);
db.Order.Remove(order);
db.OrderDetails.RemoveRange(order.oDlist);
db.SaveChanges();
}
}
public void DeleteOrderById(string id)
{
using (var db = new OrderDB())
{
var order = db.Order.Include("Items").SingleOrDefault(o => o.ID == id);
db.OrderItem.RemoveRange(order.items);
db.Order.Remove(order);
db.SaveChanges();
}
}
public void ReviseOrder(Order order)
{
using (var db = new OrderDB())
{
db.Order.Attach(order);
db.Entry(order).State = EntityState.Modified;
order.oDlist.ForEach(
item => db.Entry(item).State = EntityState.Modified);
db.SaveChanges();
}
}
public void AddOrder(Order order)
{
using (var db = new OrderDB())
{
db.Order.Add(order);
db.Order.Attach(order);
db.Entry(order).State = EntityState.Added;
db.SaveChanges();
}
Console.WriteLine("添加成功");
}