📄 usermanage.asp
字号:
<%@language=vbscript codepage=936 %>
<!--#include file="Admin.asp"-->
<!--#include file="Conndb.asp"-->
<!--#include file="Inc/Function.asp"-->
<%
dim strFileName
const MaxPerPage=20
dim totalPut,CurrentPage,TotalPages
dim rs, sql
strFileName="UserManage.asp"
if request("page")<>"" then
currentPage=cint(request("page"))
else
currentPage=1
end if
Set rs=Server.CreateObject("Adodb.RecordSet")
sql="select * from [User] order by UserID desc"
rs.Open sql,conn,1,1
%>
<script language=javascript>
function ConfirmDel()
{
if(confirm("确定要删除此用户吗?"))
return true;
else
return false;
}
</script>
<!-- #include file="Inc/Head.asp" -->
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="150" align="center" valign="top"> <table width="150" height="100%" border="0" cellpadding="0" cellspacing="0" class="HeaderTdStyle">
<tr>
<td align="center" valign="top"><table width="100%" height="24" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center">功能菜单</td>
</tr>
</table>
<table width="100%" height="90%" border="0" cellpadding="0" cellspacing="0" class="MenuBg">
<tr>
<td align="center" valign="top"><br> <table width="90%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="16%"><img src="/Img/Left_1.gif" width="28" height="11"></td>
<td width="84%" height="20"><font color="#FFFF00">会员管理</font></td>
</tr>
</table>
<table width="90%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="34%" height="20" align="right"><img src="/Img/Left_1_1.gif" width="29" height="16"></td>
<td width="66%" valign="bottom"><a href="UserManage.asp"><font color="#FFFF00">注册会员管理</font></a></td>
</tr>
</table>
</td>
</tr>
</table></td>
</tr>
</table></td>
<td width="862" align="center" valign="top">
<br>
<br>
<br>
<br>
<%
if rs.eof and rs.bof then
response.write "目前共有 0 个注册用户"
else
totalPut=rs.recordcount
if currentpage<1 then
currentpage=1
end if
if (currentpage-1)*MaxPerPage>totalput then
if (totalPut mod MaxPerPage)=0 then
currentpage= totalPut \ MaxPerPage
else
currentpage= totalPut \ MaxPerPage + 1
end if
end if
if currentPage=1 then
showpage strFileName,totalput,MaxPerPage,true,true,"个用户"
showContent
showpage strFileName,totalput,MaxPerPage,true,true,"个用户"
else
if (currentPage-1)*MaxPerPage<totalPut then
rs.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rs.bookmark
showpage strFileName,totalput,MaxPerPage,true,true,"个用户"
showContent
showpage strFileName,totalput,MaxPerPage,true,true,"个用户"
else
currentPage=1
showpage strFileName,totalput,MaxPerPage,true,true,"个用户"
showContent
showpage strFileName,totalput,MaxPerPage,true,true,"个用户"
end if
end if
end if
sub showContent
dim i
i=0
%>
<table width="550" border="0" align="center" cellpadding="0" cellspacing="2" class="border">
<tr bgcolor="#C0C0C0" class="title">
<td width="30" height="25" align="center"><strong> 序号</strong></td>
<td width="59" height="25" align="center"><strong> 用户名</strong></td>
<td width="29" height="25" align="center"><strong> 性别</strong></td>
<td width="87" height="25" align="center"><strong>Email</strong></td>
<td width="185" height="25" align="center"><strong>公司名称</strong></td>
<td width="39" height="25" align="center"><strong> 状态</strong></td>
<td width="104" height="25" align="center" bgcolor="#C0C0C0"><strong>
操作</strong></td>
</tr>
<%do while not rs.EOF %>
<tr bgcolor="#E3E3E3" class="tdbg">
<td height="22" align="center"><%=rs("UserID")%></td>
<td align="center"><%=rs("username")%></td>
<td align="center">
<%if rs("Sex")=1 then
response.write "男"
else
response.write "女"
end if%>
</td>
<td><a href="Sendmail.asp?email=<%=rs("email")%>"><%=rs("email")%></a></td>
<td> <%=rs("Comane")%> </td>
<td align="center">
<%
if rs("LockUser")=true then
response.write "已锁定"
else
response.write "正常"
end if
%>
</td>
<td align="center"><a href="UserModify.asp?UserID=<%=rs("UserID")%>">修改</a>
<%if rs("LockUser")=False then %>
<a href="UserLock.asp?Action=Lock&UserID=<%=rs("UserID")%>">锁定</a>
<%else%>
<a href="UserLock.asp?Action=CancelLock&UserID=<%=rs("UserID")%>">解锁</a>
<%end if%>
<a href="UserDel.asp?UserID=<%=rs("UserID")%>" onClick="return ConfirmDel();">删除</a></td>
</tr>
<%
i=i+1
if i>=MaxPerPage then exit do
rs.movenext
loop
%>
</table>
<%
end sub
%>
</td>
</tr>
</table>
<!-- #include file="Inc/Foot.asp" -->
<%
rs.Close
set rs=Nothing
call CloseConn()
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -