public IList <T> ToList <T>(IDataReader reader)
where T : Entity, new()
{
IList <T> lst = new List <T>();
//if (reader == null)
//{
// return lst;
//}
int len = reader.FieldCount;
string[] propertyNames = new string[len];
DatabaseEntityDef definition = _modelDefFactory.GetDef <T>();
for (int i = 0; i < len; ++i)
{
propertyNames[i] = reader.GetName(i);
}
while (reader.Read())
{
T item = new T();
for (int i = 0; i < len; ++i)
{
DatabaseEntityPropertyDef property = definition.GetProperty(propertyNames[i])
?? throw new DatabaseException($"Lack DatabaseEntityPropertyDef of {propertyNames[i]}.");
object fieldValue = reader[i];
if (property.PropertyName == "Id" && fieldValue == DBNull.Value)
{
//item = null;
//break;
throw new DatabaseException($"Database value of Property 'Id' is null. Entity:{definition.EntityFullName}");
}
object?value = property.TypeConverter == null?
ValueConverterUtil.DbValueToTypeValue(fieldValue, property.PropertyType) :
property.TypeConverter.DbValueToTypeValue(fieldValue);
if (value != null)
{
property.SetValue(item, value);
}
}
lst.Add(item);
//if (item != null && !item.Deleted)
//{
// lst.Add(item);
//}
}
return(lst);
}
public static string?GetDbValueStatement(object?value, bool needQuoted)
{
if (value == null)
{
return(null);
}
string valueStr = ValueConverterUtil.TypeValueToStringValue(value);
if (needQuoted && IsValueNeedQuoted(value.GetType()))
{
valueStr = GetQuoted(valueStr);
}
return(valueStr);
}
public void ToObject <T>(IDataReader reader, T item) where T : Entity, new()
{
if (reader == null)
{
return;
}
int len = reader.FieldCount;
string[] propertyNames = new string[len];
DatabaseEntityDef definition = _modelDefFactory.GetDef <T>();
for (int i = 0; i < len; ++i)
{
propertyNames[i] = reader.GetName(i);
}
if (reader.Read())
{
for (int i = 0; i < len; ++i)
{
DatabaseEntityPropertyDef property = definition.GetProperty(propertyNames[i])
?? throw new DatabaseException($"Lack DatabaseEntityPropertyDef of {propertyNames[i]}.");
object?value = property.TypeConverter == null?
ValueConverterUtil.DbValueToTypeValue(reader[i], property.PropertyType) :
property.TypeConverter.DbValueToTypeValue(reader[i]);
if (value != null)
{
property.SetValue(item, value);
}
}
}
}
public IList <Tuple <TSource, TTarget?> > ToList <TSource, TTarget>(IDataReader reader)
where TSource : Entity, new()
where TTarget : Entity, new()
{
IList <Tuple <TSource, TTarget?> > lst = new List <Tuple <TSource, TTarget?> >();
//if (reader == null)
//{
// return lst;
//}
DatabaseEntityDef definition1 = _modelDefFactory.GetDef <TSource>();
DatabaseEntityDef definition2 = _modelDefFactory.GetDef <TTarget>();
string[] propertyNames1 = new string[definition1.FieldCount];
string[] propertyNames2 = new string[definition2.FieldCount];
int j = 0;
for (int i = 0; i < definition1.FieldCount; ++j, ++i)
{
propertyNames1[i] = reader.GetName(j);
}
for (int i = 0; i < definition2.FieldCount; ++j, ++i)
{
propertyNames2[i] = reader.GetName(j);
}
while (reader.Read())
{
TSource t1 = new TSource();
TTarget?t2 = new TTarget();
j = 0;
for (int i = 0; i < definition1.FieldCount; ++i, ++j)
{
DatabaseEntityPropertyDef pDef = definition1.GetProperty(propertyNames1[i])
?? throw new DatabaseException($"Lack DatabaseEntityPropertyDef of {propertyNames1[i]}.");
object fieldValue = reader[j];
if (pDef.PropertyName == "Id" && fieldValue == DBNull.Value)
{
//TSource 不可以为null
//t1 = null;
//break;
throw new DatabaseException($"Database value of Property 'Id' is null. Entity:{definition1.EntityFullName}");
}
if (pDef != null)
{
object?value = pDef.TypeConverter == null?
ValueConverterUtil.DbValueToTypeValue(fieldValue, pDef.PropertyType) :
pDef.TypeConverter.DbValueToTypeValue(fieldValue);
if (value != null)
{
pDef.SetValue(t1, value);
}
}
}
for (int i = 0; i < definition2.FieldCount; ++i, ++j)
{
DatabaseEntityPropertyDef pDef = definition2.GetProperty(propertyNames2[i])
?? throw new DatabaseException($"Lack DatabaseEntityPropertyDef of {propertyNames2[i]}.");;
object fieldValue = reader[j];
if (pDef.PropertyName == "Id" && fieldValue == DBNull.Value)
{
t2 = null;
break;
//throw new DatabaseException($"Database value of Property 'Id' is null. Entity:{definition2.EntityFullName}");
}
if (pDef != null)
{
object?value = pDef.TypeConverter == null?
ValueConverterUtil.DbValueToTypeValue(fieldValue, pDef.PropertyType) :
pDef.TypeConverter.DbValueToTypeValue(fieldValue);
if (value != null)
{
pDef.SetValue(t2, value);
}
}
}
//if (t1 != null && t1.Deleted)
//{
// t1 = null;
//}
//if (t2 != null && t2.Deleted)
//{
// t2 = null;
//}
//删除全为空
//if (t1 != null || t2 != null)
//{
// lst.Add(new Tuple<TSource, TTarget>(t1, t2));
//}
lst.Add(new Tuple <TSource, TTarget?>(t1, t2));
}
return(lst);
}
