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

📄 st_grade_manage.aspx

📁 学生管理系统(asp.net+sql server)
💻 ASPX
字号:
<%@ 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" %>
<%@ Page language="c#" Codebehind="ST_grade_manage.aspx.cs" AutoEventWireup="false" Inherits="STGROUP.ST_grade_manage" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
	<HEAD>
		<title>ST_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">
		<LINK href="ST_COMMAN/style.css" type="text/css" rel="stylesheet">
	</HEAD>
	<body>
		<form id="grade_manage" method="post" runat="server">
			<uc1:st_header id="St_header1" runat="server"></uc1:st_header>
			<TABLE id="Table1" cellSpacing="1" cellPadding="1" width="777" align="center" border="1">
				<TR>
					<TD style="WIDTH: 15%" vAlign="top">
						<uc1:st_navigate id="St_navigate1" runat="server"></uc1:st_navigate>
					</TD>
					<TD vAlign="top" align="center">
						成绩管理&nbsp;&nbsp;查询方式:<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" Text="查询"></asp:button><BR>
							<BR>
						</FONT><FONT face="宋体">
							<TABLE id="Table3" cellSpacing="1" cellPadding="1" width="80%" 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="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" Text="统计"></asp:button></FONT></TD>
								</TR>
							</TABLE>
							<asp:datagrid id="st_dtg_grade" runat="server" OnPageIndexChanged="DataGrid_Page" AllowPaging="True"
								HeaderStyle-BackColor="#f5f5f5" AutoGenerateColumns="False" OnCancelCommand="DataGrid_cancel"
								OnDeleteCommand="DataGrid_delete" OnEditCommand="DataGrid_edit" OnUpdateCommand="DataGrid_update"
								DataKeyField="ST_ID" Width="100%" BorderColor="Tan" BorderWidth="1px" BackColor="LightGoldenrodYellow"
								CellPadding="2" GridLines="None" ForeColor="Black">
								<SelectedItemStyle ForeColor="GhostWhite" BackColor="DarkSlateBlue"></SelectedItemStyle>
								<AlternatingItemStyle BackColor="PaleGoldenrod"></AlternatingItemStyle>
								<HeaderStyle Font-Bold="True" BackColor="Tan"></HeaderStyle>
								<FooterStyle BackColor="Tan"></FooterStyle>
								<Columns>
									<asp:BoundColumn DataField="ST_ID" ReadOnly="True" HeaderText="ID"></asp:BoundColumn>
									<asp:BoundColumn DataField="ST_Student_id" ReadOnly="True" HeaderText="学号"></asp:BoundColumn>
									<asp:BoundColumn DataField="ST_Student_name" ReadOnly="True" HeaderText="  学生姓名"></asp:BoundColumn>
									<asp:BoundColumn DataField="ST_Student_classid" ReadOnly="True" HeaderText="班级"></asp:BoundColumn>
									<asp:BoundColumn DataField="ST_Course_id" ReadOnly="True" HeaderText="课号"></asp:BoundColumn>
									<asp:BoundColumn DataField="ST_Course_name" ReadOnly="True" HeaderText="课程名"></asp:BoundColumn>
									<asp:BoundColumn DataField="ST_Teacher_name" ReadOnly="True" HeaderText="任课教师"></asp:BoundColumn>
									<asp:BoundColumn DataField="ST_Student_grade" HeaderText="成绩"></asp:BoundColumn>
									<asp:EditCommandColumn ButtonType="LinkButton" UpdateText="更新" CancelText="取消" EditText="修改成绩"></asp:EditCommandColumn>
									<asp:ButtonColumn Text="删除" CommandName="Delete"></asp:ButtonColumn>
								</Columns>
								<PagerStyle NextPageText="&gt;&gt;" PrevPageText="&lt;&lt;" HorizontalAlign="Center" ForeColor="DarkSlateBlue"
									BackColor="PaleGoldenrod" Mode="NumericPages"></PagerStyle>
							</asp:datagrid><BR>
							<P align="center">
								<asp:linkbutton id="st_lbtn_addgrade" runat="server">录入新成绩</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" Text="退出"></asp:Button></P>
						</FONT>
					</TD>
				</TR>
			</TABLE>
			<uc1:st_bottom id="St_bottom1" runat="server"></uc1:st_bottom>
		</form>
	</body>
</HTML>

⌨️ 快捷键说明

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