//更新服务生信息 public void update(Model.waiter my) { String sql = "update waiter set waitername=@waitername,sex=@sex,age=@age,idcard=@idcard,tel=@tel,id=@id where id=@id"; List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@waitername", my.Waitername)); sqlParams.Add(new SqlParameter("@age", my.Age)); sqlParams.Add(new SqlParameter("@idcard", my.Idcard)); sqlParams.Add(new SqlParameter("@tel", my.Tel)); sqlParams.Add(new SqlParameter("@sex", my.Sex)); sqlParams.Add(new SqlParameter("@id", my.Id)); co.ExecuteSql(sql, sqlParams); }
//插入服务生信息 public void insert(Model.waiter my) { String sql = "insert into waiter(id,waitername,idcard,sex,age,tel)values(@id,@waitername,@idcard,@sex,@age,@tel)"; List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@id", my.Id)); sqlParams.Add(new SqlParameter("@waitername", my.Waitername)); sqlParams.Add(new SqlParameter("@idcard", my.Idcard)); sqlParams.Add(new SqlParameter("@sex", my.Sex)); sqlParams.Add(new SqlParameter("@age", my.Age)); sqlParams.Add(new SqlParameter("@tel", my.Tel)); co.ExecuteSql(sql, sqlParams); }
public void update(Model.waiter myu) { ro.update(myu); }
public void insert(Model.waiter myu) { ro.insert(myu); }