selectscore.aspx.cs

精通网络应用系统开发 光盘 该书是人民邮电出版社出版的

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 System.Data.Linq;
using System.Collections.Generic;
using System.Linq;
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()
	{
		///定义获取数据的类
		GradeM grade = new GradeM();
		Table<Grade> rect = grade.GetGrades();

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

	protected void MethodList_SelectedIndexChanged(object sender, EventArgs e)
	{
		gvScore.DataSource = null;
		gvScore.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)
	{
		gvScore.DataSource = null;
		gvScore.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)
	{
		gvScore.DataSource = null;
		gvScore.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")
		{
			///显示查询的成绩
			ScoreM score = new ScoreM();
			IQueryable<Score> recs = score.GetScoreByGrade(Int32.Parse(GradeList.SelectedValue));
            //DataTable dt = SQLHelper.SystemTools.ConvertDataReaderToDataTable(recs);

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

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

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

            gvScore.DataSource = recs;
			gvScore.DataBind();	
		}
	}
}