?? 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>新建網(wǎng)頁 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")%>">現(xiàn)在審批</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>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -