//修改酒店客房信息 public bool updateHotelRoomInfo(hotelRoom hr, string id /*酒店客房编号*/) { string sql = "update HotelRoomInfo set RhotelId='" + hr.Hid + "',RtypeId='" + hr.Tid + "',Rnumber=" + hr.Rnumber + ",Rprice=" + hr.Rprice + ",Rremark='" + hr.Rremark + "',RvacantNum=" + hr.RvacantNum + ",RimageUrl='" + hr.RimageUrl + "' where Rid='" + id + "'"; int num = DatabaseLink.UpdateData(sql); if (num > 0) { return(true); } else { return(false); } }
//添加酒店客房信息 public bool addHotelRoomInfo(hotelRoom hr /*酒店客房信息对象*/) { string sql = "insert into HotelRoomInfo values('" + hr.Rid + "','" + hr.Hid + "','" + hr.Tid + "'," + hr.Rnumber + "," + hr.Rprice + ",'" + hr.Rremark + "'," + hr.RvacantNum + ",'" + hr.RimageUrl + "')"; int num = DatabaseLink.UpdateData(sql); if (num > 0) { return(true); } else { return(false); } }