无法获取数据

southpine

主从表打印时，不能获取数据。
用的是ksqlAction，打印代码如下：
        Model.prototype.printBtnClick = function(event){
                var id = "5BDE2860749E45288411E614BC38B229";
                this.comp("p").setStringVar("id", id);
                this.comp("e").setStringVar("id", id);
                this.comp("report1").refresh();
        };


Network截图：

model中是空的。

窗口刷新后的截图：


不知道什么原因。

jishuang

ksql具体怎么定义的？

southpine

jishuang 发表于 2016-4-25 14:16
ksql具体怎么定义的？

主表ksql：
select SM_sell,SM_sell.fDate as fDate,SM_sell.fSale as fSale,SM_sell.fPay as fPay,SM_sell.fPayed as fPayed,SM_sell.fCardPay as fCardPay,SM_sell.fRemark as fRemark
    from SM_sell SM_sell
    where SM_sell = :id
从表ksql：
select SM_sellList.fSellID as fSellID,SM_sellList.fPrice as fPrice,SM_sellList.fNum as fNum,SM_sellList.fPay as fPay,SM_sellList.fCardPay as fCardPay,SM_sellList
    from SM_sellList SM_sellList
    where SM_sellList.fSellID = :id

jishuang

把完整的action的定义和excel文件发一下看看

southpine

action:
<action name="ksqlSellAction" global="false" procedure="ksqlQueryProcedure">
                <private name="ksql" type="String"
                        value="select SM_sell,SM_sell.fDate as fDate,SM_sell.fSale as fSale,SM_sell.fPay as fPay,SM_sell.fPayed as fPayed,SM_sell.fCardPay as fCardPay,SM_sell.fRemark as fRemark from SM_sell SM_sell where SM_sell  = :id"></private>
                <public name="variables" type="Map"></public>
                <private name="dataModel" type="String" value="/SMS/sell/data"></private>
                <public name="fnModel" type="String"></public>
        </action>
        <action name="ksqlSellListAction" global="false" procedure="ksqlQueryProcedure">
                <private name="ksql" type="String"
                        value="select SM_sellList.fSellID as fSellID,SM_sellList.fPrice as fPrice,SM_sellList.fNum as fNum,SM_sellList.fPay as fPay,SM_sellList.fCardPay as fCardPay,SM_sellList from SM_sellList SM_sellList where SM_sellList.fSellID = :id"></private>
                <public name="variables" type="Map"></public>
                <private name="dataModel" type="String" value="/SMS/sell/data"></private>
                <public name="fnModel" type="String"></public>
        </action>


print.zip (7.16 KB, 下载次数: 81)

2016-4-25 18:40 上传

点击文件名下载附件

jishuang

你好楼主，该问题需要远程，已经通过技术服务QQ加你为好友了，请及时通过，我们会尽快QQ远程。

已远程，目前不确定是什么问题，修改了设计器自动生成的reportData的xid就导致没有触发到action

可以先直接设计器生成的reportData的xid去操作

southpine

结贴。