selectscore.aspx.cs

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

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 System.Data.SqlClient;
using StudentManager;
using SQLHelper;

public partial class DesktopModules_Score_SelectScore : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
		///
		GradeList.Visible = GradeLable.Visible = false;
		if (!Page.IsPostBack)
		{
			///绑定年级的数据
			BindGradeData();
			GradeList.Visible = GradeLable.Visible = true;
		}
    }

	private void BindGradeData()
	{
		///定义获取数据的类
		Grade grade = new Grade();
		SqlDataReader rect = grade.GetGrades();

		///设定控件的数据源
		GradeList.DataSource = rect;

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

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

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

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

		///设定控件的数据源
		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();
	}

	protected void MethodList_SelectedIndexChanged(object sender, EventArgs e)
	{
		ScoreList.DataSource = null;
		ScoreList.DataBind();

		///按年级查询
		if (MethodList.SelectedValue == "0")
		{
			///设置选择列表的可见性
			GradeList.Visible = GradeLable.Visible = true;			
			ClassList.Visible = ClassLabel.Visible = false;
			StudentList.Visible = StudentLabel.Visible = false;
			CourseList.Visible = CourseLabel.Visible = false;
			
			///绑定年级信息
			BindGradeData();
			if (GradeList.Items.Count > 0)
			{
				GradeList.SelectedIndex = 0;
			}

		}
		///按班级查询
		if (MethodList.SelectedValue == "1")
		{
			///设置选择列表的可见性
			GradeList.Visible = GradeLable.Visible = true;
			ClassList.Visible = ClassLabel.Visible = true;
			StudentList.Visible = StudentLabel.Visible = false;
			CourseList.Visible = CourseLabel.Visible = false;

			///绑定年级信息
			BindGradeData();
			if (GradeList.Items.Count > 0)
			{
				GradeList.SelectedIndex = 0;
			}

			///绑定班级信息
			if (GradeList.SelectedIndex > -1)
			{
				BindClassData(Int32.Parse(GradeList.SelectedValue));
			}
			else
			{
				ClassList.Items.Clear();
			}
		}
		///按学生查询
		if (MethodList.SelectedValue == "2")
		{
			///设置选择列表的可见性
			GradeList.Visible = GradeLable.Visible = true;
			ClassList.Visible = ClassLabel.Visible = true;
			StudentList.Visible = StudentLabel.Visible = true;
			CourseList.Visible = CourseLabel.Visible = false;

			///绑定年级信息
			BindGradeData();
			if (GradeList.Items.Count > 0)
			{
				GradeList.SelectedIndex = 0;
			}

			///绑定班级信息			
			///绑定学生信息
			GradeList_SelectedIndexChanged(sender, e);			
		}
		///按课程查询
		if (MethodList.SelectedValue == "3")
		{
			///设置选择列表的可见性
			GradeList.Visible = GradeLable.Visible = false;
			ClassList.Visible = ClassLabel.Visible = false;
			StudentList.Visible = StudentLabel.Visible = false;

			CourseList.Visible = CourseLabel.Visible = true;
			BindCourseData();
			if (CourseList.Items.Count > 0)
			{
				CourseList.SelectedIndex = 0;
			}
		}
	}

	protected void ReturnBtn_Click(object sender, EventArgs e)
	{
		///
	}

	protected void GradeList_SelectedIndexChanged(object sender, EventArgs e)
	{
		ScoreList.DataSource = null;
		ScoreList.DataBind();

		///绑定班级信息
		if (GradeList.SelectedIndex > -1)
		{
			BindClassData(Int32.Parse(GradeList.SelectedValue));
		}
		else
		{
			ClassList.Items.Clear();
		}

		///绑定学生信息
		ClassList_SelectedIndexChanged(sender, e);
	}

	protected void ClassList_SelectedIndexChanged(object sender, EventArgs e)
	{
		ScoreList.DataSource = null;
		ScoreList.DataBind();

		///绑定学生信息
		if (ClassList.SelectedIndex > -1)
		{
			BindStudentData(Int32.Parse(ClassList.SelectedValue));
			if (StudentList.Items.Count > 0)
			{
				StudentList.SelectedIndex = 0;
			}
		}
		else
		{
			StudentList.Items.Clear();
		}
	}

	protected void SelectBtn_Click(object sender, EventArgs e)
	{
		///按年级查询
		if (MethodList.SelectedValue == "0")
		{
			///显示查询的成绩
			Score score = new Score();
			SqlDataReader recs = score.GetScoreByGrade(Int32.Parse(GradeList.SelectedValue));
			DataTable dt = SQLHelper.SystemTools.ConvertDataReaderToDataTable(recs);

			ScoreList.DataSource = dt;
			ScoreList.DataBind();			
		}
		///按班级查询
		if (MethodList.SelectedValue == "1")
		{
			///显示查询的成绩
			Score score = new Score();
			SqlDataReader recs = score.GetScoreByClass(Int32.Parse(ClassList.SelectedValue));
			DataTable dt = SQLHelper.SystemTools.ConvertDataReaderToDataTable(recs);

			ScoreList.DataSource = dt;
			ScoreList.DataBind();	
		}
		///按学生查询
		if (MethodList.SelectedValue == "2")
		{
			///显示查询的成绩
			Score score = new Score();
			SqlDataReader recs = score.GetScoreByStudent(Int32.Parse(StudentList.SelectedValue));
			DataTable dt = SQLHelper.SystemTools.ConvertDataReaderToDataTable(recs);

			ScoreList.DataSource = dt;
			ScoreList.DataBind();	
		}
		///按课程查询
		if (MethodList.SelectedValue == "3")
		{
			///显示查询的成绩
			Score score = new Score();
			SqlDataReader recs = score.GetScoreByCourse(Int32.Parse(CourseList.SelectedValue));
			DataTable dt = SQLHelper.SystemTools.ConvertDataReaderToDataTable(recs);

			ScoreList.DataSource = dt;
			ScoreList.DataBind();	
		}
	}
}