/// <summary>
/// query all orders
/// </summary>
/// <returns>List<Order>:all the orders</returns>
public List <Order> QueryAllOrders()
{
using (var db = new OrderDB())
{
return(db.Order.Include("details").ToList <Order>());
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox5.Text == "")
{
MessageBox.Show("用户名不可为空！", "输入空值错误");
}
else
{
try
{
using (var db = new OrderDB())
{
string num = textBox1.Text;
string mm = Form1.orderService.Find(db, num).CustomerName;
Form1.orderService.Find(db, num).Clear();
Form1.orderService.Find(db, num).CustomerName = textBox5.Text;
Form1.orderService.Find(db, num).OrderDetails.Add(new OrderDetail(textBox2.Text, int.Parse(textBox3.Text), int.Parse(textBox4.Text)));
db.SaveChanges();
}
}
catch (Exception ee)
{
MessageBox.Show(ee.Message, "修改失败");
}
textBox5.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
}
}
/// <summary>
/// query by customerName
/// </summary>
/// <param name="customerName">customer name</param>
/// <returns></returns>
public List <Order> QueryByCustomerName(string customerName)
{
using (var db = new OrderDB())
{
return(db.Order.Include("details")
.Where(o => o.Customer.Name == customerName).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())
{
return(db.Order.Include("details")
.Where(od => od.details.Where(d => d.Goods.Name == goodsName).Count() > 0).ToList <Order>());
}
}
/// <summary>
/// query by orderId
/// </summary>
/// <param name="orderId">id of the order to find</param>
/// <returns>List<Order></returns>
public Order GetById(string orderId)
{
using (var db = new OrderDB())
{
return(db.Order.Include("details").
SingleOrDefault(o => o.Id == orderId));
}
}
/// <summary>
/// add new order
/// </summary>
/// <param name="order">the order will be added</param>
public void AddOrder(Order order)
{
using (var db = new OrderDB())
{
db.Order.Add(order);
db.SaveChanges();
}
}
public List <Order> GetBigger()
{
using (var db = new OrderDB())
{
return(db.Order.Include("details")
.Where(o => o.Money() >= 70).ToList <Order>());
}
}
public void DeleteOrder2(Orders order)
{
using (var db = new OrderDB())
{
db.Details.RemoveRange(order.GetDetails);
db.Order.Remove(order);
db.SaveChanges();
}
}
public void AddOrders2(Orders orders)
{
using (var db = new OrderDB())
{
//将订单添加到List里面
db.Order.Add(orders);
db.SaveChanges();
}
}
//增删订单中商品
//public void ChangeGoods(Orders order, bool isAdd, string name, double price = 0, int number = 0)
//{
// if (isAdd == true)
// {
// if (price > 0 && number > 0)
// {
// order.AddGood(name, price, number);
// Console.WriteLine("增加成功");
// }
// else { Console.WriteLine("输入的单价和数量不可是负数"); }
// }
// else if (isAdd == false)
// {
// order.DelGood(name);
// Console.WriteLine("删除成功");
// }
//}
//删除订单
public void DeleteOrder(string s1, string s2)
{
using (var db = new OrderDB())
{
Orders order = db.Order.Include("GetDetails").SingleOrDefault(o => o.orderNumber == s1 && o.theCustomer == s2);
db.Details.RemoveRange(order.GetDetails);
db.Order.Remove(order);
db.SaveChanges();
}
}
private void button4_Click(object sender, EventArgs e)
{
using (var db = new OrderDB())
{
db.Order.Add(order);
//db.Order.Attach(order);
//db.Entry(order).State = EntityState.Added;
db.SaveChanges();
}
}
/// <summary>
/// cancel order
/// </summary>
/// <param name="orderId">id of the order which will be canceled</param>
public void RemoveOrder(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 AddOrder(string s1, string s2, string s3, List <OrderDetails> details)
{
using (var db = new OrderDB())
{
//将订单添加到List里面
Orders order = new Orders(s1, s2, s3, details);
db.Order.Add(order);
db.SaveChanges();
}
}
//修改订单基本信息
public void ChangeOrder(Orders order)
{
using (var db = new OrderDB())
{
db.Order.Attach(order);
db.Entry(order).State = EntityState.Modified;
order.GetDetails.ForEach(
details => db.Entry(details).State = EntityState.Modified);
db.SaveChanges();
}
}
/// <summary>
/// edit order's customer
/// </summary>
/// <param name="orderId"> id of the order whoes customer will be update</param>
/// <param name="newCustomer">the new customer of the order which will be update</param>
public void UpdateCustomer(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();
}
}
private void button2_Click(object sender, EventArgs e)
{
Order A = new Order("自己改", "自己改");
A.CreateNewEntry("0", 0, 0);
orderBindingSource.Add(A);
OrderDB odb = new OrderDB();
odb.Order.Add(A);
odb.SaveChanges();
}
//添加订单,返回新生成的订单系统
public List <Order> AddOrder(Order order)
{
//Order neworder = new Order(ordernumber, client);
using (var db = new OrderDB())
{
db.Order.Add(order);
db.SaveChanges();
}
orderlist.Add(order);
Console.WriteLine("Add an order " + order.OrderId + " from " + order.CliName);
return(orderlist);
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "" || textBox5.Text == "")
{
MessageBox.Show("用户名或订单号不可为空！", "输入错误");
}
else if ((int.Parse(textBox5.Text)) > 999)
{
MessageBox.Show("订单号只能输入三位流水号！", "输入超长");
}
else
{
try
{
//string s = DateTime.Now.ToString("yyyyMMdd") + (int.Parse(textBox5.Text)).ToString("000");
string s = (int.Parse(textBox5.Text)).ToString("000");
Regex rx = new Regex(s);
using (var db = new OrderDB())
{
foreach (Order t in db.Order)
{
string ss = t.CustomerNum;
Match m = rx.Match(ss);
if (m.Success)
{
MessageBox.Show("已有此订单！", "重复输入");
}
}
}
order.CustomerName = textBox1.Text;
order.CustomerNum = s;
order.OrderDetails.Add(new OrderDetail(textBox2.Text, int.Parse(textBox3.Text), int.Parse(textBox4.Text)));
}
catch
{
MessageBox.Show("订单号格式不正确！", "输入错误");
}
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
//textBox5.Text = "";
textBox5.Text = order.CustomerNum;
}
}
private void button3_Click(object sender, EventArgs e)
{
try
{
using (var db = new OrderDB())
{
string num = textBox1.Text;
Form1.orderService.Find(db, num).OrderDetails.Add(new OrderDetail(textBox2.Text, int.Parse(textBox3.Text), int.Parse(textBox4.Text)));
}
}
catch (Exception ee)
{
MessageBox.Show(ee.Message, "输入错误");
}
textBox5.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
}
//删除订单,返回新生成的订单系统
public List <Order> DeleteOrder(Order order)
{
using (var db = new OrderDB())
{
db.Order.Remove(order);
db.SaveChanges();
}
int num = orderlist.IndexOf(order);
if (num < 0)
{
return(null);
}
else
{
Console.WriteLine("Delete an order " + order.OrderId + " from " + order.OrderId);
orderlist.Remove(order);
}
return(orderlist);
}
//寻找订单
public List <Orders> SearchOrder(string s1)
{
//foreach (Orders order in mOrders)
//{
// //订单中任意一项信息匹配则输出订单信息
// if (order.orderNumber == s1 || order.theCustomer == s1)
// {
// mOrder = order;
// }
//}
//if (mOrder == null)
//{
// Console.WriteLine("未找到该订单信息，请确认输入的信息是否正确");
// return null;
//}
//return mOrder;
//数据库操作
using (var db = new OrderDB())
{
return(db.Order.Include("GetDetails").Where(o => o.orderNumber == s1 || o.theCustomer == s1).ToList <Orders>());
}
}
