Example #1
0
        private IEnumerable <T> ResolveEnities()
        {
            var predicate = QueryBuilder <T> .FromExpression(_expression);

            var p = predicate?.Predicates == null ? null : predicate;

            return(_implementor.GetList <T>(_session.Connection, p, _sort, _session.Transaction, _timeout, false, _take,
                                            _nolock));
        }
Example #2
0
        private IEnumerable <T> ResolveEnities()
        {
            IPredicateGroup predicate = QueryBuilder <T> .FromExpression(_expression);

            //IPredicateGroup p = predicate?.Predicates == null ? null : predicate;

            if (_offset.HasValue && _take.HasValue)
            {
                return(_dapperImplementor.GetListPaged <T>(_session, predicate, _sort, _session.Transaction, _timeout, false, _offset.Value, _take.Value, _nolock));
            }
            return(_dapperImplementor.GetList <T>(_session, predicate, _sort, _session.Transaction, _timeout, false, _take, _nolock));
        }
Example #3
0
 public IEnumerable <T> GetList <T>(object predicate, IList <ISort> sort, IDbTransaction transaction, int?commandTimeout, bool buffered) where T : class
 {
     return(_dapper.GetList <T>(Connection, predicate, sort, transaction, commandTimeout, buffered));
 }
Example #4
0
 public IEnumerable <T> Query <T>(object predicate, IList <ISort> sort, DbTransaction transaction, int?commandTimeout, bool buffered) where T : Cissy.Database.IEntity
 {
     return(_dapper.GetList <T>(Connection, predicate, sort, transaction, commandTimeout, buffered));
 }
Example #5
0
 /// <summary>
 /// 根据查询条件选择满足条件的记录并返回IEnumerable<T>
 /// Executes a select query using the specified predicate, returning an IEnumerable data typed as per T.
 /// </summary>
 /// <typeparam name="T">实体类型</typeparam>
 /// <param name="connection">数据库连接</param>
 /// <param name="predicate">查询条件</param>
 /// <param name="sort">排序列表</param>
 /// <param name="transaction">事务</param>
 /// <param name="commandTimeout">超时时间</param>
 /// <param name="buffered">是否缓存,默认不缓存</param>
 /// <returns>T类型的枚举器</returns>
 public static IEnumerable <T> GetList <T>(this IDbConnection connection, object predicate = null, IList <ISort> sort = null, IDbTransaction transaction = null, int?commandTimeout = null, bool buffered = false) where T : class
 {
     return(Instance.GetList <T>(connection, predicate, sort, transaction, commandTimeout, buffered));
 }
Example #6
0
 public virtual IList <T> GetList()
 {
     return(_dapperImplementor.GetList <T>(session, null, null, session.Transaction, null, false, null, false).ToList());
 }
Example #7
0
 public IEnumerable <T> GetList <T>(object predicate, IList <ISort> sort, IDbTransaction transaction, int?commandTimeout, bool buffered, string hints = null, long?top = null) where T : class
 {
     return(_dapper.GetList <T>(Connection, predicate, sort, transaction, commandTimeout, buffered, hints, top));
 }
Example #8
0
        //public IEnumerable<TEntity> Select<TEntity>(Expression<Func<TEntity, bool>> predicate, Paging paging, params Expression<Func<TEntity, object>>[] sort) where TEntity : class
        //{
        //	var filteredPredicate = _dapperFilterExecuter.ExecuteFilter(predicate);
        //	return _dapper.Select<TEntity>(Connection, filteredPredicate, paging, sort.ToSorting());
        //}

        public IEnumerable <TEntity> Select <TEntity>(Expression <Func <TEntity, bool> > predicate, Paging paging, params Sorting[] sorting) where TEntity : class
        {
            var filteredPredicate = _dapperFilterExecuter.ExecuteFilter(predicate);

            return(_dapper.GetList <TEntity>(Connection, filteredPredicate, paging, sorting));
        }