city.asp
来自「适用于网络/信息企业」· ASP 代码 · 共 161 行
ASP
161 行
<!--#include file="../INC/Conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>ELIGHT.CC</title>
</head>
<link href="../WebMaster/Images/Admin.css" rel="stylesheet" type="text/css">
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="middle">
<%
DIM NumberID,NumberIDStr,City
NumberIDStr = Trim(Request.QueryString("NumberID"))
N = Session("Eboer_CRM_City_3")
SQL = "select * from City where LagID = "& Session("Eboer_CRM_City_2") &" and "& Session("Eboer_CRM_SQL_City_") &" order by Cityorder"
set rs=server.createobject("adodb.recordset")
rs.open SQL,conn,1,1
NumberID_1 = left(NumberIDStr,3+N)
if not(rs.bof and rs.eof) then
%>
<select name="City" class="box4" onChange="var jmpURL=this.options[this.selectedIndex].value ; if(jmpURL!='') {window.location=jmpURL;} else {this.selectedIndex=0 ;}" >
<option selected value="City.asp?NumberID=0">请选择……</option>
<%
while not rs.eof
%>
<option value="City.asp?NumberID=<%=rs("NumberID")%>" <%if NumberID_1=rs("NumberID") then%>selected<%end if%>><%=rs("City")%></option>
<%
rs.movenext
wend
%>
</select>
<%
end if
rs.close
set rs=nothing
SQL = "select * from City where PartID='"& NumberID_1 &"' and "& Session("Eboer_CRM_SQL_City_") &" order by Cityorder"
set rs=server.createobject("adodb.recordset")
rs.open SQL,conn,1,1
NumberID_2 = left(NumberIDStr,6+N)
if not(rs.bof and rs.eof) then
%>
<select name="City" class="box4" onChange="var jmpURL=this.options[this.selectedIndex].value ; if(jmpURL!='') {window.location=jmpURL;} else {this.selectedIndex=0 ;}" >
<option selected>请选择……</option>
<%
while not rs.eof
%>
<option value="City.asp?NumberID=<%=rs("NumberID")%>" <%if NumberID_2=rs("NumberID") then%>selected<%end if%>><%=rs("City")%></option>
<%
rs.movenext
wend
%>
</select>
<%
end if
rs.close
set rs=nothing
if len(NumberIDStr)>=6+N then
SQL = "select * from City where PartID='"& NumberID_2 &"' and "& Session("Eboer_CRM_SQL_City_") &" order by Cityorder"
set rs=server.createobject("adodb.recordset")
rs.open SQL,conn,1,1
NumberID_3 = left(NumberIDStr,9+N)
if not(rs.bof and rs.eof) then
%>
<select name="City" class="box4" onChange="var jmpURL=this.options[this.selectedIndex].value ; if(jmpURL!='') {window.location=jmpURL;} else {this.selectedIndex=0 ;}" >
<option selected>请选择……</option>
<%
while not rs.eof
%>
<option value="City.asp?NumberID=<%=rs("NumberID")%>" <%if NumberID_3=rs("NumberID") then%>selected<%end if%>><%=rs("City")%></option>
<%
rs.movenext
wend
%>
</select>
<%
end if
rs.close
set rs=nothing
end if
if len(NumberIDStr)>=9+N then
SQL = "select * from City where PartID='"& NumberID_3 &"' and "& Session("Eboer_CRM_SQL_City_") &" order by Cityorder"
set rs=server.createobject("adodb.recordset")
rs.open SQL,conn,1,1
NumberID_4 = left(NumberIDStr,12+N)
if not(rs.bof and rs.eof) then
%>
<select name="City" class="box4" onChange="var jmpURL=this.options[this.selectedIndex].value ; if(jmpURL!='') {window.location=jmpURL;} else {this.selectedIndex=0 ;}" >
<option selected>请选择……</option>
<%
while not rs.eof
%>
<option value="City.asp?NumberID=<%=rs("NumberID")%>" <%if NumberID_4=rs("NumberID") then%>selected<%end if%>><%=rs("City")%></option>
<%
rs.movenext
wend
%>
</select>
<%
end if
rs.close
set rs=nothing
end if
if len(NumberIDStr)>=12+N then
SQL = "select * from City where PartID='"& NumberID_4 &"' and "& Session("Eboer_CRM_SQL_City_") &" order by Cityorder"
set rs=server.createobject("adodb.recordset")
rs.open SQL,conn,1,1
NumberID_5 = left(NumberIDStr,15+N)
if not(rs.bof and rs.eof) then
%>
<select name="City" class="box4" onChange="var jmpURL=this.options[this.selectedIndex].value ; if(jmpURL!='') {window.location=jmpURL;} else {this.selectedIndex=0 ;}" >
<option selected>请选择……</option>
<%
while not rs.eof
%>
<option value="City.asp?NumberID=<%=rs("NumberID")%>" <%if NumberID_5=rs("NumberID") then%>selected<%end if%>><%=rs("City")%></option>
<%
rs.movenext
wend
%>
</select>
<%
end if
rs.close
set rs=nothing
end if
Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
</table>
<script language="JavaScript">
<!--
if(document.all){
//try{
var id = '<%=NumberIDStr%>';
window.parent.document.form.City.value = id;
//}catch(exception){
// window.parent.document.Userinfo.city.value = "";
//}
}
//-->
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?