hql new

String hql = " select DISTINCT new cn.com.widemex.wides1.cooperation.domain.OlcoCnoteTd(A.id, A.sysUserTb, A.cnoteNo,"+
"A.title,A.originateTime,A.status,A.rcvUserDesc,"+
"A.createTime,A.lastModiTime) from OlcoCnoteTd A " +
" left join A.sysUserTb B "+
" left join A.olcoCnoteOptRecTds C " +
" left join A.olcoCnoteRcvUserTds D "+ //with D.sysUserTb.userId = '" +params[0]+"'
" left join A.olcoCnoteAttchmntTds E " +
" left join C.sysUserTb F " +
" left join D.sysUserTb G";


public OlcoCnoteTd(String id, SysUserTb sysUserTb, Object cnoteNo,
String title, Object originateTime, Object status, String rcvUserDesc,
Object createTime, Object lastModiTime) {
this.id = id;
this.sysUserTb = sysUserTb;
this.cnoteNo = Type.toInt(cnoteNo);
this.title = title;
this.originateTime = (Date)originateTime;
this.status = Short.valueOf(status.toString());
this.rcvUserDesc = rcvUserDesc;
this.createTime = (Date)createTime;
this.lastModiTime = (Date)lastModiTime;
}集合 好像不行