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 = '0' 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 + -
显示快捷键?