📄 news.asp
字号:
<!--#include file="conn.inc"-->
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>新建网页 2</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 instr(request.cookies("spower"),"A") 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 + -