@Override
 public String getVisibleIds(String type) {
     StringBuffer sql = new StringBuffer();
     sql.append("select t.id from T_LAWSANDREGULATIONS t where 1=1");
     sql.append(" and PASS_AUDIT='" + LawsAndRegulations.PASS_AUDIT_YES + "'");
     if (!StringUtil.isNullOrEmpty(type)) {
         sql.append(" and type = '").append(type).append("'");
     }
     List<?> lawsList = queryBySql(sql.toString());
     String queryIds = Util.spliceRangeIds(lawsList, null);
     return queryIds;
 }
 @Override
 public List<InformationVo> listRecommended(Integer userId, int count) {
     //查询出被推荐的资源。并排除已被阅读的资源。
     String sql = Util.getQueryRecommendedSqlStr("T_LAWSANDREGULATIONS", "READ_RECORD_LAWS", "LAWS_ID", userId,
             " and PASS_AUDIT='" + LawsAndRegulations.PASS_AUDIT_YES + "'", "");
     Pagination page = queryBySql(1, count, sql);
     Long[] ids = Util.convertBigDecimalSet2LongList((Set<BigDecimal>) page.getSet());
     List<InformationVo> infos = new ArrayList<InformationVo>();
     if (ids.length > 0) {
         List<LawsAndRegulations> dataList = findByIds(ids);
         String viewAddress = Util.getDggSitePath() + "lawsAndRegulations/viewContent.do?id=";
         for (LawsAndRegulations laws : dataList) {
             InformationVo vo = new InformationVo();
             vo.setReleaseTime(laws.getReleaseTime());
             vo.setTitle(laws.getName());
             vo.setType(Constants.BPM_ITEM_LAWS);
             vo.setViewAddress(viewAddress + laws.getId());
             infos.add(vo);
         }
     }
     return infos;
 }