Castle.ActiveRecord分页示例

Castle.ActiveRecord的分页示例：

分页结果泛型类：

 1namespace EasyNet.Core
 2{
 3    /**//// <summary>
 4    /// 分页结果
 5    /// </summary>
 6    /// <typeparam name="T"></typeparam>
 7    public class PagedResult<T>
 8    {
 9        /**//// <summary>
        /// 记录总数
        /// </summary>
        public int Total { get; set; }

        /**//// <summary>
        /// 结果数据
        /// </summary>
        public T Data { get; set; }
    }
}

 

文章分类（典型树形结构）：

 1namespace EasyNet.Model
 2{
 3    using System.Collections.Generic;
 4
 5    using NHibernate.Criterion;
 6
 7    using Castle.ActiveRecord;
 8    
 9    [ActiveRecord("site_articlecategory")]
    public class ArticleCategory : ActiveRecordBase<ArticleCategory>
    {
        [PrimaryKey(PrimaryKeyType.Native)]
        public int Id { get; set; }

        [Property]
        public string Name { get; set; }

        [Property]
        public bool ShowInDefault { get; set; }

        [BelongsTo("ParentId")]
        public ArticleCategory Parent { get; set; }

        [HasMany(typeof(ArticleCategory), "ParentID", "site_articlecategory", Cascade = ManyRelationCascadeEnum.All)]
        public IList<ArticleCategory> Children { get; set; }

        [Newtonsoft.Json.JsonIgnore]
        [HasAndBelongsToMany(Table = "site_articleinarticlecategory", ColumnRef = "ArticleId", ColumnKey = "CategoryId", Lazy = true)]
        public IList<Article> Articles { get; set; }

    }
}

文章实体（定义了一个根据文章分类分页查询，文章与文章分类是多对多的关系）：

 1namespace EasyNet.Model
 2{
 3    using System.Collections.Generic;
 4
 5    using NHibernate.Criterion;
 6
 7    using Castle.ActiveRecord;
 8    using Castle.ActiveRecord.Queries;
 9
    using Core;

    [ActiveRecord("site_article")]
    public class Article : ActiveRecordBase<Article>
    {
        [PrimaryKey(PrimaryKeyType.Native)]
        public int Id { get; set; }

        [Property]
        public string Title { get; set; }

        [Property]
        public string Content { get; set; }

        [Property]
        public string Summary { get; set; }

        [Property]
        public string Author { get; set; }

        [Property]
        public bool IsNewsPhotos { get; set; }

        [Property]
        public string PhotoUrl { get; set; }

        [BelongsTo("TemplateId")]
        public ArticleTemplate Template { get; set; }

        [BelongsTo("CreatorId")]
        public User Creator { get; set; }

        [BelongsTo("ModifierId")]
        public User Modifier { get; set; }

        [Property]
        public bool Published { get; set; }

        [Property]
        public bool Deleted { get; set; }

        [Property]
        public long CreatedDatetime { get; set; }

        [Property]
        public long UpdatedDatetime { get; set; }

        [Newtonsoft.Json.JsonIgnore]
        [HasAndBelongsToMany(Table = "site_articleinarticlecategory", ColumnRef = "CategoryId", ColumnKey = "ArticleId", Lazy = true)]
        public IList<ArticleCategory> Categories { get; set; }

        public static PagedResult<Article[]> FindByCategory(int categoryId, int start, int limit)
        {
            CountQuery countQuery = new CountQuery(typeof(Article));

            countQuery.SetParameter("Id", categoryId);

            countQuery.Query = "select count(*) from Article as article left join article.Categories as category where category.Id in(:Id)";

            int total = (int)ExecuteQuery(countQuery);

            if (total == 0)
            {
                return null;
            }

            SimpleQuery<Article> query = new SimpleQuery<Article>("select article from Article as article left join article.Categories as category where category.Id in(:Id)");

            query.SetParameter("Id", categoryId);
            query.SetQueryRange(start, limit);

            Article[] articles = query.Execute();

            PagedResult<Article[]> result = new PagedResult<Article[]>();

            result.Data = articles;
            result.Total = total;

            return result;
        }
    }
}