2013-03-07----------
IList<object> to Ilist<model>-------将IList<object[]>转换成IList对象模型
var idnamelist = session.CreateQuery("select distinct o.Organizationid,o.OrganizationName from VpnUser v inner " +
"join v.Organization o ").List<object[]>();
IList<OrgIDandName> orglist = new List<OrgIDandName>();
for (int i = 0; i < idnamelist.Count; i++)
{
orglist.Add(new OrgIDandName{
organizationid =(int)idnamelist[i][0],
organizationname=(string)idnamelist[i][1]
});
}
2013-03-08----------- 直接遍历list<object>对象
var list = session.CreateQuery("select v.VpnUserid,v.StationName from VpnUser v").List<object[]>();
foreach (var listobj in list)
{
int i = Convert.ToInt32(listobj[0]);
string name = listobj[1].ToString();
}
IList<object> to Ilist<model>-------将IList<object[]>转换成IList对象模型
var idnamelist = session.CreateQuery("select distinct o.Organizationid,o.OrganizationName from VpnUser v inner " +
"join v.Organization o ").List<object[]>();
IList<OrgIDandName> orglist = new List<OrgIDandName>();
for (int i = 0; i < idnamelist.Count; i++)
{
orglist.Add(new OrgIDandName{
organizationid =(int)idnamelist[i][0],
organizationname=(string)idnamelist[i][1]
});
}
2013-03-08----------- 直接遍历list<object>对象
var list = session.CreateQuery("select v.VpnUserid,v.StationName from VpnUser v").List<object[]>();
foreach (var listobj in list)
{
int i = Convert.ToInt32(listobj[0]);
string name = listobj[1].ToString();
}