special.asp

社区天地图文系统(核心:尘缘雅境图文系统) 版本: 1.0 本系统是ASP+ACCESS环境下开发成功

rs.MoveNext
wend
rs.close
%>
                        </td>            </tr>
            <tr>
              <td height="5"></td>
            </tr>
          </table></td>
        </tr>
      </table>
      <table width="194" border="0" cellspacing="0" cellpadding="0" height="131">
        <tr>
          <td width="24" height="58" valign="bottom" background="imgs/left_02-1bg.jpg">
			<img src="imgs/left_03-1.jpg" width="24" height="40"></td>
          <td width="15" valign="bottom" background="imgs/left_02-2bg.jpg">
			<img border="0" src="imgs/pleft_04-1.jpg" width="15" height="58"></td>
          <td width="148" height="78" background="imgs/left_04-12.jpg">　</td>
          <td rowspan="2" valign="top" bgcolor="#82CEFD">
			<img src="imgs/left_03-4.jpg" width="7" height="30"></td>
        </tr>
        <tr>
          <td height="53" valign="top" background="imgs/left_02-1bg.jpg">
			<img src="imgs/left_02-1.jpg" width="24" height="53"></td>
          <td valign="top" background="imgs/left_02-2bg.jpg">
			<img src="imgs/left_02-2.jpg" width="15" height="17"></td>
          <td valign="top" bgcolor="#C4E8FF"><table width="140"  border="0" align="center" cellpadding="0" cellspacing="0">
            <tr>
              <% 
 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 newslevel=0 order by click 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 newslevel<=3 order by click 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 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 newslevel<=1 order by click 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 order by click 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 order by click DESC"   '选择本月
end if
rs.Open rs.Source,conn,1,1
	if rs.bof and rs.eof then 
		response.write "<td align=center>无</td>" 
	else 
	do while not rs.eof 
%>
              <tr> 
                <td height=18> · 
                  <%if rs("picnews")=1 then%>
                  <img src="IMAGES/IMG.gif"> 
                  <%end if%>
                  <a class=middle href="ReadNews.asp?NewsID=<%=rs("NewsID")%>" title="<%=rs("title")%>" target="_blank" > 
                  <%=rs("title")%></a><font color="#666666">[<%=rs("click")%>]</font> 
                </td>
              </tr>
              <%  ii = ii + 1
    if ii>50 then exit do
	rs.movenext     
	loop
	end if  
	rs.close   
	set rs=nothing
%>
            
            </tr>
            <tr>
              <td height="5"></td>
            </tr>
          </table></td>
        </tr>
      </table>
      </td>
    <td width="564" valign="top" bgcolor="#64C2FD">
	<table width="564" border="0" cellspacing="0" cellpadding="0" height="518">
      <tr>
        <td height="33" background="imgs/daohang_bg.jpg"><table width="95%"  border="0" align="center" cellpadding="0" cellspacing="0">
            <tr>
              <TD class=yy>&nbsp;<a href="index.asp">网站首页</a><a href="#·"> </a><SPAN 
                  class=style1>| </SPAN><a href="type.asp?typeID=16">团学天地</a> <SPAN 
                  class=style1>| <a href="type.asp?typeID=17">规章制度</a> | </SPAN>
				<a href="type.asp?typeID=18">社区生活</a> <SPAN 
                  class=style1>| <a href="type.asp?typeID=19">最新下载 </a>| </SPAN>
				<a href="nwjl.asp">内务纪律</a> <SPAN 
                  class=style1>| </SPAN><a href="special.asp">社区专题</a></TD>
            </tr>
        </table></td>
      </tr>
      <tr>
        <td height="485" valign="top">
          <table width="559" border="0" cellspacing="0" cellpadding="0" height="485">
            <tr>
              <td width="559" height=42 background="imgs/photo_title.jpg" >&nbsp;&nbsp;&nbsp;&nbsp;<img border="0" src="IMAGES/menu-l-m.gif" width="11" height="11"><font class=m_tittle>&nbsp; </font>栏目导航 
 
            <a class="daohang" href="./" >&nbsp;&nbsp;网站首页</a>&gt;&gt;专题</td>
            </tr>
            <tr>
              <td valign="top" background="imgs/news_bg.jpg" height="427">
				<table width="98%"  border="0" align="center" cellpadding="0" cellspacing="0" height="411">
                  <tr>
                    <td width="4">　</td>
                    <td valign="top" bgcolor="#C4E8FF"><table width="100%" border="0" cellpadding="3" cellspacing="0">
                    <%
set rs2=server.CreateObject("ADODB.RecordSet")  '专题
rs2.Source="select * from Special  order by SpecialID DESC "
rs2.Open rs2.Source,conn,3,1

if rs2.eof and rs2.bof then
response.write "<p align=center>&nbsp;&nbsp;还没有任何专题</p>"
else
end if

if not rs2.eof then

Rs2.PageSize     = MyPageSize
MaxPages         = Rs2.PageCount
Rs2.absolutepage = MyPage
total            = Rs2.RecordCount
%>
                    <tr> 
                      <td width=100% height="25" background="imgs/2.jpg"></td>
                    </tr>
                    <%

i = 0
do until Rs2.Eof or i = Rs2.PageSize
%>
                    <tr> 
                      <td width="100%" height="20" bgcolor="#C4E8FF">&nbsp;&nbsp;<img src="images/006.gif" width="8" height="10" border="0">&nbsp;<a class=middle href="Special_News.asp?SpecialID=<%=rs2("SpecialID")%>"><%=trim(rs2("SpecialName"))%></a></td>
                    </tr>
                    <%
Rs2.MoveNext
i = i + 1
loop
%>
                    <tr> 
                      <td width="100%" height="24" align=center>第 <%=Mypage%>/<%=Maxpages%> 
                        页，每页 <%=MyPageSize%> 项 
                        <%
url="Special.asp?"
PageNextSize=int((MyPage-1)/PageShowSize)+1
Pagetpage=int((total-1)/Rs2.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

				
End If
Rs2.close

%>
                      </td>
                    </tr>
                  </table></td>
                  </tr>
                  </table></td>
            </tr>
            <tr>
              <td height="16" bgcolor="#82CEFD">
				<img src="imgs/new_bg01.jpg" width="9" height="4"></td>
            </tr>
          </table>
        </td>
        </tr>
    </table></td>
    <td width="15" valign="top" background="imgs/right_bg.jpg">　</td>
  </tr>
</table>
<table width="773" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="118" valign="top" background="imgs/under.jpg"> <!--#include file=bot.asp -->
</td>
  </tr>
</table>

</body>
</html>