28,390
社区成员
发帖
与我相关
我的任务
分享
<!--#include file="conn.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<title>课时计算</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="style.css" media="screen"/>
</head>
<body>
<div id="content">
<a class="back" href=""></a>
<span class="scroll"></span>
<p class="head">初一年级课时计算系统
<a href="#">测试版</a>
</p>
<%
set mrs=server.CreateObject("adodb.recordset")
exec="select * from [班级] order by 编号 asc"
mrs.open exec,conn,1,1
%>
<%
do while not mrs.eof
%>
<h2>初一(<% =mrs ("班级") %>)班</h2>
<table class="table1">
<thead>
<tr>
<th>初一(<% =mrs ("班级") %>)班</th>
<th scope="col" abbr="Starter">语文</th>
<th scope="col" abbr="Medium">数学</th>
<th scope="col" abbr="Business">英语</th>
<th scope="col" abbr="Deluxe">物理</th>
</tr>
</thead>
<%
set rs=server.CreateObject("adodb.recordset")
exec="select * from [课程表] where 班级='"&mrs ("班级")&"' order by id asc"
rs.open exec,conn,1,1
%>
<%
i = 0
do while not rs.eof
i=i+1
if rs ("星期")=1 then
xq="星期一"
end if
if rs ("星期")=2 then
xq="星期二"
end if
if rs ("星期")=3 then
xq="星期三"
end if
if rs ("星期")=4 then
xq="星期四"
end if
if rs ("星期")=5 then
xq="星期五"
end if
if rs ("星期")=6 then
xq="星期六"
end if
if rs ("星期")=7 then
xq="星期日"
end if
if rs ("星期")=8 then
xq="小周一"
end if
if rs ("星期")=9 then
xq="小周二"
end if
if rs ("星期")=10 then
xq="小周三"
end if
if rs ("星期")=11 then
xq="小周四"
end if
%>
<tbody>
<tr>
<th scope="row"><% =xq %></th>
<td><% =rs ("语文") %></td>
<td><% =rs ("数学") %></td>
<td><% =rs ("英语") %></td>
<td><%=i%></td>
</tr>
</tbody>
<%
rs.movenext
loop
%>
<tfoot>
<tr>
<th scope="row">合计</th>
<td>小计</td>
<td>小计</td>
<td>小计</td>
<td>小计</td>
</tr>
</tfoot>
</table>
<%
rs.close
set rs=nothing
%>
<%
mrs.movenext
loop
mrs.close
set rs=nothing
%>
</div>
<table class="table1">
<tr>
<td>这里求语文一+语文二</td>
</tr>
<tr>
<td>这里求英语一+英语二+英语三</td>
</tr>
</table>
</body>
</html>
<!--#include file="conn.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<title>课时计算</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="style.css" media="screen"/>
</head>
<body>
<div id="content">
<a class="back" href=""></a >
<span class="scroll"></span>
<p class="head">初一年级课时计算系统
<a href=" ">测试版</a >
</p >
<%
set mrs=server.CreateObject("adodb.recordset")
exec="select * from [班级] order by 编号 asc"
mrs.open exec,conn,1,1
j = 0
sum_yuwen_2 = 0
sum_sum_yinyu_3 = 0
%>
<%
do while not mrs.eof
%>
<h2>初一(<% =mrs ("班级") %>)班</h2>
<table class="table1">
<thead>
<tr>
<th>初一(<% =mrs ("班级") %>)班</th>
<th scope="col" abbr="Starter">语文</th>
<th scope="col" abbr="Medium">数学</th>
<th scope="col" abbr="Business">英语</th>
<th scope="col" abbr="Deluxe">物理</th>
</tr>
</thead>
<%
sum_yuwen=0:sum_shuxue=0:sum_yinyu=0
set rs=server.CreateObject("adodb.recordset")
exec="select * from [课程表] where 班级='"&mrs ("班级")&"' order by id asc"
rs.open exec,conn,1,1
%>
<%
i = 0
do while not rs.eof
sum_yuwen = sum_yuwen + rs ("语文")
sum_shuxue = sum_shuxue + rs ("数学")
sum_yinyu = sum_yinyu + rs ("英语")
i=i+1
if rs ("星期")=1 then
xq="星期一"
end if
if rs ("星期")=2 then
xq="星期二"
end if
if rs ("星期")=3 then
xq="星期三"
end if
if rs ("星期")=4 then
xq="星期四"
end if
if rs ("星期")=5 then
xq="星期五"
end if
if rs ("星期")=6 then
xq="星期六"
end if
if rs ("星期")=7 then
xq="星期日"
end if
if rs ("星期")=8 then
xq="小周一"
end if
if rs ("星期")=9 then
xq="小周二"
end if
if rs ("星期")=10 then
xq="小周三"
end if
if rs ("星期")=11 then
xq="小周四"
end if
%>
<tbody>
<tr>
<th scope="row"><% =xq %></th>
<td><% =rs ("语文") %></td>
<td><% =rs ("数学") %></td>
<td><% =rs ("英语") %></td>
<td><%=i%></td>
</tr>
</tbody>
<%
rs.movenext
loop
%>
<tfoot>
<tr>
<th scope="row">合计</th>
<td><%= sum_yuwen %></td>
<td><%= sum_shuxue %></td>
<td><%= sum_yinyu %></td>
<td>小计</td>
</tr>
</tfoot>
</table>
<%
rs.close
set rs=nothing
%>
<%
If(j<2) Then
sum_yuwen_2 = sum_yuwen_2 + sum_yuwen
End if
If(j<3) Then
sum_yinyu_3 = sum_yinyu_3 + sum_yinyu
End if
j = j + 1
mrs.movenext
loop
mrs.close
set rs=nothing
%>
</div>
<table class="table1">
<tr>
<td>这里求语文一+语文二<%= sum_yuwen_2 %></td>
</tr>
<tr>
<td>这里求英语一+英语二+英语三<%= sum_yinyu_3 %></td>
</tr>
</table>
</body>
</html>