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> /// 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 void AddOrders2(Orders orders) { using (var db = new OrderDB()) { //将订单添加到List里面 db.Order.Add(orders); db.SaveChanges(); } }
public void DeleteOrder2(Orders order) { using (var db = new OrderDB()) { db.Details.RemoveRange(order.GetDetails); 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 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 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(); } }
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(); }
/// <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(); } }
//添加订单,返回新生成的订单系统 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); }
//删除订单,返回新生成的订单系统 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); }