<% if session("admid")="" or Session("pwd")="" then response.redirect "default.asp"%>
<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Test Results </title>
<link rel="stylesheet" href="style/t.css" type="text/css">
<style type="text/css">
<!--
.STYLE1 {
	font-family: Tahoma;
	font-size: 18px;
	font-weight: bold;
}
-->
</style>
</head>
<body bgcolor="#D6D3CE">
<p align="center" class=header	><b><font size="3">CIC Students' Academic Record 
Systems </font></b></p>

  <center>
  <form method="POST" action="register.asp" name="form1">
  <table border="1" width="48%" bordercolorlight="#848284" cellspacing="0" cellpadding="4" bordercolordark="#FFFFFF">
    <tr>
      <td colspan="2">
        <p align="center"><b><font size="3">Score Input</font></b></td>
    </tr>
    <tr>
      <td width="25%" align="center" class="altbg1">Class</td>
      <td width="75%" align="left" class="altbg2">
       <select name="txtclass" size="1" id="txtclass">

          <%
     set rsclass=server.createobject("ADODB.Recordset") 
     sqlclass="select distinct class from student"
     rsclass.open sqlclass,conntmp,1,1
     do while not rsclass.eof
     
     response.write "<option value="&rsclass("class")&">"&rsclass("class")&"</option>"
     rsclass.movenext
     loop
     %>
       </select>
      ¡¡</td>
    </tr>
    <tr>
      <td width="25%" align="center"  class="altbg1">Courses</td>
      <td width="75%" align="left" class="altbg2">
      <select size="1" name="course">
		<option value="BusinessStudies">BusinessStudies</option>
		<option value="Chemistry">Chemistry</option>
		<option value="Economics">Economics</option>
		<option value="English">English</option>
		<option value="Maths">Maths</option>
		<option value="Physics">Physics</option>
		<option value="FurtherMaths">FurtherMaths</option>
		</select>&nbsp;¡¡</td>
    </tr>
    <tr>
      <td width="25%" align="center"  class="altbg1">Week</td>
      <td width="75%" align="left" class="altbg2"><select size="1" name="weeks">
       
        <option value="a">Week 1-2 (3-16 Sept.)</option>
        <option value="b">Week 3-4 (17-30 Sept.)</option>
        <option value="c">Week 5-6 (8-12 Oct.)</option>
        <option value="d">Week 7-8 (15-28 Oct.)</option>
        <option value="e">Week 9 (29 Oct.-4 Nov.)</option>
        <option value="g">Week 1-9 (3 Sept.-4 Nov.)-Mid Term Homework</option>
        <option value="h">Week 10 (5-11 Nov.)-Mid Term Exam</option>
        <option value="j">Week 11-12 (12-25 Nov.)</option>
        <option value="k">Week 13-14 (26 Nov.-9 Dec.)</option>
        <option value="l">Week 15-16 (10-23 Dec.)</option>
        <option value="m">Week 17-18 (24 Dec.-6 Jan.)</option>
        <option value="n">Week 19 (7-20 Jan.)</option>
        <option value="p">Week 1-19 (3 Sept. -20 Jan.)-End Term Homework </option>
        <option value="q">Week 20 (21-26 Jan.-End Term Exam</option>
            </select></td>
    </tr>
  <tr>
    <td colspan="2" align="center" height="25">
	<input type="submit" value="Submit" name="B1"> </td>
  </tr>
  </table>
  </form>
  </center>

  <center>
  <form action="searchresult.asp" method="POST" name="form2" id="form2">
  <table border="1" width="48%" bordercolorlight="#848284" cellspacing="0" cellpadding="4" bordercolordark="#FFFFFF">
    <tr>
      <td colspan="2">
        <p align="center"><b><font size="3">Results Searching</font></b></td>
    </tr>
    <tr>
      <td width="25%" align="center" class="altbg1">Class</td>
      <td width="75%" align="left" class="altbg2">
       <select name="txtclass" size="1" id="txtclass">

          <%
     set rsclass=server.createobject("ADODB.Recordset") 
     sqlclass="select distinct class from student"
     rsclass.open sqlclass,conntmp,1,1
     do while not rsclass.eof
     
     response.write "<option value="&rsclass("class")&">"&rsclass("class")&"</option>"
     rsclass.movenext
     loop
     %>
       </select>
       ¡¡</td>   
    </tr>
    <tr>
      <td align="center"  class="altbg1">Courses</td>
      <td align="left" class="altbg2"><select name="txtcourse" size="1" id="txtcourse">
          <option value="AllCourse">AllCourse</option>
          <option value="BusinessStudies">BusinessStudies</option>
          <option value="Chemistry">Chemistry</option>
          <option value="Economics">Economics</option>
        5
		
        <option value="English">English</option>
          <option value="Maths">Maths</option>
          <option value="Physics">Physics</option>
          <option value="FurtherMaths">FurtherMaths</option>
        </select>
        &nbsp;¡¡</td>
    </tr>
    <tr>
      <td width="25%" align="center"  class="altbg1">Week</td>
      <td width="75%" align="left" class="altbg2"><select name="txtweek" size="1" id="txtweek">
         <option value="allweeks">None</option>
		<option value="a">Week 1-2 (3-16 Sept.)</option>
        <option value="b">Week 3-4 (17-30 Sept.)</option>
        <option value="c">Week 5-6 (8-12 Oct.)</option>
        <option value="d">Week 7-8 (15-28 Oct.)</option>
        <option value="e">Week 9 (29 Oct.-4 Nov.)</option>
        <option value="g">Week 1-9 (3 Sept.-4 Nov.)-Mid Term Homework</option>
        <option value="h">Week 10 (5-11 Nov.)-Mid Term Exam</option>
        <option value="j">Week 11-12 (12-25 Nov.)</option>
        <option value="k">Week 13-14 (26 Nov.-9 Dec.)</option>
        <option value="l">Week 15-16 (10-23 Dec.)</option>
        <option value="m">Week 17-18 (24 Dec.-6 Jan.)</option>
        <option value="n">Week 19 (7-20 Jan.)</option>
        <option value="p">Week 1-19 (3 Sept. -20 Jan.)-End Term Homework </option>
        <option value="q">Week 20 (21-26 Jan.-End Term Exam</option>
      </select>        &nbsp;¡¡</td>
    </tr>
    <tr>
    <td width="25%" align="center" height="23"  class="altbg1">Name(CHN or EN)</td>
    <td width="75%" align="left" height="23"  class="altbg2">
	<input name="txtname" type="text" id="txtname" size="20"> (The names of all 
	students in the class will appear if this column is 
	left blank. <font color="#0000FF">Support fuzzy inquiry</font>)</td>
  </tr>
  <tr>
    <td colspan="2" align="center" height="25">
	<input type="submit" value="Submit" name="B1"> </td>
  </tr>
  </table>
  </form>
  
  
  
  </center>
 <center>
  <form action="reportsel.asp" method="POST" name="form3" id="form3">
  <table border="1" width="48%" bordercolorlight="#848284" cellspacing="0" cellpadding="4" bordercolordark="#FFFFFF">
    <tr>
      <td width="100%" colspan="2" height="25">
        <p align="center"><b><font size="3">School Report Editing</font></b></td>
    </tr>
    <tr>
      <td width="26%" align="center" class="altbg1">Class</td>
      <td width="71%" align="left" class="altbg2">
       <select name="txtclass" size="1" id="txtclass">

          <%
     set rsclass=server.createobject("ADODB.Recordset") 
     sqlclass="select distinct class from student"
     rsclass.open sqlclass,conntmp,1,1
     do while not rsclass.eof
     
     response.write "<option value="&rsclass("class")&">"&rsclass("class")&"</option>"
     rsclass.movenext
     loop
     %>
       </select>
       ¡¡</td>   
    </tr>
    <tr>
      <td align="center" height="23"  class="altbg1">Teacher</td>
      <td align="left" height="23"  class="altbg2"><select name="teacher" id="teacher">
          <option value="Supervisor" selected>Supervisor</option>
          <option value="BusinessStudies">BusinessStudies</option>
          <option value="Chemistry">Chemistry</option>
          <option value="Economics">Economics</option>
        <option value="English">English</option>
          <option value="Maths">Maths</option>
          <option value="Physics">Physics</option>
          <option value="FurtherMaths">FurtherMaths</option>
      </select></td>
    </tr>
    <tr>
    <td width="26%" align="center" height="23"  class="altbg1">Semester</td>
    <td width="71%" align="left" height="23"  class="altbg2">
	<select name="Semester" id="Semester" size="1">
	  <option value="Semester1">Semester1-MidTerm</option>
	  <option value="Semester2">Semester1-EndTerm</option>
 
          </select></td>
  </tr>
  <tr>
    <td width="100%" colspan="2" align="center" height="25">
	<input type="submit" value="Submit" name="B1"> </td>
  </tr>
  </table> 
  <p class="STYLE1"><a href="coursesetting.asp?act=test">Courses Setting<span style="font-weight: 400"></span></a><span style="font-weight: 400"><font size="2">(TAO  
	only)&nbsp;</font></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
	<a href="datesetting.asp?act=test">Date Setting</a><span style="font-weight: 400"><font size="2">(TAO 
	only)</font>   </span>   </p>
  </form>
  
  
  
  </center>

</body>

</html>