// ****************************************************************** // Filename - admn_bdg.html // Shortname - BL // Purpose - This code edit building 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 ] function BL_Bldg(bldgid,select) { CM_Connect(); write("

大樓資料維護作業

"); write("
"); write("

"); write("
"); write(""); write(""); write(""); write(""); write(""); write(""); write(""); write("
"); write("

"); csBuilding.close(); CM_Disconnect(); } function BL_BldgEdit(bldgid) { formURL=addClient("admn_bdg.html"); if (!bldgid) { AddEdit="新增"; aeText="新增"; aeAction="doDBBldgNew"; aeCancel=""; } else { AddEdit="修改"; aeText="完成"; aeAction="doDBBldgEdit"; aeCancel=""; } write ("

"+AddEdit+" 一棟大樓資訊

"); write ("\n
"); CM_Connect(); if (AddEdit == "修改") { stmt="SELECT * from Building where Building_ID="+bldgid; csBuilding=database.cursor(stmt); if (!csBuilding.next()) { debug ("錯誤 - 再做大樓資訊修改時傳遞了一個錯誤得大樓 ID: "+bldgid); } else { // get default values from database. dfBuildingName=CM_FormEscape(CM_NoneText(csBuilding.Building_Name,"")); dfMapUrl=CM_FormEscape(CM_NoneText(csBuilding.Map_Url,"")); dfImagemapUrl=CM_FormEscape(CM_NoneText(csBuilding.Imagemap_Url,"")); dfBuildingDesc= CM_FormEscape(CM_NoneText(CM_StripSpace(csBuilding.Building_Desc),"")); } csBuilding.close(); } else { // Add dfBuildingName=""; dfMapUrl=""; dfImagemapUrl="http://"; dfBuildingDesc=""; } 大樓名稱

所屬樓面佈置圖之URL(.gif)

大樓概述

CM_Disconnect(); write(aeCancel); write("
"); write(""); write(""); write(""); write("
"); write (""); } function BL_DBBldgEdit(bldgid) { insert=0; if (!bldgid) { bldgid=CM_GetNextPriKey("Building","Building_ID"); insert=1; } CM_Connect(); csEdit=database.cursor("select * from Building WHERE Building_ID="+bldgid, true); csEdit.next(); csEdit.Building_ID=bldgid; csEdit.Map_Url=request.MapUrl; csEdit.Imagemap_Url=request.ImagemapUrl; csEdit.Building_Name=request.BuildingName; csEdit.Building_Desc=CM_StripCR(request.BuildingDesc); if (insert) { csEdit.insertRow("Building"); } else { csEdit.updateRow("Building"); } csEdit.close(); CM_Disconnect(); BL_Bldg(bldgid,true); } function BL_DBBldgDel(bldgid) { CM_Connect(); csDel=database.cursor("Select * from Building where Building_ID="+bldgid, true); csDel.next(); csDel.deleteRow("Building"); // Cascades stmt="update Room set Building_ID=null where Building_ID="+bldgid; database.execute(stmt); stmt="update Address set Building_ID=null where Building_ID="+bldgid; database.execute(stmt); csDel.close(); CM_Disconnect(); BL_Bldg(null,true); } // Handlers // Building if (request.doBldg) { if (request.bldgid) { BL_Bldg(request.bldgid,true); } else { BL_Bldg(null,true); } } else if (request.doBldgEdit) { BL_BldgEdit(request.bldgid); } else if (request.doDBBldgEdit) { BL_DBBldgEdit(request.bldgid); } else if (request.doBldgNew) { BL_BldgEdit(null); } else if (request.doDBBldgNew) { BL_DBBldgEdit(null); } else if (request.doBldgDel) { BL_DBBldgDel(request.bldgid); } else if (request.doDone) { redirect(addClient("admin.html")); } else { // default BL_Bldg(null,true); }