bigclassdeta.asp

ASP+SQL2000+

                          <img src='IMAGES/IMG.gif' border='0'> 
                          <%end if%>
                          <%end if%>
                          <font color="<%=rs("titlecolor")%>"><%=gottopic(title,14)%></font></a><font color="#FF0000"> 
                          <%=rs("click")%></font> 
                          <%else%>
                          <a class=middle href="soft.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,14)%></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>
                  </div></td>
              </tr>
            </table></td>
        </tr>
      </table>
    </td>
    <td width="6" height="20" bgcolor="#FFFFFF">&nbsp;</td>
    <td background="IMAGES/menu-l.gif"> 
      <table width="100%" border="0" cellpadding="0" cellspacing="0">
        <tr bordercolor="#999999" bgcolor="#FFFFFF"> 
          <td align="center" valign="middle" bordercolor="#FFFFFF"><img src="IMAGES/kb.gif" width="9" height="3"></td>
        </tr>
        <tr> 
          <td height="25" background="IMAGES/menu-l-m.gif">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font class=m_tittle>&nbsp;</font>栏目导航 
            <%typeid=request("typeid")

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 class="daohang" href="./" >&nbsp;&nbsp;网站首页</a>&gt;&gt;<a class="daohang" href="type.asp?typeid=<%=typeid%>"><%=typename%></a>&gt;&gt;<a class="daohang" href='BigClass.asp?typeid=<%=typeid%>&BigClassID=<%=request_BigClassID%>'><%=BigClassName%></a>&gt;&gt;<%=bigClassName%>全部内容</td>
        </tr>
        <tr> 
          <td background="IMAGES/menu-l.gif"> <div align="center"> 
              <script language=javascript src=./admin/banner/ads.asp?place=1></script>
            </div></td>
        </tr>
        <tr> 
          <td> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%" id="AutoNumber3">
              <tr> 
                <td valign=top background="IMAGES/menu-l.gif"> <table border="0" cellpadding="0" 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 (BigClassid=" & request_BigClassid & " and checkked=1) order by newsid DESC"
end if
if Request.cookies("key")="" then
rs3.Source="select * from News where (BigClassid=" & request_BigClassid & " 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 (BigClassid=" & request_BigClassid & " and checkked=1 and newslevel<=3) order by newsid DESC"
	end if
	if Request.cookies("reglevel")=2 then
rs3.Source="select * from News where (BigClassid=" & request_BigClassid & " and checkked=1 and newslevel<=2) order by newsid DESC"
	end if
	if Request.cookies("reglevel")=1 then
rs3.Source="select * from News where (BigClassid=" & request_BigClassid & " and checkked=1 and newslevel<=1) order by newsid DESC"
	end if
end if
else
rs3.Source="select * from News where (BigClassid=" & request_BigClassid & " 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" background="IMAGES/menu-l-zj.gif" > 
                        <p align="center">&nbsp;共 <%=total%> 条，当前第 <%=Mypage%>/<%=Maxpages%> 
                          页，每页 <%=MyPageSize%> 条</td>
                    </tr>
                    <tr> 
                      <td width="100%"> 
                        <%
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="58%">&nbsp;&nbsp;<img src="images/006.gif" width="8" height="10" border="0">&nbsp; 
                              <%if mode<>4 then%>
                              <a class=middle href="ReadNews.asp?NewsID=<%=rs3("NewsID")%>" target=_blank title="<%=title%>"> 
                              <%if mode="2" then%>
                              <%=img%> 
                              <%end if%>
                              <font color="<%=rs3("titlecolor")%>"> 
                              <%if len(title)>20 then%>
                              <%=left(title,20)%> 
                              <%else%>
                              <%=title%> 
                              <%end if%>
                              </font></a></td>
                            <td width="7%" align="right"> 
                              <%if showauthor="1" then%>
                              <%=rs3("Author")%> 
                              <%end if%>
                            </td>
                            <td width="22%" align="center"><font class=middle><%=trim(rs3("UpdateTime"))%></font></td>
                            <td width="5%" align="center"><font color="#666666"><%=trim(rs3("click"))%></font></td>
                            <td width="8%" align="left"> 
                              <%if rs3("goodnews")="1" then%>
                              <img src="images/g.gif" > 
                              <%end if%>
                              <%else%>
                            </td>
                          </tr>
                          <tr> 
                            <td><a class=middle href="soft.asp?NewsID=<%=rs3("NewsID")%>" target=_blank title="<%=title%>"> 
                              <%if mode="2" then%>
                              <%=img%> 
                              <%end if%>
                              <font color="<%=rs3("titlecolor")%>"> 
                              <%if len(title)>50 then%>
                              <%=left(title,50)%> 
                              <%else%>
                              <%=title%> 
                              <%end if%>
                              </font></a></td>
                            <td align="right"> 
                              <%if showauthor="1" then%>
                              <%=rs3("Author")%> 
                              <%end if%>
                            </td>
                            <td align="center"><font class=middle><%=trim(rs3("UpdateTime"))%></font></td>
                            <td align="center"><font class=middle><font color="#666666"><%=trim(rs3("click"))%></font></font></td>
                            <td align="left"> 
                              <%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%" align=center valign="middle">共 <%=total%> 
                        条，当前第 <%=Mypage%>/<%=Maxpages%> 页，每页 <%=MyPageSize%> 条 
                        <%
url="bigclassdeta.asp?typeid=" & typeid & "&BigClassid=" & request_BigClassid									
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>&nbsp;本类暂无信息</td></tr>"
				
End If
Rs3.close
set rs3=nothing
%>
                      </td>
                    </tr>
                  </table></td>
              </tr>
            </table></td>
        </tr>
      </table>
    </td>
  </tr>
  <tr valign="top">
    <td height="20" background="IMAGES/menu-d-t.gif">&nbsp;</td>
    <td bgcolor="#FFFFFF">&nbsp;</td>
    <td height="20" background="IMAGES/menu-l-t.gif" class="daohang">&nbsp;</td>
  </tr>
</table>
<!--#include file=include/bottom.asp -->




  
</body>
</html><%end if%>