//添加订单 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); } } }