doshenforqianyeu.asp

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

<%@LANGUAGE="VBSCRIPT"%>
<%  
Response.ExpiresAbsolute=now()-1
Response.CacheControl="no-cache"
%>
<%
on error resume next
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 s__u
s__u = "1"
If (session("names")  <> "") Then 
  s__u = session("names") 
End If
%>
<%
Dim s
Dim s_numRows

Set s = Server.CreateObject("ADODB.Recordset")
s.ActiveConnection = MM_oavbsconn_STRING
s.Source = "SELECT fawenhuiqian.顺序 as s  FROM fawen inner join fawenhuiqian on fawenhuiqian.发文id=fawen.id  WHERE fawenhuiqian.会签人='" + Replace(s__u, "'", "''") + "'"
s.CursorType = 0
s.CursorLocation = 2
s.LockType = 1
s.Open()

s_numRows = 0
%>
<%if not s.eof or not s.bof then
dim ss
ss=s("s")
end if%>
<%
Dim r__ss
r__ss = "1"
If (ss <> "") Then 
  r__ss = ss
End If
%>
<%
Dim r__MMColParam
r__MMColParam = "1"
If ("|"&session("names")      <> "") Then 
  r__MMColParam = "|"&session("names")     
End If
%>
<%
Dim r__u
r__u = "1"
If (session("names")    <> "") Then 
  r__u = session("names")   
End If
%>
<%
Dim r
Dim r_numRows

Set r = Server.CreateObject("ADODB.Recordset")
r.ActiveConnection = MM_oavbsconn_STRING
r.Source = "SELECT *,fawen.id as ids  FROM fawen inner join fawenhuiqian on fawenhuiqian.发文id=fawen.id  WHERE 签阅人 like '%" + Replace(r__MMColParam, "'", "''") + "%'  and 开关='是' and( fawenhuiqian.是否会签完毕='是' and 顺序<" + Replace(r__ss, "'", "''") + " and fawenhuiqian.会签人<>'" + Replace(r__u, "'", "''") + "' or (顺序=1 and fawenhuiqian.会签人='" + Replace(r__u, "'", "''") + "'))  ORDER BY 最后更新时间 desc,fawen.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%>
<%
Dim c__MMColParam
c__MMColParam = "1"
If (Request("ID") <> "") Then 
  c__MMColParam = Request("ID")
End If
%>
<%
Dim c
Dim c_numRows

Set c = Server.CreateObject("ADODB.Recordset")
c.ActiveConnection = MM_oavbsconn_STRING
c.Source = "SELECT  点击,备注  FROM fawen  WHERE ID = " + Replace(c__MMColParam, "'", "''") + ""
c.CursorType = 0
c.CursorLocation = 2
c.LockType = 3
c.Open()
c("点击")=c("点击")+1
b=c("备注")
c.update

c_numRows = 0
%>


<%
Dim Recordset11__MMColParam
Recordset11__MMColParam = "1"
If ("|"&session("names")    <> "") Then 
  Recordset11__MMColParam = "|"&session("names")   
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 fawenfiles.文件名,fawenfiles.文件路径,fawenfiles.id,fawenfiles.邮件编号  FROM fawen inner join fawenfiles on fawenfiles.邮件编号=fawen.id  WHERE 审稿人 like '%" + Replace(Recordset11__MMColParam, "'", "''") + "%' or 签阅人 like '%" + Replace(Recordset11__MMColParam, "'", "''") + "%' and fawen.id=" + Replace(Recordset11__d, "'", "''") + " and 开关='是'  ORDER BY fawen.id desc"
Recordset11.CursorType = 0
Recordset11.CursorLocation = 2
Recordset11.LockType = 1
Recordset11.Open()
Recordset11_numRows = 0
%>
<%
Dim Recordset3__u
Recordset3__u = "1"
If (Session("userssdfgfhtrh") <> "") Then 
  Recordset3__u = Session("userssdfgfhtrh")
End If
%>
<%
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 id  FROM fawenyijian  WHERE 审批人帐号='" + Replace(Recordset3__u, "'", "''") + "' and 审批id=" + Replace(Recordset3__d, "'", "''") + "  ORDER BY ID DESC"
Recordset3.CursorType = 0
Recordset3.CursorLocation = 2
Recordset3.LockType = 1
Recordset3.Open()

Recordset3_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 fawenyijian  WHERE 审批ID=" + Replace(Recordset2__d, "'", "''") + "  ORDER BY 最后更新时间 desc ,ID DESC"
Recordset2.CursorType = 0
Recordset2.CursorLocation = 2
Recordset2.LockType = 1
Recordset2.Open()

Recordset2_numRows = 0
%>
<%
Dim Recordset21__u
Recordset21__u = "1"
If (Session("userssdfgfhtrh") <> "") Then 
  Recordset21__u = Session("userssdfgfhtrh")
End If
%>
<%
Dim Recordset21
Dim Recordset21_numRows
Set Recordset21 = Server.CreateObject("ADODB.Recordset")
Recordset21.ActiveConnection = MM_oavbsconn_STRING
Recordset21.Source = "SELECT *  FROM xzgwqianmingdata  WHERE useriddsfs='" + Replace(Recordset21__u, "'", "''") + "' and applying='是'"
Recordset21.CursorType = 0
Recordset21.CursorLocation = 2
Recordset21.LockType = 1
Recordset21.Open()
Recordset21_numRows = 0
%>
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
If (Request("id") <> "") Then 
  Recordset1__MMColParam = Request("id")
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_oavbsconn_STRING
Recordset1.Source = "SELECT *  FROM fawenshenimg  WHERE 发文id = '" + Replace(Recordset1__MMColParam, "'", "''") + "'"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>

<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = -1
Repeat1__index = 0
Recordset11_numRows = Recordset11_numRows + Repeat1__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
%>
<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}