private string InternalGetSqlByExpression(BinaryExpression node)
{
MemberExpressionVisitor memberExpressionVisitor = new MemberExpressionVisitor();
memberExpressionVisitor.Visit(node.Left);
string fieldName = memberExpressionVisitor.GetResult().ToString();
string parameterName = ExpressionEntry.EnsurePatameter(memberExpressionVisitor.MemberInfo);
string sql = $"{fieldName} {ConvertExpressionTypeToSymbol(node.NodeType)} @{parameterName}";
ExpressionEntry.Parameters.Add($"@{parameterName}", ExpressionEntry.GetConstantByExpression(node.Right));
return(sql);
}
protected override Expression VisitMember(MemberExpression node)
{
base.VisitMember(node);
string fieldName = GetResult().ToString();
sb.Clear();
string parameterName = ExpressionEntry.EnsurePatameter(MemberInfo);
sb.Append($"{fieldName} = @{parameterName}");
ExpressionEntry.Parameters.Add($"@{parameterName}", GetConstant());
return(node);
}
protected override Expression VisitMethodCall(MethodCallExpression node)
{
string symbol = string.Empty;
switch (node.Method.Name)
{
case "Equals":
symbol = "= {0}";
break;
case "StartsWith":
symbol = "like {0}'%'";
break;
case "EndsWith":
symbol = "like '%'{0}";
break;
case "Contains":
symbol = "like '%'{0}'%'";
break;
default:
throw new NotSupportedException($"Not support method name:{node.Method.Name}");
}
if (node.Object is MemberExpression)
{
MemberExpressionVisitor memberExpressionVisitor = new MemberExpressionVisitor();
memberExpressionVisitor.Visit(node.Object);
string fieldName = memberExpressionVisitor.GetResult().ToString();
string parameterName = ExpressionEntry.EnsurePatameter(memberExpressionVisitor.MemberInfo);
string sql = string.Format($"{fieldName} {symbol}", $"@{parameterName}");
sb.Append(sql);
ExpressionEntry.Parameters.Add($"@{parameterName}", ExpressionEntry.GetConstantByExpression(node.Arguments[0]));
}
return(node);
}
