public DbQueryResult GetRedPagerActivityRequest(RedPagerActivityQuery query)
{
StringBuilder builder = new StringBuilder();
if (!string.IsNullOrEmpty(query.Name))
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.AppendFormat(" Name LIKE '%{0}%'", DataHelper.CleanSearchString(query.Name));
}
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vshop_RedPagerActivity ", "RedPagerActivityId", (builder.Length > 0) ? builder.ToString() : null, "*"));
}
private void BindData()
{
RedPagerActivityQuery entity = new RedPagerActivityQuery {
Name = this.Name,
SortBy = "RedPagerActivityId",
SortOrder = SortAction.Desc
};
Globals.EntityCoding(entity, true);
entity.PageIndex = this.pager.PageIndex;
entity.PageSize = this.pager.PageSize;
DbQueryResult redPagerActivityRequest = RedPagerActivityBrower.GetRedPagerActivityRequest(entity);
this.rptList.DataSource = redPagerActivityRequest.Data;
this.rptList.DataBind();
this.pager.TotalRecords = redPagerActivityRequest.TotalRecords;
}
public static DbQueryResult GetRedPagerActivityRequest(RedPagerActivityQuery query)
{
return(new RedRedPagerActivityDao().GetRedPagerActivityRequest(query));
}
