/** * 功能:获得MIS的员工信息 * * @throws QueryException * @throws ContainerException */ private void appendUserData(EtsItemInfoDTO itemDTO, EtsFaAssetsDTO faDTO) throws QueryException { try { SQLModel sqlModel = modelProducer.getMISemployee(faDTO.getAssignedToNumber()); SimpleQuery sq = new SimpleQuery(sqlModel, conn); sq.executeQuery(); if (sq.hasResult()) { Row row = sq.getFirstRow(); itemDTO.setResponsibilityDept(row.getStrValue("DEPT_CODE")); itemDTO.setResponsibilityUser(row.getStrValue("EMPLOYEE_ID")); } } catch (ContainerException ex) { ex.printLog(); throw new QueryException(ex); } }