// 选择所有的字段
private Expression VisitAllMember(Type type, string alias, Expression node = null)
{
TypeRuntimeInfo runtimeInfo = TypeRuntimeInfoCache.GetRuntimeInfo(type);
Dictionary <string, Inte.XFramework.Reflection.MemberAccessWrapper> wrappers = runtimeInfo.Wrappers;
//Fixed issue# 匿名类的字段不能Set
//runtimeInfo.IsAnonymousType
//? type.GetProperties().ToDictionary(p => p.Name, p => new Inte.XFramework.Reflection.MemberAccessWrapper(p))
//: runtimeInfo.Wrappers;
foreach (var w in wrappers)
{
var wrapper = w.Value;// as Inte.XFramework.Reflection.MemberAccessWrapper;
var mapper = wrapper as MemberAccessWrapper;
if (mapper != null && mapper.Column != null && mapper.Column.NoMapped)
{
continue;
}
if (mapper != null && mapper.ForeignKey != null)
{
continue; // 不加载导航属性
}
_builder.AppendMember(alias, wrapper.Member.Name);
// 选择字段
string newName = ColumnExpressionVisitor.AddColumn(_columns, wrapper.Member.Name);
// 添加字段别名
_builder.AppendAs(newName);
_builder.Append(",");
_builder.AppendNewLine();
}
return(node);
}
// 导航属性
private void Deserialize_Navigation(object model, string typeName)
{
// CRM_SaleOrder.Client
Type pType = model.GetType();
TypeRuntimeInfo runtime = TypeRuntimeInfoCache.GetRuntimeInfo(pType);
if (string.IsNullOrEmpty(typeName))
{
typeName = pType.Name;
}
foreach (var kvp in _define.NavDescriptors)
{
var descriptor = kvp.Value;
if (descriptor.Count == 0)
{
continue;
}
string keyName = typeName + "." + descriptor.Name;
if (keyName != kvp.Key)
{
continue;
}
var navWrapper = runtime.GetWrapper(descriptor.Name);
if (navWrapper == null)
{
continue;
}
Type navType = navWrapper.DataType;
Func <IDataRecord, object> func = null;
if (!_funcCache.TryGetValue(keyName, out func))
{
func = GetDeserializer(navType, _reader, _define.Columns, descriptor.Start, descriptor.Start + descriptor.Count);
_funcCache[keyName] = func;
}
object navModel = func(_reader);
navWrapper.Set(model, navModel);
TypeRuntimeInfo navRuntime = TypeRuntimeInfoCache.GetRuntimeInfo(navType);
if (navRuntime.NavWrappers.Count > 0)
{
Deserialize_Navigation(navModel, keyName);
}
}
}
/// <summary>
/// 将 <see cref="IDataRecord"/> 映射为实体
/// </summary>
/// <typeparam reader="T">数据源</typeparam>
/// <param name="reader">数据源</param>
/// <param name="define">命令定义</param>
/// <returns></returns>
public static T ToModel <T>(this IDataRecord reader, CommandDefine define = null)
{
object obj = null;
object[] values = null;
int index = 0;
// 基元类初始化 ########################
if (Reflection.TypeUtils.IsPrimitive(typeof(T)))
{
//if(reader.IsDBNull(0)) return default(T)
//obj = reader.GetValue(0);
//return obj is DBNull ? default(T) : (T)obj;
return(reader.IsDBNull(0) ? default(T) : (T)reader.GetValue(0));
}
// 匿名类初始化 ########################
TypeRuntimeInfo runtime = TypeRuntimeInfoCache.GetRuntimeInfo <T>();
Inte.XFramework.Reflection.Emit.ConstructorInvoker ctor = runtime.ConstructInvoker;
if (runtime.IsAnonymousType)
{
values = new object[reader.FieldCount];
reader.GetValues(values);
for (index = 0; index < values.Length; ++index)
{
if (values[index] is DBNull)
{
values[index] = null;
}
}
return((T)ctor.Invoke(values));
}
// 实体类初始化 ########################
T model = (T)ctor.Invoke();
values = new object[reader.FieldCount];
reader.GetValues(values);
// 计算导航属性所占用的索引，这些索引对应的值不会赋给 T 实体
var sc = define as CommandDefine_Select;
if (sc == null || (sc.NavDescriptors != null && sc.NavDescriptors.Count == 0))
{
// 直接跑SQL,则不解析导航属性
for (int i = 0; i < reader.FieldCount; ++i)
{
obj = values[i];
if (obj == DBNull.Value)
{
continue;
}
string name = reader.GetName(i);
var wrapper = runtime.GetWrapper(name) as MemberAccessWrapper;
if (wrapper != null)
{
SetProperty(model, wrapper, obj);
}
}
}
else
{
// 使用表达式查询，解析导航属性
bool nav = sc.NavDescriptors.Any(x => x.Value.Count > 0);
int min = nav ? sc.NavDescriptors.Min(x => x.Value.Start) : 0;
// 第一层
index = -1;
foreach (var kvp in sc.Columns)
{
index += 1;
obj = values[index];
if (obj == DBNull.Value)
{
continue;
}
if (nav && index >= min)
{
break;
}
var wrapper = runtime.GetWrapper(kvp.Value.Name) as MemberAccessWrapper;
if (wrapper != null)
{
SetProperty(model, wrapper, obj);
}
}
// 递归导航属性
if (runtime.NavWrappers.Count > 0)
{
ToModel_Navigation(model, values, sc, string.Empty);
}
}
return(model);
}
// 导航属性
private static void ToModel_Navigation(object model, object[] values, CommandDefine_Select define, string typeName)
{
// CRM_SaleOrder.Client
Type pType = model.GetType();
TypeRuntimeInfo runtime = TypeRuntimeInfoCache.GetRuntimeInfo(pType);
if (string.IsNullOrEmpty(typeName))
{
typeName = pType.Name;
}
foreach (var kvp in runtime.NavWrappers)
{
string keyName = typeName + "." + kvp.Key;
ColumnNavDescriptor descriptor = null;
define.NavDescriptors.TryGetValue(keyName, out descriptor);
if (descriptor == null)
{
continue;
}
// 实例化这个导航属性并且给它赋值
var navWrapper = kvp.Value;
Type navType = navWrapper.DataType;
TypeRuntimeInfo navRuntime = TypeRuntimeInfoCache.GetRuntimeInfo(navType);
object navModel = navRuntime.ConstructInvoker.Invoke();
if (descriptor.Count > 0)
{
int index = -1;
foreach (var c_kvp in define.Columns)
{
index += 1;
if (index < descriptor.Start)
{
continue;
}
if (index > (descriptor.Start + descriptor.Count))
{
break;
}
object obj = values[index];
if (obj == DBNull.Value)
{
continue;
}
var wrapper = navRuntime.GetWrapper(c_kvp.Value.Name) as MemberAccessWrapper;
if (wrapper != null)
{
SetProperty(navModel, wrapper, obj);
}
}
}
SetProperty(model, navWrapper, navModel);
if (navRuntime.NavWrappers.Count > 0)
{
ToModel_Navigation(navModel, values, define, keyName);
}
}
}
/// <summary>
/// 将 <see cref="IDataRecord"/> 上的当前行反序列化为实体
/// </summary>
/// <returns></returns>
public T Deserialize()
{
#region 基元类型
if (Reflection.TypeUtils.IsPrimitive(typeof(T)))
{
if (_reader.IsDBNull(0))
{
return(default(T));
}
var obj = _reader.GetValue(0);
if (obj.GetType() != typeof(T))
{
obj = Convert.ChangeType(obj, typeof(T));
}
return((T)obj);
}
#endregion
#region 匿名类型
TypeRuntimeInfo runtime = TypeRuntimeInfoCache.GetRuntimeInfo <T>();
Inte.XFramework.Reflection.Emit.ConstructorInvoker ctor = runtime.ConstructInvoker;
if (runtime.IsAnonymousType)
{
object[] values = new object[_reader.FieldCount];
_reader.GetValues(values);
for (int index = 0; index < values.Length; ++index)
{
if (values[index] is DBNull)
{
values[index] = null;
}
}
return((T)ctor.Invoke(values));
}
#endregion
#region 实体类型
T model = default(T);
if (_define == null || (_define.NavDescriptors != null && _define.NavDescriptors.Count == 0))
{
// 直接跑SQL,则不解析导航属性
if (_topLevel == null)
{
_topLevel = GetDeserializer(typeof(T), _reader);
}
model = (T)_topLevel(_reader);
}
else
{
// 第一层
if (_topLevel == null)
{
_topLevel = GetDeserializer(typeof(T), _reader, _define.Columns, 0, _define.NavDescriptors.MinIndex);
}
model = (T)_topLevel(_reader);
// 递归导航属性
this.Deserialize_Navigation(model, string.Empty);
}
#endregion
return(model);
}
private static Func <IDataRecord, object> GetDeserializer(Type modelType, IDataRecord reader, IDictionary <string, Column> columns = null, int start = 0, int?end = null)
{
string methodName = Guid.NewGuid().ToString();
DynamicMethod dm = new DynamicMethod(methodName, typeof(object), new[] { typeof(IDataRecord) }, true);
ILGenerator g = dm.GetILGenerator();
TypeRuntimeInfo runtime = TypeRuntimeInfoCache.GetRuntimeInfo(modelType);
var model = g.DeclareLocal(modelType);
g.Emit(OpCodes.Newobj, runtime.ConstructInvoker.Constructor);
g.Emit(OpCodes.Stloc, model);
if (end == null)
{
end = reader.FieldCount;
}
for (int index = start; index < end; index++)
{
string keyName = reader.GetName(index);
if (columns != null)
{
Column column = null;
columns.TryGetValue(keyName, out column);
keyName = column != null ? column.Name : string.Empty;
}
var wrapper = runtime.GetWrapper(keyName);// as MemberAccessWrapper;
if (wrapper == null)
{
continue;
}
var isDBNullLabel = g.DefineLabel();
g.Emit(OpCodes.Ldarg_0);
g.Emit(OpCodes.Ldc_I4, index);
g.Emit(OpCodes.Callvirt, _isDBNull);
g.Emit(OpCodes.Brtrue, isDBNullLabel);
var m_method = GetReaderMethod(wrapper.DataType);
g.Emit(OpCodes.Ldloc, model);
g.Emit(OpCodes.Ldarg_0);
g.Emit(OpCodes.Ldc_I4, index);
g.Emit(OpCodes.Callvirt, m_method);
Type dataType = wrapper.DataType;
Type nullUnderlyingType = dataType.IsGenericType ? Nullable.GetUnderlyingType(dataType) : null;
Type unboxType = nullUnderlyingType != null ? nullUnderlyingType : dataType;
if (unboxType == typeof(byte[]) || (m_method == _getValue && dataType != typeof(object)))
{
g.Emit(OpCodes.Castclass, dataType);
}
if (nullUnderlyingType != null)
{
g.Emit(OpCodes.Newobj, dataType.GetConstructor(new[] { nullUnderlyingType }));
}
if (wrapper.Member.MemberType == MemberTypes.Field)
{
g.Emit(OpCodes.Stfld, wrapper.FieldInfo);
}
else
{
g.Emit(OpCodes.Callvirt, wrapper.SetMethod);
}
g.MarkLabel(isDBNullLabel);
}
g.Emit(OpCodes.Ldloc, model);
g.Emit(OpCodes.Ret);
var func = (Func <IDataRecord, object>)dm.CreateDelegate(typeof(Func <IDataRecord, object>));
return(func);
}