?? adminuserclear.asp
字號:
<!--#include file="conn.asp"-->
<%
if session("adminname")="" then
response.redirect "relogin.asp"
end if
%>
<%
nianji=request("nianji")
banji=request("banji")
fanwei=request("fanwei")
sql4="select * from tbnianji order by nianjiid"
set rs4=server.createobject("adodb.recordset")
rs4.open sql4,conn,3,2
sql5="select * from tbbanji order by banjiid"
set rs5=server.createobject("adodb.recordset")
rs5.open sql5,conn,3,2
if nianji="--選擇科目--" or nianji="" then
nianji=rs4("nianji")
end if
if banji="--題型--" or banji="" then
banji=rs5("banji")
end if
%><html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>系統管理 | 綜合管理 | 清理數據</title>
<script language="javascript">
function editit(id)
{
page="adminuseredit.asp?userid="+id
window.open (page,'編輯用戶','width=500,height=350')
}
function viewit(myform)
{
if (document.viewaddform.nianji.value!="")
subject=document.viewaddform.nianji.value;
else
subject="所有";
if (document.viewaddform.banji.value!="")
type=document.viewaddform.banji.value;
else
type="所有";
myform.action="adminuserclear.asp";
myform.submit();
}
function searchit(myform)
{
if (document.viewaddform.nianji.value!="")
subject=document.viewaddform.nianji.value;
else
subject="所有";
if (document.viewaddform.banji.value!="")
type=document.viewaddform.banji.value;
else
type="所有";
if (document.viewaddform.mykey.value!="--關鍵字--")
mykey=document.viewaddform.mykey.value;
else
mykey="";
result="在<"+subject+">題庫中<"+type+">題目中搜索關鍵字<"+mykey+">？"
myform.action="adminuser1.asp";
myform.submit();
}
function addit(myform)
{
if (document.viewaddform.nianji.value!="" & document.viewaddform.banji.value!=""){
result="添加"+document.viewaddform.banji.value+"題目到"+document.viewaddform.nianji.value+"題庫？"
myform.action="adminadduser.asp";
myform.submit();
}
else
alert("請首先選擇科目和題目類型！")
}
function delit(myform)
{
if (confirm("將清理此用戶題庫下的所有數據？"))
{
myform.action="adminuserdata.asp";
myform.submit();
}
}
function FanAll(form){
for (var i=0;i<form.elements.length;i++){
var e = form.elements[i];
if (e.name == 'selAnnounce' && e.checked == false){ e.checked = true; }
else { e.checked = false;}
}}
</script>
<link rel="stylesheet" type="text/css" href="css.css">
</head>
<body>
<table border="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2" height="25">
<tr>
<td width="100%">當前位置： 系統管理 >
<a href="adminsomething.asp">綜合管理</a><span lang="en-us"> > </span>清理數據</td>
</tr>
</table>
<center>
<table border="1" cellspacing="1" style="border-collapse: collapse" id="AutoNumber2" bgcolor="#99CCFF" width="100%" background="images/admin_bg_1.gif" bordercolor="#799AE1">
<form name="viewaddform" method="POST" action="adminuser.asp">
<tr>
<td><center>
<select size="1" name="nianji">
<%
do while not rs4.eof
%><option value="<%=rs4("nianji")%>" <%if rs4("nianji")= nianji then %> selected <%end if%>><%=rs4("nianji")%></option>
<%
rs4.movenext
loop %>
</select><select size="1" name="banji">
<%
do while not rs5.eof
%><option value="<%=rs5("banji")%>" <%if rs5("banji")= banji then %> selected <%end if%>><%=rs5("banji")%></option>
<%
rs5.movenext
loop %>
</select><span lang="en-us"> </span><input type="submit" value="瀏 覽" name="I3" onclick="viewit(this.form)" class="s02"><span lang="en-us">
</span><input type="submit" value="添加用戶" name="I6" onclick="addit(viewaddform)" class="s02">
<input type="text" name="mykey" size="10" value="--關鍵字--" onfocus="this.select()" class="s01"><span lang="en-us">
<select size="1" name="fanwei">
<option <%if fanwei="username" then %> selected <%end if%> value="username">準考證號</option>
<option <%if fanwei="tname" then %> selected <%end if%> value="tname">姓 名</option>
<option <%if fanwei="email" then %> selected <%end if%> value="email">電子信箱</option>
</select></span>
<input type="submit" value="查 詢" name="I7" onclick="searchit(this.form)" class="s02"></center>
</td>
</tr>
</table></center>
<%
response.write "<br><center>"+request("success")+"</center>"
mykey=request("mykey")
if mykey= "--關鍵字--" or mykey="" then
mykey=""
end if
sql="select * from tbuser where nianji='"& nianji &"' and banji='"&banji &"' order by userid,username "
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
on error resume next
rs.PageSize = 10
Page = CLng(Request("Page"))
If Page < 1 Then Page = 1
If Page > rs.PageCount Then Page = rs.PageCount
i=page+(page-1)*9
rs.AbsolutePage = Page
%><%
if rs.eof then
%><p>
<br><br>
</p>
<center>
<h4><%=nianji%>——<%=banji%>——沒有用戶</h4></center>
<%
else%><br><center><b>
<%=rs("nianji")%>——<%=banji%>（共有用戶<%=rs.recordcount%>人）</b> </center>
<br>
<center>
<table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="100%" id="AutoNumber1" height="47">
<tr class="trh">
<td width="44" align="center" bgcolor="#799AE1" height="20">
<input type="submit" value="清理" name="del" onclick="delit(viewaddform)" class="s02"></td>
<td width="44" align="center" bgcolor="#799AE1"><font color="#FFFFFF"><b>序號</b></font></td>
<td align="left" bgcolor="#799AE1" width="114">
<p align="center"><font color="#FFFFFF"><b>準考證號</b></font></td>
<td align="left" bgcolor="#799AE1" width="98">
<p align="center"><font color="#FFFFFF"><b>姓 名</b></font></td>
<td align="left" bgcolor="#799AE1" width="103">
<p align="center"><font color="#FFFFFF"><b>密 碼</b></font></td>
<td align="left" bgcolor="#799AE1" width="119">
<p align="center"><font color="#FFFFFF"><b>電子信箱</b></font></td>
<td align="left" bgcolor="#799AE1" width="76">
<p align="center"><font color="#FFFFFF">狀 態</font></td>
<td align="left" bgcolor="#799AE1" width="67">
<p align="center"><font color="#FFFFFF">數據庫</font></td>
<td align="left" bgcolor="#799AE1" width="59">
<p align="center"><font color="#FFFFFF"><b>操作</b></font></td>
</tr>
<%
For iPage = 1 To rs.PageSize
%>
<tr class="trh1">
<td align="center" width="44">
<input type="checkbox" name='selAnnounce' value="<%=rs("userid")%>"></td>
<td align="center" width="44"><%=i%> </td>
<td align="center" width="114"><a href="javascript:editit(<%=rs("userid")%>)"><%=rs("username")%></a></td>
<td align="center" width="98"><%=rs("tname")%></td>
<td align="center" width="103"><%=rs("pwd")%></td>
<td align="center" width="119"><a href="mailto:<%=rs("email")%>"><%=rs("email")%></a></td>
<td align="center" width="76"><%if rs("isopen")=0 then %><font color="#FF0000">未審核</font><%else%>通過<%end if %></td>
<td align="center" width="67"><%
set rsdata1=server.createobject("adodb.recordset")
sqldata1="select * from userdata where username='"&rs("username")&"'"
rsdata1.open sqldata1,conn,3,2
if not rsdata1.eof then
response.write "<font color=#FF0000>滿</font>"
else
response.write "空"
end if
%></td>
<td align="left" width="59">
<p align="center"><a href="javascript:editit(<%=rs("userid")%>)">
<img border="0" src="images/edit.gif" alt="查看/編輯"></a></td>
</tr>
<%
rs.MoveNext
If rs.EOF Then Exit For
i=i+1
Next
%>
<caption></caption>
</table>
</center>
</form>
<div ALIGN="right">
<table>
<form ACTION="<%=Myself%>?nianji=<%=nianji%>&banji=<%=banji%>&mykey=<%=mykey%>%>" METHOD="POST">
<tr>
<td>
<p ALIGN="right">
<input type=checkbox name=del_all1 value=1 onclick=FanAll(viewaddform)>全選<span lang="en-us"> </span>
<INPUT class="s02" onclick="window.location='adminmanyuser.asp'" type=button value="批量添加" name=close1><span lang="en-us">
</span>
<INPUT class="s02" onclick="window.location='adminsomething.asp'" type=button value="返 回" name=close><%If Page <> 1 Then ' 如果不是位于第一頁%>
<span lang="en-us"> </span>
<a href="<%=Myself%>?Page=1&nianji=<%=nianji%>&banji=<%=banji%>&mykey=<%=mykey%>">
第一頁</a>
<a HREF="<%=Myself%>?Page=<%=(Page-1)%>&nianji=<%=nianji%>&banji=<%=banji%>&mykey=<%=mykey%>">
上一頁</a>
<%
End If
If Page <> rs.PageCount Then ' 如果不是位于最后一頁
%> <a HREF="<%=Myself%>?Page=<%=(Page+1)%>&nianji=<%=nianji%>&banji=<%=banji%>&mykey=<%=mykey%>">
下一頁</a>
<a HREF="<%=Myself%>?Page=<%=rs.PageCount%>&nianji=<%=nianji%>&banji=<%=banji%>&mykey=<%=mykey%>">
最后一頁</a> <% End If %>
<font SIZE="2">頁次:</font><font COLOR="Red" SIZE="2"><%=Page%>/<%=rs.PageCount%></font></p>
<p> </td>
</tr>
</form>
</table>
<%end if
sub deleteannounce(id)
dim rs2,sql
sql5="select * from tbuser where userid="&cstr(id)
set rs5=server.createobject("adodb.recordset")
rs5.open sql5,conn,3,2
username=rs5("username")
set rs2=server.createobject("adodb.recordset")
sql2="delete from tbistest where username='"&username&"'"
conn.execute sql2
sql3="delete from tbscore where username='"&username&"'"
conn.execute sql3
sql7="delete from userdata where username='"&username&"'"
conn.execute sql7
set rs6=server.createobject("adodb.recordset")
sql6="delete from tbuser where userid="&cstr(id)
conn.execute sql6
if err.Number<>0 then
err.clear
response.write "刪 除 失 敗 !<br>"
else
response.write "<br><center>刪 除 成 功！</center>"
end if
End sub
%></div>
</div>
</td>
</tr>
</table>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -