?? list_all_f.asp
字號:
<!--#include file="conn.inc"-->
<%
sql_y="select year(d_date) as 年份 from document where kind='發(fā)文' 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='發(fā)文' 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>公文管理——公文（發(fā)文）瀏覽</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%">您正在瀏覽的是類別為“發(fā)文”的公文：</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">數(shù) 據(jù) 匯 總</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>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -