adminyijianfcgf.asp

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

<%@LANGUAGE="VBSCRIPT"%>
<%  
Response.ExpiresAbsolute=now()-1
Response.CacheControl="no-cache"
%>
<%
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 fawen  WHERE (审稿人 like '%" + Replace(r__MMColParam, "'", "''") + "%' or 签阅人 like '%" + Replace(r__MMColParam, "'", "''") + "%' or 办理人 like '%" + Replace(r__MMColParam, "'", "''") + "%') and fawen.id=" + Replace(r__d, "'", "''") + "  ORDER BY 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 b
b=r("备注")
%> 
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "王海"
If ("|"&session("names")   <> "") Then 
  Recordset1__MMColParam = "|"&session("names")  
End If
%>
<%
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 fawenfiles.文件名,fawenfiles.文件路径,fawenfiles.id,fawenfiles.邮件编号  FROM fawen inner join fawenfiles on fawenfiles.邮件编号=fawen.id  WHERE (审稿人 like '%" + Replace(Recordset1__MMColParam, "'", "''") + "%' or 签阅人 like '%" + Replace(Recordset1__MMColParam, "'", "''") + "%' or 办理人 like '%" + Replace(Recordset1__MMColParam, "'", "''") + "%') and fawen.id=" + Replace(Recordset1__d, "'", "''") + "  ORDER BY fawen.id desc"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Dim Recordset3__u
Recordset3__u = "1"
If (Session("userssdfgfhtrh") <> "") Then 
  Recordset3__u = Session("userssdfgfhtrh")
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, "'", "''") + "'  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__u
Recordset2__u = "1"
If (Session("userssdfgfhtrh") <> "") Then 
  Recordset2__u = Session("userssdfgfhtrh")
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, "'", "''") + " and 审批人帐号='" + Replace(Recordset2__u, "'", "''") + "'  ORDER BY 最后更新时间 desc ,ID DESC"
Recordset2.CursorType = 0
Recordset2.CursorLocation = 2
Recordset2.LockType = 1
Recordset2.Open()
Recordset2_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = -1
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
<%
Dim Repeat2__numRows
Dim Repeat2__index
Repeat2__numRows = -1
Repeat2__index = 0
Recordset2_numRows = Recordset2_numRows + Repeat2__numRows
%>
<%
'  *** Recordset Stats, Move To Record, and Go To Record: declare stats variables

Dim Recordset2_total
Dim Recordset2_first
Dim Recordset2_last

' set the record count
Recordset2_total = Recordset2.RecordCount

' set the number of rows displayed on this page
If (Recordset2_numRows < 0) Then
  Recordset2_numRows = Recordset2_total
Elseif (Recordset2_numRows = 0) Then
  Recordset2_numRows = 1
End If

' set the first and last displayed record
Recordset2_first = 1
Recordset2_last  = Recordset2_first + Recordset2_numRows - 1

' if we have the correct record count, check the other stats
If (Recordset2_total <> -1) Then
  If (Recordset2_first > Recordset2_total) Then
    Recordset2_first = Recordset2_total
  End If
  If (Recordset2_last > Recordset2_total) Then
    Recordset2_last = Recordset2_total
  End If
  If (Recordset2_numRows > Recordset2_total) Then
    Recordset2_numRows = Recordset2_total
  End If
End If
%>
<%
' *** Recordset Stats: if we don't know the record count, manually count them

If (Recordset2_total = -1) Then

  ' count the total records by iterating through the recordset
  Recordset2_total=0
  While (Not Recordset2.EOF)
    Recordset2_total = Recordset2_total + 1
    Recordset2.MoveNext
  Wend

  ' reset the cursor to the beginning
  If (Recordset2.CursorType > 0) Then
    Recordset2.MoveFirst
  Else
    Recordset2.Requery
  End If

  ' set the number of rows displayed on this page
  If (Recordset2_numRows < 0 Or Recordset2_numRows > Recordset2_total) Then
    Recordset2_numRows = Recordset2_total
  End If

  ' set the first and last displayed record
  Recordset2_first = 1
  Recordset2_last = Recordset2_first + Recordset2_numRows - 1
  
  If (Recordset2_first > Recordset2_total) Then
    Recordset2_first = Recordset2_total
  End If
  If (Recordset2_last > Recordset2_total) Then
    Recordset2_last = Recordset2_total
  End If

End If
%>
<%
Dim Repeat3__numRows
Dim Repeat3__index

Repeat3__numRows = -1
Repeat3__index = 0
Recordset2_numRows = Recordset2_numRows + Repeat3__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">
<!--
.style37 {color: #FF0000}
.style38 {color: #FFFFFF;
	font-size: 14px;
	font-weight: bold;
}
.style41 {color: #999999}
.style42 {color: #009933}
body {
	margin-top: 2px;
}
-->
</style>
<table width="100%" height="23" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="20%"><div align="right">发文：</div></td>
    <td width="3%"><div align="right"><img src="../../img/txl/29.gif" width="16" height="16"></div></td>
    <td width="7%"><div align="right"><a href="../../toall/fawen/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/fawen/sentshengqinglistfsdghs.asp">拟稿记录</a></div></td>
    <td width="2%"><div align="right"><img src="../../img/txl/15.gif" width="16" height="16"></div></td>
    <td width="6%"><div align="right"><a href="../../toall/fawen/daishenfawen.asp">待审发文</a></div></td>
    <td width="3%"><div align="right"><img src="../../img/txl/26.gif" width="16" height="16"></div></td>
    <td width="6%"><div align="right"><a href="../../toall/fawen/yishenshenlist.asp">已审收文</a></div></td>
    <td width="3%"><div align="right"><img src="../../img/txl/From.gif" width="16" height="16"></div></td>
    <td width="6%"><div align="right"><a href="../../toall/fawen/getshenlist.asp">审稿列表</a></div></td>
    <td width="3%"><div align="right"><img src="../../img/txl/12.gif" width="16" height="16"></div></td>
    <td width="6%"><div align="right"><a href="../../toall/fawen/daiqianfawen.asp">待签发文</a> <span class="style41"></span></div></td>
    <td width="3%"><div align="right"><img src="../../img/txl/1.gif" width="16" height="16"></div></td>
    <td width="6%"><div align="right"><a href="../../toall/fawen/yiqianqianfawen.asp">已签发文</a></div></td>
    <td width="2%"><div align="right"><img src="../../img/txl/16.gif" width="16" height="16"></div></td>
    <td width="6%"><div align="right"><a href="../../toall/fawen/qianyuefawen.asp">签阅发文</a></div></td>
    <td width="2%"><div align="right"><img src="../../img/txl/24.gif" width="16" height="16"></div></td>
    <td width="6%"><div align="right"><a href="../../toall/fawen/updatimgpath.asp">上传签名</a></div></td>
    <td width="1%">&nbsp;</td>
  </tr>
</table>
<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="0" cellspacing="1" bgcolor="#FF3333">
  <tr>
    <td bgcolor="#FFFFFF"><p align="center"><strong>      <%=(r.Fields.Item("文件标题").Value)%></strong>
        <br>
  　　　　　　　　　　　　　　　　　　　　　　　　　　　
  <%if r("最后更新日期")="2006-10-1" then%>
提交时间:<%=(r.Fields.Item("添加时间").Value)%>
<%else%>
<span class="style37">最后更新:<%=(r.Fields.Item("最后更新时间").Value)%></span>
<%end if%>
　 点击:<%=(r.Fields.Item("点击").Value)%> 　意见:<%=(Recordset2_total)%>条    
      <hr width="95%" size="1" color="#999999" height="1">
　　　　　　　　　　　　　　　　　　　
<% If Not Recordset2.EOF Or Not Recordset2.BOF Then %>
<% 
While ((Repeat3__numRows <> 0) AND (NOT Recordset2.EOF)) 
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td style="word-break:break-all;Width:fixed">&nbsp;审批意见：<%=HTMLEncode(Recordset2.Fields.Item("审批意见").Value)%>  结果：<span class="style42"><%=(Recordset2.Fields.Item("审批签阅结果").Value)%></span><br>
      　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　 　　　　　　<img src="../../img/bbs/update.gif" width="16" height="16"><a href="updatefghdfg.asp?id=<%=request("ID")%>&ids=<%=(Recordset2.Fields.Item("ID").Value)%>">修改</a>　<img src="../../img/bbs/del.gif" width="12" height="13"><a href="delshnepiyijian.asp?id=<%=(Recordset2.Fields.Item("ID").Value)%>&idb=<%=request("id")%>" onClick="return confirm('您确定要删除吗？')">删除</a>　
      <%if Recordset2("最后更新日期")="2006-10-1" then %><%=(Recordset2.Fields.Item("审批时间").Value)%><%else%>
      <span class="style39 style37">更新：<%=(Recordset2.Fields.Item("最后更新时间").Value)%></span>
      <%end if%> 　 &nbsp;<br>
      　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　
      <hr width="95%" size="1" color="#999999" height="1">　　　　　　　　
      </td>
  </tr>
</table>
<% 
  Repeat3__index=Repeat3__index+1
  Repeat3__numRows=Repeat3__numRows-1
  Recordset2.MoveNext()
Wend
%>
<% End If ' end Not Recordset2.EOF Or NOT Recordset2.BOF %>
　　　　　　　　　　　　　　　　　　　　　　　　　　　　　 　　　　　　　　　　　　　　　　　　　 申请人：<a href="#" title="提交人:<%=r("添加人姓名")%> &nbsp;部门:<%=r("添加人部门")%>"><%=(r.Fields.Item("发送人").Value)%></a><br>      　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　
         　　　　　　&nbsp;　　　　　　　　　　　　　　　　<%=(r.Fields.Item("添加时间").Value)%>　　
      <table width="446" border="0" cellspacing="0" cellpadding="0">
      <% If Not Recordset1.EOF Or Not Recordset1.BOF Then %>
      <% 
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) 
%>
  <tr>
          <td>&nbsp;<a href="redirect.asp?id=<%=(Recordset1.Fields.Item("id").Value)%>&gwid=<%=(Recordset1.Fields.Item("邮件编号").Value)%>&fpath=<%=(Recordset1.Fields.Item("文件路径").Value)%>" target="_blank"><%=(Recordset1.Fields.Item("文件名").Value)%></a>　　<a href="downfile.asp?id=<%=(Recordset1.Fields.Item("id").Value)%>&gwid=<%=(Recordset1.Fields.Item("邮件编号").Value)%>" >下载</a><br/></td>
          <td>&nbsp;</td>
        </tr>
      <% 
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  Recordset1.MoveNext()
Wend
%>
      <% End If ' end Not Recordset1.EOF Or NOT Recordset1.BOF %>

</table>
    
    <% 
While ((Repeat2__numRows <> 0) AND (NOT Recordset2.EOF)) 
%>
    <% If Not Recordset2.EOF Or Not Recordset2.BOF Then %>
    <% End If ' end Not Recordset2.EOF Or NOT Recordset2.BOF %>
    <% 
  Repeat2__index=Repeat2__index+1
  Repeat2__numRows=Repeat2__numRows-1
  Recordset2.MoveNext()
Wend
%>
<br>
    <form name="form1" method="post" action="shenpiyuiajincbgsghsd.asp?id=<%=r("id")%>"id")%>
      </form>
    </td>
  </tr>
</table>
<p align="center">  <span class="style37"><%=(Recordset2_total)%></span> 条意见 <a href="javascript:history.go(-1)">返回</a> 　</p>
<p align="center">&nbsp;</p>
<%
r.Close()
Set r = Nothing
%>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
<%
Recordset3.Close()
Set Recordset3 = Nothing
%>
<%
Recordset2.Close()
Set Recordset2 = Nothing
%>
<%else%>
<script>
{
alert("数据不存在.");history.go(-1);
}
</script>
<%end if%>