//更新房间信息
public void update(Model.room my)
{
string sql = "update room set roomabb=@roomabb,roomfee=@roomfee,roomlocation=@roomlocation Where roomname=@roomname ";
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@roomname", my.Roomname));
sqlParams.Add(new SqlParameter("@roomabb", my.Roomabb));
sqlParams.Add(new SqlParameter("@roomfee", my.Roomfee));
sqlParams.Add(new SqlParameter("@roomlocation", my.Roomlocation));
co.ExecuteSql(sql, sqlParams);
}
//插入房间信息
public void insert(Model.room my)
{
string sql = "insert into room(id,roomname,roomabb,roomfee,roomwz)values(@id,@roomname,@roomabb,@roomfee,@roomlocation)";
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@id", my.Id));
sqlParams.Add(new SqlParameter("@roomname", my.Roomname));
sqlParams.Add(new SqlParameter("@roomabb", my.Roomabb));
sqlParams.Add(new SqlParameter("@roomfee", my.Roomfee));
sqlParams.Add(new SqlParameter("@roomlocation", my.Roomlocation));
co.ExecuteSql(sql, sqlParams);
}
public void update(Model.room myu)
{
ro.update(myu);
}
public void insert(Model.room myu)
{
ro.insert(myu);
}
