/// <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();
}
