public DTOSet getUses() throws QueryException { GetMisHousInfoModel model = (GetMisHousInfoModel) sqlProducer; SimpleQuery sq = new SimpleQuery(model.getUsesInfo(), conn); sq.setDTOClassName(AmsHouseUsesDTO.class.getName()); sq.executeQuery(); return sq.getDTOSet(); }
public DTOSet getLines(String transId) throws QueryException { AmsBjTransQueryModel model = new AmsBjTransQueryModel(sfUser, null); SimpleQuery sq = new SimpleQuery(model.getByTransIdModel(dto.getTransId()), conn); sq.setDTOClassName(AmsBjsAllotDDto.class.getName()); sq.executeQuery(); return sq.getDTOSet(); }
/** * 功能:获取资产变更信息对象 * * @param assetid * @param conn * @return * @throws QueryException */ public TDSrvAssetsUpdateDTO getAssetsDtoBydId(String assetid, Connection conn) throws QueryException { TDSrvAssetsUpdateDTO dto = null; TDSrvAssetsUpdateModel assetsModel = new TDSrvAssetsUpdateModel(null, null); SQLModel sqlModel = assetsModel.getAssetsUpdateDTO(assetid); SimpleQuery sq = new SimpleQuery(sqlModel, conn); sq.setDTOClassName(TDSrvAssetsUpdateDTO.class.getName()); sq.executeQuery(); if (sq.hasResult()) { dto = (TDSrvAssetsUpdateDTO) sq.getFirstDTO(); } return dto; }