📄 bjxqfx.asp
字号:
<%@ language=vbscript %>
<!--#include file="conn.asp"-->
<%
dm=request("dm")
zybj= request("zybj")
if Session.Contents("gws")=true or Session.Contents("zybj")=zybj or Session.Contents("dm")=true or Session.Contents("dm")=dm then
bjbh= request("bjbh")
bjbh="b"+cstr(bjbh)
mc=request("mc")
dim rs,rs1,rs2
dim sql,sql1,sql2
set rs=server.createobject("adodb.recordset")
set rs1=server.createobject("adodb.recordset")
if mc="1" then
sql="select * from "&bjbh&" Order by fs10+fs11+fs12+fs13+fs14+fs15+fs16+fs17+fs18+fs19+fs110+fs111+fs112+fs113+fs114+fs115+fs116+fs117+fs118+fs119 desc"
end if
if mc="2" then
sql="select * from "&bjbh&" Order by fs20+fs21+fs22+fs23+fs24+fs25+fs26+fs27+fs28+fs29+fs120+fs121+fs122+fs123+fs124+fs125+fs126+fs127+fs128+fs129 desc"
end if
if mc="3" then
sql="select * from "&bjbh&" Order by fs30+fs31+fs32+fs33+fs34+fs35+fs36+fs37+fs38+fs39+fs130+fs131+fs132+fs133+fs134+fs135+fs136+fs137+fs138+fs139 desc"
end if
if mc="4" then
sql="select * from "&bjbh&" Order by fs40+fs41+fs42+fs43+fs44+fs45+fs46+fs47+fs48+fs49+fs140+fs141+fs142+fs143+fs144+fs145+fs146+fs147+fs148+fs149 desc"
end if
if mc="5" then
sql="select * from "&bjbh&" Order by fs50+fs51+fs52+fs53+fs54+fs55+fs56+fs57+fs58+fs59+fs150+fs151+fs152+fs153+fs154+fs155+fs156+fs157+fs158+fs159 desc"
end if
if mc="6" then
sql="select * from "&bjbh&" Order by fs60+fs61+fs62+fs63+fs64+fs65+fs66+fs67+fs68+fs69+fs160+fs161+fs162+fs163+fs164+fs165+fs166+fs167+fs168+fs169 desc"
end if
if mc="7" then
sql="select * from "&bjbh&" Order by fs70+fs71+fs72+fs73+fs74+fs75+fs76+fs77+fs78+fs79+fs170+fs171+fs172+fs173+fs174+fs175+fs176+fs177+fs178+fs179 desc"
end if
if mc="8" then
sql="select * from "&bjbh&" Order by fs80+fs81+fs82+fs83+fs84+fs85+fs86+fs87+fs88+fs89+fs180+fs181+fs182+fs183+fs184+fs185+fs186+fs187+fs188+fs189 desc"
end if
sql1="select * from zybjmc where zybj='" + zybj + "'"
rs.open sql,conn,1,1
rs1.open sql1,conn,1,1
if rs.eof then
response.write"<script language='javascript'>"
response.write"alert('没有符合您要求的记录！');"
response.write"history.go(-1);"
response.write"</script>"
response.end
end if
total=rs.recordcount
Dim js,zf,yjs
js=0
zf=0
yjs=0
%>
<html>
<head>
<title>龚文生</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="config.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000" background="bg01.gif">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>
<div align="center"><b><font color=red><font face="华文行楷" size="6">
<%=zybj%></font></font></b></div>
<div align="center"><b><font color=red>第<font color=black size="4">*<%=mc%>*</font>学期分析</font></b></div>
<div align="center"><b><font color="#0066FF">共有<font color=red><%=total%></font>位学生
</font></b></div>
</td>
</tr>
</table>
<center>
<table border=1 cellpadding=1 cellspacing=1>
<tr bgcolor=black style='color:white'>
<td align=center>名次</td>
<td align=center>学号</td>
<td align=center>姓名</td>
<td align=center>性别</td>
<td align=center>详情</td>
<%
if mc="1" then
%>
<td align=center><%=rs1("fs10")%> </td>
<%
if rs1("fs10")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs11")%> </td>
<%
if rs1("fs11")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs12")%> </td>
<%
if rs1("fs12")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs13")%> </td>
<%
if rs1("fs13")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs14")%> </td>
<%
if rs1("fs14")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs15")%> </td>
<%
if rs1("fs15")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs16")%> </td>
<%
if rs1("fs16")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs17")%> </td>
<%
if rs1("fs17")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs18")%> </td>
<%
if rs1("fs18")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs19")%> </td>
<%
if rs1("fs19")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs110")%> </td>
<%
if rs1("fs110")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs111")%> </td>
<%
if rs1("fs111")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs112")%> </td>
<%
if rs1("fs112")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs113")%> </td>
<%
if rs1("fs113")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs114")%> </td>
<%
if rs1("fs114")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs115")%> </td>
<%
if rs1("fs115")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs116")%> </td>
<%
if rs1("fs116")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs117")%> </td>
<%
if rs1("fs117")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs118")%> </td>
<%
if rs1("fs118")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs119")%> </td>
<%
if rs1("fs119")<>"" then
js=js+1
end if
%>
<%
end if
%>
<%
if mc="2" then
%>
<td align=center><%=rs1("fs20")%> </td>
<%
if rs1("fs20")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs21")%> </td>
<%
if rs1("fs21")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs22")%> </td>
<%
if rs1("fs22")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs23")%> </td>
<%
if rs1("fs23")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs24")%> </td>
<%
if rs1("fs24")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs25")%> </td>
<%
if rs1("fs25")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs26")%> </td>
<%
if rs1("fs26")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs27")%> </td>
<%
if rs1("fs27")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs28")%> </td>
<%
if rs1("fs28")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs29")%> </td>
<%
if rs1("fs29")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs120")%> </td>
<%
if rs1("fs120")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs121")%> </td>
<%
if rs1("fs121")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs122")%> </td>
<%
if rs1("fs122")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs123")%> </td>
<%
if rs1("fs123")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs124")%> </td>
<%
if rs1("fs124")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs125")%> </td>
<%
if rs1("fs125")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs126")%> </td>
<%
if rs1("fs126")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs127")%> </td>
<%
if rs1("fs127")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs128")%> </td>
<%
if rs1("fs128")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs129")%> </td>
<%
if rs1("fs129")<>"" then
js=js+1
end if
%>
<%
end if
%>
<%
if mc="3" then
%>
<td align=center><%=rs1("fs30")%> </td>
<%
if rs1("fs30")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs31")%> </td>
<%
if rs1("fs31")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs32")%> </td>
<%
if rs1("fs32")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs33")%> </td>
<%
if rs1("fs33")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs34")%> </td>
<%
if rs1("fs34")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs35")%> </td>
<%
if rs1("fs35")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs36")%> </td>
<%
if rs1("fs36")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs37")%> </td>
<%
if rs1("fs37")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs38")%> </td>
<%
if rs1("fs38")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs39")%> </td>
<%
if rs1("fs39")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs130")%> </td>
<%
if rs1("fs130")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs131")%> </td>
<%
if rs1("fs131")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs132")%> </td>
<%
if rs1("fs132")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs133")%> </td>
<%
if rs1("fs133")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs134")%> </td>
<%
if rs1("fs134")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs135")%> </td>
<%
if rs1("fs135")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs136")%> </td>
<%
if rs1("fs136")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs137")%> </td>
<%
if rs1("fs137")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs138")%> </td>
<%
if rs1("fs138")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs139")%> </td>
<%
if rs1("fs139")<>"" then
js=js+1
end if
%>
<%
end if
%>
<%
if mc="4" then
%>
<td align=center><%=rs1("fs40")%> </td>
<%
if rs1("fs40")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs41")%> </td>
<%
if rs1("fs41")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs42")%> </td>
<%
if rs1("fs42")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs43")%> </td>
<%
if rs1("fs43")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs44")%> </td>
<%
if rs1("fs44")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs45")%> </td>
<%
if rs1("fs45")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs46")%> </td>
<%
if rs1("fs46")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs47")%> </td>
<%
if rs1("fs47")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs48")%> </td>
<%
if rs1("fs48")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs49")%> </td>
<%
if rs1("fs49")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs140")%> </td>
<%
if rs1("fs140")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs141")%> </td>
<%
if rs1("fs141")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs142")%> </td>
<%
if rs1("fs142")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs143")%> </td>
<%
if rs1("fs143")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs144")%> </td>
<%
if rs1("fs144")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs145")%> </td>
<%
if rs1("fs145")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs146")%> </td>
<%
if rs1("fs146")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs147")%> </td>
<%
if rs1("fs147")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs148")%> </td>
<%
if rs1("fs148")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs149")%> </td>
<%
if rs1("fs149")<>"" then
js=js+1
end if
%>
<%
end if
%>
<%
if mc="5" then
%>
<td align=center><%=rs1("fs50")%> </td>
<%
if rs1("fs50")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs51")%> </td>
<%
if rs1("fs51")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs52")%> </td>
<%
if rs1("fs52")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs53")%> </td>
<%
if rs1("fs53")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs54")%> </td>
<%
if rs1("fs54")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs55")%> </td>
<%
if rs1("fs55")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs56")%> </td>
<%
if rs1("fs56")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs57")%> </td>
<%
if rs1("fs57")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs58")%> </td>
<%
if rs1("fs58")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs59")%> </td>
<%
if rs1("fs59")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs150")%> </td>
<%
if rs1("fs150")<>"" then
js=js+1
end if
%>
<td align=center><%=rs1("fs151")%> </td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -