protected void BindTopicList() { TopicQuery page = new TopicQuery { PageIndex = this.pager.PageIndex, PageSize = this.pager.PageSize, SortBy = "DisplaySequence", SortOrder = SortAction.Asc }; DbQueryResult topicList = VShopHelper.GettopicList(page); this.rpTopic.DataSource = topicList.Data; this.rpTopic.DataBind(); this.pager.TotalRecords = topicList.TotalRecords; }
public DbQueryResult GetTopicList(TopicQuery page) { StringBuilder builder = new StringBuilder(); if (!(!page.IsRelease.HasValue ? true : !page.IsRelease.Value)) { builder.Append("IsRelease = 1"); } else if (!(!page.IsRelease.HasValue ? true : page.IsRelease.Value)) { builder.Append("IsRelease = 0"); } if (page.IsincludeHomeProduct.HasValue && !page.IsincludeHomeProduct.Value) { if (builder.Length > 0) { builder.Append(" and "); } builder.Append(" topicid not in (select topicid from Vshop_HomeTopics) "); } int num = 0x200; return DataHelper.PagingByRownumber(page.PageIndex, page.PageSize, page.SortBy, page.SortOrder, page.IsCount, "Vshop_Topics t", "TopicId", builder.ToString(), "*, (SELECT Keys FROM vshop_Reply WHERE [ReplyType] =" + num + " AND Activityid = t.TopicId) AS Keys"); }
public static DbQueryResult GettopicList(TopicQuery page) { return new TopicDao().GetTopicList(page); }