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);
}
}
