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