checkscore.aspx.cs

来自「《精通ASP.NET2.0网络应用系统开发》书中的源码」· CS 代码 · 共 206 行

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using StudentManager;
using System.Data.SqlClient;

public partial class DesktopModules_Score_CheckScore : System.Web.UI.Page
{
	private int nScoreID = -1;

	protected void Page_Load(object sender, EventArgs e)
	{
		if (!Page.IsPostBack)
		{
			///显示班级的数据
			BindClassData();
			BindCourseData();
			if (ClassList.Items.Count > 0)
			{
				ClassList.SelectedIndex = 0;
				BindStudentData(Int32.Parse(ClassList.Items[0].Value));
			}
			if (CourseList.Items.Count > 0)
			{
				CourseList.SelectedIndex = 0;
			}
		}
	}

	private void BindClassData()
	{
		///定义获取数据的类
		Class gClass = new Class();
		SqlDataReader recg = gClass.GetClasss();

		///设定控件的数据源
		ClassList.DataSource = recg;

		///设定控件的Text属性和Value属性
		ClassList.DataTextField = "Desn";
		ClassList.DataValueField = "ClassID";

		///绑定控件的数据
		ClassList.DataBind();

		///关闭数据读取器和数据库的连接
		recg.Close();
	}

	private void BindStudentData(int nClassID)
	{
		///定义获取数据的类
		Student student = new Student();
		SqlDataReader recd = student.GetStudentByClass(nClassID);

		///设定控件的数据源
		StudentList.DataSource = recd;

		///设定控件的Text属性和Value属性
		StudentList.DataTextField = "Name";
		StudentList.DataValueField = "StudentID";

		///绑定控件的数据
		StudentList.DataBind();

		///关闭数据读取器和数据库的连接
		recd.Close();
	}

	private void BindCourseData()
	{
		///定义获取数据的类
		Course course = new Course();
		SqlDataReader recc = course.GetCourses();

		///设定控件的数据源
		CourseList.DataSource = recc;

		///设定控件的Text属性和Value属性
		CourseList.DataTextField = "Desn";
		CourseList.DataValueField = "CourseID";

		///绑定控件的数据
		CourseList.DataBind();

		///关闭数据读取器和数据库的连接
		recc.Close();
	}

	private void BindScoreData(int nStudentID, int nCourseID)
	{
		///定义获取数据的类
		Score score = new Score();
		SqlDataReader recs = score.GetScoreByStudentCourse(nStudentID,nCourseID);

		if (recs.Read())
		{
			Mark.Text = recs["Mark"].ToString();
		}
		else
		{
			Mark.Text = "无成绩";
		}
		recs.Close();
	}

	protected void ClassList_SelectedIndexChanged(object sender, EventArgs e)
	{
		if (ClassList.SelectedIndex <= -1)
		{
			StudentList.Items.Clear();

			///显示操作结果信息
			Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONNOSELECTMESSAGE + "')</script>");
			return;
		}

		///重新显示学生信息
		BindStudentData(Int32.Parse(ClassList.SelectedValue));
	}

	protected void AddStudent_Click(object sender, EventArgs e)
	{
		if (StudentList.SelectedIndex <= -1)
		{
			///显示操作结果信息
			Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONNOSELECTMESSAGE + "')</script>");
			return;
		}
		Name.Text = StudentList.SelectedItem.Text;
		if (CourseList.SelectedIndex > -1)
		{
			///显示学生的成绩
			BindScoreData(Int32.Parse(StudentList.SelectedValue), Int32.Parse(CourseList.SelectedValue));
		}
	}

	protected void CheckBtn_Click(object sender, EventArgs e)
	{
		if (StudentList.SelectedIndex <= -1)
		{
			///显示操作结果信息
			Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONNOSELECTMESSAGE + "')</script>");
			return;
		}
		if (CourseList.SelectedIndex <= -1)
		{
			///显示操作结果信息
			Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONNOSELECTMESSAGE + "')</script>");
			return;
		}
		///如果页面输入内容合法
		if (Page.IsValid == true)
		{
			///定义类
			StudentManager.Score score = new Score();
			try
			{
				///修改成绩
				score.CheckScore(Int32.Parse(StudentList.SelectedValue), Int32.Parse(CourseList.SelectedValue));

				///显示操作结果信息
				Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONUPDATESUCCESSMESSAGE + "')</script>");
			}
			catch (Exception ex)
			{
				///显示修改操作中的失败、错误信息
				Response.Redirect("~/DesktopModules/ErrorPage.aspx?ErrorUrl="
					+ ASPNET2System.RedirectErrorUrl(Request.RawUrl)
					+ "&ErrorMessage=" + ex.Message.Replace("\n", " "));
			}
		}
	}

	protected void ReturnBtn_Click(object sender, EventArgs e)
	{
		///返回管理页面
		Response.Redirect("~/DesktopModules/Score/ScoreManage.aspx");
	}

	protected void CourseList_SelectedIndexChanged(object sender, EventArgs e)
	{
		if (StudentList.SelectedIndex <= -1)
		{
			///显示操作结果信息
			Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONNOSELECTMESSAGE + "')</script>");
			return;
		}
		if (CourseList.SelectedIndex <= -1)
		{
			///显示操作结果信息
			Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONNOSELECTMESSAGE + "')</script>");
			return;
		}
		///显示学生的成绩
		BindScoreData(Int32.Parse(StudentList.SelectedValue), Int32.Parse(CourseList.SelectedValue));
	}
}