// Cross Join
private void AppendCrossJoin(ISqlBuilder builder, DbExpression exp, TableAliasCache aliases)
{
var lambdaExp = exp.Expressions[1] as LambdaExpression;
Type type = lambdaExp.Parameters[1].Type;
var typeRuntime = TypeRuntimeInfoCache.GetRuntimeInfo(type);
bool withNoLock = !typeRuntime.IsTemporary && _context.NoLock && !string.IsNullOrEmpty(_provider.WidthNoLock);
builder.Append(' ');
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
string alias = aliases.GetTableAlias(lambdaExp.Parameters[1]);
builder.Append(' ');
builder.Append(alias);
builder.Append(' ');
if (withNoLock)
{
builder.Append(_provider.WidthNoLock);
builder.Append(' ');
}
}
// 添加导航属性关联
protected override void AppendNavigation()
{
if (base.NavMembers == null || base.NavMembers.Count == 0)
{
return;
}
// 如果有一对多的导航属性，肯定会产生嵌套查询。那么内层查询别名肯定是t0，所以需要清掉
if (this.HasMany)
{
_aliases = new TableAliasCache(_aliases.Declared);
}
//开始产生LEFT JOIN 子句
ISqlBuilder builder = this.JoinFragment;
foreach (var kvp in base.NavMembers)
{
string key = kvp.Key;
MemberExpression m = kvp.Value;
TypeRuntimeInfo typeRuntime = TypeRuntimeInfoCache.GetRuntimeInfo(m.Expression.Type);
ForeignKeyAttribute attribute = typeRuntime.GetInvokerAttribute <ForeignKeyAttribute>(m.Member.Name);
string innerKey = string.Empty;
string outerKey = key;
string innerAlias = string.Empty;
if (!m.Expression.Acceptable())
{
innerKey = m.Expression.NodeType == ExpressionType.Parameter
? (m.Expression as ParameterExpression).Name
: (m.Expression as MemberExpression).Member.Name;
}
else
{
MemberExpression mLeft = null;
if (m.Expression.NodeType == ExpressionType.MemberAccess)
{
mLeft = m.Expression as MemberExpression;
}
else if (m.Expression.NodeType == ExpressionType.Call)
{
mLeft = (m.Expression as MethodCallExpression).Object as MemberExpression;
}
string name = TypeRuntimeInfoCache.GetRuntimeInfo(mLeft.Type).TableName;
innerAlias = _aliases.GetJoinTableAlias(name);
if (string.IsNullOrEmpty(innerAlias))
{
string keyLeft = mLeft.GetKeyWidthoutAnonymous();
if (base.NavMembers.ContainsKey(keyLeft))
{
innerKey = keyLeft;
}
innerAlias = _aliases.GetNavigationTableAlias(innerKey);
}
}
string alias1 = !string.IsNullOrEmpty(innerAlias) ? innerAlias : _aliases.GetTableAlias(innerKey);
string alias2 = _aliases.GetNavigationTableAlias(outerKey);
builder.AppendNewLine();
builder.Append("LEFT JOIN ");
Type type = m.Type;
if (type.IsGenericType)
{
type = type.GetGenericArguments()[0];
}
var typeRuntime2 = TypeRuntimeInfoCache.GetRuntimeInfo(type);
builder.AppendMember(typeRuntime2.TableName, !typeRuntime2.IsTemporary);
builder.Append(" ");
builder.Append(alias2);
bool withNoLock = !typeRuntime2.IsTemporary && _context.NoLock && !string.IsNullOrEmpty(_provider.WidthNoLock);
if (withNoLock)
{
builder.Append(' ');
builder.Append(_provider.WidthNoLock);
}
builder.Append(" ON ");
for (int i = 0; i < attribute.InnerKeys.Length; i++)
{
builder.Append(alias1);
builder.Append('.');
builder.AppendMember(attribute.InnerKeys[i]);
builder.Append(" = ");
builder.Append(alias2);
builder.Append('.');
builder.AppendMember(attribute.OuterKeys[i]);
if (i < attribute.InnerKeys.Length - 1)
{
builder.Append(" AND ");
}
}
}
}
// LEFT OR INNER JOIN
private void AppendLfInJoin(ISqlBuilder builder, DbExpression dbExpression, TableAliasCache aliases)
{
bool withNoLock = false;
builder.Append(' ');
IDbQueryable dbQuery = (IDbQueryable)((dbExpression.Expressions[0] as ConstantExpression).Value);
if (dbQuery.DbExpressions.Count == 1 && dbQuery.DbExpressions[0].DbExpressionType == DbExpressionType.GetTable)
{
Type type = dbExpression.Expressions[0].Type.GetGenericArguments()[0];
var typeRuntime = TypeRuntimeInfoCache.GetRuntimeInfo(type);
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
withNoLock = !typeRuntime.IsTemporary && _context.NoLock && !string.IsNullOrEmpty(_provider.WidthNoLock);
}
else
{
// 嵌套
var cmd = dbQuery.Resolve(builder.Indent + 1, false, builder.Token);
builder.Append("(");
builder.Append(cmd.CommandText);
builder.AppendNewLine();
builder.Append(')');
}
var left = dbExpression.Expressions[1] as LambdaExpression;
var right = dbExpression.Expressions[2] as LambdaExpression;
// t0(t1)
string alias = !(left.Body.NodeType == ExpressionType.New || left.Body.NodeType == ExpressionType.MemberInit)
? aliases.GetTableAlias(dbExpression.Expressions[2])
: aliases.GetTableAlias(right.Parameters[0]);
builder.Append(' ');
builder.Append(alias);
builder.Append(' ');
if (withNoLock)
{
builder.Append(_provider.WidthNoLock);
builder.Append(' ');
}
// ON a.Name = b.Name AND a.Id = b.Id
builder.Append("ON ");
if (left.Body.NodeType == ExpressionType.New)
{
var body1 = left.Body as NewExpression;
var body2 = right.Body as NewExpression;
for (int index = 0; index < body1.Arguments.Count; ++index)
{
builder.AppendMember(aliases, body1.Arguments[index]);
builder.Append(" = ");
builder.AppendMember(aliases, body2.Arguments[index]);
if (index < body1.Arguments.Count - 1)
{
builder.Append(" AND ");
}
}
}
else if (left.Body.NodeType == ExpressionType.MemberInit)
{
var body1 = left.Body as MemberInitExpression;
var body2 = right.Body as MemberInitExpression;
for (int index = 0; index < body1.Bindings.Count; ++index)
{
builder.AppendMember(aliases, (body1.Bindings[index] as MemberAssignment).Expression);
builder.Append(" = ");
builder.AppendMember(aliases, (body2.Bindings[index] as MemberAssignment).Expression);
if (index < body1.Bindings.Count - 1)
{
builder.Append(" AND ");
}
}
}
else
{
builder.AppendMember(aliases, left.Body.ReduceUnary());
builder.Append(" = ");
builder.AppendMember(aliases, right.Body.ReduceUnary());
}
}