public void AddOrder(Order order)
{
using (var db = new OrderDB())
{
db.Order.Add(order);
db.SaveChanges();
}
}
public int AddOrder(Order order)//添加订单
{
using (var db = new OrderDB()) {
db.Order.Add(order);
db.SaveChanges();
}
orderDict[order.Id] = order;
return(0);
}
public void Delete(String orderId)
{
using (var db = new OrderDB())
{
var order = db.Order.Include("Items").SingleOrDefault(o => o.Id == orderId);
db.OrderItem.RemoveRange(order.Items);
db.Order.Remove(order);
db.SaveChanges();
}
}
public void Add(Order order)
{
using (var db = new OrderDB())
{
db.Order.Add(order);
//db.Order.Attach(order);
//db.Entry(order).State = EntityState.Added;
db.SaveChanges();
}
}
//添加订单
public void AddOrder(string num1, string cusName1, string phoneNum1, string goodName1, double price1)
{
OrderDetails A = new OrderDetails(num1, cusName1, phoneNum1, goodName1, price1);
using (var db = new OrderDB())
{
db.OrderDetails.Add(A);
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 int RemoveOrder(int orderId)//删除订单
{
using (var db = new OrderDB())
{
var order = db.Order.Include("Details").SingleOrDefault(o => o.Id == orderId);
db.OrderDetails.RemoveRange(order.Details);
db.Order.Remove(order);
db.SaveChanges();
}
orderDict.Remove(orderId);
return(0);
}
//删除订单
public void DeleteOrder(string num1)
{
using (var db = new OrderDB())
{
var order = db.OrderDetails.SingleOrDefault(o => o.num == num1);
if (order != null)
{
db.OrderDetails.Remove(order);
db.SaveChanges();
}
else
{
Console.WriteLine("订单不存在不能删除");
}
}
}
//修改订单
public void ChangeOrder(string num2, string cusName2, string phoneNum2, string goodName2, double price2, string num1, string cusName1, string phoneNum1, string goodName1, double price1)
{
OrderDetails B = new OrderDetails(num1, cusName1, phoneNum1, goodName1, price1);
using (var db = new OrderDB())
{
var A = db.OrderDetails.SingleOrDefault(o => o.num == num2 && o.goodName == goodName2 && o.cusName == cusName2 && o.price == price2 && o.phoneNum == phoneNum2);
if (A != null)
{
db.OrderDetails.Remove(A);
db.OrderDetails.Add(B);
db.SaveChanges();
}
else
{
Console.WriteLine("订单修改失败");
}
}
}