//添加客房类型 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); } }