📄 oa_nlist.asp
字号:
<%@language="vbscript" codepage="936" %>
<!--#include file="../inc/conn.asp"-->
<!--#include file="../inc/config.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>常州新北学区公文流转-公文管理</title>
<link href="../inc/setup.css" rel="stylesheet" type="text/css">
<link href="../inc/textbox.css" rel="stylesheet" type="text/css">
<link href="../inc/setup.css" rel="stylesheet" type="text/css">
<link href="../inc/textbox.css" rel="stylesheet" type="text/css">
<table cellpadding="6" cellspacing="1" border="0" width="100%" align=center>
<tr bgcolor=ffffff>
<th width="100%" height=12 align="center" bgcolor="ffffff">未签收公文</th>
</tr>
</table>
</head>
<%
if CheckUserLogined()=False then
response.Redirect "../login.asp"
end if%>
<body leftmargin="0" topmargin="0" >
<!--#include file="../inc/top1.asp"-->
<table width="776" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="592" valign="top" >
<table width="90%" border="0" align="center" cellpadding="10" cellspacing="0">
<tr>
<td height="27"><font color="#990000">未签收公文</font></td>
</tr>
</table>
<%
dim sql,rs,aa,id
dim Q_Rs,Q_sql,OA_Fruit1,found
found=false
const MaxPerPage=200
dim strFileName
dim totalPut,CurrentPage,TotalPages,strField
aa=Trim(Request.Cookies("ye51")("School"))
if aa="" or isnull(aa) then
aa=Session("ManageName")
end if
sql="Select oa_id,oa_title,oa_content,oa_author,uploadfiles,filename,filecount,filesize,fileext,oa_updatetime,oa_fruit from [oa_data] where oa_fruit like '%"& aa &"%' order by oa_updatetime desc"
'response.write sql
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
if rs.bof and rs.eof then
%>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="24"><font color="#FF3300">暂未找到相关文件！</font></td>
</tr>
</table>
<%else
do while not rs.EOF
id =rs("oa_id")
set Q_rs=Server.CreateObject("ADODB.RECORDSET")
Q_sql="Select reply_id,oa_id,username,reply_time,ip from [Reply_data] where username='"&aa&"' and oa_id="&id&""
Q_rs.open Q_sql,conn,1,3
if Q_rs.bof and Q_rs.eof then
%> <table width="95%" height="30" border="0" align="center" cellpadding="3" cellspacing="3" onMouseOver=this.style.backgroundColor='#F2f2f2'; this.style.cursor='hand'; onMouseOut=this.style.backgroundColor='';>
<tr>
<td width="9" height="24"> </td>
<td width="274"><a href="oa_info.asp?oa_id=<%=rs("oa_id")%>" ><%=rs("oa_title")%></a></td>
<td width="70"><%=rs("oa_author")%></td>
<td width="81"><%=rs("oa_updatetime")%></td>
<td width="83"><a href="../OA_Reply/Reply_Show.asp?oa_id=<%=rs("oa_id")%>" >查看签收情况</a></td>
</tr>
</table>
<% end if
rs.movenext
loop
Q_rs.close
set Q_rs=nothing
end if
rs.Close
set rs=Nothing
call closeconn
%>
</td>
</tr>
</table>
<!--#include file="../inc/bottom.asp"-->
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -