/// <summary> /// 绑定数据源 /// </summary> private void bind() { string filter = "1=1 "; filter += DropDownList_class.SelectedValue.Equals("全部班级") ? "" : " and className='" + DropDownList_class.SelectedValue + "'"; filter += DropDownList_course.SelectedValue.Equals("全部课程") ? "" : " and courseName='" + DropDownList_course.SelectedValue + "'"; filter += DropDownList_teacher.SelectedValue.Equals("全部教师") ? "" : " and teacherName='" + DropDownList_teacher.SelectedValue + "'"; filter += DropDownList_week.SelectedValue.Equals("周次") ? "" : " and week='" + DropDownList_week.SelectedValue + "'"; filter += DropDownList_weekDay.SelectedValue.Equals("星期") ? "" : " and weekDay='" + DropDownList_weekDay.SelectedValue + "'"; filter += DropDownList_courseTime.SelectedValue.Equals("上课时间") ? "" : " and courseTime='" + DropDownList_courseTime.SelectedValue + "'"; string sort = ""; switch (RadioButtonList1.SelectedIndex) { case 0: if (RadioButtonList2.SelectedIndex == 0) sort += "className asc "; else sort += "className desc "; break; case 1: if (RadioButtonList2.SelectedIndex == 0) sort += "teacherName asc "; else sort += "teacherName desc "; break; case 2: if (RadioButtonList2.SelectedIndex == 0) sort += "week asc "; else sort += "week desc "; break; case 3: if (RadioButtonList2.SelectedIndex == 0) sort += "attendaceRate asc "; else sort += "attendaceRate desc "; break; } CommonBLL commBLL = new CommonBLL(); DataTable dt = PageUtil.getProcessedDataTable(commBLL.getAttendaceRate(true), filter, sort); AspNetPager1.RecordCount = dt.Rows.Count; int from = (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize + 1; int to = from + AspNetPager1.PageSize - 1 > AspNetPager1.RecordCount ? AspNetPager1.RecordCount : from + AspNetPager1.PageSize - 1; GridView1.DataSource = PageUtil.getPaged(dt, from, to); GridView1.DataBind(); }