public override DbExpression Visit(DbExistsExpression exp)
{
this._sqlBuilder.Append("Exists ");
DbSqlQueryExpression rawSqlQuery = exp.SqlQuery;
DbSqlQueryExpression sqlQuery = new DbSqlQueryExpression()
{
TakeCount = rawSqlQuery.TakeCount,
SkipCount = rawSqlQuery.SkipCount,
Table = rawSqlQuery.Table,
Condition = rawSqlQuery.Condition,
HavingCondition = rawSqlQuery.HavingCondition,
};
sqlQuery.GroupSegments.AddRange(rawSqlQuery.GroupSegments);
DbColumnSegment columnSegment = new DbColumnSegment(DbExpression.Constant("1"), "C");
sqlQuery.ColumnSegments.Add(columnSegment);
DbSubQueryExpression subQuery = new DbSubQueryExpression(sqlQuery);
return(subQuery.Accept(this));
}
public virtual JoinQueryResult ToJoinQueryResult(JoinType joinType, LambdaExpression conditionExpression, ScopeParameterDictionary scopeParameters, StringSet scopeTables, Func <string, string> tableAliasGenerator)
{
DbSqlQueryExpression sqlQuery = this.CreateSqlQuery();
DbSubQueryExpression subQuery = new DbSubQueryExpression(sqlQuery);
string alias = tableAliasGenerator(UtilConstants.DefaultTableAlias);
DbTableSegment tableSeg = new DbTableSegment(subQuery, alias, LockType.Unspecified);
DbJoinTableExpression joinTable = new DbJoinTableExpression(joinType.AsDbJoinType(), tableSeg);
DbTable aliasTable = new DbTable(tableSeg.Alias);
IObjectModel newModel = this.QueryModel.ResultModel.ToNewObjectModel(sqlQuery, aliasTable, joinTable, this.QueryModel.IgnoreFilters);
scopeParameters[conditionExpression.Parameters[conditionExpression.Parameters.Count - 1]] = newModel;
DbExpression condition = GeneralExpressionParser.Parse(conditionExpression, scopeParameters, scopeTables);
joinTable.Condition = condition;
JoinQueryResult result = new JoinQueryResult();
result.ResultModel = newModel;
result.JoinTable = joinTable;
return(result);
}
public override DbExpression Visit(DbSubQueryExpression exp)
{
return(exp);
}
public override DbExpression Visit(DbSubQueryExpression exp)
{
return(exp.Accept(this._generator));
}
public abstract T Visit(DbSubQueryExpression exp);
public virtual JoinQueryResult ToJoinQueryResult(JoinType joinType, LambdaExpression conditionExpression, DbFromTableExpression fromTable, List<IMappingObjectExpression> moeList, string tableAlias)
{
DbSqlQueryExpression sqlQuery = this.CreateSqlQuery();
DbSubQueryExpression subQuery = new DbSubQueryExpression(sqlQuery);
string alias = tableAlias;
DbTableSegment tableSeg = new DbTableSegment(subQuery, alias);
DbTable table = new DbTable(tableSeg.Alias);
IMappingObjectExpression newMoe = this.Result.MappingObjectExpression.ToNewObjectExpression(sqlQuery, table);
List<IMappingObjectExpression> moes = new List<IMappingObjectExpression>(moeList.Count + 1);
moes.AddRange(moeList);
moes.Add(newMoe);
DbExpression condition = GeneralExpressionVisitor.VisitPredicate(conditionExpression, moes);
DbJoinTableExpression joinTable = new DbJoinTableExpression(joinType, tableSeg, condition);
JoinQueryResult result = new JoinQueryResult();
result.MappingObjectExpression = newMoe;
result.JoinTable = joinTable;
return result;
}
public virtual FromQueryResult ToFromQueryResult()
{
DbSqlQueryExpression sqlQuery = this.CreateSqlQuery();
DbSubQueryExpression subQuery = new DbSubQueryExpression(sqlQuery);
DbTableSegment tableSeg = new DbTableSegment(subQuery, ResultElement.DefaultTableAlias);
DbFromTableExpression fromTable = new DbFromTableExpression(tableSeg);
DbTable table = new DbTable(tableSeg.Alias);
IMappingObjectExpression newMoe = this.Result.MappingObjectExpression.ToNewObjectExpression(sqlQuery, table);
FromQueryResult result = new FromQueryResult();
result.FromTable = fromTable;
result.MappingObjectExpression = newMoe;
return result;
}
public virtual GeneralQueryState AsSubQueryState()
{
DbSqlQueryExpression sqlQuery = this.CreateSqlQuery();
DbSubQueryExpression subQuery = new DbSubQueryExpression(sqlQuery);
ResultElement result = new ResultElement();
DbTableSegment tableSeg = new DbTableSegment(subQuery, result.GenerateUniqueTableAlias());
DbFromTableExpression fromTable = new DbFromTableExpression(tableSeg);
result.FromTable = fromTable;
DbTable table = new DbTable(tableSeg.Alias);
//TODO 根据旧的生成新 MappingMembers
IMappingObjectExpression newMoe = this.Result.MappingObjectExpression.ToNewObjectExpression(sqlQuery, table);
result.MappingObjectExpression = newMoe;
//得将 subQuery.SqlQuery.Orders 告诉 以下创建的 result
//将 orderPart 传递下去
if (this.Result.OrderSegments.Count > 0)
{
for (int i = 0; i < this.Result.OrderSegments.Count; i++)
{
DbOrderSegment orderPart = this.Result.OrderSegments[i];
DbExpression orderExp = orderPart.DbExpression;
string alias = null;
DbColumnSegment columnExpression = sqlQuery.ColumnSegments.Where(a => DbExpressionEqualityComparer.EqualsCompare(orderExp, a.Body)).FirstOrDefault();
// 对于重复的则不需要往 sqlQuery.Columns 重复添加了
if (columnExpression != null)
{
alias = columnExpression.Alias;
}
else
{
alias = Utils.GenerateUniqueColumnAlias(sqlQuery);
DbColumnSegment columnSeg = new DbColumnSegment(orderExp, alias);
sqlQuery.ColumnSegments.Add(columnSeg);
}
DbColumnAccessExpression columnAccessExpression = new DbColumnAccessExpression(orderExp.Type, table, alias);
result.OrderSegments.Add(new DbOrderSegment(columnAccessExpression, orderPart.OrderType));
}
}
result.IsOrderSegmentsFromSubQuery = true;
GeneralQueryState queryState = new GeneralQueryState(result);
return queryState;
}
