⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 admin_oa_list.asp

📁 一个比较完整的企业erp系统
💻 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">
</head>
<%
if CheckUserLogined()=False then
	response.Redirect "../login.asp"
end if%>


<body leftmargin="0" topmargin="0" >
<!--#include file="../inc/top1.asp"-->
<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>
<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
const MaxPerPage=200
dim strFileName
dim totalPut,CurrentPage,TotalPages,strField
strFileName="Admin_OA_List.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_author= '"& 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
        	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="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="7" height="24">&nbsp;</td>
          <td width="216"><a href="oa_info.asp?oa_id=<%=rs("oa_id")%>" target="_blank"><%=rs("oa_title")%></a></td>
          <td width="83"><%=rs("oa_author")%></td>
          <td width="64"><%=rs("oa_updatetime")%></td>
          <td width="77"><a href="../OA_Reply/Reply_Show.asp?oa_id=<%=rs("oa_id")%>"  >查看签收情况</a></td>
          <td width="27"><a href="admin_oa_modi.asp?oa_id=<%=rs("oa_id")%>">修改</a></td>
          <td width="25"><a href="admin_oa_del.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 + -