/*
* 向数据库中提交用的代码
* 桌子的ID和需要提交的菜单
* */
public static int SubmitOrder(int Tid, List <AddOrderTmp> addOrders)
{
String connectStr = ConnectorInfo.connectStr;
MySqlConnection conn = new MySqlConnection(connectStr);
conn.Open();
//先将数据库已有的此桌子的菜单删除
String sql = "delete from orderinfo where OTableId='" + Tid + "'";
MySqlCommand mySqlCommand = new MySqlCommand(sql, conn);
mySqlCommand.ExecuteNonQuery();
//遍历菜单，逐个插入
foreach (AddOrderTmp addOrder in addOrders)
{
Dish dish = DishInfoConnector.GetDish(addOrder.DTitle);
int count = int.Parse(addOrder.DNumber);
double money = count * Double.Parse(addOrder.DPrice);
sql = "insert into orderinfo(OTableId,ODid,OCount,OMoney) " +
"values(" + Tid + "," + dish.DId + "," + count + "," + money + ")";
mySqlCommand = new MySqlCommand(sql, conn);
try
{
mySqlCommand.ExecuteNonQuery();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
return(-1);
}
}
return(0);
}
/*
* 返回数据库中该餐桌id的已有订单
* 参数为餐桌id
* */
public static List <AddOrderTmp> GetOrdersByTId(int TId)
{
String connectStr = ConnectorInfo.connectStr;
MySqlConnection conn = new MySqlConnection(connectStr);
conn.Open();
List <AddOrderTmp> addOrderTmps = new List <AddOrderTmp>();
String sql = "select * from orderinfo where OTableId=" + TId;
MySqlCommand mySqlCommand = new MySqlCommand(sql, conn);
MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader();
while (mySqlDataReader.Read())
{
Dish dish = DishInfoConnector.GetDish(mySqlDataReader.GetInt32("ODId"));
AddOrderTmp order = new AddOrderTmp(dish.DTitle, dish.DPrice.ToString(), mySqlDataReader.GetInt32("OCount").ToString());
addOrderTmps.Add(order);
}
return(addOrderTmps);
}
