📄 shouwenlist.asp
字号:
<!--#include file="check.asp"-->
<!--#INCLUDE FILE="connect.asp" -->
<html>
<head>
<title>办公自动化（OA）</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="apply.css" type="text/css">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" oncontextmenu="return false">
<!--#include file="checksql.asp"-->
<%
set rs=server.createobject("adodb.recordset")
temp=checksql(request("title"))
ifdone=request("ifdone")
if ifdone="" or ifdone="0" then ifdone="1"
select case ifdone
case "1"
flowstatus=""
case "2"
flowstatus="status=0 and "
case "3"
flowstatus="status=1 and "
end select
if session("type")="admin" then
sql="select id,title,writename,draftime,status from shouwen where "&flowstatus&"title like '%"& temp &"%' order by id desc"
else
sql="select shouwen.id,title,writename,draftime,status from shouwen where "&flowstatus&"shouwen.id in(select swflow.flowid from swflow where swflow.handleid='"&session("uid")&"') and title like '%"& temp &"%' order by shouwen.id desc"
end if
rs.open sql,conn,1,1
TSum=1
mypage=10
rs.pagesize=CINT(mypage)
PageNo=CLng(REQUEST("PageNo"))
if PageNo="" or PageNo=0 then
PageNo=1
else
PageNo=PageNo+1
PageNo=PageNo-1
end if
if not rs.eof then
TSum=INT(rs.RECORDCOUNT/Mypage*-1)*-1
rs.absolutepage=PageNo
RowCount=rs.PageSize
nowrecord=0
end if
%>
<div align="center">
<form name="form" method="POST" action="shouwenlist.asp">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="50">
<tr>
<td align="center"><img src="images/shouwenlist.gif"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="26" bgcolor="#D4DEF4">
<tr height=1>
<td bgcolor="#A7BAE4" height="1" colspan="3"></td>
</tr>
<tr>
<td width="21%" align="center">
共计<%=tsum%>页,目前第<font color="#ff5bad"><%=PageNo%></font>页</td>
<td width="71%" align="right" class='aapply'> <a href="flowlist.asp" class="aapply">
转到发文流程</a>
<%
if (PageNo*mypage-mypage)>0 then
PrwePage=PageNo-1
response.write "<a href='shouwenlist.asp?ifdone="&ifdone&"&title="&temp&"&PageNo="&PrwePage&"' class='aapply'>上一页</a> "
else
response.write "上一页 "
end if
if (PageNO*mypage)<rs.recordcount then
NextPage=PageNo+1
response.write" <a href='shouwenlist.asp?ifdone="&ifdone&"&title="&temp&"&PageNo="&NextPage&"' class='aapply'>下一页</a>"
else
response.write" 下一页"
end if
%>
</td>
<td width="8%" align="left"> </td>
</tr>
<tr height=1>
<td bgcolor="#A7BAE4" height="1" colspan="3"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="E7ECF7" height="26">
<td width="14%" align="center" height="26">拟 办 人</td>
<td align="center" width="56%" height="26"> 标 题</td>
<td align="center" width="18%" height="26">拟稿时间</td>
<td align="center" width="12%" height="26">状 态</td>
</tr>
<tr height="1">
<td bgcolor="#C9E9FC" colspan="4"><img src="images/spacer.gif" width="1" height="1"></td>
</tr>
<%if rs.eof then %>
<tr height="1">
<td bgcolor="#ffffff" colspan="4"><img src="images/spacer.gif" width="1" height="1"></td>
</tr>
<tr bgcolor="#F5FAFD" align="center">
<td height="26" colspan="4" class="f6wait"> 没有找到相应的收文流程</td>
</tr>
<tr height="1">
<td bgColor="#D6E1F8" colspan="4"><img src="images/spacer.gif" width="1" height="1"></td>
</tr>
<% else %>
<% for i=1 to mypage
if rs.eof then exit for
%>
<tr height="1">
<td bgcolor="#ffffff" colspan="4"><img src="images/spacer.gif" width="1" height="1"></td>
</tr>
<tr bgcolor="#F5FAFD" align="center">
<td height="26" width="14%"> <a href="readshouwen.asp?flowid=<%=rs("id")%>&title=<%=rs("title")%>&status=<%=rs("status")%>" class="aapply"><%=rs("writename")%></a></td>
<td height="26" width="56%"> <a href="readshouwen.asp?flowid=<%=rs("id")%>&title=<%=rs("title")%>&status=<%=rs("status")%>" class="aapply">
<%temp=""&rs("title")
if len(temp)>20 then
temp=left(temp,20)&"…"
end if
response.write(temp)
%>
</a></td>
<td height="26" width="18%" class="applygz"><%=rs("draftime")%></td>
<td height="26" width="12%" align="center">
<%if rs("status")="0" then
response.write("<font class='undone'>待 办</font>")
else
response.write("<font class='done'>完 毕</font>")
end if
%>
</td>
</tr>
<tr height="1">
<td bgColor="#D6E1F8" colspan="4"><img src="images/spacer.gif" width="1" height="1"></td>
</tr>
<%
rs.movenext
next
end if
%>
<tr>
<td height="26" colspan="4">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="26" bgcolor="#D4DEF4">
<tr height=1>
<td bgcolor="#A7BAE4" height="1" colspan="2"></td>
</tr>
<tr>
<td align="right" width="52%">查 找:
<input type="radio" name="ifdone" value="1" <%if request("ifdone")="" or request("ifdone")="1" then response.write("checked")%>>
全部
<input type="radio" name="ifdone" value="2" <%if request("ifdone")="2" then response.write("checked")%>>
待办
<input type="radio" name="ifdone" value="3" <%if request("ifdone")="3" then response.write("checked")%>>
已办
<input class="boxinput" type="text" name="title" size="10" tableindex=1 maxlength="10" value="<%=request("title")%>">
</td>
<td valign="bottom" width="48%">
<input type="image" name="find3" value="查 找" src="images/findgif.gif" alt="查找">
<input type="image" name="find22" onClick="history.go(-1);return false;" src="images/fanhuigif.gif" alt="返回">
</td>
</tr>
<tr height=1>
<td bgcolor="#A7BAE4" height="1" colspan="2"></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</div>
<!--#include file="close.asp"-->
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -