//添加订单
public void AddOrder(Order order)
{
orderService.OrderList.Add(order);
using (var db = new OrderSystemContext())
{
var customer = db.DBCustomer.FirstOrDefault(c => c.Name == order.CustomerName);
if (customer == null)
{
db.DBCustomer.Add(new Customer()
{
Name = order.CustomerName
});
}
foreach (var detail in order.OrderDetails)
{
var good = new Good(detail.GoodName, detail.GoodPrice);
var result = db.DBGood.ToList().FirstOrDefault(g => g.Name == good.Name);
if (result == null)
{
db.DBGood.Add(good);
}
}
db.DBOrder.Add(order);
db.SaveChanges();
}
}
//将xml文件中的数据导入到数据库中
public void ImportData()
{
init();
using (var db = new OrderSystemContext())
{
List <Order> orders = new List <Order>();
XmlSerializer xmlSerializer = new XmlSerializer(typeof(List <Order>));
using (FileStream fileStream = new FileStream("orders.xml", FileMode.Create))
{
xmlSerializer.Serialize(fileStream, orders);
}
foreach (var order in orders)
{
var m = db.DBOrder.FirstOrDefault(o => o.ID == order.ID);
if (m == null)
{
db.DBOrder.Add(order);
}
foreach (var od in order.OrderDetails)
{
var n = db.DBOrderDetail.Where(odetail => odetail.id == od.id);
if (n == null)
{
db.DBOrderDetail.Add(od);
}
}
}
db.SaveChanges();
}
}
//删除订单
public void RemoveOrder(int id)
{
orderService.RemoveOrder(id);
using (var db = new OrderSystemContext())
{
var order = db.DBOrder.Include("orderDetails").FirstOrDefault(o => o.ID == id);
db.DBOrder.Remove(order);
db.SaveChanges();
}
}
//根据id修改订单
public void ModifyOrder(int id, Order order)
{
using (var db = new OrderSystemContext())
{
orderService.RemoveOrder(id);
orderService.OrderList.Add(order);
this.RemoveOrder(id);
this.AddOrder(order);
db.SaveChanges();
}
}
