guidangdetail.asp

绿叶oa系统办公自动化 2008.工作日志管理,文件管理

<%
Response.ExpiresAbsolute=now()-1
Response.CacheControl="no-cache"
%>
<%
on error resume next
Dim StartTime,EndTime
StartTime=timer() '创建一个计时器,单位：毫秒,页面开始执行时间
%>
<%server.ScriptTimeout=1800%>
<%
' *** Restrict Access To Page: Grant or deny access to this page
MM_authorizedUsers=""
MM_authFailedURL="../../index.asp"
MM_grantAccess=false
If Session("userssdfgfhtrh") <> "" Then
  If (true Or CStr(Session("MM_UserAuthorization"))="") Or _
         (InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then
    MM_grantAccess = true
  End If
End If
If Not MM_grantAccess Then
  MM_qsChar = "?"
  If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&"
  MM_referrer = Request.ServerVariables("URL")
  if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString()
  MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer)
  Response.Redirect(MM_authFailedURL)
End If
%>
<!--#include file="../../Connections/oavbsconn.asp" -->
<%
Dim r__d
r__d = "1"
If (request("id") <> "") Then 
  r__d = request("id")
End If
%>
<%
Dim r
Dim r_numRows
Set r = Server.CreateObject("ADODB.Recordset")
r.ActiveConnection = MM_oavbsconn_STRING
r.Source = "SELECT *,归档收发文db.备注 as bz,归档收发文db.id as ids  FROM shouwen left join 归档收发文db on shouwen.id=归档收发文db.收发文ID  WHERE  shouwen.id=" + Replace(r__d, "'", "''") + ""
r.CursorType = 0
r.CursorLocation = 2
r.LockType = 3
r.Open()
r_numRows = 0
%>
<%if not r.eof or not r.bof then
dim id
id=r("id")
end if%>
<%
Dim Recordset11__d
Recordset11__d = "1"
If (request("id") <> "") Then 
  Recordset11__d = request("id")
End If
%>
<%
Dim Recordset11
Dim Recordset11_numRows
Set Recordset11 = Server.CreateObject("ADODB.Recordset")
Recordset11.ActiveConnection = MM_oavbsconn_STRING
Recordset11.Source = "SELECT shouwenfiles.文件名,shouwenfiles.文件路径,shouwenfiles.id,shouwenfiles.邮件编号,文件上传时间,上传人姓名,上传人部门  FROM shouwen inner join shouwenfiles on shouwenfiles.邮件编号=shouwen.id  WHERE  shouwen.id=" + Replace(Recordset11__d, "'", "''") + "  ORDER BY shouwen.id desc"
Recordset11.CursorType = 0
Recordset11.CursorLocation = 2
Recordset11.LockType = 1
Recordset11.Open()
Recordset11_numRows = 0
%>
<%
Dim jimi
Dim jimi_numRows
Set jimi = Server.CreateObject("ADODB.Recordset")
jimi.ActiveConnection = MM_oavbsconn_STRING
jimi.Source = "SELECT * FROM 机密程度"
jimi.CursorType = 0
jimi.CursorLocation = 2
jimi.LockType = 1
jimi.Open()
jimi_numRows = 0
%>

<%
Dim Recordset2__d
Recordset2__d = "1"
If (request("id")   <> "") Then 
  Recordset2__d = request("id")  
End If
%>
<%
Dim Recordset2
Dim Recordset2_numRows

Set Recordset2 = Server.CreateObject("ADODB.Recordset")
Recordset2.ActiveConnection = MM_oavbsconn_STRING
Recordset2.Source = "SELECT *  FROM shouwenyijian  WHERE 审批iD=" + Replace(Recordset2__d, "'", "''") + " and 意见类型='审稿'  ORDER BY 最后更新时间 desc ,ID DESC"
Recordset2.CursorType = 0
Recordset2.CursorLocation = 2
Recordset2.LockType = 1
Recordset2.Open()

Recordset2_numRows = 0
%>
<%
Dim Recordset1__d
Recordset1__d = "1"
If (request("id")   <> "") Then 
  Recordset1__d = request("id")  
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_oavbsconn_STRING
Recordset1.Source = "SELECT *  FROM shouwenyijian  WHERE 审批iD=" + Replace(Recordset1__d, "'", "''") + " and 意见类型='签阅'  ORDER BY 最后更新时间 desc ,ID DESC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>
<%
Dim Recordset3__d
Recordset3__d = "1"
If (request("id")   <> "") Then 
  Recordset3__d = request("id")  
End If
%>
<%
Dim Recordset3
Dim Recordset3_numRows

Set Recordset3 = Server.CreateObject("ADODB.Recordset")
Recordset3.ActiveConnection = MM_oavbsconn_STRING
Recordset3.Source = "SELECT *  FROM shouwenyijian  WHERE 审批iD=" + Replace(Recordset3__d, "'", "''") + " and 意见类型='办理'  ORDER BY 最后更新时间 desc ,ID DESC"
Recordset3.CursorType = 0
Recordset3.CursorLocation = 2
Recordset3.LockType = 1
Recordset3.Open()

Recordset3_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = -1
Repeat1__index = 0
Recordset11_numRows = Recordset11_numRows + Repeat1__numRows
%>
<%
Dim Repeat4__numRows
Dim Repeat4__index

Repeat4__numRows = -1
Repeat4__index = 0
Recordset3_numRows = Recordset3_numRows + Repeat4__numRows
%>
<%
Dim Repeat3__numRows
Dim Repeat3__index

Repeat3__numRows = -1
Repeat3__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat3__numRows
%>
<%
Dim Repeat2__numRows
Dim Repeat2__index

Repeat2__numRows = -1
Repeat2__index = 0
Recordset2_numRows = Recordset2_numRows + Repeat2__numRows
%>
<%
function HTMLEncode(fString)
	fString = replace(fString, ">", "&gt;")
	fString = replace(fString, "<", "&lt;")
	fString = Replace(fString, CHR(13), "")
	fString = replace(fString,chr(32),"&nbsp;")
	fString = Replace(fString, CHR(10) & CHR(10), "</P><P>")
	fString = Replace(fString, CHR(10), "<BR>")
	HTMLEncode = fString
end function
%>
<html>
<head>
<script language="JavaScript" src="swfj.js"></script>
<script language="JavaScript" src="shouwen.js"></script>
<script language=javascript>


var upfj;
upfj=0;           //上传附件没有错误
//--------------------------------send fujian file------------------------------
function sendfj(fileid){
   var NameUrl="<%=NameUrl%>"               //保存公文文件url路径
	var FjUrl="<%=FjUrl%>"                  //保存附件文件url路径
	var FjDelUrl="<%=FjDelUrl%>"                  //上传失败删除临时文件
	var MaxSize="<%=session("MaxSize")%>"   //限制上传附件文件的大小 
	var fileform = document.submitinput;
	PsoPath=fileform.elements[fileid].value
	//PsoPath=document.submitinput.filefj0.value
	PsoFile=PsoPath                     //定义附件的文件名
	PsoType=""
    while(PsoFile.indexOf("\\")>0)             //获得附件的文件名
    { 
     i = PsoFile.indexOf("\\") 
     PsoFile = PsoFile.substring(i + 1, PsoFile.length); 
    }                                //获得附件的文件名
	                    
	 PsoPath=PsoPath.substring(0,PsoPath.lastIndexOf("\\"))   //获得附件的路径
	 PsoType=PsoFile
	 if (PsoType.lastIndexOf(".")>0)              //获得附件的扩展名
     { 
     i = PsoType.lastIndexOf(".") 
     PsoType = PsoType.substring(i + 1, PsoType.length); 
     } 

   result=form.web.upload(FjUrl,PsoFile,PsoPath,MaxSize)  //向服务器上传附件
   //document.submitinput.fujian.value=PsoFile
  if (!result)
  {
  
   result=form.web.sendurl(FjDelUrl,"","");             //删除前面上传的临时文件
   alert("上传附件失败或附件不存在！");
   fileform.elements[fileid].focus();
   upfj=1;
   return false;                             //上传附件失败，返回起草公文页面
   }
   else{
   result=form.web.sendurl(NameUrl,PsoFile,PsoType)
   }
     
}
//------------------end function-------------------------------------------------------
function checkform() {
upfj=0;
//-------发送附件
var fileform = document.submitinput;              //调用上传附件函数
	for ( var i= 0 ; i <fileform.elements.length ; i ++ ) {				    
		if ( fileform.elements[i].type == "file" && fileform.elements[i].name !="file" ) {
			if (fileform.elements[i].value!="") {
				sendfj(i);