private void button1_Click(object sender, EventArgs e) { using (var db = new Orderdb()) { OrderService os = new OrderService(); string a = textBox1.Text; string b = textBox2.Text; string c = textBox3.Text; string d = textBox4.Text; List <OrderService> order = new List <OrderService>(); db.Order.Add(order); db.SaveChanges(); bool bol = os.OrderFoundation(order, a, b, c, d); if (bol == true) { Form4 f = new Form4(); f.ShowDialog(); } else { Form5 ff = new Form5(); ff.ShowDialog(); } } }
private void button3_Click(object sender, EventArgs e) { OrderService os = new OrderService(); OrderDetails p1 = new OrderDetails("1", "饺子", "张三", "10000"); OrderDetails p2 = new OrderDetails("2", "包子", "李四", "20000"); OrderDetails p3 = new OrderDetails("3", "馒头", "王五", "1000"); List <OrderService> order = new List <OrderService>(); order.Add(p1); order.Add(p2); order.Add(p3); using (var db = new Orderdb()) { db.Order.Add(order); db.SaveChanges(); } using (var context = new Orderdb()) { string a = richTextBox2.Text; bool bol = os.Orderdelete(order, a); if (bol == true) { Form4 f = new Form4(); f.ShowDialog(); } else { Form5 ff = new Form5(); ff.ShowDialog(); } } }
private void button1_Click(object sender, EventArgs e) { OrderService os = new OrderService(); string a = textBox1.Text; string b = textBox2.Text; string c = textBox3.Text; string d = textBox4.Text; OrderDetails p1 = new OrderDetails("1", "饺子", "张三", "10000"); OrderDetails p2 = new OrderDetails("2", "包子", "李四", "20000"); OrderDetails p3 = new OrderDetails("3", "馒头", "王五", "1000"); List <OrderService> order = new List <OrderService>(); order.Add(p1); order.Add(p2); order.Add(p3); using (var db = new Orderdb()) { db.Order.Add(order); db.SaveChanges(); bool bol = os.OrderRenew(p2, a, b, c, d); if (bol == true) { Form4 f = new Form4(); f.ShowDialog(); } else { Form5 ff = new Form5(); ff.ShowDialog(); } } }
private void button4_Click(object sender, EventArgs e) { using (var db = new Orderdb()) { string a = textBox1.Text; OrderDetails p1 = new OrderDetails("1", "饺子", "张三", "10000"); OrderDetails p2 = new OrderDetails("2", "包子", "李四", "20000"); OrderDetails p3 = new OrderDetails("3", "馒头", "王五", "1000"); List <OrderService> order = new List <OrderService>(); order.Add(p1); order.Add(p2); order.Add(p3); db.Order.Add(order); var n = from OrderDetails god in order where god.ordernum == a select god; foreach (var m in n) { richTextBox1.Text = "订单号是:" + m.ordernum + " " + "货物名称是:" + m.goodname + " " + "客人名字是:" + m.customername + " " + "商品价格是:" + m.ordervalue; } /*主键查询的例子 * OrderDetails user = new OrderDetails(); * user = db.Order.Find(1); * ObjectDumper.Write(user); * */ } /* if (p1.ordernum == a) * { * richTextBox1.Text = "订单号是:" + p1.ordernum + " " + "货物名称是:" + p1.goodname + " " + "客人名字是:" + p1.customername + " " + "商品价格是:" + p1.ordervalue; * } * else * { * if (p2.ordernum == a) * { * richTextBox1.Text = "订单号是:" + p2.ordernum + " " + "货物名称是:" + p2.goodname + " " + "客人名字是:" + p2.customername +" "+"商品价格是:" + p2.ordervalue; * } * else * { * if (p3.ordernum == a) * { * richTextBox1.Text = "订单号是:" + p3.ordernum + " " + "货物名称是:" + p3.goodname + " " + "客人名字是:" + p3.customername + " " + "商品价格是:" + p3.ordervalue; * } * else { * richTextBox1.Text = "很遗憾,没有你的订单"; * } * } * } * */ }
public Orderdb CreateOrderdb(Orderdb orderdb) { try { if (!ModelState.IsValid) { throw new HttpResponseException(HttpStatusCode.BadRequest); } db.Orderdbs.Add(orderdb); db.SaveChanges(); return(orderdb); } catch (Exception ex) { throw new HttpResponseException(HttpStatusCode.BadRequest); } }
public void UpdateOrderdb(int id, Orderdb orderdb) { if (!ModelState.IsValid) { throw new HttpResponseException(HttpStatusCode.BadRequest); } var orderss = db.Orderdbs.SingleOrDefault(x => x.Id == id); if (orderss == null) { throw new HttpResponseException(HttpStatusCode.NotFound); } orderdb.OrderNo = orderss.OrderNo; orderdb.TotalPrice = orderss.TotalPrice; orderdb.TotalQuantity = orderss.TotalQuantity; orderdb.OrderDate = orderss.OrderDate; db.SaveChanges(); }
public bool SaveOrder(OrderInfo oOrd) { Orderdb oDb = new Orderdb(); return(oDb.SaveOrder(oOrd)); }
public DataSet GetOrder() { Orderdb oDb = new Orderdb(); return(oDb.GetOrder()); }