示例#1
0
 /**
  * 功能:获得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);
   }
 }