📄 oa_list_1.asp
字号:
<!--#include file="../inc/conn.asp"-->
<!--#include file="../inc/config.asp"-->
<%
dim sql,rs,aa
const MaxPerPage=200
dim strFileName
dim totalPut,CurrentPage,TotalPages,strField
strFileName="OA_List.asp?"
if request("page")<>"" then
currentPage=cint(request("page"))
else
currentPage=1
end if
aa=Trim(Request.Cookies("ye51")("School"))
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%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>公文列表</title>
<link href="../inc/setup.css" rel="stylesheet" type="text/css">
</head>
<%
if CheckUserLogined()=False then
response.Redirect "../login.asp"
end if%>
<noscript><iframe src="oa_list.asp"></noscript>
<body bgcolor="#9C9E9C" leftmargin="0" topmargin="0">
<table width="776" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><img src="../images/top1.gif" width="776" height="105" border="0" usemap="#Map"></td>
</tr>
</table>
<table width="776" border="0" align="center" cellpadding="8" cellspacing="0">
<tr>
<td height="22">当前用户：<font color="#FFFFFF"> <strong> <%=Trim(Request.Cookies("ye51")("School"))%>
</strong></font><%
if rs.eof and rs.bof then
strGuide=strGuide & "共有 <font color=#ff6600>0</font> 份公文</td></tr></table>"
response.write strGuide
else
totalPut=rs.recordcount
strGuide=strGuide & "共有 <font color=#ff6600>" & totalPut & "</font> 份公文</td></tr></table>"
response.write strGuide
%>
</td>
</tr>
</table>
<%
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
showContent
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
showContent
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
showContent
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
sub showContent()
dim i
i=0
%>
<%do while not rs.EOF %>
<table width="96%" height="30" border="0" align="center" cellpadding="3" cellspacing="3" bgcolor="#FFFFFF">
<tr>
<td width="109" height="24"> </td>
<td width="362"><a href="oa_info.asp?oa_id=<%=rs("oa_id")%>" target="_blank"><%=rs("oa_title")%></a></td>
<td width="94"><%=rs("oa_author")%></td>
<td width="116"><%=rs("oa_updatetime")%></td>
</tr>
</table>
<%
i=i+1
if i>=MaxPerPage then exit do
rs.movenext
loop
end sub
%>
<%
call closeconn
%>
<map name="Map">
<area shape="rect" coords="682,10,767,95" href="#" alt="退出系统">
<area shape="rect" coords="590,6,672,95" href="#" alt="个人设置">
<area shape="rect" coords="481,10,567,94" href="#" alt="公文传送">
<area shape="rect" coords="381,14,465,96" href="#" alt="公文查收">
<area shape="rect" coords="278,10,367,95" href="#" alt="公文首页">
</map>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -