doshenpideatilvbgf.asp

来自「绿叶oa系统办公自动化 2008.工作日志管理,文件管理」· ASP 代码 · 共 626 行 · 第 1/2 页

<%  
Response.ExpiresAbsolute=now()-1
Response.CacheControl="no-cache"
%>
<%on error resume next
' *** 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__MMColParam
r__MMColParam = "1"
If ("|"&session("names")    <> "") Then 
  r__MMColParam = "|"&session("names")   
End If
%>
<%
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 *  FROM shouwen  WHERE (审稿人 like '%" + Replace(r__MMColParam, "'", "''") + "%' or 办理人 like '%" + Replace(r__MMColParam, "'", "''") + "%'or 签阅人 like '%" + Replace(r__MMColParam, "'", "''") + "%') and shouwen.id=" + Replace(r__d, "'", "''") + " and 开关='是'  ORDER BY shouwen.id desc"
r.CursorType = 0
r.CursorLocation = 2
r.LockType = 3
r.Open()


r_numRows = 0
%>
<%if not r.bof or not r.eof then
geter=(r.Fields.Item("接收人").Value)
r("点击")=r("点击")+1
r.update
dim b
b=r("备注")

%>
<%
Dim r11__MMColParam
r11__MMColParam = "1"
If ("|"&session("names")    <> "") Then 
  r11__MMColParam = "|"&session("names")   
End If
%>
<%
Dim r11__d
r11__d = "1"
If (request("id") <> "") Then 
  r11__d = request("id")
End If
%>
<%
Dim r11
Dim r11_numRows

Set r11 = Server.CreateObject("ADODB.Recordset")
r11.ActiveConnection = MM_oavbsconn_STRING
r11.Source = "SELECT shouwenfiles.文件名,shouwenfiles.文件路径,shouwenfiles.id,shouwenfiles.邮件编号,文件上传时间,上传人姓名,上传人部门  FROM shouwen inner join shouwenfiles on shouwenfiles.邮件编号=shouwen.id  WHERE (审稿人 like '%" + Replace(r11__MMColParam, "'", "''") + "%' or 办理人 like '%" + Replace(r11__MMColParam, "'", "''") + "%'or 签阅人 like '%" + Replace(r11__MMColParam, "'", "''") + "%') and shouwen.id=" + Replace(r11__d, "'", "''") + " and 开关='是'  ORDER BY shouwen.id desc"
r11.CursorType = 0
r11.CursorLocation = 2
r11.LockType = 1
r11.Open()

r11_numRows = 0
%>
<%
Dim r3__u
r3__u = "1"
If (Session("userssdfgfhtrh") <> "") Then 
  r3__u = Session("userssdfgfhtrh")
End If
%>
<%
Dim r3__d
r3__d = "1"
If (request("id") <> "") Then 
  r3__d = request("id")
End If
%>
<%
Dim r3
Dim r3_numRows

Set r3 = Server.CreateObject("ADODB.Recordset")
r3.ActiveConnection = MM_oavbsconn_STRING
r3.Source = "SELECT id  FROM shouwenyijian  WHERE 审批人帐号='" + Replace(r3__u, "'", "''") + "' and 审批id=" + Replace(r3__d, "'", "''") + "  ORDER BY ID DESC"
r3.CursorType = 0
r3.CursorLocation = 2
r3.LockType = 1
r3.Open()

r3_numRows = 0
%>
<%
Dim r2__d
r2__d = "1"
If (request("id") <> "") Then 
  r2__d = request("id")
End If
%>
<%
Dim r2
Dim r2_numRows

Set r2 = Server.CreateObject("ADODB.Recordset")
r2.ActiveConnection = MM_oavbsconn_STRING
r2.Source = "SELECT *  FROM shouwenyijian  WHERE 审批ID=" + Replace(r2__d, "'", "''") + "  ORDER BY 最后更新时间 desc ,ID DESC"
r2.CursorType = 0
r2.CursorLocation = 2
r2.LockType = 1
r2.Open()

r2_numRows = 0
%>
<%
Dim r21__u
r21__u = "1"
If (Session("userssdfgfhtrh") <> "") Then 
  r21__u = Session("userssdfgfhtrh")
End If
%>
<%
Dim r21
Dim r21_numRows
Set r21 = Server.CreateObject("ADODB.Recordset")
r21.ActiveConnection = MM_oavbsconn_STRING
r21.Source = "SELECT *  FROM xzgwqianmingdata  WHERE useriddsfs='" + Replace(r21__u, "'", "''") + "' and applying='是'"
r21.CursorType = 0
r21.CursorLocation = 2
r21.LockType = 1
r21.Open()
r21_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
r11_numRows = r11_numRows + Repeat1__numRows
%>
<%
Dim Repeat2__numRows
Dim Repeat2__index

Repeat2__numRows = -1
Repeat2__index = 0
Recordset1_numRows = Recordset1_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
%>
<style type="text/css">
<!--
.style36 {font-size: 13px;
	color: #FFFFFF;
	font-weight: bold;
}
.style5 {color: #FFFFFF}
-->
</style>
<link href="../../css/link1.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style2 {font-size: 13px}
.style39 {color: #FF0000}
.style38 {color: #FFFFFF;
	font-size: 14px;
	font-weight: bold;
}
.style40 {color: #009933}
.style41 {color: #999999}
body {
	margin-top: 2px;
}
-->
</style>
<script>
<!--
function dis(){
document.form1.submit.value='发送意见..'
document.form1.submit.disabled=true;
return true;
}
function check() {
if (document.form1.yijian.value=="") {
window.alert ("请您输入审批意见 ！")
document.form1.yijian.focus()
return false
}if (document.form1.yijian.value.length>65535) {
window.alert ("审批意见或结果字符超出数据库极限,系统最多接受65535个字符 ！")
document.form1.yijian.focus()
return false
}

return true
}
//-->
</SCRIPT>

<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><form name="form1" method="post" action="sentshengqinglistfsdghsforquesry.asp">
  <table width="100%" height="23" border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td width="5%"><div align="right">收文：</div></td>
      <td width="2%"><div align="right"><img src="../../img/txl/29.gif" width="16" height="16"></div></td>
      <td width="6%"><div align="right"><a href="../../toall/shouwen/sendgwfoxz.asp">收文拟稿</a></div></td>
      <td width="3%"><div align="right"><img src="../../img/txl/28.gif" width="16" height="16"></div></td>
      <td width="6%"><div align="right"><a href="../../toall/shouwen/sentshengqinglistfsdghs.asp">拟稿记录</a></div></td>
      <td width="3%"><div align="right"><img src="../../img/txl/15.gif" width="16" height="16"></div></td>
      <td width="6%"><div align="right"><a href="../../toall/shouwen/daishenlist.asp">待审收文</a></div></td>