| | 62 | |
|---|
| | 63 | @SuppressWarnings("unchecked") |
|---|
| | 64 | public List<PnProjectSpaceMetaCombo> getValuesOptionListForProperty(final Integer propertyId) { |
|---|
| | 65 | try { |
|---|
| | 66 | List metaValues = (List) getHibernateTemplate().execute(new HibernateCallback() { |
|---|
| | 67 | public List doInHibernate(Session session) throws HibernateException, SQLException { |
|---|
| | 68 | String hql = "from PnProjectSpaceMetaCombo where comp_id.propertyId=:propertyId"; |
|---|
| | 69 | try { |
|---|
| | 70 | Query query = session.createQuery(hql); |
|---|
| | 71 | query.setInteger("propertyId", propertyId); |
|---|
| | 72 | return query.list(); |
|---|
| | 73 | } catch (Exception e) { |
|---|
| | 74 | e.printStackTrace(); |
|---|
| | 75 | } |
|---|
| | 76 | return null; |
|---|
| | 77 | } |
|---|
| | 78 | }); |
|---|
| | 79 | |
|---|
| | 80 | List<PnProjectSpaceMetaCombo> result = new ArrayList<PnProjectSpaceMetaCombo>(); |
|---|
| | 81 | result.addAll(metaValues); |
|---|
| | 82 | return result; |
|---|
| | 83 | } catch (Exception e) { |
|---|
| | 84 | e.printStackTrace(); |
|---|
| | 85 | } |
|---|
| | 86 | return null; |
|---|
| | 87 | } |
|---|