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