?? pg_wd.asp
字號:
<!--#include file="conn.asp"-->
<%
if session("adminname")="" then
response.redirect "relogin.asp"
end if
%>
<%
userid=request("userid")
sql1="SELECT * from tbuser where userid="&userid
set rs1=server.createobject("adodb.recordset")
rs1.open sql1,conn,3,2
username=rs1("username")
kcid=request("kcid")
paperno=request("paperno")
nianji=rs1("nianji")
banji=rs1("banji")
category=request("category")
%>
<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>
<link rel="stylesheet" type="text/css" href="css.css">
</head>
<body><center><b><%=nianji%>級--<%=banji%>——<%=username%></b></center>
<% sqltm="SELECT * FROM tbkcconfig where kcid="&kcid&" and category=6 and paperno="&paperno
set rstm=server.createobject("adodb.recordset")
rstm.open sqltm,conn,3,2
sqlp="SELECT * FROM tbpaper where paperno="&paperno
set rsp=server.createobject("adodb.recordset")
rsp.open sqlp,conn,3,2
sql="SELECT top "&rstm("datano")&" tbtk.tmid, tbtk.title,tbtk.category, tbkc.kcid, tbkc.kcm, tbtk.chapter,photo FROM tbkc, userdata, tbtk WHERE username='"&username&"' and userdata.tmid=tbtk.tmid and tbtk.kcid=tbkc.kcid and tbkc.kcid="&kcid&" and paperno="&paperno &" and kao=1 and category=6 order by tbtk.tmid;"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
on error resume next
%>當前位置：批改試卷 > <%=rs("kcm")%>——<%=rsp("info")%>
<center><form name="viewdatabase" ACTION="<%=Myself%>" method="post">
<table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="100%" id="AutoNumber1" height="339">
<tr class="trh">
<td width="37" align="center" bgcolor="#799AE1" height="22">
<font color="#FFFFFF"><b>序號</b></font></td>
<td align="center" bgcolor="#799AE1" width="599" height="22">
<p align="center"><font color="#FFFFFF"><b>簡答題（共<%=rstm("datano")%>題,<%=rstm("datano")*rstm("datavalue")%>分）</b></font></td>
</tr>
<%
rs.PageSize =2
Page = CLng(Request("Page"))
If Page < 1 Then Page = 1
If Page > rs.PageCount Then Page = rs.PageCount
i=page+(page-1)*1
rs.AbsolutePage = Page
For iPage = 1 To rs.PageSize
sql3="SELECT * FROM userdata where username='"&username&"' and tmid="&rs("tmid")&" and paperno="&paperno
set rs3=server.createobject("adodb.recordset")
rs3.open sql3,conn,3,2
fen1="fen"&rs("tmid")
if Request.ServerVariables("http_method")="POST" then
fen=request(""&fen1&"")
rs3("fen")=fen
rs3.update
end if
%>
<tr class="trh1">
<td align="center" height="35" width="37"><%=i%> </td>
<td align="left" width="599" height="35"><br>試題——<%=htmlencode(rs("title"))%> <br><% if len(rs("photo")) > 1 then
%> <center>
<img border="0" src="examimage/<%=rs("photo")%>"></center>
<br><% end if %>
標準答案：<br> <textarea rows="6" onblur="this.className='inputnormalleft'" onfocus="this.className='inputedit';this.select()" class="inputnormalleft" readonly cols="60"><%=rs3("ans")%></textarea>
<br>您的答案：<br> <textarea rows="6" onblur="this.className='inputnormalleft'" onfocus="this.className='inputedit';this.select()" class="inputnormalleft" readonly cols="60" name="S1"><%=rs3("uans")%></textarea><br>
您的得分：<select size="1" name="<%=fen1%>" class="s02">
<% singvalue=rstm("datavalue")
for sing=0 to singvalue %>
<option <%if rs3("fen")=sing then %>selected <%end if%> value="<%=sing%>"><%=sing%>分</option>
<%next%>
</select>
</td>
</tr>
<%
rs.MoveNext
If rs.EOF Then Exit For
i=i+1
Next
%>
<tr>
<td align="center" bgcolor="#FFFFFF" height="33" width="640" colspan="2" bordercolor="#FFFFFF">
<input type="submit" value="給 分" name="I3" class="s02"><span lang="en-us">
</span>
<input type="button" value="關閉窗口" name="B2" onclick="self.close()" class="s02"></td>
</tr>
<caption></caption>
</table>
</form>
</center>
<center> <form ACTION="<%=Myself%>" METHOD="GET">
<table style="border-collapse: collapse" bordercolor="#111111" cellpadding="0" cellspacing="0">
<tr>
<td width="576">
<p ALIGN="center"><%If Page <> 1 Then ' 如果不是位于第一頁%>
<a href="<%=Myself%>?Page=1&kcid=<%=kcid%>&userid=<%=userid%>&category=<%=category%>&paperno=<%=paperno%>">第一頁</a>
<a HREF="<%=Myself%>?Page=<%=(Page-1)%>&kcid=<%=kcid%>&userid=<%=userid%>&category=<%=category%>&paperno=<%=paperno%>">上一頁</a>
<%
End If
If Page <> rs.PageCount Then ' 如果不是位于最后一頁
%> <a HREF="<%=Myself%>?Page=<%=(Page+1)%>&kcid=<%=kcid%>&userid=<%=userid%>&category=<%=category%>&paperno=<%=paperno%>">下一頁</a>
<a HREF="<%=Myself%>?Page=<%=rs.PageCount%>&kcid=<%=kcid%>&userid=<%=userid%>&category=<%=category%>&paperno=<%=paperno%>">最后一頁</a>
<% End If %>
<font SIZE="2">頁次:</font><font COLOR="Red" SIZE="2"><%=Page%>/<%=rs.PageCount%></font></p>
<p> </td>
</tr>
</table>
</form>
</center>
<%
%>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -