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

📄 oa_info.asp

📁 一个比较完整的企业erp系统
💻 ASP
字号:
<!--#include file="../inc/conn.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">
</head>

<body>
<%
dim id
id=replacebadchar(request("oa_id"))
dim sql,rs 


Set rs = Server.CreateObject("ADODB.Recordset")
sql="Select oa_id,oa_title,oa_content,oa_author,uploadfiles,filename,filecount,filesize,fileext,oa_updatetime,oa_fruit from [oa_data] where oa_id="&id
rs.open sql,conn,1,3
if rs.bof and rs.eof then 
response.write("<font color='#FF0000'>未找到相关文件!</font>")

   else
%>
<table width="700" border="0" align="center" cellpadding="0" cellspacing="0"  >
  <tr>
    <td height="45" colspan="3"><div align="center"><strong><font color="#990000" size="+2"><%=rs("oa_title")%></font></strong></div></td>
  </tr>
  <tr> 
    <td height="45" colspan="3"><div align="center"><strong>发文部门:</strong><%=rs("oa_author")%> 
        &nbsp;<strong>发文时间:</strong> <%=rs("oa_updatetime")%></div></td>
  </tr>
  <tr> 
    <td width="60" rowspan="2">公文</td>
    <td height="51">公文说明</td>
    <td height="51"> 
      <table width="500" border="0" align="center" cellpadding="0" cellspacing="0"  style="table-layout:fixed;word-break:break-all;">
        <tr>
          <td><%=rs("oa_content")%></td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td width="96" height="51">公文附件</td>
    <td width="544"> 
      <%   dim  filename0,oa_file,i
	  
  	if instr(rs("uploadfiles"),"|")>0 then
	       filename0=right(rs("uploadfiles"),len(rs("uploadfiles"))-1)
			filename=split(filename0,"|")
		for i=0 to ubound(filename)%>
      <a href="oa_file.asp?id=<%=rs("oa_id")%>-<%=i+1%>" )>公文附件<%=i+1%> </a> &nbsp; 
      <%		next		
  else
  	 response.write("此公文无附件!" )
end if
	%>
    </td>
  </tr>
</table>
<table width="700" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
  <%
			dim Q_Rs,Q_sql,Q_Found
			Q_Found=false
     set Q_rs=Server.CreateObject("ADODB.RECORDSET")
     Q_sql="Select reply_id,oa_id,username,reply_time,ip from [Reply_data] where username='"&Trim(Request.Cookies("ye51")("School"))&"' and oa_id="&id&""
     Q_rs.open Q_sql,conn,1,3 
	 if not ( Q_Rs.bof and  Q_Rs.eof) then  
     Q_Found=True
	 end if
  %>
    <td height="27"><div align="center"> 
        <%if Q_Found=false then%>
        <font color="#FF3300">[</font><a href="../OA_Reply/oa_reply.asp?oa_id=<%=rs("oa_id")%>" onClick="javascript:return confirm('已完全阅读,签收<%=rs("oa_title")%>文件!')"><font color="#FF0000">公文签收</font></a><font color="#FF3300">]</font> 
        <%else%>
        <font color="#0033FF">该文件你已于<%=Q_rs("reply_time")%>签收!</font> 
        <%end if%>
        [<a href="../OA_Reply/Reply_Show.asp?oa_id=<%=rs("oa_id")%>" >查看签收情况</a>]
      </div></td>
  </tr>
</table>
<%
end if

rs.close
set rs=nothing
call CloseConn()
%>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -