//输出所有订单 public List <Order> FindAll() { using (var db = new OrderDB()) { return(db.Order.Include("orderDetails").ToList <Order>()); } }
//通过用户名查找相应订单 public List <Order> FindByGuestName(string guestname) { using (var db = new OrderDB()) { return(db.Order.Include("OrderDetail") .Where(o => o.guestName.Equals(guestname)).ToList <Order>()); } }
//通过订单号查找相应订单 public Order FindByOrderNumber(long ordernumber) { using (var db = new OrderDB()) { return(db.Order.Include("OrderDetail"). SingleOrDefault(o => o.orderNumber == ordernumber)); } }
//通过货物名查找相应订单 public List <Order> FindByGoodName(string goodname) { using (var db = new OrderDB()) { var query = db.Order.Include("OrderDetail") .Where(o => o.orderDetail.Where( item => item.goodName.Equals(goodname)).Count() > 0); return(query.ToList <Order>()); } }
public void Update(Order order) { using (var db = new OrderDB()) { db.Order.Attach(order); db.Entry(order).State = EntityState.Modified; order.orderDetail.ForEach( item => db.Entry(item).State = EntityState.Modified); db.SaveChanges(); } }
//删除订单 public void RemoveOrder(long ordernumber) { using (var db = new OrderDB()) { var order = db.Order.Include("orderDetails").SingleOrDefault(o => o.orderNumber == ordernumber); db.OrderDetail.RemoveRange(order.orderDetail); db.Order.Remove(order); db.SaveChanges(); } //orderDictionary.Remove(ordernumber); }
//添加订单 public void AddOrder(Order order) { using (var db = new OrderDB()) { db.Order.Add(order); db.SaveChanges(); } //if (orderDictionary.ContainsKey(order.orderNumber)) // throw new Exception("Order has existed."); //orderDictionary[order.orderNumber] = order; }