⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 bigclass.asp

📁 一套设计精美的学校网站全站系统
💻 ASP
📖 第 1 页 / 共 3 页
字号:
<%@ Language=VBScript%>

<!--#include file=include/conn.asp -->
<!--#include file=include/function.asp -->
<!--#include file=include/config.asp -->
<!--#include file="admin/char.inc"-->
<%
function nohtml(str)
    dim re
    Set re=new RegExp
    re.IgnoreCase =true
    re.Global=True
    re.Pattern="(\<.[^\<]*\>)"
    str=re.replace(str," ")
    re.Pattern="(\<\/[^\<]*\>)"
    str=re.replace(str," ")
    nohtml=str
    set re=nothing
end function
%>
<%
typeid=checkstr(request("typeid"))
request_BigClassID=Request.QueryString("BigClassID")
if typeid="" or request_bigclassid="" then
Response.Write "<script>alert('未指定参数');history.back()</script>"
response.end
else

if not IsNumeric(request_BigClassID) or not IsNumeric(typeid) then
 response.write "<script>alert('非法参数');history.back()</script>"
 response.end
else

set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select * from BigClass where bigclassid=" & request_bigclassid &" order by BigClassorder"
rs.Open rs.Source,conn,1,1
bigclassname=rs("bigclassname")
rs.close
set rs=nothing

set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select * from BigClass where typeid=" & typeid &" order by BigClassorder"
rs.Open rs.Source,conn,1,1
bigclasszs=rs("bigclasszs")


dim ArrayBigClassID(10000),ArrayBigClassName(10000)
BigClassCount=rs.RecordCount
for i=1 to BigClassCount
ArrayBigClassID(i)=rs("BigClassID")
ArrayBigClassName(i)=rs("BigClassName")
rs.MoveNext
next


set rs2=server.CreateObject("ADODB.RecordSet")  '专题
rs2.Source="select Top " & top_sp & " * from Special  order by SpecialID DESC "
rs2.Open rs2.Source,conn,1,1


set rs4=server.CreateObject("Adodb.RecordSet")
rs4.source="select * from SmallClass Where BigClassid=" & request_BigClassid &" order by SmallClassorder"
rs4.open rs4.source,conn,1,1


SmallClassCount=rs4.RecordCount
dim ArraySmallClassID(10000),ArraySmallClassName(10000)
for i=1 to SmallClassCount
ArraySmallClassID(i)=rs4("SmallClassID")
ArraySmallClassName(i)=rs4("SmallClassName")
rs4.MoveNext
next
rs4.Close
set rs4=nothing

dim typename
set rs5=server.CreateObject("ADODB.RecordSet")
rs5.Source="select * from type where typeid=" & typeid &" order by typeorder"
rs5.Open rs5.Source,conn,1,1
typename=rs5("typename")
rs5.Close
set rs5=nothing

end if

%>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=BigClassName%>__<%=typeName%>__<%=jjgn%></title>
<LINK href=index.css rel=stylesheet>
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-right: 0px;
}
-->
</style></head>

<body topmargin="0" background="img/bg.gif">
<!--#include file=include/top1.asp -->
<table width="778" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"  style="border: 1px solid #cccccc">
  <tr valign="top"> 
    <td width="200" bgcolor="#f4f4f4"><table width="100%" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td>
          <div align="center"><img src="IMAGES/kb.gif" width="9" height="8
			"></div></td>
      </tr>
      <tr>
        <td></td>
      </tr>
      <tr>
        <td height="645" valign="top"><table width="90%" align="center" cellpadding="0" cellspacing="0" style="border: 1px solid #cccccc">
          <tr bgcolor="#FFFFFF">
            <td height="25" align="center"><img src="img/type_left_01.gif" width="180" height="29"></td>
          </tr>
          <tr bgcolor="#FFFFFF">
            <td width="30%" height="154" align="center" valign="top"><table width="92%" border="0" cellpadding="0" cellspacing="0">
                <tr>
                  <td>
                    <%
    dim mode
    typeid=checkstr(request("typeid"))
    set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select * from type where typeid="&typeid&" order by typeorder"
rs.Open rs.Source,conn,1,1
mode=rs("mode")
rs.close
set rs=nothing
    if mode=5 then
    set rs=conn.execute("SELECT * FROM bigclass where typeid="&typeid&" order by bigclassorder") 
    if not rs.EOF then
	do while not rs.eof

    %>
                    <table border="0" cellpadding="3" cellspacing="0" style="border-collapse: collapse" width="100%" id="AutoNumber2">
                      <tr>
                        <td colspan="2">
                          <img src="img/arrow00.gif" width="9" height="11"> 
                          <%if not Rs.eof then%>
                          <font class=m_tittle> </font><a class=middle href="bigclass.asp?typeid=<%=typeid%>&bigclassid=<%=Rs("bigclassid")%>"><font color="#000000"><%=Rs("bigclassname")%></font></a> </td>
                      </tr>
                      <%set nrs=conn.execute("SELECT * FROM smallclass where bigclassid="&cstr(rs("bigclassid"))&" order by smallclassorder")%>
                      <%do while not nrs.eof%>
                      <tr>
                        <td width=100% align=center valign="middle">
                          <%if not nRs.eof then%>
                          <a class=class href="SmallClass.asp?typeid=<%=typeid%>&BigClassID=<%=nrs("bigclassid")%>&smallclassid=<%=nrs("smallclassid")%>"><%=nRs("smallclassname")%></a> </td>
                        <%nrs.movenext   
		     end if %>
                      </tr>
                      <%loop
            nRs.Close
           set nRs=nothing
            %>
                    </table>
                    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="<%=border%>" width="105%" id="AutoNumber2" height="11">
                      <tr>
                        <td height=1 align=center></td>
                      </tr>
                    </table>
                    <%rs.movenext   
	end if
	  loop
	rs.close
%>
                    <%else%>
                    <table cellpadding=3 cellspacing=0 width=100% border=0 style="border-collapse: collapse">
                      <tr>
                        <td height="22">    <font color="#000000">暂无大类</font> </td>
                      </tr>
                    </table>
                    <%end if%>
                    <%else%>
                    <%  
typeid=checkstr(request("typeid"))
	set rs=conn.execute("SELECT * FROM bigclass where typeid="&typeid&" order by bigclassorder") 
	do while not rs.eof
%>
                    <table width="100%" border="0" cellpadding="3" cellspacing="0" id="AutoNumber2" style="border-collapse: collapse">
                      <tr>
                        <td height=22 colspan="2">
                          <img src="img/arrow00.gif" width="9" height="11"> 
                          <%if not Rs.eof then%>
                          <a class=middle href="bigclass.asp?typeid=<%=typeid%>&bigclassid=<%=Rs("bigclassid")%>"><font color="#000000"><%=Rs("bigclassname")%></font></a></td>
                      </tr>
                      <%set nrs=conn.execute("SELECT * FROM smallclass where bigclassid="&cstr(rs("bigclassid"))&" order by smallclassorder")%>
                      <%do while not nrs.eof%>
                      <tr>
                        <td width=50% align=center valign="middle">
                          <%if not nRs.eof then%>
                          <a class=class href="SmallClass.asp?typeid=<%=typeid%>&BigClassID=<%=nrs("bigclassid")%>&smallclassid=<%=nrs("smallclassid")%>"><%=nRs("smallclassname")%></a> </td>
                        <%nrs.movenext   
		     end if %>
                        <td width=50% align=center valign="middle">
                          <%if not nRs.eof then%>
                          <a class=class href="SmallClass.asp?typeid=<%=typeid%>&BigClassID=<%=nrs("bigclassid")%>&smallclassid=<%=nrs("smallclassid")%>"><%=nRs("smallclassname")%></a> </td>
                        <%nRs.movenext
             end if%>
                      </tr>
                      <%loop
            nRs.Close
           set nRs=nothing
            %>
                    </table>
                    <%rs.movenext   
	end if
	loop  
	rs.close
%>
                    <%end if%>
                  </td>
                </tr>
            </table></td>
          </tr>
        </table>
          <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" id="AutoNumber4">
            <tr>
              <td width="100%" align=center><img name="" src="" width="1" height="8" alt=""></td>
            </tr>
          </table>
          <table width="90%" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" id="AutoNumber4" style="border: 1px solid #cccccc">
            <tr>
              <td width="100%" align=center><img src="img/type_left_02.gif" width="180" height="29"></td>
            </tr>
            <tr>
              <td align=center><img name="" src="" width="1" height="8" alt=""></td>
            </tr>
            <tr>
              <td align=center><%if search="1" then%>
                  <!--#include file=search.asp-->
                  <%else%>
                  <!--#include file=search1.asp-->
                  <%end if%></td>
            </tr>
            <tr>
              <td align=center><img name="" src="" width="1" height="8" alt=""></td>
            </tr>
          </table>
          <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" id="AutoNumber4">
            <tr>
              <td width="100%" align=center><img name="" src="" width="1" height="8" alt=""></td>
            </tr>
          </table>
          <table width="90%" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" id="AutoNumber4" style="border: 1px solid #cccccc">
              <tr>
                <td align=center><strong><font color="#000000"><img src="img/type_left_03.gif" width="180" height="29"></font></strong></td>
              </tr>
              <tr>
                <td width="100%" height="20" align=center><br>
                    <%
set rs3=server.CreateObject("ADODB.RecordSet")
if uselevel=1 then
if Request.cookies("key")="super" or Request.cookies("key")="typemaster" or Request.cookies("key")="bigmaster" or Request.cookies("key")="smallmaster" or Request.cookies("key")="check" then
rs3.Source ="select top " & top_img & " * from News where picnews=1 and checkked=1 and typeid="&typeid&" and picname is not null order by NewsID DESC"
end if
if Request.cookies("key")="" then
rs3.Source ="select top " & top_img & " * from News where picnews=1 and checkked=1 and newslevel=0 and typeid="&typeid&" and picname is not null order by NewsID DESC"
end if
if Request.cookies("key")="selfreg" then
	if Request.cookies("reglevel")=3 then
rs3.Source ="select top " & top_img & " * from News where picnews=1 and checkked=1 and newslevel<=3 and typeid="&typeid&" and picname is not null order by NewsID DESC"
	end if
	if Request.cookies("reglevel")=2 then
rs3.Source ="select top " & top_img & " * from News where picnews=1 and checkked=1 and newslevel<=2 and typeid="&typeid&" and picname is not null order by NewsID DESC"
	end if
	if Request.cookies("reglevel")=1 then
rs3.Source ="select top " & top_img & " * from News where picnews=1 and checkked=1 and newslevel<=1 and typeid="&typeid&" and picname is not null order by NewsID DESC"
	end if
end if
else
rs3.Source ="select top " & top_img & " * from News where picnews=1 and checkked=1 and typeid="&typeid&" and picname is not null order by NewsID DESC"
end if
rs3.Open rs3.Source,conn,1,1
if not rs3.EOF then
while not rs3.EOF
fileExt=lcase(getFileExtName(rs3("picname")))
Content=rs3("Content")
content=replace(content,"[[","<")
content=replace(content,"]]",">")
%>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -