📄 adminuser_admin.asp
字号:
<%@ Language=VBScript%>
<%
Response.Buffer=false
Response.Expires=0
if Session("userqx")="1" or Session("userqx")="9" then
else
Response.Redirect "../warn.asp"
end if
%>
<!-- #include file="../dsn.asp" -->
<%
code=Request.QueryString("keyno")
pageno=Request.QueryString("pageno")
flag=Request.QueryString("flag")
if flag="" then flag="1"
htmlname="adminuser_admin.asp?xx=1"
addhtml="adminuser_edit.asp?pageno="+pageno
if flag="1" then
htmltitle="管理用户维护"
else
htmltitle="已删除用户列表"
end if
set cn=server.CreateObject("ADODB.Connection")
cn.Open mycnstr
set rs=server.CreateObject("ADODB.Recordset")
if code<>"" then
sqltext="select count(productno) from product where username='"+code+"'"
rs.Open sqltext,cn,1,1
if rs(0)=0 then
sqltext="delete from adminuser where username='"+code+"'"
cn.Execute(sqltext)
else
sqltext="update adminuser set flag='0' where username='"+code+"'"
cn.Execute(sqltext)
end if
rs.Close
sqltext="delete from pro_auth where username='"+code+"'"
'Response.Write sqltext
'Response.End
cn.Execute(sqltext)
end if
%>
<html>
<head>
<title><%=htmltitle%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
body {font-size: 12px; color: #000000; font-family: 宋体}
td {font-size: 12px; color: #000000; font-family: 宋体;line-height:130%}
.t1 {font:12px 宋体;color=000000}
.t2 {font:12px 宋体;color:ffffff}
.t3 {font:12px 宋体;color:336699}
.t4 {font:12px 宋体;color:ff0000}
.bt1 {font:14px 宋体;color=000000}
.bt2 {font:12px 宋体;color:ffffff}
.bt3 {font:14px 宋体;color:336699}
.bt4 {font:14px 宋体;color:ff0000}
.bt5 {font:14px 宋体;color:0000ff}
.bt10 {font:14px 宋体;color:0000ff}
.td1 {font-size:12px;background-color:#3388bb;color:#ffffff}
.td2 {font-size:12px;background-color:#ffffff;color:#000000;}
A:link {color: #000077}
A:visited {color: #000077}
A:hover {color: #ff0000}
A.r:link {color: #000077}
A.r:visited {color: #000077}
A.r:hover {color: #ff6600}
-->
</style>
</head>
<body topmargin=5 leftmargin=5 bgcolor=#ffffff>
<table width="100%" align=center border="0" cellspacing="0" cellpadding="0">
<tr><td align="left">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height=18>
<tr>
<td><font color="navy" style="font-size:14px"><b><%=htmltitle%></b></font></td>
</tr>
</table>
</td></tr>
<tr><td>
<table width="100%" border="0">
<tr>
<%
sqltext="select * from adminuser where flag='"+flag+"' order by username asc"
'Response.Write sqltext
rs.Open sqltext,cn,1,1
listcs=30
rs.PageSize=listcs
if pageno="" then
pageno=1
else
pageno=cint(pageno)
end if
if rs.PageCount>0 then rs.AbsolutePage=pageno
%>
<td class=t1 align="left" width=200>
<a href="<%=htmlname%>&flag=<%=flag%>">[刷新列表]</a>
<%if flag="1" then%>
<a href="<%=addhtml%>">[增加]</a>
<%end if%>
</td>
<td align="right">
<%if rs.PageCount>1 then%>
[第<b><%=pageno%></b>页, 共<b><%=rs.PageCount%></b>页<b><%=rs.RecordCount%></b>条记录]
<%if pageno>1 then%>
<a class=r href="<%=htmlname%>&pageno=1">[首页]</a>
<a class=r href="<%=htmlname%>&pageno=<%=pageno-1%>">[上页]</a>
<%end if
if pageno<rs.PageCount then%>
<a class=r href="<%=htmlname%>&pageno=<%=pageno+1%>">[下页]</a>
<a class=r href="<%=htmlname%>&pageno=<%=rs.PageCount%>">[末页]</a>
<%end if%>
<%end if
%>
</td>
</tr>
</table>
</td></tr>
<tr><td>
<table width="100%" border="0" cellspacing="1" cellpadding="1" style="font-size:14.5px;line-height:100%">
<tr bgcolor="527c72" style="color:#ffffff" align="center">
<%if flag="1" then%>
<td height=20 class=bt2>删除</td>
<%end if%>
</td><td class=bt2>用户编号</td><td class=bt2>用户名称</td>
<td class=bt2>管理权限</td><td class=bt2>最后上线</td><td class=bt2>IP</td><td class=bt2>上线次数</td>
</tr>
<%
i=0
do while not rs.EOF and i<listcs
if (i mod 2)=1 then
Response.Write("<tr bgcolor=fefefe>")
else
Response.Write("<tr bgcolor=efefef>")
end if
%>
<%if flag="1" then%>
<td onclick="delrec('<%=rs("username")%>','<%=trim(rs("username"))%>')" width="35" align="center"><img src="../admin/delete.gif"></td>
<%end if%>
<td width="100" align="left"><%=rs("username")%></td>
<td align=left><%if flag="1" then%><a href="<%=addhtml%>&username=<%=rs("username")%>"><%end if%><%=trim(rs("realname"))%></td>
<td width="80" align="center" height=20>
<%Select Case trim(rs("authority"))
case "1"
Response.Write("<font color=black>普通管理员</font>")
case "9"
Response.Write("<font color=800000>高级管理员</font>")
end select
%>
</td>
<td width=110 align="left"><%=rs("logindate")%></td>
<td width="110" align=center><%=trim(rs("ipaddress"))%></td>
<td width=60 align="right"><%=rs("logincount")%></td>
</tr>
<%
i=i+1
rs.MoveNext
loop
%>
</table>
</td></tr>
<%if rs.PageCount>1 then%>
<tr><td>
<table width="100%" cellspacing="0" cellpadding="0" border=0>
<tr><td bgcolor="336699">
<tr><td align=right>
[第<b><%=pageno%></b>页, 共<b><%=rs.PageCount%></b>页<b><%=rs.RecordCount%></b>条记录]
<%if pageno>1 then%>
<a class=r href="<%=htmlname%>&flag=<%=flag%>&pageno=1">[首页]</a>
<a class=r href="<%=htmlname%>&flag=<%=flag%>&pageno=<%=pageno-1%>">[上页]</a>
<%end if
if pageno<rs.PageCount then%>
<a class=r href="<%=htmlname%>&flag=<%=flag%>&pageno=<%=pageno+1%>">[下页]</a>
<a class=r href="<%=htmlname%>&flag=<%=flag%>&pageno=<%=rs.PageCount%>">[末页]</a>
<%end if%>
</td></tr>
</table>
</td></tr>
<%end if%>
</table>
</body>
</html>
<script language="Javascript">
function delrec(code,topic)
{
if (confirm('您确认要删除('+topic+')吗？')==true)
{
window.location.href="<%=htmlname%>&keyno="+code+"&pageno=<%=pageno%>"
}
}
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -