.net餐厅管理系统数据层餐厅服务类添加删除菜品
SqlDBHelper db = new SqlDBHelper();
#region//添加菜品
///
/// 增加
///
///
///
public Result AddFood(FoodModel foodModel)
{
Result result = new Result();
try
{
string sql = "insert into Food([CategoryID],[FoodName],[FoodPrice],[FoodDes],[FoodImg])" +
"values({0},'{1}',{2},'{3}','{4}')";
sql = string.Format(sql, Convert.ToInt32(foodModel.CategoryId), foodModel.Name, Convert.ToDecimal(foodModel.Price), foodModel.Des, foodModel.Image);
db.ExecuteNonQuery(sql);
result.code = true;
result.Info = "添加成功";
sql = "select FoodID from Food where FoodName='" + foodModel.Name+"'";
result.id = db.GetSingleVal(sql);
}
catch (Exception ex)
{
result.code = false;
result.Info = ex.Message;
}
return result;
}
#endregion
#region//删除菜品
///
/// 删除
///
///
///
public Result DelFood(int foodId)
{
Result result = new Result();
try
{
string sql = "delete from Food Where FoodID=" + foodId;
db.ExecuteNonQuery(sql);
result.code = true;
result.Info = "删除成功";
}
catch (Exception ex)
{
result.code = false;
result.Info = ex.Message;
}
return result;
}
#endregion
SqlDBHelper db = new SqlDBHelper();
#region//添加菜品
///
/// 增加
///
///
///
public Result AddFood(FoodModel foodModel)
{
Result result = new Result();
try
{
string sql = "insert into Food([CategoryID],[FoodName],[FoodPrice],[FoodDes],[FoodImg])" +
"values({0},'{1}',{2},'{3}','{4}')";
sql = string.Format(sql, Convert.ToInt32(foodModel.CategoryId), foodModel.Name, Convert.ToDecimal(foodModel.Price), foodModel.Des, foodModel.Image);
db.ExecuteNonQuery(sql);
result.code = true;
result.Info = "添加成功";
sql = "select FoodID from Food where FoodName='" + foodModel.Name+"'";
result.id = db.GetSingleVal(sql);
}
catch (Exception ex)
{
result.code = false;
result.Info = ex.Message;
}
return result;
}
#endregion
#region//删除菜品
///
/// 删除
///
///
///
public Result DelFood(int foodId)
{
Result result = new Result();
try
{
string sql = "delete from Food Where FoodID=" + foodId;
db.ExecuteNonQuery(sql);
result.code = true;
result.Info = "删除成功";
}
catch (Exception ex)
{
result.code = false;
result.Info = ex.Message;
}
return result;
}
#endregion