// ****************************************************************** // Filename - admn_eq.html // Shortname - EQ // Purpose - This code edits Equipment information // Copyright - (C) 1996, Ingenia Communications Corporation // Authors - Kjell Wooding // - Chris Grant // Contact - kwooding@ingenia.com // ****************************************************************** CM_Authorize(); IF_VerifyRoutines(); empURL=addClient("admn_emp.html"); roomURL=addClient("admn_rm.html"); buildURL=addClient("admn_bdg.html"); invURL=addClient("admn_inv.html"); mapURL=addClient("admn_map.html"); quitURL=addClient("login.html?logout=1"); mainURL=addClient("admin.html"); iMeet 會議室預訂系統 - 會議室資料維護作業 [ Buildings ] [ Employees ] [ Inventory ] [ Rooms ] [ Logout ] [ Main ] // Room function RM_RoomIDtoStr(roomid) { CM_Connect(); tempstr=""; stmt="SELECT * from Outer(Building),Room where Room_ID="+roomid+ " AND Building.Building_ID=Room.Building_ID"; csRoom=database.cursor(stmt); if (!csRoom.next()) { debug("ERROR: RM_RoomIDtoStr passed invalid roomid:"+roomid); } else { tempstr=CM_NoneText(csRoom.Building_Name,"不屬於既有的大樓內")+ ", "+ csRoom.Room_Number; if (csRoom.Floor_Number) { tempstr +=", Floor "+csSelRoom.Floor_Number; } } csRoom.close(); CM_Disconnect(); return(tempstr); } function RM_RoomSelectOpts(roomid,select) { // Roomid - room to select // select - (flag) select first name if roomid is null. 1=yes 0=no CM_Connect(); if (roomid) { // Have a roomid - Put selected entry first stmt="SELECT * from Outer(Building),Room where Room_ID="+roomid+ " AND Building.Building_ID=Room.Building_ID"; csSelRoom=database.cursor(stmt); if (!csSelRoom.next()) { debug("錯誤: RM_Room passed invalid roomid:"+roomid); } else { write("