private void BindSearch()
{
ArticleQuery articleQuery = new ArticleQuery();
articleQuery.StartArticleTime = this.startArticleTime;
articleQuery.EndArticleTime = this.endArticleTime;
articleQuery.Keywords = Globals.HtmlEncode(this.keywords);
articleQuery.CategoryId = this.categoryId;
articleQuery.PageIndex = this.pager.PageIndex;
articleQuery.PageSize = this.pager.PageSize;
articleQuery.SortBy = this.grdArticleList.SortOrderBy;
articleQuery.SortOrder = SortAction.Desc;
DbQueryResult articleList = SubsiteCommentsHelper.GetArticleList(articleQuery);
this.grdArticleList.DataSource = articleList.Data;
this.grdArticleList.DataBind();
this.pager.TotalRecords = articleList.TotalRecords;
this.pager1.TotalRecords = articleList.TotalRecords;
}
private void BindSearch()
{
ArticleQuery articleQuery = new ArticleQuery();
articleQuery.StartArticleTime = startArticleTime;
articleQuery.EndArticleTime = endArticleTime;
articleQuery.Keywords = Globals.HtmlEncode(keywords);
articleQuery.CategoryId = categoryId;
articleQuery.PageIndex = pager.PageIndex;
articleQuery.PageSize = pager.PageSize;
articleQuery.SortBy = grdArticleList.SortOrderBy;
articleQuery.SortOrder = SortAction.Desc;
DbQueryResult articleList = ArticleHelper.GetArticleList(articleQuery);
grdArticleList.DataSource = articleList.Data;
grdArticleList.DataBind();
pager.TotalRecords = articleList.TotalRecords;
pager1.TotalRecords = articleList.TotalRecords;
}
void BindList()
{
ArticleQuery articleQuery = new ArticleQuery();
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["CategoryId"]))
{
int result = 0;
if (int.TryParse(this.Page.Request.QueryString["CategoryId"], out result))
{
articleQuery.CategoryId = new int?(result);
}
}
articleQuery.PageIndex = this.pager.PageIndex;
articleQuery.SortBy = "AddedDate";
articleQuery.SortOrder = SortAction.Desc;
DbQueryResult articleList = CommentBrowser.GetArticleList(articleQuery);
this.rptArticles.DataSource = articleList.Data;
this.rptArticles.DataBind();
this.pager.TotalRecords = articleList.TotalRecords;
}
public static DbQueryResult GetArticleList(ArticleQuery articleQuery)
{
return CommentProvider.Instance().GetArticleList(articleQuery);
}
public override DbQueryResult GetArticleList(ArticleQuery articleQuery)
{
StringBuilder builder = new StringBuilder();
builder.AppendFormat("Title LIKE '%{0}%'", DataHelper.CleanSearchString(articleQuery.Keywords));
if (articleQuery.CategoryId.HasValue)
{
builder.AppendFormat(" AND CategoryId = {0}", articleQuery.CategoryId.Value);
}
if (articleQuery.StartArticleTime.HasValue)
{
builder.AppendFormat(" AND AddedDate >= '{0}'", articleQuery.StartArticleTime.Value);
}
if (articleQuery.EndArticleTime.HasValue)
{
builder.AppendFormat(" AND AddedDate <= '{0}'", articleQuery.EndArticleTime.Value);
}
return DataHelper.PagingByRownumber(articleQuery.PageIndex, articleQuery.PageSize, articleQuery.SortBy, articleQuery.SortOrder, articleQuery.IsCount, "vw_Hishop_Articles", "ArticleId", builder.ToString(), "*");
}
public abstract DbQueryResult GetArticleList(ArticleQuery articleQuery);
public override DbQueryResult GetArticleList(ArticleQuery articleQuery)
{
StringBuilder builder = new StringBuilder();
builder.Append(" IsRelease=1 ");
if (!string.IsNullOrEmpty(articleQuery.Keywords))
{
builder.AppendFormat(" AND Title LIKE '%{0}%'", articleQuery.Keywords);
}
if (articleQuery.CategoryId.HasValue)
{
builder.AppendFormat(" AND CategoryId = {0}", articleQuery.CategoryId.Value);
}
if (articleQuery.StartArticleTime.HasValue)
{
builder.AppendFormat(" AND AddedDate >= '{0}'", articleQuery.StartArticleTime.Value);
}
if (articleQuery.EndArticleTime.HasValue)
{
builder.AppendFormat(" AND AddedDate <= '{0}'", articleQuery.EndArticleTime.Value);
}
builder.AppendFormat(" AND DistributorUserId = {0} ", HiContext.Current.SiteSettings.UserId.Value);
return DataHelper.PagingByRownumber(articleQuery.PageIndex, articleQuery.PageSize, articleQuery.SortBy, articleQuery.SortOrder, articleQuery.IsCount, "vw_distro_Articles", "ArticleId", builder.ToString(), "*");
}
