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

📄 admin_addkc.asp

📁 ASP开发学生成绩查询管理系统,能满足毕业设计的要求
💻 ASP
字号:
<!--#include file="conn.asp" -->
<!--#include file="login_menu.asp" -->
<!--#include file="error.asp" -->
<html>
<head>
<title>25175学生成绩查询管理系统v2.21_(学生成绩查询)_(绩查询管理)</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="topadmin_kcs.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; <a href="admin_kcs.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">
<%
  dim rank
  if admin25175="" then
      errmsg="<li>你还没有登陆,请先登陆"
	  call errormsg()
  else
      set rs=conn.execute("select rank from manager where mname='"&admin25175&"'")
	  rank=rs("rank")
	  set rs=nothing
	  
	  if rank>=2 then
          '班级列表只读取一次,提高执行速度
          dim sel_class
		  set rs=conn.execute("select cid,cname from class")
          do while not rs.eof
              if rs("cid")=int(request.form("set_cla_id")) then
                  sel_class=sel_class&"<option value='"&rs("cid")&"' selected>"&rs("cname")&"</option>"
	          else
                  sel_class=sel_class&"<option value='"&rs("cid")&"'>"&rs("cname")&"</option>"
	          end if
	          rs.movenext
          loop
          set rs=nothing  
%>
    <table width="100%" border="0" cellpadding="0" cellspacing="0">
    <form name="form2" method="post" action="?">    
    <tr>
      <td>课程数
        <select name="set_kc_count" id="set_kc_count">
          <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>        </td>
      <td>课程公共字
        <input name="set_sname" type="text" id="set_sname" size="5"></td>
      <td>所属班级
        <select name="set_cla_id" id="select2">
        <%=sel_class%>
        </select></td>
      <td>所属学期
        <select name="set_sterm" id="select">
          <option value="1">第一学期</option>
          <option value="2">第二学期</option>
          <option value="3">第三学期</option>
          <option value="4">第四学期</option>
          <option value="5">第五学期</option>
          <option value="6">第六学期</option>
          <option value="7">第七学期</option>
          <option value="8">第八学期</option>
                </select></td>
      <td>类型
        <select name="set_stype" id="set_stype">
          <option value="必修">必修</option>
          <option value="选修">选修</option>
        </select>        </td>
      <td><input type="submit" name="Submit4" value="设定参数"></td>
    </tr>
	</form>
  </table>
<%
      else
	      errmsg="<li>你没有操作权限"
	      call errormsg()
	  end if
  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 rank>=2 then
%>					<form name="form1" method="post" action="admin_savekc.asp">
                   <table width="100%" border="0" cellspacing="4" cellpadding="0">
<tr>
  <td><div align="center">课程</div></td>
  <td><div align="center">所属班级</div></td>
  <td><div align="center">所属学期</div></td>
  <td><div align="center">类型</div></td>
</tr>
<%
  dim i,set_kc_count,set_sname,set_cla_id,set_sterm,set_stype
  set_kc_count=request.form("set_kc_count")
  set_sname=request.form("set_sname")
  set_cla_id=request.form("set_cla_id")
  set_sterm=request.form("set_sterm")
  set_stype=request.form("set_stype")
  if set_kc_count="" then set_kc_count=1
  for i=1 to set_kc_count
%>                        
<tr>
                          <td><div align="center"><font color="#FF0000"><%=i%></font>
                            <input name="sname<%=i%>" type="text" id="sname<%=i%>" value="<%=set_sname%>">
                          </div></td>
                          <td><div align="center">
                            <select name="cla_id<%=i%>" id="select3">
							<%=sel_class%>
                            </select>
                          </div></td>
                          <td><div align="center">
                            <select name="sterm<%=i%>" id="select4">
                              <option value="1" <%if set_sterm=1 then response.write"selected"%>>第一学期</option>
                              <option value="2" <%if set_sterm=2 then response.write"selected"%>>第二学期</option>
                              <option value="3" <%if set_sterm=3 then response.write"selected"%>>第三学期</option>
                              <option value="4" <%if set_sterm=4 then response.write"selected"%>>第四学期</option>
                              <option value="5" <%if set_sterm=5 then response.write"selected"%>>第五学期</option>
                              <option value="6" <%if set_sterm=6 then response.write"selected"%>>第六学期</option>
                              <option value="7" <%if set_sterm=7 then response.write"selected"%>>第七学期</option>
                              <option value="8" <%if set_sterm=8 then response.write"selected"%>>第八学期</option>
                            </select>
                          </div></td>
                          <td><div align="center">
                            <select name="stype<%=i%>" id="select5">
                              <option value="必修" <%if set_stype="必修" then response.write"selected"%>>必修</option>
                              <option value="选修" <%if set_stype="选修" then response.write"selected"%>>选修</option>
                            </select>
                          </div></td>
</tr>
<%
  next
%>
                        <tr>
                          <td height="40" colspan="4" valign="bottom"><div align="center">
                            <input name="kc_count" type="hidden" id="kc_count" value="<%=i%>" size="5">
                            <input type="submit" name="Submit3" value="添加课程">
                          </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 + -