/// <summary>
/// 查询推文列表
/// </summary>
/// <param name="filter">过滤条件</param>
/// <returns>返回推文列表</returns>
public static QueryResult <ArticleEntity> SearchPageList(QF_Article filter)
{
var cmd = new DataCommand("Article.SearchPageList");
cmd.QuerySetCondition("title", ConditionOperation.Like, DbType.String, filter.Title);
cmd.QuerySetCondition("is_delete", ConditionOperation.Equal, DbType.Int32, (int)DeletedEnums.Actived);
if (filter.StartTime.HasValue)
{
cmd.QuerySetCondition("create_time", ConditionOperation.MoreThanEqual, DbType.DateTime, filter.StartTime);
}
if (filter.EndTime.HasValue)
{
cmd.QuerySetCondition("create_time", ConditionOperation.LessThan, DbType.DateTime, filter.EndTime.Value.AddDays(1));
}
cmd.CommandText = cmd.CommandText.Replace("#STRWHERE#", cmd.QueryConditionString);
return(cmd.Query <ArticleEntity>(filter, "create_time DESC", null, true));
}
/// <summary>
/// 查询推文列表
/// </summary>
/// <param name="filter">过滤条件</param>
/// <returns>返回推文列表</returns>
public QueryResult <ArticleVO> SearchPageList(QF_Article filter)
{
return(ArticleDA.SearchPageList(filter).ToArticleVOPageList());
}
public JsonResult Query()
{
QF_Article filter = BuildQueryFilterEntity <QF_Article>();
return(AjaxGridJson(ArticleBasisService.SearchPageList(filter)));
}