sentshengqinglistfsdghs111.asp

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

<%@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__u
r__u = "1"
If (Session("userssdfgfhtrh") <> "") Then 
  r__u = Session("userssdfgfhtrh")
End If
%>
<%
Dim r
Dim r_numRows
Set r = Server.CreateObject("ADODB.Recordset")
r.ActiveConnection = MM_oavbsconn_STRING
r.Source = "SELECT *  FROM shouwen  WHERE 添加人帐号 ='" + Replace(r__u, "'", "''") + "'  ORDER BY 最后更新时间 desc, id desc"
r.CursorType = 0
r.CursorLocation = 2
r.LockType = 1
r.Open()
r_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = 30
Repeat1__index = 0
r_numRows = r_numRows + Repeat1__numRows
%>
<style type="text/css">
<!--
.style5 {color: #FFFFFF}
-->
</style>
<link href="../../css/link.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style37 {color: #000000}
.style38 {color: #FF0000}
.style39 {font-size: 12px}
-->
</style>
<div align="center">  
<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="style5"><strong>收 文 拟 稿</strong></div></td>
    </tr>
  </table>
  <table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#FF3333">
    <tr>
      <td bgcolor="#FFFFFF"><table width="100%" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td height="6" colspan="7"></td>
          </tr>
        <tr>
          <td>&nbsp;</td>
          <td><strong>事 由</strong></td>
          <td><div align="center"><strong>审 稿</strong></div></td>
          <td><div align="center"><strong>签 阅</strong></div></td>
          <td><div align="center"><strong>办 理</strong></div></td>
          <td><div align="center"><strong>修 改</strong></div></td>
          <td width="21%"><div align="center"><strong>时 间</strong></div></td>
        </tr>
        <% 
While ((Repeat1__numRows <> 0) AND (NOT r.EOF)) 
%>
        <% If Not r.EOF Or Not r.BOF Then %><%dim geter 
geter=r("接收人")%>

        <tr bgcolor="#FFFFFF" onMouseOver = "this.style.backgroundColor = '#EEEEEE'" onMouseOut = "this.style.backgroundColor = ''">
            <td width="3%" height="15"><div align="center"><img src="../tz/img/icon1.gif" width="8" height="9"></div></td>
            <td width="55%" height="15"><a href="shouwenjiludetail.asp?id=<%=(r.Fields.Item("id").Value)%>"><%=(r.Fields.Item("事由").Value)%></a>
            </td>
            <td width="6%" height="15"><%=(r.Fields.Item("审稿通过否").Value)%></td>
            <td width="5%" height="15"><div align="center"><%=(r.Fields.Item("签阅通过否").Value)%></div></td>
            <td width="5%" height="15"><div align="center"><%=(r.Fields.Item("办理否").Value)%></div></td>
            <td width="5%" height="15"><div align="center"><a href="updateshenpimyfdda.asp?id=<%=(r.Fields.Item("id").Value)%>">修改</a></div></td>
            <td width="21%" height="15">
              <div align="left">
                <%if r("最后更新日期")="2006-10-1" then%>
				<%if r("添加日期") or r("最后更新日期")=date() then%>
				<%=r("更新times")%><%else%>
                <span class="style5 style37"><%=(r.Fields.Item("添加时间").Value)%></span>
                <%end if%> <%end if%>
                <%if r("最后更新日期")<>"2006-10-1" then%>
				
               <%if r("添加日期") or r("最后更新日期")=date() then%>
				<%=r("更新times")%><%else%>
                <span class="style37"><%=(r.Fields.Item("最后更新时间").Value)%></span>
               
                <%end if%><%end if%>
                </div></td>
        </tr>
        <% End If %>

        <% 
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  r.MoveNext()
Wend
%>
      </table></td>
    </tr>
  </table>
</div>
<p align="center" class="style39">
  <% If r.EOF And r.BOF Then %>
暂无收文记录..
<% End If ' end r.EOF And r.BOF %>
  <br>
  <a href="javascript:history.go(-1)">返回
  </a><br>
</p>
  <%
r.Close()
Set r = Nothing
%>