📄 room_test.asp
字号:
<!-- #include file="../include/common.inc" -->
<%
dim conn : set conn = DBConnection
dim roomOptions, floorOptions
'' 缺省选中的值，要根据实际情况修改
'' 这个值只有两种情况：
'' 一是新增，新增的话，机房编号和楼层都没有，
'' 二是修改，修改的话，机房编号是从数据库中读出来的，楼层编号可以从机房编号中获取（机房编号的前二位）
dim pRoomNo, pFloor
pRoomNo = "B2EEKT02"
if IsEmpty(pRoomNo) then
pRoomNo = ""
pFloor = ""
else
pFloor = left(pRoomNo, 2)
end if
'' ******************************************************************
'' 构造楼层编号选项和机房编号选项
'' ---------------------------------------------------------------------------------------------------------
floorOptions = SelectOptions(conn, "select distinct floor from t_room order by floor", "floor", "floor", pFloor)
roomOptions = SelectOptions(conn, "select room_no from t_room order by room_no", "room_no", "room_no", pRoomNo)
%>
<html>
<head>
<title>上海信息大楼 Shanghai Information Tower</title>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<link rel="stylesheet" href="../include/common.css" type="text/css">
<script language="javascript">
function OnFloorChange()
{
var sFloor, sRoomNo;
var objFloor, objRoom;
// 楼层和机房编码 <select> 对象
objFloor = document.all.floor; // 楼层
objRoom = document.all.room_no; // 机房选项对象
// 选中的楼层
sFloor = objFloor.options[objFloor.selectedIndex].value;
// 清空机房编号选项，然后从备选机房编号列表中逐个检查是否和楼层编码一致，如果一致，则放入选项列表
objRoom.innerHTML = "";
for (var j=0; j < document.all.roomlist.options.length; j++)
{
// 机房编号
sRoomNo = document.all.roomlist.options[j].value;
// 如果机房编号和楼层编号一致，则放到创建一个<option>选项
if (sRoomNo.substr(0,2) == sFloor)
objRoom.options[objRoom.options.length] = new Option(sRoomNo, sRoomNo, 0, 0)
}
}
</script>
</head>
<body>
<table border=0 width=400 align=center>
<tr>
<td>
楼层：<select id="floor" name="floor" style="width:86px" onchange="javascript:OnFloorChange();"><%=floorOptions%></select>
</td>
<td>
机房编号：<select id="room_no" name="room_no" style="width:86px"><%=roomOptions%>
</select>
<select id="roomlist" style="display:none"><%=roomOptions%></select>
</td>
</tr>
</table>
<script language="javascript">
// 在页面下载结束之前设置缺省选中的值
if ("<%=pFloor%>" == "")
document.all.floor.selectedIndex = 0; // 如果是新增，则选中第一个楼层
else
document.all.floor.value = "<%=pFloor%>"; // 如果是修改，则选中相应的楼层值
OnFloorChange();
if ("<%=pRoomNo%>" != "")
document.all.room_no.value = "<%=pRoomNo%>"; // 机房编号则选中相应的值
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -