📄 allmember.asp
字号:
<!--#include file="conn.asp"-->
<%
id=session("userid")
username=session("username")
if id="" or username="" then
response.Redirect("adminloginerror.asp")
end if
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from sysuser where sysuser='"& username &"' and id=" & id &" and admintyp='财务管理员'"
rs.open sql,conn,3,3
if rs.eof then
response.Redirect("adminloginerror.asp")
else
%>
<title><%=webname%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style.css" rel="stylesheet" type="text/css">
<body><div align="center">
<center>
<table width="90%" border="1" cellpadding="3" cellspacing="0" bordercolor="#6687BA" style="border-collapse: collapse">
<form name="form1" method="post" action="admin_sysadd.asp">
<tr>
<td bgcolor="#EAF1FB">
<div align="center" class="f1">所 有 企 业 用 户 列 表</div>
</td>
</tr>
<tr>
<td bordercolor="#FFFFFF" bgcolor="#FFFFFF">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr align="center">
<td width="20%">
<div align="center">会员名称</div>
</td>
<td width="20%">
<div align="center">所在省份</div>
</td>
<td width="20%">登陆密码</td>
<td width="20%">客户类型</td>
<td width="20%">
<div align="center">注册日期</div>
</td>
</tr>
</table>
<%
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from userentreg where usertyp='企业' order by id desc"
rs.open sql,conn,3,3
if rs.eof then
%>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td>
<div align="center" class="f1">暂 无 人 注 册</div>
</td>
</tr>
</table>
<% else
rs.Pagesize=10
page=clng(request("page"))
if page<1 or page=empty then page=1
if page>rs.pagecount then page=rs.pagecount
rs.Absolutepage=page
do while not rs.eof
%>
<table width="100%" border="0" cellpadding="3" cellspacing="0">
<tr>
<td width="20%">
<div align="center" class="f1"><%=rs("login_name")%></div>
</td>
<td width="20%">
<div align="center"><span class="f1"><%=rs("province")%></span></div>
</td>
<td width="20%" align="center"><span class="f1"><%=rs("password")%></span>
</td>
<td width="20%">
<div align="center"><span class="f1"><%=rs("sales")%></span></div>
</td>
<td width="20%">
<div align="center" class="f1"><%=rs("date")%></div>
</td>
</tr>
</table>
<%
i=i+1
if i>10 then exit do
rs.movenext
loop
end if
%>
<div align="center">
<center>
<table width="100%" border="0" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td> <%
if page<>1 then %> <div align="center"><a href=<%=myself%>?page=1>第一页</a>
<a href=<%=myself%>?page=<%=(page-1)%>>上一页</a>
<%
end if
if page<>rs.pagecount then
%>
<a href=<%=myself%>?page=<%=(page+1)%>>下一页</a> <a href=<%=myself%>?page=<%=rs.pagecount%>>最后一页</a>
<% end if %>
<font style="font-size:9pt"> 输入页次:</font>
<input type=text name=page22 size=3 class="border">
<font style="font-size:9pt">页次:</font><font color=red style="font-size:9pt"><%=page%>/<%=rs.pagecount%></font> 共有记录<font color=red style="font-size:9pt"><%=rs.recordcount %></font>条</div></td>
</tr>
</table> </center>
</div>
</td>
</tr>
</form>
</table>
</center>
</div>
<br>
<div align="center">
<center>
<table width="90%" border="1" cellpadding="3" cellspacing="0" bordercolor="#6687BA" style="border-collapse: collapse">
<form name="form1" method="post" action="admin_sysadd.asp">
<tr>
<td bgcolor="#EAF1FB">
<div align="center" class="f1">所 有 个 人 用 户 列 表</div>
</td>
</tr>
<tr>
<td bordercolor="#FFFFFF" bgcolor="#FFFFFF">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr align="center">
<td width="20%">
<div align="center">会员名称</div>
</td>
<td width="20%">
<div align="center">所在省份</div>
</td>
<td width="20%">登陆密码</td>
<td width="20%">用户类型</td>
<td width="20%">
<div align="center">注册日期</div>
</td>
</tr>
</table>
<%
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from userpersreg where usertyp='个人' order by id desc"
rs.open sql,conn,3,3
if rs.eof then
%>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td>
<div align="center" class="f1">暂 无 人 注 册</div>
</td>
</tr>
</table>
<% else
rs.Pagesize=11
page=clng(request("page"))
if page<1 or page=empty then page=1
if page>rs.pagecount then page=rs.pagecount
rs.Absolutepage=page
do while not rs.eof
%>
<table width="100%" border="0" cellpadding="3" cellspacing="0">
<tr>
<td width="20%">
<div align="center" class="f1"><%=rs("login_name")%></div>
</td>
<td width="20%">
<div align="center"><span class="f1"><%=rs("province")%></span></div>
</td>
<td width="20%" align="center"><span class="f1"><%=rs("password")%></span>
</td>
<td width="20%">
<div align="center"><span class="f1"><%=rs("sales")%></span></div>
</td>
<td width="20%">
<div align="center" class="f1"><%=rs("date")%></div>
</td>
</tr>
</table>
<%
i=i+1
if i>111 then exit do
rs.movenext
loop
end if
%>
<div align="center">
<center>
<table width="100%" border="0" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td align="center"> <%
if page<>1 then %> <div align="center"><a href=<%=myself%>?page=1>第一页</a>
<a href=<%=myself%>?page=<%=(page-1)%>>上一页</a>
<%
end if
if page<>rs.pagecount then
%>
<a href=<%=myself%>?page=<%=(page+1)%>>下一页</a> <a href=<%=myself%>?page=<%=rs.pagecount%>>最后一页</a>
<% end if %>
<font style="font-size:9pt"> 输入页次:</font>
<input type=text name=page22 size=3 class="border">
<font style="font-size:9pt">页次:</font><font color=red style="font-size:9pt"><%=page%>/<%=rs.pagecount%></font> 共有记录<font color=red style="font-size:9pt"><%=rs.recordcount %></font>条</div></td>
</tr>
</table> </center>
</div>
</td>
</tr>
</form>
</table>
</center>
</div>
<br>
<div align="center">
<center>
<p></p>
</body>
</html><%
end if
rs.close
set rs=nothing
set conn=nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -