📄 news.asp
字号:
<!--#include file="conn.inc"
'连接数据库
-->
<html>
<head>
<title>新建网页</title>
<link rel="stylesheet" type="text/css" href="css.css">
</head>
<body>
<table border="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td width="100%" height="30" style="border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; border-top-style: solid; border-top-width: 0; border-bottom: 1px solid #000000">
<img border="0" src="images/news.jpg"></td>
</tr>
<%
sql="select * from waitforpass where havepass=1 and objname='新闻'"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
do while not rs.eof
sql1="select * from exam_news where newsid="& rs("objid")
set rs1=server.createobject("adodb.recordset")
rs1.open sql1,conn,3,2
'打开新闻内容表
%>
<tr>
<td width="100%" height="30"><img border="0" src="images/bluebullet.gif">
<a href="viewnews.asp?newsid=<%=rs1("newsid")%>"><%=rs1("title")%></a> [<%=formatdatetime(rs1("fabsj"),1)%>]
<%
if (date()-rs1("fabsj"))<3 then
%> <img border="0" src="images/new.gif"> <%
end if
%> </td>
</tr>
<% '显示新闻标题
rs1.close
rs.movenext
loop %>
<tr>
<td width="100%"> </td>
</tr>
</table>
<%
if request.cookies("userid")<>"" then
'如果是已经登录的领导,判断是否有需要审批的信息
rs.close
sql="select * from waitforpass where havepass=0 and passuserid="& request.cookies("userid")
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
if not rs.eof then
%>
<table border="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
<tr>
<td width="100%" style="border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; border-top-style: solid; border-top-width: 0; border-bottom: 1px solid #000000">
<img border="0" src="images/tishi.gif"></td>
</tr>
<%
do while not rs.eof
%>
<tr>
<td width="100%" height="30"><img border="0" src="images/blue.gif"> 有一项<font color="#ff0000"><%=rs("objname")%></font>需要您审批。<a href="passit.asp?id=<%=rs("id")%>&objid=<%=rs("objid")%>">现在审批</a></td>
</tr>
<%
rs.movenext
loop
%>
</table>
<%
end if
end if
%>
<%
if request.cookies("ifadmin")="True" then
'如果是已经登录的管理员,判断是否有管理员信息
rs.close
sql="select * from waitforpass where havepass=0"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
if not rs.eof then
%>
<table border="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
<tr>
<td width="100%" style="border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; border-top-style: solid; border-top-width: 0; border-bottom: 1px solid #000000">
<img border="0" src="images/tishi.gif"></td>
</tr>
<%
do while not rs.eof
%>
<tr>
<td width="100%" height="30"><img border="0" src="images/blue.gif"> 有一项<font color="#ff0000"><%=rs("objname")%></font>[编号：<%=rs("objid")%>]没有通过审批。<a href="unpassit.asp?id=<%=rs("id")%>&objname=<%=rs("objname")%>&objid=<%=rs("objid")%>">作废</a></td>
</tr>
<%
rs.movenext
loop
%>
</table>
<%
end if
end if
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -