日期:2014-05-17 浏览次数:21113 次
String hql = "select new fi.salesManagement.bean.PurchaseVo(f.inId as Id,f.ifoId as ifoId,i.UTime as time,f.ACurnum as count,f.inPrice as inprice) from PurchaseInStorageInfo f inner join PurchaseInStorage i with f.inId = i.inId and f.delFlag = 0 and i.delFlag = 0 and f.AId = ? and f.sId = ?"; String hql = "select new fi.salesManagement.bean.PurchaseVo(f.inId as Id,f.ifoId as ifoId,i.UTime as time,f.ACurnum as count,f.inPrice as inprice) from PurchaseInStorageInfo f, PurchaseInStorage i where f.inId = i.inId"; List<PurchaseVo> PurchaseVoList = this.createQuery(getSession(), hql, values).list();
private Long inId; private Long ifoId; private Date UTime; private Long ACurnum; private BigDecimal inPrice; public PurchaseVo(Long inId, Long ifoId, Date uTime, Long aCurnum, BigDecimal inPrice) { super(); this.inId = inId; this.ifoId = ifoId; UTime = uTime; ACurnum = aCurnum; this.inPrice = inPrice; }