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