/// <summary> /// 查询单个实体 /// </summary> /// <param name="item">框架实体</param> /// <returns>单个对象</returns> public T SelectModel(FrameWorkItem item) { try { var sql = DalAid.CreatePageQuerySql(item.Sql, null, dbType); using (var connection = GetDbConnection(item.ConnectionString)) { using (var cmd = GetDbCommand(sql, connection, item.SqlParam)) { using (IDataReader dr = cmd.ExecuteReader()) { if (dr != null && dr.Read()) { return(DynamicBuilderEntity <T> .CreateBuilder(dr).Build(dr)); } } } } } catch (Exception ex) { throw ex; } finally { } return(default(T)); }
/// <summary> /// 查询集合,带分页 /// </summary> /// <param name="item">框架实体</param> /// <param name="isAutoParam">是否自动匹配参数</param> /// <param name="dp">分页对象</param> /// <returns>对象集合</returns> public List <To> SelectList <To>(FrameWorkItem item, DataPage dp = null, bool isAutoParam = false) where To : new() { try { var sql = DalAid.CreatePageQuerySql(item.Sql, dp, dbType); var param = item.SqlParam; if (isAutoParam) { var where = GetWhere(item.SqlParam); sql += where.Item1; param = where.Item2; } using (var connection = GetDbConnection(item.ConnectionString)) { using (var cmd = GetDbCommand(sql, connection, param)) { using (IDataReader dr = cmd.ExecuteReader()) { List <To> list = new List <To>(); if (dp != null && dp.PageSize > 0) { int result = GetResult <int>(string.Format("SELECT COUNT(1) FROM ({0}) a", item.Sql), item.ConnectionString, item.SqlParam); dp.RowCount = result; } var builders = DynamicBuilderEntity <To> .CreateBuilder(dr); while (dr != null && dr.Read()) { To tempT = new To(); tempT = builders.Build(dr); list.Add(tempT); } return(list); } } } } catch (Exception ex) { throw ex; } finally { } }
/// <summary> /// 建立过程 /// </summary> /// <param name="dataRecord">取数据流字段</param> /// <returns></returns> public static DynamicBuilderEntity <T> CreateBuilder(IDataRecord dataRecord) { var dynamicBuilder = new DynamicBuilderEntity <T>(); var method = new DynamicMethod("DynamicCreateEntity", typeof(T), new[] { typeof(IDataRecord) }, typeof(T), true); ILGenerator generator = method.GetILGenerator(); LocalBuilder result = generator.DeclareLocal(typeof(T)); generator.Emit(OpCodes.Newobj, typeof(T).GetConstructor(Type.EmptyTypes)); generator.Emit(OpCodes.Stloc, result); for (int i = 0; i < dataRecord.FieldCount; i++) { var propertyInfo = typeof(T).GetProperty(dataRecord.GetName(i)); if (propertyInfo == null) { continue; } var endIfLabel = generator.DefineLabel(); if (propertyInfo.GetSetMethod() == null) { continue; } generator.Emit(OpCodes.Ldarg_0); generator.Emit(OpCodes.Ldc_I4, i); generator.Emit(OpCodes.Callvirt, isDBNullMethod); generator.Emit(OpCodes.Brtrue, endIfLabel); generator.Emit(OpCodes.Ldloc, result); generator.Emit(OpCodes.Ldarg_0); generator.Emit(OpCodes.Ldc_I4, i); generator.Emit(OpCodes.Callvirt, getValueMethod); generator.Emit(OpCodes.Unbox_Any, dataRecord.GetFieldType(i)); generator.Emit(OpCodes.Callvirt, propertyInfo.GetSetMethod()); generator.MarkLabel(endIfLabel); } generator.Emit(OpCodes.Ldloc, result); generator.Emit(OpCodes.Ret); dynamicBuilder.handler = (Load)method.CreateDelegate(typeof(Load)); return(dynamicBuilder); }