private void processResources ( ) throws SQLException { List < Row > rows = getRows ( "select * from zresource where zproject=? order by zorderinproject" , m_projectID ) ; for ( Row row : rows ) { Resource resource = m_project . addResource ( ) ; resource . setUniqueID ( row . getInteger ( "Z_PK" ) ) ; resource . setEmailAddress ( row . getString ( "ZEMAIL" ) ) ; resource . setInitials ( row . getString ( "ZINITIALS" ) ) ; resource . setName ( row . getString ( "ZTITLE_" ) ) ; resource . setGUID ( row . getUUID ( "ZUNIQUEID" ) ) ; resource . setType ( row . getResourceType ( "ZTYPE" ) ) ; resource . setMaterialLabel ( row . getString ( "ZMATERIALUNIT" ) ) ; if ( resource . getType ( ) == ResourceType . WORK ) { resource . setMaxUnits ( Double . valueOf ( NumberHelper . getDouble ( row . getDouble ( "ZAVAILABLEUNITS_" ) ) * 100.0 ) ) ; } Integer calendarID = row . getInteger ( "ZRESOURCECALENDAR" ) ; if ( calendarID != null ) { ProjectCalendar calendar = m_project . getCalendarByUniqueID ( calendarID ) ; if ( calendar != null ) { calendar . setName ( resource . getName ( ) ) ; resource . setResourceCalendar ( calendar ) ; } } m_eventManager . fireResourceReadEvent ( resource ) ; } }
Read resource data .