st_grade_manage.aspx
来自「学生管理系统。C#开发。偏重与数据库的应用。」· ASPX 代码 · 共 140 行
ASPX
140 行
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ST_grade_manage.aspx.cs" Inherits="ST_grade_manage" %>
<%@ Register TagPrefix="uc1" TagName="st_bottom" Src="ST_COMMAN/st_bottom.ascx" %>
<%@ Register TagPrefix="uc1" TagName="st_header" Src="ST_COMMAN/st_header.ascx" %>
<%@ Register TagPrefix="uc1" TagName="st_navigate" Src="ST_COMMAN/st_navigate.ascx" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
<link href="ST_COMMAN/style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div>
<uc1:st_header ID="St_header1" runat="server" />
<table id="Table1" align="center" border="1" cellpadding="1" cellspacing="1" width="777">
<tr>
<td style="width: 15%" valign="top">
<uc1:st_navigate id="St_navigate1" runat="server">
</uc1:st_navigate><span style="font-size: 10pt"> </span>
</td>
<td align="center" style="font-size: 10pt" valign="top">
成绩管理 查询方式：<asp:DropDownList ID="st_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="st_tbx_name" runat="server"
Width="75px"></asp:TextBox><font size="2">年度</font>：
<asp:TextBox ID="st_tbx_term" runat="server" Width="75px"></asp:TextBox><font color="#ff0000"
size="2">例：2005-2006<asp:Button ID="st_btn_search" runat="server" OnClick="st_btn_search_Click"
Text="查询" /><br />
<br />
</font><font face="宋体">
<table id="Table3" align="center" border="0" cellpadding="1" cellspacing="1" width="80%">
<tr>
<td colspan="2">
<font face="宋体" size="2">成绩统计：</font></td>
</tr>
<tr>
<td>
<font face="宋体" size="2">统计范围：</font></td>
<td>
<asp:DropDownList ID="st_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="st_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="st_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="st_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="st_tbx_year" runat="server" Width="75px"></asp:TextBox></font></td>
</tr>
<tr>
<td>
</td>
<td>
<font face="宋体">
<asp:Button ID="st_btn_count" runat="server" OnClick="st_btn_count_Click" Text="统计" /></font></td>
</tr>
</table>
<asp:DataGrid ID="st_dtg_grade" runat="server" AllowPaging="True" AutoGenerateColumns="False"
BackColor="LightGoldenrodYellow" BorderColor="Tan" BorderWidth="1px" CellPadding="2"
DataKeyField="ST_ID" ForeColor="Black" GridLines="None" HeaderStyle-BackColor="#f5f5f5"
OnCancelCommand="DataGrid_cancel" OnDeleteCommand="DataGrid_delete" OnEditCommand="DataGrid_edit"
OnPageIndexChanged="DataGrid_Page" OnUpdateCommand="DataGrid_update" Width="100%">
<SelectedItemStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
<AlternatingItemStyle BackColor="PaleGoldenrod" />
<HeaderStyle BackColor="Tan" Font-Bold="True" />
<FooterStyle BackColor="Tan" />
<Columns>
<asp:BoundColumn DataField="ST_ID" HeaderText="ID" ReadOnly="True"></asp:BoundColumn>
<asp:BoundColumn DataField="ST_Student_id" HeaderText="学号" ReadOnly="True"></asp:BoundColumn>
<asp:BoundColumn DataField="ST_Student_name" HeaderText=" 学生姓名" ReadOnly="True"></asp:BoundColumn>
<asp:BoundColumn DataField="ST_Student_classid" HeaderText="班级" ReadOnly="True"></asp:BoundColumn>
<asp:BoundColumn DataField="ST_Course_id" HeaderText="课号" ReadOnly="True"></asp:BoundColumn>
<asp:BoundColumn DataField="ST_Course_name" HeaderText="课程名" ReadOnly="True"></asp:BoundColumn>
<asp:BoundColumn DataField="ST_Teacher_name" HeaderText="任课教师" ReadOnly="True"></asp:BoundColumn>
<asp:BoundColumn DataField="ST_Student_grade" HeaderText="成绩"></asp:BoundColumn>
<asp:EditCommandColumn ButtonType="LinkButton" CancelText="取消" EditText="修改成绩" UpdateText="更新">
</asp:EditCommandColumn>
<asp:ButtonColumn CommandName="Delete" Text="删除"></asp:ButtonColumn>
</Columns>
<PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center"
Mode="NumericPages" NextPageText=">>" PrevPageText="<<" />
</asp:DataGrid><br />
<p align="center">
<asp:LinkButton ID="st_lbtn_addgrade" runat="server" OnClick="st_lbtn_addgrade_Click">录入新成绩</asp:LinkButton><br />
<asp:Label ID="st_lbl_average" runat="server"></asp:Label>
<asp:Label ID="st_lbl_high" runat="server"></asp:Label></p>
<p align="center">
<asp:Label ID="st_lbl_all" runat="server"></asp:Label></p>
<p align="center">
<asp:Label ID="st_lbl_a" runat="server"></asp:Label>
<asp:Label ID="st_lbl_unpass" runat="server"></asp:Label></p>
<p align="center">
<asp:Label ID="st_lbl_note" runat="server"></asp:Label>
<asp:Button ID="st_btn_exit" runat="server" OnClick="st_btn_exit_Click" Text="退出" /></p>
</font>
</td>
</tr>
</table>
<uc1:st_bottom ID="St_bottom1" runat="server" />
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?