/// <summary> /// 博客列表 /// </summary> /// <param name="searchSetting"></param> /// <returns></returns> public static IPageOfList<BlogPostInfo> List(BlogSearchSetting searchSetting) { FastPaging fp = new FastPaging(); fp.OverOrderBy = " BP.CreateDateTime DESC"; fp.PageIndex = searchSetting.PageIndex; fp.PageSize = searchSetting.PageSize; fp.QueryFields = "*"; fp.TableName = "BlogPosts"; fp.PrimaryKey = "Id"; fp.TableReName = "BP"; fp.WithOptions = " WITH(NOLOCK)"; StringBuilder sbCondition = new StringBuilder(); sbCondition.Append(" IsDeleted = 0 "); if(searchSetting.UserId >0){ sbCondition.AppendFormat(" AND UserId = {0}",searchSetting.UserId); } if(searchSetting.SystemCategoryId >0){ sbCondition.AppendFormat(" AND SystemCategoryId = {0}",searchSetting.SystemCategoryId); } fp.Condition = sbCondition.ToString(); IList<BlogPostInfo> list = new List<BlogPostInfo>(); BlogPostInfo model = null; DataTable dt = SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005()); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { model = GetByDataRow(dr); if (model != null) { list.Add(model); } } } int count = Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, fp.BuildCountSQL())); return new PageOfList<BlogPostInfo>(list, searchSetting.PageIndex, searchSetting.PageSize, count); }
/// <summary> /// 博客列表 /// </summary> /// <param name="searchSetting"></param> /// <returns></returns> public static IPageOfList<BlogPostInfo> List(BlogSearchSetting searchSetting) { return BlogPostManage.List(searchSetting); }