📄 oa_alist.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
strFileName="OA_NList.asp?"
if request("page")<>"" then
currentPage=cint(request("page"))
else
currentPage=1
end if
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"
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%>
<%
totalPut=rs.recordcount
if currentpage<1 then
currentpage=1
end if
if (currentpage-1)*MaxPerPage>totalput then
if (totalPut mod MaxPerPage)=0 then
currentpage= totalPut \ MaxPerPage
else
currentpage= totalPut \ MaxPerPage + 1
end if
end if
if currentPage=1 then
if found=false then
showContent
end if
response.write "<table class=border border=0 cellspacing=1 width=100% cellpadding=0><tr valign=middle class=tdbg><td>"
showpage strFileName,totalput,MaxPerPage,true,true,"份公文"
response.write "</td></tr></table>"
else
if (currentPage-1)*MaxPerPage<totalPut then
rs.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rs.bookmark
if found=false then
showContent
end if
response.write "<table class=border border=0 cellspacing=1 width=100% cellpadding=0><tr valign=middle class=tdbg><td>"
showpage strFileName,totalput,MaxPerPage,true,true,"份公文"
response.write "</td></tr></table>"
else
currentPage=1
if found=false then
showContent
end if
response.write "<table class=border border=0 cellspacing=1 width=100% cellpadding=0><tr valign=middle class=tdbg><td>"
showpage strFileName,totalput,MaxPerPage,true,true,"份公文"
response.write "</td></tr></table>"
end if
end if
end if
rs.Close
set rs=Nothing
call closeconn
sub showContent()
dim i
i=0
%>
<%
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 not Q_Rs.bof and not Q_Rs.eof then
found=true
end if
%>
<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>
<%
i=i+1
if i>=MaxPerPage then exit do
rs.movenext
loop
end sub
%>
</td>
</tr>
</table>
<!--#include file="../inc/bottom.asp"-->
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -