Ejemplo n.º 1
0
        public void AddPage(Type t, String condition, ObjectPage pager, IList list)
        {
            String key = CacheKey.getPageList(t, condition, pager.getSize(), pager.getCurrent());

            addList(key, list);
            addToApplication(CacheKey.getPagerInfoKey(key), pager);     // 添加分页统计数据
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 根据查询条件、每页数量,返回分页数据集合
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="condition">查询条件</param>
        /// <param name="pageSize">每页需要显示的数据量</param>
        /// <returns>分页数据列表,包括当前页、总记录数、分页条等</returns>
        public static DataPage <T> findPage <T>(String condition, int pageSize) where T : IEntity
        {
            if (pageSize <= 0)
            {
                pageSize = 20;
            }

            ObjectInfo state = new ObjectInfo(typeof(T));

            state.includeAll();
            state.Pager.setSize(pageSize);

            IPageList result = ObjectPool.FindPage(typeof(T), condition, state.Pager);

            if (result == null)
            {
                IList      list = ObjectDB.FindPage(state, condition);
                ObjectPage p    = state.Pager;
                ObjectPool.AddPage(typeof(T), condition, p, list);

                result             = new PageList();
                result.Results     = list;
                result.PageCount   = p.PageCount;
                result.RecordCount = p.RecordCount;
                result.Size        = p.getSize();
                result.PageBar     = p.PageBar;
                result.Current     = p.getCurrent();
            }
            else
            {
                result.PageBar = new ObjectPage(result.RecordCount, result.Size, result.Current).PageBar;
            }

            return(new DataPage <T>(result));
        }
Ejemplo n.º 3
0
        public IPageList FindPage(Type t, String condition, ObjectPage pager)
        {
            String key = CacheKey.getPageList(t, condition, pager.getSize(), pager.getCurrent());

            logger.Debug("FindPage=>" + t.FullName);
            IList list = getListFromCache(key, t);

            if (list == null)
            {
                return(null);
            }

            IPageList result = new PageList();

            ObjectPage pageInfo = getPagerInfo(key);

            if (pageInfo == null)
            {
                return(null);
            }

            result.Results     = list;
            result.PageCount   = pageInfo.PageCount;
            result.RecordCount = pageInfo.RecordCount;
            result.Size        = pageInfo.getSize();
            result.PageBar     = pageInfo.PageBar;
            result.Current     = pageInfo.getCurrent();

            return(result);
        }
Ejemplo n.º 4
0
        public int beginCount( String countSql, ObjectPage pager, EntityInfo entityInfo ) {

            String commandText = countSql;
            logger.Info( "[Page Record Count] " + commandText );
            IDbCommand command = DataFactory.GetCommand( commandText, DbContext.getConnection( entityInfo ) );
            pager.RecordCount = cvt.ToInt( command.ExecuteScalar() );
            pager.computePageCount();
            pager.resetCurrent();

            return pager.getCurrent();
        }
Ejemplo n.º 5
0
        public int beginCount(String countSql, ObjectPage pager, EntityInfo entityInfo)
        {
            String commandText = countSql;

            logger.Info("[Page Record Count] " + commandText);
            IDbCommand command = DataFactory.GetCommand(commandText, DbContext.getConnection(entityInfo));

            pager.RecordCount = cvt.ToInt(command.ExecuteScalar());
            pager.computePageCount();
            pager.resetCurrent();

            return(pager.getCurrent());
        }
Ejemplo n.º 6
0
        public static DataPage <T> GetPage(List <T> list, int pageSize, int pageIndex = 0)
        {
            ObjectPage op = new ObjectPage();

            if (pageSize <= 0)
            {
                pageSize = 20;
            }
            op.setSize(pageSize);
            op.RecordCount = list.Count;
            // 计算页数
            op.computePageCount();

            // 矫正当前页码
            int currentPageNumber = CurrentRequest.getCurrentPage();

            if (pageIndex > 0)
            {
                currentPageNumber = pageIndex;
            }
            op.setCurrent(currentPageNumber);
            op.resetCurrent();
            currentPageNumber = op.getCurrent();

            // 得到结果集
            List <T> results = new List <T>();
            int      start   = (currentPageNumber - 1) * pageSize;
            int      count   = 1;

            for (int i = start; i < list.Count; i++)
            {
                if (count > pageSize)
                {
                    break;
                }
                results.Add(list[i]);
                count++;
            }

            // 填充分页数据
            DataPage <T> page = new DataPage <T>();

            page.Results     = results;
            page.Current     = currentPageNumber;
            page.Size        = pageSize;
            page.RecordCount = list.Count;

            page.PageCount = op.PageCount;

            return(page);
        }
Ejemplo n.º 7
0
 public void AddPage( Type t, String condition, ObjectPage pager, IList list )
 {
     String key = CacheKey.getPageList( t, condition, pager.getSize(), pager.getCurrent() );
     addList( key, list );
     addToApplication( CacheKey.getPagerInfoKey( key ), pager ); // 添加分页统计数据
 }
Ejemplo n.º 8
0
        public IPageList FindPage( Type t, String condition, ObjectPage pager )
        {
            String key = CacheKey.getPageList( t, condition, pager.getSize(), pager.getCurrent() );
            logger.Debug( "FindPage=>" + t.FullName );
            IList list = getListFromCache( key, t );
            if (list == null) return null;

            IPageList result = new PageList();

            ObjectPage pageInfo = getPagerInfo( key );
            if (pageInfo == null) return null;

            result.Results = list;
            result.PageCount = pageInfo.PageCount;
            result.RecordCount = pageInfo.RecordCount;
            result.Size = pageInfo.getSize();
            result.PageBar = pageInfo.PageBar;
            result.Current = pageInfo.getCurrent();

            return result;
        }
Ejemplo n.º 9
0
        public void AddPage(Type t, String condition, ObjectPage pager, IList list)
        {
            String key = CacheKey.getPageList(t, condition, pager.getSize(), pager.getCurrent());

            addList(key, list);
        }
Ejemplo n.º 10
0
 public void AddPage( Type t, String condition, ObjectPage pager, IList list )
 {
     String key = CacheKey.getPageList( t, condition, pager.getSize(), pager.getCurrent() );
     addList( key, list );
 }