?? yijian.asp
字號(hào):
<!--#include file=conn.asp-->
<%
if session("charge")<>"2" then
response.write ("<script>alert('你沒有瀏覽日志的權(quán)限，請(qǐng)重登錄');history.go(-1);</script>")
end if
dim beginday,endday
set rs1=server.createobject("adodb.recordset")
sql="select startday from config"
rs1.open sql,conn,3,1
if request("w")<>"" then
w=request("w")
else
i=1
beginday=rs1("startday")-weekday(rs1("startday"))+2+7*(i-1)
endday=beginday+6
nowday=date()
do while not (nowday>=beginday and nowday<=endday)
i=i+1
beginday=rs1("startday")-weekday(rs1("startday"))+2+7*(i-1)
endday=beginday+6
loop
w=i
end if
beginday=rs1("startday")-weekday(rs1("startday"))+2+7*(w-1)
endday=beginday+6
set rs=server.createobject("adodb.recordset")
sql="select * from rizhi where yijian<>'' and year(date)>=year('"&beginday&"') and month(date)>=month('"&beginday&"') and day(date)>=day('"&beginday&"') and year(date)<=year('"&endday&"') and month(date)<=month('"&endday&"') and day(date)<=day('"&endday&"')"
rs.open sql,conn,1,1%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>重慶市萬(wàn)州高級(jí)中學(xué)網(wǎng)上教學(xué)日程查詢系統(tǒng)</title>
<LINK href=news.css rel=stylesheet></head>
<body leftmargin="0" topmargin="0">
<form action="yijian.asp" method="post" name="form1" target="_self">
<div align="center">
<table width="105%" border="0" bordercolor="#99CCFF" bgcolor="#99CCFF">
<tr>
<td><div align="center">請(qǐng)輸入你要查詢的對(duì)教學(xué)意見情況的周次
<input name="w" type="text" id="w" size="5">
<input type="submit" name="Submit" value="提交">
</div></td>
</tr>
</table>
</div>
</form>
<div align="center"><%=beginday%>日至<%=endday%>日 第<%=w%>周
<%if not rs.eof then%>
</div>
<table width="556" border="1" align="center">
<!--DWLayoutTable-->
<%do while not rs.eof%>
<tr bgcolor="#B9DCFF">
<td width="91">
<div align="center">教師姓名</div></td>
<td width="86" bgcolor="#B9DCFF">
<div align="center">班級(jí)</div></td>
<td width="147" bgcolor="#B9DCFF">
<div align="center">日期</div></td>
<td width="94">
<div align="center">科目</div></td>
<td width="104">
<div align="center">課時(shí)</div></td>
</tr>
<tr bgcolor="#D0E8FF">
<td>
<div align="center"><%=rs("teachername")%></div></td>
<td>
<div align="center"><%=rs("class")%> </div></td>
<td>
<div align="center"><%=year(rs("date"))%>年<%=month(rs("date"))%>月<%=day(rs("date"))%>日 星期<%=weekday(rs("date"))-1%></div></td>
<td>
<div align="center"><%=rs("kemu")%> </div></td>
<td>
<div align="center"><%=rs("jieci")%> </div></td>
</tr>
<tr bgcolor="#B9DCFF">
<td colspan="5">
<div align="center">對(duì)教學(xué)的意見</div></td>
</tr>
<tr bgcolor="#D0E8FF">
<td colspan="5">
<div align="left"><%=rs("yijian")%></div></td>
</tr>
<tr>
<td height="20" colspan="5"> </td>
</tr>
<%rs.movenext
loop%>
</table>
<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">
打印本頁(yè)</a></div></td>
</tr>
</table>
<%else%>
<div align="center">本周沒有對(duì)教學(xué)意見的記錄
<%end if%>
</div>
<p> </p>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -