📄 grade_manage.aspx
字号:
<%@ Page language="c#" Codebehind="grade_manage.aspx.cs" AutoEventWireup="false" Inherits="sms.grade_manage" %>
<!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 id="grade_manage" method="post" runat="server">
<TABLE id="Table1" cellSpacing="1" cellPadding="1" width="98%" align="center" border="1">
<TR bgColor="#cccccc">
<TD colSpan="2">
<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><FONT face="宋体" size="2">具体范围：</FONT></TD>
<TD><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="统计"></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="查询"></asp:button><BR>
<BR>
</FONT><FONT face="宋体">
<asp:datagrid id="Dgd_grade" runat="server" OnPageIndexChanged="DataGrid_Page" AllowPaging="True" PageSize="5" HeaderStyle-BackColor="#f5f5f5" AutoGenerateColumns="False" OnCancelCommand="DataGrid_cancel" OnDeleteCommand="DataGrid_delete" OnEditCommand="DataGrid_edit" OnUpdateCommand="DataGrid_update" DataKeyField="ID" Width="100%">
<HeaderStyle BackColor="WhiteSmoke"></HeaderStyle>
<Columns>
<asp:BoundColumn DataField="ID" ReadOnly="True" HeaderText="ID"></asp:BoundColumn>
<asp:BoundColumn DataField="Student_id" ReadOnly="True" HeaderText="学号"></asp:BoundColumn>
<asp:BoundColumn DataField="Student_name" ReadOnly="True" HeaderText=" 学生姓名"></asp:BoundColumn>
<asp:BoundColumn DataField="Student_classid" ReadOnly="True" HeaderText="班级"></asp:BoundColumn>
<asp:BoundColumn DataField="Course_id" ReadOnly="True" HeaderText="课号"></asp:BoundColumn>
<asp:BoundColumn DataField="Course_name" ReadOnly="True" HeaderText="课程名"></asp:BoundColumn>
<asp:BoundColumn DataField="Teacher_name" ReadOnly="True" HeaderText="任课教师"></asp:BoundColumn>
<asp:BoundColumn DataField="Student_grade" HeaderText="成绩"></asp:BoundColumn>
<asp:EditCommandColumn ButtonType="LinkButton" UpdateText="更新" CancelText="取消" EditText="修改成绩"></asp:EditCommandColumn>
<asp:ButtonColumn Text="删除" CommandName="Delete"></asp:ButtonColumn>
</Columns>
<PagerStyle NextPageText=">>" PrevPageText="<<" HorizontalAlign="Right"></PagerStyle>
</asp:datagrid><BR>
<P align="center">
<EM>
<asp:linkbutton id="Link_addgrade" runat="server">录入新成绩</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 + -