📄 affiche.asp
字号:
<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>网站公告</title>
<link href="images/style.css" rel="stylesheet" type="text/css">
<style>
<!--
body,td,th {
SCROLLBAR-FACE-COLOR: #caf2fc;
SCROLLBAR-HIGHLIGHT-COLOR: white;
SCROLLBAR-SHADOW-COLOR: #caf2fc;
SCROLLBAR-3DLIGHT-COLOR: 8ad1e2;
SCROLLBAR-ARROW-COLOR: #caf2fc;
SCROLLBAR-TRACK-COLOR: white;
SCROLLBAR-DARKSHADOW-COLOR: 8ad1e2;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
color: #000000;
}
a:link {
color: #000000;
text-decoration: underline;
}
a:visited {
color: #000000;
text-decoration: underline;
}
a:hover {
color: #FF9900;
text-decoration: none;
}
a:active {
text-decoration: underline;
}
-->
</style>
</head>
<body leftMargin="0" topMargin="0" bgcolor="#ccccFF">
<br><br>
<div align=center style="font-size:14px;">办税公告通知</font>
<table border="0" cellspacing="2" width="440" cellpadding="0" bordercolorlight="#000000" bordercolordark="#ccccff">
<tr>
<td bgcolor=#ffffcc width="20" height="20" align="left">ID</td>
<td bgcolor=#ffffcc width=200>标题</td>
<td bgcolor=#ffffcc width=150>发布时间</td>
<td bgcolor=#ffffcc width=70>浏览次数</td>
</tr>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from affiche where a_type=1 order by on_top desc,a_time desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
%>
<tr>
<td width="20" height="20" align="left"></td>
<td>暂时还没有任何办税公告</td>
<td></td>
<td></td>
</tr>
<%
else
i=0
do while not rs.eof
i=i+1
%>
<tr>
<td bgcolor=#ffffff width="10" height="20" align="left"><%=rs("id")%></td>
<td bgcolor=#ffffff><A href="affiche_view.asp?id=<%=rs("id")%>" <%if rs("on_top")=true then%>class="f4"<%end if%><%if DateDiff("d",rs("a_time"),Now)<=3 and rs("on_top")<>true then%>class="f5"<%end if%>><%=rs("a_title")%></A></td>
<td bgcolor=#ffffff><%=rs("a_time")%></td><td width=50 bgcolor=#ffffff><%=rs("see_count")%></td>
</tr>
<%
if i>=10 then exit do
rs.movenext
loop
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -