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

📄 bigclassdeta.asp

📁 ASP+SQL2000+
💻 ASP
📖 第 1 页 / 共 2 页
字号:
<%@ Language=VBScript%>

<!--#include file=include/conn.asp -->
<!--#include file=include/config.asp -->
<!--#include file=include/function.asp-->
<%
typeid=request("typeid")
request_BigClassID=Request.QueryString("BigClassID")
if typeid="" or request_bigclassid="" then
Response.Write "未指定参数"
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


PageShowSize = 10            '每页显示多少个页
MyPageSize   = 20           '每页显示多少条新闻
	
If Not IsNumeric(Request("page")) Or IsEmpty(Request("page")) Or Request("page") <=0 Then
MyPage=1
Else
MyPage=Int(Abs(Request("page")))
End if


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

dim ArrayBigClassID(10000),ArrayBigClassName(10000)
BigClassCount=rs.RecordCount
for i=1 to BigClassCount
ArrayBigClassID(i)=rs("BigClassID")
ArrayBigClassName(i)=trim(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)=trim(rs4("SmallClassName"))
rs4.MoveNext
next
rs4.Close
set rs4=nothing


%>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>全部内容__<%=BigClassName%>__<%=jjgn%></title>
<LINK href=news.css rel=stylesheet>
</head>

<body topmargin="0">
<!--#include file=include/top.asp -->
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr valign="top"> 
    <td width="180" background="IMAGES/menu-d.gif"> 
      <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
        <tr> 
          <td height="3"><img src="IMAGES/kb.gif" width="9" height="3"></td>
        </tr>
        <tr> 
          <td height="25" align="center" background="IMAGES/menu-d-fl.gif"><font color="#000000">分类栏目</font> 
          </td>
        </tr>
        <tr> 
          <td width="545" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="3" bgcolor="efefef">
              <tr bgcolor="#FFFFFF"> 
                <td width="30%" height="23" align="center" valign="top" background="IMAGES/menu-d.gif"> 
                  <table width="92%" border="0" cellpadding="0" cellspacing="0">
                    <tr> 
                      <td> 
                        <%
    dim mode
    typeid=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=3 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"> <li></li>
                              <%if not Rs.eof then%>
                              <font class=m_tittle>&nbsp;</font><a class=middle href="bigclass.asp?typeid=<%=typeid%>&bigclassid=<%=Rs("bigclassid")%>"><font color="#000000"><%=Rs("bigclassname")%></font></a>&nbsp;</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">&nbsp;&nbsp;&nbsp;&nbsp;<font color="#000000">暂无大类</font>&nbsp;</td>
                          </tr>
                        </table>
                        <%end if%>
                        <%else%>
                        <%  
typeid=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"> <li></li>
                              <%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>
              <tr> 
                <td height="25" valign="middle" background="IMAGES/menu-d-ss.gif"> 
                  <p align="center">文章搜索</td>
              </tr>
              <tr> 
                <td height="24" align=center valign="middle" background="IMAGES/menu-d.gif"> 
                  <%if search="1" then%>
                  <!--#include file=search.asp-->
                  <%else%>
                  <!--#include file=search1.asp-->
                  <%end if%>
                </td>
              </tr>
              <tr> 
                <td height="25" valign="middle" background="IMAGES/menu-d-new.gif"> 
                  <p align="center"><font color="#000000">本月最新</font><font color="#ffffff"></font></td>
              </tr>
              <tr> 
                <td height="76" background="IMAGES/menu-d.gif"><div align="center"> 
                    <table width="90%" border="0" cellspacing="0" cellpadding="0">
                      <tr> 
                        <td> 
                          <%  dim ii
	ii = 0
	if uselevel=1 then
if Request.cookies("key")="" then
rs.Source="select top " & top_txt & " * from News where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" and newslevel=0 order by click DESC,newsid desc"   '选择本月
end if
if Request.cookies("key")="selfreg" then
	if Request.cookies("reglevel")=3 then
	rs.Source="select top " & top_txt & " * from News where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" and newslevel<=3 order by click DESC,newsid desc"   '选择本月
	end if
	if Request.cookies("reglevel")=2 then
	rs.Source="select top " & top_txt & " * from News where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" and newslevel<=2 order by click DESC"   '选择本月
	end if
	if Request.cookies("reglevel")=1 then
	rs.Source="select top " & top_txt & " * from News where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" and newslevel<=1 order by click DESC,newsid desc"   '选择本月
	end if
end if
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
rs.Source="select top " & top_txt & " * from News where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" order by click DESC,newsid desc"   '选择本月
end if
else
rs.Source="select top " & top_txt & " * from News where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" order by click DESC,newsid desc"   '选择本月
end if
rs.Open rs.Source,conn,1,1
	if rs.bof and rs.eof then 
		response.write "&nbsp;&nbsp;本月无更新" 
	else 
	do while not rs.eof 
title=trim(rs("title"))
title=replace(title,"<br>","")
%>
                          · 
                          <%
    typeid=request("typeid")
    set rs11=server.CreateObject("ADODB.RecordSet")
rs11.Source="select * from type where typeid="&typeid&" order by typeorder"
rs11.Open rs11.Source,conn,1,1
mode=rs11("mode")
rs11.close
set rs11=nothing%>
                          <%if mode<>4 then%>
                          <a class=middle href="ReadNews.asp?NewsID=<%=rs("NewsID")%>" title="<%=title%>" target="_blank"> 
                          <%if mode="2" then%>
                          <%if rs("picname")<>"" then%>

⌨️ 快捷键说明

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