public QueryWhere(LambdaExpression expression, QueryOperator queryOperator, INetSqlQueryable subQueryable) { Type = QueryWhereType.SubQuery; SubQueryColumn = expression; SubQueryOperator = queryOperator; SubQueryable = subQueryable; }
protected async Task <List <TEntity> > PaginationAsync(Paging paging = null, INetSqlQueryable <TEntity> query = null, IDbTransaction transaction = null) { if (paging == null) { paging = new Paging(); } if (query == null) { query = Db.Find(); } query.Limit(paging.Skip, paging.Size); //排序 foreach (var sort in paging.OrderBy) { query.OrderBy(sort); } var count = query.Count(); var list = query.ToList(); paging.TotalCount = await count; return(await list); }
public static INetSqlQueryable <WorkflowDefinitionVersionEntity> WithVersion( this INetSqlQueryable <WorkflowDefinitionVersionEntity> query, VersionOptions version) { return(query.WhereIf(version.IsDraft, a => a.IsPublished == false) .WhereIf(version.IsLatest, a => a.IsLatest == true) .WhereIf(version.IsPublished, a => a.IsPublished == true) .WhereIf(version.IsLatestOrPublished, a => a.IsPublished == true || a.IsLatest == true) .WhereIf(version.Version > 0, a => a.Version == version.Version) .OrderByDescending(a => a.Version)); }
public void SetWhere(LambdaExpression expression, QueryOperator queryOperator, INetSqlQueryable subQueryable) { if (subQueryable != null) { Where.Add(new QueryWhere(expression, queryOperator, subQueryable)); } }
public INetSqlQueryable <TEntity, TEntity2, TEntity3> Where <TKey>(Expression <Func <TEntity, TEntity2, TEntity3, TKey> > key, QueryOperator queryOperator, INetSqlQueryable queryable) { QueryBody.SetWhere(key, queryOperator, queryable); return(this); }