1054 lines
45 KiB
C#
1054 lines
45 KiB
C#
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Collections.ObjectModel;
|
|||
|
|
using System.Globalization;
|
|||
|
|
using System.Linq;
|
|||
|
|
using System.Linq.Expressions;
|
|||
|
|
using System.Reflection;
|
|||
|
|
using System.Text;
|
|||
|
|
namespace SqlSugar
|
|||
|
|
{
|
|||
|
|
public class ExpressionTool
|
|||
|
|
{
|
|||
|
|
internal static string ResolveMemberValue(ExpressionContext context, Expression item, string value)
|
|||
|
|
{
|
|||
|
|
if (item is MemberExpression member)
|
|||
|
|
{
|
|||
|
|
if (member.Expression is ParameterExpression parameterExpression)
|
|||
|
|
{
|
|||
|
|
if (value != null && value.Contains("(") && !value.Contains(" "))
|
|||
|
|
{
|
|||
|
|
var guid = Guid.NewGuid() + "";
|
|||
|
|
var guid2 = Guid.NewGuid() + "";
|
|||
|
|
value = value.Replace("(", guid).Replace(")", guid2);
|
|||
|
|
value = context.GetTranslationColumnName(value);
|
|||
|
|
value = value.Replace(guid, "(").Replace(guid2, ")");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return value;
|
|||
|
|
}
|
|||
|
|
internal static Expression GetConditionalExpression(Expression item)
|
|||
|
|
{
|
|||
|
|
ConstantExpression trueConstant = Expression.Constant(true, typeof(bool));
|
|||
|
|
ConstantExpression falseConstant = Expression.Constant(false, typeof(bool));
|
|||
|
|
|
|||
|
|
// 创建条件表达式：item ? true : false
|
|||
|
|
Expression conditionalExpression = Expression.Condition(
|
|||
|
|
test: item,
|
|||
|
|
ifTrue: trueConstant,
|
|||
|
|
ifFalse: falseConstant
|
|||
|
|
);
|
|||
|
|
return conditionalExpression;
|
|||
|
|
}
|
|||
|
|
internal static bool IsOwnsOne(ExpressionContext context, Expression member)
|
|||
|
|
{
|
|||
|
|
var isOwnsOne = false;
|
|||
|
|
if (context?.SugarContext?.Context == null)
|
|||
|
|
{
|
|||
|
|
return false;
|
|||
|
|
}
|
|||
|
|
if (member is MemberExpression memberExp)
|
|||
|
|
{
|
|||
|
|
var name = memberExp?.Member?.Name;
|
|||
|
|
if (memberExp?.Expression is MemberExpression parentMemberExp)
|
|||
|
|
{
|
|||
|
|
if (name != null && parentMemberExp?.Expression is ParameterExpression rootExp)
|
|||
|
|
{
|
|||
|
|
var entityInfo = context?.SugarContext?.Context?.EntityMaintenance?.GetEntityInfo(rootExp.Type);
|
|||
|
|
var navColumn = entityInfo?.Columns?.FirstOrDefault(it => it.PropertyName == name);
|
|||
|
|
isOwnsOne = navColumn?.ForOwnsOnePropertyInfo != null;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return isOwnsOne;
|
|||
|
|
}
|
|||
|
|
internal static EntityColumnInfo GetOwnsOneColumnInfo(ExpressionContext context, Expression member)
|
|||
|
|
{
|
|||
|
|
EntityColumnInfo entityColumnInfo = new EntityColumnInfo();
|
|||
|
|
if (member is MemberExpression memberExp)
|
|||
|
|
{
|
|||
|
|
var name = memberExp?.Member?.Name;
|
|||
|
|
if (memberExp.Expression is MemberExpression parentMemberExp)
|
|||
|
|
{
|
|||
|
|
if (name != null && parentMemberExp.Expression is ParameterExpression)
|
|||
|
|
{
|
|||
|
|
var rootExp = (parentMemberExp.Expression as ParameterExpression);
|
|||
|
|
var entityInfo = context?.SugarContext?.Context?.EntityMaintenance?.GetEntityInfo(rootExp.Type);
|
|||
|
|
var navColumn = entityInfo.Columns.FirstOrDefault(it => it.PropertyName == name);
|
|||
|
|
entityColumnInfo= navColumn;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return entityColumnInfo;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
internal static bool IsNavMember(ExpressionContext context, Expression member)
|
|||
|
|
{
|
|||
|
|
var isNav = false;
|
|||
|
|
if (member is MemberExpression && (member as MemberExpression)?.Type?.IsClass()==true)
|
|||
|
|
{
|
|||
|
|
var memberExp = (member as MemberExpression);
|
|||
|
|
var name = memberExp?.Member?.Name;
|
|||
|
|
var type = memberExp?.Type;
|
|||
|
|
if (name!=null&&type!=null&&memberExp.Expression is ParameterExpression)
|
|||
|
|
{
|
|||
|
|
var rootExp = (memberExp.Expression as ParameterExpression);
|
|||
|
|
var entityInfo = context?.SugarContext?.Context?.EntityMaintenance?.GetEntityInfo(rootExp.Type);
|
|||
|
|
var navColumn = entityInfo.Columns.FirstOrDefault(it => it.PropertyName == name);
|
|||
|
|
isNav = navColumn?.Navigat != null;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return isNav;
|
|||
|
|
}
|
|||
|
|
internal static bool IsNavMember(ISqlSugarClient context, Expression member)
|
|||
|
|
{
|
|||
|
|
var isNav = false;
|
|||
|
|
if (member is MemberExpression && (member as MemberExpression)?.Type?.IsClass() == true)
|
|||
|
|
{
|
|||
|
|
var memberExp = (member as MemberExpression);
|
|||
|
|
var name = memberExp?.Member?.Name;
|
|||
|
|
var type = memberExp?.Type;
|
|||
|
|
if (name != null && type != null && memberExp.Expression is ParameterExpression)
|
|||
|
|
{
|
|||
|
|
var rootExp = (memberExp.Expression as ParameterExpression);
|
|||
|
|
var entityInfo = context?.EntityMaintenance?.GetEntityInfo(rootExp.Type);
|
|||
|
|
var navColumn = entityInfo.Columns.FirstOrDefault(it => it.PropertyName == name);
|
|||
|
|
isNav = navColumn?.Navigat != null;
|
|||
|
|
}
|
|||
|
|
else if (name != null && type != null && memberExp.Expression is MemberExpression)
|
|||
|
|
{
|
|||
|
|
var rootExp = (memberExp.Expression as MemberExpression);
|
|||
|
|
if (rootExp.Type.IsClass()&&type.IsArray==false&&type.FullName.IsCollectionsList()==false)
|
|||
|
|
{
|
|||
|
|
var entityInfo = context?.EntityMaintenance?.GetEntityInfo(rootExp.Type);
|
|||
|
|
var navColumn = entityInfo.Columns.FirstOrDefault(it => it.PropertyName == name);
|
|||
|
|
isNav = navColumn?.Navigat != null;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return isNav;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
internal static bool IsSqlParameterDbType(ExpressionContext context, Expression member)
|
|||
|
|
{
|
|||
|
|
var isNav = false;
|
|||
|
|
if (context?.SugarContext!=null&&member is MemberExpression && (member as MemberExpression)?.Expression is ParameterExpression expression)
|
|||
|
|
{
|
|||
|
|
if (expression != null)
|
|||
|
|
{
|
|||
|
|
var typeEntity = context?.SugarContext.Context.EntityMaintenance.GetEntityInfo(expression.Type);
|
|||
|
|
var columnInfo = typeEntity.Columns.FirstOrDefault(it => it.PropertyName == ExpressionTool.GetMemberName(member));
|
|||
|
|
if (columnInfo?.SqlParameterDbType is Type)
|
|||
|
|
{
|
|||
|
|
return true;
|
|||
|
|
}
|
|||
|
|
if (columnInfo?.SqlParameterDbType is System.Data.DbType)
|
|||
|
|
{
|
|||
|
|
return true;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return isNav;
|
|||
|
|
}
|
|||
|
|
internal static SugarParameter GetParameterBySqlParameterDbType(int index,object value,ExpressionContext context, Expression member)
|
|||
|
|
{
|
|||
|
|
var expression=(member as MemberExpression)?.Expression;
|
|||
|
|
var typeEntity = context?.SugarContext.Context.EntityMaintenance.GetEntityInfo(expression.Type);
|
|||
|
|
var columnInfo = typeEntity.Columns.FirstOrDefault(it => it.PropertyName == ExpressionTool.GetMemberName(member));
|
|||
|
|
var columnDbType = columnInfo.SqlParameterDbType as Type;
|
|||
|
|
if (columnDbType != null)
|
|||
|
|
{
|
|||
|
|
var ParameterConverter = columnDbType.GetMethod("ParameterConverter").MakeGenericMethod(columnInfo.PropertyInfo.PropertyType);
|
|||
|
|
var obj = Activator.CreateInstance(columnDbType);
|
|||
|
|
var p = ParameterConverter.Invoke(obj, new object[] { value, index }) as SugarParameter;
|
|||
|
|
return p;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
var paramter = new SugarParameter("@Common" + index, value)
|
|||
|
|
{
|
|||
|
|
DbType = (System.Data.DbType)columnInfo.SqlParameterDbType
|
|||
|
|
};
|
|||
|
|
if (columnInfo.SqlParameterSize!=null&& columnInfo.SqlParameterSize.ObjToInt()>0)
|
|||
|
|
{
|
|||
|
|
paramter.Size= columnInfo.SqlParameterSize.ObjToInt();
|
|||
|
|
}
|
|||
|
|
return paramter;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
public static List<string> ExtractMemberNames(Expression expression)
|
|||
|
|
{
|
|||
|
|
var memberNames = new List<string>();
|
|||
|
|
var currentExpression = (expression as LambdaExpression).Body;
|
|||
|
|
|
|||
|
|
while (currentExpression != null && currentExpression.NodeType == ExpressionType.MemberAccess)
|
|||
|
|
{
|
|||
|
|
var memberExpression = (MemberExpression)currentExpression;
|
|||
|
|
memberNames.Add(memberExpression.Member.Name);
|
|||
|
|
currentExpression = memberExpression.Expression;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
memberNames.Reverse(); // Reverse the list to get the correct order of member names
|
|||
|
|
return memberNames;
|
|||
|
|
}
|
|||
|
|
public static Expression<Func<T, bool>> ChangeLambdaExpression<T>(Expression<Func<T,bool>> exp,string replaceParameterName, string newParameterName)
|
|||
|
|
{
|
|||
|
|
var parameter = Expression.Parameter(typeof(T), newParameterName);
|
|||
|
|
|
|||
|
|
// 替换Lambda表达式中指定参数名
|
|||
|
|
var visitor = new ParameterReplacer(replaceParameterName, parameter);
|
|||
|
|
var newBody = visitor.Visit(exp);
|
|||
|
|
|
|||
|
|
return (Expression<Func<T, bool>>)newBody;
|
|||
|
|
}
|
|||
|
|
public static Expression ChangeLambdaExpression(Expression exp, Type targetType, string replaceParameterName, string newParameterName)
|
|||
|
|
{
|
|||
|
|
var parameter = Expression.Parameter(targetType, newParameterName);
|
|||
|
|
|
|||
|
|
// 替换Lambda表达式中指定参数名
|
|||
|
|
var visitor = new ParameterReplacer(replaceParameterName, parameter);
|
|||
|
|
var newBody = visitor.Visit(exp);
|
|||
|
|
|
|||
|
|
return newBody;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public static List<string> GetNewArrayMembers(NewArrayExpression newArrayExpression)
|
|||
|
|
{
|
|||
|
|
List<string> strings = new List<string>();
|
|||
|
|
// 获取数组元素的 MemberExpression，并输出属性名
|
|||
|
|
foreach (var expression in newArrayExpression.Expressions)
|
|||
|
|
{
|
|||
|
|
var memberExpression = expression as MemberExpression;
|
|||
|
|
if (memberExpression != null)
|
|||
|
|
{
|
|||
|
|
strings.Add(memberExpression.Member.Name);
|
|||
|
|
}
|
|||
|
|
else if (expression is ConstantExpression)
|
|||
|
|
{
|
|||
|
|
strings.Add((expression as ConstantExpression).Value+"");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return strings;
|
|||
|
|
}
|
|||
|
|
public static List<string> GetTopLevelMethodCalls(Expression expression)
|
|||
|
|
{
|
|||
|
|
var methodCalls = new List<string>();
|
|||
|
|
GetTopLevelMethodCalls(expression, methodCalls);
|
|||
|
|
return methodCalls;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public static void GetTopLevelMethodCalls(Expression expression, List<string> methodCalls)
|
|||
|
|
{
|
|||
|
|
if (expression is MethodCallExpression methodCallExpression)
|
|||
|
|
{
|
|||
|
|
methodCalls.Add(methodCallExpression.Method.Name);
|
|||
|
|
if (methodCallExpression.Object is MethodCallExpression parentMethodCallExpression)
|
|||
|
|
{
|
|||
|
|
GetTopLevelMethodCalls(parentMethodCallExpression, methodCalls);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else if (expression is LambdaExpression lambdaExpression)
|
|||
|
|
{
|
|||
|
|
GetTopLevelMethodCalls(lambdaExpression.Body, methodCalls);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public static Dictionary<string, Expression> GetNewExpressionItemList(Expression lamExp)
|
|||
|
|
{
|
|||
|
|
var caseExp = GetLambdaExpressionBody(lamExp);
|
|||
|
|
if (caseExp is MemberInitExpression)
|
|||
|
|
{
|
|||
|
|
return GetMemberBindingItemList((caseExp as MemberInitExpression).Bindings);
|
|||
|
|
}
|
|||
|
|
var exp= caseExp as NewExpression;
|
|||
|
|
if (exp == null)
|
|||
|
|
{
|
|||
|
|
Check.ExceptionEasy("Use Select(it=>new class(){})", "导航查询请使用Select(it=>new class(){})");
|
|||
|
|
}
|
|||
|
|
var dict = new Dictionary<string, Expression>();
|
|||
|
|
|
|||
|
|
for (int i = 0; i < exp.Arguments.Count; i++)
|
|||
|
|
{
|
|||
|
|
var arg = exp.Arguments[i];
|
|||
|
|
var parameterInfo = exp.Constructor.GetParameters()[i];
|
|||
|
|
|
|||
|
|
dict.Add(parameterInfo.Name, arg);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
return dict;
|
|||
|
|
}
|
|||
|
|
public static Dictionary<string, Expression> GetMemberBindingItemList(ReadOnlyCollection<MemberBinding> exp)
|
|||
|
|
{
|
|||
|
|
Dictionary<string, Expression> dict = new Dictionary<string, Expression>();
|
|||
|
|
// 获取MemberInitExpression中的每一个MemberBinding
|
|||
|
|
foreach (var binding in exp)
|
|||
|
|
{
|
|||
|
|
// 判断是MemberAssignment还是MemberListBinding
|
|||
|
|
if (binding is MemberAssignment assignment)
|
|||
|
|
{
|
|||
|
|
// 获取属性名和属性值
|
|||
|
|
string propertyName = assignment.Member.Name;
|
|||
|
|
dict.Add(assignment.Member.Name, assignment.Expression);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
return dict;
|
|||
|
|
}
|
|||
|
|
public static bool ContainsMethodName(BinaryExpression expression, string name)
|
|||
|
|
{
|
|||
|
|
var visitor = new MethodCallExpressionVisitor(name);
|
|||
|
|
var hasMethodCallWithName = visitor.HasMethodCallWithName(expression);
|
|||
|
|
return hasMethodCallWithName;
|
|||
|
|
}
|
|||
|
|
public static bool IsVariable(Expression expr)
|
|||
|
|
{
|
|||
|
|
var ps = new ParameterExpressionVisitor();
|
|||
|
|
ps.Visit(expr);
|
|||
|
|
return ps.Parameters.Count==0;
|
|||
|
|
}
|
|||
|
|
public static List<ParameterExpression> GetParameters(Expression expr)
|
|||
|
|
{
|
|||
|
|
var ps = new ParameterExpressionVisitor();
|
|||
|
|
ps.Visit(expr);
|
|||
|
|
return ps.Parameters;
|
|||
|
|
}
|
|||
|
|
public static bool IsComparisonOperatorBool(BinaryExpression binaryExp)
|
|||
|
|
{
|
|||
|
|
return binaryExp.NodeType.IsIn(ExpressionType.Equal,
|
|||
|
|
ExpressionType.GreaterThan, ExpressionType.GreaterThanOrEqual,
|
|||
|
|
ExpressionType.LessThan, ExpressionType.LessThanOrEqual);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public static string GetOperator(ExpressionType expressiontype)
|
|||
|
|
{
|
|||
|
|
switch (expressiontype)
|
|||
|
|
{
|
|||
|
|
case ExpressionType.And:
|
|||
|
|
return "&";
|
|||
|
|
case ExpressionType.AndAlso:
|
|||
|
|
return "AND";
|
|||
|
|
case ExpressionType.Equal:
|
|||
|
|
return "=";
|
|||
|
|
case ExpressionType.GreaterThan:
|
|||
|
|
return ">";
|
|||
|
|
case ExpressionType.GreaterThanOrEqual:
|
|||
|
|
return ">=";
|
|||
|
|
case ExpressionType.LessThan:
|
|||
|
|
return "<";
|
|||
|
|
case ExpressionType.LessThanOrEqual:
|
|||
|
|
return "<=";
|
|||
|
|
case ExpressionType.NotEqual:
|
|||
|
|
return "<>";
|
|||
|
|
case ExpressionType.Or:
|
|||
|
|
return "|";
|
|||
|
|
case ExpressionType.OrElse:
|
|||
|
|
return "OR";
|
|||
|
|
case ExpressionType.Add:
|
|||
|
|
case ExpressionType.AddChecked:
|
|||
|
|
return "+";
|
|||
|
|
case ExpressionType.Subtract:
|
|||
|
|
case ExpressionType.SubtractChecked:
|
|||
|
|
return "-";
|
|||
|
|
case ExpressionType.Divide:
|
|||
|
|
return "/";
|
|||
|
|
case ExpressionType.Multiply:
|
|||
|
|
case ExpressionType.MultiplyChecked:
|
|||
|
|
return "*";
|
|||
|
|
case ExpressionType.Modulo:
|
|||
|
|
return "%";
|
|||
|
|
case ExpressionType.Coalesce:
|
|||
|
|
throw new Exception("Expression no support ?? ,Use SqlFunc.IsNull");
|
|||
|
|
default:
|
|||
|
|
Check.ThrowNotSupportedException(string.Format(ErrorMessage.OperatorError, expressiontype.ToString()));
|
|||
|
|
return null;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
public static void GetOneToOneInfo<T>(SqlSugarProvider context,Expression<Func<T, object>> LeftObject, out MemberExpression memberExpression, out string navObjectName, out EntityColumnInfo navColumn, out EntityInfo navEntityInfo, out EntityColumnInfo navPkColumn)
|
|||
|
|
{
|
|||
|
|
memberExpression = ((LeftObject as LambdaExpression).Body as MemberExpression);
|
|||
|
|
var listItemType = typeof(T);
|
|||
|
|
var listItemEntity = context.EntityMaintenance.GetEntityInfo(listItemType);
|
|||
|
|
var listPkColumn = listItemEntity.Columns.Where(it => it.IsPrimarykey).FirstOrDefault();
|
|||
|
|
navObjectName = memberExpression.Member.Name;
|
|||
|
|
var navObjectName2 = navObjectName;
|
|||
|
|
var navObjectNamePropety = listItemType.GetProperty(navObjectName);
|
|||
|
|
var navObjectNameColumnInfo = listItemEntity.Columns.First(it => it.PropertyName == navObjectName2);
|
|||
|
|
Check.ExceptionEasy(navObjectNameColumnInfo.Navigat == null, $"{navObjectName} not [Navigat(..)] ", $"{navObjectName} 没有导航特性 [Navigat(..)] ");
|
|||
|
|
Check.ExceptionEasy(navObjectNameColumnInfo.Navigat.NavigatType != NavigateType.OneToOne, $"IncludeLeftJoin can only be one-on-one ", $"IncludeLeftJoin 只能是一对一 ");
|
|||
|
|
navColumn = listItemEntity.Columns.FirstOrDefault(it => it.PropertyName == navObjectNameColumnInfo.Navigat.Name);
|
|||
|
|
Check.ExceptionEasy(navColumn == null, "OneToOne navigation configuration error", $"OneToOne导航配置错误： 实体{ listItemEntity.EntityName } 不存在{navObjectNameColumnInfo.Navigat.Name}");
|
|||
|
|
var navType = navObjectNamePropety.PropertyType;
|
|||
|
|
navEntityInfo = context.EntityMaintenance.GetEntityInfo(navType);
|
|||
|
|
context.InitMappingInfo(navEntityInfo.Type);
|
|||
|
|
navPkColumn = navEntityInfo.Columns.Where(it => it.IsPrimarykey).FirstOrDefault();
|
|||
|
|
Check.ExceptionEasy(navPkColumn == null && navObjectNameColumnInfo.Navigat.Name2 == null, navEntityInfo.EntityName + "need primarykey", navEntityInfo.EntityName + " 需要主键");
|
|||
|
|
if (navObjectNameColumnInfo.Navigat.Name2.HasValue())
|
|||
|
|
{
|
|||
|
|
navPkColumn = navEntityInfo.Columns.Where(it => it.PropertyName == navObjectNameColumnInfo.Navigat.Name2).FirstOrDefault();
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
public static List<ParameterExpression> ExpressionParameters(Expression expression)
|
|||
|
|
{
|
|||
|
|
List<ParameterExpression> parameters = null;
|
|||
|
|
if (expression is LambdaExpression)
|
|||
|
|
{
|
|||
|
|
if ((expression as LambdaExpression).Parameters != null)
|
|||
|
|
{
|
|||
|
|
parameters = (expression as LambdaExpression).Parameters.ToList();
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return parameters;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public static object GetValue(object value,ExpressionContext context)
|
|||
|
|
{
|
|||
|
|
if (value == null) return value;
|
|||
|
|
var type = value.GetType();
|
|||
|
|
if (type.IsEnum() && type != typeof(DateType) && type != typeof(JoinType) && type != typeof(OrderByType))
|
|||
|
|
{
|
|||
|
|
if (context.TableEnumIsString == true)
|
|||
|
|
{
|
|||
|
|
return value.ToString();
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
return Convert.ToInt64(value);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
return value;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public static Expression GetLambdaExpressionBody(Expression expression)
|
|||
|
|
{
|
|||
|
|
Expression newExp = expression;
|
|||
|
|
if (newExp is LambdaExpression)
|
|||
|
|
{
|
|||
|
|
newExp = (newExp as LambdaExpression).Body;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
return newExp;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
public static string GetFirstTypeNameFromExpression(Expression expression)
|
|||
|
|
{
|
|||
|
|
if (expression is LambdaExpression lambda)
|
|||
|
|
{
|
|||
|
|
return GetFirstTypeNameFromExpression(lambda.Body);
|
|||
|
|
}
|
|||
|
|
else if (expression is MemberExpression member)
|
|||
|
|
{
|
|||
|
|
return member.Member.Name;
|
|||
|
|
}
|
|||
|
|
else if (expression is NewExpression newExpr)
|
|||
|
|
{
|
|||
|
|
return newExpr.Type.Name;
|
|||
|
|
}
|
|||
|
|
else if (expression is MethodCallExpression methodCall)
|
|||
|
|
{
|
|||
|
|
return GetFirstTypeNameFromExpression(methodCall.Arguments.FirstOrDefault());
|
|||
|
|
}
|
|||
|
|
return "";
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public static string GetMethodName(Expression expression)
|
|||
|
|
{
|
|||
|
|
if (expression is MethodCallExpression)
|
|||
|
|
{
|
|||
|
|
return (expression as MethodCallExpression).Method.Name;
|
|||
|
|
}
|
|||
|
|
return null;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public static Type GetMemberInfoType(MemberInfo member)
|
|||
|
|
{
|
|||
|
|
switch (member.MemberType)
|
|||
|
|
{
|
|||
|
|
case MemberTypes.Event:
|
|||
|
|
return ((EventInfo)member).EventHandlerType;
|
|||
|
|
case MemberTypes.Field:
|
|||
|
|
return ((FieldInfo)member).FieldType;
|
|||
|
|
case MemberTypes.Method:
|
|||
|
|
return ((MethodInfo)member).ReturnType;
|
|||
|
|
case MemberTypes.Property:
|
|||
|
|
return ((PropertyInfo)member).PropertyType;
|
|||
|
|
default:
|
|||
|
|
return null;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
public static bool IsLogicOperator(string operatorValue)
|
|||
|
|
{
|
|||
|
|
return operatorValue == "&&" || operatorValue == "||" || operatorValue == "AND" || operatorValue == "OR";
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public static bool IsLogicOperator(Expression expression)
|
|||
|
|
{
|
|||
|
|
return expression.NodeType == ExpressionType.And ||
|
|||
|
|
expression.NodeType == ExpressionType.AndAlso ||
|
|||
|
|
expression.NodeType == ExpressionType.Or ||
|
|||
|
|
expression.NodeType == ExpressionType.OrElse;
|
|||
|
|
}
|
|||
|
|
public static bool IsComparisonOperator(Expression expression)
|
|||
|
|
{
|
|||
|
|
return expression.NodeType != ExpressionType.And &&
|
|||
|
|
expression.NodeType != ExpressionType.AndAlso &&
|
|||
|
|
expression.NodeType != ExpressionType.Or &&
|
|||
|
|
expression.NodeType != ExpressionType.OrElse;
|
|||
|
|
}
|
|||
|
|
public static bool IsEqualOrLtOrGt(Expression expression)
|
|||
|
|
{
|
|||
|
|
return expression.NodeType== ExpressionType.Equal||
|
|||
|
|
expression.NodeType == ExpressionType.GreaterThan||
|
|||
|
|
expression.NodeType == ExpressionType.LessThan||
|
|||
|
|
expression.NodeType == ExpressionType.LessThanOrEqual ||
|
|||
|
|
expression.NodeType == ExpressionType.GreaterThanOrEqual
|
|||
|
|
;
|
|||
|
|
}
|
|||
|
|
public static object GetMemberValue(MemberInfo member, Expression expression)
|
|||
|
|
{
|
|||
|
|
var rootExpression = expression as MemberExpression;
|
|||
|
|
var memberInfos = new Stack<MemberInfo>();
|
|||
|
|
var fieldInfo = member as System.Reflection.FieldInfo;
|
|||
|
|
object reval = null;
|
|||
|
|
MemberExpression memberExpr = null;
|
|||
|
|
while (expression is MemberExpression)
|
|||
|
|
{
|
|||
|
|
memberExpr = expression as MemberExpression;
|
|||
|
|
memberInfos.Push(memberExpr.Member);
|
|||
|
|
if (memberExpr.Expression == null)
|
|||
|
|
{
|
|||
|
|
var isProperty = memberExpr.Member.MemberType == MemberTypes.Property;
|
|||
|
|
var isField = memberExpr.Member.MemberType == MemberTypes.Field;
|
|||
|
|
if (isProperty)
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
reval = GetPropertyValue(memberExpr);
|
|||
|
|
}
|
|||
|
|
catch
|
|||
|
|
{
|
|||
|
|
reval = null;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else if (isField)
|
|||
|
|
{
|
|||
|
|
reval = GetFiledValue(memberExpr);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
if (memberExpr.Expression == null)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
expression = memberExpr.Expression;
|
|||
|
|
}
|
|||
|
|
// fetch the root object reference:
|
|||
|
|
var constExpr = expression as ConstantExpression;
|
|||
|
|
if (constExpr == null)
|
|||
|
|
{
|
|||
|
|
return DynamicInvoke(rootExpression);
|
|||
|
|
}
|
|||
|
|
object objReference = constExpr.Value;
|
|||
|
|
// "ascend" back whence we came from and resolve object references along the way:
|
|||
|
|
while (memberInfos.Count > 0) // or some other break condition
|
|||
|
|
{
|
|||
|
|
var mi = memberInfos.Pop();
|
|||
|
|
if (mi.MemberType == MemberTypes.Property)
|
|||
|
|
{
|
|||
|
|
if (objReference == null)
|
|||
|
|
{
|
|||
|
|
Check.ExceptionEasy($"Expression error {rootExpression?.ToString()} expression, An empty reference appears in the expression to check if the parameter is null ", $"表达式错误 {rootExpression?.ToString()} 表达式中出现了空引用 检查参数是否为null ");
|
|||
|
|
}
|
|||
|
|
var objProp = objReference.GetType().GetProperties().Where(it=>it.Name== mi.Name).FirstOrDefault();
|
|||
|
|
if (objProp == null)
|
|||
|
|
{
|
|||
|
|
objReference = DynamicInvoke(expression, rootExpression == null ? memberExpr : rootExpression);
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
objReference = objProp.GetValue(objReference, null);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else if (mi.MemberType == MemberTypes.Field)
|
|||
|
|
{
|
|||
|
|
var objField = objReference.GetType().GetField(mi.Name);
|
|||
|
|
if (objField == null)
|
|||
|
|
{
|
|||
|
|
objReference = DynamicInvoke(expression, rootExpression == null ? memberExpr : rootExpression);
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
objReference = objField.GetValue(objReference);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
reval = objReference;
|
|||
|
|
return reval;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
internal static Expression RemoveConvert(Expression item)
|
|||
|
|
{
|
|||
|
|
for (int i = 0; i < 10; i++)
|
|||
|
|
{
|
|||
|
|
if ((item is UnaryExpression) && (item as UnaryExpression).NodeType == ExpressionType.Convert)
|
|||
|
|
{
|
|||
|
|
item = (item as UnaryExpression).Operand;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
break;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return item;
|
|||
|
|
}
|
|||
|
|
internal static Expression RemoveConvertThanOne(Expression item)
|
|||
|
|
{
|
|||
|
|
for (int i = 0; i < 10; i++)
|
|||
|
|
{
|
|||
|
|
if ((item is UnaryExpression)
|
|||
|
|
&& (item as UnaryExpression).NodeType == ExpressionType.Convert
|
|||
|
|
&& (item as UnaryExpression).Operand is UnaryExpression)
|
|||
|
|
{
|
|||
|
|
item = (item as UnaryExpression).Operand;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
break;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return item;
|
|||
|
|
}
|
|||
|
|
public static string GetMemberName(Expression expression)
|
|||
|
|
{
|
|||
|
|
if (expression is LambdaExpression)
|
|||
|
|
{
|
|||
|
|
expression = (expression as LambdaExpression).Body;
|
|||
|
|
}
|
|||
|
|
if (expression is UnaryExpression)
|
|||
|
|
{
|
|||
|
|
expression = ((UnaryExpression)expression).Operand;
|
|||
|
|
}
|
|||
|
|
var member = (expression as MemberExpression)?.Member?.Name;
|
|||
|
|
return member;
|
|||
|
|
}
|
|||
|
|
internal static object GetExpressionValue(Expression expression)
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
if (expression is ConstantExpression)
|
|||
|
|
{
|
|||
|
|
return (expression as ConstantExpression).Value;
|
|||
|
|
}
|
|||
|
|
else if (expression is MethodCallExpression)
|
|||
|
|
{
|
|||
|
|
return LambdaExpression.Lambda(expression).Compile().DynamicInvoke();
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
return GetMemberValue((expression as MemberExpression).Member, expression);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
catch
|
|||
|
|
{
|
|||
|
|
return LambdaExpression.Lambda(expression).Compile().DynamicInvoke();
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public static object GetFiledValue(MemberExpression memberExpr)
|
|||
|
|
{
|
|||
|
|
if (!(memberExpr.Member is FieldInfo))
|
|||
|
|
{
|
|||
|
|
return DynamicInvoke(memberExpr);
|
|||
|
|
}
|
|||
|
|
object reval = null;
|
|||
|
|
FieldInfo field = (FieldInfo)memberExpr.Member;
|
|||
|
|
Check.Exception(field.IsPrivate, string.Format(" Field \"{0}\" can't be private ", field.Name));
|
|||
|
|
reval = field.GetValue(memberExpr.Member);
|
|||
|
|
if (reval != null && reval.GetType().IsClass() && reval.GetType() != UtilConstants.StringType)
|
|||
|
|
{
|
|||
|
|
var fieldName = memberExpr.Member.Name;
|
|||
|
|
var proInfo = reval.GetType().GetProperty(fieldName);
|
|||
|
|
if (proInfo != null)
|
|||
|
|
{
|
|||
|
|
reval = proInfo.GetValue(reval, null);
|
|||
|
|
}
|
|||
|
|
var fieInfo = reval.GetType().GetField(fieldName);
|
|||
|
|
if (fieInfo != null)
|
|||
|
|
{
|
|||
|
|
reval = fieInfo.GetValue(reval);
|
|||
|
|
}
|
|||
|
|
if (fieInfo == null && proInfo == null)
|
|||
|
|
{
|
|||
|
|
Check.Exception(field.IsPrivate, string.Format(" Field \"{0}\" can't be private ", field.Name));
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return reval;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
public static bool IsConstExpression(MemberExpression memberExpr)
|
|||
|
|
{
|
|||
|
|
var result = false;
|
|||
|
|
while (memberExpr != null && memberExpr.Expression != null)
|
|||
|
|
{
|
|||
|
|
var isConst = memberExpr.Expression is ConstantExpression;
|
|||
|
|
if (isConst)
|
|||
|
|
{
|
|||
|
|
result = true;
|
|||
|
|
break;
|
|||
|
|
}
|
|||
|
|
else if (memberExpr.Expression is BinaryExpression&&(memberExpr.Expression as BinaryExpression).NodeType==ExpressionType.ArrayIndex)
|
|||
|
|
{
|
|||
|
|
result = true;
|
|||
|
|
break;
|
|||
|
|
}
|
|||
|
|
memberExpr = memberExpr.Expression as MemberExpression;
|
|||
|
|
}
|
|||
|
|
return result;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public static object GetPropertyValue(MemberExpression memberExpr)
|
|||
|
|
{
|
|||
|
|
if (!(memberExpr.Member is PropertyInfo))
|
|||
|
|
{
|
|||
|
|
return DynamicInvoke(memberExpr);
|
|||
|
|
}
|
|||
|
|
object reval = null;
|
|||
|
|
PropertyInfo pro = (PropertyInfo)memberExpr.Member;
|
|||
|
|
reval = pro.GetValue(memberExpr.Member, null);
|
|||
|
|
if (reval != null && reval.GetType().IsClass() && reval.GetType() != UtilConstants.StringType)
|
|||
|
|
{
|
|||
|
|
var fieldName = memberExpr.Member.Name;
|
|||
|
|
var proInfo = reval.GetType().GetProperty(fieldName);
|
|||
|
|
if (proInfo != null)
|
|||
|
|
{
|
|||
|
|
reval = proInfo.GetValue(reval, null);
|
|||
|
|
}
|
|||
|
|
var fieInfo = reval.GetType().GetField(fieldName);
|
|||
|
|
if (fieInfo != null)
|
|||
|
|
{
|
|||
|
|
reval = fieInfo.GetValue(reval);
|
|||
|
|
}
|
|||
|
|
if (fieInfo == null && proInfo == null&& !reval.GetType().FullName.IsCollectionsList())
|
|||
|
|
{
|
|||
|
|
Check.Exception(true, string.Format(" Property \"{0}\" can't be private ", pro.Name));
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return reval;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public static object DynamicInvoke(Expression expression, MemberExpression memberExpression = null)
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
object value = Expression.Lambda(expression).Compile().DynamicInvoke();
|
|||
|
|
if (value != null && value.GetType().IsClass() && value.GetType() != UtilConstants.StringType && memberExpression != null)
|
|||
|
|
{
|
|||
|
|
value = Expression.Lambda(memberExpression).Compile().DynamicInvoke();
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
return value;
|
|||
|
|
}
|
|||
|
|
catch (InvalidOperationException ex)
|
|||
|
|
{
|
|||
|
|
return new MapperExpressionResolve(expression,ex).GetSql(); ;
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
throw new Exception("No support "+expression.ToString()+" "+ex.Message);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public static Type GetPropertyOrFieldType(MemberInfo propertyOrField)
|
|||
|
|
{
|
|||
|
|
if (propertyOrField.MemberType == MemberTypes.Property)
|
|||
|
|
return ((PropertyInfo)propertyOrField).PropertyType;
|
|||
|
|
if (propertyOrField.MemberType == MemberTypes.Field)
|
|||
|
|
return ((FieldInfo)propertyOrField).FieldType;
|
|||
|
|
throw new NotSupportedException();
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public static bool IsEntity(Type type)
|
|||
|
|
{
|
|||
|
|
return type.IsClass() && type != UtilConstants.StringType;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public static bool IsValueType(Type type)
|
|||
|
|
{
|
|||
|
|
return !IsEntity(type);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public static bool IsUnConvertExpress(Expression item)
|
|||
|
|
{
|
|||
|
|
return item is UnaryExpression && item.NodeType == ExpressionType.Convert;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
internal static List<NewExpressionInfo> GetNewexpressionInfos(Expression item,ExpressionContext context, BaseResolve baseResolve)
|
|||
|
|
{
|
|||
|
|
List<NewExpressionInfo> result = new List<NewExpressionInfo>();
|
|||
|
|
foreach (MemberBinding binding in ((MemberInitExpression)item).Bindings)
|
|||
|
|
{
|
|||
|
|
if (binding.BindingType != MemberBindingType.Assignment)
|
|||
|
|
{
|
|||
|
|
throw new NotSupportedException();
|
|||
|
|
}
|
|||
|
|
MemberAssignment memberAssignment = (MemberAssignment)binding;
|
|||
|
|
NewExpressionInfo additem = new NewExpressionInfo();
|
|||
|
|
if (memberAssignment.Expression is MemberExpression)
|
|||
|
|
{
|
|||
|
|
additem.LeftNameName = memberAssignment.Member.Name;
|
|||
|
|
var member = (memberAssignment.Expression as MemberExpression).Expression;
|
|||
|
|
additem.ShortName = member + "";
|
|||
|
|
additem.RightName = (memberAssignment.Expression as MemberExpression).Member.Name;
|
|||
|
|
additem.RightDbName = context.GetDbColumnName(member.Type.Name, additem.RightName);
|
|||
|
|
if(ExpressionTool.IsNavMember(context, member))
|
|||
|
|
{
|
|||
|
|
additem.RightDbName=additem.RightName = baseResolve.GetNewExpressionValue(memberAssignment.Expression);
|
|||
|
|
}
|
|||
|
|
result.Add(additem);
|
|||
|
|
}
|
|||
|
|
else if (memberAssignment.Expression is ConstantExpression)
|
|||
|
|
{
|
|||
|
|
var value = ((ConstantExpression)memberAssignment.Expression).Value;
|
|||
|
|
//var leftInfo = keys[i];
|
|||
|
|
additem.Type = nameof(ConstantExpression);
|
|||
|
|
additem.RightName = memberAssignment.Member.Name;
|
|||
|
|
additem.ShortName = memberAssignment.Member.Name;
|
|||
|
|
additem.RightName = memberAssignment.Member.Name;
|
|||
|
|
additem.LeftNameName = memberAssignment.Member.Name;
|
|||
|
|
additem.RightDbName = UtilMethods.GetSqlValue(value);
|
|||
|
|
//additem.Value = "";
|
|||
|
|
result.Add(additem);
|
|||
|
|
}
|
|||
|
|
else if (memberAssignment.Expression is MemberInitExpression|| memberAssignment.Expression is NewExpression)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
var dic = ExpressionTool.GetNewExpressionItemList(memberAssignment.Expression);
|
|||
|
|
foreach (var kv in dic)
|
|||
|
|
{
|
|||
|
|
additem = new NewExpressionInfo();
|
|||
|
|
//var leftInfo = keys[i];
|
|||
|
|
additem.Type = nameof(NewExpression);
|
|||
|
|
additem.RightName = kv.Key;
|
|||
|
|
additem.ShortName = ExpressionTool.GetParameters(kv.Value).First().Name;
|
|||
|
|
additem.RightName = kv.Key;
|
|||
|
|
additem.LeftNameName = memberAssignment.Member.Name + "." + kv.Key;
|
|||
|
|
additem.RightDbName = kv.Key;
|
|||
|
|
//additem.Value = "";
|
|||
|
|
result.Add(additem);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
var value = baseResolve.GetNewExpressionValue(memberAssignment.Expression);
|
|||
|
|
//var leftInfo = keys[i];
|
|||
|
|
additem.Type = nameof(ConstantExpression);
|
|||
|
|
additem.RightName = memberAssignment.Member.Name;
|
|||
|
|
additem.ShortName = memberAssignment.Member.Name;
|
|||
|
|
additem.RightName = memberAssignment.Member.Name;
|
|||
|
|
additem.LeftNameName = memberAssignment.Member.Name;
|
|||
|
|
additem.RightDbName = value;
|
|||
|
|
//additem.Value = "";
|
|||
|
|
result.Add(additem);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
return result;
|
|||
|
|
}
|
|||
|
|
internal static List<NewExpressionInfo> GetNewDynamicexpressionInfos(Expression item, ExpressionContext context, BaseResolve baseResolve)
|
|||
|
|
{
|
|||
|
|
List<NewExpressionInfo> result = new List<NewExpressionInfo>();
|
|||
|
|
int i = 0;
|
|||
|
|
foreach (var binding in ((NewExpression)item).Arguments)
|
|||
|
|
{
|
|||
|
|
NewExpressionInfo additem = new NewExpressionInfo();
|
|||
|
|
var keys = ((NewExpression)item).Members;
|
|||
|
|
if (binding is MemberExpression)
|
|||
|
|
{
|
|||
|
|
var member = (MemberExpression)binding;
|
|||
|
|
var entityName = member.Expression?.Type?.Name;
|
|||
|
|
//var memberAssignment = binding;
|
|||
|
|
//NewExpressionInfo additem = new NewExpressionInfo();
|
|||
|
|
additem.RightName = member.Member.Name;
|
|||
|
|
additem.ShortName = member.Expression + "";
|
|||
|
|
additem.RightName = member.Member.Name;
|
|||
|
|
additem.RightDbName = context.GetDbColumnName(entityName, additem.RightName);
|
|||
|
|
var isNavMember = member.Expression != null
|
|||
|
|
&& ExpressionTool.IsNavMember(context, member.Expression);
|
|||
|
|
additem.LeftNameName = member.Member.Name;
|
|||
|
|
if (isNavMember && (context?.SugarContext?.QueryBuilder?.JoinQueryInfos?.Count()??0)==0)
|
|||
|
|
{
|
|||
|
|
var exp = context.GetCopyContextWithMapping();
|
|||
|
|
exp.Resolve(member, ResolveExpressType.FieldSingle);
|
|||
|
|
var sql = exp.Result.GetResultString();
|
|||
|
|
if (context.IsSingle&& context.CurrentShortName.IsNullOrEmpty())
|
|||
|
|
{
|
|||
|
|
context.SingleTableNameSubqueryShortName=ExpressionTool.GetParameters(member)?.FirstOrDefault()?.Name;
|
|||
|
|
}
|
|||
|
|
additem.RightDbName = sql;
|
|||
|
|
}
|
|||
|
|
else if (isNavMember && context?.SugarContext?.QueryBuilder?.JoinQueryInfos?.Any(it=>it.ShortName?.StartsWith("pnv_" + ExpressionTool.GetMemberName(member.Expression)) ==true)==true)
|
|||
|
|
{
|
|||
|
|
additem.ShortName = "pnv_"+ExpressionTool.GetMemberName(member.Expression);
|
|||
|
|
}
|
|||
|
|
//additem.Value = "";
|
|||
|
|
result.Add(additem);
|
|||
|
|
}
|
|||
|
|
else if (binding is ConstantExpression)
|
|||
|
|
{
|
|||
|
|
var value = ((ConstantExpression)binding).Value;
|
|||
|
|
var leftInfo = keys[i];
|
|||
|
|
additem.Type = nameof(ConstantExpression);
|
|||
|
|
additem.RightName = leftInfo.Name;
|
|||
|
|
additem.ShortName = leftInfo.Name;
|
|||
|
|
additem.RightName = leftInfo.Name;
|
|||
|
|
additem.LeftNameName = leftInfo.Name;
|
|||
|
|
additem.RightDbName = UtilMethods.GetSqlValue(value);
|
|||
|
|
//additem.Value = "";
|
|||
|
|
result.Add(additem);
|
|||
|
|
}
|
|||
|
|
else if (binding is MemberInitExpression || binding is NewExpression)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
var dic = ExpressionTool.GetNewExpressionItemList(binding);
|
|||
|
|
foreach (var kv in dic)
|
|||
|
|
{
|
|||
|
|
additem = new NewExpressionInfo();
|
|||
|
|
//var leftInfo = keys[i];
|
|||
|
|
additem.Type = nameof(NewExpression);
|
|||
|
|
additem.RightName = kv.Key;
|
|||
|
|
additem.ShortName = ExpressionTool.GetParameters(kv.Value).First().Name;
|
|||
|
|
additem.RightName = kv.Key;
|
|||
|
|
additem.LeftNameName = keys[i].Name+ "." + kv.Key;
|
|||
|
|
additem.RightDbName = kv.Key;
|
|||
|
|
//additem.Value = "";
|
|||
|
|
result.Add(additem);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
var value = baseResolve.GetNewExpressionValue(binding);
|
|||
|
|
var leftInfo = keys[i];
|
|||
|
|
additem.Type = nameof(ConstantExpression);
|
|||
|
|
additem.RightName = leftInfo.Name;
|
|||
|
|
additem.ShortName = leftInfo.Name;
|
|||
|
|
additem.RightName = leftInfo.Name;
|
|||
|
|
additem.LeftNameName = leftInfo.Name;
|
|||
|
|
additem.RightDbName = value;
|
|||
|
|
//additem.Value = "";
|
|||
|
|
result.Add(additem);
|
|||
|
|
}
|
|||
|
|
i++;
|
|||
|
|
}
|
|||
|
|
return result;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
internal static bool IsSubQuery(Expression it)
|
|||
|
|
{
|
|||
|
|
if (it is MethodCallExpression)
|
|||
|
|
{
|
|||
|
|
var method = (MethodCallExpression)it;
|
|||
|
|
if (method.Object != null && method.Object.Type.Name.StartsWith("Subquery"))
|
|||
|
|
{
|
|||
|
|
return true;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return false;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
internal static bool IsIsNullSubQuery(Expression it)
|
|||
|
|
{
|
|||
|
|
if (it is MethodCallExpression)
|
|||
|
|
{
|
|||
|
|
var method = (MethodCallExpression)it;
|
|||
|
|
if (method.Method.Name == "IsNull")
|
|||
|
|
{
|
|||
|
|
if (method.Arguments.Count==2&&IsSubQuery(method.Arguments[0]))
|
|||
|
|
{
|
|||
|
|
return true;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return false;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
internal static bool IsMemberInit(object selectValue)
|
|||
|
|
{
|
|||
|
|
var result = false;
|
|||
|
|
if (selectValue is Expression)
|
|||
|
|
{
|
|||
|
|
if (selectValue is MemberInitExpression)
|
|||
|
|
{
|
|||
|
|
result = true;
|
|||
|
|
}
|
|||
|
|
else if (selectValue is LambdaExpression)
|
|||
|
|
{
|
|||
|
|
var lambda = (LambdaExpression)selectValue;
|
|||
|
|
if (lambda.Body is MemberInitExpression)
|
|||
|
|
{
|
|||
|
|
result = true;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return result;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
internal static MemberInitExpression GetMemberInit(object selectValue)
|
|||
|
|
{
|
|||
|
|
MemberInitExpression result = null;
|
|||
|
|
if (selectValue is Expression)
|
|||
|
|
{
|
|||
|
|
if (selectValue is MemberInitExpression)
|
|||
|
|
{
|
|||
|
|
result = (MemberInitExpression)selectValue;
|
|||
|
|
}
|
|||
|
|
else if (selectValue is LambdaExpression)
|
|||
|
|
{
|
|||
|
|
var lambda = (LambdaExpression)selectValue;
|
|||
|
|
if (lambda.Body is MemberInitExpression)
|
|||
|
|
{
|
|||
|
|
result = (MemberInitExpression)lambda.Body;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return result;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
public static bool IsNegate(Expression exp)
|
|||
|
|
{
|
|||
|
|
return exp is UnaryExpression && exp.NodeType == ExpressionType.Negate;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public static bool GetIsLength(Expression item)
|
|||
|
|
{
|
|||
|
|
var isLength=(item is MemberExpression) && ((item as MemberExpression).Member.Name == "Length");
|
|||
|
|
if (isLength)
|
|||
|
|
{
|
|||
|
|
var exp=(item as MemberExpression).Expression;
|
|||
|
|
if (exp == null)
|
|||
|
|
{
|
|||
|
|
return false;
|
|||
|
|
}
|
|||
|
|
else if (exp.Type == UtilConstants.StringType&&item.Type==UtilConstants.IntType)
|
|||
|
|
{
|
|||
|
|
return true;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
return false;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
return false;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|