Example #1
0
 /**
  * 功能:判断barcode的存在性。
  *
  * @return
  */
 private boolean isExist(EtsFaAssetsDTO faDTO) throws QueryException {
   boolean hasResule = false;
   SQLModel sqlModel = modelProducer.hasBarcode(faDTO.getTagNumber());
   SimpleQuery sq = new SimpleQuery(sqlModel, conn);
   sq.executeQuery();
   if (sq.hasResult()) {
     hasResule = true;
   }
   return hasResule;
 }
Example #2
0
 public SQLModel getPageQueryModel() throws SQLModelException {
   SQLModel sqlModel = new SQLModel();
   List sqlArgs = new ArrayList();
   String sqlStr =
       "SELECT EFA.ORGANIZATION_ID,\n"
           + "       EFA.TAG_NUMBER,\n"
           + "       EFA.ASSET_NUMBER,\n"
           + "       EFA.ASSETS_DESCRIPTION,\n"
           + "       EFA.MODEL_NUMBER,\n"
           + "       EFA.LIFE_IN_YEARS,\n"
           + "       EFA.DATE_PLACED_IN_SERVICE,\n"
           + "       EFA.ASSIGNED_TO_NAME,\n"
           + "       EFA.ASSIGNED_TO_NUMBER,\n"
           + "       AMS_PUB_PKG.GET_ORGNIZATION_NAME(EFA.ORGANIZATION_ID) ORGANIZATION_NAME,\n"
           + "       EFA.FA_CATEGORY_CODE\n"
           + "  FROM ETS_FA_ASSETS EFA\n"
           + " WHERE (EFA.IS_RETIREMENTS = 0 OR EFA.IS_RETIREMENTS = 2)\n"
           + "   AND NOT EXISTS\n"
           + " (SELECT 1 FROM ETS_ITEM_MATCH EIM WHERE EIM.ASSET_ID = EFA.ASSET_ID)\n"
           + "   AND NOT EXISTS (SELECT 1\n"
           + "          FROM ETS_ITEM_MATCH_ASSIST_MIS EIMAM\n"
           + "         WHERE EIMAM.ASSET_ID = EFA.ASSET_ID)\n"
           + "   AND EFA.ORGANIZATION_ID = ISNULL(?, EFA.ORGANIZATION_ID)\n"
           + "   AND EFA.ASSET_NUMBER LIKE dbo.NVL(?, EFA.ASSET_NUMBER)"
           + "   AND EFA.TAG_NUMBER LIKE dbo.NVL(?, EFA.TAG_NUMBER)"
           + "   AND EFA.ASSETS_DESCRIPTION LIKE dbo.NVL(?, EFA.ASSETS_DESCRIPTION)"
           + "   AND ( "
           + SyBaseSQLUtil.isNull()
           + "  OR EFA.MODEL_NUMBER LIKE ?)"
           + "   AND EFA.FA_CATEGORY_CODE LIKE dbo.NVL(?, EFA.FA_CATEGORY_CODE)";
   sqlArgs.add(dto.getOrganizationId());
   sqlArgs.add(dto.getAssetNumber());
   sqlArgs.add(dto.getTagNumber());
   sqlArgs.add(dto.getAssetsDescription());
   sqlArgs.add(dto.getModelNumber());
   sqlArgs.add(dto.getModelNumber());
   sqlArgs.add(dto.getFaCategoryCode());
   try {
     if (dto.getEndDate().toString().equals("")) {
       sqlStr +=
           "   AND GETDATE() - EFA.DATE_PLACED_IN_SERVICE >=\n" + "       EFA.LIFE_IN_YEARS * 365";
     } else {
       sqlStr +=
           "   AND TO_DATE(?,'YYYY-MM-DD HH24:MI:SS') - EFA.DATE_PLACED_IN_SERVICE >=\n"
               + "       EFA.LIFE_IN_YEARS * 365";
       sqlArgs.add(dto.getSQLEndDate().toString());
     }
   } catch (CalendarException e) {
     throw new SQLModelException(e);
   }
   sqlModel.setSqlStr(sqlStr);
   sqlModel.setArgs(sqlArgs);
   return sqlModel;
 }
Example #3
0
 /**
  * 提交工单
  *
  * @param dtoSet
  * @return
  * @throws QueryException
  * @throws DataHandleException
  */
 private boolean importEAMhouse(DTOSet dtoSet) throws DataHandleException {
   boolean operatorResult = false;
   try {
     if (dtoSet != null && dtoSet.getSize() > 0) {
       EtsFaAssetsDTO faDTO = null;
       EtsItemInfoDTO itemDTO = null;
       AmsHouseInfoDTO houseDTO = null;
       SystemItemHouse systemItemUtil = new SystemItemHouse();
       for (int i = 0; i < dtoSet.getSize(); i++) {
         faDTO = (EtsFaAssetsDTO) dtoSet.getDTO(i);
         itemDTO = new EtsItemInfoDTO();
         itemDTO.setBarcode(faDTO.getTagNumber());
         itemDTO.setItemName(faDTO.getAssetsDescription());
         itemDTO.setItemSpec(faDTO.getModelNumber());
         itemDTO.setItemQty(StrUtil.nullToString(faDTO.getCurrentUnits()));
         itemDTO.setStartDate(faDTO.getDatePlacedInService().toString());
         itemDTO.setItemCategory("HOUSE");
         itemDTO.setAssetId(faDTO.getAssetId());
         itemDTO.setOrganizationId(faDTO.getOrganizationId());
         itemDTO.setFinanceProp("ASSETS");
         itemDTO = systemItemUtil.checkSysItem(conn, itemDTO);
         appendProjIdData(itemDTO, faDTO);
         appendUserData(itemDTO, faDTO);
         appendAddressData(itemDTO, faDTO);
         if (StrUtil.isEmpty(itemDTO.getAddressId())) {
           addAddressData(faDTO);
           appendAddressData(itemDTO, faDTO);
         }
         if (StrUtil.isEmpty(itemDTO.getAddressId())) {
           continue;
         }
         houseDTO = new AmsHouseInfoDTO();
         houseDTO.setBarcode(faDTO.getTagNumber());
         houseDTO.setHouseAddress(faDTO.getAssetsLocation());
         houseDTO.setHremark("house信息导入");
         itemDTO.setSystemId(getNextSystemId());
         itemDTO.setRemark("house信息导入");
         if (!isExist(faDTO)) {
           insertEtsItemInfo(itemDTO); // IN  ams_item_info
         }
         insertHouesInfo(houseDTO); // IN ams_house_info
         matchData(itemDTO, faDTO); // 进行匹配操作
       }
     }
     operatorResult = true;
   } catch (DataHandleException ex) {
     ex.printLog();
     throw new DataHandleException(ex);
   } catch (SQLException ex) {
     Logger.logError(ex);
     throw new DataHandleException(ex);
   } catch (ContainerException ex) {
     ex.printLog();
     throw new DataHandleException(ex);
   } catch (QueryException ex) {
     ex.printLog();
     throw new DataHandleException(ex);
   } catch (CalendarException ex) {
     ex.printLog();
     throw new DataHandleException(ex);
   }
   return operatorResult;
 }