public SQLModel getPageQueryModel() throws SQLModelException { AmsAssetsAddressVDTO dto = (AmsAssetsAddressVDTO) dtoParameter; SQLModel sqlModel = new SQLModel(); List sqlArgs = new ArrayList(); String sqlStr = "SELECT EOCM.ORGANIZATION_ID,\n" + " EOCM.COMPANY,\n" + " COUNT(1) LASTING_COUNT\n" + "FROM ETS_ITEM_INFO EII,\n" + " ETS_OU_CITY_MAP EOCM\n" + "WHERE EII.ORGANIZATION_ID = EOCM.ORGANIZATION_ID\n" + // "AND EII.ATTRIBUTE1 = 'RENT'\n" + "AND EII.FINANCE_PROP = 'RENT_ASSETS'\n" + "AND ( EII.DISABLE_DATE IS NULL OR EII.DISABLE_DATE " + SyBaseSQLUtil.isNullNoParam() + " ) \n" + "AND (" + SyBaseSQLUtil.nullIntParam() + " OR EII.ORGANIZATION_ID = ?)\n" + "GROUP BY EOCM.ORGANIZATION_ID,\n" + " EOCM.COMPANY"; // sqlArgs.add(dto.getOrganizationId()); // sqlArgs.add(dto.getOrganizationId()); SyBaseSQLUtil.nullIntParamArgs(sqlArgs, dto.getOrganizationId()); sqlModel.setSqlStr(sqlStr); sqlModel.setArgs(sqlArgs); return sqlModel; }