public static void SavaChange(AspNetPager CtrPagerIndex) { int totalPage = CtrPagerIndex.RecordCount % CtrPagerIndex.PageSize == 0 ? CtrPagerIndex.RecordCount / CtrPagerIndex.PageSize : CtrPagerIndex.RecordCount / CtrPagerIndex.PageSize + 1; totalPage = totalPage == 0 ? 1 : totalPage; CtrPagerIndex.CustomInfoHTML = "当前第" + CtrPagerIndex.CurrentPageIndex + "/" + totalPage + "页 共" + CtrPagerIndex.RecordCount + "条记录 每页" + CtrPagerIndex.PageSize + "条"; }
/// <summary> /// 绑定分页控件 /// </summary> /// <param name="recordCount"></param> /// <param name="pager"></param> /// <param name="pageSize"></param> /// <param name="pageIndex"></param> public static void PaginationInfo(int recordCount, AspNetPager pager, int pageSize, int pageIndex) { pager.RecordCount = recordCount; pager.AlwaysShow = true; pager.PageSize = pageSize; pager.PageIndexBoxType = PageIndexBoxType.DropDownList; pager.PageIndexBoxClass = "PageDropDown"; pager.PageIndexBoxStyle = "width:42px;margin:0"; pager.ShowBoxThreshold = 1; pager.CurrentPageIndex = pageIndex; //pager.HorizontalAlign = HorizontalAlign.Right; pager.UrlPaging = true; pager.ShowCustomInfoSection = ShowCustomInfoSection.Never; //pager.CustomInfoHTML = "当前第<b>%CurrentPageIndex%</b>/<b>%PageCount%</b>页 共<b>%RecordCount%</b>条记录 每页<b>%PageSize%</b>条 "; pager.CustomInfoHTML = " "; pager.CustomInfoClass = "PageCustomInfo"; pager.FirstLastButtonsStyle = "display:none"; pager.FirstPageText = "<i class=\"icon-step-backward\"></i>"; pager.LastPageText = "<i class=\"icon-step-forward\"></i>"; pager.NextPageText = "<i class=\"icon-double-angle-right\"></i>"; pager.PrevPageText = "<i class=\"icon-double-angle-left\"></i>"; pager.CssClass = "PagingClass"; pager.CurrentPageButtonClass = "CurrentPagingClass"; }
protected void getPager(object sender, EventArgs e) { AspNetPager g = (AspNetPager)sender; this.StoreGridView.DataSource = srv.GetAllBlogStorysSummaryOfUser(userId, anp.StartRecordIndex - 1, anp.PageSize); this.StoreGridView.DataBind(); }
public void Asp_Holiday(GridView gv, AspNetPager pager, UserEntity en) { SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@UserID", SqlDbType.VarChar, 50); param[0].Value = en.UserID; param[1] = new SqlParameter("@UserName", SqlDbType.VarChar, 50); param[1].Value = en.UserName; string comstr = "with UsersInfo as(select users.*,\r\n (\r\n select count(*) from UserHoliday where UserHoliday.UserID=users.UserID and UserHoliday.RecordState=1) as num,\r\n Row_Number() over(order by users.UserID) as row_number from users where 1=1"; string comstr2 = "select count(*) from users where 1=1 \t"; if (en.UserID != null && en.UserID != "") { comstr += " and UserID=@UserID"; comstr2 += " and UserID=@UserID"; } if (en.UserName != null && en.UserName != "") { comstr += " and UserName Like '%'+@UserName+'%'"; comstr2 += " and UserName Like '%'+@UserName+'%'"; } comstr += " )select * from UsersInfo where row_number>{0} and row_number<={1};"; comstr = string.Format(comstr, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize); DataBase db = new DataBase(); pager.RecordCount = Convert.ToInt32(db.ExecuteValue(comstr2, param)); gv.DataSource = db.GetDataTable(comstr, param); gv.DataBind(); }
public void Asp5(GridView gv, AspNetPager pager, ProjectPaperEntity en) { SqlParameter[] para = new SqlParameter[4]; para[0] = new SqlParameter("@PPID", SqlDbType.Int); para[0].Value = en.PPID; para[1] = new SqlParameter("@Name", SqlDbType.VarChar, 256); para[1].Value = en.Name; para[2] = new SqlParameter("@PTID", SqlDbType.Int); para[2].Value = en.PTID; para[3] = new SqlParameter("@ClientID", SqlDbType.VarChar, 256); para[3].Value = en.ClientID; string comstr = "with ProjectPaperInfo as \r\n(\r\n\tselect (case when State=2 then '已承接' else '未承接' end) as IsAccept,ProjectPaper.PPID,ProjectPaper.Name,ProjectPaper.FhdateTime,PTName,Row_Number() over(order by PPID ) as row_number from ProjectPaper,PaperType where 1=1 and PaperType.PTID=ProjectPaper.PTID and ClientID=@ClientID"; string comstr2 = "select count(*) from ProjectPaper where 1=1"; if (en.PPID != 0) { comstr += " and PPID = @PPID"; comstr2 += " and PPID = @PPID"; } if (en.Name != null) { comstr += " and Name Like '%'+@Name+'%'"; comstr2 += " and Name Like '%'+@Name+'%'"; } comstr += ") select * from ProjectPaperInfo where row_number>{0} and row_number<={1};"; comstr = string.Format(comstr, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize); pager.RecordCount = Convert.ToInt32(this.db.ExecuteValue(comstr2, para)); gv.DataSource = this.db.GetDataTable(comstr, para); gv.DataBind(); }
public void Asp(GridView gv, AspNetPager pager, DepartmentEntity en) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@DepartmentName", SqlDbType.VarChar, 100) }; param[0].Value = en.DepartmentName; DataBase db = new DataBase(); string comstr = "with DepartmentsInfo as\r\n(select *,Row_Number() over(order by DepartmentID) as row_number from Department\twhere 1=1"; // string comstr="with DepartmentsInfo as\r\n(select *,Row_Number() over(order by DepartmentID) as row_number from Department\twhere 1=1"; string comstr2 = "select count(*) from Department\twhere 1=1"; // string comstr2 = "select count(*) from Department\twhere 1=1"; if (en.DepartmentName != null && en.DepartmentName != "") { comstr += " and DepartmentName Like '%'+@DepartmentName+'%'"; comstr2 += " and DepartmentName Like '%'+@DepartmentName+'%'"; } comstr += " )select * from DepartmentsInfo where row_number>{0} and row_number<={1}"; comstr = string.Format(comstr, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize); pager.RecordCount = Convert.ToInt32(db.ExecuteValue(comstr2, param)); gv.DataSource = db.GetDataTable(comstr, param); gv.DataBind(); }
public void Asp2(DataList gv, AspNetPager pager, UserHolidayEntity mo) { DataBase db = new DataBase(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@UserID", SqlDbType.VarChar, 50); param[0].Value = mo.UserID; string comstr = "with UserHolidayInfo as\r\n (\r\n select UserHoliday.*,(case when RecordState=1 then '未读' when RecordState=2 then '已读,认同加分' else '已读,不认同加分' end ) as CheckState,Users.UserName as UserName,ChangDes,Row_Number() over(order by UserHolidayID) as row_number from Users,UserHoliday,UserIntegraDetail where UserHoliday.UserID=Users.UserID,Users.UserID=UserIntegraDetail.UserID"; // string comstr = "with WrongProblemInfo as\r\n (\r\n select WrongProblem.*,(case when RecordState=1 then '教师未读' when RecordState=2 then '教师已读,认同加分' else '教师已读,不认同加分' end ) as CheckState,Problems.ProblemName as ProblemName,Problems.ProblemDes as ProblemDes,Users.UserName as UserName,Row_Number() over(order by WrongProblemID) as row_number from Problems,Users,WrongProblem where WrongProblem.UserID=Users.UserID and WrongProblem.ProblemID=Problems.ProblemID"; string comstr2 = "select count(*) from Users,UserHoliday where UserHoliday.UserID=Users.UserID "; if (mo.UserID != null && mo.UserID != "") { comstr += " and UserHoliday.UserID=@UserID"; comstr2 += " and UserHoliday.UserID=@UserID"; } comstr += " )select * from UserHolidayInfo where row_number>{0} and row_number<={1}"; comstr = string.Format(comstr, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize); pager.RecordCount = Convert.ToInt32(db.ExecuteValue(comstr2, param)); gv.DataSource = db.GetDataTable(comstr, param); gv.DataBind(); }
public void Asp(GridView gv, AspNetPager pager, UserIntegralDetailEntity mo) { SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@DetailID", SqlDbType.Int); param[0].Value = mo.DetailID; param[1] = new SqlParameter("@UserID", SqlDbType.VarChar, 50); param[1].Value = mo.UserID; string comstr = "with IntegralInfo as\r\n (\r\n select ui.DetailID as DetailID,ui.UserID as UserID,ui.IntegralChange as IntegralChange,ui.ChangeDes as ChangeDes,us.UserName as UserName,Row_Number() over(order by DetailID) as row_number from UserIntegralDetail ui,Users us where ui.UserID=us.UserID"; string comstr2 = "select count(*) from UserIntegralDetail ui,Users us where ui.UserID=us.UserID"; if (mo.DetailID != 0) { comstr += " and ui.DetailID=@DetailID"; comstr2 += " and ui.DetailID=@DetailID"; } if (mo.UserID != null && mo.UserID != "") { comstr += " and ui.UserID=@UserID"; comstr2 += " and ui.UserID=@UserID"; } comstr += " ) select * from IntegralInfo where row_number>{0} and row_number<{1}"; comstr = string.Format(comstr, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize); DataBase db = new DataBase(); pager.RecordCount = Convert.ToInt32(db.ExecuteValue(comstr2, param)); gv.DataSource = db.GetDataTable(comstr, param); gv.DataBind(); }
protected void aspPager_PageChanged(object sender, EventArgs e) { AspNetPager asppage = sender as AspNetPager; if (asppage == null) { return; } switch (asppage.ID) { case "aspAllCusPager": V_CRM_STAFF_CUSTOMER conAllCus = new V_CRM_STAFF_CUSTOMER(); if (string.IsNullOrEmpty(hidAllCus.Value)) { conAllCus = JsonServiceBase.FromJson <V_CRM_STAFF_CUSTOMER>(hidAllCus.Value); } BindData(conAllCus, asppage.CurrentPageIndex, asppage); break; case "aspToDayMustConPager": V_CRM_STAFF_CUSTOMER_NOTCONTACT conToDayMustCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); if (string.IsNullOrEmpty(hidToDayMustCon.Value)) { conToDayMustCon = JsonServiceBase.FromJson <V_CRM_STAFF_CUSTOMER_NOTCONTACT>(hidToDayMustCon.Value); } BindData(conToDayMustCon, asppage.CurrentPageIndex, asppage); break; case "aspExpiredPager": V_CRM_STAFF_CUSTOMER_NOTCONTACT conExpired = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); if (string.IsNullOrEmpty(hidExpired.Value)) { conExpired = JsonServiceBase.FromJson <V_CRM_STAFF_CUSTOMER_NOTCONTACT>(hidExpired.Value); } BindData(conExpired, asppage.CurrentPageIndex, asppage); break; case "aspWillInHighSeasPager": V_CRM_STAFF_CUSTOMER_NOTCONTACT conWillInHighSeas = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); if (string.IsNullOrEmpty(hidWillInHighSeas.Value)) { conExpired = JsonServiceBase.FromJson <V_CRM_STAFF_CUSTOMER_NOTCONTACT>(hidWillInHighSeas.Value); } BindData(conWillInHighSeas, asppage.CurrentPageIndex, asppage); break; case "aspContractedPager": V_CRM_STAFF_CUSTOMER conContracted = new V_CRM_STAFF_CUSTOMER(); if (string.IsNullOrEmpty(hidContracted.Value)) { conContracted = JsonServiceBase.FromJson <V_CRM_STAFF_CUSTOMER>(hidContracted.Value); } BindData(conContracted, asppage.CurrentPageIndex, asppage); break; default: break; } }
public BindPagedList(Page page, AspNetPager pager, NBiz.BLLBase <T> bllBase, GridView gv, IList <T> list) { this.CurrentPage = page; this.pager = pager; this.bllBase = bllBase; this.gv = gv; // //TODO: 在此处添加构造函数逻辑 // }
public override string GetDesignTimeHtml() { this.wb = (AspNetPager)base.Component; this.wb.RecordCount = 0xe1; StringWriter writer = new StringWriter(); HtmlTextWriter writer2 = new HtmlTextWriter(writer); this.wb.RenderControl(writer2); return(writer.ToString()); }
public void Asp(GridView gv, AspNetPager pager) { string sql = "with AllWrongProblem as(select UserHolidayID,UserHolidayDes,ManagerBack,DateUp,UserID,Row_Number() over(order by UserHolidayID) as row_number from WrongProblem)select * from AllWrongProblem where row_number>{0} and row_number<={1}"; string sql2 = "select count(*) from WrongProblem"; sql = string.Format(sql, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize); pager.RecordCount = Convert.ToInt32(this.db.ExecuteValue(sql2)); gv.DataSource = this.db.GetDataTable(sql); gv.DataBind(); }
public void Asp(DataList gv, AspNetPager pager) { DataBase db = new DataBase(); string sql = @"with OrderTable as(select ItemID,ParentID,ItemName,ItemContent,ItemSort,ItemKind,ItemUrl,IsTop,IsHome,NewsSort,DisplayNum,DepartID,Row_Number() over(order by ItemID,ItemSort)as row_number from Item) select * from OrderTable where row_number>{0} and row_number<{1}"; string sql1 = "select count(*) from Item"; sql = string.Format(sql, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize); pager.RecordCount = Convert.ToInt32(db.ExecuteValue(sql1)); gv.DataSource = db.GetDataTable(sql); gv.DataBind(); }
public void Asp(GridView gv, AspNetPager pager) { DataBase db = new DataBase(); string comstr = "with PowersInfo as \r\n(\r\n\tselect *,Row_Number() over(order by PowerID ) as row_number from Powers \r\n)\r\nselect * from PowersInfo where row_number>{0} and row_number<={1}"; string comstr2 = "select count(*) from Powers"; comstr = string.Format(comstr, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize); pager.RecordCount = Convert.ToInt32(db.ExecuteValue(comstr2)); gv.DataSource = db.GetDataTable(comstr); gv.DataBind(); }
/// <summary> /// 分页 /// </summary> /// <param name="src"></param> /// <param name="e"></param> protected void anp_top_PageChanging(object src, PageChangingEventArgs e) { Control controlGrid = Page.FindControl("anp_top"); if (controlGrid != null) { AspNetPager Grid = (AspNetPager)controlGrid; Grid.CurrentPageIndex = e.NewPageIndex; BindGridView(); } }
/// <summary> /// 分页数据绑定(列表控件和数据控件) /// </summary> /// <param name="ctrl">绑定控件</param> /// <param name="source">数据源</param> /// <param name="pager">分页控件</param> public static void BindControl(Repeater ctrl, DataSet source, AspNetPager pager) { if (source.Tables.Count < 1) { return; } ctrl.DataSource = source.Tables[0]; ctrl.DataBind(); pager.RecordCount = Convert.ToInt32(source.Tables[1].Rows[0][0]); pager.SetRewriteUrl(); }
public void Asp(GridView gv, AspNetPager pager, ManagerEnitity en) { SqlParameter[] param = new SqlParameter[4]; param[0] = new SqlParameter("@ManagerID", SqlDbType.VarChar, 50); param[0].Value = en.ManagerID; param[1] = new SqlParameter("@DepartmentID", SqlDbType.Int, 4); param[1].Value = en.DepartmentID; param[2] = new SqlParameter("@PowerID", SqlDbType.Int, 4); param[2].Value = en.PowerID; param[3] = new SqlParameter("@ManagerName", SqlDbType.VarChar, 100); param[3].Value = en.ManagerName; /*row_number() over (order by '字段名')是 * 微软最新发布的MSSQL2005,对TSQL进行了小规模的加强 按照字段名进行排序,可以实现数据分页功能 * */ string comstr = "with ManagerInfo as\r\n(\r\nselect Manager.ManagerID,Manager.DepartmentID,Manager.PowerID,ManagerName,ManagerPwd,ManagerImage,ManagerDes\r\n ,Powers.PowerName,Department.DepartmentName\t,\r\nRow_Number() over(order by ManagerID) as row_number\tfrom Manager ,Powers,Department\r\nwhere\tManager.PowerID=powers.PowerID\tand Manager.DepartmentID=Department.DepartmentID"; // string comstr = "with ManagerInfo as\r\n(\r\nselect Manager.ManagerID,Manager.DepartmentID,Manager.PowerID,ManagerName,ManagerPwd,ManagerImage,ManagerDes\r\n,Powers.PowerName,Department.DepartmentName\t,\r\nRow_Number() over(order by ManagerID) as row_number\tfrom Manager,Powers,Department\r\nwhere\tManager.PowerID=powers.PowerID\tand Manager.DepartmentID=Department.DepartmentID)"; // string comstr2 = "select count(*) from Manager,Powers,Department\r\nwhere\tManager.PowerID=Powers.PowerID\t and Manager.DepartmentID=Department.DepartmentID"; string comstr2 = "select count(*)\tfrom Manager ,Powers,Department\r\nwhere\tManager.PowerID=Powers.PowerID\tand Manager.DepartmentID=Department.DepartmentID"; if (en.DepartmentID != 0) { comstr += " and Manager.DepartmentID=@DepartmentID"; comstr2 += " and Manager.DepartmentID=@DepartmentID"; } if (en.PowerID != 0) { comstr += " and Manager.PowerID=@PowerID"; comstr2 += " and Manager.PowerID=@PowerID"; } if (en.ManagerID != "" && en.ManagerID != null) { comstr += " and ManagerID=@ManagerID"; comstr2 += " and ManagerID=@ManagerID"; } if (en.ManagerName != "" && en.ManagerName != null) { comstr += " and ManagerName Like '%'+@ManagerName+'%'"; comstr2 += " and ManagerName Like '%'+ManagerName+'%'"; } comstr += " )select * from ManagerInfo where row_number>{0} and row_number<={1};"; comstr = string.Format(comstr, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize); DataBase db = new DataBase(); pager.RecordCount = Convert.ToInt32(db.ExecuteValue(comstr2, param)); gv.DataSource = db.GetDataTable(comstr, param); gv.DataBind(); }
public DataSet DsPager(string sql, AspNetPager pager) { open(); SqlCommand cmd = new SqlCommand(sql, con); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adapter.Fill(ds, pager.PageSize * (pager.CurrentPageIndex - 1), pager.PageSize, "Table"); return(ds); ds.Dispose(); close(); }
/// <summary> /// 设置分页控件 /// </summary> /// <param name="pager"></param> /// <returns></returns> public AspNetPager ResetPager(AspNetPager pager) { pager.CssClass = "pager"; pager.FirstPageText = "First"; pager.LastPageText = "Last"; pager.NextPageText = "Next"; pager.PrevPageText = "prev"; pager.AlwaysShow = true; pager.Wrap = false; pager.PageSize = FGA_NUtility.ConfigHelper.GetConfigInt("PageSize"); pager.SubmitButtonText = "To"; pager.ShowBoxThreshold = Int32.MaxValue; return(pager); }
/// <summary> /// 组织的GridView绑定 /// </summary> /// <param name="anpager"></param> /// <param name="strWhere"></param> /// <param name="strOrder"></param> /// <param name="grvControl"></param> public void GridViewPagerBind(AspNetPager anpager, string strWhere, string strOrder, GridView grvControl) { int iRowCount = 0; int row1 = (anpager.CurrentPageIndex - 1) * anpager.PageSize + 1; int row2 = anpager.CurrentPageIndex * anpager.PageSize; grvControl.DataSource = dal.GridViewData(strWhere, strOrder, row1, row2, ref iRowCount); grvControl.DataBind(); anpager.RecordCount = iRowCount; anpager.CustomInfoHTML = "共<font color=\"blue\"><b>" + anpager.RecordCount.ToString() + "</b></font>条记录"; anpager.CustomInfoHTML += " 共<font color=\"blue\"><b>" + anpager.PageCount.ToString() + "</b></font>页"; anpager.CustomInfoHTML += " 当前第<font color=\"red\"><b>" + anpager.CurrentPageIndex.ToString() + "</b></font>页"; }
/// <summary> /// 根据pager返回当前页码(索引从0开始) /// 分页控件采用post方式的时候一定要加onpagechanged事件 /// </summary> /// <param name="pager">分页控件</param> /// <returns></returns> public static int getPageIndex(AspNetPager pager) { int reval = 1; if (pager.UrlPaging) { reval = getPageIndex(); } else { reval = pager.CurrentPageIndex - 1; } return(reval); }
public void Asp(GridView gv, AspNetPager pager, UserHolidayEntity en) { SqlParameter[] p = new SqlParameter[] { new SqlParameter("@UserID", SqlDbType.VarChar, 50) }; p[0].Value = en.UserID; string sql = "with AllUserProblem as( select UserHolidayID,UserHolidayDes,ManagerBack,DateUp,Row_Number() over(order by UserHolidayID) as row_number from UserHoliday where UserID=@UserID ) select * from AllUserProblem where row_number>{0} and row_number<={1}"; string sql2 = "select count (*) from WrongProblem where UserID=@UserID"; sql = string.Format(sql, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize); pager.RecordCount = Convert.ToInt32(this.db.ExecuteValue(sql2, p)); gv.DataSource = this.db.GetDataTable(sql, p); gv.DataBind(); }
/// <summary> /// 绑定分页数据 /// </summary> /// <param name="dt">DataTable对象</param> /// <param name="anp">AspNetPager对象</param> public static void BindPageData(DataTable dt, Repeater rpt, AspNetPager AspNetPager1) { AspNetPager1.RecordCount = dt.Rows.Count; if (dt.Rows.Count >= 0) { PagedDataSource ps = new PagedDataSource(); DataView dv = new DataView(dt); ps.DataSource = dv; ps.AllowPaging = true; ps.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1; ps.PageSize = AspNetPager1.PageSize; rpt.DataSource = ps; rpt.DataBind(); } }
public void DsRep(string sql, AspNetPager pager) { open(); SqlDataAdapter adapter = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); adapter.Fill(ds, "Table"); pager.RecordCount = ds.Tables[0].Rows.Count; ds.Dispose(); close(); }
public void Asp(GridView gv, AspNetPager pager, RecordEntity en) { SqlParameter[] p = new SqlParameter[] { new SqlParameter("@PPID", SqlDbType.Int) }; p[0].Value = en.PpID; string sql = "with AllRecord as( select RecordID,PPIDD,PresentDate,Des,ProjectPaper.Name,Row_Number() over(order by RecordID) as row_number from Record,ProjectPaper where PPIDD=@PPID and PPID=PPIDD ) select * from AllRecord where row_number>{0} and row_number<={1}"; string sql2 = "select count (*) from Record where PPIDD=@PPID"; sql = string.Format(sql, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize); pager.RecordCount = Convert.ToInt32(this.db.ExecuteValue(sql2, p)); gv.DataSource = this.db.GetDataTable(sql, p); gv.DataBind(); }
/// <summary> /// 全部数据用AspNetPager分页绑定,Repeater,GridView,DataList /// </summary> /// <param name="ie">实现IEnumerable的数据源</param> /// <param name="ctl_Listctl">列表控件</param> /// <param name="AspNetPager1"></param> public static void BindCtrl(IEnumerable ie, Control ctl_Listctl, AspNetPager AspNetPager1) { PagedDataSource PDS = new PagedDataSource(); PDS.DataSource = ie; if (ie is DataTable) { AspNetPager1.RecordCount = ((DataTable)ie).Rows.Count; } if (ie is IList) { AspNetPager1.RecordCount = ((IList)ie).Count; } int cPageIndex = AspNetPager1.CurrentPageIndex; if (cPageIndex > 1) { PDS.CurrentPageIndex = cPageIndex - 1; } PDS.AllowPaging = true; PDS.PageSize = AspNetPager1.PageSize; if (ctl_Listctl is Repeater) { ((Repeater)ctl_Listctl).DataSource = PDS; ((Repeater)ctl_Listctl).DataBind(); } if (ctl_Listctl is DataList) { ((DataList)ctl_Listctl).DataSource = PDS; ((DataList)ctl_Listctl).DataBind(); } if (ctl_Listctl is GridView) { ((GridView)ctl_Listctl).DataSource = PDS; ((GridView)ctl_Listctl).DataBind(); } }
/// <summary> /// DataList分页 /// </summary> /// <param name="pager">AspNetPager控件ID</param> /// <param name="dt">DataTable</param> /// <param name="e">DataList</param> public static void BindAspNetPager(AspNetPager pager, DataTable dt, DataList e) { ((AspNetPager)pager).RecordCount = dt.Rows.Count; PagedDataSource pds = new PagedDataSource(); pds.DataSource = dt.DefaultView; pds.AllowPaging = true; pds.CurrentPageIndex = pager.CurrentPageIndex - 1; pds.PageSize = pager.PageSize; e.DataSource = pds; e.DataBind(); dt.Dispose(); dt = null; }
protected override void OnLoad(EventArgs e) { if (!IsPostBack) { Control controlGrid = Page.FindControl("anp_top"); if (controlGrid != null) { AspNetPager Grid = (AspNetPager)controlGrid; if (Grid.PageSize == 10) { Grid.PageSize = Convert.ToInt32(ConfigurationManager.AppSettings["PageSize"]); } } } base.OnLoad(e); }
public void DsLoad(string sql, AspNetPager pager, DataList datalist) { open(); SqlDataAdapter adapter = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); DataSet ds1 = new DataSet(); adapter.Fill(ds, "Table"); adapter.Fill(ds1, pager.PageSize * (pager.CurrentPageIndex - 1), pager.PageSize, "Table"); pager.RecordCount = ds.Tables[0].Rows.Count; datalist.DataSource = ds1.Tables[0].DefaultView; datalist.DataBind(); adapter.Dispose(); ds.Dispose(); ds1.Dispose(); close(); }
private void AddPager(Panel p) { pager = new AspNetPager(); pager.ID = "Pager"; pager.CssClass = "pager"; pager.UrlPaging = true; pager.PagingButtonType = PagingButtonType.Text; pager.NumericButtonType = PagingButtonType.Text; pager.NavigationButtonType = PagingButtonType.Text; pager.ShowNavigationToolTip = true; pager.ShowPageIndexBox = ShowPageIndexBox.Never; pager.ShowPageIndex = true; pager.AlwaysShowFirstLastPageNumber = true; pager.AlwaysShow = false; pager.UrlPageIndexName = "page"; p.Controls.Add(pager); }
private void BindData(ITableImplement con, int pageCur, AspNetPager asppager) { int recount = -1; asppager.PageSize = 20; switch (asppager.ID) { case "aspAllCusPager": case "aspContractedPager": V_CRM_STAFF_CUSTOMER vcrmscCon = con as V_CRM_STAFF_CUSTOMER; if (vcrmscCon == null) return; if (asppager.ID == "aspAllCusPager") hidAllCus.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER>(vcrmscCon); else hidContracted.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER>(vcrmscCon); vcrmscCon.af_PageBy(V_CRM_STAFF_CUSTOMER.Attribute.Cus_ID, Order.Desc); V_CRM_STAFF_CUSTOMER valsc = new V_CRM_STAFF_CUSTOMER(); valsc._SID = ""; valsc.Cus_ID = 0; valsc.CompanyName = ""; valsc.ShopName = ""; valsc.Cus_Name = ""; valsc.CustQQ = ""; valsc.WangWangId = ""; valsc.LastContactTime = DateTime.MinValue; valsc.SNAME = ""; valsc.CustStatus = 0; List<V_CRM_STAFF_CUSTOMER> vcrmscList = BLLTable<V_CRM_STAFF_CUSTOMER>.Factory(conn).SelectByPage(valsc, vcrmscCon, asppager.PageSize, pageCur, ref recount); if (vcrmscList.Count > 0) { FormHelper.Bind(Page, vcrmscList[0].DicAttrValues); //BindToFindSelect(listObj[0].DicAttrValues); } if (asppager.ID == "aspAllCusPager") { repAllCusList.DataSource = vcrmscList; repAllCusList.DataBind(); } else { lit_ContractedCusCount.Text = recount.ToString(); repContractedList.DataSource = vcrmscList; repContractedList.DataBind(); } asppager.RecordCount = recount; break; case "aspToDayMustConPager": case "aspExpiredPager": case "aspWillInHighSeasPager": V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscnCon = con as V_CRM_STAFF_CUSTOMER_NOTCONTACT; if (vcrmscnCon == null) return; if (asppager.ID == "aspToDayMustConPager") hidToDayMustCon.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon); else if (asppager.ID == "aspExpiredPager") hidExpired.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon); else hidWillInHighSeas.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon); vcrmscnCon.af_PageBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.Cus_ID, Order.Desc); V_CRM_STAFF_CUSTOMER_NOTCONTACT valscn = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); valscn.STAFF_ID = 0; valscn.Cus_ID = 0; valscn.CompanyName = ""; valscn.ShopName = ""; valscn.Cus_Name = ""; valscn.CustQQ = ""; valscn.WangWangId = ""; valscn.LastContactTime = DateTime.MinValue; valscn.NextContactTime = DateTime.MinValue; valscn.SNAME = ""; valscn.CustStatus = 0; List<V_CRM_STAFF_CUSTOMER_NOTCONTACT> vcrmscnList = BLLTable<V_CRM_STAFF_CUSTOMER_NOTCONTACT>.Factory(conn).SelectByPage(valscn, vcrmscnCon, asppager.PageSize, pageCur, ref recount); if (vcrmscnList.Count > 0) { FormHelper.Bind(Page, vcrmscnList[0].DicAttrValues); //BindToFindSelect(listObj[0].DicAttrValues); } if (asppager.ID == "aspToDayMustConPager") { lit_todayConCusCount.Text = recount.ToString(); repToDayMustConList.DataSource = vcrmscnList; repToDayMustConList.DataBind(); } else if (asppager.ID == "aspExpiredPager") { lit_ExpiredUnConCusCount.Text = recount.ToString(); repExpiredList.DataSource = vcrmscnList; repExpiredList.DataBind(); } else { lit_WillInHighSeasCusCount.Text = recount.ToString(); repWillInHighSeasList.DataSource = vcrmscnList; repWillInHighSeasList.DataBind(); } asppager.RecordCount = recount; break; default: break; } }