doshenpideatilvbgfforpintiny.asp
来自「绿叶oa系统办公自动化 2008.工作日志管理,文件管理」· ASP 代码 · 共 416 行
ASP
416 行
<%@LANGUAGE="VBSCRIPT"%>
<%
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 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 shouwenyijian 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 shouwenyijian 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 r1__MMColParam
r1__MMColParam = "1"
If ("|"&session("names") <> "") Then
r1__MMColParam = "|"&session("names")
End If
%>
<%
Dim r1__d
r1__d = "1"
If (request("id") <> "") Then
r1__d = request("id")
End If
%>
<%
Dim r1
Dim r1_numRows
Set r1 = Server.CreateObject("ADODB.Recordset")
r1.ActiveConnection = MM_oavbsconn_STRING
r1.Source = "SELECT id FROM shouwen WHERE 办理人 like '%" + Replace(r1__MMColParam, "'", "''") + "%' and shouwen.id=" + Replace(r1__d, "'", "''") + " ORDER BY shouwen.id desc"
r1.CursorType = 0
r1.CursorLocation = 2
r1.LockType = 3
r1.Open()
r1_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
Recordset2_numRows = Recordset2_numRows + Repeat2__numRows
%>
<%
function HTMLEncode(fString)
fString = replace(fString, ">", ">")
fString = replace(fString, "<", "<")
fString = Replace(fString, CHR(13), "")
fString = replace(fString,chr(32)," ")
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">
<!--
.style12 {font-size: 12px}
.style2 {font-size: 13px}
.style39 {color: #FF0000}
.style38 {color: #FFFFFF;
font-size: 14px;
font-weight: bold;
}
-->
</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%" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="6" height="20"><img src="/img/bbs/leftlin1red.gif" width="6" height="20"></td>
<td width="936" height="20" bgcolor="#FF3333"><div align="center" class="style38"><span class="style5"><span class="style13 style5 style6"><span class="style36">办 理 收 文 审 批 </span></span></span></div></td>
</tr>
</table>
<table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#FF0000">
<tr bgcolor="#FFFFFF">
<td width="9%"><div align="right">来文机关：</div></td>
<td width="45%"> <%=(r.Fields.Item("来文机关").Value)%> </td>
<td width="46%">来文字号 ： <%=(r.Fields.Item("来文字号").Value)%> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td><div align="right">来文日期： </div></td>
<td><div align="left"> <%=(r.Fields.Item("来文日期").Value)%> 收文日期： <%=(r.Fields.Item("收文日期").Value)%> </div></td>
<td> 办完日期： <%=(r.Fields.Item("办完日期").Value)%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><div align="right">事由：</div></td>
<td colspan="2"><%=HTMLEncode(r.Fields.Item("事由").Value)%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><div align="right">拟办意见：</div></td>
<td colspan="2"><%=HTMLEncode(r.Fields.Item("拟办意见").Value)%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><div align="right">领导批示：</div></td>
<td colspan="2"> <%
While ((Repeat2__numRows <> 0) AND (NOT Recordset2.EOF))
%>
<% If Not Recordset2.EOF Or Not Recordset2.BOF Then %>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr><%session("shenpiid")=r("id")%>
<td style="word-break:break-all;Width:fixed">
<hr width="95%" size="1" color="#5AAE18" height="1">
<div align="left"><%=HTMLEncode(Recordset2.Fields.Item("审批意见").Value)%> <br>
审批人：<a href="#" title="审批人:<%=Recordset2("审批人姓名")%> 部门:<%=Recordset2("审批人部门")%>"><%=(Recordset2.Fields.Item("审批人姓名").Value)%></a> <br>
<img src="<%=(Recordset2.Fields.Item("电子签名").Value)%>" width="150" height="80"> <br>
<%if Recordset2("最后更新日期")="2006-10-1" then %>
<%=(Recordset2.Fields.Item("审批时间").Value)%>
<%else%>
<span class="style39">更新：<%=(Recordset2.Fields.Item("最后更新时间").Value)%></span>
<%end if%>
</div></td>
</tr>
</table>
<% End If ' end Not Recordset2.EOF Or NOT Recordset2.BOF %>
<%
Repeat2__index=Repeat2__index+1
Repeat2__numRows=Repeat2__numRows-1
Recordset2.MoveNext()
Wend
%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><div align="right">办理结果：</div></td>
<td colspan="2"><div align="left"><%=HTMLEncode(r.Fields.Item("办理结果").Value)%> <br> <br>
办理人：<%=(r.Fields.Item("办理人").Value)%> </div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><div align="right">备注：</div></td>
<td colspan="2"><%=HTMLEncode(r.Fields.Item("备注").Value)%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><div align="right">附件：</div></td>
<td colspan="2"><table width="357" border="0" cellspacing="0" cellpadding="0">
<%
While ((Repeat1__numRows <> 0) AND (NOT r11.EOF))
%>
<tr>
<%p=r11.Fields.Item("文件路径").Value%>
<td width="255"> <a href="redirect.asp?id=<%=(r11.Fields.Item("id").Value)%>&gwid=<%=(r11.Fields.Item("邮件编号").Value)%>&fpath=<%=p%>" target="_blank"><%=(r11.Fields.Item("文件名").Value)%></a> <a href="downfile.asp?id=<%=(r11.Fields.Item("id").Value)%>&gwid=<%=(r11.Fields.Item("邮件编号").Value)%>" >下载</a><br/></td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
r11.MoveNext()
Wend
%>
</table></td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FF3333">
<tr><%dim bt1,bt
bt=r("事由")
bt1=left(bt,20)
%>
<td bgcolor="#FFFFFF"><%if r("是否显示列表")="是" then%>
审批、办理人：<%=geter%><%end if%>
<table width="334" border="0" cellspacing="0" cellpadding="0">
<% If Not r11.EOF Or Not r11.BOF Then %>
<%
While ((Repeat1__numRows <> 0) AND (NOT r11.EOF))
%>
<tr>
<td width="301"> <a href="redirect.asp?id=<%=(r11.Fields.Item("id").Value)%>&gwid=<%=(r11.Fields.Item("邮件编号").Value)%>&fpath=<%=(r11.Fields.Item("文件路径").Value)%>" target="_blank"><%=(r11.Fields.Item("文件名").Value)%></a> <br/></td>
<td width="33"><a href="downfile.asp?id=<%=(r11.Fields.Item("id").Value)%>&gwid=<%=(r11.Fields.Item("邮件编号").Value)%>" >下载</a></td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
r11.MoveNext()
Wend
%>
<% End If ' end Not r11.EOF Or NOT r11.BOF %>
</table>
<form action="shenpiyuiajincbgsghsd.asp?id=<%=r("id")%>" method="post" name="form11" id="form11">
</form></td>
</tr>
</table>
<p align="center"><a href="getshenlist.asp?id=<%=(r.Fields.Item("id").Value)%>">返回</a> <span class="style2"><a href="javascript:window.print()">我要打印</a></span></p>
<%
r.Close()
Set r = Nothing
%>
<%
r11.Close()
Set r11 = Nothing
%>
<%
Recordset3.Close()
Set Recordset3 = Nothing
%>
<%
Recordset2.Close()
Set Recordset2 = Nothing
%>
<%
Recordset21.Close()
Set Recordset21 = Nothing
%>
<%
r1.Close()
Set r1 = Nothing
%>
<%else%>
<script>
{alert("数据不存在.");history.go(-1)
}
</script>
<%end if%>
<%
getimg.Close()
Set getimg = Nothing
%>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?