public List <Order> GetByCustormer(String custormer) { using (var db = new OrderDB()) { return(db.Order.Include("items").Where(order => order.Customer.Equals(custormer)).ToList <Order>()); } }
public List <Order> GetAll() { using (var db = new OrderDB()) { return(db.Order.Include("items").ToList <Order>()); } }
public List <Order> GetByGoods(String good) { using (var db = new OrderDB()) { return(db.Order.Include("items").Where(order => order.Items.Where(item => item.Product.Equals(good)).Count() > 0).ToList <Order>()); } }
public Order GetOrder(String id) { using (var db = new OrderDB()) { return(db.Order.Include("items").SingleOrDefault(order => order.Id == id)); } }
}///更新订单 /// <summary> /// query by orderId /// </summary> /// <param name="orderId">id of the order to find</param> /// <returns>List<Order></returns> public Order GetById(int orderId) { using (var db = new OrderDB()) { return(db.Order.Include("Details").SingleOrDefault(o => o.Id == orderId));//找到order } }
}//删除货物 /// <summary> /// query all orders /// </summary> /// <returns>List<Order>:all the orders</returns> public List <Order> QueryAll() { using (var db = new OrderDB()) { return(db.Order.Include("Details").ToList <Order>()); } }
public List <Order> GetAllOrders() { using (var db = new OrderDB()) { List <OrderDetail> orderDetails = db.OrderDetail.Include("Goods").ToList <OrderDetail>(); List <Order> orders = db.Order.Include("Details").Include("Customer").ToList <Order>(); foreach (Order O in orders) { foreach (OrderDetail ODetail in O.Details) { foreach (OrderDetail orderDetail in orderDetails) { if (ODetail.Id.Equals(orderDetail.Id)) { ODetail.Goods = orderDetail.Goods; } } } } SaveOrders = orders; return(SaveOrders); } }
/// <summary> /// update the order /// </summary> /// <param name="order">the order to be updated</param> /*public void Update(Order order) { * RemoveOrder(order.Id); * orderList.Add(order); * } */ public void updata(Order order, List <OrderDetail> removed, List <OrderDetail> newDetails) { using (var db = new OrderDB()) { order.Details.AddRange(newDetails); foreach (OrderDetail Detail in order.Details) { if (removed.Contains(Detail)) { db.Entry(Detail).State = EntityState.Deleted; } else if (newDetails.Contains(Detail)) { db.Entry(Detail).State = EntityState.Added; } else { db.Entry(Detail).State = EntityState.Modified; } } db.SaveChanges(); db.Entry(order).State = EntityState.Modified; db.SaveChanges(); } }
/// <summary> /// query by customerName /// </summary> /// <param name="customerName">customer name</param> /// <returns></returns> /*public List<Order> QueryByCustomerName(string customerName) { * var query = orderList * .Where(o => o.Customer.Name == customerName); * return query.ToList(); * }*/ public List <Order> QueryByCustomerName(string customerName) { using (var db = new OrderDB()) { return(db.Order.Include("Details").Where(o => o.Customer.Equals(customerName)).ToList <Order>()); } }
public Order GetOrder(String Id) { using (var db = new OrderDB()) { return(db.Order.Include("Details"). SingleOrDefault(o => o.Id == Id)); } }
public void Add(Order order) { using (var db = new OrderDB()) { db.Order.Add(order); db.SaveChanges(); } }
public Order GetById(string orderId) { using (var db = new OrderDB()) { return(db.Order.Include("details"). SingleOrDefault(o => o.Id == orderId)); } }
public Order GetOrder(int Id) { using (var db = new OrderDB()) { return(db.Order.Include("Items"). SingleOrDefault(o => o.Id == Id)); } }
//private List<Order> orderList; /// <summary> /// constructor /// </summary> /// <summary> /// add new order /// </summary> /// <param name="order">the order to be added</param> public void AddOrder(Order order) { using (var db = new OrderDB()) { db.Entry(order).State = EntityState.Added; db.SaveChanges(); } }
/// <summary> /// query all orders /// </summary> /// <returns>List<Order>:all the orders</returns> public List <Order> QueryAllOrders() { //return orderDict.Values.ToList(); using (var db = new OrderDB()) { return(db.Order.Include("details").ToList <Order>()); } }
/// <summary> /// query by goodsName /// </summary> /// <param name="goodsName">the name of goods in order's orderDetail</param> /// <returns></returns> public List <Order> QueryByGoodsName(string goodsName) { using (var db = new OrderDB()) { var query = db.Order.Include("Details") .Where(o => o.Details.Where(detail => detail.Goods.Name.Equals(goodsName)).Count() > 0); return(query.ToList <Order>()); } }
/// <summary> /// update the order /// </summary> /// <param name="order">the order to be updated</param> public void Update(Order order) { RemoveOrder(order.Id); using (var db = new OrderDB()) { db.Entry(order).State = EntityState.Added; db.SaveChanges(); } }///更新订单
/// <summary> /// query orders whose totalAmount >= totalAmount /// </summary> /// <param name="totalAmount">the minimum totalAmount</param> /// <returns></returns> /* public List<Order> QueryByTotalAmount(float totalAmount) { * var query = orderList.Where(o=>o.TotalAmount>=totalAmount); * return query.ToList(); * }*/ public List <Order> QueryByTotalAmount(float totalAmount) { using (var db = new OrderDB()) { var query = db.Order.Include("Details") .Where(o => o.Details.Where(detail => detail.Goods.Equals(totalAmount)).Count() > 0); return(query.ToList <Order>()); } }
public void Delete(String orderId) { using (var db = new OrderDB()) { var order = db.Order.Include("Details").SingleOrDefault(o => o.Id == orderId); db.OrderDetail.RemoveRange(order.Details); db.Order.Remove(order); db.SaveChanges(); } }
public void RemoveOrder(string orderId) { using (var db = new OrderDB()) { var order = db.Order.Include("details").SingleOrDefault(o => o.Id == orderId); db.OrderItem.RemoveRange(order.details); db.Order.Remove(order); db.SaveChanges(); } }
public List <Order> QueryByGoods(String product) { using (var db = new OrderDB()) { var query = db.Order.Include("Details") .Where(o => o.Details.Where( item => item.Goods.Name.Equals(product)).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.Details.ForEach(detail => db.Entry(detail).State = EntityState.Modified); db.SaveChanges(); } }
/// <summary> /// remove order /// </summary> /// <param name="orderId">id of the order which will be removed</param> public void RemoveOrder(int orderId) { Order order = GetById(orderId); using (var db = new OrderDB()) { db.Entry(order).State = EntityState.Deleted; db.SaveChanges(); } }//数据库删除订单
public void Delete(int 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(); } }
/// <summary> /// query by customerName /// </summary> /// <param name="customerName">customer name</param> /// <returns></returns> public List <Order> QueryByCustomerName(string customerName) { //var query=orderDict.Values // .Where(order => order.Customer.Name == customerName); //return query.ToList(); using (var db = new OrderDB()) { return(db.Order.Include("details") .Where(order => order.Customer.Name == customerName) .ToList <Order>()); } }
public List <Order> QueryByPrice(double price) { using (var db = new OrderDB()) { return(db.Order.Include("details") .Where(order => order.Amount > price) .ToList <Order>()); } //var query = orderDict.Values // .Where(order => order.Amount> price); //return query.ToList(); }
/// <summary> /// query by goodsName /// </summary> /// <param name="goodsName">the name of goods in order's orderDetail</param> /// <returns></returns> public List <Order> QueryByGoodsName(string goodsName) { //var query = orderDict.Values.Where(order => // order.Details.Where(d => d.Goods.Name == goodsName) // .Count() > 0 // ); //return query.ToList(); using (var db = new OrderDB()) { return(db.Order.Include("details") .Where(order => order.Details.Where(d => d.Goods.Name == goodsName).Count() > 0) .ToList <Order>()); } }
/// <summary> /// add new order /// </summary> /// <param name="order">the order will be added</param> public void AddOrder(Order order) { //if (orderDict.ContainsKey(order.Id)) // throw new Exception($"order-{order.Id} is already existed!"); //orderDict[order.Id] = order; if (orderDict.ContainsKey(order.Id)) { throw new Exception($"order-{order.Id} is already existed!"); } else { using (var db = new OrderDB()) { db.Order.Add(order); db.SaveChanges(); } } }
public void Delete(string orderId) { using (var db = new OrderDB()) { var order = db.Order.Include("Details").Include("Customer").SingleOrDefault(o => o.Id == orderId); foreach (OrderDetail orderDetail in order.Details) { var ods = db.OrderDetail.Include("Goods").SingleOrDefault(d => d.Id == orderDetail.Id); db.Goods.Remove(ods.Goods); } db.OrderDetail.RemoveRange(order.Details); db.Customer.Remove(order.Customer); db.Order.Remove(order); SaveOrders.Remove(order); db.SaveChanges(); } }