public void addOneOrderDishes(OrderEntity order,int orderId)
{
for(int i=0;i<order.dishList.Count;i++){
string mysql = "insert `yumi_order_detail`(`order_id`,`dish_id`,`dish_count`) values(?orderId,?dishId,?dishCount);";
MySqlParameter[] parameters = {
new MySqlParameter("?orderId", MySqlDbType.UInt32),
new MySqlParameter("?dishId", MySqlDbType.UInt32),
new MySqlParameter("?dishCount", MySqlDbType.UInt32)
};
parameters[0].Value = orderId;
parameters[1].Value = order.dishList[i].id;
parameters[2].Value = order.dishList[i].count;
//通过MySqlCommand的ExecuteReader()方法构造DataReader对象
int count = MySqlHelper.ExecuteNonQuery(mysql, parameters);
}
}
public List<OrderEntity> getAllOrderByRestaurantId(int restaurantId)
{
//string mysql = "SELECT * FROM yumiyumi.yumi_account where user_name ='"+email+"'";
string mysql = "SELECT `order_id`,`user_id`,`restaurant_id`,`remark`,`total_price`,`status`,`start_time` FROM `yumi_order` WHERE `restaurant_id` =?restaurantId Order by start_time desc";
MySqlParameter[] parameters = {
new MySqlParameter("?restaurantId", MySqlDbType.UInt32)
};
parameters[0].Value = restaurantId;
MySqlDataReader myreader = MySqlHelper.ExecuteReader(mysql, parameters);
List<OrderEntity> list = new List<OrderEntity>();
while (myreader.Read())
{
OrderEntity order = new OrderEntity();
order.order_id = myreader.GetInt32(0);
order.user_id = myreader.GetInt32(1);
order.restaurant_id = myreader.GetInt32(2);
order.remark = myreader.GetString(3);
order.total_price = myreader.GetInt32(4);
order.status = myreader.GetInt32(5);
order.start_time = myreader.GetString(6);
list.Add(order);
}
myreader.Close();
for (int i = 0; i < list.Count; i++)
{
OrderEntity order = list[i];
string mysql2 = "SELECT `id`,`order_id`,`dish_id`,`dish_count` FROM `yumi_order_detail` WHERE `order_id` =?orderId;";
MySqlParameter[] parameters2 = {
new MySqlParameter("?orderId", MySqlDbType.UInt32)
};
parameters2[0].Value = order.order_id;
MySqlDataReader myreader2 = MySqlHelper.ExecuteReader(mysql2, parameters2);
while (myreader2.Read())
{
OrderDetailEntity detail = new OrderDetailEntity();
detail.order_id = myreader2.GetInt32(1);
detail.dish_id = myreader2.GetInt32(2);
detail.count = myreader2.GetInt32(3);
order.dishList.Add(detail);
}
myreader2.Close();
}
return list;
}
public bool addOneService(OrderEntity order)
{
string mysql = "insert `yumi_service`(`id`,`user_id`,`restaurant_id`,`service_type`,`ctime`) values(5,1,1,2,'2008-9-4 0:00:00');";
MySqlParameter[] parameters = {
new MySqlParameter("?userId", MySqlDbType.Int32),
new MySqlParameter("?restaurantId", MySqlDbType.Int32),
new MySqlParameter("?remark", MySqlDbType.VarChar,255),
new MySqlParameter("?total", MySqlDbType.Int32),
new MySqlParameter("?status", MySqlDbType.Int32)
};
parameters[0].Value = order.user_id;
parameters[1].Value = order.restaurant_id;
parameters[2].Value = order.remark;
parameters[3].Value = order.total_price;
parameters[4].Value = order.status;
//通过MySqlCommand的ExecuteReader()方法构造DataReader对象
int count = MySqlHelper.ExecuteNonQuery(mysql, parameters);
if (count > 0) { return true; }
else { return false; }
}
public OrderEntity getOneOrderByOrderId(int orderId)
{
string mysql = "SELECT `order_id`,`user_id`,`restaurant_id`,`remark`,`total_price` FROM `yumi_order` WHERE `order_id` =?orderId";
MySqlParameter[] parameters = {
new MySqlParameter("?orderId", MySqlDbType.UInt32)
};
parameters[0].Value = orderId;
MySqlDataReader myreader = MySqlHelper.ExecuteReader(mysql, parameters);
OrderEntity order = new OrderEntity();
while (myreader.Read())
{
order.order_id = myreader.GetInt32(0);
order.user_id = myreader.GetInt32(1);
order.restaurant_id = myreader.GetInt32(2);
order.remark = myreader.GetString(3);
order.total_price = myreader.GetInt32(4);
string mysql2 = "SELECT `id`,`order_id`,`dish_id`,`dish_count`,`dish_status` FROM `yumi_order_detail` WHERE `order_id` =?orderId;";
MySqlParameter[] parameters2 = {
new MySqlParameter("?orderId", MySqlDbType.UInt32)
};
parameters2[0].Value = order.order_id;
MySqlDataReader myreader2 = MySqlHelper.ExecuteReader(mysql2, parameters2);
while (myreader2.Read())
{
OrderDetailEntity detail = new OrderDetailEntity();
detail.id = myreader2.GetInt32(0);
detail.order_id = myreader2.GetInt32(1);
detail.dish_id = myreader2.GetInt32(2);
detail.count = myreader2.GetInt32(3);
detail.status = myreader2.GetInt32(4);
order.dishList.Add(detail);
}
}
return order;
}
