//将数据行转化为Orderitem实例
public OrderItem_Information DataRowToOrderitem(DataRow dr)
{
OrderItem_Information orderit = new OrderItem_Information();
orderit.order_ID = (int)dr["order_ID"];
orderit.dish_ID = (int)dr["dish_ID"];
orderit.dish_amount = (int)dr["dish_amount"];
orderit.total_pay = (float)Convert.ToDouble(dr["total_pay"]);
return orderit;
}
//根据菜单ID修改菜单项信息函数
public int Update_orderitem(OrderItem_Information orderit, int ID)
{
String sql = "update orderitem_information set dish_ID=@dish_ID,dish_amount=@dish_amount,total_pay=@total_pay where order_ID=@ID";
SqlParameter[] param =
{
new SqlParameter("@dish_ID",SqlDbType.Int),
new SqlParameter("@dish_amount",SqlDbType.Int),
new SqlParameter("@total_pay",SqlDbType.Float),
new SqlParameter("@ID",SqlDbType.Int),
};
param[0].Value = orderit.dish_ID;
param[1].Value = orderit.dish_amount;
param[2].Value = orderit.total_pay;
param[3].Value = ID;
return SqlHelper.ExecuteQuery(sql, param);
}
//加入订单id,菜色id，数量，价格
public int Add_orderitem(OrderItem_Information orderitem)
{
String sql = "insert into orderitem_information values(@order_ID,@dish_ID,@dish_amount,@total_pay)";
SqlParameter[] param =
{
new SqlParameter("@order_ID",SqlDbType.Int),
new SqlParameter("@dish_ID",SqlDbType.Int),
new SqlParameter("@dish_amount",SqlDbType.Int),
new SqlParameter("@total_pay",SqlDbType.Float)
};
param[0].Value = orderitem.order_ID;
param[1].Value = orderitem.dish_ID;
param[2].Value = orderitem.dish_amount;
param[3].Value = orderitem.total_pay;
return SqlHelper.ExecuteQuery(sql, param);
}
public bool Update_orderitem(OrderItem_Information orderit, int ID)
{
return dal.Update_orderitem(orderit, ID) > 0;
}
public bool Add_orderitem(OrderItem_Information orderit)
{
return dal.Add_orderitem(orderit) > 0;
}
//生成订单
public void Made_Order()
{
DataTable dt;
dt = bll.Load_Service_dis(common.rest.ID);
//Order ord = new Order();
common.ord.customer_ID = common.cus.ID;
common.ord.restaurant_ID = common.rest.ID;
common.ord.should_pay = Convert.ToInt32(lab_price.Content);
common.ord.order_privilege = (int)dt.Rows[0]["rest_privilege"];
common.ord.actually_pay = common.ord.should_pay;
common.ord.score_use = 0;
common.ord.order_description = "";
common.ord.order_date = DateTime.Now;
common.ord.order_state = 0;
common.ord.meal_state = 0;
common.ord.order_location = "";
o_dal.Add_order(common.ord);
common.ord = o_dal.select_order_by_restID_and_date(common.ord.restaurant_ID, common.ord.order_date);
OrderItem_Information ordit = new OrderItem_Information();
if (lab_count1.Content.ToString() != ""&&lab_count1.Content.ToString()!="0")
{
ordit.order_ID = common.ord.ID;
ordit.dish_ID = dishes1[0].ID;
ordit.dish_amount = Convert.ToInt32(lab_count1.Content);
ordit.total_pay = ordit.dish_amount * (float)Convert.ToDouble(label1.Content);
oit_dal.Add_orderitem(ordit);
}
if (lab_count2.Content.ToString() != "" && lab_count2.Content.ToString() != "0")
{
ordit.order_ID = common.ord.ID;
ordit.dish_ID = dishes1[1].ID;
ordit.dish_amount = Convert.ToInt32(lab_count2.Content);
ordit.total_pay = ordit.dish_amount * (float)Convert.ToDouble(label2.Content);
oit_dal.Add_orderitem(ordit);
}
if (lab_count3.Content.ToString() != "" && lab_count3.Content.ToString() != "0")
{
ordit.order_ID = common.ord.ID;
ordit.dish_ID = dishes1[2].ID;
ordit.dish_amount = Convert.ToInt32(lab_count3.Content);
ordit.total_pay = ordit.dish_amount * (float)Convert.ToDouble(label13.Content);
oit_dal.Add_orderitem(ordit);
}
if (lab_count4.Content.ToString() != "" && lab_count4.Content.ToString() != "0")
{
ordit.order_ID = common.ord.ID;
ordit.dish_ID = dishes0[0].ID;
ordit.dish_amount = Convert.ToInt32(lab_count4.Content);
ordit.total_pay = ordit.dish_amount * (float)Convert.ToDouble(label20.Content);
oit_dal.Add_orderitem(ordit);
}
if (lab_count5.Content.ToString() != "" && lab_count5.Content.ToString()!= "0")
{
ordit.order_ID = common.ord.ID;
ordit.dish_ID = dishes0[1].ID;
ordit.dish_amount = Convert.ToInt32(lab_count5.Content);
ordit.total_pay = ordit.dish_amount * (float)Convert.ToDouble(label22.Content);
oit_dal.Add_orderitem(ordit);
}
if (lab_count6.Content.ToString() != "" && lab_count6.Content.ToString()!= "0")
{
ordit.order_ID = common.ord.ID;
ordit.dish_ID = dishes0[2].ID;
ordit.dish_amount = Convert.ToInt32(lab_count6.Content);
ordit.total_pay = ordit.dish_amount * (float)Convert.ToDouble(label24.Content);
oit_dal.Add_orderitem(ordit);
}
if (lab_count7.Content.ToString() != "" && lab_count7.Content.ToString()!= "0")
{
ordit.order_ID = common.ord.ID;
ordit.dish_ID = dishes0[3].ID;
ordit.dish_amount = Convert.ToInt32(lab_count7.Content);
ordit.total_pay = ordit.dish_amount * (float)Convert.ToDouble(label24.Content);
oit_dal.Add_orderitem(ordit);
}
if (lab_count8.Content.ToString() != "" && lab_count8.Content.ToString()!= "0")
{
ordit.order_ID = common.ord.ID;
ordit.dish_ID = dishes0[4].ID;
ordit.dish_amount = Convert.ToInt32(lab_count8.Content);
ordit.total_pay = ordit.dish_amount * (float)Convert.ToDouble(label26.Content);
oit_dal.Add_orderitem(ordit);
}
if (lab_count9.Content.ToString() != "" && lab_count9.Content.ToString()!= "0")
{
ordit.order_ID = common.ord.ID;
ordit.dish_ID = dishes0[5].ID;
ordit.dish_amount = Convert.ToInt32(lab_count9.Content);
ordit.total_pay = ordit.dish_amount * (float)Convert.ToDouble(label28.Content);
oit_dal.Add_orderitem(ordit);
}
}