📄 class_proauth.asp

📁 ASP网页
💻 ASP
字号:
<%@ Language=VBScript %>
<%
Response.Buffer=true
Response.Expires=0
if Session("userqx")>="1" and Session("userqx")<="9" then
else
	Response.Redirect "../warn.asp"
end if
%>
<!-- #include file="../dsn.asp" -->
<%
classcode=Request.QueryString("classcode")
keyno=Request.QueryString("keyno")
pageno=Request.QueryString("pageno")

if classcode="" then Response.End

tablename="product"
set cn=server.CreateObject("ADODB.Connection")
cn.Open mycnstr
set rs=server.CreateObject("ADODB.Recordset")
set rs2=server.CreateObject("ADODB.Recordset")

sqltext="select classname from "+tablename+"_class where classcode='"+classcode+"'"
rs.Open sqltext,cn,1,1
if not rs.EOF then
	classname=trim(rs(0))
else
	Response.End
end if
rs.Close

ordertxt="order by username asc"
htmltitle="产品小类操作权限管理"

htmlname="class_proauth.asp?classcode="+classcode

if Request.ServerVariables("REQUEST_METHOD")="POST" then
	
	sqltext="delete from pro_auth where classcode='"+classcode+"'"
	'Response.Write sqltext
	cn.Execute sqltext
	
	rectot=Request.Form("rectot")
	for i=1 to rectot
		checksele=Request.Form("checksele"&i)
		if checksele<>"" then
			seleitem=Request.Form("seleitem"&i)
			sqltext="insert into pro_auth values('"+classcode+"','"+seleitem+"','1')"
			'Response.Write sqltext
			cn.Execute sqltext
		end if
	next
	Response.Write("<font color=red>权限已成功修改！</font>")
end if
%>
<HTML>
<HEAD>
<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: 宋体;}
.t1 {font:12px 宋体;color=000000} 
.t2 {font:12px 宋体;color:ffffff} 

.bt1 {font:14px 宋体;color=000000} 
.bt2 {font:14px 宋体;color:ffffff} 

A:link {color: #000066}
A:visited {color: #000066}
A:hover {color: #ff0000}

A.r1:link {font-size:12px;text-decoration:underline;color:#000000;}
A.r1:visited {font-size:12px;text-decoration:underline;color:#000000;}
A.r1:hover {font-size:12px;text-decoration:underline;color:#ff6600;}

A.r2:link {font-size:12px;text-decoration:underline;color:#ffffff;}
A.r2:visited {font-size:12px;text-decoration:underline;color:#ffffff;}
A.r2:hover {font-size:12px;text-decoration:underline;color:#ff6600;}
-->
</style>
</HEAD>
<body topmargin=5 leftmargin=5 bgcolor=#ffffff>
<table width="100%" align=center border="0" cellspacing="0" cellpadding="2">
	<form name=form1 method="post" action="<%=htmlname%>&pageno=<%=pageno%>">
	<tr><td align="left">
		<table width="100%" border="0" cellspacing="0" cellpadding="0"  height=24>
			<tr valign=bottom>
				<td style="font-size:12px;">&nbsp;
				<font color=DarkSlateGray style="font-size:14px"><b><%=htmltitle%></b></font>
				<font color=#ff4500 style="font-size:12px">(<%=classname%>)</font>
				<a href="<%=htmlname%>&pageno=<%=pageno%>">[刷新列表]</a>
				<a href="product_class.asp?parentcode=<%=left(classcode,3)%>">[返回]</a>
			</td><td>	
				<input type="submit" name="mydele" value="权限分配" style="background-color:527c72;width:90px;height:22px;color:ffffff;cursor:hand">
				<input type="checkbox" name="seleall" onclick="checkall(form1)" >选择所有人员
			</td>
			</tr>
			</table>
	</td></tr>
	<%
		sqltext="select username,realname from adminuser "+ordertxt
		rs.Open sqltext,cn,1,1
		
		listcount=30
		rs.PageSize=listcount
		if pageno="" then pageno=1 else pageno=cint(pageno)	
		if rs.PageCount>0 then rs.AbsolutePage=pageno

	%>
	<tr><td>
		<table width="100%" border="0" cellspacing="1" cellpadding="1">
			<tr bgcolor="527c72" style="color:#ffffff" align="center">
				<td height=18 width="35" class=t2></td>
				<td class=t2>用户编号</td>
				<td width="80" class=t2>用户名称</td>
				<td>&nbsp;</td>
			</tr>
		<%
		i=1
		do while not rs.EOF and i<=listcount
			if (i mod 2)=0 then
				Response.Write("<tr bgcolor=fefefe>")
			else
				Response.Write("<tr bgcolor=efefef>")
			end if	
		%>
			<td width="35" align=right>
			    <%
				sqltext="select authority from pro_auth where classcode='"+classcode+"' and username='"+trim(rs("username"))+"'"
				rs2.open sqltext,cn,1,1
				if not rs2.EOF then
				%>
					<input type=checkbox id='checksele<%=i%>' name='checksele<%=i%>' value='1' checked>
				<%	
				else
				%>
					<input type=checkbox id='checksele<%=i%>' name='checksele<%=i%>' value='0'>
				<%	
				end if
				rs2.Close
				%>
				<input type=hidden id="seleitem<%=i%>" name="seleitem<%=i%>" value="<%=trim(rs("username"))%>">
			</td>
			<td width="100" align="center" height=20><%=trim(rs("username"))%></td>
			<td width="100" align="left" height=20><%=trim(rs("realname"))%></td>
			<td>&nbsp;</td>
			</tr>
		<%	
			i=i+1
			rs.MoveNext
		loop
		%>
		 <input type=hidden value="<%=i-1%>" name=rectot>   	
		 </table>
	</td></tr>
	<tr><td>
		<table width="100%" cellspacing="0" cellpadding="0" border=0> 
		<tr><td><hr size=1></td></tr>
			<tr><td align=right>
			[第<b><%=pageno%></b>页, 共<b><%=rs.PageCount%></b>页<b><%=rs.RecordCount%></b>条记录]			
			<%if pageno>1 then%>
				<a class=r1 href="<%=htmlname%>&pageno=1">[首页]</a>              
				<a class=r1 href="<%=htmlname%>&pageno=<%=pageno-1%>">[上页]</a>              
			<%end if              
			if pageno<rs.PageCount then%>              
				<a class=r1 href="<%=htmlname%>&pageno=<%=pageno+1%>">[下页]</a>              
				<a class=r1 href="<%=htmlname%>&pageno=<%=rs.PageCount%>">[末页]</a>              
			<%end if%>              
			</td></tr>              
		</table>
	</td></tr>
	</form>
</table>
</body>
</html>

<script language="Javascript">

	function delrec(code)
	{
		if (confirm('您确认要删除吗？')==true)
		{
		window.location.href="<%=htmlname%>&keyno="+code
		}
	}

	function checkall(form)
	 {
		  for (var i=0;i<form.elements.length;i++)
		    {
			    var obj = form.elements[i];
			    var objname=obj.name;
			   
			    if(objname.substring(0,9)=="checksele")
					{
					 obj.checked=form.seleall.checked	
					}
		    }
	  }
	
</script>
⌨️ 快捷键说明

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