public Form3() { InitializeComponent(); priceList["Milk"] = 69.9; priceList["eggs"] = 4.99; priceList["apple"] = 5.99; priceList["banana"] = 10; priceList["orange"] = 12; priceList["cookie"] = 15; order = new ordertest.Order(); detailsBindingSource.DataSource = null; }
private void savebutton_Click(object sender, EventArgs e) { //Console.WriteLine(this.id, this.customer_name, this.customer_id); int id_int = Convert.ToInt32(id); ordertest.Customer c = new ordertest.Customer(Convert.ToUInt32(customer_id), customer_name); ordertest.Goods goods = new ordertest.Goods(Convert.ToInt32(goods_id), goods_name, Convert.ToDouble(price)); ordertest.OrderDetail de = new ordertest.OrderDetail(goods, Convert.ToUInt32(amount)); if (op == 1) { if (service.GetById(id_int) == null) { ordertest.Order o = new ordertest.Order(id_int, c); service.AddOrder(o); o.AddDetails(de); } else { service.GetById(id_int).AddDetails(de); } } else if (op == 2) { ordertest.Order o = service.GetById(id_int); var d = o.Details; foreach (var i in d) { if (i.Goods.Id == Convert.ToInt32(goods_id)) { i.Amount = Convert.ToUInt32(amount); i.Goods.Price = Convert.ToDouble(price); } } } else if (op == 3) { if (service.GetById(id_int) == null) { throw new Exception("无此账单"); } else { service.RemoveOrder(id_int); } } MessageBox.Show("信息改变已保存"); this.Close(); }
private void savebutton_Click(object sender, EventArgs e) { //Console.WriteLine(this.id, this.customer_name, this.customer_id); int id_int = Convert.ToInt32(id); ordertest.Customer c = new ordertest.Customer(Convert.ToInt32(customer_id), customer_name); ordertest.Goods goods = new ordertest.Goods(Convert.ToInt32(goods_id), goods_name, Convert.ToDouble(price)); ordertest.OrderDetail de = new ordertest.OrderDetail(goods, Convert.ToInt32(amount), Convert.ToInt32(detail_id)); if (op == 1) { using (var db = new OrderContext()) { var r = db.orders.Where(o => o.OrderId == id_int); if (r.Count() != 0) { ordertest.OrderDetail ds = new ordertest.OrderDetail() { Goods = goods, Amount = Convert.ToInt32(amount), DetailId = Convert.ToInt32(detail_id), }; db.Entry(ds).State = EntityState.Added; db.SaveChanges(); } else { ordertest.Order o = new ordertest.Order(id_int, c); ordertest.OrderDetail ds = new ordertest.OrderDetail() { Goods = goods, Amount = Convert.ToInt32(amount), DetailId = Convert.ToInt32(detail_id), }; o.Details = new List <ordertest.OrderDetail>(); o.Details.Add(ds); db.orders.Add(o); db.SaveChanges(); } } } else if (op == 2) { using (var db = new OrderContext()) { var d = new ordertest.OrderDetail() { DetailId = de.DetailId, OrderID = de.OrderID }; db.Entry(d).State = EntityState.Modified; d = de; db.SaveChanges(); } } else if (op == 3) { using (var db = new OrderContext()) { var r = db.orders.FirstOrDefault(o => o.OrderId == id_int); var r_de = db.details.FirstOrDefault(d => d.DetailId == de.DetailId); if (r != null && r_de != null) { db.details.Remove(r_de); db.SaveChanges(); } else { MessageBox.Show("无此订单"); } } } MessageBox.Show("信息改变已保存"); this.Close(); }