📄 grade_manage.aspx
字号:
<%@ Page language="c#" Inherits="sms.grade_manage" CodeFile="grade_manage.aspx.cs" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>grade_manage</title>
<meta content="Microsoft Visual Studio 7.0" name="GENERATOR">
<meta content="C#" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
</HEAD>
<body>
<form method="post" runat="server">
<TABLE id="Table1" cellSpacing="1" cellPadding="1" width="98%" align="center" border="1">
<TR bgColor="#cccccc">
<TD colSpan="2" bgcolor="#6699ff">
<P align="center"><FONT face="宋体" size="6"><STRONG>成绩管理</STRONG></FONT></P>
</TD>
</TR>
<TR>
<TD style="WIDTH: 161px" vAlign="top">
<P><FONT face="宋体"><BR>
</FONT><A href="student.aspx"><FONT face="宋体">学生管理</FONT></A></P>
<P><A href="classes.aspx"><FONT face="宋体">班级管理</FONT></A></P>
<P><A href="teacher.aspx"><FONT face="宋体">教师管理</FONT></A></P>
<P><A href="course.aspx"><FONT face="宋体">课程管理</FONT></A></P>
<P><A href="student_course.aspx"><FONT face="宋体">学生选课管理</FONT></A></P>
<P><A href="grade_manage.aspx"><FONT face="宋体">成绩管理</FONT></A></P>
<TABLE id="Table3" cellSpacing="1" cellPadding="1" width="97%" align="center" border="0">
<TR>
<TD colSpan="2"><FONT face="宋体" size="2">成绩统计：</FONT></TD>
</TR>
<TR>
<TD><FONT face="宋体" size="2">统计范围：</FONT></TD>
<TD>
<asp:dropdownlist id="Ddl_stat" runat="server" Width="76px">
<asp:ListItem Value="系别">系别</asp:ListItem>
<asp:ListItem Value="学院">学院</asp:ListItem>
<asp:ListItem Value="班级">班级</asp:ListItem>
</asp:dropdownlist><FONT size="2"></FONT></TD>
</TR>
<TR>
<TD style="height: 26px"><FONT face="宋体" size="2">具体范围：</FONT></TD>
<TD style="height: 26px"><FONT face="宋体">
<asp:textbox id="Tbx_area" runat="server" Width="75px"></asp:textbox></FONT></TD>
</TR>
<TR>
<TD><FONT face="宋体" size="2"> 课号：</FONT></TD>
<TD><FONT face="宋体">
<asp:textbox id="Tbx_classid" runat="server" Width="75px"></asp:textbox></FONT></TD>
</TR>
<TR>
<TD><FONT face="宋体" size="2">统计内容：</FONT></TD>
<TD><FONT face="宋体">
<asp:dropdownlist id="Ddl_content" runat="server" Width="76px">
<asp:ListItem Value="均分">均分</asp:ListItem>
<asp:ListItem Value="最高分">最高分</asp:ListItem>
<asp:ListItem Value="总人数">总人数</asp:ListItem>
<asp:ListItem Value="优秀人数">优秀人数</asp:ListItem>
<asp:ListItem Value="不及格人数">不及格人数</asp:ListItem>
</asp:dropdownlist></FONT></TD>
</TR>
<TR>
<TD><FONT face="宋体" size="2">年度：</FONT></TD>
<TD><FONT face="宋体">
<asp:textbox id="Tbx_year" runat="server" Width="75px"></asp:textbox></FONT></TD>
</TR>
<TR>
<TD></TD>
<TD><FONT face="宋体">
<asp:button id="Btn_count" runat="server" Text="统计" onclick="Btn_count_Click"></asp:button></FONT></TD>
</TR>
</TABLE>
</TD>
<TD vAlign="top" align="middle"><FONT size="2">查询方式</FONT>：<asp:dropdownlist id="Ddl_way" runat="server" Width="78px">
<asp:ListItem Value="按课号">按课号</asp:ListItem>
<asp:ListItem Value="按课程名">按课程名</asp:ListItem>
<asp:ListItem Value="按班级">按班级</asp:ListItem>
<asp:ListItem Value="按教师号">按教师号</asp:ListItem>
<asp:ListItem Value="按学生号">按学号</asp:ListItem>
</asp:dropdownlist><FONT size="2">查询内容</FONT>：<asp:textbox id="Tbx_name" runat="server" Width="75px"></asp:textbox><FONT size="2">年度</FONT>：
<asp:textbox id="Tbx_term" runat="server" Width="75px"></asp:textbox><FONT color="#ff0000" size="2">例：2000－2001<asp:button id="Btn_search" runat="server" Text="查询" onclick="Btn_search_Click"></asp:button><BR>
<BR>
</FONT><FONT face="宋体">
<asp:GridView ID="GridView1" runat="server" DataKeyNames="ID" AllowPaging="True" AutoGenerateColumns="False" OnPageIndexChanging="GridView1_PageIndexChanging" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True" SortExpression="ID" />
<asp:BoundField DataField="Student_id" HeaderText="学号" ReadOnly="True" SortExpression="Student_id" />
<asp:BoundField DataField="Student_name" HeaderText="学生姓名" ReadOnly="True" SortExpression="Student_name" />
<asp:BoundField DataField="Student_classid" HeaderText="班级" ReadOnly="True" SortExpression="Student_classid" />
<asp:BoundField DataField="Course_id" HeaderText="课号" ReadOnly="True" SortExpression="Course_id" />
<asp:BoundField DataField="Course_name" HeaderText="课程名" ReadOnly="True" SortExpression="Course_name" />
<asp:BoundField DataField="Teacher_name" HeaderText="任课教师" ReadOnly="True" SortExpression="Teacher_name" />
<asp:BoundField DataField="Student_grade" HeaderText="成绩" SortExpression="Student_grade" />
<asp:CommandField EditText="修改成绩" ShowEditButton="True" />
<asp:CommandField ShowDeleteButton="True" />
</Columns>
</asp:GridView>
<BR>
<P align="center">
<EM>
<asp:linkbutton id="Link_addgrade" runat="server" onclick="Link_addgrade_Click">录入新成绩</asp:linkbutton><BR>
</EM>
<asp:Label id="Lbl_average" runat="server"></asp:Label>
<asp:Label id="Lbl_high" runat="server"></asp:Label></P>
<P align="center">
<asp:Label id="Lbl_all" runat="server"></asp:Label></P>
<P align="center">
<asp:Label id="Lbl_a" runat="server"></asp:Label>
<asp:Label id="Lbl_unpass" runat="server"></asp:Label></P>
<P align="center"><asp:label id="Lbl_note" runat="server"></asp:label></P>
</FONT>
</TD>
</TR>
</TABLE>
</form>
</body>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -