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