/// <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>()); } }