📄 admin_admin.asp
字号:
<%@language=vbscript codepage=936 %>
<!--#include file="../inc/conn.asp"-->
<!--#include file="../inc/md5.asp"-->
<!--#include file="../inc/config.asp"-->
<%
dim rs, sql, strPurview,iCount
dim Action,FoundErr,ErrMsg
Action=Trim(request("Action"))
%>
<html>
<head>
<title>管理员管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="Admin_Style.css" rel="stylesheet" type="text/css">
<SCRIPT language=javascript>
function unselectall()
{
if(document.myform.chkAll.checked){
document.myform.chkAll.checked = document.myform.chkAll.checked&0;
}
}
function CheckAll(form)
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
if (e.Name != "chkAll"&&e.disabled!=true)
e.checked = form.chkAll.checked;
}
}
function CheckAdd()
{
if(document.form1.username.value=="")
{
alert("用户名不能为空！");
document.form1.username.focus();
return false;
}
if(document.form1.Password.value=="")
{
alert("密码不能为空！");
document.form1.Password.focus();
return false;
}
if((document.form1.Password.value)!=(document.form1.PwdConfirm.value))
{
alert("初始密码与确认密码不同！");
document.form1.PwdConfirm.select();
document.form1.PwdConfirm.focus();
return false;
}
}
function CheckModify()
{
if((document.form1.Password.value)!=(document.form1.PwdConfirm.value))
{
alert("初始密码与确认密码不同！");
document.form1.PwdConfirm.select();
document.form1.PwdConfirm.focus();
return false;
}
}
</script>
</head>
<body leftmargin="2" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class="border">
<tr class="topbg">
<td height="22" colspan="2" align="center"><strong>管 理 员 管 理</strong></td>
</tr>
<tr class="tdbg">
<td width="119" height="30"><strong>管理导航：</strong></td>
<td width="635" height="30"><a href="Admin_Admin.asp">管理员管理首页</a> | <a href="Admin_Admin.asp?Action=Add">新增管理员</a></td>
</tr>
</table>
<%
if Action="Add" then
call AddAdmin()
elseif Action="SaveAdd" then
call SaveAdd()
elseif Action="Modify" then
call Modify()
elseif Action="SaveModify" then
call SaveModify()
elseif Action="Del" then
call DelAdmin()
else
call main()
end if
if FoundErr=True then
call WriteErrMsg()
else
call ShowHelp()
end if
call CloseConn()
sub main()
Set rs=Server.CreateObject("Adodb.RecordSet")
sql="select * from oa_admin order by id"
rs.Open sql,conn,1,1
iCount=rs.recordcount
%>
<br>
<table width='100%' border="0" cellpadding="0" cellspacing="0">
<tr>
<form name="myform" method="Post" action="Admin_Admin.asp" onsubmit="return confirm('确定要删除选中的管理员吗？');">
<td>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class="border">
<tr align="center" class="title">
<td width="32"><strong>选中</strong></td>
<td width="28" height="22"><strong> 序号</strong></td>
<td width="184" height="22"><strong> 用 户 名</strong></td>
<td width="100" height="22"><strong> 权 限</strong></td>
<td width="100"><strong>最后登录IP</strong></td>
<td width="120"><strong>最后登录时间</strong></td>
<td width="79"><strong>登录次数</strong></td>
<td width="81" height="22"><strong> 操 作</strong></td>
</tr>
<%do while not rs.EOF %>
<tr align="center" class="tdbg" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor='#F7F7F7'">
<td width="32"> <input name="ID" type="checkbox" id="ID" value="<%=rs("ID")%>" <%if rs("UserName")=session("Admin") then response.write " disabled"%> onclick="unselectall()">
</td>
<td width="28"><%=rs("ID")%></td>
<td>
<%
if rs("username")=session("Admin") then
response.write "<font color=red><b>" & rs("UserName") & "</b></font>"
else
response.write rs("UserName")
end if
%>
</td>
<td width="100">
<%
select case rs("purview")
case 1
strPurview="管理员"
case 2
strpurview="公文发布"
end select
response.write(strPurview)
%>
</td>
<td width="100">
<%
if rs("LastLoginIP")<>"" then
response.write rs("LastLoginIP")
else
response.write " "
end if
%>
</td>
<td width="120">
<%
if rs("LastLoginTime")<>"" then
response.write rs("LastLoginTime")
else
response.write " "
end if
%>
</td>
<td width="79">
<%
if rs("LoginTimes")<>"" then
response.write rs("LoginTimes")
else
response.write "0"
end if
%>
</td>
<td width="81">
<%
response.write "<a href='Admin_Admin.asp?Action=Modify&ID=" & rs("ID") & "'>修改</a> "
if iCount>1 and rs("UserName")<>session("Admin") then
response.write "<a href='Admin_Admin.asp?Action=Del&ID=" & rs("ID") & "' onClick=""return confirm('确定要删除此管理员吗？');"">删除</a>"
else
response.write " "
end if
%>
</td>
</tr>
<%
rs.MoveNext
loop
%>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="200" height="30"><input name="chkAll" type="checkbox" id="chkAll" onclick=CheckAll(this.form) value="checkbox">
选中本页显示的所有管理员</td>
<td><input name="Action" type="hidden" id="Action" value="Del">
<input name="Submit" type="submit" id="Submit" value="删除选中的管理员"></td>
</tr>
</table>
</td>
</form></tr></table>
<%
rs.Close
set rs=Nothing
end sub
sub AddAdmin()
%>
<form method="post" action="Admin_Admin.asp" name="form1" onsubmit="javascript:return CheckAdd();">
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class="border" >
<tr class="title">
<td height="22" colspan="2"> <div align="center"><strong>新 增 管 理 员</strong></div></td>
</tr>
<tr class="tdbg">
<td width="300" class="tdbg"><strong> 用 户 名：</strong></td>
<td class="tdbg"><input name="username" type="text"> </td>
</tr>
<tr class="tdbg">
<td width="300" class="tdbg"><strong> 初始密码： </strong></td>
<td class="tdbg"><font size="2">
<input type="password" name="Password">
</font></td>
</tr>
<tr class="tdbg">
<td width="300" class="tdbg"><strong> 确认密码：</strong></td>
<td class="tdbg"><font size="2">
<input type="password" name="PwdConfirm">
</font></td>
</tr>
<tr class="tdbg">
<td width="300" class="tdbg"><strong>权限设置： </strong></td>
<td class="tdbg"><select name="purview" id="purview">
<option value="1" selected>管理员</option>
<option value="2">高级用户</option>
</select></td>
</tr>
<tr class="tdbg">
<td height="40" colspan="2" align="center" class="tdbg"><input name="Action" type="hidden" id="Action" value="SaveAdd">
<input type="submit" name="Submit" value=" 添 加 " style="cursor:hand;">
<input name="Cancel" type="button" id="Cancel" value=" 取 消 " onClick="window.location.href='Admin_Admin.asp'" style="cursor:hand;"></td>
</tr>
</table>
</form>
<%
end sub
sub Modify()
dim UserID,Purview
UserID=trim(Request("ID"))
if UserID="" then
FoundErr=True
ErrMsg=ErrMsg & "<br><li>请指定要修改的管理员ID</li>"
exit sub
else
UserID=Clng(UserID)
end if
sql="Select * from oa_Admin where ID=" & UserID
Set rs=Server.CreateObject("Adodb.RecordSet")
rs.Open sql,conn,1,3
if rs.Bof and rs.EOF then
FoundErr=True
ErrMsg=ErrMsg & "<br><li>不存在此用户！</li>"
else
Purview=rs("Purview")
%>
<form method="post" action="Admin_Admin.asp" name="form1" onsubmit="javascript:return CheckModify();">
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class="border" >
<tr class="title">
<td height="22" colspan="2"> <div align="center"><font size="2"><strong>修
改 管 理 员 信 息</strong></font></div></td>
</tr>
<tr>
<td width="300" class="tdbg"><strong>用 户 名：</strong></td>
<td class="tdbg"><%=rs("UserName")%> <input name="ID" type="hidden" value="<%=rs("ID")%>"></td>
</tr>
<tr>
<td width="300" class="tdbg"><strong>新 密 码：</strong><br><font color="#0000FF">如果不想修改，请保持为空</font></td>
<td class="tdbg"><input type="password" name="Password">
</td>
</tr>
<tr>
<td width="300" class="tdbg"><strong>确认密码：</strong><br><font color="#0000FF">如果不想修改，请保持为空</font></td>
<td class="tdbg"><input type="password" name="PwdConfirm">
</td>
</tr>
<tr>
<td width="300" class="tdbg"><strong>权限设置： </strong></td>
<td class="tdbg"><select name="purview" id="purview">
<option value="1" <%if purview=1 then %>selected<% end if %>>管理员</option>
<option value="2" <%if purview=2 then %>selected<% end if %>>高级用户</option>
</select>
<input name="OldPurview" type="hidden" id="OldPurview" value="<%=purview%>"></td>
</tr>
<tr>
<td colspan="2" align="center" class="tdbg"><input name="Action" type="hidden" id="Action" value="SaveModify">
<input type="submit" name="Submit" value=" 确 定 " style="cursor:hand;">
<input name="Cancel" type="button" id="Cancel" value=" 取 消 " onClick="window.location.href='Admin_Admin.asp'" style="cursor:hand;"></td>
</tr>
</table>
</form>
<%
end if
rs.close
set rs=nothing
end sub
%>
<%
sub ShowHelp()
%>
<br>
<table width="100%" border="0" cellspacing="1" cellpadding="2" class="border">
<tr class="title">
<td height="22" colspan="2"><strong>管理员权限说明</strong></td>
</tr>
<tr valign="top" class="tdbg">
<td width="121" align="right"><strong>高级用户：</strong></td>
<td width="633">查看各用户信息的权限。</td>
</tr>
<tr valign="top" class="tdbg">
<td width="121" align="right"><strong>管理员：</strong></td>
<td>拥有所有管理权限。</td>
</tr>
</table>
<%
end sub
%>
</body>
</html>
<%
sub SaveAdd()
dim username, password,PwdConfirm, purview
dim ClassID
username=trim(Request("username"))
password=trim(Request("Password"))
PwdConfirm=trim(request("PwdConfirm"))
purview=trim(Request("purview"))
ClassID=trim(request("ClassID"))
if username="" then
FoundErr=True
ErrMsg=ErrMsg & "<br><li>用户名不能为空！</li>"
end if
if password="" then
FoundErr=True
ErrMsg=ErrMsg & "<br><li>初始密码不能为空！</li>"
end if
if PwdConfirm<>Password then
FoundErr=True
ErrMsg=ErrMsg & "<br><li>确认密码必须与初始密码相同！</li>"
end if
if purview="" then
FoundErr=True
ErrMsg=ErrMsg & "<br><li>用户权限不能为空！</li>"
else
purview=CInt(purview)
end if
if FoundErr=True then
exit sub
end if
sql="Select * from oa_Admin where username='"&username&"'"
Set rs=Server.CreateObject("Adodb.RecordSet")
rs.Open sql,conn,1,3
if not (rs.bof and rs.EOF) then
FoundErr=True
ErrMsg=ErrMsg & "<br><li>数据库中已经存在此管理员！</li>"
rs.close
set rs=nothing
exit sub
end if
password=md5(password)
rs.addnew
rs("username")=username
rs("password")=password
rs("purview")=purview
rs.update
rs.Close
set rs=Nothing
Call main()
end sub
sub SaveModify()
dim UserID, UserName,password,PwdConfirm,Purview,OldPurview
UserID=trim(Request("ID"))
if UserID="" then
FoundErr=True
ErrMsg=ErrMsg & "<br><li>请指定要修改的管理员ID</li>"
else
UserID=Clng(UserID)
end if
password=trim(Request("Password"))
PwdConfirm=trim(request("PwdConfirm"))
purview=trim(Request("purview"))
if PwdConfirm<>Password then
FoundErr=True
ErrMsg=ErrMsg & "<br><li>确认密码必须与新密码相同！</li>"
end if
if purview="" then
FoundErr=True
ErrMsg=ErrMsg & "<br><li>用户权限不能为空！</li>"
else
purview=CInt(purview)
end if
if FoundErr=True then
exit sub
end if
sql="Select * from oa_Admin where ID=" & UserID
Set rs=Server.CreateObject("Adodb.RecordSet")
rs.Open sql,conn,1,3
if rs.Bof and rs.EOF then
FoundErr=True
ErrMsg=ErrMsg & "<br><li>不存在此用户！</li>"
rs.close
set rs=nothing
exit sub
end if
if Password<>"" then
rs("password")=md5(password)
end if
rs("purview")=purview
rs.update
if OldPurview=4 and Purview<>4 then
call RemoveClassMaster(rs("UserName"))
end if
rs.Close
set rs=Nothing
call main()
end sub
sub DelAdmin()
dim UserID
UserID=trim(Request("ID"))
if UserID="" then
FoundErr=True
ErrMsg=ErrMsg & "<br><li>请指定要删除的管理员ID</li>"
exit sub
end if
if instr(UserID,",")>0 then
UserID=replace(UserID," ","")
sql="Select * from oa_Admin where ID in (" & UserID & ")"
else
UserID=clng(UserID)
sql="select * from oa_Admin where ID=" & UserID
end if
Set rs=Server.CreateObject("Adodb.RecordSet")
rs.Open sql,conn,1,3
do while not rs.eof
if rs("Purview")=4 then
call RemoveClassMaster(rs("UserName"))
end if
rs.delete
rs.update
rs.movenext
loop
rs.close
set rs=nothing
call main()
end sub
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -