/// <summary>
/// 绑定数据源
/// </summary>
private void bind()
{
int punishType = Convert.ToInt32(Request.QueryString["punishType"]);
string filter = "";
int min = 0;
int max = 0;
switch (punishType)
{
case 1:
min = 1;
max = 8;
filter += "truancy>=" + min + " and truancy<=" + max;
break;
case 2:
filter += "truancy=9";
break;
case 3:
min = 10;
max = 19;
filter += "truancy>=" + min + " and truancy<=" + max;
break;
case 4:
min = 20;
max = 29;
filter += "truancy>=" + min + " and truancy<=" + max;
break;
case 5:
min = 30;
max = 39;
filter += "truancy>=" + min + " and truancy<=" + max;
break;
case 6:
min = 40;
max = 49;
filter += "truancy>=" + min + " and truancy<=" + max;
break;
case 7:
filter += "truancy>=50";
break;
case 8:
filter += "truancy>=1";
break;
}
CommonBLL commBLL = new CommonBLL();
DataTable dt = PageUtil.getProcessedDataTable(commBLL.getStudentAttendStatistics(false), filter);
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();
}
/// <summary>
/// 绑定数据源
/// </summary>
private void bind()
{
string filter = "1=1 ";
filter += DropDownList_class.SelectedValue.Equals("全院") ? "" : " and className='" + DropDownList_class.SelectedValue + "'";
Label_className.Text = DropDownList_class.SelectedValue;
CommonBLL commBLL = new CommonBLL();
DataTable dt = PageUtil.getProcessedDataTable(commBLL.getStudentAttendStatistics(false), filter);
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();
}
