#region//修改菜品
///
/// 修改
///
///
///
public Result UpdFood(FoodModel foodModel)
{
Result result = new Result();
try
{
string sql = "update Food set [CategoryID]={0},[FoodName]='{1}',[FoodPrice]={2},[FoodDes]='{3}',[FoodImg]='{4}'"
+ " where FoodID={5}";
sql = string.Format(sql, Convert.ToInt32(foodModel.CategoryId), foodModel.Name, Convert.ToDecimal(foodModel.Price), foodModel.Des, foodModel.Image, foodModel.Id);
db.ExecuteNonQuery(sql);
result.code = true;
result.Info = "修改成功";
}
catch (Exception ex)
{
result.code = false;
result.Info = ex.Message;
}
return result;
}
#endregion
#region//查询菜品
///
/// 查询
///
///
///
///
public DataTable Search(string info)
{
string sql = "select * from " + info;
DataTable dt = db.GetDataTable(sql);
return dt;
}
#endregion
#region//获得菜品信息
///
/// 获取菜的信息
///
///
///
public DataTable GetFoodInfo(int foodId)
{
string sql = "select * from Food where FoodID=" + foodId;
DataTable dt = db.GetDataTable(sql);
return dt;
}
#endregion