grade_manage.aspx.cs

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

			
			Dgd_grade.EditItemIndex=-1;
			Bindgrid();
			
		}
		public void DataGrid_edit(object sender,DataGridCommandEventArgs e)
		{
			
			Dgd_grade.EditItemIndex=(int)e.Item.ItemIndex;
			Bindgrid();
			
		}
		public void DataGrid_update(object sender,DataGridCommandEventArgs e)
		{
			string strsql="update student_course set Student_grade=@Student_grade where Student_id=@Student_id and Course_id=@Course_id and ID=@id";
			SqlCommand cm=new SqlCommand(strsql,cn);
			cm.Parameters.Add(new SqlParameter("@Student_grade",SqlDbType.Int,4));
			cm.Parameters.Add(new SqlParameter("@Course_id",SqlDbType.VarChar,50));
			cm.Parameters.Add(new SqlParameter("@Student_id",SqlDbType.VarChar,50));
			cm.Parameters.Add(new SqlParameter("@id",SqlDbType.Char,10));
			string colvalue=((TextBox)e.Item.Cells[7].Controls[0]).Text;
			cm.Parameters["@Student_grade"].Value=colvalue;
			cm.Parameters["@Student_id"].Value=e.Item.Cells[1].Text;
			cm.Parameters["@Course_id"].Value=e.Item.Cells[4].Text;
			cm.Parameters["@Student_grade"].Value=colvalue;
			cm.Parameters["@id"].Value=Dgd_grade.DataKeys[(int)e.Item.ItemIndex];
			cm.Connection.Open();
			try
			{
				cm.ExecuteNonQuery();
				Lbl_note.Text="编辑成功";
				Dgd_grade.EditItemIndex=-1;
			}
			catch(SqlException)
			{
				Lbl_note.Text="编辑失败";
				Lbl_note.Style["color"]="red";
			}
			cm.Connection.Close();		
			Bindgrid();
			
		}
		
		public void DataGrid_delete(object sender,DataGridCommandEventArgs e)
		{
			
			string strsql="delete from student_course where ID=@id";
			SqlCommand cm=new SqlCommand(strsql,cn);
			cm.Parameters.Add(new SqlParameter("@id",SqlDbType.Char,10));			
            cm.Parameters["@id"].Value=Dgd_grade.DataKeys[(int)e.Item.ItemIndex];
			cm.Connection.Open();
			try
			{
				cm.ExecuteNonQuery();
				Lbl_note.Text="删除成功";
				
			}
			catch(SqlException)
			{
				Lbl_note.Text="删除失败";
				Lbl_note.Style["color"]="red";
			}
			cm.Connection.Close();			
			Bindgrid();
		}

		private void Btn_count_Click(object sender, System.EventArgs e)
		{
			if(Ddl_stat.SelectedItem.Value=="系别")
			{
					
			   if(Ddl_content.SelectedItem.Text=="总人数")
			   {
				   strsql="select AVG(Student_grade),MAX(Student_grade),COUNT(*) from student_course,student,class where Course_id='"+Tbx_classid.Text+"' and student_course.Course_year='"+Tbx_year.Text+"'and student_course.Student_id=student.Student_id and student.Student_classid=class.Class_id and class.Class_department='"+Tbx_area.Text+"' ";
			   }
			   else if(Ddl_content.SelectedItem.Text=="优秀人数")
			   {
				   strsql="select AVG(Student_grade),MAX(Student_grade),COUNT(*) from student_course,student,class where Course_id='"+Tbx_classid.Text+"' and student_course.Course_year='"+Tbx_year.Text+"'and student_course.Student_id=student.Student_id and student.Student_classid=class.Class_id and class.Class_department='"+Tbx_area.Text+"'and Student_grade>=85 ";
			   }
			   else if(Ddl_content.SelectedItem.Text=="不及格人数")
			   {
				   strsql="select AVG(Student_grade),MAX(Student_grade),COUNT(*) from student_course,student,class where Course_id='"+Tbx_classid.Text+"' and student_course.Course_year='"+Tbx_year.Text+"'and student_course.Student_id=student.Student_id and student.Student_classid=class.Class_id and class.Class_department='"+Tbx_area.Text+"'and Student_grade<60 ";
			   }
				else
			   {
				 strsql="select AVG(Student_grade),MAX(Student_grade) from student_course,student,class where Course_id='"+Tbx_classid.Text+"' and student_course.Course_year='"+Tbx_year.Text+"'and student_course.Student_id=student.Student_id and student.Student_classid=class.Class_id and class.Class_department='"+Tbx_area.Text+"' ";
			   }
			}
			else if(Ddl_stat.SelectedItem.Value=="学院")
			{
				if(Ddl_content.SelectedItem.Text=="总人数")
				{
					strsql="select AVG(Student_grade),MAX(Student_grade),COUNT(*) from student_course,student,class where Course_id='"+Tbx_classid.Text+"' and student_course.Course_year='"+Tbx_year.Text+"'and student_course.Student_id=student.Student_id and student.Student_classid=class.Class_id and class.Class_college='"+Tbx_area.Text+"' ";
				}
				else if(Ddl_content.SelectedItem.Text=="优秀人数")
				{
					strsql="select AVG(Student_grade),MAX(Student_grade),COUNT(*) from student_course,student,class where Course_id='"+Tbx_classid.Text+"' and student_course.Course_year='"+Tbx_year.Text+"'and student_course.Student_id=student.Student_id and student.Student_classid=class.Class_id and class.Class_college='"+Tbx_area.Text+"'and Student_grade>=85 ";
				}
				else if(Ddl_content.SelectedItem.Text=="不及格人数")
				{
					strsql="select AVG(Student_grade),MAX(Student_grade),COUNT(*) from student_course,student,class where Course_id='"+Tbx_classid.Text+"' and student_course.Course_year='"+Tbx_year.Text+"'and student_course.Student_id=student.Student_id and student.Student_classid=class.Class_id and class.Class_college='"+Tbx_area.Text+"'and Student_grade<60 ";
				}
				else
				{
						strsql="select AVG(Student_grade),MAX(Student_grade) from student_course,student,class where Course_id='"+Tbx_classid.Text+"' and student_course.Course_year='"+Tbx_year.Text+"'and student_course.Student_id=student.Student_id and student.Student_classid=class.Class_id and class.Class_college='"+Tbx_area.Text+"' ";
				}
				
				
			}
			else if(Ddl_stat.SelectedItem.Value=="班级")
			{
				if(Ddl_content.SelectedItem.Text=="总人数")
				{
					strsql="select AVG(Student_grade),MAX(Student_grade),COUNT(*) from student_course,student where Course_id='"+Tbx_classid.Text+"' and student_course.Course_year='"+Tbx_year.Text+"' and student_course.Student_id=student.Student_id and student.Student_classid='"+Tbx_area.Text+"'";
				}
				else if(Ddl_content.SelectedItem.Text=="优秀人数")
				{
				strsql="select AVG(Student_grade),MAX(Student_grade),COUNT(*) from student_course,student where Course_id='"+Tbx_classid.Text+"' and student_course.Course_year='"+Tbx_year.Text+"' and student_course.Student_id=student.Student_id and student.Student_classid='"+Tbx_area.Text+"'and Student_grade>=85";
				}
				else if(Ddl_content.SelectedItem.Text=="不及格人数")
				{strsql="select AVG(Student_grade),MAX(Student_grade),COUNT(*) from student_course,student where Course_id='"+Tbx_classid.Text+"' and student_course.Course_year='"+Tbx_year.Text+"' and student_course.Student_id=student.Student_id and student.Student_classid='"+Tbx_area.Text+"'and Student_grade<60";
				}
				else
				{
						strsql="select AVG(Student_grade),MAX(Student_grade) from student_course,student where Course_id='"+Tbx_classid.Text+"' and student_course.Course_year='"+Tbx_year.Text+"' and student_course.Student_id=student.Student_id and student.Student_classid='"+Tbx_area.Text+"'";
				}
					
				
			}
			SqlCommand cm=new SqlCommand(strsql,cn);
			cn.Open();
			SqlDataReader dr=cm.ExecuteReader();
			if(dr.Read())
			{
				if(Ddl_content.SelectedItem.Text=="均分")
				{
					Lbl_average.Visible=true;
					Lbl_average.Text="平均分为："+dr[0].ToString();
				}
				else if(Ddl_content.SelectedItem.Text=="最高分")
				{
					Lbl_high.Visible=true;
					Lbl_high.Text="最高分为："+dr[1].ToString();
				}
				else if(Ddl_content.SelectedItem.Text=="总人数")
				{
					Lbl_all.Visible=true;
					Lbl_all.Text="总人数为："+dr[2].ToString();
				}
				else if(Ddl_content.SelectedItem.Text=="优秀人数")
				{
					Lbl_a.Visible=true;
					Lbl_a.Text="优秀人数为："+dr[2].ToString();
				}
				else if(Ddl_content.SelectedItem.Text=="不及格人数")
				{
						Lbl_unpass.Visible=true;
					Lbl_unpass.Text="不及格人数为："+dr[2].ToString();
				}
				else
				{Lbl_note.Text="无此信息";
				}
				cn.Close();
			}
			 
		}
		
	}
}