📄 poapprove.asp
字号:
<!--#include file="../config.ini" -->
<!--#include file="../commfunction.inc" -->
<%
dim conn
dim rs
set conn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
conn.Open connstring
rs.Open "select * from v_poapprove where type='"&Request.QueryString("type")&"'",conn,1,1
all=rs.Recordcount
%>
<html>
<head>
<LINK href="../global.css" rel=STYLESHEET type=text/css>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>审核关系</title>
</head>
<body vlink="#48576C" link="#48576C" alink="#000000" bgcolor="#FFFFFF" topmargin="3">
<table width="100%" height="30" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="25"><strong><font class=title><%=request("type")%>关系</font></strong> <a href="javascript:opensubwin('resizable=yes, scrollbars=no, left= 300, top=220, menubar=no, location=no, toolbar=no ,width=300, height=200','newpoapprove.asp?type=<%=Request.QueryString("type")%>');"><img src="../images/button_new.gif" border=0></a></td>
</tr>
<tr >
<td height="16" colspan="2" background="../images/title.gif"> </td>
</tr>
<tr>
<td height=4></td>
</tr>
</table>
<%
'dim connq
'dim rsq
'set connq=server.CreateObject("adodb.connection")
'set rsq=server.CreateObject("adodb.recordset")
'connq.Open connstring
'rsq.Open "select type,count(*) from approve group by type",connq,1,1
'if not rs.EOF then
' Response.Write "<table cellspacing=1 bgcolor='#ffffff'><tr>"
' do while not rsq.EOF
' if rs("type")=rsq("type") then
' Response.Write "<td height=18 align=center valign=center bgcolor='#FB0802'><font color='#FFFFFF'>"&rsq("type")&"</font></td>"
' else
' Response.Write "<td height=18 align=center valign=center bgcolor='#4A699C'><a href=approve.asp?type="&rsq("type")&"><font color='#FFFFFF'>"&rsq("type")&"</font></a></td>"
' end if
' rsq.MoveNext
' loop
' Response.Write "</tr></table>"
'end if
'rsq.Close
'set rsq=nothing
'connq.Close
'set onnnq=nothing
%>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#DECFAD">
<tr bgcolor="efefef">
<td width="30%" align=center>审核人</td>
<td width="30%" align=center>用户名</td>
<td width="40%" align=center>操作</td>
</tr>
<%do while not rs.EOF%>
<tr>
<td bgcolor="#FFFFFF" align=center><%=rs("approvername")%></td>
<td bgcolor="#FFFFFF" align=center><%=rs("username")%></td>
<td bgcolor="#FFFFFF" align=center><a href="javascript:opensubwin('resizable=yes, scrollbars=no, left= 300, top=220, menubar=no, location=no, toolbar=no ,width=300, height=200','newpoapprove.asp?id=<%=rs("id")%>');">编辑</a> <a href="javascript:opensubwin('resizable=yes, scrollbars=no, left= 300, top=220, menubar=no, location=no, toolbar=no ,width=300, height=200','../delete.asp?poapproveid=<%=rs("id")%>');">删除</a></td>
</tr>
<%
rs.MoveNext
loop
rs.Close
set rs=nothing
conn.Close
set conn=nothing
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -