我在DAL层写了public DataSet SelAll()
{
StringBuilder sb = new StringBuilder("select * from two");
return dbh.getDS(sb.ToString());
}
返回的是dataset
然后我要在BLL层 返回的是 list 请问如何转换呢
{
StringBuilder sb = new StringBuilder("select * from two");
return dbh.getDS(sb.ToString());
}
返回的是dataset
然后我要在BLL层 返回的是 list 请问如何转换呢
{
IList<T> list = new List<T>();
T t = default(T);
PropertyInfo[] propertypes = null;
string tempName = string.Empty;
foreach (DataRow row in table.Rows)
{
t = Activator.CreateInstance<T>();
propertypes = t.GetType().GetProperties();
foreach (PropertyInfo pro in propertypes)
{
tempName = pro.Name;
if (table.Columns.Contains(tempName))
{
object value = row[tempName];
pro.SetValue(t, value, null);
}
}
list.Add(t);
}
return list;
}
{
Ilist<Model.User> ilist = List<Model.User>();
StringBuilder sb = new StringBuilder("select * from two");
dataset ds = dbh.getDS(sb.ToString());
for(int i=0;i<ds.rows.count;i++)
{
Model.User model = new Model.User();
model.UserID=ds.rows[i][0];
model.UserName = ds.rows[i][1];
....
ilist.add(model);
}
ds.close();
ds.dispose();
return ilist
}