📄 zxtj.asp
字号:
<!--#include file="dataconn.asp"-->
<!--#include file="ADOVBS.INC"-->
<HTML>
<head>
<style type="text/css">
<!--
p{font-size:9pt};
td{font-size:9pt};
li{font-size:9pt};
select{font-size:9pt};
.forms {
BORDER-RIGHT: #254b03 1px solid; BORDER-TOP: #254b03 1px solid; MARGIN-TOP: auto; MARGIN-BOTTOM: auto; BORDER-LEFT: #254b03 1px solid; WIDTH: 80px; BORDER-BOTTOM: #254b03 1px solid; HEIGHT: 14px; BACKGROUND-COLOR: #ffffff
}
a {color:#0000ff;font-size: 9pt ;text-decoration:none; line-height:13.5pt}
a:hover {text-decoration:none; color:#000000;text-decoration: underline}
-->
.a10 { font-size: 10.5pt}
.bg {
background-repeat: no-repeat;
}
</style>
<script language="JavaScript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
<title>作业系统</title><meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head>
<body background="../images/untitled/bg.gif" leftmargin="0" topmargin="0">
<table width="760" cellpadding="0" cellspacing="0" border="0" align="center">
<tr>
<td background="../images/untitled/top.gif" height="15">
<div align="right"></div>
</td>
</tr>
</table>
<table width="760" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td><img src="../images/top.gif" width="760" height="100"></td>
</tr>
</table>
<table width="760" border="0" cellpadding="0" cellspacing="0" bordercolor="003366" align="center">
<tr>
<td background="../images/untitled/top2.gif" height="32">
<div align="right">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<div align="center"><img src="../images/untitled/top3.gif" width="197" height="32"></div>
<div align="right"></div></td>
</tr>
</table>
</div>
</td>
</tr>
</table>
<table width="760" border="0" cellpadding="0" cellspacing="0" bordercolor="003366" align="center">
<tr>
<td valign="top">
<table width="100%" height="438" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="438" align="center" valign="top" background="../images/untitled/bg1.png">
<div align="center"> </div>
<div align="left" class="bg"> <br>
<TABLE width="80%" border=0 align="center">
<TBODY>
<TR>
<TD height=21 vAlign=top><TABLE width="100%">
<TBODY>
<TR>
<TD vAlign=top><FIELDSET align=center>
<LEGEND align=top>最新需要提交的作业<br>
</LEGEND>
<%
'sql="select * from bzzy as a where id = (select max(id) from bzzy as b where a.zy_km = b.zy_km)"
'sql="select * from bzzy where zy_cs in (select max(zy_cs),zy_km from bzzy group by zy_km)"
'sql = "select * from bzzy where zy_km in (select distinct zy_km from bzzy) order by id desc"
sql="select * from bzzy as a where zy_cs = (select max(zy_cs) from bzzy as b where a.zy_km = b.zy_km)"
set rscat=conn.execute(sql)
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
if not rscat.eof then
do while not rscat.eof
%>
<%
'if (date()-rscat("zy_fbtime"))<15 then
'if (datediff("d",rscat("zy_fbtime"),date()))<15 then
%>
<tr>
<td height="20" width="5%"><img
height=20 src="../images/untitled/newsall.gif" width=14></td>
<td height="20" width="95%"><a href="tijiao.asp?id=<%=rscat("id")%>">第<%=rscat("zy_cs")%>次</a> <%=rscat("zy_km")%> 发布时间：[<%=formatdatetime(rscat("zy_fbtime"),1)%>]<img border="0" src="../images/untitled/new.gif" width="27" height="10">(期限：15天)</td>
</tr>
<% rscat.movenext
if rscat.eof then exit do
loop
%>
<% else %>
<tr>
<td height="20" width="100%">暂时没有需要提交的作业</td>
</tr>
<% end if %>
</table>
<BR>
</FIELDSET></TD>
</TR>
</TBODY>
</TABLE>
<br><br><table width="100%">
<tbody>
<tr>
<td valign=top> <FIELDSET align=center>
<LEGEND align=left>
已提交过的作业<br>
</LEGEND>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="20">
<%
sql_tj0="select * from tjzy where zy_studentid='"&session("student_id")&"' order by zy_km,zy_tjtime asc"
set rs0=conn.execute(sql_tj0)
if not rs0.eof then
%>
<%
sql_tj6="select * from tjzy where zy_studentid='"&session("student_id")&"' and ifread=true order by zy_km,zy_tjtime asc"
set rs6=conn.execute(sql_tj6)
if not rs6.eof then
%>
<tr>
<td height="20" colspan="2"><font color="#FF0000">已批改的作业</font></td>
</tr>
<%
sql_tj1="select * from tjzy where zy_studentid='"&session("student_id")&"' and ifread=true and zy_grade='优秀' order by zy_km,zy_tjtime asc"
set rs1=conn.execute(sql_tj1)
if not rs1.eof then
%>
<tr>
<td height="20" colspan="2">等级为优秀的作业：</td>
</tr>
<% do while not rs1.eof %>
<tr>
<td height="20" width="5%"><img
height=20 src="../images/untitled/newsall.gif" width=14></td>
<td height="20" width="95%"><a href="ypg_zy.asp?id=<%=rs1("id")%>">第<%=rs1("zy_cs")%>次</a> <%=rs1("zy_km")%> 提交时间:[<%=formatdatetime(rs1("zy_tjtime"),1)%>] (已批改)</td>
</tr>
<% rs1.movenext
if rs1.eof then exit do
loop
%>
<% else %>
<tr>
<td height="20" colspan="2">暂无等级为优秀的作业</td>
</tr>
<% end if %>
<%
sql_tj2="select * from tjzy where zy_studentid='"&session("student_id")&"' and ifread=true and zy_grade='良好' order by zy_km,zy_tjtime asc"
set rs2=conn.execute(sql_tj2)
if not rs2.eof then
%>
<tr>
<td height="20" colspan="2">等级为良好的作业：</td>
</tr>
<% do while not rs2.eof %>
<tr>
<td height="20" width="5%"><img
height=20 src="../images/untitled/newsall.gif" width=14></td>
<td height="20" width="95%"><a href="ypg_zy.asp?id=<%=rs2("id")%>">第<%=rs2("zy_cs")%>次</a> <%=rs2("zy_km")%> 提交时间:[<%=formatdatetime(rs2("zy_tjtime"),1)%>] (已批改)</td>
</tr>
<% rs2.movenext
if rs2.eof then exit do
loop
%>
<% else %>
<tr>
<td height="20" colspan="2">暂无等级为良好的作业</td>
</tr>
<% end if %>
<%
sql_tj3="select * from tjzy where zy_studentid='"&session("student_id")&"' and ifread=true and zy_grade='及格' order by zy_km,zy_tjtime asc"
set rs3=conn.execute(sql_tj3)
if not rs3.eof then
%>
<tr>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -