弹出框中的数据来自SQL(x5)

 前台界面

       <item>
          <xforms:trigger style="height:24px;cursor:default;width:90px;" id="addFromTempl"
            appearance="text" title="从模板新建">
            <xforms:action id="action1" ev:event="DOMActivate">
              <xforms:script id="xformsScript1">mainActivity.addFromTemplClick(event)</xforms:script>
            </xforms:action> 
            <xhtml:label id="label1">从模板新建</xhtml:label>
          </xforms:trigger>
        </item> 

 <xhtml:div component="/UI/system/components/windowDialog.xbl.xml#windowDialog"
      title="施工专业选择" width="600" height="450" modal="true" id="windowDialog1" url="/PMB/costManagement/process/dialog/specialtyTemplActivity.w"/> 

JS实现

mainActivity.addFromTemplClick = function(event) {
     var projectInfo = pmcSystem.parseURLParams();
 if (!projectInfo)
  return;
 var dlg = justep.xbl('windowDialog1');
 pmcSystem.useMappingResult(dlg, [ {
  scopeData : "result",
  scope : "all",
  aimData : "dataMain",
  operate : "updateLocatedOrInsert",
  locateMapping : null,
  dataMapping : [ {
   name : "fWBSCode",
   value : "[result.fWBSCode]"
  }, {
   name : "fWBSName",
   value : "[result.fWBSName]"
  }, {
   name : "fCreatePsnName",
   value : justep.Context.getCurrentPersonName()
  }, {
   name : "fCreateTime",
   value: justep.Date.toString(justep.System.datetime(), justep.Date.STANDART_FORMAT)
  }, {
   name : "fProjectID",
   value : projectInfo.projectId
  }, {
   name : "fProjectCode",
   value : projectInfo.projectCode
  }, {
   name : "fProjectName",
   value : projectInfo.projectName
  } ]
 } ], null, null, null, null, "getParams", sendToIframeDataOrFun);
 dlg.open();
};
function sendToIframeDataOrFun(){
 var projectInfo = pmcSystem.parseURLParams();
 if (!projectInfo) return null;
 document.__projectInfo = projectInfo;
 var ptID = projectInfo.projectId;
 return ptID; 
}

弹出框中的JS

var specialtyTemplActivity = {};
specialtyTemplActivity.listMultiChooseModelLoad = function(event){
 var sql = "select distinct b.* from pm_model a join PMB_Specialty_Templ b on a.fptcatalog = b.fprjcatalog " +
           " and b.fusestatus = 1 and a.fid = '"+getParams(data)+"' ORDER BY b.fsequenceno";
 pmcSystem.loadDataBySQL("main", "/PMB/costManagement/data", sql, "FID", "", true);
};
function getParams(data){
 return data;
}