点击完参数面板上某个按钮之后会调用查询按钮然后会跳转窗口,跳转传递的参数值为单元格B1和C1的值,怎么样才能获取到这两个值呢代码及图示如下:var kk=this.options.form.getWidgetByName("saparam4");var X = "X"kk.setValue(X)_g().parameterCommit(); var url = FR.cjkEncode("/webroot/decision/view/report?viewlet=/决策分析/单号明细报表.cpt&op=write&saparam5="+a+"&saparam7="+b);window.open(url);
SELECT ORDERNO,SEIMEI,rtrim(ZUBAN) AS ZUBAN,KUMIYMD,sum(SEISU) as TOTAL FROM where KUMIYMD between '${para6}' and '${para5}' and SEIMEI between A' and B group by ORDERNO,ZUBAN,SEIMEI,KUMIYMD希望A和B分别是A3和B3单元格的值,怎么实现呢
SELECT ORDERNO,SEIMEI,rtrim(ZUBAN) AS ZUBAN,KUMIYMD,sum(SEISU) as TOTAL
FROM
where KUMIYMD between $para6 and $para5
group by ORDERNO,ZUBAN,SEIMEI,KUMIYMD$para5和$para6是当天时间和前一天时间是在参数面板上的,这样写不对,应该怎么写呢,我希望能够获取到参数面板上的值