protected object VisitMember(MemberExpression m, bool columnOnly) { try { if (m.Expression != null && m.Expression.NodeType == ExpressionType.Constant && (_overridedNodeType == null)) { VisitConstantFixed(m.Expression as ConstantExpression, m.Member?.Name); return(m); } else if (m.Expression != null && (m.Expression.NodeType == ExpressionType.Parameter || (m.ToString().EndsWith(".HasValue") && m.Expression.NodeType == ExpressionType.MemberAccess)) && (_overridedNodeType == null)) { var hasValueAttr = m.ToString().EndsWith(".HasValue"); _overridedNodeType = null; var cl = hasValueAttr ? (m.Expression as MemberExpression).Expression.Type : m.Expression.Type; var prop = DeepCloner.GetFastDeepClonerProperties(cl).First(x => x.Name == (hasValueAttr ? (m.Expression as MemberExpression).Member.Name : m.Member.Name)); var name = prop.GetPropertyName(); var table = cl.TableName(); var columnName = string.Format("[{0}].[{1}]", table, name).CleanValidSqlName(DataBaseTypes); var dataEncode = prop.GetCustomAttribute <DataEncode>(); if (columnOnly) { return(columnName); } bool isNot = sb.ToString().EndsWith("NOT "); if (prop.PropertyType.IsEnum && prop.ContainAttribute <Stringify>()) { if (!SavedTypes.ContainsKey(prop.FullName)) { SavedTypes.TryAdd(prop.FullName, prop.PropertyType); } columnName += stringyFy.Replace("#", prop.FullName); } if (isNot) { if (!hasValueAttr) { columnName = $"(CASE WHEN { columnName } = 0 THEN 1 ELSE 0 END) {boolString.Replace("#", "0")}"; } else { columnName = $"(CASE WHEN {columnName} IS NULL THEN 1 ELSE 0 END) {boolString.Replace("#", "0")}"; } } else if (hasValueAttr) { columnName = $"(CASE WHEN {columnName} IS NULL THEN 0 ELSE 1 END) {boolString.Replace("#", "1")}"; } else if (prop.PropertyType == typeof(bool) || prop.PropertyType == typeof(bool?)) { columnName = columnName + boolString.Replace("#", "1"); } if (dataEncode != null) { columnName = columnName + dataEncodeString.Replace("#", dataEncode.Key + "|" + ((int)dataEncode.KeySize).ToString()); } sb.Append(columnName); return(m); } else if (m.Expression != null && (m.Expression.NodeType == ExpressionType.MemberAccess)) { _overridedNodeType = null; var key = string.Join("", m.ToString().Split('.').Take(m.ToString().Split('.').Length - 1)); var cl = m.Expression.Type; var prop = DeepCloner.GetFastDeepClonerProperties(cl).First(x => x.Name == m.Member.Name); var name = prop.GetPropertyName(); var table = cl.TableName(); var randomTableName = JoinClauses.ContainsKey(key) ? JoinClauses[key].Item1 : RandomKey(); var primaryId = DeepCloner.GetFastDeepClonerProperties(cl).First(x => x.ContainAttribute <PrimaryKey>()).GetPropertyName(); var columnName = string.Format("[{0}].[{1}]", randomTableName, name).CleanValidSqlName(DataBaseTypes); if (columnOnly) { return(columnName); } sb.Append(columnName); if (JoinClauses.ContainsKey(key)) { return(m); } // Ok lets build inner join var parentType = (m.Expression as MemberExpression).Expression.Type; var parentTable = parentType.TableName(); prop = DeepCloner.GetFastDeepClonerProperties(parentType).FirstOrDefault(x => x.ContainAttribute <ForeignKey>() && x.GetCustomAttribute <ForeignKey>().Type == cl); var v = ""; if (prop != null) { v += string.Format("LEFT JOIN [{0}] {1} ON [{2}].[{3}] = [{4}].[{5}]", table, randomTableName, randomTableName, primaryId, parentTable, prop.GetPropertyName()).CleanValidSqlName(DataBaseTypes); } else { prop = DeepCloner.GetFastDeepClonerProperties(cl).FirstOrDefault(x => x.ContainAttribute <ForeignKey>() && x.GetCustomAttribute <ForeignKey>().Type == parentType); if (prop != null) { v += string.Format("LEFT JOIN [{0}] {1} ON [{2}].[{3}] = [{4}].[{5}]", table, randomTableName, randomTableName, prop.GetPropertyName(), parentTable, primaryId).CleanValidSqlName(DataBaseTypes); } } if (string.IsNullOrEmpty(v)) { sb = sb.Remove(sb.Length - columnName.Length, columnName.Length); sb.Append(ValuetoSql(GetValue(m))); } else { JoinClauses.TryAdd(key, new Tuple <string, string>(randomTableName, v)); } return(m); } else if (m.Expression != null && _overridedNodeType == ExpressionType.MemberAccess) { _overridedNodeType = null; var key = string.Join("", m.ToString().Split('.').Take(m.ToString().Split('.').Length - 1)); var cl = m.Expression.Type; var prop = DeepCloner.GetFastDeepClonerProperties(cl).First(x => x.Name == m.Member.Name); var table = cl.TableName(); var randomTableName = JoinClauses.ContainsKey(key) ? JoinClauses[key].Item1 : RandomKey(); var primaryId = DeepCloner.GetFastDeepClonerProperties(cl).First(x => x.ContainAttribute <PrimaryKey>()).GetPropertyName(); if (JoinClauses.ContainsKey(key)) { return(m); } // Ok lets build inner join var parentType = (m as MemberExpression).Type.GetActualType(); var parentTable = parentType.TableName(); prop = DeepCloner.GetFastDeepClonerProperties(parentType).FirstOrDefault(x => x.ContainAttribute <ForeignKey>() && x.GetCustomAttribute <ForeignKey>().Type == cl); var v = ""; if (prop != null) { v += string.Format("INNER JOIN [{0}] {1} ON [{2}].[{3}] = [{4}].[{5}]", parentTable, randomTableName, table, primaryId, randomTableName, prop.GetPropertyName()).CleanValidSqlName(DataBaseTypes); } else { throw new NotSupportedException(string.Format("Expression STRUCTURE IS NOT SUPPORTED MEMBER{0} for EntityWorker", m.Member.Name)); } if (!string.IsNullOrEmpty(v)) { JoinClauses.TryAdd(key, new Tuple <string, string>(randomTableName, v)); } return(m); } } catch { throw new NotSupportedException(string.Format("Expression '{0}' is not supported", m.ToString())); } if (m.Type.IsInternalType() && m.Expression.NodeType == ExpressionType.Call) { sb.Append(ValuetoSql(Expression.Lambda(m).Compile().DynamicInvoke())); return(m); } throw new NotSupportedException(string.Format("The member '{0}' is not supported", m.Member.Name)); }
protected dynamic VisitMember(MemberExpression m, bool columnOnly) { if (m.Expression != null && m.Expression.NodeType == ExpressionType.Constant && (_overridedNodeType == null)) { VisitConstantFixed(m.Expression as ConstantExpression, m.Member?.Name); return(m); } else if (m.Expression != null && m.Expression.NodeType == ExpressionType.Parameter && (_overridedNodeType == null)) { _overridedNodeType = null; var cl = m.Expression.Type; var prop = FastDeepCloner.DeepCloner.GetFastDeepClonerProperties(cl).First(x => x.Name == m.Member.Name); var name = prop.GetPropertyName(); var table = cl.GetCustomAttribute <Table>()?.Name ?? cl.Name; var columnName = string.Format("[{0}].[{1}]", table, name); if (columnOnly) { return(columnName); } sb.Append(columnName); return(m); } else if (m.Expression != null && (m.Expression.NodeType == ExpressionType.MemberAccess)) { _overridedNodeType = null; var key = string.Join("", m.ToString().Split('.').Take(m.ToString().Split('.').Length - 1)); var cl = m.Expression.Type; var prop = FastDeepCloner.DeepCloner.GetFastDeepClonerProperties(cl).First(x => x.Name == m.Member.Name); var name = prop.GetPropertyName(); var table = cl.GetCustomAttribute <Table>()?.Name ?? cl.Name; var randomTableName = JoinClauses.ContainsKey(key) ? JoinClauses[key].Item1 : RandomKey(); var primaryId = FastDeepCloner.DeepCloner.GetFastDeepClonerProperties(cl).First(x => x.ContainAttribute <PrimaryKey>()).GetPropertyName(); var columnName = string.Format("[{0}].[{1}]", randomTableName, name); if (columnOnly) { return(columnName); } sb.Append(columnName); if (JoinClauses.ContainsKey(key)) { return(m); } // Ok lets build inner join var parentType = (m.Expression as MemberExpression).Expression.Type; var parentTable = parentType.GetCustomAttribute <Table>()?.Name ?? parentType.Name; prop = FastDeepCloner.DeepCloner.GetFastDeepClonerProperties(parentType).FirstOrDefault(x => x.ContainAttribute <ForeignKey>() && x.GetCustomAttribute <ForeignKey>().Type == cl); var v = ""; if (prop != null) { v += string.Format("LEFT JOIN [{0}] {1} ON [{2}].[{3}] = [{4}].[{5}]", table, randomTableName, randomTableName, primaryId, parentTable, prop.GetPropertyName()); } else { prop = FastDeepCloner.DeepCloner.GetFastDeepClonerProperties(cl).FirstOrDefault(x => x.ContainAttribute <ForeignKey>() && x.GetCustomAttribute <ForeignKey>().Type == parentType); if (prop != null) { v += string.Format("LEFT JOIN [{0}] {1} ON [{2}].[{3}] = [{4}].[{5}]", table, randomTableName, randomTableName, prop.GetPropertyName(), parentTable, primaryId); } } JoinClauses.Add(key, new Tuple <string, string>(randomTableName, v)); return(m); } else if (m.Expression != null && _overridedNodeType == ExpressionType.MemberAccess) { _overridedNodeType = null; var key = string.Join("", m.ToString().Split('.').Take(m.ToString().Split('.').Length - 1)); var cl = m.Expression.Type; var prop = FastDeepCloner.DeepCloner.GetFastDeepClonerProperties(cl).First(x => x.Name == m.Member.Name); var table = cl.GetCustomAttribute <Table>()?.Name ?? cl.Name; var randomTableName = JoinClauses.ContainsKey(key) ? JoinClauses[key].Item1 : RandomKey(); var primaryId = FastDeepCloner.DeepCloner.GetFastDeepClonerProperties(cl).First(x => x.ContainAttribute <PrimaryKey>()).GetPropertyName(); if (JoinClauses.ContainsKey(key)) { return(m); } // Ok lets build inner join var parentType = (m as MemberExpression).Type.GetActualType(); var parentTable = parentType.GetCustomAttribute <Table>()?.Name ?? parentType.Name; prop = FastDeepCloner.DeepCloner.GetFastDeepClonerProperties(parentType).FirstOrDefault(x => x.ContainAttribute <ForeignKey>() && x.GetCustomAttribute <ForeignKey>().Type == cl); var v = ""; if (prop != null) { v += string.Format("INNER JOIN [{0}] {1} ON [{2}].[{3}] = [{4}].[{5}]", parentTable, randomTableName, table, primaryId, randomTableName, prop.GetPropertyName()); } else { throw new NotSupportedException(string.Format("CLASS STRUCTURE IS NOT SUPPORTED MEMBER{0}", m.Member.Name)); } if (!string.IsNullOrEmpty(v)) { JoinClauses.Add(key, new Tuple <string, string>(randomTableName, v)); } return(m); } throw new NotSupportedException(string.Format("The member '{0}' is not supported", m.Member.Name)); }