📄 teaching.asp
字号:
<!--#include file="Conn.asp"-->
<!--#include file="Inc/CheckUser.asp"-->
<HTML>
<HEAD>
<title>工程学院教学管理系统 —— 教学工作 </title>
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Expires" content="0">
<meta http-equiv="Pragma" content="no-cache">
<LINK href="Style/style.css" rel="stylesheet">
<script language="javascript" type="text/javascript" src="Jscript/function.js"></script>
</HEAD>
<body background="Images/bg.jpg" topmargin="0" leftmargin="0">
<table class="borderon" id="control" cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr align="center">
<td height="20" width="100"></td>
<td class="tbutton" <%if Session("isOpen") = 1 or Session("Admin") = true then%>onclick="javascript:location.href='?action=add';"<%else%>onclick="javascript:window.alert('当前系统处于关闭状态！');return false;"<%end if%>>添加学科资料</td>
<td class="tbutton" onclick="javascript:location.href='?action=list';">
学科列表</td>
<td width="100"></td>
</table>
<form name="index" method="post" action="?action=save" ID="Form1">
<%
dim action,iyear
action = Request.QueryString("action")
select case action
case "list"
call list()
case "add"
call add()
case "change"
call change()
case "save"
call save()
case else
call list()
end select
'学习简历列表
sub list()
Set rs = Server.CreateObject("ADODB.RecordSet")
if Session("Admin") = true then
sql = "Select * From [teaching]"
else
sql = "Select * From [teaching] Where owner = "&Session("UID")
end if
rs.Open sql,conn,1,1
dim i,j
dim page,pagecount,show_str,total,content
%>
<table cellSpacing="0" cellPadding="0" width="100%" border="0" ID="Table7">
<tr>
<td vAlign="top" height="30">
<ol style="line-height:150%">
<li>
管理教师的教学工作资料（包括理论教学、实验教学、课程实习、毕业实习、指导毕业生论文等）</li>
</td>
</tr>
</table>
<input type="hidden" name="act" value="delete" ID="Hidden1">
<table width="95%" border="0" cellpadding="3" cellspacing="1" bgcolor="#000000" align="center" ID="Table1">
<tr style="BACKGROUND-IMAGE: url('Images/title1.gif');">
<td bgcolor="#99A6BF" style="background-image: url('')" width="3%"></td>
<td bgcolor="#99A6BF" style="background-image: url('')" width="11%">
<b>起止时间</b></td>
<td bgcolor="#99A6BF" style="background-image: url('')" width="8%">
<b>工作内容</b></td>
<td bgcolor="#99A6BF" style="background-image: url('')" width="18%">
<b>课程或实验、实习名称<br>（是否双语教学）</b></td>
<td bgcolor="#99A6BF" style="background-image: url('')" width="9%">
<b>授课专业</b></td>
<td bgcolor="#99A6BF" style="background-image: url('')" width="11%">
<b>学时或周数</b></td>
<td bgcolor="#99A6BF" style="background-image: url('')" width="6%">
<b>人 数</b></td>
<td bgcolor="#99A6BF" style="background-image: url('')" width="6%">
<b>年 度</b></td>
<td bgcolor="#99A6BF" style="background-image: url('')" width="7%">
<b>添加人</b></td>
<td bgcolor="#99A6BF" style="background-image: url('')" width="7%">
<b>修改人</b></td>
<td bgcolor="#99A6BF" style="background-image: url('')" width="8%">
<b>管 理</b></td>
</tr>
<%
if rs.BOF or rs.EOF then
total=0
page=0
pagecount=0
for j = 1 to 10
%>
<tr bgcolor="<%=TableBodyColor%>">
<td width="3%"> </td>
<td width="11%"> </td>
<td width="8%"> </td>
<td width="18%"> </td>
<td width="9%"> </td>
<td width="11%"> </td>
<td width="6%"> </td>
<td width="6%"> </td>
<td width="7%"> </td>
<td width="7%"> </td>
<td width="8%"> </td>
</tr>
<%
next
else
i = 0
total = rs.RecordCount
rs.pagesize = 10
if request("page") = "" then
page = 1
else
page = request("page")
end if
rs.AbsolutePage = page
pagecount = rs.pagecount
if int(page) >= int(rs.pagecount) then
page = rs.pagecount
end if
if page = 1 then
show_str = ""
else
show_str = " <a href=?page="&page-1&"&action=list>上一页</a> "
end if
if int(page) >= int(rs.pagecount) then
show_str = show_str&""
else
show_str = show_str&" <a href=?page="&page+1&"&action=list>下一页</a> "
end if
do while not(rs.EOF or rs.BOF)
%>
<tr bgcolor="<%=TableBodyColor%>" onMouseOver="this.style.backgroundColor='#ffffff'; " onMouseOut="this.style.backgroundColor='';">
<td width="3%">
<input type="checkbox" name="delid" value="<%=rs("id")%>" ID="Checkbox1">
</td>
<td width="11%">
<%=rs("startendTime")%>
</td>
<td width="8%">
<%=rs("workContent")%>
</td>
<td width="18%">
<%=rs("lessonName")%>
</td>
<td width="9%">
<%=rs("class")%>
</td>
<td width="11%">
<%=rs("period")%>
</td>
<td width="6%">
<%=rs("persons")%>
</td>
<td width="6%">
<%=rs("yearinfo")%>
</td>
<td width="7%">
<a href="MyProfile.asp?id=<%=rs("owner")%>" target="_blank" title="查看添加人的档案资料"><%=rs("adder")%></a>
</td>
<td width="7%">
<%=rs("changer")%>
</td>
<td align="center" width="8%">
<%if Session("isOpen") = 1 or Session("Admin") = true then%><a href="?action=change&id=<%=rs("id")%>">修改</a><%else%><font color=#99A6BF>修改</font><%end if%></td>
</tr>
<%
i = i + 1
if i = rs.pagesize then exit do
rs.MoveNext
loop
if i < 10 then
for j = 1 to (10 - i)
%>
<tr bgcolor="<%=TableBodyColor%>">
<td width="3%"> </td>
<td width="11%"> </td>
<td width="8%"> </td>
<td width="18%"> </td>
<td width="9%"> </td>
<td width="11%"> </td>
<td width="6%"> </td>
<td width="6%"> </td>
<td width="7%"> </td>
<td width="7%"> </td>
<td width="8%"> </td>
</tr>
<%
next
end if
%>
<tr bgcolor="<%=TableLeftColor%>">
<td colspan="11">
<table cellSpacing="0" cellPadding="0" border="0" height="80%" width="100%" ID="Table2">
<tr>
<td>
<input type="checkbox" name="chkall" value="on" onclick="CheckAll(this.form)" ID="chkall"><label for="chkall">选中所有显示记录</label>
<input type="submit" name="del" value="删除选中的资料" ID="Submit1" <%if Session("isOpen") = 1 or Session("Admin") = true then%><%else%> disabled <%end if%>>
</td>
<td>
每页显示
<%=rs.PageSize%>
条记录， 共 <font color="red"><b>
<%=page%>
</b></font>/<%=pagecount%>
页， 共有 <font color="red"><b>
<%=total%>
</b></font>条记录，
<%=show_str%>
</td>
</tr>
</table>
</td>
</tr>
<%
end if
%>
</table>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -