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

📄 smallclass.asp

📁 学校 管理系统 学校 管理系统
💻 ASP
📖 第 1 页 / 共 2 页
字号:
rs.Open rs.Source,conn,1,1
	if rs.bof and rs.eof then 
		response.write "本月无更新" 
	else 
	do while not rs.eof 
title=trim(rs("title"))
title=replace(title,"<br>","")
%>
 ·
      <%
    typeid=checkstr(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 href="ReadNews.asp?NewsID=<%=rs("NewsID")%>" title="<%=title%>" target="_blank">
      <%if mode="2" then%>
      <%if rs("picname")<>"" then%>
      <img src='IMAGES/IMG.gif' border='0'>
      <%end if%>
      <%end if%>
      <font color="<%=rs("titlecolor")%>"><%=gottopic(title,30)%></font></a><font color="#FF0000"> <%=rs("click")%></font>
      <%else%>
      <a href="ReadNews.asp?NewsID=<%=rs("NewsID")%>" title="<%=title%>" target="_blank">
      <%if mode="2" then%>
      <%if rs("picname")<>"" then%>
      <img src='IMAGES/IMG.gif' border='0'>
      <%end if%>
      <%end if%>
      <font color="<%=rs("titlecolor")%>"><%=gottopic(title,12)%></font></a><font color="#FF0000"> <%=rs("click")%></font>
      <%end if%>
      <br>
      <%  ii = ii + 1
    if ii>50 then exit do
	rs.movenext     
	loop
	end if  
	rs.close   
	set rs=nothing
%></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></td>
        </tr>
      </table>
    </td>
    <td bgcolor="#CCCCCC"><img name="" src="" width="1" height="1" alt=""></td>
    <td> 
      <table width="100%" border="0" cellpadding="0" cellspacing="0">
        <tr bgcolor="#FFFFFF"> 
          <td align="center" valign="middle"><img src="IMAGES/kb.gif" width="1" height="8"></td>
        </tr>
        <tr> 
          <td height="25"> 
            <%
  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

%>
                  栏目导航<a href="./" > 
          网站首页</a>>><a href="type.asp?typeid=<%=typeid%>"><%=typename%></a>>><a href='BigClass.asp?typeid=<%=typeid%>&BigClassID=<%=request_BigClassID%>'><%=BigClassName%></a>>><%=SmallClassName%></td>
        </tr>
        <tr> 
          <td><div align="center"> 
              <script language=javascript src=./admin/banner/ads.asp?place=1></script>
            </div></td>
        </tr>
        <tr> 
          <td><table border="0" cellpadding="3" cellspacing="0" width="100%" style="border-collapse: collapse">
              <%

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 * from News where (SmallClassid=" & request_SmallClassid &" and checkked=1) order by newsid DESC"
end if
if Request.cookies("key")="" then
rs3.Source="select * from News where (SmallClassid=" & request_SmallClassid &" and checkked=1 and newslevel=0) order by newsid DESC"
end if
if Request.cookies("key")="selfreg" then
	if Request.cookies("reglevel")=3 then
rs3.Source="select * from News where (SmallClassid=" & request_SmallClassid &" and checkked=1 and newslevel<=3) order by newsid DESC"
	end if
	if Request.cookies("reglevel")=2 then
rs3.Source="select * from News where (SmallClassid=" & request_SmallClassid &" and checkked=1 and newslevel<=2) order by newsid DESC"
	end if
	if Request.cookies("reglevel")=1 then
rs3.Source="select * from News where (SmallClassid=" & request_SmallClassid &" and checkked=1 and newslevel<=1) order by newsid DESC"
	end if
end if
else
rs3.Source="select * from News where (SmallClassid=" & request_SmallClassid &" and checkked=1) order by newsid DESC"
end if
rs3.Open rs3.Source,conn,3,1

If Not rs3.eof then
Rs3.PageSize     = MyPageSize
MaxPages         = Rs3.PageCount
Rs3.absolutepage = MyPage
total            = Rs3.RecordCount
%>
              <tr> 
                <td width=100% height="25" valign="middle" > 
                  <p align="center"> 共 <%=total%> 条,当前第 <%=Mypage%>/<%=Maxpages%> 
                页,每页 <%=MyPageSize%> 条</td>
              </tr>
              <tr> 
                <td width="100%" height="27"> 
                  <%
i = 0
do until rs3.Eof or i = rs3.PageSize
if rs3("picname")<>"" then
img="<img src='IMAGES/IMG.gif' border='0'>"
else
img=""
end if
title=trim(rs3("title"))
title=replace(title,"<br>","")
%>
                  <table width="98%" border="0" cellpadding="3" cellspacing="0">
                    <tr> 
                      <td width="55%"> 
                        <%if mode<>4 and  mode<>1 and  mode<>3 then%>
                        <%if mode="2" then%>  <img src="IMAGES/006.gif" width="8" height="10"><a href="ReadNews.asp?NewsID=<%=rs3("NewsID")%>" target=_blank title="<%=title%>">
                        <%=img%> 
                        <%end if%>
                        <<%=rs3("titletype")%>><font color="<%=rs3("titlecolor")%>"> 
                        <%if len(title)>18 then%>
                        <%=left(title,18)%> 
                        <%else%>
                        <%=title%> 
                        <%end if%>
                        </font></<%=rs3("titletype")%>></a></td>
                      <td width="7%" align="right"> 
                        <%if showauthor="1" then%>
                        <%=rs3("Author")%> 
                        <%end if%>
                      </td>
                      <td width="28%" align="left"><font class=middle><%=trim(rs3("UpdateTime"))%></font></td>
                      <td width="5%" align="center"><font class=middle><font color="#66666"><%=trim(rs3("click"))%></font></font></td>
                      <td width="8%" align="left"><font class=middle> </font> 
                        <%if rs3("goodnews")="1" then%>
                        <img src="images/g.gif"> 
                        <%end if%>
                        <%else%>
                      </td>
                    </tr>
                    <tr> 
                      <td>  <img src="IMAGES/004.gif" width="8" height="10"><a class=middle href="ReadNews.asp?NewsID=<%=rs3("NewsID")%>" target=_blank title="<%=title%>"> 
                        <%if mode="4" or  mode="1" or mode="3" then%>
                        <%=img%> 
                        <%end if%>
                        <font color="<%=rs3("titlecolor")%>"> 
                        <%if len(title)>18 then%>
                        <%=left(title,18)%> 
                        <%else%>
                        <%=title%> 
                        <%end if%>
                        </font></a></td>
                      <td align="right"> 
                        <%if showauthor="1" then%>
                        <%=rs3("Author")%> 
                        <%end if%>
                      </td>
                      <td align="left"> </td>
                      <td align="center"><font class=middle><%=trim(rs3("UpdateTime"))%></font></td>
                      <td align="left"><font class=middle><font color="#666666"><%=trim(rs3("click"))%></font></font> 
                        <%if rs3("goodnews")="1" then%>
                        <img src="images/g.gif" > 
                        <%end if%>
                        <%end if%>
                      </td>
                    </tr>
                  </table>
                  <%
rs3.MoveNext
i = i + 1
loop
%>
                </td>
              </tr>
              <tr> 
                <td width="100%" height="20" align=center valign="middle">共 
                  <%=total%> 条,当前第 <%=Mypage%>/<%=Maxpages%> 页,每页 <%=MyPageSize%> 
                  <%
url="SmallClass.asp?typeid=" &typeid & "&BigClassid=" & request_BigClassid & "&SmallClassid=" & request_SmallClassid									
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 align=center background=""IMAGES/menu-l.gif"">&nbsp;本类暂无信息</td></tr>"
				
End If
Rs3.close
set rs3=nothing

%>
                </td>
              </tr>
            </table></td>
        </tr>
        <tr> 
          <td> </td>
        </tr>
      </table>
      <p> </p></td>
  </tr>
</table>
<!--#include file=include/bottom.asp --></td>
<td width="4" height="209"> </td>
    
<td width="636" height="209" valign=top>  </td>
  </tr>
</table>
</body>
</html><%end if%>

⌨️ 快捷键说明

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