protected void BindData() { int pageIndex = GetUrlInt("p"); if (pageIndex <= 0) { pageIndex = 1; } WebPager pager = SiteSetting.CreateWebPagerForGridView(gvData, pageIndex); pager.PageCSSName = "NotShowPage"; pager.PageSize = 10000; WebQuery query = new WebQuery(); query.Fields = OrderDetailInfo.AllFields; query.OrderBy = "ID"; query.PrimaryKey = OrderDetailInfo.TablePrimaryKey; query.SqlCreateType = ControlSqlCreateType.RowNum; query.TableName = OrderDetailInfo.TableOrViewName; query.Condition = "AddMemberName='" + CurrentMember.UserName + "' And OrderNum='" + OrderNum + "'"; gvData.Db = TMS.Db.Helper; gvData.Query = query; gvData.CreateDataSource(); gvData.DataBind(); }
public static WebPagerItemCollection CreatePagerItems(WebPager pager) { // pager.SetPagerProperties(string.Empty); WebPagerItemCollection Pages = new WebPagerItemCollection( pager.TotalRecords, pager.PageSize, pager.PageIndex); pager.TotalPages = Pages.PageCount; return(Pages); }
/// <summary> /// 生成分页对象,并绑定到对应的GridView实例 /// </summary> /// <param name="gvData"></param> /// <param name="pageIndex"></param> /// <returns></returns> public static WebPager CreateWebPagerForGridView(GridView gvData, int pageIndex) { WebPager pager = new WebPager(); pager.ButtonCount = PageButtonCount; pager.PageSize = PageSize; pager.PageStyle = ControlPageStyle.Full; pager.PageCSSName = "gvPage"; pager.PageIndex = pageIndex; gvData.Pager = pager; return(pager); }
protected void BindData() { string condition = "LineID=" + MyLine.ID; WebPager pager = AdminSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex); //不分页 pager.PageSize = 1000; WebQuery query = new WebQuery(); query.Ascending = false; query.Fields = LineDetailInfo.AllFields; query.OrderBy = "SortOrder asc"; query.PrimaryKey = LineDetailInfo.TablePrimaryKey; query.SqlCreateType = ControlSqlCreateType.RowNum; query.TableName = LineDetailInfo.TableOrViewName; query.Condition = condition; gvData.Db = TMS.Db.Helper; gvData.Query = query; gvData.CreateDataSource(); gvData.DataBind(); }
/// <summary> /// ajax pagination /// </summary> /// <typeparam name="T"></typeparam> /// <param name="html"></param> /// <param name="pager"></param> /// <param name="option"></param> /// <returns></returns> public static String AjaxPagination <T>(this HtmlHelper html, WebPager <T> pager, AjaxPaginationOption option) { var param = html.ViewContext.HttpContext.Request.Form; // merge data of ajax pagination option and request var data = new RouteValueDictionary(option.Data); if (option.AutoLoadParam == true) { foreach (var key in param.AllKeys) { if (key != null && !data.ContainsKey(key)) { data.Add(key, param[key]); } } } var dataObj = Json.Decode <Object>(Json.EncodeDictionary(data)); // autload htmlID var HtmlID = option.HtmlID; if (option.AutoLoadHtmlID == true && param["HtmlID"] != null) { HtmlID = param["HtmlID"]; } var url = Javascript.addParamToURL(option.URL, "page", WebPager <T> .PageValue); string hiddenRefresh = html.ButtonToRemote(WebPager <T> .PageName, "cmdRefresh", new RemoteOption { URL = url, Update = HtmlID, Data = dataObj }, new { style = "display:none" }).Replace(WebPager <T> .PageValue, pager.GetPage().ToString()); if (!pager.HaveToPagination()) { return(hiddenRefresh); } var ret = new List <String>(); var linkPattern = html.LinkToRemote(WebPager <T> .PageName, new RemoteOption { URL = url, Update = HtmlID, Data = dataObj }); var linkPagePattern = linkPattern.Replace(WebPager <T> .PageName, WebPager <T> .PageValue); pager.LinkPattern = linkPagePattern; pager.CurrentLinkPattern = "<b>" + WebPager <T> .PageValue + "</b>"; // first page if (pager.GetPage() != pager.GetFirstPage()) { ret.Add(linkPattern.Replace(WebPager <T> .PageName, "First").Replace(WebPager <T> .PageValue, pager.GetFirstPage().ToString())); } // previous page if (pager.GetPreviousPage() > 0) { ret.Add(linkPattern.Replace(WebPager <T> .PageName, "Previous").Replace(WebPager <T> .PageValue, pager.GetPreviousPage().ToString())); } // pages foreach (var link in pager.GetLinks()) { ret.Add(link); } // next page if (pager.GetNextPage() > 0) { ret.Add(linkPattern.Replace(WebPager <T> .PageName, "Next").Replace(WebPager <T> .PageValue, pager.GetNextPage().ToString())); } // last page if (pager.GetPage() != pager.GetLastPage()) { ret.Add(linkPattern.Replace(WebPager <T> .PageName, "Last").Replace(WebPager <T> .PageValue, pager.GetLastPage().ToString())); } return(String.Join(" ", ret.ToArray()) + hiddenRefresh); }
/// <summary> /// show web pager /// </summary> /// <typeparam name="T"></typeparam> /// <param name="html"></param> /// <param name="pager"></param> /// <param name="columns"></param> /// <param name="option"></param> /// <returns></returns> public static String ShowWebPager <T>(this HtmlHelper html, WebPager <T> pager, Object[] columns, AjaxPaginationOption option) { return(ListData(html, pager, columns) + AjaxPagination(html, pager, option)); }
protected void Ex() { WebPager wb = new WebPager(); wb.Show(); }