Exemplo n.º 1
0
        /// <summary>
        /// Remark:获取List列表系列重载方法
        /// </summary>
        #region 获取分页系列重载方法

        public static List <T> PageList <T>(int page, int pageSize, string sql, out int recordCount)
        {
            int pageIndex = page;

            using (var db = new PetaDbContext())
            {
                var result = db.Page <T>(pageIndex, pageSize, sql);
                recordCount = (int)result.TotalItems;

                return(result.Items);
            }
        }
Exemplo n.º 2
0
        public static List <T> PageList <T>(int page, int pageSize, string sql, out int recordCount, params object[] args)
        {
            int pageIndex = page;

            using (var db = new PetaDbContext())
            {
                //PetaPoco框架自带分页
                var result = db.Page <T>(pageIndex, pageSize, sql, args);
                recordCount = (int)result.TotalItems;

                return(result.Items);
            }
        }