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

📄 type.asp

📁 社区天地图文系统(核心:尘缘雅境图文系统) 版本: 1.0 本系统是ASP+ACCESS环境下开发成功
💻 ASP
📖 第 1 页 / 共 2 页
字号:
          <td width="148" height="78" background="imgs/left_05-2.jpg"> </td>
          <td rowspan="3" valign="top" bgcolor="#82CEFD">
			<img src="imgs/left_03-4.jpg" width="7" height="30"></td>
        </tr>
        <tr>
          <td rowspan="2" valign="top" background="imgs/left_02-1bg.jpg">
			<img src="imgs/left_02-1.jpg" width="24" height="53"></td>
          <td rowspan="2" valign="top" background="imgs/left_02-2bg.jpg">
			<img src="imgs/left_02-2.jpg" width="15" height="17"></td>
          <td height="78" valign="top" bgcolor="#C4E8FF"><table width="95%"  border="0" align="center" cellpadding="0" cellspacing="0">
            <tr>
              <td height="5"></td>
            </tr>
            <tr>
              <TD height=73 vAlign=top>
                  <%								
function gettipnum()
dim tmprs
tmprs=conn.execute("Select Count(NewsID) from News where checkked=1")
gettipnum=tmprs(0)
set tmprs=nothing
if isnull(gettipnum) then gettipnum=0
end function

function todays()
dim tmprs
tmprs=conn.execute("Select count(NewsID) from News Where checkked=1 and year(updatetime)=year(date()) and month(updatetime)=month(date()) and day(updatetime)=day(date())")
todays=tmprs(0)
set tmprs=nothing
if isnull(todays) then todays=0
end function

function getusernum()
dim rs
rs=conn.execute("Select Count(ID) from admin")
getusernum=rs(0)
set rs=nothing
if isnull(getusernum) then getusernum=0
end function

function getgg()
dim rs
rs=conn.execute("Select Count(ID) from admin where sex='先生'")
getgg=rs(0)
set rs=nothing
if isnull(getgg) then getgg=0
end function

function getmm()
dim rs
rs=conn.execute("Select Count(ID) from admin where sex='女士'")
getmm=rs(0)
set rs=nothing
if isnull(getmm) then getmm=0
end function

function getother()
dim rs
rs=conn.execute("Select Count(ID) from admin where sex='保密'")
getother=rs(0)
set rs=nothing
if isnull(getother) then getother=0
end function
%>
                  &nbsp;&nbsp;○- 今日文章:<font color=red><%=todays()%></font><br> 
                  &nbsp;&nbsp;○- 文章总数:<font color=red><%=gettipnum()%></font><br>
				                   <%if showcount=1 then%>
                  <script src=include/cnt.asp></script>
				  <!--#include file=include/zx.asp -->
				  <br> &nbsp;&nbsp;○- 当前在线:<font color=red><%=i%></font>				  <%end if%>
                  </TD>
           
          </table></td>
        </tr>
    </table></td>
    <td width="564" valign="top" bgcolor="#64C2FD">
	<table width="564" border="0" cellspacing="0" cellpadding="0" height="604">
      <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="571" valign="top">
          <div align="center">
          <table width="559" border="0" cellspacing="0" cellpadding="0" bgcolor="#64C2FD">
            <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>栏目导航 
            &nbsp;&nbsp;<a href="./" class="daohang">网站首页</a>&gt;&gt;<%=typename%> 
          </td>
            </tr>
            <tr>
              <td valign="top" background="imgs/news_bg.jpg">
				<table width="101%"  border="0" align="center" cellpadding="0" cellspacing="0">
                  <tr>
                    <td valign="top" width="9">
					 </td>
                    <td valign="top">                                    <%if mode<>4 then%>
                  <%
  if rseof=1 then
for i=1 to RecordCount
BigClassID=ArrayBigClassID(i)
BigClassName=ArrayBigClassName(i)
BigClassview=ArrayBigClassview(i)
if ArrayBigClassView(i)=1 then 
%>
                  <table border="0" cellpadding="3" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber5" bgcolor="#C4E8FF">
                    <tr> 
                      <td height="25" background="imgs/2.jpg" bgcolor="#C4E8FF">&nbsp;<img src=IMAGES/POINT1.GIF width="13" height="13">&nbsp;<font class=m_tittle><%=BigClassName%></font></td>
                    </tr>
                    <%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 top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1) order by newsid DESC"
end if
if Request.cookies("key")="" then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & 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 top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel<=3) order by newsid DESC"
	end if
	if Request.cookies("reglevel")=2 then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel<=2) order by newsid DESC"
	end if
	if Request.cookies("reglevel")=1 then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel<=1) order by newsid DESC"
	end if
end if
else
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1) order by newsid DESC"
end if
rs3.Open rs3.Source,conn,1,1
while not rs3.EOF
if showyear=1 then
newsurl="ReadNews.asp?NewsID=" & rs3("NewsID")
datetime="<font class=middle>(" & year(rs3("UpdateTime"))  &"年"& Month(rs3("UpdateTime"))  &"月"& Day(rs3("UpdateTime")) &"日)</font>"
else
newsurl="ReadNews.asp?NewsID=" & rs3("NewsID")
datetime="<font class=middle>("& Month(rs3("UpdateTime"))  &"月"& Day(rs3("UpdateTime")) &"日)</font>"
end if
if rs3("picnews")=1 then
img="<img src='IMAGES/IMG.gif' border='0'>"
else
img=""
end if
title=trim(rs3("title"))
title=replace(title,"<br>","")
%>
                    <tr> 
                      <td bgcolor="#C4E8FF"> <div align="center"> 
                          <table width="98%" border="0" cellpadding="0" cellspacing="0">
                            <tr> 
                              <td width="65%">&nbsp;&nbsp;<img src="IMAGES/006.gif" width="8" height="10"><a class=middle href="<%=newsurl%>" title="<%=title%>"  onclick="return ow(this)"  target="_blank"> 
                                <%if mode="2" then%>
                                <%=img%> 
                                <%end if%>
                                <<%=rs3("titletype")%>><font color="<%=rs3("titlecolor")%>"> 
                                <%if showtime="1" then%>
                                <%if len(title)>24 then%>
                                <%=left(title,24)%> 
                                <%else%>
                                <%=title%> 
                                <%end if%>
                                <%else%>
                                <%if len(title)>24 then%>
                                <%=left(title,24)%> 
                                <%else%>
                                <%=title%> 
                                <%end if%>
                                <%end if%>
                                </font></<%=rs3("titletype")%>></a> </td>
                              <td width="15%" align="left"> 
                                <%if showtime="1" then%>
                                <%=datetime%> 
                                <%end if%>
                                &nbsp;</td>
                              <td width="5%" align="center"> 
                                <%if showclick="1" then%>
                                <font color=#666666><%=rs3("click")%></font> 
                                <%end if%>
                              </td>
                              <td width="8%" align="left"> 
                                <%if year(rs3("updatetime"))=year(date()) and month(rs3("updatetime"))=month(date()) and day(rs3("updatetime"))=day(date()) then%>
                                <img src="images/new.gif"> 
                                <%end if%>
                                <%if rs3("goodnews")="1" then%>
                                <img src="images/g.gif" > 
                                <%end if%>
                              </td>
                            </tr>
                          </table>
                        </div></td>
                    </tr>
                    <%

rs3.MoveNext
wend
%>
                    <tr> 
                      <td width=100% height="19" align=right bgcolor="#C4E8FF"><a class=class href='bigClassdeta.asp?typeid=<%=typeid%>&BigClassid=<%=BigClassid%>'><img src="images/more.gif" border="0" alt="更多<%=BigClassName%>"></a>&nbsp;&nbsp;</td>
                    </tr>
                  </table>
                  <%
end if
next
'rs3.close
'set rs3=nothing
else 
Response.Write "<table width=98% border=0 height=25><tr><td>暂无大类</td></tr></table>"
end if
%>
                  <%else%>
                  <%
  if rseof=1 then
