📄 teacherscorel.asp
字号:
<!--#include file="admin/top.asp"-->
<!--#include file="Function.asp"-->
<!--#include file="Odbc_connection.asp"-->
<%
'-------------------------------------------------------------
Dim Depart,Teacher,Depart1,Teacher1,Term,Course
Depart=request("depart")
Teacher=request("Teacher")
'------------------------------------------------------
Depart1=Depart
Teacher1=Teacher
'------------------------------------------------------
if Depart<>"" and Teacher<>"" and Depart<>"请选择教师院系" and Teacher<>"请选择教师" then
strsql="select * from department where id="&depart
set rs=db.execute(strsql)
depart=rs("department")
strsql="select * from teacher where id="&teacher
set rs=db.execute(strsql)
teacher=rs("teachername")
else
Depart=""
Teacher=""
end if
'-------------------------------------------------------
'----------------将院别和教师编号转化成真实的名称
Term=request("Term")
Course=request("Course")
Term1=Term
Course1=Course
if Term<>"" and Course<>"" and Term<>"请选择教师开课学期" and Course<>"请选择教师课程" then
strsql="select * from term where id="&term
set rs=db.execute(strsql)
term=cstr(rs("term"))
strsql="select * from TEACHERCOURSE where id="&course
set rs=db.execute(strsql)
course=cstr(rs("course"))
else
Term=""
Course=""
end if
%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="wangye9pt.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="786" height="500" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="188" rowspan="4" valign="top" background="images/lefttiao.jpg"><!--#include file="left.asp"--></td>
<td height="20" colspan="2"><img src="images/righttop.jpg" width="598" height="20"></td>
</tr>
<tr>
<td height="50" align="center" valign="top" background="images/rightbg.jpg"><form action="" method="post" name="addform" id="addform">
<table width="95%" border="0" cellpadding="0" cellspacing="1" bgcolor="#336699" class="w9pt">
<tr align="center" bgcolor="#FFFFFF">
<td height="25" colspan="5" class="9ptred">成绩查询模块</td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td height="20" colspan="2" ><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#336699" class="w9pt">
<tr align="center" valign="middle" bgcolor="#B7B700">
<td height="25" colspan="5" >目前参加<%=Wtitle%>投票人数：
<%
strsql="select count(*) as total from TEACHERSCORE where usertype=1"
set rs=db.execute(strsql)
scorel=rs("total")
strsql="select count(*) as total from TEACHERSCORE where usertype=2"
set rs=db.execute(strsql)
scoret=rs("total")
strsql="select count(*) as total from TEACHERSCORE where usertype=3"
set rs=db.execute(strsql)
scores=rs("total")
strsql="select count(*) as total from TEACHERSCORE where usertype=4"
set rs=db.execute(strsql)
scorett=rs("total")
scoresum=scorel+scoret+scores+scorett
response.Write scoresum
if scoresum=0 then
scoresum=1
end if
tablewid=400
tablel=scorel/scoresum*tablewid
tablet=scoret/scoresum*tablewid
tables=scores/scoresum*tablewid
tablett=scorett/scoresum*tablewid
'---------------------------------------------------------
'显示已经投票的总人数
%>
人</td>
</tr>
<tr align="center" valign="middle" bgcolor="#FFFFFF">
<td height="25" colspan="3" align="left" bgcolor="#FFFFFF" >
<% response.write "学生："&scores&"人 占"&formatnumber((scores/scoresum*100),2)&"%"%></td>
<td width="74%" align="left" bgcolor="#FFFFFF" ><table width=<%=tables%> height="10" border="0" cellpadding="0" cellspacing="0">
<tr>
<td background="images/display3.gif"></td>
</tr>
</table></td>
</tr>
<tr align="center" valign="middle" bgcolor="#FFFFFF">
<td height="25" colspan="3" align="left" bgcolor="#FFFFFF" ><% response.write "教师："&scorett&"人 占"&formatnumber((scorett/scoresum*100),2)&"%"%></td>
<td align="left" bgcolor="#FFFFFF" ><table width=<%=tablett%> height="10" border="0" cellpadding="0" cellspacing="0">
<tr>
<td background="images/display4.gif"></td>
</tr>
</table></td>
</tr>
<tr align="center" valign="middle" bgcolor="#FFFFFF">
<td height="25" colspan="3" align="left" bgcolor="#FFFFFF" >
<% response.write "督导："&scoret&"人 占"&formatnumber((scoret/scoresum*100),2)&"%"%></td>
<td height="25" align="left" bgcolor="#FFFFFF" ><table width=<%=tablet%> height="10" border="0" cellpadding="0" cellspacing="0">
<tr>
<td background="images/display2.gif"></td>
</tr>
</table></td>
</tr>
<tr align="center" valign="middle" bgcolor="#FFFFFF">
<td height="25" colspan="3" align="left" bgcolor="#FFFFFF" ><% response.write "领导："&scorel&"人 占"&formatnumber((scorel/scoresum*100),2)&"%"%></td>
<td height="25" align="left" bgcolor="#FFFFFF" ><table width=<%=tablel%> height="10" border="0" cellpadding="0" cellspacing="0">
<tr>
<td background="images/display1.gif"></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr align="center" bgcolor="#B7B700">
<td height="25" colspan="2" valign="middle" >
<%
sql = "select * FROM TEACHER order by ID asc"
set rs=server.createobject("ADODB.Recordset")
rs.open sql,db,1,1%>
<script language = "JavaScript">
var onecount1;
onecount1=0;
subcat1 = new Array();
<%count = 0
do while not rs.eof%>
subcat1[<%=count%>] = new Array("<%= trim(rs("TEACHERNAME"))%>","<%= trim(rs("DEPARTID"))%>","<%= trim(rs("ID"))%>");
<%count = count + 1
rs.movenext
loop
rs.close
set rs=nothing%>
onecount1=<%=count%>;
function changelocation1(addone)
{
document.addform.teacher.length = 0;
var addone_id=addone_id;
var i;
document.addform.teacher.options[0] = new Option('请选择教师','请选择教师');
for (i=0;i < onecount1; i++)
{
if (subcat1[i][1] == addone)
{
document.addform.teacher.options[document.addform.teacher.length] = new Option(subcat1[i][0], subcat1[i][2]);
}
}
}
</script> </td>
</tr>
<tr align="center" valign="bottom" bgcolor="#FFFFFF">
<td width="19%" height="25" align="right" valign="middle" class="9ptred" >请选择教师院系：</td>
<td width="81%" height="25" align="left" valign="middle" class="9ptred" >
<%
if Depart<>"" and Depart<>"请选择教师院系" then
response.Write Depart
response.Write "<input name='Depart' type='hidden' value='"&Depart1&"'>"
else
%>
<select name="depart" id="select7" onChange="changelocation1(document.addform.depart.options[document.addform.depart.selectedIndex].value)">
<option value="请选择教师院系" selected>请选择教师院系</option>
<%
sql="select * from DEPARTMENT order by ID desc"
set rs=server.createobject("ADODB.Recordset")
rs.open sql,db,1,1
while not rs.eof%>
<option value="<%=rs("id")%>"><%=rs("DEPARTMENT")%></option>
<%rs.movenext
wend
rs.Close()
%>
</select>
*
<% end if%>
</td>
</tr>
<tr align="center" valign="bottom" bgcolor="#FFFFFF">
<td height="25" align="right" valign="middle" class="9ptred" >请选择教师：</td>
<td height="25" align="left" valign="middle" class="9ptred" >
<%
if Teacher<>"" and Teacher<>"请选择教师" then
response.Write Teacher
response.Write "<input name='Teacher' type='hidden' value='"&Teacher1&"'>"
else
%>
<select name="teacher" id="select8">
<option selected value="请选择教师">请选择教师</option>
</select>
***
<input type="submit" name="Submit2" value="选择学期和课程">
<%end if%>
</td>
</tr>
<%
if teacher<>"" and depart<>"" then
classterm()
end if
'------------------------------------------------选择教师的课程
sub classterm()
sql = "select * FROM TEACHERCOURSE where teachername='"&teacher&"' and department='"&depart& "' order by ID desc"
set rs=server.createobject("ADODB.Recordset")
rs.open sql,db,1,1%>
<script language = "JavaScript">
var onecount2;
onecount2=0;
subcat2 = new Array();
<%count1 = 0
do while not rs.eof%>
subcat2[<%=count1%>] = new Array("<%= trim(rs("COURSE"))%>","<%= trim(rs("TERMID"))%>","<%= trim(rs("ID"))%>");
<%count1 = count1 + 1
rs.movenext
loop
rs.close
set rs=nothing%>
onecount2=<%=count1%>;
function changelocation2(addone)
{
document.addform.course.length = 0;
var addone_id=addone_id;
var i;
document.addform.course.options[0] = new Option('请选择教师课程','');
for (i=0;i < onecount2; i++)
{
if (subcat2[i][1] == addone)
{
document.addform.course.options[document.addform.course.length] = new Option(subcat2[i][0], subcat2[i][2]);
}
}
}
</script>
<tr align="center" valign="bottom" bgcolor="#FFFFFF">
<td height="25" align="right" valign="middle" class="9ptred" >请选择开课学期：</td>
<td height="25" align="left" valign="middle" class="9ptred" >
<%
if Term<>"" then
response.Write Term
response.Write "<input name='Term' type='hidden' value='"&Term1&"'>"
else
%>
<select name="term" id="term" onChange="changelocation2(document.addform.term.options[document.addform.term.selectedIndex].value)">
<option value="请选择教师开课学期" selected>请选择教师开课学期</option>
<%
sql="select * from TERM order by ID desc"
set rs=server.createobject("ADODB.Recordset")
rs.open sql,db,1,1
while not rs.eof%>
<option value="<%=rs("id")%>"><%=rs("TERM")%></option>
<%rs.movenext
wend
rs.Close()
%>
</select>
*<%end if%></td>
</tr>
<tr align="center" valign="bottom" bgcolor="#FFFFFF">
<td height="25" align="right" valign="middle" class="9ptred" >请选择课程：</td>
<td height="25" align="left" valign="middle" class="9ptred" >
<%
if Course<>"" then
response.Write Course
response.Write "<input name='Course' type='hidden' value='"&Course1&"'>"
else
%>
<select name="course" id="course">
<option selected value="请选择教师课程">请选择教师课程</option>
</select>
***
<input name="Submit1" type="submit" id="Submit1" value="开始查分">
<%end if%>
</td>
</tr>
<% end sub%>
</table>
</form></td>
</tr>
<tr>
<td height="400" align="center" valign="top" background="images/rightbg.jpg">
<%
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -