protected void xsPage_PageChanged(object sender, xsFramework.UserControl.Pager.PageChangedEventArgs e)
{
PagerParameter pagepara = new PagerParameter();
pagepara.DbConn = GlabalString.DBString;
pagepara.XsPager = xsPage;
pagepara.Sql = pageLogic.QueryGroup();
pagepara.OrderBy = "group_id";
gvGroup.DataSource = xsPageHelper.BindPager(pagepara, e);
gvGroup.DataBind();
}
/// <summary>
/// 设置翻页
/// </summary>
/// <param name="gotoPage"></param>
protected virtual void OnPageChanged(int gotoPage)
{
PageChangedEventArgs e = new PageChangedEventArgs(gotoPage);
if (this.PageChanged != null)
{
PageChanged(this, e);
CurrentPage = gotoPage;
if (TotalPage < CurrentPage)
{ //删除的特殊情况
OnPageChanged(TotalPage);
}
}
}
protected void xsPage_PageChanged(object sender, xsFramework.UserControl.Pager.PageChangedEventArgs e)
{
PagerParameter pagepara = new PagerParameter();
pagepara.DbConn = GlabalString.DBString;
pagepara.XsPager = xsPage;
pagepara.Sql = pageLogic.QueryProducts(ddlType.SelectedValue, txtName.Text);
pagepara.OrderBy = "product_id";
DataTable dt = xsPageHelper.BindPager(pagepara, e);
Nodata.Visible = false;
if (dt.Rows.Count == 0)
{
Nodata.Visible = true;
}
rptProduct.DataSource = dt;
rptProduct.DataBind();
}
public static DataTable BindPager(PagerParameter pagePara, PageChangedEventArgs e)
{
#region datasafe
if (pagePara.OrderBy.Length == 0)
{
throw new Exception(" must set groupby!");
}
#endregion
//data sum count
string strCount = "select Count(*) from (" + pagePara.Sql + ")T";
xsSqlParameter sqlpara = new xsSqlParameter();
sqlpara.SQL = strCount;
sqlpara.SqlConnectString = pagePara.DbConn;
DataTable dtCount = SqlHelper.GetDataTable(sqlpara);
int DataCount = Convert.ToInt32(dtCount.Rows[0][0]);
pagePara.XsPager.TotalCount = DataCount;//set total count
if (DataCount <= 0)
{
return(new DataTable());
}
int pageSize = pagePara.XsPager.PageSize;
pageSize = pageSize <= 0 ? 10 : pageSize;
StringBuilder sbPageSql = new StringBuilder();
sbPageSql.Append("SELECT * FROM(");
sbPageSql.Append("SELECT *,ROW_NUMBER() OVER(ORDER BY " + pagePara.OrderBy + ") PID FROM (");
sbPageSql.Append(pagePara.Sql);
sbPageSql.Append(")Tsql )T WHERE PID between ");
sbPageSql.Append(((e.CurrentPage - 1) * pageSize + 1).ToString());
sbPageSql.Append(" AND ");
sbPageSql.Append((e.CurrentPage - 1) * pageSize + pageSize);
sqlpara.SQL = sbPageSql.ToString();
return(SqlHelper.GetDataTable(sqlpara));
}
protected void xsPage_PageChanged(object sender, xsFramework.UserControl.Pager.PageChangedEventArgs e)
{
PagerParameter pagepara = new PagerParameter();
pagepara.DbConn = GlabalString.DBString;
pagepara.XsPager = xsPage;
pagepara.Sql = pageLogic.QueryLeave();
pagepara.OrderBy = "leave_time";
DataTable dt = xsPageHelper.BindPager(pagepara, e);
NoData.Visible = false;
if (dt.Rows.Count == 0)
{
NoData.Visible = true;
}
else
{
rptLeave.DataSource = dt;
rptLeave.DataBind();
}
}