获得webi报表

      public String[][] getWebiName(String folderName1,String folderName2) {
  if (boes == null ) {
   return null;
  }

  try {
   IInfoStore store = (IInfoStore) boes.getService("InfoStore");
                        int folderID1 ;
                        IInfoObject folder1 =null;
                        IInfoObjects folders1 =
                                store.query("select si_id from ci_infoobjects where si_name = '"+folderName1+"' and si_kind ='folder'");
                        if(folders1.getResultSize()>0){
                              folder1 = (IInfoObject)folders1.get(0);
                        }
                        folderID1 = folder1.getID();  //获得父文件夹id
                        int folderID2 ;
                        IInfoObject folder2 =null;
                        IInfoObjects folders2 =
                                store.query("select * from ci_infoobjects where si_name = '"+folderName2+"' and SI_PARENTID="+folderID1+"");
                        if(folders2.getResultSize()>0){
                              folder2 = (IInfoObject)folders2.get(0);
                        }
                        folderID2 = folder2.getID(); //获得子文件夹id

   IInfoObjects webis =
    store.query(
     "select * from ci_infoobjects where SI_PARENTID="+folderID2+"");
                        String[][] webiName = new String[webis.getResultSize()][2];
   if (webis.getResultSize() > 0) {
   for(int i=0;i                            IInfoObject webi = (IInfoObject) webis.get(i);
                                webiName[i][0]=String.valueOf(webi.getID());
    webiName[i][1]=webi.getTitle();
                        }
                           return webiName;    //获得webi名字
   }
  } catch (SDKException sdke) {
   msg = sdke.getMessage();
  }

  return null;
 }

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15073171/viewspace-664350/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15073171/viewspace-664350/