获得ID

sue

请问两个表有主外键关系，在第一个页面是增加消息主外关联的表都有增加，在第二个页面根据这个增加的id打印此消息，用getCurrentID()不行

zhaixin

发一下代码

sue

mainActivity.trigger2Click = function(event){
    var process = justep.Context.getCurrentProcess();
        var activity = justep.Context.getCurrentActivity();
        var dataMasterId = justep.xbl("dataMaster").getCurrentID();        ---------想获取a这个页面存入的iD
        var dataDetailId = justep.xbl("dataDetail").getCurrentID();
        if (dataMaster && (dataMaster != "")) {
                var url = "/UI/estate/shoufei/process/contingendsPrintReport/mainActivity.w?process="
                                + process + "&activity=" + activity + "&dataMasterId=" + dataMasterId+"&dataDetailId="+dataDetailId;
                justep.Portal.openWindow("报表", url);
                }               
};


获得ID
                var dataMasterId = justep.Request.URLParams.dataMasterId;
                var dataDetailId = justep.Request.URLParams.dataDetailId;
                justep.xbl("reportData1").setStringVar('a','dataMasterId');       
                justep.xbl("reportData2").setStringVar('b','dataDetailId');
                justep.xbl('report1').refresh();       

action：主表
select TempCharge.*
    from TempCharge TempCharge
    where TempCharge.intTempChargeID = :a
从表
select TempChargeDetail.*
    from TempChargeDetail TempChargeDetail
     join TempCharge TempCharge on TempCharge.intTempChargeID = TempChargeDetail.intTempChargeDetailID
    where TempChargeDetail.intTempChargeDetailID = :b
报错信息：
Caused by: com.justep.model.exception.ModelException: 执行ksql:select TempChargeDetail.* from TempChargeDetail TempChargeDetail  join TempCharge TempCharge on TempCharge.intTempChargeID = TempChargeDetail.intTempChargeDetailID where TempCharge.intTempChargeID = :b时出错！
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.KSQL.select(Unknown Source)
        at KSQLProcedure.query(KSQLProcedure.java:15)
        ... 26 more
Caused by: com.justep.model.exception.ModelException: 找不到变量：b对应的值！

jishuang

什么时机，怎么给b这个参数赋值的？

sue

点击事件的时候

zhaixin

if (dataMaster && (dataMaster != "")) { 这个判断不对，没有定义dataMaster

                justep.xbl("reportData1").setStringVar('a','dataMasterId');        
                justep.xbl("reportData2").setStringVar('b','dataDetailId');
赋值不对，不应该有引号
          justep.xbl("reportData1").setStringVar('a',dataMasterId);        
                justep.xbl("reportData2").setStringVar('b',dataDetailId);

Caused by: com.justep.model.exception.ModelException: 执行ksql:select TempChargeDetail.* from TempChargeDetail TempChargeDetail  join TempCharge TempCharge on TempCharge.intTempChargeID = TempChargeDetail.intTempChargeDetailID where TempCharge.intTempChargeID = :b时出错！
这里面的ksql是在哪里定义的，和
从表
select TempChargeDetail.*
     from TempChargeDetail TempChargeDetail
     join TempCharge TempCharge on TempCharge.intTempChargeID = TempChargeDetail.intTempChargeDetailID
     where TempChargeDetail.intTempChargeDetailID = :b
不同，所以这个错误是没有给那个ksql里面的b参数赋值

sue

是发错了地方b的参数
在ksql里这样写的：主表：select TempCharge.*,BaseFang.louid as louid,BaseFang.danyuan as danyuan,BaseFang.xm as xm,BaseFang.huhao as huhao,BaseFang.louceng as louceng
    from TempCharge TempCharge
     optional  join BaseFang BaseFang on TempCharge.intClientID = BaseFang
    where TempCharge = :a
从表：
select TempChargeDetail.* from TempChargeDetail TempChargeDetail
     optional  join TempCharge TempCharge on TempCharge.intTempChargeID = TempChargeDetail.intTempChargeDetailID
    where TempCharge = :a
报错信息：
执行ksql:select TempChargeDetail.* from TempChargeDetail TempChargeDetail  optional  join TempCharge TempCharge on TempCharge.intTempChargeID = TempChargeDetail.intTempChargeDetailID where TempCharge = :a
从表为什么一直得不到传过去的数据

sue

应该是ksql变量传值都有问题，

jishuang

justep.xbl("reportData1").setStringVar(a,dataMasterId);        
这样传值没传进去？

sue

恩咯，
justep.xbl("reportData1").setStringVar(a,dataMasterId);    这里的a不需要单引号？