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

📄 smallclass.asp

📁 综合信息管理系统
💻 ASP
字号:
🔍 
<%@ Language=VBScript%>

<!--#include file=include/conn.asp -->
<!--#include file=include/config.asp -->
<%
request_BigClassID=Request.QueryString("BigClassID")
request_BigClassName=trim(Request.QueryString("BigClassName"))
request_SmallClassID=Request.QueryString ("SmallClassID")
request_SmallClassName=trim(Request.QueryString("SmallClassName"))

PageShowSize = 10            '每页显示多少个页
MyPageSize   = 30           '每页显示多少条新闻
	
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 order by BigClassID"
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 BigClassName='" & request_BigClassName &"' order by SmallClassID"
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><%=request_SmallClassName%>__<%=request_BigClassName%>__<%=redcaff%></title>
<LINK href=news.css rel=stylesheet>
</head>

<body topmargin="0">
<!--#include file=include/top.asp -->
<table width="750" border="0" cellspacing="0" cellpadding="0" align="center">
<tr valign="top" bgcolor="<%=border%>">
<td height="1" width="1"></td>
<td height="1" width="748"></td>
<td height="1" width="1"></td>
</tr>
</table>
<table border="0" width="750" align=center cellspacing="0" cellpadding="0" bgcolor="<%=border%>">
<tr valign="middle">
<td width="1" ></td>
<td bgcolor=#FFFFFF  width="15">&nbsp;</td>
<td bgcolor=#FFFFFF align=left width="736" height="22" ><b>分类栏目</b>
<%for i=1 to BigClassCount

TdString="&nbsp;|&nbsp;<a class=class href='BigClass.asp?BigClassID=" & ArrayBigClassID(i) & "&BigClassName="& ArrayBigClassName(i) &"'>" & ArrayBigClassName(i) & "</a>"

Response.Write TdString

Next
rs.Close
%>
</td>
<td width="1" align=left></td>
</tr>
</table>

<table width="750" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor="<%=border%>">
<tr valign="top">
<td height="1" width="1" bgcolor="<%=border%>"></td>
<td height="1" width="748" bgcolor="<%=border%>"></td>
<td height="1" width="1" bgcolor="<%=border%>"></td>
</tr>
<tr valign="top">
<td bgcolor="<%=border%>" width="1"></td>
<td width="748" bgcolor="<%=t_m_bg%>">&nbsp;</td>
<td bgcolor="<%=border%>" width="1"></td>
</tr>
<tr valign="top">
<td height="1" width="1" bgcolor="<%=border%>"></td>
<td height="1" width="748" bgcolor="<%=border%>"></td>
<td height="1" width="1" bgcolor="<%=border%>"></td>
</tr>
</table>
<table width="750" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor="<%=border%>">
<tr>
<td>
<table width="748" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF" align="center">
<tr>
<td width="15">&nbsp;</td>
<td width="637" height="20">当前位置：<a class=class href="./" >首页</a>&gt;&gt;<a class=class href='BigClass.asp?BigClassID=<%=request_BigClassID%>&amp;BigClassName=<%=request_BigClassName%>'><%=request_BigClassName%></a>&gt;&gt;<%=request_SmallClassName%></td>
<td width="91">&nbsp;</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="750" border="0" cellspacing="0" cellpadding="0" align="center">
<tr valign="top" bgcolor="<%=border%>">
<td height="1" width="1"></td>
<td height="1" width="748"></td>
<td height="1" width="1"></td>
</tr>
</table>
<table width="750" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td bgcolor="<%=border%>" width="1"></td>
<!-----------------------------------------------------左------------------------------------------------>
<td width="160" align="center" valign="top" bgcolor="<%=l_bg%>">
      <table border="0" width="100%" align=center cellspacing="1" cellpadding="0" bgcolor="<%=l_main%>">
        <tr> 
          <td width="100%" bgcolor="<%=l_top%>" height="18"> 
            <table width="100%" border="0" cellspacing="1" cellpadding="0" bgcolor="<%=l_main%>">
              <tr> 
                <td  bgcolor="<%=l_top%>" align="center" > <font class=l_title>资料搜索</font> 
                </td>
              </tr>
            </table>
          </td>
        </tr>
          <tr> 
            <td width="100%" bgcolor="<%=l_main%>" align=center height="40" valign="middle"> 
              <!--#include file=search.asp-->
            </td>
          </tr>
      </table>