for i=1 to RecordCount
BigClassID=ArrayBigClassID(i)
BigClassName=ArrayBigClassName(i)
BigClassview=ArrayBigClassview(i)
if ArrayBigClassView(i)=1 then 
%>
                  <table border="0" cellpadding="3" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber5" bgcolor="#C4E8FF">
                    <tr> 
                      <td height="25" background="imgs/2.jpg" bgcolor="#C4E8FF">&nbsp;<img src=IMAGES/POINT1.GIF width="13" height="13">&nbsp;<font class=m_tittle><%=BigClassName%></font></td>
                    </tr>
                    <%
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 top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1) order by newsid DESC"
end if
if Request.cookies("key")="" then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & 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 top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel<=3) order by newsid DESC"
	end if
	if Request.cookies("reglevel")=2 then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel<=2) order by newsid DESC"
	end if
	if Request.cookies("reglevel")=1 then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel<=1) order by newsid DESC"
	end if
end if
else
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1) order by newsid DESC"
end if
rs3.Open rs3.Source,conn,1,1
while not rs3.EOF
if showyear=1 then
newsurl="ReadNews.asp?NewsID=" & rs3("NewsID")
datetime="<font class=middle>(" & year(rs3("UpdateTime"))  &"年"& Month(rs3("UpdateTime"))  &"月"& Day(rs3("UpdateTime")) &"日)</font>"
else
newsurl="ReadNews.asp?NewsID=" & rs3("NewsID")
datetime="<font class=middle>("& Month(rs3("UpdateTime"))  &"月"& Day(rs3("UpdateTime")) &"日)</font>"
end if
if rs3("picnews")=1 then
img="<img src=""IMAGES/IMG.gif"">"
else
img=""
end if
title=trim(rs3("title"))
title=replace(title,"<br>","")
%>
                    <tr> 
                      <td height=18 bgcolor="#C4E8FF">&nbsp;&nbsp;<img src="IMAGES/006.gif" width="8" height="10"><a class=middle href="<%=newsurl%>" title="<%=title%>"   onclick="return ow(this)" target="_blank"> 
                        <%if mode="2" then%>
                        <%=img%> 
                        <%end if%>
                        <font color="<%=rs3("titlecolor")%>"> 
                        <%if len(title)>60 then%>
                        <%=left(title,60)%>... 
                        <%else%>
                        <%=title%> 
                        <%end if%>
                        </font></a><br> &nbsp;&nbsp;&nbsp;&nbsp;简介: 
                        <%if len(rs3("content"))>250 then%>
                        <%=left(rs3("content"),250)%>... 
                        <%else%>
                        <%=trim(rs3("content"))%> 
                        <%end if%>
                        <%if showtime="1" then%>
                        <%=datetime%> 
                        <%end if%>
                        <%if showclick="1" then%>
                        <font color=#666666>[<%=rs3("click")%>]</font> 
                        <%end if%>
                        <%if year(rs3("updatetime"))=year(date()) and month(rs3("updatetime"))=month(date()) and day(rs3("updatetime"))=day(date()) then%>
                        <img src="images/new.gif"> 
                        <%end if%>
                        <%if rs3("goodnews")="1" then%>
                        <img src="images/g.gif" > 
                        <%end if%>
                      </td>
                    </tr>
                    <%

rs3.MoveNext
wend
%>
                    <tr> 
                      <td width=100% align=right height=18 bgcolor="#C4E8FF"><a class=class href='bigClassdeta.asp?typeid=<%=typeid%>&BigClassid=<%=BigClassid%>'><img src="images/more.gif" border="0" alt="更多<%=BigClassName%>"></a>&nbsp;&nbsp;</td>
                    </tr>
                  </table>
                  <%
end if
next
'rs3.close
'set rs3=nothing
else 
Response.Write "<table width=98% border=0 height=25><tr><td>暂无大类</td></tr></table>"
end if
%>
                  <%end if%>
                
                  <%end if%>
                
                </td>
                    <td valign="top" width="12">
					 </td>
                  </tr>
              </table></td>
            </tr>
            <tr>
              <td height="4" bgcolor="#64C2FD">
				<img src="imgs/new_bg01.jpg" width="9" height="4"></td>
            </tr>
          </table>
        	</div>
        </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>

⌨️ 快捷键说明

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