⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 admin_group.asp

📁 这是去年开发的中移鼎讯手机进销存系统 大家
💻 ASP
字号:
<!--#include file="../inc/function.asp"-->
<!--#include file="../inc/ChkPurview.asp"-->
<%
'组管理
'只有省级用户的管理员才能进入。
Dim Action,iCount
Action=Trim(request("Action"))
if GetUserGPower<>9999 or GetUserPower<>"A" then 
	Call  Msg("您没有权限",1,"")
End if

%>
<html>
<head>
<title>组管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css/mobile_sale.css" rel="stylesheet" type="text/css">
<SCRIPT language=javascript>
function CheckAdd()
{
  if(document.form1.UserGName.value=="")
    {
      alert("组名不能为空!");
	  document.form1.UserGName.focus();
      return false;
    }
    
  if (document.form1.Purview[1].checked==true){
	GetClassPurview();
  }
}

function CheckModifyPurview()
{
  if (document.form1.Purview[1].checked==true){
	GetClassPurview();
  }
}

</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="70" height="30"><strong>管理导航:</strong></td>
    <td height="30"><a href="Admin_Group.asp">用户组管理</a>&nbsp;|&nbsp;<a href="Admin_Group.asp?Action=Add">添加新组</a></td>
  </tr>
</table>
<%
if Action="Add" then
	call AddAdmin()
elseif Action="SaveAdd" then
	call SaveAdd()
elseif Action="ModifyPwd" then
	call ModifyPwd()
elseif Action="SaveModifyPwd" then
	call SaveModifyPwd()
elseif Action="Del" then
	call DelAdmin()
else
	call main()
end if

Call CONN_End(Conn)

