//按订单号查询订单
public OrderDetails SearchOrder1(string num1)
{
using (var db = new OrderDB())
{
return(db.OrderDetails.SingleOrDefault(o => o.num == num1));
}
}
//按商品名称查询订单
public OrderDetails SearchOrder2(string goodName1)
{
using (var db = new OrderDB())
{
return(db.OrderDetails.SingleOrDefault(o => o.goodName == goodName1));
}
}
//获得所有订单
public List <OrderDetails> GetAllOrders()
{
using (var db = new OrderDB())
{
return(db.OrderDetails.ToList <OrderDetails>());
}
}
public List <Order> GetAllOrders()
{
using (var db = new OrderDB())
{
return(db.Order.Include("Items").ToList <Order>());
}
}
//查询电话号码
public OrderDetails SearchOrder4(string phoneNum1)
{
using (var db = new OrderDB())
{
return(db.OrderDetails.SingleOrDefault(o => o.phoneNum == phoneNum1));
}
}
//按客户查询订单
public OrderDetails SearchOrder3(string cusName1)
{
using (var db = new OrderDB())
{
return(db.OrderDetails.SingleOrDefault(o => o.cusName == cusName1));
}
}
public List <Order> QueryById(String id)
{
using (var db = new OrderDB())
{
return(db.Order.Include("items")
.Where(o => o.Id.Equals(id)).ToList <Order>());
}
}
public void AddOrder(Order order)
{
using (var db = new OrderDB())
{
db.Order.Add(order);
db.SaveChanges();
}
}
public Order GetOrder(String Id)
{
using (var db = new OrderDB())
{
return(db.Order.Include("Items").
SingleOrDefault(o => o.Id == Id));
}
}
public List <Order> QueryByCustormer(String custormer)
{
using (var db = new OrderDB())
{
return(db.Order.Include("Items")
.Where(o => o.Customer.Equals(custormer)).ToList <Order>());
}
}
public List <Order> QueryAllOrders() //查询所有订单
{
using (var db = new OrderDB())
{
return(db.Order.Include("Details").ToList <Order>());
}
return(orderDict.Values.ToList());
}
public int AddOrder(Order order)//添加订单
{
using (var db = new OrderDB()) {
db.Order.Add(order);
db.SaveChanges();
}
orderDict[order.Id] = order;
return(0);
}
public List <Order> QueryByGoods(String product)
{
using (var db = new OrderDB())
{
var query = db.Order.Include("Items")
.Where(o => o.Items.Where(
item => item.Product.Equals(product)).Count() > 0);
return(query.ToList <Order>());
}
}
public void Delete(String 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();
}
}
//添加订单
public void AddOrder(string num1, string cusName1, string phoneNum1, string goodName1, double price1)
{
OrderDetails A = new OrderDetails(num1, cusName1, phoneNum1, goodName1, price1);
using (var db = new OrderDB())
{
db.OrderDetails.Add(A);
db.SaveChanges();
}
}
public void Add(Order order)
{
using (var db = new OrderDB())
{
db.Order.Add(order);
//db.Order.Attach(order);
//db.Entry(order).State = EntityState.Added;
db.SaveChanges();
}
}
public List <Order> QueryByGoodsName(string goodsName)//根据商品名字查询订单，使用linq语句
{
using (var db = new OrderDB())
{
return(db.Order.Include("Details")
.Where(order => order.Details.Where(d => d.goodsname == goodsName).Count() > 0).ToList <Order>());
}
/* var query = orderDict.Values.Where(order => order.Details.Where(d => d.goodsname == goodsName).Count() > 0);
* return query.ToList();*/
}
public void Update(Order order)
{
using (var db = new OrderDB())
{
db.Order.Attach(order);
db.Entry(order).State = EntityState.Modified;
order.Items.ForEach(
item => db.Entry(item).State = EntityState.Modified);
db.SaveChanges();
}
}
public List <Order> QueryByCustomerName(string customerName)//根据客户名字查询订单，使用linq语句
{
using (var db = new OrderDB())
{
return(db.Order.Include("Details")
.Where(o => o.customername.Equals(customerName)).ToList <Order>());
}
/* var query = orderDict.Values
* .Where(order => order.customername == customerName);
* return query.ToList();*/
}
public int RemoveOrder(int orderId)//删除订单
{
using (var db = new OrderDB())
{
var order = db.Order.Include("Details").SingleOrDefault(o => o.Id == orderId);
db.OrderDetails.RemoveRange(order.Details);
db.Order.Remove(order);
db.SaveChanges();
}
orderDict.Remove(orderId);
return(0);
}
//删除订单
public void DeleteOrder(string num1)
{
using (var db = new OrderDB())
{
var order = db.OrderDetails.SingleOrDefault(o => o.num == num1);
if (order != null)
{
db.OrderDetails.Remove(order);
db.SaveChanges();
}
else
{
Console.WriteLine("订单不存在不能删除");
}
}
}
//修改订单
public void ChangeOrder(string num2, string cusName2, string phoneNum2, string goodName2, double price2, string num1, string cusName1, string phoneNum1, string goodName1, double price1)
{
OrderDetails B = new OrderDetails(num1, cusName1, phoneNum1, goodName1, price1);
using (var db = new OrderDB())
{
var A = db.OrderDetails.SingleOrDefault(o => o.num == num2 && o.goodName == goodName2 && o.cusName == cusName2 && o.price == price2 && o.phoneNum == phoneNum2);
if (A != null)
{
db.OrderDetails.Remove(A);
db.OrderDetails.Add(B);
db.SaveChanges();
}
else
{
Console.WriteLine("订单修改失败");
}
}
}