<table border="0" width="100%" align=center cellspacing="1" cellpadding="0" bgcolor="<%=l_main%>">
<tr>
<td width="100%" bgcolor="<%=l_top%>" height="18">
<table width="100%" border="0" cellspacing="1" cellpadding="0" bgcolor="<%=l_main%>">
<tr>
<td  bgcolor="<%=l_top%>" align="center" ><font class=l_title>相关小类</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" bgcolor="<%=l_main%>" align=center valign="middle">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="<%=l_main%>">
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<%
for i=1 to SmallClassCount
%>
<tr>
<td align=center height="20">
<%
Response.Write "<a class=lift href='SmallClass.asp?BigClassID=" & request_BigClassID & "&BigClassName="& request_BigClassName & "&SmallClassID=" & ArraySmallClassID(i)& "&SmallClassName="& ArraySmallClassName(i) &"'>" & ArraySmallClassName(i) & "</a>"
%>
</td>
</tr>
<%next
%>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table border="0" width="100%" cellspacing="1" cellpadding="0" bgcolor="<%=l_main%>" >
<tr>
<td width="100%" bgcolor="<%=l_top%>" height="18">
<table width="100%" border="0" cellspacing="1" cellpadding="0" bgcolor="<%=l_main%>">
<tr>
<td  bgcolor="<%=l_top%>" align="center" ><font class=l_title>信息专题</font></td>
</tr>
</table>
</td>
</tr>
<%
if not rs2.EOF then
while not rs2.EOF 
TrString="<tr><td width=100% height=18 bgcolor="& l_main &">&nbsp;-&nbsp;<a class=lift href='Special_News.asp?SpecialID=" & rs2("SpecialID") &"&SpecialName="& rs2("SpecialName") &"'>" & trim(rs2("SpecialName")) & "</a></td></tr>"
Response.Write TrString
rs2.MoveNext
wend
%>

<tr>
<td width="100%" bgcolor="<%=l_main%>" align="right"><a href=special.asp class=class>更多专题...</a></td>
</tr>
<%
else
Response.Write "<tr><td width=100% align=center height=18 bgcolor="& l_main &">暂无专题</td></tr>"
end if
rs2.Close
set rs2=nothing
%>
</table>
<table border="0" width="100%" cellspacing="1" cellpadding="0" bgcolor="<%=l_main%>">
<tr>
<td width="100%" bgcolor="<%=l_top%>" height="18">
<table width="100%" border="0" cellspacing="1" cellpadding="0" bgcolor="<%=l_main%>">
<tr>
<td  bgcolor="<%=l_top%>" align="center" ><font class=l_title>本周热门信息</font></td>
</tr>
</table>
</td>
</tr>

<tr>
<td bgcolor="<%=l_main%>">
<table width="100%" border="0" cellspacing="5" cellpadding="0" align="center">
<%
rs.Source="select top "& top_txt &" NewsID,Title,BigClassName,SmallClassName,SpecialID,click from News where (SmallClassName='" & request_SmallClassName & "' and year(updatetime)=year(date()) and month(updatetime)=month(date()) and day(updatetime)>=day(date()-6) and image=0 and hot=1) order by click DESC"
rs.Open rs.Source,conn,1,1
while not rs.EOF
%>
<tr>
                <td>&nbsp;<img src="images/xpgo.gif" width="4" height="7" border="0"> <a class=lift_top href="ReadNews.asp?NewsID=<%=rs("NewsID")%>&BigClassName=<%=rs("BigClassName")%>&SmallClassName=<%=rs("SmallClassName")%>&SpecialID=<%=rs("SpecialID")%>" target="_blank"><%if len(rs("title"))>20 then%><%=left(rs("title"),20)%>...<%else%><%=rs("title")%><%end if%></a>&nbsp;<font color=red><%=rs("click")%></font>
                  <%
rs.MoveNext
wend
rs.close
set rs=nothing
%>            </table>

</td>
</tr>
</table>
</td>
<td width="2"></td>
<!-----------------------------------------------------中------------------------------------------------>	
    <td width="587" align="center" valign="top" bgcolor="<%=m_bg%>" height="378"> 
      <table border="0" cellpadding="1" cellspacing="0" width="98%">
<tr>
<td width=100% height="10" valign="middle" align="center"></td>
</tr>
<%


set rs3=server.CreateObject("ADODB.RecordSet")

rs3.Source="select NewsID,Title,UpdateTime,BigClassName,SmallClassName,SpecialID,image,click from News where SmallClassName='" & request_SmallClassName &"' order by NewsID DESC"
rs3.Open rs3.Source,conn,1,3

If Not rs3.eof then
Rs3.PageSize     = MyPageSize
MaxPages         = Rs3.PageCount
Rs3.absolutepage = MyPage
total            = Rs3.RecordCount
%>
<tr>
          <td width=100% height="25" valign="top" align="center">&nbsp;共 <%=total%> 条，当前第 <%=Mypage%>/<%=Maxpages%> 
            页，每页 <%=MyPageSize%> 条</td>
</tr>
<%


i = 0
do until rs3.Eof or i = rs3.PageSize
if rs3("image")=>1 then
img="<img src='images/img.gif' height='9' border='0'>"
else
img=""
end if
%>
<tr>
<td width="100%" height="20">&nbsp;<img src="images/go.gif" width="10" height="9" border="0">&nbsp;<a class=middle href="ReadNews.asp?NewsID=<%=rs3("NewsID")%>&BigClassName=<%=rs3("BigClassName")%>&SmallClassName=<%=rs3("SmallClassName")%>&SpecialID=<%=rs3("SpecialID")%>" target=_blank><%=trim(rs3("Title"))%></a><font class=middle>(<%=trim(rs3("UpdateTime"))%>)[<font color="#ff0000"><%=trim(rs3("click"))%></font>]</font><%=img%></td>
</tr>
<%
rs3.MoveNext
i = i + 1
loop
%>
<tr>
<td width="100%">&nbsp; </td>
</tr>
<tr>
          <td width="100%" align=center>共 <%=total%> 条，当前第 <%=Mypage%>/<%=Maxpages%> 
            页，每页 <%=MyPageSize%> 条 
            <%
url="SmallClass.asp?BigClassName=" & request_BigClassName & "&SmallClassName=" & request_SmallClassName									
PageNextSize=int((MyPage-1)/PageShowSize)+1
Pagetpage=int((total-1)/rs3.PageSize)+1

if PageNextSize >1 then
PagePrev=PageShowSize*(PageNextSize-1)
Response.write "<a class=black href='" & Url & "&page=" & PagePrev & "' title='上" & PageShowSize & "页'>上一翻页</a> "
Response.write "<a class=black href='" & Url & "&page=1' title='第1页'>页首</a> "
end if
if MyPage-1 > 0 then
Prev_Page = MyPage - 1
Response.write "<a class=black href='" & Url & "&page=" & Prev_Page & "' title='第" & Prev_Page & "页'>上一页</a> "
end if

if Maxpages>=PageNextSize*PageShowSize then
PageSizeShow = PageShowSize
Else
PageSizeShow = Maxpages-PageShowSize*(PageNextSize-1)
End if
If PageSizeShow < 1 Then PageSizeShow = 1
for PageCounterSize=1 to PageSizeShow
PageLink = (PageCounterSize+PageNextSize*PageShowSize)-PageShowSize
if PageLink <> MyPage Then
Response.write "<a class=black href='" & Url & "&page=" & PageLink & "'>[" & PageLink & "]</a> "
else
Response.Write "<B>["& PageLink &"]</B> "
end if
If PageLink = MaxPages Then Exit for
Next

if Mypage+1 <=Pagetpage  then
Next_Page = MyPage + 1
Response.write "<a class=black href='" & Url & "&page=" & Next_Page & "' title='第" & Next_Page & "页'>下一页</A>"
end if

if MaxPages > PageShowSize*PageNextSize then
PageNext = PageShowSize * PageNextSize + 1
Response.write " <A class=black href='" & Url & "&page=" & Pagetpage & "' title='第"& Pagetpage &"页'>页尾</A>"
Response.write " <a class=black href='" & Url & "&page=" & PageNext & "' title='下" & PageShowSize & "页'>下一翻页</a>"
End if
else
Response.write "<tr><td>&nbsp;本类暂无信息</td></tr>"
				
End If
Rs3.close
set rs3=nothing
%>
          </td>
</tr>
<tr>
<td width="100%" align=center>&nbsp;</td>
</tr>
<tr>
<td width="100%"></td>
</tr>
</table>
    </td>
<td bgcolor="<%=border%>" width="1"></td>
</tr>
</table>
<table width="750" border="0" cellspacing="0" cellpadding="0" align="center">
<tr valign="top" bgcolor="<%=border%>">
<td height="1" width="1"></td>
<td height="1" width="748"></td>
<td height="1" width="1"></td>
</tr>
</table>
<!--#include file=include/bottom.asp -->
</body>

</html>

⌨️ 快捷键说明

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