 |
| <%sql="select * from board"
rs.open sql,conn,1,1
content=rs("content")
rs.close%>
|
|
|
 |
<%sql="select top 10 * from news order by news_id desc"
rs.open sql,conn,1,1%>
|
|
 |
<%sql="select top 10 * from news order by hit desc"
rs.open sql,conn,1,1%>
|
|
 |
<%set rst=conn.execute("select count(*) from news")
count=rst(0)%>
| 文章总数: |
<%=count%>篇 |
<%set rst=nothing%>
<%set rst=conn.execute("select count(*) from news where ischeck=0")
count=rst(0)%>
| 待审文章: |
<%=count%>篇 |
<%set rst=conn.execute("select count(*) from member")
count=rst(0)%>
| 会员总数: |
<%=count%>人 |
<%set rst=nothing%>
<%set rst=conn.execute("select count(hit) from news")
count=rst(0)%>
| 浏览总数: |
<%=count%>次 |
|
|
 |
|
<%
set rst=conn.execute("SELECT * From shop_toupiao where IsChecked=1 ")
if rst.eof then
%>
暂无投票
<%else%>
|
<%end if%> |
 |
<%sql="select top 10 * from member order by news_count desc"
rs.open sql,conn,1,1%>
| |
名次 |
用户名 |
文章数 |
<%for i=0 to rs.recordcount%>
| |
<%=i%> |
<%=rs("user")%> |
<%=rs("news_count")%> |
<%rs.movenext
if rs.eof then exit for
next
rs.close%>
|
|
|
| 安全生产 |
|
自查汇报 综合治理 整改措施 消防技防 安全规范 事故认定 交通安全 校园安全 more |
|
|
|
| 演讲致辞 |
 |
<%big_class="演讲致辞"
sql="select top 7 * from news where big_class='"&big_class&"'"
rs.open sql,conn,1,1%>
|
|
| 工作报告 |
|
<%big_class="工作报告"
sql="select top 7 * from news where big_class='"&big_class&"'"
rs.open sql,conn,1,1%>
|
|
| 工作总结 |
|
<%big_class="工作总结"
sql="select top 7 * from news where big_class='"&big_class&"'"
rs.open sql,conn,1,1%>
|
|
| 领导讲话 |
|
<%big_class="领导讲话"
sql="select top 7 * from news where big_class='"&big_class&"'"
rs.open sql,conn,1,1%>
|
|
| 各种材料 |
|
<%big_class="各种材料"
sql="select top 7 * from news where big_class='"&big_class&"'"
rs.open sql,conn,1,1%>
|
|
| 心得体会 |
|
<%big_class="心得体会"
sql="select top 7 * from news where big_class='"&big_class&"'"
rs.open sql,conn,1,1%>
|
|
| 论文世界 |
|
<%big_class="论文世界"
sql="select top 7 * from news where big_class='"&big_class&"'"
rs.open sql,conn,1,1%>
|
|
| 党团工队 |
|
<%big_class="党团工队"
sql="select top 7 * from news where big_class='"&big_class&"'"
rs.open sql,conn,1,1%>
|
|
| 创卫创模 |
|
<%big_class="创卫创模"
sql="select top 7 * from news where big_class='"&big_class&"'"
rs.open sql,conn,1,1%>
|
|
| 安全生产 |
|
<%big_class="安全生产"
sql="select top 7 * from news where big_class='"&big_class&"' order by news_id desc"
rs.open sql,conn,1,1%>
|
|
| 常用公文 |
|
<%big_class="常用公文"
sql="select top 7 * from news where big_class='"&big_class&"' order by news_id desc"
rs.open sql,conn,1,1%>
|
|
| 综合文艺 |
|
<%big_class="综合文艺"
sql="select top 7 * from news where big_class='"&big_class&"' order by news_id desc"
rs.open sql,conn,1,1%>
|
|
|
