Exemplo n.º 1
0
        /// <summary>
        /// 获得分页列表,无论是否是缓存实体都从数据库直接拿取数据
        /// </summary>
        /// <param name="pPageIndex">页数</param>
        /// <param name="pPageSize">每页列表</param>
        /// <param name="pOrderBy">排序</param>
        /// <param name="pSortExpression">排序字段</param>
        /// <param name="pRecordCount">列表行数</param>
        /// <returns>数据分页</returns>
        public static List<EmDangInfo> GetPagedList(int pPageIndex,int pPageSize,SortDirection pOrderBy,string pSortExpression,out int pRecordCount)
        {
            if(pPageIndex<=1)
            pPageIndex=1;
            List< EmDangInfo> list = new List< EmDangInfo>();

            Query q = EmDang .CreateQuery();
            q.PageIndex = pPageIndex;
            q.PageSize = pPageSize;
            q.ORDER_BY(pSortExpression,pOrderBy.ToString());
            EmDangCollection  collection=new  EmDangCollection();
             	collection.LoadAndCloseReader(q.ExecuteReader());

            foreach (EmDang  emDang  in collection)
            {
                EmDangInfo emDangInfo = new EmDangInfo();
                LoadFromDAL(emDangInfo,   emDang);
                list.Add(emDangInfo);
            }
            pRecordCount=q.GetRecordCount();

            return list;
        }
Exemplo n.º 2
0
 /// <summary>
 /// 获得数据列表
 /// </summary>
 /// <returns></returns>
 public static List<EmDangInfo> GetList()
 {
     string cacheKey = GetCacheKey();
     //本实体已经注册成缓存实体,并且缓存存在的时候,直接从缓存取
     if (CachedEntityCommander.IsTypeRegistered(typeof(EmDangInfo)) && CachedEntityCommander.GetCache(cacheKey) != null)
     {
         return CachedEntityCommander.GetCache(cacheKey) as List< EmDangInfo>;
     }
     else
     {
         List< EmDangInfo>  list =new List< EmDangInfo>();
         EmDangCollection  collection=new  EmDangCollection();
         Query qry = new Query(EmDang.Schema);
         collection.LoadAndCloseReader(qry.ExecuteReader());
         foreach(EmDang emDang in collection)
         {
             EmDangInfo emDangInfo= new EmDangInfo();
             LoadFromDAL(emDangInfo,emDang);
             list.Add(emDangInfo);
         }
       	//生成缓存
         if (CachedEntityCommander.IsTypeRegistered(typeof(EmDangInfo)))
         {
             CachedEntityCommander.SetCache(cacheKey, list);
         }
         return list;
     }
 }