示例#1
0
        public Mvc.Pager.PagedList <object> GetList(Func <IQueryable <TEntity>, List <object> > selector,
                                                    Core.Specifications.ISpecification <TEntity> spec,
                                                    string orderByString,
                                                    string order,
                                                    int PageIndex = 1,
                                                    int PageSize  = 24)
        {
            var query = order.Trim().ToLower().Equals("desc")
                ?
                        (this.DbSet.Where(spec.GetExpression()).OrderBy(orderByString, true))
                :
                        (this.DbSet.Where(spec.GetExpression()).OrderBy(orderByString));
            var result = query.Skip((PageIndex - 1) * PageSize).Take(PageSize);
            var list   = new Mvc.Pager.PagedList <object>(selector(result), PageIndex, PageSize, query.Count());

            return(list);

            #region reflection
            //PropertyInfo property = typeof(TEntity).GetProperty(orderByString);
            //string type = property.PropertyType.FullName;

            //Type generic = typeof(CreateExpression<,>);
            //Type[] typeArgs2 = { typeof(TEntity), Type.GetType(type) };
            //generic = generic.MakeGenericType(typeArgs2);
            //var dic = Activator.CreateInstance(generic);

            //MethodInfo mi = dic.GetType().GetMethod("GetExpressionByStringColumn");
            //Expression<Func<TEntity, int>> result = mi.Invoke(null, new object[] { orderByString }) as Expression<Func<TEntity, int>>;
            #endregion
        }
示例#2
0
        public Pager.PagedList <object> GetList(Func <IQueryable <TEntity>, List <object> > selector,
                                                Core.Specifications.ISpecification <TEntity> spec
                                                , Dictionary <string, bool> paramNames
                                                , int PageIndex = 1
                                                , int PageSize  = 24)
        {
            var query  = this.DbSet.Where(spec.GetExpression()).OrderBy(paramNames);
            var result = query.Skip((PageIndex - 1) * PageSize).Take(PageSize);
            var list   = new Mvc.Pager.PagedList <object>(selector(result), PageIndex, PageSize, query.Count());

            return(list);
        }
示例#3
0
 public TEntity GetEntity(Core.Specifications.ISpecification <TEntity> spec)
 {
     return(GetEntity(spec.GetExpression()));
 }