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