grade_manage.aspx.cs

C# SQL遍写的学生选课系统 给大家看看 有点多 有点复杂

			
        //    string strsql="delete from student_course where ID='"+Dgd_grade.DataKeys[(int)e.Item.ItemIndex]+"'";
        //    DataAccess DataAs = new DataAccess();
        //    bool Result = DataAs.ExecSql(strsql);
        //    if (Result)
        //    {
        //        Lbl_note.Text="删除成功";
				
        //    }
        //    else
        //    {
        //        Lbl_note.Text="删除失败";
        //        Lbl_note.Style["color"]="red";
        //    }			
        //    Bindgrid();
        //}

		protected 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+"'";
				}
					
				
			}
            DataAccess DataAs = new DataAccess();
            DataTable DT = DataAs.CreateDatatable(strsql);
			if(DT.Rows.Count>0)
			{
				if(Ddl_content.SelectedItem.Text=="均分")
				{
					Lbl_average.Visible=true;
					Lbl_average.Text="平均分为："+DT.Rows[0][0].ToString();
				}
				else if(Ddl_content.SelectedItem.Text=="最高分")
				{
					Lbl_high.Visible=true;
					Lbl_high.Text="最高分为："+DT.Rows[0][1].ToString();
				}
				else if(Ddl_content.SelectedItem.Text=="总人数")
				{
					Lbl_all.Visible=true;
					Lbl_all.Text="总人数为："+DT.Rows[0][2].ToString();
				}
				else if(Ddl_content.SelectedItem.Text=="优秀人数")
				{
					Lbl_a.Visible=true;
					Lbl_a.Text="优秀人数为："+DT.Rows[0][2].ToString();
				}
				else if(Ddl_content.SelectedItem.Text=="不及格人数")
				{
						Lbl_unpass.Visible=true;
					Lbl_unpass.Text="不及格人数为："+DT.Rows[0][2].ToString();
				}
				else
				{Lbl_note.Text="无此信息";
				}

			}
			 
		}

        protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            GridView1.PageIndex = e.NewPageIndex;
            Bindgrid();
        }
        protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            GridView1.EditIndex = -1;
            Bindgrid();

        }
        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            string strsql = "delete from student_course where ID='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
            DataAccess DataAs = new DataAccess();
            bool Result = DataAs.ExecSql(strsql);
            if (Result)
            {
                Lbl_note.Text = "删除成功";

            }
            else
            {
                Lbl_note.Text = "删除失败";
                Lbl_note.Style["color"] = "red";
            }
            Bindgrid();
        }
        protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
        {
            GridView1.EditIndex = e.NewEditIndex;
            Bindgrid();
        }
        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            GridViewRow gvr = GridView1.Rows[e.RowIndex];
            string strsql = "update student_course set Student_grade=" + ((TextBox)gvr.Cells[7].Controls[0]).Text + "where Student_id='" + gvr.Cells[1].Text + "'and Course_id='" + gvr.Cells[1].Text + "'and ID='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
            DataAccess DataAs = new DataAccess();
            bool Result = DataAs.ExecSql(strsql);
            if (Result)
            {
                Lbl_note.Text = "编辑成功";
                GridView1.EditIndex = -1;
            }
            else
            {
                Lbl_note.Text = "编辑失败";
                Lbl_note.Style["color"] = "red";
            }
            Bindgrid();

        }
}
}