⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 tea_addwork.asp

📁 在线学生成绩管理系统的功能包括:所在班级,所修科目,成绩记录,家长管理.......
💻 ASP
字号:
<!--#include file="conn.asp" -->
<!--#include file="login_menu.asp" -->
<!--#include file="error.asp" -->
<html>
<head>
<title><%=site_name%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="25175com_221.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!-- ImageReady Slices (25175_sub2.psd) -->
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td background="images/index_02.gif"><table width="898" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td>
<!--#include file="top.asp" -->
<table width="898" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="202" valign="top"><%call login()%></td>
    <td width="696" valign="top"><table width="695" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><img src="images/index_15.gif" width="695" height="48" alt=""></td>
      </tr>
      <tr>
        <td><table width="695" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="32"><img src="images/index_17.gif" width="32" height="579" alt=""></td>
            <td valign="top" bgcolor="#FFFFFF"><table width="619" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
              <tr>
                <td><table width="619" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
                  <tr>
                    <td width="340">&nbsp;</td>
                    <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td width="4%"><div align="right"><img src="images/index_19.gif" width="6" height="20" alt=""></div></td>
                        <td width="93%" bgcolor="#E4E7DB">&nbsp;&nbsp;<a href="index.asp">首页</a> &gt; 平时成绩添加</td>
                        <td width="3%"><img src="images/index_21.gif" width="7" height="20" alt=""></td>
                      </tr>
                    </table></td>
                  </tr>
                </table></td>
              </tr>
              <tr>
                <td height="80" valign="bottom"><table width="97%"  border="0" align="right" cellpadding="0" cellspacing="0">
                  <tr>
                    <td><div align="center"><img src="images/index_30.gif" width="6" height="70" alt=""></div></td>
                    <td width="600" background="images/index_31.gif">
<%
  if master25175="" then
      errmsg="<li>你还没有登陆,请先登陆"
	  call errormsg()
  else
      dim datey,datem,dated,set_cla_id,i,subname
	  set_cla_id=int(request.form("set_cla_id"))
	  datey=int(request.form("datey"))
	  datem=int(request.form("datem"))
	  dated=int(request.form("dated"))
	  subname=request.form("subname")
%>
    <table width="100%" border="0" cellpadding="0" cellspacing="0">
    <form name="form2" method="post" action="?">    
    <tr>
      <td>班级
        <select name="set_cla_id" id="set_cla_id">
<%
		  set rs=conn.execute("select distinct c.cid,c.cname,d.dname from class c,department d,teacher t,tea_sub ts where ts.ts_tea_user=t.tuser and ts.ts_cla_id=c.cid and c.dep_id=d.did and t.tuser='"&master25175&"' order by c.cid asc")
		  if rs.eof and rs.bof then
		      response.write"<option value='0'>-没有班级-</option>"
		  else
		      do while not rs.eof
                  if rs("cid")=set_cla_id then
                      response.write"<option value='"&rs("cid")&"' selected>"&rs("dname")&rs("cname")&"</option>"
	              else
                      response.write"<option value='"&rs("cid")&"'>"&rs("dname")&rs("cname")&"</option>"
	              end if
	              rs.movenext
              loop
		  end if
		  set rs=nothing
%>
		</select>	  </td>
      <td>课程
        <input name="subname" type="text" id="subname" value="<%=subname%>" size="10"></td>
      <td><select name="datey" id="datey">
<%
  for i=2006 to 2020
	  if i=datey then
          response.write"<option value='"&i&"' selected>"&i&"</option>"
	  else
          response.write"<option value='"&i&"'>"&i&"</option>"
      end if
  next
%>
         </select>
        <select name="datem" id="datem">
<%
  for i=1 to 12
	  if i=datem then
          response.write"<option value='"&i&"' selected>"&i&"</option>"
	  else
          response.write"<option value='"&i&"'>"&i&"</option>"
      end if
  next
%>
          </select>
        <select name="dated" id="select">
<%
  for i=1 to 31
	  if i=dated then
          response.write"<option value='"&i&"' selected>"&i&"</option>"
	  else
          response.write"<option value='"&i&"'>"&i&"</option>"
      end if
  next
%>
         </select>
        日</td>
      <td><br></td>
      <td><input type="submit" name="Submit4" value="设定">        </td>
    </tr>
	</form>
  </table>
<%
  end if
%>
                    <td>
                    <td><div align="center"><img src="images/index_34.gif" height="70" alt=""></div></td>
                  </tr>
                </table></td>
              </tr>
              <tr>
                <td><table width="90%"  border="0" align="center" cellpadding="0" cellspacing="0">
                  <tr>
                    <td height="419" valign="top">
<%
  if master25175<>"" then
%>					<form name="form1" method="post" action="tea_savework.asp">
  <table width="100%" align="center" cellpadding="2" cellspacing="0" <%=table_com%>>
    <tr>
<%
  i=0
  set rs=conn.execute("select suser,sname from student where cla_id="&set_cla_id&"")
  do while not rs.eof
      i=i+1
      response.write"<td><font color='#ff0000'>"&i&"</font> "&rs("sname")&"</td><td><input name='buser"&i&"' type='hidden' id='buser' size='2' value='"&rs("suser")&"'><input name='bresult"&i&"' type='text' id='bresult"&i&"' size='4'></td>"
	  rs.movenext
	  if i mod 4=0 then
	      response.write"</tr><tr>"
	  end if
  loop
  set rs=nothing
%>
    </tr>
	<tr>
	  <td height="50" colspan="8"><div align="center">
	    <input type="submit" name="Submit3" value="录入全班平时成绩">
			<input name="bbs_count" type="hidden" id="bbs_count" value="<%=i%>" size="2">
	        <input name="cla_id" type="hidden" id="cla_id" value="<%=set_cla_id%>" size="2">
			<input name="subname" type="hidden" id="subname" value="<%=subname%>" size="2">
	        <input name="dateym" type="hidden" id="dateym" value="<%=datey&"-"&datem&"-"&dated%>" size="2">
</div></td>
    </tr>
  </table>
</form>
<%
  end if
%></td>
                  </tr>
                  <tr>
                    <td height="18"><div align="center"></div></td>
                  </tr>
                </table></td>
              </tr>
              <tr>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td><img src="images/index_78.gif" alt="" width="620" height="24"></td>
              </tr>
            </table></td>
            <td width="43"><img src="images/index_22.gif" width="43" height="579" alt=""></td>
          </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
</table></td>
      </tr>
      <tr>
        <td><!--#include file="bottom.asp" -->
</td>
      </tr>
    </table></td>
  </tr>
</table>
<!-- End ImageReady Slices -->
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -