//添加客房类型
public bool addRoomType(roomType t /*客房类型对象*/)
{
string sql = "insert into RoomType values('" + t.Tid + "','" + t.Ttype + "'," + t.TbedNum + ",'" + t.TairConditioning
+ "','" + t.Ttelevision + "','" + t.ThairDrier + "','" + t.Tlandline + "','" + t.Twifi + "','" + t.Tremark + "')";
int num = DatabaseLink.UpdateData(sql);
if (num > 0)
{
return(true);
}
else
{
return(false);
}
}
//修改客房类型信息
public bool updateRoomType(roomType t, string id /*客房类型编号*/)
{
string sql = "update RoomType set Ttype='" + t.Ttype + "',TbedNum=" + t.TbedNum + ",TairConditioning='" + t.TairConditioning
+ "',Ttelevision='" + t.Ttelevision + "',ThairDrier='" + t.ThairDrier + "',Tlandline='" + t.Tlandline + "',Twifi='" + t.Twifi
+ "',Tremark='" + t.Tremark + "' where Tid='" + id + "'";
int num = DatabaseLink.UpdateData(sql);
if (num > 0)
{
return(true);
}
else
{
return(false);
}
}
