28,406
社区成员
发帖
与我相关
我的任务
分享
<%
......
SmallClassList = SmallClassList & "<option value='"&rsCl("id")&"' if '"&rscl("id")&"'='"&rs("bigtype")&"' then "&selected&" end if>"&rsCl("smallgroupname")&"</option>"
......
%>
<%
Dim SubClsCount, rsCl
Set rsCl = Server.Createobject("Adodb.Recordset")
rsCl.Open "Select * From [smallgroup] Order By id",Conn,1,1
%>
<script language = "JavaScript">
var TCount = 0;
subCls = new Array();
<%
SubClsCount = 0
Do While Not rsCl.Eof
%>
subCls[<%=SubClsCount%>] = new Array("<%=Trim(rsCl("id"))%>","<%=rsCl("biggroupid")%>","<%=Trim(rsCl("smallgroupname"))%>");
<%
SubClsCount = SubClsCount + 1
rsCl.Movenext
Loop
rsCl.Close
Set rsCl = Nothing
%>
TCount=<%=SubClsCount%>;
function changelocation(locationid)
{
document.getElementById("SmallClassID").length = 0;
var locationid = locationid;
var i;
for (i=0;i < TCount; i++)
{
if (subCls[i][1] == locationid)
{
document.getElementById("SmallClassID").options[document.getElementById("SmallClassID").length] = new Option(subCls[i][2], subCls[i][0]);
}
}
if (document.getElementById("SmallClassID").options.length <= 0)
{
document.getElementById("SmallClassID").options[document.getElementById("SmallClassID").length] = new Option("暂无小类", 0);
}
}
</script>
<%
Dim SelClassID
Set rsCl = Server.Createobject("Adodb.Recordset")
'if rs("bigtype") <> "" then
'rsCl.Open "Select * From [biggroup] where id="&rs("bigtype")&" Order By id",Conn,1,1
'else
rsCl.Open "Select * From [biggroup] Order By id",Conn,1,1
'end if
If rsCl.Eof And rsCl.Bof Then
Response.Write "请添加顶级(大)类别!"
'Response.End()
Else
%>
<select style="width:110px;height:16px;border:#7e9eb7 solid 1px" name="BigClassID" size="1" id="BigClassID" onChange="changelocation(document.getElementById('BigClassID').options[document.getElementById('BigClassID').selectedIndex].value)">
<%
SelClassID = rsCl("id")
Do While Not rsCl.Eof
%>
<option value="<%=rsCl("id")%>" <%if rscl("id")=rs("bigtype") then%>selected<%end if%>><%=rsCl("biggroupname")%></option>
<%
rsCl.Movenext
Loop
%>
</select>
<%
End If
rsCl.Close
%> <%
Dim SmallClassList
Set rsCl4 = Server.Createobject("Adodb.Recordset")
rsCl4.Open "Select * From [biggroup] Order By id desc",Conn,1,1 '大类
If rsCl4.Eof And rsCl4.Bof Then
response.Write("暂无分类")
else
SmallClassList = "<select name=SmallClassID id=SmallClassID style=width:170px;height:16px;border:#7e9eb7 solid 1px>"
'if rs("smalltype") <> "" then
'rsCl.Open "Select * From [smallgroup] Where biggroupid = "&SelClassID&" and id="&rs("smalltype")&" Order By id desc" ,Conn,1,1 '小类
'else
rsCl.Open "Select * From [smallgroup] Where biggroupid = "&SelClassID&" Order By id desc" ,Conn,1,1 '小类
'end if
If Not (rsCl.Eof And rsCl.Bof) Then
Do While Not rsCl.Eof
SmallClassList = SmallClassList & "<option value='" & rsCl("id") & "'"
if rscl("id") = rs("bigtype") then
SmallClassList = SmallClassList & " selected"
end if
SmallClassList = SmallClassList & ">" & rsCl("smallgroupname") & "</option>"
rsCl.Movenext
Loop
Else
SmallClassList = SmallClassList & "<option value='0'>暂无小类</option>"
End If
rsCl.Close
Set rsCl = Nothing
SmallClassList = SmallClassList & "</select>"
Response.Write(SmallClassList)
end if
rscl4.close
set rscl4=nothing
%>
<%
SmallClassList = SmallClassList & " <option value='" & rsCl("id") & "'"
if rscl("id") = rs("bigtype").value then
SmallClassList = SmallClassList & " selected"
end if
SmallClassList = SmallClassList & ">" & rsCl("smallgroupname") & " </option>"
%>
<%
SmallClassList = SmallClassList & "<option value='" & rsCl("id") & "'"
if rscl("id").value = rs("bigtype").value then
SmallClassList = SmallClassList & " selected"
end if
SmallClassList = SmallClassList & ">" & rsCl("smallgroupname") & "</option>"
%>