|
楼主 |
发表于 2014-10-10 15:14:25
|
显示全部楼层
按照您的指导,做的传参数一步做不下去了,如果没有参数的话,功能可以正常显示。但是加上参数就报错。 查了一下说是参数个数不对,但是我仔细检查了,没问题啊还请指教
1.做的acction,这个acction有 4 个 参数
2.这个acction的代码 有 4个参数,代码如下
import java.math.*;
import java.sql.*;
import java.util.*;
import org.dom4j.*;
import com.justep.system.data.*;
public class Caiwufenxi {
public static Table huizongfuzhai(String a,String b,String c,String n){
String sql = "select sum(x.CalculateAmountf) CalculateAmount, x.YearMonth as YearMonth,substring(x.YearMonth ,1,4) as year,substring(x.YearMonth ,6,2) as month from Balancesheetv x where ((x.subcompany ='" + a + "' or x.subcompany ='" + b + "' or x.subcompany ='" + c + "' ) and x.lineNumber ='71') group by YearMonth having (x.YearMonth like '" + n + "%') order by x.YearMonth asc ";
//String sql = "select sum(x.CalculateAmountf) CalculateAmount, x.YearMonth as YearMonth,substring(x.YearMonth ,1,4) as year,substring( x.YearMonth ,6,2) as month from Balancesheetv x where ((x.subcompany ='0015' or x.subcompany ='0020' or x.subcompany ='0023' ) and x.lineNumber ='71') group by YearMonth having (x.YearMonth like '2014%') order by x.YearMonth asc ";
HashMap<String,String> sqlMap = new HashMap<String,String>();
sqlMap.put(SQL.DEFAULT_DB_NAME,sql);
return SQL.select(sqlMap,null,"/juecefenxi/caiwufenxi/data");
}
}
3,对应的js传参代码如下
var mainActivity = {};
mainActivity.grdMainRowClick = function(event){
var fengongsi = justep.xbl("data1").getValue("子公司单位");
var dangqian = justep.xbl("bizData2").getValue("fSZSZ");
var x ='1';
var y='1';
var z='1'
if (fengongsi.indexOf("0015")>=0)
{
x ='0015'
}
if (fengongsi.indexOf("0020")>=0)
{
y ='0020'
}
if (fengongsi.indexOf("0023")>=0)
{
z ='0023'
}
justep.xbl('fuzhaizonge').setStringVar('a',x);
justep.xbl('fuzhaizonge').setStringVar('b',y);
justep.xbl('fuzhaizonge').setStringVar('c',z);
justep.xbl('fuzhaizonge').setStringVar('n',dangqian);
justep.xbl('fuzhaizonge').refreshData();
justep.xbl('chart7').refresh();
alert("ok")
};
4报错信息如下
2014-10-10 15:04:38 action:<?xml version="1.0" encoding="UTF-8"?>
<action direct-execute="true" process="/juecefenxi/caiwufenxi/process/mainjiemian/mainjiemianProcess" activity="mainActivity" action-flag="__action_0__" executor="" execute-context="" name="huizongfuzhai"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="a"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">1</xbiz:simple></parameter><parameter name="b"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">1</xbiz:simple></parameter><parameter name="c"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">1</xbiz:simple></parameter><parameter name="n"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">2014</xbiz:simple></parameter></parameters></action>
java.lang.IllegalArgumentException: wrong number of arguments
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at com.justep.system.action.Engine.invokeActions(Native Method)
at com.justep.system.action.Engine.invokeActions(Unknown Source)
at com.justep.business.server.BusinessServer.doAction(Unknown Source)
at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)
[ERROR] 2014-10-10 15:04:38,948 com.justep.report.controller.DataController - 报表数据获取失败
执行Action出错, wrong number of arguments
com.justep.report.exception.ReportServerException: 报表数据获取失败
at com.justep.report.controller.DataController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.controller.InitController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.Servlet.a(Unknown Source)
at com.justep.report.Servlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.report.exception.ReportServerException: 执行Action出错, wrong number of arguments
at com.justep.report.controller.DataController.a(Unknown Source)
at com.justep.report.controller.DataController.a(Unknown Source)
... 20 more
Caused by: java.lang.Exception
... 22 more
|
|