/// <summary>
/// 将对象转换实体
/// </summary>
public Model.orders DataRowToModel(DataRow row)
{
Model.orders model = new Model.orders();
if (row != null)
{
#region 主表信息======================
//利用反射获得属性的所有公共属性
Type modelType = model.GetType();
for (int i = 0; i < row.Table.Columns.Count; i++)
{
//查找实体是否存在列表相同的公共属性
PropertyInfo proInfo = modelType.GetProperty(row.Table.Columns[i].ColumnName);
if (proInfo != null && row[i] != DBNull.Value)
{
proInfo.SetValue(model, row[i], null);//用索引值设置属性值
}
}
#endregion
#region 子表信息======================
StringBuilder strSql1 = new StringBuilder();
strSql1.Append("select * from " + databaseprefix + "order_goods");
strSql1.Append(" where order_id=@id");
SqlParameter[] parameters1 =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters1[0].Value = model.id;
DataTable dt1 = DbHelperSQL.Query(strSql1.ToString(), parameters1).Tables[0];
if (dt1.Rows.Count > 0)
{
int rowsCount = dt1.Rows.Count;
List <Model.order_goods> models = new List <Model.order_goods>();
Model.order_goods modelt;
for (int n = 0; n < rowsCount; n++)
{
modelt = new Model.order_goods();
Type modeltType = modelt.GetType();
for (int i = 0; i < dt1.Rows[n].Table.Columns.Count; i++)
{
PropertyInfo proInfo = modeltType.GetProperty(dt1.Rows[n].Table.Columns[i].ColumnName);
if (proInfo != null && dt1.Rows[n][i] != DBNull.Value)
{
proInfo.SetValue(modelt, dt1.Rows[n][i], null);
}
}
models.Add(modelt);
}
model.order_goods = models;
}
#endregion
}
return(model);
}
