?? grade_manage.aspx.cs
字號:
// 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();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -