📄 addcoursetwo.asp
字号:
<!--#include file="a25175_top.asp"-->
<link href="../25175css_pro.css" rel="stylesheet" type="text/css">
<!--#include file="INCFIRST.asp"-->
<!--#include file="../Function.asp"-->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<script language = "JavaScript">
function addclass()
{
var class2=document.frm.selectclass.value
document.frm.class1.value=document.frm.selectclass.value+'*'+document.frm.class1.value
}
</script>
<body>
<table width="500" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#ADD7FF">
<tr>
<td width="188" rowspan="7" valign="top"><!--#include file="adminleft.asp"--></td>
</tr>
<tr>
<td width="589" height="45" align="left" valign="top" bgcolor="#FFFFFF"><p>教师课程添加</p>
<p>第二步：添加开课学期和班级：</p></td>
<td width="9" rowspan="6" background=""></td>
</tr>
<tr>
<td height="25" align="left" valign="middle" bgcolor="#FFFFFF">
<%
depart=request.Form("addone_id")
teach=request.Form("addtwo_id")
if depart="请选择教师院系" or teach=Null or teach="请选择教师" then
response.write"<script>alert('请选择教师院系与教师名称！');location='pingjiaone.asp'</script>"
response.End()
end if
depart=cint(depart)
teach=cint(teach)
strsql="select * from department where id="&depart
set rs=db.execute(strsql)
depart=rs("department")
strsql="select * from teacher where id="&teach
set rs=db.execute(strsql)
teach=rs("teachername")
response.write "教师院别：<font color='#FF33cc'>"&depart&"</font>"
%> </td>
</tr>
<tr>
<td height="25" align="left" valign="middle" bgcolor="#FFFFFF"><%="教师姓名：<font color='#FF33cc'>"&teach&"</font>"%></td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#FFFFFF"><form action="ADDCOURSEOK.ASP" method="post" name="frm" id="frm">
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#ADD7FF">
<tr>
<td width="12%" bgcolor="#FFFFFF">开课学期:</td>
<td width="88%" height="30" bgcolor="#FFFFFF"><select name="term" id="term">
<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("TERM")%>"><%=rs("TERM")%></option>
<%rs.movenext
wend
rs.Close()
%>
</select></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">课程名称：</td>
<td height="30" bgcolor="#FFFFFF"><input name="course" type="text" id="course" size="30"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">开课班级：</td>
<td height="30" bgcolor="#FFFFFF"> <input name="class1" type="text" id="class14" size="30">
<select name="selectclass" id="selectclass" onChange="addclass()">
<option value="" selected>请选择教师开课班级</option>
<%
sql="select * from class where department='"&depart&"' order by ID desc"
set rs=server.createobject("ADODB.Recordset")
rs.open sql,db,1,1
while not rs.eof%>
<option value="<%=rs("classname")%>"><%=rs("classname")%></option>
<%rs.movenext
wend
rs.Close()
%>
</select></td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFFFFF"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">备注：</td>
<td height="100" bgcolor="#FFFFFF"><textarea name="BEIZHU" cols="40" rows="5" id="BEIZHU"></textarea></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><input name="depart" type="hidden" id="depart" value="<%=depart%>"> <input name="teach" type="hidden" id="teach" value="<%=teach%>"></td>
<td bgcolor="#FFFFFF"><input type="submit" name="Submit" value="提交"></td>
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td height="100" bgcolor="#FFFFFF"> <table width="95%" border="0" cellpadding="0" cellspacing="1" bgcolor="#ADD7FF">
<tr align="center" bgcolor="#FFFFFF">
<td>序号</td>
<td>开课学期</td>
<td>课程名称</td>
<td>开课班级</td>
<td>开课院系</td>
<td>开课教师</td>
<td>删除</td>
</tr>
<%
strsql="select * from teachercourse where teachername='"&teach&"' and department='"&depart&"'"
set rs=db.execute(strsql)
J=1
do while not rs.eof
%>
<tr align="center" bgcolor="#FFFFFF">
<td><%=J%></td>
<td><%=rs("term")%></td>
<td><%=rs("course")%></td>
<td><%=rs("class")%></td>
<td><%=rs("department")%></td>
<td><%=rs("teachername")%></td>
<td>删除</td>
</tr>
<%
J=J+1
rs.movenext
loop
%>
</table></td>
</tr>
</table>
</body>
</html>
<!--#include file="../foot.asp"-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -