//更新重置食物信息 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); }