asp三级分类-联动下拉菜单
来源:互联网 发布:python网络爬虫源代码 编辑:程序博客网 时间:2024/05/17 01:09
<%
dim rs,firstFlag
set rs=server.CreateObject("adodb.recordset")
'读主分类
sqlstr = "select product_type1_id,product_type1 from t_product_type1 where isDel=0 and me_ver='" & G_mver & "' order by sort"
rs.Open sqlstr,conn,1,1
response.Write "<script language='javascript'>"
response.Write "optType1=new Array("
firstFlag = true
do while not rs.EOF
if firstFlag then
response.Write "'" & rs("product_type1_id") & "','" & rs("product_type1") & "'"
firstFlag = false
else
response.Write ",'" & rs("product_type1_id") & "','" & rs("product_type1") & "'"
end if
rs.MoveNext()
loop
response.Write ");"
response.Write "</script>"
rs.Close()
'读二级分类
sqlstr = "select product_type1_id,product_type2_id,product_type2 from t_product_type2 where me_ver='"& G_mver &"' order by product_type1_id,sort"
rs.Open sqlstr,conn,1,1
response.Write "<script language='javascript'>"
response.Write "optType2=new Array("
firstFlag = true
do while not rs.EOF
if firstFlag then
response.Write "'" & rs("product_type1_id") & "_" & rs("product_type2_id") & "','" & rs("product_type2") & "'"
firstFlag = false
else
response.Write ",'" & rs("product_type1_id") & "_" & rs("product_type2_id") & "','" & rs("product_type2") & "'"
end if
rs.MoveNext()
loop
response.Write ");"
response.Write "</script>"
rs.Close()
'读三级分类
sqlstr = "select product_type1_id,product_type2_id,product_type3_id,product_type3 from t_product_type3 where me_ver='"& G_mver &"' order by product_type1_id,product_type2_id,sort"
rs.Open sqlstr,conn,1,1
response.Write "<script language='javascript'>"
response.Write "optType3=new Array("
firstFlag = true
do while not rs.EOF
if firstFlag then
response.Write "'" & rs("product_type1_id") & "_" & rs("product_type2_id") & "|" & rs("product_type3_id") & "','" & rs("product_type3") & "'"
firstFlag = false
else
response.Write ",'" & rs("product_type1_id") & "_" & rs("product_type2_id") & "|" & rs("product_type3_id") & "','" & rs("product_type3") & "'"
end if
rs.MoveNext()
loop
response.Write ");"
response.Write "</script>"
rs.Close()
set rs=nothing
%>
<script language="javascript">
function chang_product_type(){
location.href="product_list.asp?type1_id="+document.frm_search.product_type1_id.options[document.frm_search.product_type1_id.selectedIndex].value;
}
</script>
主类别:
<select name="type1_id" onChange="changeType1(this, frm_search.product_type2_id)" style="WIDTH: 90px; COLOR: navy; font-size:9pt"
ID="product_type1_id">
<option value="0">所有主类别</option>
<script language="javascript">
showOptions(optType1);
</script>
</select>
<select name="type2_id" onChange="changeType2(this, frm_search.product_type3_id)" style="WIDTH: 100px; COLOR: navy; font-size:9pt"
ID="product_type2_id">
<option value="0_0">所有二级类别</option>
</select>
<select name="type3_id" style="WIDTH: 100px; COLOR: navy; font-size:9pt" ID="product_type3_id">
<option value="0_0_0">所有三级类别</option>
</select>
<script language="javascript">
<!--
//初始载入时确定所选项
if(!frm_search.product_type1_id[0].selected)
changeType1(frm_search.product_type1_id,frm_search.product_type2_id);
if(!frm_search.product_type2_id[0].selected)
changeType2(frm_search.product_type2_id,frm_search.product_type3_id);
//显示所选项
//主分类
var len=frm_search.product_type1_id.length;
var s1=frm_search.product_type1_id;
for(i=0;i<len;i++)
{
if(s1.options[i].value=='<%=request.Form("type1_id")%>')
{
s1.selectedIndex=i;
}
}
changeType1(frm_search.product_type1_id,frm_search.product_type2_id);
//二级分类
len=frm_search.product_type2_id.length;
var s2=frm_search.product_type2_id;
for(i=0;i<len;i++)
{
if(s2.options[i].value=='<%=request.Form("type2_id")%>')
{
s2.selectedIndex=i;
}
}
changeType2(frm_search.product_type2_id,frm_search.product_type3_id);
//三级分类
len=frm_search.product_type3_id.length;
var s3=frm_search.product_type3_id;
for(i=0;i<len;i++)
{
if(s3.options[i].value=='<%=request.Form("type3_id")%>')
{
s3.selectedIndex=i;
}
}
//-->
</script>
dim rs,firstFlag
set rs=server.CreateObject("adodb.recordset")
'读主分类
sqlstr = "select product_type1_id,product_type1 from t_product_type1 where isDel=0 and me_ver='" & G_mver & "' order by sort"
rs.Open sqlstr,conn,1,1
response.Write "<script language='javascript'>"
response.Write "optType1=new Array("
firstFlag = true
do while not rs.EOF
if firstFlag then
response.Write "'" & rs("product_type1_id") & "','" & rs("product_type1") & "'"
firstFlag = false
else
response.Write ",'" & rs("product_type1_id") & "','" & rs("product_type1") & "'"
end if
rs.MoveNext()
loop
response.Write ");"
response.Write "</script>"
rs.Close()
'读二级分类
sqlstr = "select product_type1_id,product_type2_id,product_type2 from t_product_type2 where me_ver='"& G_mver &"' order by product_type1_id,sort"
rs.Open sqlstr,conn,1,1
response.Write "<script language='javascript'>"
response.Write "optType2=new Array("
firstFlag = true
do while not rs.EOF
if firstFlag then
response.Write "'" & rs("product_type1_id") & "_" & rs("product_type2_id") & "','" & rs("product_type2") & "'"
firstFlag = false
else
response.Write ",'" & rs("product_type1_id") & "_" & rs("product_type2_id") & "','" & rs("product_type2") & "'"
end if
rs.MoveNext()
loop
response.Write ");"
response.Write "</script>"
rs.Close()
'读三级分类
sqlstr = "select product_type1_id,product_type2_id,product_type3_id,product_type3 from t_product_type3 where me_ver='"& G_mver &"' order by product_type1_id,product_type2_id,sort"
rs.Open sqlstr,conn,1,1
response.Write "<script language='javascript'>"
response.Write "optType3=new Array("
firstFlag = true
do while not rs.EOF
if firstFlag then
response.Write "'" & rs("product_type1_id") & "_" & rs("product_type2_id") & "|" & rs("product_type3_id") & "','" & rs("product_type3") & "'"
firstFlag = false
else
response.Write ",'" & rs("product_type1_id") & "_" & rs("product_type2_id") & "|" & rs("product_type3_id") & "','" & rs("product_type3") & "'"
end if
rs.MoveNext()
loop
response.Write ");"
response.Write "</script>"
rs.Close()
set rs=nothing
%>
<script language="javascript">
function chang_product_type(){
location.href="product_list.asp?type1_id="+document.frm_search.product_type1_id.options[document.frm_search.product_type1_id.selectedIndex].value;
}
</script>
主类别:
<select name="type1_id" onChange="changeType1(this, frm_search.product_type2_id)" style="WIDTH: 90px; COLOR: navy; font-size:9pt"
ID="product_type1_id">
<option value="0">所有主类别</option>
<script language="javascript">
showOptions(optType1);
</script>
</select>
<select name="type2_id" onChange="changeType2(this, frm_search.product_type3_id)" style="WIDTH: 100px; COLOR: navy; font-size:9pt"
ID="product_type2_id">
<option value="0_0">所有二级类别</option>
</select>
<select name="type3_id" style="WIDTH: 100px; COLOR: navy; font-size:9pt" ID="product_type3_id">
<option value="0_0_0">所有三级类别</option>
</select>
<script language="javascript">
<!--
//初始载入时确定所选项
if(!frm_search.product_type1_id[0].selected)
changeType1(frm_search.product_type1_id,frm_search.product_type2_id);
if(!frm_search.product_type2_id[0].selected)
changeType2(frm_search.product_type2_id,frm_search.product_type3_id);
//显示所选项
//主分类
var len=frm_search.product_type1_id.length;
var s1=frm_search.product_type1_id;
for(i=0;i<len;i++)
{
if(s1.options[i].value=='<%=request.Form("type1_id")%>')
{
s1.selectedIndex=i;
}
}
changeType1(frm_search.product_type1_id,frm_search.product_type2_id);
//二级分类
len=frm_search.product_type2_id.length;
var s2=frm_search.product_type2_id;
for(i=0;i<len;i++)
{
if(s2.options[i].value=='<%=request.Form("type2_id")%>')
{
s2.selectedIndex=i;
}
}
changeType2(frm_search.product_type2_id,frm_search.product_type3_id);
//三级分类
len=frm_search.product_type3_id.length;
var s3=frm_search.product_type3_id;
for(i=0;i<len;i++)
{
if(s3.options[i].value=='<%=request.Form("type3_id")%>')
{
s3.selectedIndex=i;
}
}
//-->
</script>
- asp三级分类-联动下拉菜单
- ASP的三级联动下拉菜单
- asp.net DropDownList 三级联动下拉菜单
- ASP+JS三级联动下拉菜单
- 三级联动下拉菜单
- ASP+JS三级联动下拉菜单[调用数据库数据]
- ASP+JS三级联动下拉菜单[调用数据库数据]
- Asp三级联动下拉菜单数据库调用版
- asp.net DropDownList 三级联动下拉菜单实现代码
- ASP+JS三级联动下拉菜单[调用数据库数据]
- ASP+JS三级联动下拉菜单 调用数据…
- android下拉菜单三级联动
- 三级联动下拉菜单[调用数据库数据]
- 严格的三级联动日期下拉菜单
- 中国地区三级联动下拉菜单
- js实现年月日三级下拉菜单联动
- Thinkphp dwz 三级联动下拉菜单
- Thinkphp dwz 三级联动下拉菜单
- FFmpeg Mencoder FLV 3GP FLVmdi Avisynth 加水印参数
- 揭开SVCHOST.exe进程之谜
- .net编程创建 Access 文件和 Excel 文件
- Bles for the future
- java set system time
- asp三级分类-联动下拉菜单
- SOA
- ASP.NET在MOSS中与Webpart数据库的访问参数设置。
- 高手 全面认识Svchost.exe进程
- Asp.net源码程序分析所感——印度,一个不可轻视的近邻!
- FFmpeg 参数说明
- 索引的使用说明
- 转义字符跟变量的一些事
- 实战DeviceIoControl:通过API访问设备驱动程序