ourse.Course_year='"+Tbx_term.Text+"'andstudent_course.Course_id=course.Course_idandstudent_course.Student_id=student.Student_idandstudent_course.Course_id=teacher_course.Course_idandteacher_course.Teacher_id=teacher.Teacher_idandteacher_course.Class_id=student.Student_classid";
}
}
elseif(Ddl_way.SelectedItem.Text=="按班级")
{
if(Tbx_term.Text=="所有")
{
strsql="selectstudent_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_gradefromcourse,student,teacher,student_course,teacher_coursewherestudent.Student_classid='"+Tbx_name.Text+"'andstudent_course.Course_id=course.Course_idandstudent_course.Student_id=student.Student_idandstudent_course.Course_id=teacher_course.Course_idandteacher_course.Teacher_id=teacher.Teacher_idandteacher_course.Class_id=student.Student_classid";
}
else
{
strsql="selectstudent_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_gradefromcourse,student,teacher,student_course,teacher_coursewherestudent.Student_classid='"+Tbx_name.Text+"'andstudent_course.Course_year='"+Tbx_term.Text+"'andstudent_course.Course_id=course.Course_idandstudent_course.Student_id=student.Student_idandstudent_course.Course_id=teacher_course.Course_idandteacher_course.Teacher_id=teacher.Teacher_idandteacher_course.Class_id=student.Student_classid";
}
}
elseif(Ddl_way.SelectedItem.Text=="按教师号")
{
if(Tbx_term.Text=="所有")
{
strsql="selectstudent_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_gradefromcourse,student,teacher,student_course,teacher_coursewhereteacher.Teacher_id='"+Tbx_name.Text+"'andstudent_course.Course_id=course.Course_idandstudent_course.Student_id=student.Student_idandstudent_course.Course_id=teacher_course.Course_idandteacher_course.Teacher_id=teacher.Teacher_idandteacher_course.Class_id=student.Student_classid";
}
else
{
strsql="selectstudent_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_gradefromcourse,student,teacher,student_course,teacher_coursewhereteacher.Teacher_id='"+Tbx_name.Text+"'andstudent_course.Course_year='"+Tbx_term.Text+"'andstudent_course.Course_id=course.Course_idandstudent_course.Student_id=student.Student_idandstudent_course.Course_id=teacher_course.Course_idandteacher_course.Teacher_id=teacher.Teacher_idandteacher_course.Class_id=student.Student_classid";
}
}
SqlCommandcm=newSqlCommand(strsql,cn);
cn.Open();
SqlDataReaderdr=cm.ExecuteReader();
if(dr.Read())
{
Dgd_grade.Visible=true;
cn.Close();
cn.Open();
SqlDataAdapterda=newSqlDataAdapter(strsql,cn);
DataSetds=newDataSet();
da.Fill(ds);
Dgd_grade.DataSource=ds;
Dgd_grade.DataBind();
}
else
{
Dgd_grade.Visible=false;
Lbl_note.Text="无纪录!";
}
cn.Close();
}
publicvoidDataGrid_cancel(objectsender,DataGridCommandEventArgse)
{
Dgd_grade.EditItemIndex=-1;
Bindgrid();
}
publicvoidDataGrid_edit(objectsender,DataGridCommandEventArgse)
{
Dgd_grade.EditItemIndex=(int)e.Item.ItemIndex;
Bindgrid();
}
publicvoidDataGrid_update(objectsender,DataGridCommandEventArgse)
{
stringstrsql="updatestudent_coursesetStudent_grade=@Student_gradewhereStudent_id=@Student_idandCourse_id=@Course_idandID=@id";
SqlCommandcm=newSqlCommand(strsql,cn);
cm.Parameters.Add(newSqlParameter("@Student_grade",SqlDbType.Int,4));
cm.Parameters.Add(newSqlParameter("@Course_id",SqlDbType.VarChar,50));
cm.Parameters.Add(newSqlParameter("@Student_id",SqlDbType.VarChar,50));
cm.Parameters.Add(newSqlParameter("@id",SqlDbType.Char,10));
stringcolvalue=((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();
}
publicvoidDataGrid_delete(objectsender,DataGridCommandEventArgse)
{
stringstrsql="deletefromstudent_coursewhereID=@id";
SqlCommandcm=newSqlCommand(strsql,cn);
cm.Parameters.Add(newSqlParameter("@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();
}
privatevoidBtn_count_Click(objectsender,System.EventArgse)
{
if(Ddl_stat.SelectedItem.Value=="系别")
{
if(Ddl_content.SelectedItem.Text=="总人数")
{
strsql="selectAVG(Student_grade),MAX(Student_grade),COUNT(*)fromstudent_course,student,classwhereCourse_id='"+Tbx_classid.Text+"'andstudent_course.Course_year='"+Tbx_year.Text+"'andstudent_course.Student_id=student.Student_idandstudent.Student_classid=class.Class_idandclass.Class_department='"+Tbx_area.Text+"'";
}
elseif
上一篇:
ASP_net002企业投资价值分析系统(论文和程序)
下一篇:
病理学实验课多样化教学方法探讨