protected override Expression VisitConstant(ConstantExpression node)
{
var table = EntityConfigurationManager.GetTable(node.Type.GetGenericArguments()[0]);
ExtraObject = table.Name;
return(base.VisitConstant(node));
}
private SchemaModel.Table GetTable()
{
MemberExpression expression;
Label_0000:
expression = (MemberExpression)_memberInfos.Peek();
_tableMember = expression.Member;
Type fieldType = null;
if (_tableMember.MemberType == MemberTypes.Field)
{
fieldType = ((FieldInfo)_tableMember).FieldType;
}
else
{
fieldType = ((PropertyInfo)_tableMember).PropertyType;
}
if (TypeHelper.IsCompilerGenerated(fieldType))
{
_memberInfos.Pop();
goto Label_0000;
}
if (EntityConfigurationManager.IsEntity(fieldType))
{
_memberInfos.Pop();
return(GetTable(fieldType));
}
return(null);
}
private SchemaModel.Table GetTable(Type tableType)
{
if (ParserUtils.IsAnonymousType(tableType))
{
_tableMember = ((MemberExpression)_memberInfos.Pop()).Member;
tableType = ((PropertyInfo)_tableMember).PropertyType;
return(GetTable(tableType));
}
return(EntityConfigurationManager.GetTable(tableType));
}
protected string GetTableAlias(Column column)
{
if (!string.IsNullOrWhiteSpace(tableName))
{
return(tableName);
}
if (!string.IsNullOrWhiteSpace(column.Table.Alias))
{
return(column.Table.Alias);
}
var name = column.Name;
foreach (var join in _context.Joins.Values)
{
Dictionary <string, SchemaModel.Column> .ValueCollection.Enumerator enumerator2;
if (join.Left.Name == name)
{
return(join.Left.Table.Alias);
}
if (join.Right.Name == name)
{
return(join.Right.Table.Alias);
}
var table = EntityConfigurationManager.GetTable(join.Left.Table.Type);
using (enumerator2 = table.Columns.Values.GetEnumerator())
{
while (enumerator2.MoveNext())
{
if (enumerator2.Current.Name == name)
{
return(@join.Left.Table.Name == table.Name
? @join.Left.Table.Alias
: @join.Right.Table.Alias);
}
}
}
table = EntityConfigurationManager.GetTable(join.Right.Table.Type);
using (enumerator2 = table.Columns.Values.GetEnumerator())
{
while (enumerator2.MoveNext())
{
if (enumerator2.Current.Name == name)
{
return(@join.Left.Table.Name == table.Name
? @join.Left.Table.Alias
: @join.Right.Table.Alias);
}
}
}
}
throw new Exception();
}
private void BuildDeleteSql()
{
var str = string.Empty;
var table = EntityConfigurationManager.GetTable(_context.ElementType);
this.tableName = table.Name;
var tableName = GetTableName(table);
if (_context.Conditions.Any())
{
str = BuildWhere(_context.Conditions);
}
var format = "DELETE FROM {0} {1}";
format = string.Format(format, tableName, str);
_result.CommandText = format;
}
protected override Expression VisitParameter(ParameterExpression node)
{
var type = node.Type;
var expression = _memberExpressions.LastOrDefault();
if (!TypeHelper.IsValueType(expression.Type))
{
while (!EntityConfigurationManager.IsEntity(type))
{
type = _memberExpressions.Pop().Type;
}
ParseEntityType(type);
return(node);
}
var visitor = new MemberExpressionVisitor(Context);
visitor.Visit(expression);
Columns.Add(visitor.SelectedColumn);
return(node);
}
private void BuildUpdateSql()
{
var str = string.Empty;
var table = EntityConfigurationManager.GetTable(_context.ElementType);
var name = string.Empty;
var column =
table.Columns.FirstOrDefault(x => x.Value.IsKey)
.Value;
if (column != null)
{
name = column.PropertyInfo.Name;
}
this.tableName = table.Name;
var tableName = GetTableName(table);
if (_context.Conditions.Any())
{
str = BuildWhere(_context.Conditions);
}
var values = new List <string>();
var str4 = string.Empty;
foreach (var str6 in _context.UpdateResult.Keys)
{
if (str6 != name)
{
str4 = ParserUtils.GenerateAlias(str6);
var item = @"[{str6}] = @{str4}";
_result.Parameters.Add(str4, _context.UpdateResult[str6]);
values.Add(item);
}
}
var format = "UPDATE {0} SET {1} {2}";
format = string.Format(format, tableName, string.Join(",", values), str);
_result.CommandText = format;
}
private void ParseEntityType(Type type)
{
var table = EntityConfigurationManager.GetTable(type);
var table2 = new Table
{
DataBase = table.DataBase,
Name = table.Name,
Type = table.Type
};
foreach (var column in table.Columns.Values)
{
var item = new Column
{
Name = column.Name,
DataType = column.PropertyInfo.PropertyType,
MemberInfo = column.PropertyInfo,
Table = table2
};
Columns.Add(item);
Context.Columns.Add(column.Name, item);
}
}
public TResult Execute <TResult>(Expression expression)
{
object obj2;
var base2 = ProviderFactory.CreateProvider(dc.dbconn(string.Empty).Reader.DatabaseType);
var result = ParseExpression(expression);
var type = typeof(TResult);
//SqlExecutorBase base3 = base2.CreateSqlExecutor();
if ((expression.NodeType != ExpressionType.Call) || !type.IsValueType)
{
var flag = false;
if (type.IsGenericType)
{
var reader = ModelOpretion.SearchDataRetunDataTable(result.CommandText,
result.SqlQueryParameters, null); //base3.ExecuteReader(result.CommandText, result.Parameters);
if (type.GetGenericTypeDefinition() == ReflectorConsts.IEnumerableType)
{
var objectType = type.GetGenericArguments()[0];
IList list = null;
try
{
list = EntityMapper.Map(objectType, reader, base2.ObjectPropertyConvertType);
}
catch
{
throw new Exception("转化成TResult失败");
}
return((TResult)list);
}
if (typeof(Nullable <>).IsAssignableFrom(type))
{
flag = true;
}
if (!flag)
{
throw new Exception();
}
}
if (type.IsValueType | flag)
{
var obj = ModelOpretion.ScalarBache(result.CommandText, result.SqlQueryParameters, null);
if (obj == null)
{
return(default(TResult));
}
if (obj == DBNull.Value)
{
return(default(TResult));
}
return((TResult)Convert.ChangeType(obj, type));
}
if (!EntityConfigurationManager.IsEntity(type))
{
throw new Exception();
}
var dataReader = ModelOpretion.SearchDataRetunDataTable(result.CommandText,
result.SqlQueryParameters, null);
IList list2 = null;
try
{
list2 = EntityMapper.Map(type, dataReader, base2.ObjectPropertyConvertType);
}
catch (Exception ex)
{
throw new Exception("TResult:转化成实体失败.");
}
finally
{
}
if (list2.Count <= 0)
{
return(default(TResult));
}
var entity = list2[0];
return((TResult)entity);
}
//var name = ((MethodCallExpression) expression).Method.Name;
//if (name != "Any")
//{
// if ((name != "Delete") && (name != "Update"))
// {
// if ((name != "Average") && (name != "Sum") && (name != "Count"))
// {
// throw new Exception();
// }
// obj2 = base3.ExecuteScalar(result.CommandText, result.Parameters);
// if (obj2 == DBNull.Value)
// {
// return default(TResult);
// }
// var converter1 = new BaseTypeConverter(obj2, type);
// converter1.Process();
// return (TResult) converter1.Result;
// }
//}
//else
//{
// DataSet set = base3.ExecuteDataSet(result.CommandText, result.Parameters);
// obj2 = set.Tables.Count <= 0 ? 0 : (object) (set.Tables[0].Rows.Count > 0);
// return (TResult) obj2;
//}
obj2 = ModelOpretion.ScalarBache(result.CommandText,
result.SqlQueryParameters, null);
return((TResult)obj2);
}
protected override Expression VisitParameter(ParameterExpression node)
{
var column = new Column();
if (!EntityConfigurationManager.IsEntity(node.Type))
{
var table2 = GetTable();
MemberInfo member = null;
var key = string.Empty;
Table table3 = null;
if (table2 != null)
{
key = _tableMember.Name;
member = ((MemberExpression)_memberInfos.Pop()).Member;
if (_joins != null)
{
if (_joins.ContainsKey(key))
{
key = _joins[key].Right.Table.Alias;
}
}
else
{
key = table2.Name;
}
table3 = CreateTable(key, table2.DataBase, table2.Name, table2.Type);
}
else
{
member = ((MemberExpression)_memberInfos.Pop()).Member;
table3 = _columns[member.Name].Table;
key = table3.Alias;
table2 = GetTable(table3.Type);
}
var propertyType = ((PropertyInfo)member).PropertyType;
var name = string.Empty;
var column2 = table2.Columns[member.Name];
if (column2 != null)
{
name = column2.Name;
}
else
{
name = Context.Columns[member.Name].Name;
}
column = new Column
{
DataType = propertyType,
Name = name,
Table = table3,
MemberInfo = member
};
while (_memberInfos.Count > 0)
{
var expression2 = _memberInfos.Pop();
if (expression2.NodeType != ExpressionType.MemberAccess)
{
throw new Exception();
}
var memberInfo = ((MemberExpression)expression2).Member;
column.Converters.Push(new ColumnConverter(memberInfo, new List <object>()));
}
}
else
{
var table = GetTable(node.Type);
var info = ((MemberExpression)_memberInfos.Pop()).Member;
column.DataType = ((PropertyInfo)info).PropertyType;
column.Name = table.Columns[info.Name].Name;
column.MemberInfo = info;
var alias = node.Name;
if (_joins != null)
{
if (_joins.ContainsKey(alias))
{
alias = _joins[alias].Right.Table.Alias;
}
}
else
{
alias = table.Name;
}
column.Table = CreateTable(alias, table.DataBase, table.Name, table.Type);
while (_memberInfos.Count > 0)
{
var expression = _memberInfos.Pop();
if (expression.NodeType != ExpressionType.MemberAccess)
{
throw new Exception();
}
var info2 = ((MemberExpression)expression).Member;
column.Converters.Push(new ColumnConverter(info2, new List <object>()));
}
}
Token = Token.Create(column);
return(node);
}
protected override Expression VisitParameter(ParameterExpression node)
{
if (EntityConfigurationManager.IsEntity(node.Type))
{
var table = GetTable(node.Type);
var info = _memberInfoStack.Pop();
if (table.Columns[info.Name] == null)
{
SelectedColumn = null;
return(node);
}
SelectedColumn.DataType = ((PropertyInfo)info).PropertyType;
SelectedColumn.Name = table.Columns[info.Name].Name;
SelectedColumn.MemberInfo = info;
var key = node.Name;
if (_Joins != null)
{
if (_Joins.ContainsKey(key))
{
key = _Joins[key].Right.Table.Alias;
}
}
else
{
key = table.Name;
}
SelectedColumn.Table = CreateTable(key, table.DataBase, table.Name, table.Type);
while (_memberInfoStack.Count > 0)
{
var memberInfo = _memberInfoStack.Pop();
SelectedColumn.Converters.Push(new ColumnConverter(memberInfo, new List <object>()));
}
return(node);
}
var table2 = GetTable();
var info3 = _memberInfoStack.Pop();
if (table2.Columns[info3.Name] == null)
{
SelectedColumn = null;
return(node);
}
var propertyType = ((PropertyInfo)info3).PropertyType;
var name = _tableMember.Name;
if (_Joins != null)
{
if (_Joins.ContainsKey(name))
{
name = _Joins[name].Right.Table.Alias;
}
}
else
{
name = table2.Name;
}
var table3 = CreateTable(name, table2.DataBase, table2.Name, table2.Type);
var column1 = new Column
{
DataType = propertyType,
Name = table2.Columns[info3.Name].Name,
Table = table3,
MemberInfo = info3
};
SelectedColumn = column1;
while (_memberInfoStack.Count > 0)
{
var info4 = _memberInfoStack.Pop();
SelectedColumn.Converters.Push(new ColumnConverter(info4, new List <object>()));
}
return(node);
}
