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