62,046
社区成员
发帖
与我相关
我的任务
分享
List l = new ArrayList();
//
for(int i=0;i<;i++){
Software s = new Software();
s.mID=;
m.mName=;
l.add(s);
}
return l;
public IList<Software> GetAll()
{
string sql = "select * from(select s.ID as ID,s.Name as Name,s.PictureUrl as PictureUrl,q.Price as Price,a.Name as BigTypeName from Software as s,Quotation as q,Agent as a where q.Agent_ID = a.ID and q.Software_ID =s.ID) as Software";
return _session.CreateSQLQuery(sql).AddEntity("software", typeof(Software)).List <Software>();
}
//VS2008
//实体类定义属性修饰符为public virtual
//配置文件
public class Software
{
#region NHFrog自维护属性,请不要使用代码编程器
// 主键的私有变量
public virtual int ID
{get;set;}
// 名称的私有变量
public virtual string Name
{get;set;}
List<Software> l = (Software)_session.CreateSQLQuery(sql).AddEntity("software", typeof(Software)).List <Software>();
// 获取结果
IList results = query.List();
// 转化结果为Array
Software[] soft = new UserTalk[results.Count];
results.CopyTo(soft, 0);