//更新重置食物信息
public void update(Model.food my)
{
String sql = "update food set foodname=@foodname,foodnum=@foodnum,foodtype=@foodtype,foodprice=@foodprice Where foodname=@foodname ";
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@foodname", my.Foodname));
sqlParams.Add(new SqlParameter("@foodtype", my.Foodtype));
sqlParams.Add(new SqlParameter("@foodnum", my.Foodnum));
sqlParams.Add(new SqlParameter("@foodprice", my.Foodprice));
co.ExecuteSql(sql, sqlParams);
}
//插入食物信息
public void insert(Model.food my)
{
string sql = "insert into food(id,foodname,foodnum,foodtype,foodprice)values(@id,@foodname,@foodnum,@foodtype,@foodprice)";
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@id", my.Id));
sqlParams.Add(new SqlParameter("@foodname", my.Foodname));
sqlParams.Add(new SqlParameter("@foodnum", my.Foodnum));
sqlParams.Add(new SqlParameter("@foodtype", my.Foodtype));
sqlParams.Add(new SqlParameter("@foodprice", my.Foodprice));
co.ExecuteSql(sql, sqlParams);
}
public void update(Model.food myu)
{
my.update(myu);
}
public void insert(Model.food myu)
{
my.insert(myu);
}
