コード例 #1
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        /// <returns></returns>
        public static List <ProjectStepInfo> GetList()
        {
            string cacheKey = GetCacheKey();

            //本实体已经注册成缓存实体,并且缓存存在的时候,直接从缓存取
            if (CachedEntityCommander.IsTypeRegistered(typeof(ProjectStepInfo)) && CachedEntityCommander.GetCache(cacheKey) != null)
            {
                return(CachedEntityCommander.GetCache(cacheKey) as List <ProjectStepInfo>);
            }
            else
            {
                List <ProjectStepInfo> list       = new List <ProjectStepInfo>();
                ProjectStepCollection  collection = new  ProjectStepCollection();
                Query qry = new Query(ProjectStep.Schema);
                collection.LoadAndCloseReader(qry.ExecuteReader());
                foreach (ProjectStep projectStep in collection)
                {
                    ProjectStepInfo projectStepInfo = new ProjectStepInfo();
                    LoadFromDAL(projectStepInfo, projectStep);
                    list.Add(projectStepInfo);
                }
                //生成缓存
                if (CachedEntityCommander.IsTypeRegistered(typeof(ProjectStepInfo)))
                {
                    CachedEntityCommander.SetCache(cacheKey, list);
                }
                return(list);
            }
        }
コード例 #2
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 <ProjectStepInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount)
        {
            if (pPageIndex <= 1)
            {
                pPageIndex = 1;
            }
            List <ProjectStepInfo> list = new List <ProjectStepInfo>();

            Query q = ProjectStep.CreateQuery();

            q.PageIndex = pPageIndex;
            q.PageSize  = pPageSize;
            q.ORDER_BY(pSortExpression, pOrderBy.ToString());
            ProjectStepCollection collection = new  ProjectStepCollection();

            collection.LoadAndCloseReader(q.ExecuteReader());

            foreach (ProjectStep projectStep  in collection)
            {
                ProjectStepInfo projectStepInfo = new ProjectStepInfo();
                LoadFromDAL(projectStepInfo, projectStep);
                list.Add(projectStepInfo);
            }
            pRecordCount = q.GetRecordCount();

            return(list);
        }
コード例 #3
0
 /// <summary>
 /// 批量装载
 /// </summary>
 internal static void LoadFromDALPatch(List <ProjectStepInfo> pList, ProjectStepCollection pCollection)
 {
     foreach (ProjectStep projectStep in pCollection)
     {
         ProjectStepInfo projectStepInfo = new ProjectStepInfo();
         LoadFromDAL(projectStepInfo, projectStep);
         pList.Add(projectStepInfo);
     }
 }
コード例 #4
0
ファイル: ProjectStepInfo.cs プロジェクト: xingfudaiyan/OA
 /// <summary>
 /// 批量装载
 /// </summary>
 internal static void LoadFromDALPatch(List< ProjectStepInfo> pList, ProjectStepCollection pCollection)
 {
     foreach (ProjectStep projectStep in pCollection)
     {
         ProjectStepInfo projectStepInfo = new ProjectStepInfo();
         LoadFromDAL(projectStepInfo, projectStep );
         pList.Add(projectStepInfo);
     }
 }
コード例 #5
0
ファイル: ProjectStepInfo.cs プロジェクト: xingfudaiyan/OA
        /// <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<ProjectStepInfo> GetPagedList(int pPageIndex,int pPageSize,SortDirection pOrderBy,string pSortExpression,out int pRecordCount)
        {
            if(pPageIndex<=1)
            pPageIndex=1;
            List< ProjectStepInfo> list = new List< ProjectStepInfo>();

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

            foreach (ProjectStep  projectStep  in collection)
            {
                ProjectStepInfo projectStepInfo = new ProjectStepInfo();
                LoadFromDAL(projectStepInfo,   projectStep);
                list.Add(projectStepInfo);
            }
            pRecordCount=q.GetRecordCount();

            return list;
        }
コード例 #6
0
ファイル: ProjectStepInfo.cs プロジェクト: xingfudaiyan/OA
 /// <summary>
 /// 获得数据列表
 /// </summary>
 /// <returns></returns>
 public static List<ProjectStepInfo> GetList()
 {
     string cacheKey = GetCacheKey();
     //本实体已经注册成缓存实体,并且缓存存在的时候,直接从缓存取
     if (CachedEntityCommander.IsTypeRegistered(typeof(ProjectStepInfo)) && CachedEntityCommander.GetCache(cacheKey) != null)
     {
         return CachedEntityCommander.GetCache(cacheKey) as List< ProjectStepInfo>;
     }
     else
     {
         List< ProjectStepInfo>  list =new List< ProjectStepInfo>();
         ProjectStepCollection  collection=new  ProjectStepCollection();
         Query qry = new Query(ProjectStep.Schema);
         collection.LoadAndCloseReader(qry.ExecuteReader());
         foreach(ProjectStep projectStep in collection)
         {
             ProjectStepInfo projectStepInfo= new ProjectStepInfo();
             LoadFromDAL(projectStepInfo,projectStep);
             list.Add(projectStepInfo);
         }
       	//生成缓存
         if (CachedEntityCommander.IsTypeRegistered(typeof(ProjectStepInfo)))
         {
             CachedEntityCommander.SetCache(cacheKey, list);
         }
         return list;
     }
 }