grade_manage.aspx.cs

一个学生管理系统的C++源程序

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;

namespace sms
{
	/// <summary>
	/// grade_manage 的摘要说明。
	/// </summary>
	public class grade_manage : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DropDownList Ddl_way;
		protected System.Web.UI.WebControls.TextBox Tbx_name;
		protected System.Web.UI.WebControls.Button Btn_search;
		protected System.Web.UI.WebControls.DataGrid Dgd_grade;
		protected System.Web.UI.WebControls.LinkButton Link_addgrade;
	    SqlConnection cn; 
		protected System.Web.UI.WebControls.Label Lbl_note;
		protected System.Web.UI.WebControls.DropDownList Ddl_stat;
		protected System.Web.UI.WebControls.TextBox Tbx_area;
		protected System.Web.UI.WebControls.TextBox Tbx_classid;
		protected System.Web.UI.WebControls.DropDownList Ddl_content;
		protected System.Web.UI.WebControls.Button Btn_count;
		protected System.Web.UI.WebControls.TextBox Tbx_year;
		protected System.Web.UI.WebControls.Label Lbl_average;
		protected System.Web.UI.WebControls.Label Lbl_high;
		protected System.Web.UI.WebControls.Label Lbl_a;
		protected System.Web.UI.WebControls.Label Lbl_unpass;
		protected System.Web.UI.WebControls.Label Lbl_all;
		protected System.Web.UI.WebControls.TextBox Tbx_term;
		string strsql;
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			string strconn= ConfigurationSettings.AppSettings["dsn"];
			cn=new SqlConnection(strconn);	
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Btn_count.Click += new System.EventHandler(this.Btn_count_Click);
			this.Btn_search.Click += new System.EventHandler(this.Btn_search_Click);
			this.Link_addgrade.Click += new System.EventHandler(this.Link_addgrade_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		
		private void Link_addgrade_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("addgrade.aspx");
		}

		private void Btn_search_Click(object sender, System.EventArgs e)
		{
			Bindgrid();

		}
		public void DataGrid_Page(object sender,DataGridPageChangedEventArgs e)
		{
			Dgd_grade.CurrentPageIndex=e.NewPageIndex;
			Bindgrid();
		}
		public void Bindgrid()
		{
			if(Ddl_way.SelectedItem.Text=="按学号")
			{
				if(Tbx_term.Text=="所有")
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where student_course.Student_id='"+Tbx_name.Text+"' and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
				}
				else
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where student_course.Student_id='"+Tbx_name.Text+"' and Course_year='"+Tbx_term.Text+"' and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
				}
			}
			else if(Ddl_way.SelectedItem.Text=="按课号")
			{
				if(Tbx_term.Text=="所有")
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where student_course.Course_id='"+Tbx_name.Text+"' and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
				}
				else
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where student_course.Course_id='"+Tbx_name.Text+"' and student_course.Course_year='"+Tbx_term.Text+"' and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
				}
			}
			else if(Ddl_way.SelectedItem.Text=="按课程名")
			{
				if(Tbx_term.Text=="所有")
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where course.Course_name='"+Tbx_name.Text+"' and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
			
				}
				else
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where course.Course_name='"+Tbx_name.Text+"' and student_course.Course_year='"+Tbx_term.Text+"' and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
				}
			}
			else if(Ddl_way.SelectedItem.Text=="按班级")
			{
				if(Tbx_term.Text=="所有")
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where student.Student_classid='"+Tbx_name.Text+"'and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
			
				}
				else
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where student.Student_classid='"+Tbx_name.Text+"' and student_course.Course_year='"+Tbx_term.Text+"' and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
				}
			}
			else if(Ddl_way.SelectedItem.Text=="按教师号")
			{
				if(Tbx_term.Text=="所有")
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where teacher.Teacher_id='"+Tbx_name.Text+"' and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
			
				}
				else
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where teacher.Teacher_id='"+Tbx_name.Text+"' and student_course.Course_year='"+Tbx_term.Text+"' and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
				}
			}
			
			SqlCommand cm=new SqlCommand(strsql,cn);
			cn.Open();
			SqlDataReader dr=cm.ExecuteReader();
			if(dr.Read())
			{
				Dgd_grade.Visible=true;
				cn.Close();
				cn.Open();
				SqlDataAdapter da=new SqlDataAdapter(strsql,cn);
				DataSet ds=new DataSet();
				da.Fill(ds);
				Dgd_grade.DataSource=ds;
				Dgd_grade.DataBind();
			}
			else
			{
				Dgd_grade.Visible=false;
				Lbl_note.Text="无纪录！";
			}
			cn.Close();
		}
		public void DataGrid_cancel(object sender,DataGridCommandEventArgs e)
		{