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;
            }
        }
    }
}