📄 cx_ks_yued.asp
字号:
<!--#include file="conn.asp"-->
<%
if session("username")="" then
response.redirect "relogin.asp"
end if
%>
<%
username=request.cookies("username")
kcid=request("kcid")
paperno=request("paperno")
category=request("category")
sql0="SELECT tbuser.username, tbnianji.nianji, tbbanji.banji, tbpower.power FROM tbuser INNER JOIN ((tbpower INNER JOIN tbbanji ON tbpower.banjiid = tbbanji.banjiid) INNER JOIN tbnianji ON tbpower.nianjiid = tbnianji.nianjiid) ON (tbuser.banji = tbbanji.banji) AND (tbuser.nianji = tbnianji.nianji) WHERE (((tbuser.username)='"&username&"'));"
set rs0=server.createobject("adodb.recordset")
rs0.open sql0,conn,3,2
a=rs0("power")
flag=0
if instr(a,",")>0 then
a=split(a,",")
u=ubound(a)
for w=0 to u
if cint(paperno)=cint(a(w)) then
flag=1
end if
next
else
if paperno=a then
flag=1
end if
end if
if flag=0 then
response.write "<center><h2>您没有权限</h2></center>"
else
sqlpaper="SELECT * FROM tbpaper where paperno="&paperno
set rspaper=server.createobject("adodb.recordset")
rspaper.open sqlpaper,conn,3,2
sqltm="SELECT * FROM tbkcconfig where kcid="&kcid&" and category=8 and paperno="&paperno
set rstm=server.createobject("adodb.recordset")
rstm.open sqltm,conn,3,2
sql_fen="SELECT top "&rstm("datano")&" userdata.fen,userdata.tmid ,userdata.dataid FROM userdata,tbtk where username='"&username&"' and userdata.tmid=tbtk.tmid and tbtk.kcid="&kcid&" and paperno="&paperno&" and category=8 and kao=1 order by tbtk.tmid"
set rs_fen=server.createobject("adodb.recordset")
rs_fen.open sql_fen,conn,3,2
xiaotino=0
yued_fen=0
do while not rs_fen.eof
sql_fen1="SELECT * FROM userdataread where username='"&username&"' and dataid="&rs_fen("dataid")&" and tmid="&rs_fen("tmid")&" and paperno="&paperno&" "
set rs_fen1=server.createobject("adodb.recordset")
rs_fen1.open sql_fen1,conn,3,2
xiaotino=rs_fen1.recordcount+xiaotino
do while not rs_fen1.eof
yued_fen=rs_fen1("fen")+yued_fen
rs_fen1.movenext
loop
rs_fen.movenext
loop
sql="SELECT top "&rstm("datano")&" tbtk.tmid, tbtk.title,tbtk.category, tbkc.kcid, tbkc.kcm ,a,b,c,d,e,f,photo FROM tbkc, userdata, tbtk WHERE username='"&username&"' and userdata.tmid=tbtk.tmid and tbtk.kcid=tbkc.kcid and tbkc.kcid="&kcid&" and kao=1 and category=8 and paperno="&paperno&" order by tbtk.tmid;"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
on error resume next
%>
<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>成绩查询 | 考试成绩 | <%=rs("kcm")%>——<%=rspaper("info")%> | 阅读理解</title>
<link rel="stylesheet" type="text/css" href="css.css">
<script language="JavaScript">
<!--
function FP_swapImg() {//v1.0
var doc=document,args=arguments,elm; for(var n=2; n<args.length; n+=2) {
elm=FP_getObjectByID(args[n]); if(elm) { if(!doc.$imgSwaps)doc.$imgSwaps=new Array();
doc.$imgSwaps[doc.$imgSwaps.length]=elm; elm.$src=elm.src; elm.src=args[n+1]; } }
}
function FP_preloadImgs() {//v1.0
var d=document,a=arguments; if(!d.FP_imgs) d.FP_imgs=new Array();
for(var i=0; i<a.length; i++) { d.FP_imgs[i]=new Image; d.FP_imgs[i].src=a[i]; }
}
function FP_getObjectByID(id,o) {//v1.0
var c,el,els,f,m,n; if(!o)o=document; if(o.getElementById) el=o.getElementById(id);
if(o.layers) c=o.layers; else if(o.all) el=o.all[id]; if(el) return el;
if(o.id==id || o.name==id) return o; if(o.childNodes) c=o.childNodes; if(c)
for(n=0; n<c.length; n++) { el=FP_getObjectByID(id,c[n]); if(el) return el; }
f=o.forms; if(f) for(n=0; n<f.length; n++) { els=f[n].elements;
for(m=0; m<els.length; m++){ el=FP_getObjectByID(id,els[n]); if(el) return el; } }
return null;
}
// -->
</script>
</head>
<body>
<%
%><center>
<table border="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2" height="25">
<tr>
<td width="100%" height="29" style="border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; border-top-style: solid; border-top-width: 0; border-bottom: 1px solid #000000">
<img border="0" src="images/cxcj.gif"></td>
</tr>
<tr>
<td width="100%" height="21">当前位置：考试成绩查询 > <a href="cx_ks_type.asp?kcid=<%=rs("kcid")%>&paperno=<%=paperno%>"><%=rs("kcm")%>——<%=rspaper("info")%></a>
</td>
</tr>
</table></center>
<center><form name="viewdatabase" ACTION="<%=Myself%>" method="post">
<table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="100%" id="AutoNumber1" height="390">
<tr class="trh">
<td width="6%" align="center" bgcolor="#799AE1" height="24">
<font color="#FFFFFF"><b>序号</b></font></td>
<td align="center" bgcolor="#799AE1" width="93%" height="24">
<p align="center"><font color="#FFFFFF"><b>阅读理解（共<%=rstm("datano")&"大题--"&xiaotino&"小题"%>,<%=rstm("datavalue")*xiaotino&"分"%>）</b></font></td>
</tr>
<%
rs.PageSize =1
Page = CLng(Request("Page"))
If Page < 1 Then Page = 1
If Page > rs.PageCount Then Page = rs.PageCount
i=page+(page-1)*0
rs.AbsolutePage = Page
For iPage = 1 To rs.PageSize
%>
<tr>
<td align="center" bgcolor="#FFFDE8" height="68" width="6%" bordercolor="#215DC6"><%=i%> </td>
<td align="center" bgcolor="#FFFDE8" height="68" width="93%" bordercolor="#215DC6">
<table border="0" cellpadding="0" width="89%">
<tr>
<td><br>试题——<%=htmlencode(rs("title"))%><br>
<% if len(rs("photo")) > 1 then
%> <center>
<img border="0" src="examimage/<%=rs("photo")%>"></center>
<br><% end if %><hr color="#000000">
</td>
</tr>
<%
sqlyued1="SELECT * FROM tbread WHERE tmid="&rs("tmid")&""
set rsyued1=server.createobject("adodb.recordset")
rsyued1.open sqlyued1,conn,3,2
do while not rsyued1.eof
sqlyued3="SELECT * FROM userdataread WHERE username='"&username&"' and paperno="&paperno&" and noid="&rsyued1("noid")&" and tmid="&rsyued1("tmid")
set rsyued3=server.createobject("adodb.recordset")
rsyued3.open sqlyued3,conn,3,2
%>
<tr>
<td>(<%=rsyued1("readno")%>)、<%=htmlencode(rsyued1("xiaoti"))%>——(难度:<%
if rsyued1("slevel")=1 then
response.write "容易"
end if
if rsyued1("slevel")=2 then
response.write "中等"
end if
if rsyued1("slevel")=3 then
response.write "较难"
end if
if rsyued1("slevel")=4 then
response.write "最难"
end if
%>) <br><% if len(rsyued1("pic")) > 1 then
%> <center>
<img border="0" src="examimage/<%=rsyued1("pic")%>">
</center>
<br><% end if %>
<% if rsyued1("a")<>"" then %> A.<%=rsyued1("a")%><br><%end if%>
<% if rsyued1("b")<>"" then %> B.<%=rsyued1("b")%><br><%end if%>
<% if rsyued1("c")<>"" then %> C.<%=rsyued1("c")%><br><%end if%>
<% if rsyued1("d")<>"" then %> D.<%=rsyued1("d")%><br><%end if%>
<% if rsyued1("e")<>"" then %> E.<%=rsyued1("e")%><br><%end if%>
<% if rsyued1("f")<>"" then %> F.<%=rsyued1("f")%><br><%end if%>
标准答案： <b><% if trim(rsyued3("rans"))="A" then %>A.<%=rsyued1("a")%><%end if%>
<% if trim(rsyued3("rans"))="B" then %>B.<%=rsyued1("b")%><%end if%>
<% if trim(rsyued3("rans"))="C" then %>C.<%=rsyued1("c")%><%end if%>
<% if trim(rsyued3("rans"))="D" then %>D.<%=rsyued1("d")%><%end if%>
<% if trim(rsyued3("rans"))="E" then %>E.<%=rsyued1("e")%><%end if%>
<% if trim(rsyued3("rans"))="F" then %>F.<%=rsyued1("f")%><%end if%></b><br>
您的答案：<%
'--------------------------------
if trim(rsyued3("ruans"))="A" then %>
<% if trim(rsyued3("ruans"))<>trim(rsyued3("rans")) then
response.write "<font color=red>"%>
A.<%=rsyued1("a")%>
<% response.write "</font>"
else
%>
A.<%=rsyued1("a")%>
<%end if%>
<%end if%>
<% '--------------------------------
if trim(rsyued3("ruans"))="B" then %>
<% if trim(rsyued3("ruans"))<>trim(rsyued3("rans")) then
response.write "<font color=red>"%>
B.<%=rsyued1("b")%>
<% response.write "</font>"
else
%>
B.<%=rsyued1("b")%>
<%end if%>
<%end if%>
<%'------------------------------------
if trim(rsyued3("ruans"))="C" then %>
<% if trim(rsyued3("ruans"))<>trim(rsyued3("rans")) then
response.write "<font color=red>"%>
C.<%=rsyued1("c")%>
<% response.write "</font>"
else
%>
C.<%=rsyued1("c")%>
<%end if%>
<%end if%>
<% '-------------------------------------
if trim(rsyued3("ruans"))="D" then %>
<% if trim(rsyued3("ruans"))<>trim(rsyued3("rans")) then
response.write "<font color=red>"%>
D.<%=rsyued1("d")%>
<% response.write "</font>"
else
%>
D.<%=rsyued1("d")%>
<%end if%><%end if%>
<% '---------------------------------------
if trim(rsyued3("ruans"))="E" then %>
<% if trim(rsyued3("ruans"))<>trim(rsyued3("rans")) then
response.write "<font color=red>"%>
E.<%=rsyued1("e")%>
<% response.write "</font>"
else
%>
E.<%=rsyued1("e")%>
<%end if%><%end if%>
<% '-----------------------------------
if trim(rsyued3("ruans"))="F" then %>
<% if trim(rsyued3("ruans"))<>trim(rsyued3("rans")) then
response.write "<font color=red>"%>
F.<%=rsyued1("f")%>
<% response.write "</font>"
else
%>
F.<%=rsyued1("f")%>
<%end if%><%end if%>
<br>
您的得分：
<%
response.write rsyued3("fen")&"分"
%><br><hr color="#4455AA"> </td>
</tr>
<% rsyued1.movenext
loop
%></table>
</td>
</tr>
<%
rs.MoveNext
If rs.EOF Then Exit For
i=i+1
Next
%>
<tr>
<td align="center" bgcolor="#FFFFFF" height="38" width="6%" bordercolor="#FFFFFF">
</td>
<td align="center" bgcolor="#FFFFFF" height="38" width="93%" bordercolor="#FFFFFF">
<a href="cx_ks_type.asp?kcid=<%=kcid%>&paperno=<%=paperno%>"><img border="0" id="img2" src="images/button3E.gif" height="22" width="70" alt="返 回" onmouseover="FP_swapImg(1,0,/*id*/'img2',/*url*/'images/button40.gif')" onmouseout="FP_swapImg(1,0,/*id*/'img2',/*url*/'images/button3E.gif')" onmousedown="FP_swapImg(1,0,/*id*/'img2',/*url*/'images/button42.gif')" onmouseup="FP_swapImg(1,0,/*id*/'img2',/*url*/'images/button40.gif')" fp-style="fp-btn: Metal Rectangle 1; fp-font: 宋体; fp-font-style: Bold; fp-font-size: 11; fp-transparent: 1; fp-proportional: 0; fp-orig: 0" fp-title="返 回"></a></td>
</tr>
</table>
</form>
</center>
<center> <form ACTION="<%=Myself%>" METHOD="GET">
<table style="border-collapse: collapse" bordercolor="#111111" cellpadding="0" cellspacing="0">
<tr>
<td width="100%">
<p ALIGN="center"><%If Page <> 1 Then ' 如果不是位于第一页%>
<a href="<%=Myself%>?Page=1&kcid=<%=kcid%>&paperno=<%=paperno%>">第一页</a>
<a HREF="<%=Myself%>?Page=<%=(Page-1)%>&kcid=<%=kcid%>&paperno=<%=paperno%>">上一页</a>
<%
End If
If Page <> rs.PageCount Then ' 如果不是位于最后一页
%> <a HREF="<%=Myself%>?Page=<%=(Page+1)%>&kcid=<%=kcid%>&paperno=<%=paperno%>">下一页</a>
<a HREF="<%=Myself%>?Page=<%=rs.PageCount%>&kcid=<%=kcid%>&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>
<%
%><%end if %>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -