getshenlistqorquery.asp

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

<%@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
%>
<%q=request("q")
if q="检索收文审稿" then q="%"
Dim r__q
r__q = "1"
If (q <> "") Then 
  r__q = q
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, "'", "''") + "%' and 开关='是'and (内容 like '%" + Replace(r__q, "'", "''") + "%' or 备注 like '%" + Replace(r__q, "'", "''") + "%' or 发送人 like '%" + Replace(r__q, "'", "''") + "%' or 来文机关 like '%" + Replace(r__q, "'", "''") + "%' or 来文日期 like '%" + Replace(r__q, "'", "''") + "%' or 收文日期 like '%" + Replace(r__q, "'", "''") + "%'or 来文字号 like '%" + Replace(r__q, "'", "''") + "%'or 事由 like '%" + Replace(r__q, "'", "''") + "%'or 拟办意见 like '%" + Replace(r__q, "'", "''") + "%'or 领导批示 like '%" + Replace(r__q, "'", "''") + "%'or 审稿结果 like '%" + Replace(r__q, "'", "''") + "%'or 签阅结果 like '%" + Replace(r__q, "'", "''") + "%'or 归档类别 like '%" + Replace(r__q, "'", "''") + "%' or 添加时间 like '%" + Replace(r__q, "'", "''") + "%' or 添加日期  like '%" + Replace(r__q, "'", "''") + "%'or 添加人帐号 like '%" + Replace(r__q, "'", "''") + "%' or 添加人姓名 like '%" + Replace(r__q, "'", "''") + "%'  or 添加人部门 like '%" + Replace(r__q, "'", "''") + "%')  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">
<!--
.style36 {	font-size: 13px;
	color: #FFFFFF;
	font-weight: bold;
}
.style5 {color: #FFFFFF}
-->
</style>
<link href="../../css/link.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style37 {color: #000000}
.style38 {color: #FF0000}
.style40 {font-size: 12px}
.style41 {color: #FFFFFF;
	font-size: 14px;
	font-weight: bold;
}
.style42 {color: #999999}
body {
	margin-top: 2px;
}
-->
</style>
<div align="center">  
  <table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><form name="form1" method="post" action="getshenlistqorquery.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>
            <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/shouwen/yishenlist.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/shouwen/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/shouwen/havenoqianyuelist.asp">待签收文</a> <span class="style42"></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/shouwen/haveedqianyuelist.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/shouwen/qianyuelist.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/shouwen/havenobanlilist.asp">待办收文</a></div></td>
            <td width="2%"><div align="right"><img src="../../img/txl/hn2_sunny.gif" width="19" height="19"></div></td>
            <td width="6%"><div align="right"><a href="../../toall/shouwen/haveedbanlilist.asp">已办收文</a></div></td>
            <td width="2%"><div align="right"><img src="../../img/txl/31.gif" width="16" height="16"></div></td>
            <td width="6%"><div align="right"><a href="../../toall/shouwen/banlilist.asp">办理列表</a></div></td>
            <td width="1%">&nbsp;</td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td colspan="11"><div align="right">
                <input name="q" type="text" class="style42" id="q" onclick=this.value='' value="<%=request("q")%>">
                <span class="bg style2">
                <input name="提交" type=submit style="FONT-SIZE: 12px; HEIGHT: 27px"  value= " 搜 索 " >
            </span></div></td>
            <td>&nbsp;</td>
          </tr>
        </table>
      </form></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="21"></td>
      <td width="936" height="20" bgcolor="#FF3333"><div align="center" class="style41"><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="0" bgcolor="#FF3333">
    <tr>
      <td bgcolor="#FFFFFF"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
        <tr>
          <td height="22" bgcolor="#FFFFFF">&nbsp;<strong>标 题</strong></td>
          <td bgcolor="#FFFFFF"><div align="center"><strong>操　作</strong></div></td>
          <td bgcolor="#FFFFFF"><div align="center"><strong>提交人</strong></div></td>
          <td width="20%" bgcolor="#FFFFFF"><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("接收人")%><%dim s
s=r.Fields.Item("事由").Value%>
        <tr bgcolor="#FFFFFF" onMouseOver = "this.style.backgroundColor = '#EEEEEE'" onMouseOut = "this.style.backgroundColor = ''">
            <td width="50%" height="22">&nbsp;<img src="../tz/img/icon1.gif" width="8" height="9">&nbsp;<a href="doshenpideatilvbgf.asp?id=<%=(r.Fields.Item("id").Value)%>">
              <%if len(s)<30 then%>
            <%=s%>
            <%else%>
            <%=left(s,30)&".."%>
            <%end if%></a><%if r.Fields.Item("附件数").Value<>0 then%>
          <img src="../../img/common.gif" width="16" height="16">          <span class="style42"><%=(r.Fields.Item("附件数").Value)%>个附件</span>
          <%end if%></td>
            <td width="21%"><div align="center"><a href="geterupdateshouwen.asp?id=<%=(r.Fields.Item("ID").Value)%>">修改</a>&nbsp;<a href="sendtoshenpifordijioahuobanli.asp?id=<%=(r.Fields.Item("id").Value)%>&s=<%=s%>&u=<%=(r.Fields.Item("添加人姓名").Value)%>">转审</a>&nbsp;<a href="sentdobanli.asp?id=<%=(r.Fields.Item("id").Value)%>&s=<%=s%>&u=<%=(r.Fields.Item("添加人姓名").Value)%>">转办</a> <a href="chengyue.asp?id=<%=(r.Fields.Item("ID").Value)%>&s=<%=(r.Fields.Item("添加人姓名").Value)%>&bt=<%=s%>">向上呈阅</a></div></td>
            <td width="7%"><div align="center"><%=(r.Fields.Item("添加人姓名").Value)%></div></td>
            <td width="20%">
              <div align="center">
                <%if r("最后更新日期")="2006-10-1" then%>
                  <span class="style5 style37"><%=(r.Fields.Item("添加时间").Value)%></span>
                <%end if%>
                <%if r("最后更新日期")<>"2006-10-1" then%>
                  <span class="style12 style38"><%=(r.Fields.Item("最后更新时间").Value)%></span> <span class="style12 style11 style38">[更新]</span>
                <%end if%>
              </div></td></tr>
        <% End If ' end Not r.EOF Or NOT r.BOF %>
        <% 
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  r.MoveNext()
Wend
%>
      </table></td>
    </tr>
  </table>
</div>
<div align="center">
  <% If r.EOF And r.BOF Then %>
</div>
<p align="center" class="style40">暂无收文审稿..</p>
<div align="center">
  <p><%end if%>
    <%
r.Close()
Set r = Nothing
%>
  </p>
  <p><a href="javascript:history.go(-1)">返回</a> </p>
</div>