//更新服务生信息
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);
}