sub main()
	Sql="select * from T_UserGroup Order By UserGID"
	Call sql_open(Rs,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_Group.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="60" height="22"><strong> 用户组名</strong></td>
    <td><strong>权限说明</strong></td>
    <td  width="60"><strong>权限指数</strong></td>
    <td  width="60"><strong>用户数</strong></td>
    <td  width="150" height="22"><strong> 操 作</strong></td>
  </tr>
  <%Do While Not Rs.EOF %>
  <tr class="tdbg" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor='#BFDFFF'"> 
    <td><%=Rs("UserGName")%></td>
    <td><%=Rs("UserGInfo")%></td>
    <td width="60"><%=Rs("UserGPower")%></td>
    <td width="60"><%=Rs("UserNum")%></td>
    <td width="150">
	<%
		Response.write "<a href='Admin_Group.asp?Action=ModifyPwd&ID=" & rs("UserGID") & "'>修改</a>&nbsp;&nbsp;"
		Response.write "<a href='Admin_Group.asp?Action=Del&ID=" & rs("UserGID") & "' onClick=""return confirm('确定要删除此组吗?');"">删除</a>"
	%>	</td>
  </tr>
  <%
	Rs.MoveNext
loop
  %>
</table>  
</td>
</form></tr></table>
<%
	Call Rs_End(Rs)
end sub

sub AddAdmin()
%>
<form method="post" action="Admin_Group.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 class="tdbg"><strong>组名: </strong></td>
      <td class="tdbg"><input name="UserGName" type="text" id="UserGName"></td>
    </tr>
    <tr class="tdbg">
      <td class="tdbg"><strong>权限指数:</strong></td>
      <td class="tdbg"><input name="UserGPower" type="text" id="UserGPower" maxlength="4"></td>
    </tr>
    <tr class="tdbg"> 
      <td width="35%" class="tdbg"><strong>权限说明:</strong></td>
      <td width="65%" class="tdbg"><textarea name="UserGInfo" id="UserGInfo"></textarea></td>
    </tr>
    <tr> 
      <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;"> 
        &nbsp; <input name="Cancel" type="button" id="Cancel" value=" 取 消 " onClick="window.location.href='Admin_Group.asp'" style="cursor:hand;"></td>
    </tr>

  </table>
</form>
<%
end sub

sub ModifyPwd()
	dim UserGID
	UserGID=trim(Request("ID"))
	if UserGID="" then
		Call Msg("请指定要修改的组", 1,"")
		exit sub
	else
		UserGID=Clng(UserGID)
	end if
	
	Sql="Select * from T_UserGroup where UserGID=" & UserGID
	Call sql_open(Rs,Sql,Conn,1,3)
	If Rs.Bof And Rs.EOF Then
		Call Msg("不存在此用户", 1,"")
	Else
%>
<form method="post" action="Admin_Group.asp" name="form1" onsubmit="javascript:return CheckModifyPwd();">
  <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>
      <td class="tdbg"><strong>组名: </strong></td>
      <td class="tdbg"><input name="UserGName" type="text" id="UserGName" value="<%=Rs("UserGName")%>"></td>
    </tr>
    <tr class="tdbg">
      <td class="tdbg"><strong>权限指数:</strong></td>
      <td class="tdbg"><input name="UserGPower" type="text" id="UserGPower" maxlength="4" value="<%=Rs("UserGPower")%>"></td>
    </tr>
    <tr class="tdbg"> 
      <td width="35%" class="tdbg"><strong>权限说明:</strong></td>
      <td width="65%" class="tdbg"><textarea name="UserGInfo" id="UserGInfo"><%=Rs("UserGInfo")%></textarea></td>
    </tr>
    <tr> 
      <td colspan="2" align="center" class="tdbg"><input name="ID" type="hidden" id="ID" value="<%=Rs("UserGID")%>">        <input name="Action" type="hidden" id="Action" value="SaveModifyPwd"> 
        <input  type="submit" name="Submit" value="保存修改结果" style="cursor:hand;">
        &nbsp;
        <input name="Cancel" type="button" id="Cancel" value=" 取 消 " onClick="window.location.href='Admin_Group.asp'" style="cursor:hand;"></td>
    </tr>
  </table>
</form>
<%
	End If
	Call Rs_End(Rs)
End Sub
%>
</body>
</html>
<%
'增加新组
Sub SaveAdd()
	dim UserGName,UserGPower,UserGInfo
	UserGName=trim(Request("UserGName"))
	UserGPower=Request("UserGPower")
	UserGInfo=Request("UserGInfo")
	if UserGName="" then
		Call Msg("组名不能为空", 1,"")
	end if
	Sql="Select * from T_UserGroup where UserGName='"&UserGName&"'"
	Call sql_open(Rs,Sql,Conn,1,3)
	if not (rs.bof and rs.EOF) then
		Call Msg("数据库中已经存在此组", 1,"")
		Call Rs_End(Rs)
		exit sub
	end if
   	rs.addnew
 	rs("UserGName")=UserGName
	rs("UserGPower")=UserGPower	
	rs("UserGInfo")=UserGInfo	
	rs.update
    Call Rs_End(Rs)
	Call main()
end sub
'修改组
sub SaveModifyPwd()
	dim UserGID,UserGName,UserGPower,UserGInfo
	UserGID=trim(Request("ID"))
	UserGName=trim(Request("UserGName"))
	UserGPower=Request("UserGPower")
	UserGInfo=Request("UserGInfo")	
	if UserGID="" then
		Call Msg("请指定要修改的组", 1,"")
	else
		UserGID=Clng(UserGID)
	end if
	Sql="Select * from T_UserGroup where UserGID=" & UserGID
	Call sql_open(Rs,Sql,Conn,1,3)
	if rs.Bof and rs.EOF then
		Call Msg("不存在此组", 1,"")
		Call Rs_End(Rs)
		exit sub
	end if
	Rs("UserGName")=UserGName
	Rs("UserGPower")=UserGPower
	Rs("UserGInfo")=UserGInfo
 	rs.update
	rs.Close
   	set rs=Nothing
    call main()
end sub
'删除组
sub DelAdmin()
	dim UserGID
	UserGID=trim(Request("ID"))
	if UserGID="" then
		Call Msg("请指定组", 1,"")
		exit sub
	end if
	if instr(UserGID,",")>0 then
		UserGID=replace(UserGID," ","")
		sql="Select * from T_UserGroup where UserGID in (" & UserGID & ")"
	else
		UserGID=clng(UserGID)
		sql="select * from T_UserGroup where UserGID=" & UserGID
	end if
	Call sql_open(Rs,Sql,Conn,1,3)
	do while not rs.eof

		rs.delete
		rs.update
		rs.movenext
	loop
	Call Rs_End(Rs)
	call main()
end sub

%>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -