//添加订单
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 Order QueryOrderById(int id)
{
using (var db = new OrderSystemContext())
{
var order = db.DBOrder.Include("orderDetails").FirstOrDefault(o => o.ID == id);
return(order);
}
}
public List <Order> QueryOrderByTotalPrice(double price)
{
using (var db = new OrderSystemContext())
{
var order = db.DBOrder.Include("orderDetails").ToList().Where(o => o.TotalPrice == price).ToList();
return(order);
}
}
public List <Order> QueryOrderByCustomer(string customerName)
{
using (var db = new OrderSystemContext())
{
var order = db.DBOrder.Include("orderDetails").Where(o => o.CustomerName == customerName).ToList();
return(order);
}
}
public List <Order> QueryOrderByGoodName(string goodName)
{
using (var db = new OrderSystemContext())
{
var order = db.DBOrder.Include("orderDetails").ToList().Where
(o => o.OrderDetails.Any(detail => detail.GoodName == goodName)).ToList();
return(order);
}
}
//删除订单
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();
}
}
public void init()
{
using (var db = new OrderSystemContext())
{
orderService.OrderList.Clear();
List <Order> orders = db.DBOrder.ToList <Order>();
for (int i = 0; i < orders.Count; i++)
{
db.DBOrderDetail.ToList().Where(od => od.OrderId == orders[i].ID).ToList <OrderDetail>();
orderService.AddOrder(orders[i]);
}
}
}
//将数据库中的数据导出到xml文件中
public void Export()
{
using (var db = new OrderSystemContext())
{
XmlSerializer xmlSerializer = new XmlSerializer(typeof(List <Order>));
using (FileStream fileStream = new FileStream("orders.xml", FileMode.Create))
{
var orders = db.DBOrder.ToList();
foreach (var o in orders)
{
List <OrderDetail> ods = db.DBOrderDetail.Where(od => od.OrderId == o.ID).ToList <OrderDetail>();
}
xmlSerializer.Serialize(fileStream, orders);
}
}
}