selectclass.asp

晴和教务管理系统

<% if request.Cookies("jiaowu")("Lx") <> "学生" then response.redirect "/jw/index.asp"%>
<!--#include file="../inc/top.asp"-->
<%
dim action
action=request.QueryString("action")
select case action
case ""
%>
<div align="center">
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
<TR><td class="table-shangxia" bgcolor="#ffffff" height="35"><img src="/jw/images/menu_06.gif" width="41" height="33" align="absmiddle"> <a href="/jw/index.asp">教学系统</a> >>  >> 
	<a href="index.asp">学生事务</a> &gt;&gt; &gt;&gt; 选择选修课</td></tr>
</table>
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
<TR>
<td class="table-xia" align="center" height="27"><font color="#008000">所有选修课列表</font></td>
</tr>
</table>
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
<TR>
<td class="table-zuoyou" align="center" width="8%" height="25"><p class="table-xia">课程代码</p></td>
<td class="table-you" align="center" width="8%" height="25"><p class="table-xia">教师</p></td>
<td class="table-you" align="center" width="18%" height="25"><p class="table-xia">课程名称</p></td>
<td class="table-you" align="center" width="11%" height="25"><p class="table-xia">授课对象</p></td>
<td class="table-you" align="center" width="7%" height="25"><p class="table-xia">教室</p></td>
<td class="table-you" align="center" width="32%" height="25"><p class="table-xia">时间</p></td>
<td class="table-you" align="center" width="9%" height="25"><p class="table-xia">说明</p></td>
<td class="table-you" align="center" width="10%" height="25"><p class="table-xia">　</p></td>
</tr>
<form name="classinfo" method="post" action="selectclass.asp?action=save">
<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from Jw_teaclass where lock = 0 and xuanxiuke = 1 order by num desc",conn,1,3
do while not rs.eof
%>
<TR>
<td class="table-zuoyou" align="center" width="8%" height="25"><p class="table-xia"><% =rs("Num")%></p></td>
<td class="table-you" align="center" width="8%" height="25"><p class="table-xia"><% =rs("teacher")%></p></td>
<td class="table-you" align="center" width="18%" height="25"><p class="table-xia"><% =rs("name")%></p></td>
<td class="table-you" align="center" width="11%" height="25"><p class="table-xia"><% =rs("skdx")%></p></td>
<td class="table-you" align="center" width="7%" height="25"><p class="table-xia"><% =rs("classroom")%></p></td>
<td class="table-you" align="center" width="32%" height="25"><p class="table-xia"><% =rs("sj")%></p></td>
<td class="table-you" align="center" width="9%" height="25"><p class="table-xia">
<a href="javascript:;" onClick="javascript:window.open('selectclasswindow.asp?id=<% =rs("id")%>','selectclasswindow','width=400,height=250,toolbar=no, status=no, menubar=no, resizable=no, scrollbars=no');return false;">查看说明</a></p></td>
<td class="table-you" align="center" width="10%" height="25"><p class="table-xia">
<input class=go-wenbenkuang onclick="window.location='selectclass.asp?action=save&teacherclassID=<% =rs("id")%>'" type=button value="选修" name=Submit3></p>
</td>
</tr>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
</form>
</table>
</div>
<%
case "save"

teacherclassID=request("teacherclassID")
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from Jw_stuclass where teacherclassID=" & teacherclassID & " and studentNum='"&request.Cookies("jiaowu")("Num")&"'",conn,1,3
if rs.recordcount>0 then
response.write "<script LANGUAGE='javascript'>alert('你已经选过这门课！');history.go(-1);</script>"
response.end
end if
rs.addnew
rs("studentNum")=request.Cookies("jiaowu")("Num")
rs("teacherclassID")=request("teacherclassID")
rs.update
rs.close
set rs=nothing
response.write "<br><br><center><font color=red>选修课程成功，可在“本学期修读课程”中进行管理！</font></center><br><br>"

end select
%><!--#include file="../inc/end.asp"-->