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 <YearInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount)
        {
            if (pPageIndex <= 1)
            {
                pPageIndex = 1;
            }
            List <YearInfo> list = new List <YearInfo>();

            Query q = Year.CreateQuery();

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

            collection.LoadAndCloseReader(q.ExecuteReader());

            foreach (Year year  in collection)
            {
                YearInfo yearInfo = new YearInfo();
                LoadFromDAL(yearInfo, year);
                list.Add(yearInfo);
            }
            pRecordCount = q.GetRecordCount();

            return(list);
        }
Exemplo n.º 2
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        /// <returns></returns>
        public static List <YearInfo> GetList()
        {
            string cacheKey = GetCacheKey();

            //本实体已经注册成缓存实体,并且缓存存在的时候,直接从缓存取
            if (CachedEntityCommander.IsTypeRegistered(typeof(YearInfo)) && CachedEntityCommander.GetCache(cacheKey) != null)
            {
                return(CachedEntityCommander.GetCache(cacheKey) as List <YearInfo>);
            }
            else
            {
                List <YearInfo> list       = new List <YearInfo>();
                YearCollection  collection = new  YearCollection();
                Query           qry        = new Query(Year.Schema);
                collection.LoadAndCloseReader(qry.ExecuteReader());
                foreach (Year year in collection)
                {
                    YearInfo yearInfo = new YearInfo();
                    LoadFromDAL(yearInfo, year);
                    list.Add(yearInfo);
                }
                //生成缓存
                if (CachedEntityCommander.IsTypeRegistered(typeof(YearInfo)))
                {
                    CachedEntityCommander.SetCache(cacheKey, list);
                }
                return(list);
            }
        }
Exemplo n.º 3
0
        //数据持久化
        internal static void  SaveToDb(YearInfo pYearInfo, Year pYear, bool pIsNew)
        {
            pYear.YearId   = pYearInfo.yearId;
            pYear.YearName = pYearInfo.yearName;
            pYear.IsNew    = pIsNew;
            string UserName = SubsonicHelper.GetUserName();

            try
            {
                pYear.Save(UserName);
            }
            catch (Exception ex)
            {
                LogManager.getInstance().getLogger(typeof(YearInfo)).Error(ex);
                if (ex.Message.Contains("插入重复键"))               //违反了唯一键
                {
                    throw new AppException("此对象已经存在");          //此处等待优化可以从唯一约束中直接取出提示来,如果没有的话,默认为原始的出错提示
                }
                throw new AppException("保存失败");
            }
            pYearInfo.yearId = pYear.YearId;
            //如果缓存存在,更新缓存
            if (CachedEntityCommander.IsTypeRegistered(typeof(YearInfo)))
            {
                ResetCache();
            }
        }
Exemplo n.º 4
0
 /// <summary>
 /// 批量装载
 /// </summary>
 internal static void LoadFromDALPatch(List <YearInfo> pList, YearCollection pCollection)
 {
     foreach (Year year in pCollection)
     {
         YearInfo yearInfo = new YearInfo();
         LoadFromDAL(yearInfo, year);
         pList.Add(yearInfo);
     }
 }
Exemplo n.º 5
0
        public YearInfo GetYearInfoById(int YearId)
        {
            YearInfo yearInfo = null;             //

            try
            {
                yearInfo = new YearInfo(YearId);
            }
            catch (AppException)
            {
                return(null);
            }

            return(yearInfo);
        }
Exemplo n.º 6
0
 private void LoadFromId(int yearId)
 {
     if (CachedEntityCommander.IsTypeRegistered(typeof(YearInfo)))
     {
         YearInfo yearInfo = Find(GetList(), yearId);
         if (yearInfo == null)
         {
             throw new AppException("未能在缓存中找到相应的键值对象");
         }
         Copy(yearInfo, this);
     }
     else
     {
         Year year = new Year(yearId);
         if (year.IsNew)
         {
             throw new AppException("尚未初始化");
         }
         LoadFromDAL(this, year);
     }
 }
Exemplo n.º 7
0
 /// <summary>
 /// 复制为另一个对象
 /// </summary>
 /// <param name="pIndustryTypeInfoTo"></param>
 public void CopyTo(YearInfo pYearInfoTo)
 {
     Copy(this, pYearInfoTo);
 }
Exemplo n.º 8
0
 //从后台获取数据
 internal static void  LoadFromDAL(YearInfo pYearInfo, Year pYear)
 {
     pYearInfo.yearId   = pYear.YearId;
     pYearInfo.yearName = pYear.YearName;
     pYearInfo.Loaded   = true;
 }
Exemplo n.º 9
0
 /// <summary>
 /// 复制一个对象,采用硬编码的方式,避免反射的低效
 /// </summary>
 /// <param name="pIndustryTypeInfoFrom"></param>
 /// <param name="pIndustryTypeInfoTo"></param>
 public static void Copy(YearInfo pYearInfoFrom, YearInfo pYearInfoTo)
 {
     pYearInfoTo.YearId   = pYearInfoFrom.yearId;
     pYearInfoTo.YearName = pYearInfoFrom.yearName;
     pYearInfoTo.Loaded   = pYearInfoFrom.Loaded;
 }
Exemplo n.º 10
0
 public object  SaveYearInfo(YearInfo yearInfo)
 {
     yearInfo.Save();
     return(yearInfo.YearId);
 }
Exemplo n.º 11
0
 public List <YearInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount)
 {
     return(YearInfo.GetPagedList(pPageIndex, pPageSize, pOrderBy, pSortExpression, out pRecordCount));
 }
Exemplo n.º 12
0
 public List <YearInfo> GetYearInfoList()
 {
     return(YearInfo.GetList());
 }
Exemplo n.º 13
0
        public void DeleteById(YearInfo pYearInfo)
        {
            YearInfo yearInfo = new YearInfo(pYearInfo.YearId);

            yearInfo.Delete();
        }