?? cxbanji.asp
字號:
<!--#include file=conn.asp-->
<%
if session("charge")<>"2" then
response.write ("<script>alert('你沒有瀏覽日志的權(quán)限，請重登錄');history.go(-1);</script>")
end if
if request("banji")<>"" then
banji=request("banji")
end if
if banji<>"" or request("banji")<>"" then
set rs=server.createobject("adodb.recordset")
sql="select * from rizhi where class='"&banji&"' and year(date)='"&request("year")&"' and month(date)='"&request("month")&"' and day(date)='"&request("day")&"'"
rs.open sql,conn,1,1%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>重慶市萬州高級中學網(wǎng)上教學日程查詢系統(tǒng)</title>
<LINK href=news.css rel=stylesheet></head>
<body leftmargin="0" topmargin="0">
<%set rs2=server.createobject("adodb.recordset")
sql="select * from class"
rs2.open sql,conn,1,1%>
<form action="cxbanji.asp" method="post" name="form1" target="_self">
<div align="center">
<table width="105%" border="0" bordercolor="#99CCFF" bgcolor="#99CCFF">
<tr>
<td><div align="center"> 請選擇你要查詢的班級
<select name="banji">
<%if banji="" then%>
<option>請選擇班級</option>
<%else%>
<option><%=banji%></option>
<%end if%>
<%do while not rs2.eof%>
<option value="<%=rs2("classname")%>"><%=rs2("classname")%></option>
<%
rs2.movenext
loop%>
</select>
請選擇要查詢的日期
<input name="year" type="text" id="year" <%if request("year")="" then%>value="<%=year(now())%>"<%else%>value="<%=request("year")%>"<%end if %> size="6">
年
<select name="month" id="month">
<%if request("month")="" then%>
<option value="<%=month(now())%>"><%=month(now())%></option>
<%else%>
<option value="<%=request("month")%>"><%=request("month")%></option>
<%end if %>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
月
<input name="day" type="text" id="day" <%if request("day")="" then%>value="<%=day(now())%>"<%else%>value="<%=request("day")%>"<%end if %> size="6">
日
<input type="submit" name="Submit" value="提交">
</div></td>
</tr>
</table>
</div>
</form>
<div align="center">
<%if not rs.eof then%>
</div>
<%do while not rs.eof%>
<table width="464" border="1" align="center">
<tr bgcolor="#DCFFD7">
<td width="65">
<div align="center">科目</div></td>
<td width="82">
<div align="center">教師</div></td>
<td width="119">
<div align="center">日期</div></td>
<td width="66">
<div align="center">星期</div></td>
<td width="98">
<div align="center">課時</div></td>
</tr>
<tr>
<td><div align="center"><%=rs("kemu")%></div></td>
<td><div align="center"><%=rs("teachername")%> </div></td>
<td><div align="center"><%=year(rs("date"))%>年<%=month(rs("date"))%>月<%=day(rs("date"))%>日 </div></td>
<td><div align="center"> 星期<%=weekday(rs("date"))-1%> </div></td>
<td><div align="center"> <%=rs("jieci")%></div></td>
</tr>
<tr bgcolor="#EBFFE8">
<td>
<div align="center">出勤情況</div></td>
<td>
<div align="center">教學內(nèi)容</div></td>
<td>
<div align="center">電教設(shè)備使用</div></td>
<td>
<div align="center">普通話</div></td>
<td>
<div align="center">作業(yè)數(shù)量</div></td>
</tr>
<tr>
<td><div align="center"><%=rs("teacherchuqin")%> </div></td>
<td><div align="center"><%=rs("neirong")%></div></td>
<td><div align="center"><%=rs("dianjiao")%></div></td>
<td><div align="center"><%=rs("putong")%></div></td>
<td><div align="center"><%=rs("zyshuliang")%></div></td>
</tr>
<tr bgcolor="#EBFFE8">
<td>
<div align="center">作業(yè)來源</div></td>
<td bgcolor="#EBFFE8">
<div align="center">作業(yè)處理</div></td>
<td bgcolor="#EBFFE8">
<div align="center">聽課有無</div></td>
<td bgcolor="#EBFFE8">
<div align="center">聽課來源</div></td>
<td bgcolor="#EBFFE8">
<div align="center">學習地點</div></td>
</tr>
<tr>
<td><div align="center"><%=rs("zylaiyuan")%></div></td>
<td><div align="center"><%=rs("zychuli")%></div></td>
<td><div align="center"><%=rs("tkyouwu")%></div></td>
<td><div align="center"><%=rs("tklaiyuan")%></div></td>
<td><div align="center"><%=rs("didian")%></div></td>
</tr>
<%if rs("youwu")="有" then%>
<tr>
<td bgcolor="#EBFFE8">
<div align="center">調(diào)課情況</div></td>
<td colspan="4">本節(jié)原為<%=rs("tkteacher")%>老師的<%=rs("tkkemu")%>課，調(diào)至<%=rs("tkshijian")%>,<%=rs("tkjieci")%> </td>
</tr><%end if %>
<%if rs("yijian")<>"" then%>
<tr>
<td bgcolor="#EBFFE8">
<div align="center">教學意見</div></td>
<td colspan="4"><%=rs("yijian")%> </td>
</tr>
<%end if%>
<%if rs("beizhu")<>"" then%>
<tr>
<td bgcolor="#EBFFE8">
<div align="center">備注</div></td>
<td colspan="4"><%=rs("beizhu")%> </td>
</tr>
<%end if%></table>
<div align="center"><font color="#00CCFF">-----------------------------------------------------------------------------</font>
<%rs.movenext
loop%>
<table width="550" border="0" align="center" dwcopytype="CopyTableRow">
<tr>
<td height="38">
<div align="right"><a href="javascript:window.print()" class=bottom><img src="printer.gif" width="16" height="16" border="0">
打印本頁</a></div></td>
</tr>
</table>
<%else%>
</div>
<div align="center">今天沒有該班的日志記錄 </div>
<%end if%>
<%else%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>重慶市萬州高級中學網(wǎng)上教學日程查詢系統(tǒng)</title>
<LINK href=news.css rel=stylesheet></head>
<body leftmargin="0" topmargin="0">
<%set rs2=server.createobject("adodb.recordset")
sql="select * from class"
rs2.open sql,conn,1,1%>
<form action="cxbanji.asp" method="post" name="form1" target="_self">
<div align="center">
<table width="105%" border="0" bordercolor="#99CCFF" bgcolor="#99CCFF">
<tr>
<td><div align="center"> 請選擇你要查詢的班級
<select name="banji">
<%if banji="" then%>
<option>請選擇班級</option>
<%else%>
<option><%=banji%></option>
<%end if%>
<%do while not rs2.eof%>
<option value="<%=rs2("classname")%>"><%=rs2("classname")%></option>
<%
rs2.movenext
loop%>
</select>
請選擇要查詢的日期
<input name="year" type="text" id="year" value="<%=year(now())%>" size="6">
年
<select name="month" id="month">
<%if request("month")="" then%>
<option value="<%=month(now())%>"><%=month(now())%></option>
<%else%>
<option value="<%=request("month")%>"><%=request("month")%></option>
<%end if %>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
月
<input name="day" type="text" id="day" <%if request("day")="" then%>value="<%=day(now())%>"<%else%>value="<%=request("day")%>" <%end if%>size="6">
日
<input type="submit" name="Submit" value="提交">
</div></td>
</tr>
</table>
</div>
</form>
<div align="center">請選擇班級</div>
<%end if%>
<p> </p>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -