IT/etc

[oz] n개의 쿼리를 한번에 호출

generator 2010. 4. 29. 13:39

var param ="";
 param = "connection.pcount=1\n";
 param += "connection.servlet="+_ACCESS_URL+"/weblogic/"+DEFAULT_OZ_VER_DIR+"/server\n";
 param += "connection.reportname="+ozReportName+"\n";
 param += "viewer.zoom=100\n";
 param += "viewer.showtree=true\n";
 param += "print.alldocument=true\n";
    param += "applet.configmode=html\n";
 //param += "information.debug=true\n";
 
 param += "connection.datafromserver=true\n";
 //param += "viewer.isframe=false\n";//
 param += "odi.odinames="+reportName+"\n";
 param += "odi."+reportName+".pcount=6\n";
 param += "odi."+reportName+".args1=PUBLISH_DATE="+cal_publish.Value+"\n";
 param += "odi."+reportName+".args2=CALCULATION_DATE="+cal_calculation.Value+"\n";
 param += "odi."+reportName+".args3=FULFILLMENT_DATE="+cal_fulfillment.Value+"\n";
 param += "odi."+reportName+".args4=ERDC_DVCD="+che_erdc_dvcd.Value+"\n";
 param += "odi."+reportName+".args5=CLOG_YM=\n";
 
 var ii = 0;
 var cnt = ds_list.rowcount;
 var cntChk = 0;   
 for(var i=0; i<cnt; i++){
  if(ds_list.GetColumn(i,"CHK") == true){
   if(ii==0){
    param += "connection.displayname="+ds_list.GetColumn(i,"LP_NAME")+"\n";
    param += "odi."+reportName+".args6=FNPL_PRNO="+ds_list.GetColumn(i,"FNPL_PRNO")+"\n";
   }else{
    param += "child"+ii+".connection.servlet="+_ACCESS_URL+"/weblogic/"+DEFAULT_OZ_VER_DIR+"/server\n";
    param += "child"+ii+".connection.reportname="+ozReportName+"\n";
    param += "child"+ii+".viewer.zoom=100\n";
    param += "child"+ii+".print.alldocument=true\n";
    param += "child"+ii+".applet.configmode=html\n";
    //param += "child"+ii+".information.debug=true\n";
    param += "child"+ii+".connection.displayname="+ds_list.GetColumn(i,"LP_NAME")+"\n";
    param += "child"+ii+".connection.datafromserver=true\n";
    //param += "child1.viewer.isframe=false\n";//
    param += "child"+ii+".odi.odinames="+reportName+"\n";
    param += "child"+ii+".odi."+reportName+".pcount=6\n";
    param += "child"+ii+".odi."+reportName+".args1=PUBLISH_DATE="+cal_publish.Value+"\n";
    param += "child"+ii+".odi."+reportName+".args2=CALCULATION_DATE="+cal_calculation.Value+"\n";
    param += "child"+ii+".odi."+reportName+".args3=FULFILLMENT_DATE="+cal_fulfillment.Value+"\n";
    param += "child"+ii+".odi."+reportName+".args4=ERDC_DVCD="+che_erdc_dvcd.Value+"\n";
    param += "child"+ii+".odi."+reportName+".args5=CLOG_YM=\n";
    param += "child"+ii+".odi."+reportName+".args6=FNPL_PRNO="+ds_list.GetColumn(i,"FNPL_PRNO")+"\n";
   } 
   //trace("FP_NO:"+ds_list.GetColumn(i,"FNPL_PRNO"));
   
   ii++;
  }
 }  
 param += "viewer.childcount="+(ii-1)+"\n";