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