private void DBOper() { OracleUtil util = new OracleUtil(Para); DataTable dt = util.ExecuteDataTable(sql); foreach (DataRow dr in dt.Rows) { T t = new T(); // 获得此模型的公共属性 PropertyInfo[] propertys = t.GetType().GetProperties(); foreach (PropertyInfo pi in propertys) { if (dt.Columns.Contains(pi.Name)) { if (!pi.CanWrite) { continue; } object value = dr[pi.Name]; if (value != DBNull.Value) { pi.SetValue(t, value, null); } } } entities.EntityList.Add(t); } }
protected virtual void DBOper() { OracleUtil util = new OracleUtil(Para); DataTable dt = util.ExecuteDataTable(sql); foreach (DataRow dr in dt.Rows) { dynamic obj = new ExpandoObject(); var dict = (IDictionary <string, object>)obj; foreach (DataColumn column in dt.Columns) { dict[column.ColumnName] = dr[column.ColumnName]; } entities.EntityList.Add(obj); } }