NHibernate---用criteria做分页出问题

来源：互联网发布：linux mint与ubuntu 编辑：程序博客网时间：2024/05/19 23:14

using CoVics.Framework.DataAccess;using IWOMTracker.Data.Model;using System.Collections.Generic;using NHibernate;using NHibernate.Criterion;using System;namespace IWOMTracker.Data.Dao{    public class OutStorageDataDao : AbstractNHibernateDao<OutStorageDataView, int>, IOutStorageDataDao    {        #region IOutStorageDataDao 成员        public IList<OutStorageDataView> GetItemList(int Brand_ID, int pageNo, int pageSize, out int TotalNumber)        {                                   IList<OutStorageDataView> List;            ICriteria critRecordCount = NHibernateSessionReader.CreateCriteria(typeof(OutStorageDataView));            //查询总数（未入数据）            TotalNumber = Convert.ToInt32(critRecordCount.SetProjection(Projections.Count("Item_ID")).UniqueResult());            //获得当前页的数据            ICriteria crit = NHibernateSessionReader.CreateCriteria(typeof(OutStorageDataView));            crit.Add(Restrictions.Eq("Brand_ID", Brand_ID));            crit.SetFirstResult((pageNo - 1) * pageSize)                            .SetMaxResults(pageSize);            List = crit.List<OutStorageDataView>();            return List;        }        #endregion    }}