private void VisitJoinExpression(MethodCallExpression node)
{
var visitor = new JoinExpressionVisitor(_context);
visitor.Visit(node);
Joins = visitor.Joins;
if (_selectExpression == null)
_selectExpression = visitor.SelectExpression;
}
protected override System.Linq.Expressions.Expression VisitMethodCall(System.Linq.Expressions.MethodCallExpression node)
{
var leftTable = node.Arguments[0];
if (leftTable.NodeType == ExpressionType.Call)
{
var leftCallExp = leftTable as MethodCallExpression;
if (leftCallExp.Method.Name == "NoLock")
{
leftTable = leftCallExp.Arguments[0];
}
}
//JoinExpressionVisitor visitor = null;
var joinName = "<>" + Path.GetRandomFileName();
if (leftTable.NodeType == ExpressionType.Call)
{
var leftMethodCallExp = (MethodCallExpression)leftTable;
var visitorSub = new JoinExpressionVisitor(Context);
visitorSub.Visit(leftTable);
if (node.Method.Name == "SelectMany")
{
SelectExpression = node.Arguments[2];
joinName = ((ParameterExpression)((LambdaExpression)((UnaryExpression)node.Arguments[2]).Operand).Parameters[1]).Name;
var joinTmps = visitorSub.Joins;
var lastJoin = joinTmps.LastOrDefault();
joinTmps.Remove(lastJoin.Key);
// var lockTables = visitor.Result as List<string>;
Joins.Add(joinName, lastJoin.Value);
//foreach (var item in joinTmps)
//{
// if (item.Key == lastJoin.Key)
// {
// continue;
// }
// Joins.Add(item.Key, item.Value);
//}
return node;
}
//foreach (var item in visitorSub.Joins)
//{
// Joins.Add(item.Key, item.Value);
//}
}
SelectExpression = node.Arguments[4];
//if (leftTable.NodeType == ExpressionType.Call &&
// (((MethodCallExpression)leftTable).Method.Name == "SelectMany" ||
// _joinMethodNames.Contains(((MethodCallExpression)leftTable).Method.Name)))
//{
// visitor = new JoinExpressionVisitor();
// visitor.Visit(leftTable);
// foreach (var item in visitor.Joins)
// {
// Joins.Add(item.Key, item.Value);
// }
// //((List<Join>)Result).AddRange((List<Join>)visitor.Result);
// if (node.Method.Name == "SelectMany")
// {
// return node;
// }
//}
var rightTable = node.Arguments[1];
//var nolockRightTable = false;
if (rightTable.NodeType == ExpressionType.Call)
{
var rightCallExp = (MethodCallExpression)rightTable;
if (rightCallExp.Method.Name != "NoLock")
{
throw new Exception();
}
//nolockRightTable = true;
rightTable = rightCallExp.Arguments[0];
}
if (rightTable.NodeType != ExpressionType.Constant)
{
throw new Exception();
}
var leftColumnExp = node.Arguments[2];
var rightColumnExp = node.Arguments[3];
var memVisitor = new MemberExpressionVisitor(Context);
memVisitor.Visit(leftColumnExp);
if (memVisitor.Token.Type != TokenType.Column)
{
throw new Exception();
}
var join = new Join();
join.Left = memVisitor.Token.Column;
memVisitor = new MemberExpressionVisitor(Context);
memVisitor.Visit(rightColumnExp);
join.Right = memVisitor.Token.Column;
//if (nolockRightTable)
//{
// ((List<string>)Result).Add(join.Right.Table.Alias);
//}
switch (node.Method.Name)
{
case "Join":
join.JoinType = JoinType.Inner;
break;
case "GroupJoin":
join.JoinType = JoinType.Left;
break;
default:
throw new Exception();
}
var resultExp = node.Arguments[4];
var resultCallExp = (LambdaExpression)((LambdaExpression)((UnaryExpression)resultExp).Operand);
Joins.Add(joinName, join);
return node;
}