right.js

以前做的一个j2ee的项目

  if(obj.checked){
     svalue+=id+"X";
  }else{
     
     s=svalue.replace(res,'');
     
     svalue=s ;
  }
  document.all.delvalue.value=svalue;

}


function prev(){
  pag=pag - 1;  
      document.all.next.disabled=false;  
  if(pag==1){
      document.all.prev.disabled=true;   

  }
  pags=isevl * pag - (isevl - 1);
  page= isevl * pag; 
  if(gcname.indexOf("精华区")>0){
    jhdoc(ly,lyn,pags,page); 
  }else{
    newdocu(ly,lyn,pags,page);
  }
}
function next(){
  
  pag=pag + 1;  
  document.all.prev.disabled=false;
  //alert(pag+"--"+pagcount)
  if(pag==pagcount){
    document.all.next.disabled=true;
  }
  pags=isevl * pag - (isevl - 1);
  page= isevl * pag; 
  if(gcname.indexOf("精华区")>0){
    jhdoc(ly,lyn,pags,page); 
  }else{

   newdocu(ly,lyn,pags,page);
  }
}

function newdocu(lay,layn,ps,pe){


              //var sql=" select NAME, CREATEDATE,URL,TYPE from (" +
              //        " SELECT  rownum myrow, NAME, CREATEDATE,URL,TYPE  FROM T_GZDA_FILEMANAGERABSTR  "+
              //        " where( leve>"+lay+" and LEVE<"+layn+" and URL<>'A' AND FILESTATUE='0' and OPERID='"+oid+"') or ("+
              //        " leve>"+lay+" and LEVE<"+layn+" and URL<>'A' AND FILESTATUE='1' )"   +
              //        "  order by leve  " +
              //        " )  where myrow>="+ps+" and  myrow<="+pe ;
              if((glbcode=='FA')||(glbcode=='FAX')){
                 var sql="select NAME, CREATEDATE,URL,TYPE from (" +
                         " SELECT   rownum myrow, NAME, CREATEDATE,URL,TYPE  FROM T_GZDA_FILEMANAGERABSTR  "+
		         " where leve>"+lay+" and LEVE<"+layn+" and URL<>'A' "+

			 " and tpayerid in ( "+
	                 " select to_char(a.nsrnbm) from t_flgl_nsrflxx a ,t_flgl_flxx b where a.fl_xh=b.fl_xh "+
	                 " and b.lrry_dm='"+oid+"' "+
        	         " ) "+

		         " ORDER BY LEVE ASC " +
                         " )  where myrow>="+ps+" and  myrow<="+pe ;
                         ;
              }else{
              var sql="select NAME, CREATEDATE,URL,TYPE from (" +
		" select rownum myrow,a.url, a.name,a.createdate,a.type ,c.mc "+
		" from t_gzda_filemanagerabstr a, t_dm_gy_swry b, t_dm_gy_swjg c "+
		" where a.filetype = '1' and a.operid = b.swry_dm and b.swjg_dm = c.swjg_dm "+
		"    and "+
		"    (b.swjg_dm in "+
		"      (select swjg_dm "+
		"       from t_dm_gy_swjg "+
		"       connect by prior swjg_dm = sjswjg_dm "+
		"       start with swjg_dm in "+
		"         (select swjg_dm "+
		"          from t_qxgl_swry_zn_jgfw "+
		"          where swry_dm = '"+oid+"' and zn_dm = '0' "+
		"         ) "+
		"       ) "+
		"       or "+
		"       a.operid = '"+oid+"' "+
		"       or "+
		"       url in "+
		"       (select sj_xh "+
		"        from t_qxgl_gx "+
		"        where jgry_dm in "+
		"        ((select '01' || swjg_dm "+
		"          from t_qxgl_swry_zn_jgfw "+
		"          where swry_dm = '"+oid+"' and zn_dm = '1' "+
		"         ) "+
		"         union "+
		"         select '02' || '"+oid+"' from dual) and table_name = 'T_GZDA_FILEMANAGERABSTR' "+
		"       ) "+
		"    ) and leve >"+lay+" and leve<"+layn+
		"  order by leve asc "+
                      " )  where myrow>="+ps+" and  myrow<="+pe ;

                }


              var oRnt=execute(sql,"gov.gdlt.ssgly.taxcore.taxblh.gzda.service.SqlSelectBLH");
              var str=createHTML(oRnt,"没有你需要查看的文件!"); 
              document.all.ttable.innerHTML=str;
}

function showlj(obj){
  ooid=obj.id;
  var kcname="非共享文档";
  url=ooid.substring(3,ooid.length);
    var sql="select sj_xh from t_qxgl_gx where sj_xh='"+url+"' and table_name='T_GZDA_FILEMANAGERABSTR' "+
          " and sj_xh not in (select url from t_gzda_filemanagerabstr where operid = '"+oid+"') " ;
  var oRnt=execute(sql,"gov.gdlt.ssgly.taxcore.taxblh.gzda.service.SqlSelectBLH");
  var gx=oRnt.selectSingleNode("//root/params");
  if(gx.childNodes.length>0){
      kcname="共享文档";
  }



  var names="";
  var space=" ";
  var sql="select length(code) - 1 LE from t_gzda_filemanagerabstr where url='"+url+"'";
  var oRnt=execute(sql,"gov.gdlt.ssgly.taxcore.taxblh.gzda.service.SqlSelectBLH");
  var ll=oRnt.selectSingleNode("//root/params/item/LE").text;
  var l=parseInt(ll);

  var sql="select name from t_gzda_filemanagerabstr where url='A' and "+ 
           " ( leve = (select max(leve) from t_gzda_filemanagerabstr "+
             "  where leve<(select leve from t_gzda_filemanagerabstr "+
             "  where url='"+url+"') and "+
             "    length(code)=2 )" ;

      for(var i=3;i<=l;i++){
           sql=sql+" or leve = (select max(leve) from t_gzda_filemanagerabstr "+
             "  where leve<(select leve from t_gzda_filemanagerabstr "+
             "  where url='"+url+"') and "+
             "    length(code)="+i+" ) " 
      }
           
             sql=sql+" ) order by leve" ;
//myMessage(sql)

  var oRnt=execute(sql,"gov.gdlt.ssgly.taxcore.taxblh.gzda.service.SqlSelectBLH");

  var para=oRnt.selectSingleNode("//root/params");
  var len=para.childNodes.length;

  if(len>0){
    for(var i=0;i<len;i++){
        var item = para.childNodes[i];
        space+=space;
        names=names+space+item.childNodes[0].text+"\n";
        
    }
  }  

  obj.title="本文档的状态为:\n"+kcname+"\n本文档的存储路径为:\n"+names;

}

function cxJH(lay,cnam){
  
  var cn="**"+cnam;
  //alert(lay+"--"+cn)
  if(cn.indexOf("本人精华区")>0){
    var sql="select count(distinct(a.url)) COU "+
		" from db_ssgly.t_gzda_jh a, db_ssgly.t_dm_gy_swry b "+
		" where a.id =  '02' || b.swry_dm "+
		"    and  "+
		"    (b.swjg_dm in "+
		"      (select swjg_dm "+
		"       from db_ssgly.t_qxgl_swry_zn_jgfw "+
		"       where swry_dm = '"+oid+"' and zn_dm = '0' "+
		"      ) "+
		"      or "+
		"      a.id = '02' || '"+oid+"' "+
		"     )";
         calcpage(sql);

    var sql="select url,name,createdate,type from ( "+
	" select rownum myrow,d.url, d.name,d.createdate,d.type from db_ssgly.t_gzda_filemanagerabstr d "+
	" where url in ( "+
	" select (a.url) "+
	" from db_ssgly.t_gzda_jh a, db_ssgly.t_dm_gy_swry b "+
	" where a.id =  '02' || b.swry_dm "+
	"    and  "+
	"    (b.swjg_dm in "+
	"      (select swjg_dm "+
	"       from db_ssgly.t_qxgl_swry_zn_jgfw "+
	"       where swry_dm = '"+oid+"' and zn_dm = '0' "+
	"      ) "+
	"      or "+
	"      a.id = '02' || '"+oid+"' "+
	"     ) "+
	")     "+
	" ) where myrow>="+pags+" and myrow<="+page; 
//myMessage(sql)
              var oRnt=execute(sql,"gov.gdlt.ssgly.taxcore.taxblh.gzda.service.SqlSelectBLH");
              var str=createHTML(oRnt,"没有你需要查看的文件!",true); 
              document.all.ttable.innerHTML=str;
  }else if(cn.indexOf("本科精华区")>0){
    var sql="select count(distinct(a.url)) COU "+
	" from t_gzda_jh a, t_dm_gy_swry b "+
	" where a.id =  '01' || b.swjg_dm and b.swry_dm = '"+oid+"' ";
        calcpage(sql); 
    var sql="select url,name,createdate,type from ( "+
	" select rownum myrow,d.url, d.name,d.createdate,d.type from db_ssgly.t_gzda_filemanagerabstr d "+
	" where url in ( "+
	"  select distinct(a.url) "+
	"  from db_ssgly.t_gzda_jh a, t_dm_gy_swry b "+
	"  where a.id =  '01' || b.swjg_dm and b.swry_dm = '"+oid+"' "+
	" ) "+    
	" )where myrow>="+pags+" and myrow<="+page;
              var oRnt=execute(sql,"gov.gdlt.ssgly.taxcore.taxblh.gzda.service.SqlSelectBLH");
              var str=createHTML(oRnt,"没有你需要查看的文件!",true); 
              document.all.ttable.innerHTML=str;
   
  }else if(cn.indexOf("本局精华区")>0){
    var sql="select count(distinct(a.url)) COU "+
	" from t_gzda_jh a, "+
	" (select decode(swjg.swbm_bj, '0', swjg.swjg_dm, '1', swjg.sjswjg_dm) as sjswjg_dm "+
	"  from t_dm_gy_swjg swjg, t_dm_gy_swry swry "+
	"  where swjg.swjg_dm = swry.swjg_dm and swry.swry_dm = '"+oid+"' "+
	" ) c "+
	" where a.id =  '01' || c.sjswjg_dm";

        calcpage(sql);
     var sql="select url,name,createdate,type from ( "+
	" select rownum myrow,d.url, d.name,d.createdate,d.type from db_ssgly.t_gzda_filemanagerabstr d "+
	" where url in ( "+
	"  select distinct(a.url) "+
	"  from db_ssgly.t_gzda_jh a,  "+
	"   (select decode(swjg.swbm_bj, '0', swjg.swjg_dm, '1', swjg.sjswjg_dm) as sjswjg_dm "+
	"    from db_ssgly.t_dm_gy_swjg swjg, t_dm_gy_swry swry "+
	"    where swjg.swjg_dm = swry.swjg_dm and swry.swry_dm = '"+oid+"' "+
	"   ) c "+
	"  where a.id =  '01' || c.sjswjg_dm "+
	" ) "+    
	" )where myrow>="+pags+" and myrow<="+page;

              var oRnt=execute(sql,"gov.gdlt.ssgly.taxcore.taxblh.gzda.service.SqlSelectBLH");
              var str=createHTML(oRnt,"没有你需要查看的文件!",true); 
              document.all.ttable.innerHTML=str;
     //myMessage(sql);
  } 
} 
function calcpage(cousql){

              var oRnt=execute(cousql,"gov.gdlt.ssgly.taxcore.taxblh.gzda.service.SqlSelectBLH");
              var pagc=oRnt.selectSingleNode("//root/params/item/COU").text;

              pagcount=parseInt(pagc);

              if(pagcount>isevl){
                  document.all.next.disabled=false;
              } 


              
              if(pagcount % isevl!=0){
                   pagcount=Math.floor(pagcount/isevl) + 1;
              }else{
                   pagcount=Math.floor(pagcount/isevl);
              }

}



function jhdoc(ly,lyn,ps,pe) {
  if(gcname.indexOf("本人精华区")>0){
    var sql="select url,name,createdate,type from ( "+
	" select rownum myrow,d.url, d.name,d.createdate,d.type from db_ssgly.t_gzda_filemanagerabstr d "+
	" where url in ( "+
	" select (a.url) "+
	" from db_ssgly.t_gzda_jh a, db_ssgly.t_dm_gy_swry b "+
	" where a.id =  '02' || b.swry_dm "+
	"    and  "+
	"    (b.swjg_dm in "+
	"      (select swjg_dm "+
	"       from db_ssgly.t_qxgl_swry_zn_jgfw "+
	"       where swry_dm = '"+oid+"' and zn_dm = '0' "+
	"      ) "+
	"      or "+
	"      a.id = '02' || '"+oid+"' "+
	"     ) "+
	")     "+
	" ) where myrow>="+ps+" and myrow<="+pe; 
  }else if(gcname.indexOf("本科精华区")>0){
    var sql="select url,name,createdate,type from ( "+
	" select rownum myrow,d.url, d.name,d.createdate,d.type from db_ssgly.t_gzda_filemanagerabstr d "+
	" where url in ( "+
	"  select distinct(a.url) "+
	"  from db_ssgly.t_gzda_jh a, t_dm_gy_swry b "+
	"  where a.id =  '01' || b.swjg_dm and b.swry_dm = '"+oid+"' "+
	" ) "+    
	" )where myrow>="+ps+" and myrow<="+pe;
  }else if(gcname.indexOf("本局精华区")>0){
     var sql="select url,name,createdate,type from ( "+
	" select rownum myrow,d.url, d.name,d.createdate,d.type from db_ssgly.t_gzda_filemanagerabstr d "+
	" where url in ( "+
	"  select distinct(a.url) "+
	"  from db_ssgly.t_gzda_jh a,  "+
	"   (select decode(swjg.swbm_bj, '0', swjg.swjg_dm, '1', swjg.sjswjg_dm) as sjswjg_dm "+
	"    from db_ssgly.t_dm_gy_swjg swjg, t_dm_gy_swry swry "+
	"    where swjg.swjg_dm = swry.swjg_dm and swry.swry_dm = '"+oid+"' "+
	"   ) c "+
	"  where a.id =  '01' || c.sjswjg_dm "+
	" ) "+    
	" )where myrow>="+ps+" and myrow<="+pe;
  } 
              var oRnt=execute(sql,"gov.gdlt.ssgly.taxcore.taxblh.gzda.service.SqlSelectBLH");
              var str=createHTML(oRnt,"没有你需要查看的文件!",true); 
              document.all.ttable.innerHTML=str;

} 



var isevl=10;
  var pag=1;
  var pags=isevl * pag - (isevl - 1);
  var page= isevl * pag; 
  var pagcount=0;  
  var ly=0;
  var lyn=0;
  var oid="";
  var glbcode="";
  var goid="";
  var gcname="";