📄 flowlist.asp
字号:
<!--#include file="check.asp"-->
<!--#INCLUDE FILE="connect.asp" -->
<!--#include file="checksql.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">
<% title=checksql(request("title"))
ifdone=request("ifdone")
if request("ifdone")="" or request("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
set rs=server.createobject("adodb.recordset")
if session("type")="admin" then
sql="select title,writename,writetime,status,fawen.id from fawen where "&flowstatus&"title like '%"& title &"%' group by title,writename,writetime,status,fawen.id order by fawen.id desc"
else
sql="select title,writename,writetime,status,fawen.id from fawen where "&flowstatus&"id in(select flowid from workflow where handleid='"&session("uid")&"') and title like '%"& title &"%' order by id desc"
end if
%>
<% rs.open sql,conn,1,1
mypage=10
TSum=1
rs.pagesize=CLng(mypage)
PageNo=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="flowlist.asp">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="50">
<tr>
<td align="center"><img src="images/fawenlist.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="shouwenlist.asp" class="aapply">转到收文流程</a>
<%
if (PageNo*mypage-mypage)>0 then
PrwePage=PageNo-1
response.write "<a href='flowlist.asp?ifdone="&ifdone&"&title="&title&"&PageNo="&PrwePage&"' class='aapply'>上一页</a> "
else
response.write "上一页 "
end if
if (PageNO*mypage)<rs.recordcount then
NextPage=PageNo+1
response.write" <a href='flowlist.asp?ifdone="&ifdone&"&title="&title&"&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">
<td height="26" align="left" colspan="4">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="100%" bgcolor="E7ECF7">
<tr>
<td width="15%" align="center" height="25">拟 稿 人</td>
<td align="center" width="57%" height="25"> 标 题</td>
<td align="center" width="14%" height="25">拟稿时间</td>
<td align="center" width="14%" height="25">状 态</td>
</tr>
<tr height="1">
<td bgcolor="#C9E9FC" colspan="4"><img src="images/spacer.gif" width="1" height="1"></td>
</tr>
</table>
</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'>
<td height="26" width="15%" align="center" bgcolor="#F5FAFD"><a href="readfawen.asp?flowid=<%=rs("id")%>&title=<%=rs("title")%>&status=<%=rs("status")%>" class="aapply"><%=rs("writename")%></a>
</td>
<td height="26" width="57%" align="center" bgcolor="#F5FAFD"><a href="readfawen.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="19%" class="applygz"><%=rs("writetime")%></td>
<td height="26" width="9%">
<%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
%>
</table>
<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>
</form>
</div>
<!--#include file="close.asp"-->
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -