📄 list_all_f.asp
字号:
<!--#include file="conn.inc"-->
<%
sql_y="select year(d_date) as 年份 from document where kind='发文' group by year(d_date)"
set rs_y=server.createobject("adodb.recordset")
rs_y.open sql_y,conn,3,2
if request("s_year")<>"" then
sql="select zi,count(id) as shumu from document where kind='发文' and year(d_date)="&request("s_year")&" group by zi"
rs.open sql,conn,3,2
end if
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>公文管理——公文（发文）浏览</title>
<style>p, td, input, select { font-size: 9pt }
.button01 { background-color: #D0D7AF; border: 1 solid #999966 }
a:visited { text-decoration: none; color: #000000 }
a:active { text-decoration: none; color: #ff0000 }
a:hover { text-decoration: underline; color: #ff0000 }
a:link { text-decoration: none; color: #000000 }
</style>
</head>
<body bgcolor="#EAEDDC">
<table border="0" width="100%">
<tr>
<td width="100%">您正在浏览的是类别为“发文”的公文：</td>
</tr>
</table>
<table border="0" width="100%">
<tr>
<td width="100%">
<%
do while not rs_y.eof
%>
<a href="list_all_f.asp?s_year=<%=rs_y("年份")%>"><%=rs_y("年份")%>年</a>|
<%
rs_y.movenext
loop
%>
</td>
</tr>
</table>
<%
if request("s_year")<>"" then
%>
<table border="0" width="757" cellspacing="1" cellpadding="0" height="25" bgcolor="#808000">
<tr height="25">
<td bgcolor="#D0D7AF" width="46">
<p align="center">序号</p>
</td>
<td bgcolor="#D0D7AF" width="255">
<p align="center">文 件 字 号</td>
<td bgcolor="#D0D7AF" width="442">
<p align="center">数 据 汇 总</td>
</tr>
<%
i=1
do while not rs.eof
%>
<tr height="25" bgcolor="#F2F2F2">
<td width="46"><center><%=i%></center></td>
<td width="255"><center><a href="mulu_f.asp?s_year=<%=request("s_year")%>&s_zi=<%=rs("zi")%>" target="_blank"><%=rs("zi")%></a></center></td>
<td width="442"><center>此分类共有文件 <%=rs("shumu")%> 份<center></center></center></td>
</tr>
<%
rs.MoveNext
i=i+1
loop
%>
</table>
<%
end if
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -