📄 sqlistt.asp
字号:
<% Set hdobj = Server.CreateObject("HD.comOpen")'请确保此行在最前
Conn = hdobj.WeekaaConn()
if Session("AdminUser")<>"admin" then
response.write "对不起，你没有获得使用本功能的授权。"
response.end
end if
dim i,j,k,LL,L(20),p
for i=1 to 1000
LL="L"&i
p=""
p=request.form(LL)
if p<>"" then
for j=1 to 30
if L(j)="" then
L(j)=p
k=j
j=31
end if
next
end if
next
sub Lis(LA)
dim ro,sqlo,Kec
Set ro=Server.Createobject("Adodb.RecordSet")
sqlo = "Select c From [HRworker] where ID='"&LA&"'"
ro.Open sqlo,Conn,1,3
Kec=ro("c")
response.write "<a href='../HR/HR_Worker/Per.asp?ID="&LA&"' target='_blank'>"
response.write Kec&"</a>"
response.write "<br>"
ro.close
set ro=nothing
end sub
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<meta http-equiv="pragma" content="no-cache">
<title>红笛软件</title>
<style type="text/css">
<!--
.tables {
background-image: url(../Image/bigbg.jpg);
background-repeat: no-repeat;
}
.style3 {font-size: 12px}
.style4 { color: #FFFFFF;
font-size: 14px;
}
body,td,th {
font-size: 12px;
}
a:link {
text-decoration: none;
color: #000066;
}
a:visited {
text-decoration: none;
color: #000066;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
.B A:link {
FONT-SIZE: 12px; COLOR: #ffffff; TEXT-DECORATION: none
}
.B A:visited {
FONT-SIZE: 12px; COLOR: #ffffff; TEXT-DECORATION: none
}
.B A:hover {
FONT-SIZE: 12px; COLOR: #ffffff; TEXT-DECORATION: none
}
.B A:active {
FONT-SIZE: 12px; COLOR: #ffffff; TEXT-DECORATION: none
}
body {
background-color: #DEE7FF;
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
background-image: url(../Image/bg.gif);
}
.STYLE15 {
font-family: "黑体";
font-size: 16px;
}
.STYLE17 {color: #FFFFFF}
.STYLE18 {font-size: 12px; color: #FFFFFF; }
-->
</style>
</head>
<body onmouseover="self.status='红笛软件:服务网址[http://weekaa.com/red]';return true">
<table width="1003" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#3399fd">
<tr>
<td height="150" align="center" valign="bottom"><img src="../Image/bigbga.jpg" width="1003" height="150"></td>
</tr>
<tr>
<td height="28" align="center" valign="middle" background="../Image/bg01a.jpg"><span class="b"><a href="LoginList.asp">日志</a> <a href="SQlist.asp">授权</a> <a href="BF.asp">备份</a> <a href="Bak/HFa.asp">恢复</a> <a href="User_Edit.asp">管理密码</a> <a href="User_Edit.asp">老师密码</a> <a href="passstu.asp">学生密码</a></span></td>
</tr>
<tr>
<td height="20" align="center" valign="top" bgcolor="#3399FD"> </td>
</tr>
<tr>
<td height="400" align="center" valign="top" bgcolor="#3399FD">
<form name="form1" method="post" action="SQlistadd.asp">
<table width="90%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#3399FD">
<tr background="../User/image/hdb.jpg">
<td height="28" colspan="2" align="center" valign="middle" background="../Image/bg01.jpg"><span class="STYLE15">用户操作授权</span></td>
</tr>
<tr>
<td width="20%" align="center" valign="top" bgcolor="#3399FD"><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="30" align="center" bordercolor="#FFFFFF" bgcolor="#3399FD" class="STYLE15">授权对象</td>
</tr>
<tr bgcolor="#3399FD">
<td height="20" align="center" valign="top"><table width="90%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td height="30" align="center" bgcolor="#72B8FE"><span class="style4">授权名单</span></td>
</tr>
<tr>
<td height="30" align="center" bgcolor="#72B8FE"><span class="STYLE17">
<input type="hidden" name="K" value="<%=K%>">
<%
for i=1 to k
call lis(L(i))
LL="L"&i
%>
<input type="hidden" name="<%=LL%>" value="<%=L(i)%>">
<%
next
%>
</span></td>
</tr>
<tr>
<td height="30" bgcolor="#72B8FE"> </td>
</tr>
<tr>
<td height="30" bgcolor="#3399FD"> </td>
</tr>
<tr>
<td height="30" align="center" bgcolor="#72B8FE"><span class="style4">特别权限</span></td>
</tr>
<tr>
<td height="30" align="center" bgcolor="#72B8FE"><span class="STYLE18">数据删除权
<input name="a98" type="checkbox" id="a98" value="ok">
</span></td>
</tr>
<tr>
<td height="30" align="center" bgcolor="#72B8FE"><span class="STYLE18">添加修改权
<input name="a99" type="checkbox" id="a99" value="ok">
</span></td>
</tr>
</table></td>
</tr>
</table></td>
<td width="80%" valign="top"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" >
<tr>
<td height="30" align="center" bordercolor="#FFFFFF" bgcolor="#3399FD" class="STYLE15">授 权 内 容</td>
</tr>
<tr bordercolor="#FFFFFF">
<td align="center" bgcolor="#3399FD"><table width="698" border="0" align="center" cellpadding="2" cellspacing="0" bgcolor="#3399FD">
<tr>
<td width="114" height="105" align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Aa.gif"></td>
<td width="114" align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Ba.gif"></td>
<td width="114" align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Ca.gif"></td>
<td width="114" align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Da.gif"></td>
<td width="114" align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Ea.gif"></td>
<td width="114" align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Fa.gif"></td>
</tr>
<tr>
<td height="20" align="center" valign="middle" bgcolor="#3399FD"><input name="a1" type="checkbox" id="a1" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a2" type="checkbox" id="a2" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a3" type="checkbox" id="a3" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a4" type="checkbox" id="a4" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a5" type="checkbox" id="a5" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a6" type="checkbox" id="a6" value="ok"></td>
</tr>
<tr>
<td height="105" align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Ga.gif"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Ha.gif"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Ia.gif"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Ja.gif"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Ka.gif"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/La.gif"></td>
</tr>
<tr>
<td height="20" align="center" valign="middle" bgcolor="#3399FD"><input name="a7" type="checkbox" id="a7" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a8" type="checkbox" id="a8" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a9" type="checkbox" id="a9" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a10" type="checkbox" id="a10" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a11" type="checkbox" id="a11" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a12" type="checkbox" id="a12" value="ok"></td>
</tr>
<tr>
<td height="105" align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Ma.gif"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Na.gif"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Oa.gif"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Pa.gif"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Qa.gif"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Ra.gif"></td>
</tr>
<tr>
<td height="20" align="center" valign="middle" bgcolor="#3399FD"><input name="a13" type="checkbox" id="a13" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a14" type="checkbox" id="a14" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a15" type="checkbox" id="a15" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a16" type="checkbox" id="a16" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a17" type="checkbox" id="a17" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a18" type="checkbox" id="a18" value="ok"></td>
</tr>
<tr>
<td height="105" align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Sa.gif"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Ta.gif"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Ua.gif"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Va.gif"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Wa.gif"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Xa.gif"></td>
</tr>
<tr>
<td height="20" align="center" valign="middle" bgcolor="#3399FD"><input name="a19" type="checkbox" id="a19" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a20" type="checkbox" id="a20" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a21" type="checkbox" id="a21" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a22" type="checkbox" id="a22" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a23" type="checkbox" id="a23" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a24" type="checkbox" id="a24" value="ok"></td>
</tr>
<tr>
<td height="100" align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Ya.gif"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Za.gif"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/0a.gif" width="105" height="105"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/ZYa.gif" width="105" height="105"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/Helpa.gif" width="105" height="105"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><img src="../Image/main/SYSa.gif"></td>
</tr>
<tr>
<td height="20" align="center" valign="middle" bgcolor="#3399FD"><input name="a25" type="checkbox" id="a25" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a26" type="checkbox" id="a26" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a27" type="checkbox" id="a27" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD"><input name="a28" type="checkbox" id="a28" value="ok"></td>
<td align="center" valign="middle" bgcolor="#3399FD">不用授权</td>
<td align="center" valign="middle" bgcolor="#3399FD">禁止授权</td>
</tr>
<tr>
<td height="30" colspan="6" align="center" valign="middle" bgcolor="#3399FD"><input type="submit" name="Submit" value="提交授权"></td>
</tr>
</table>
<map name="Image1Map">
<area shape="circle" coords="93,20,10" href="help.asp" target="_blank">
</map> </td>
</tr></table></td>
</tr>
</table>
</form> </td>
</tr>
<tr>
<td height="25" bgcolor="#3399FD"> </td>
</tr>
<tr>
<td height="25" background="../Image/bg01a.jpg" bgcolor="#3399FD"> </td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -