public DbQueryResult GetCashBackDetailsByPager(CashBackDetailsQuery query)
{
string selectFields = "*";
string table = "Hishop_CashBackDetails hcd";
string pk = "CashBackDetailsId";
string filter = " 1=1 ";
filter = filter + string.Format(" AND CashBackId={0}", query.CashBackId);
query.SortOrder = SortAction.Desc;
query.SortBy = "CashBackDetailsId";
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, table, pk, filter, selectFields));
}
private void BindCashBackDetails()
{
CashBackDetailsQuery query = new CashBackDetailsQuery {
CashBackId = int.Parse(base.Request.QueryString["CashBackId"]),
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
SortBy = "CashBackDetailsId",
SortOrder = SortAction.Desc
};
DbQueryResult cashBackDetailsByPager = CashBackHelper.GetCashBackDetailsByPager(query);
this.rptList.DataSource = cashBackDetailsByPager.Data;
this.rptList.DataBind();
this.pager.TotalRecords = cashBackDetailsByPager.TotalRecords;
}
public static DbQueryResult GetCashBackDetailsByPager(CashBackDetailsQuery query)
{
return(new CashBackDao().GetCashBackDetailsByPager(query));
}
