|
版本: |
X5.2.5 |
小版本号: |
|
|
|
数据库: |
MS SQLServer |
服务器操作系统: |
Windows |
应用服务器: |
Tomcat |
客户端操作系统: |
Windows 其它 |
浏览器: |
Chrome |
|
|
自定义Action,参数和bizQueryProcedure都一样,只是select语句在代码里面自己重写了,用的是SQL而不是KSQL,看了语法没错,但页面加载的时候总报错,麻烦帮忙看一下。。。
报错信息:- com.justep.model.exception.ModelException: java.lang.RuntimeException: compile error :
- E:\X5.2.5\X5.2.5\model\BIZ\OA\workTime\logic\code\dsrc\WorkTime.java:30: 找不到符号
- 符号: 方法 select(java.lang.String,,java.lang.String)
- 位置: 类 com.justep.system.data.SQL
- Table result=SQL.select(strSql, null, dataModel);
- ^
- 1 错误
- 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)
- Caused by: java.lang.RuntimeException: compile error :
- E:\X5.2.5\X5.2.5\model\BIZ\OA\workTime\logic\code\dsrc\WorkTime.java:30: 找不到符号
- 符号: 方法 select(java.lang.String,,java.lang.String)
- 位置: 类 com.justep.system.data.SQL
- Table result=SQL.select(strSql, null, dataModel);
- ^
- 1 错误
- at com.justep.model.impl.ModelImpl$DynamicClassManager.compile(Unknown Source)
- at com.justep.model.impl.ModelImpl$DynamicClassManager.getDynamicClass(Unknown Source)
- at com.justep.model.impl.ModelImpl$DynamicClassManager.getDynamicMethod(Unknown Source)
- at com.justep.model.impl.ModelImpl.getModelMethod(Unknown Source)
- at com.justep.system.action.Engine.invokeActions(Native Method)
- ... 21 more
- url:/UI/system/service/common/bizAction.j
- param:{"process":"/OA/workTime/process/scheduling/schedulingProcess","activity":"scheduling","actionFlag":"__action_0__","executor":"BF047D084F3F4C97874418C920C699C8","executeContext":"","action":"queryShift","parameters":{"variables":{},"filter":"(fUseStatus='1')","offset":0,"limit":20,"columns":"cName,fCode","orderBy":"fCode ASC"},"translateParameter":{"dataType":"row-list","transformIdcolumn":true,"useNamespace":true,"cellnameByRelation":false,"rowsConfig":{"concept":"OA_WM_SHIFT","sequence":"fCode,cName"}}}
复制代码 自定义queryAction代码:- public static Table queryShift(String concept,String idColumn,String select,String from,String condition,
- List range,String filter,Boolean distinct,Integer offset,Integer limit,
- String columns,String orderBy,String aggregate,String aggregateColumns,Map variables,
- String dataModel,String fnModel){
-
- java.sql.Connection conn=null;
- dataModel="/OA/workTime/data";
- concept="OA_WM_SHIFT";
- idColumn="OA_WM_SHIFT.fCode";
- conn=com.justep.model.ModelUtils.getConnectionInTransaction(dataModel);
- String strSql="";
- strSql="SELECT OA_WM_SHIFT.fCode, OA_WM_SHIFT.fName+' '"
- +"+case when (fTime3 is null) then right(CONVERT(varchar(16), FTIME1, 120),5)+'-'+right(CONVERT(varchar(16), FTIME2, 120),5) "
- +"when (FTIME3 is not null) and (FTIME5 is not null) "
- +"then right(CONVERT(varchar(16), FTIME1, 120),5)+'-'+right(CONVERT(varchar(16), FTIME2, 120),5)+',"
- +"'+right(CONVERT(varchar(16), FTIME3, 120),5)+'-'+right(CONVERT(varchar(16), FTIME4, 120),5)+','"
- +"+right(CONVERT(varchar(16), FTIME5, 120),5)+'-'+right(CONVERT(varchar(16), FTIME6, 120),5) "
- +"else right(CONVERT(varchar(16), FTIME1, 120),5)+'-'+right(CONVERT(varchar(16), FTIME2, 120),5)+',"
- +"'+right(CONVERT(varchar(16), FTIME3, 120),5)+'-'+right(CONVERT(varchar(16), FTIME4, 120),5) end as cName FROM OA_WM_SHIFT";
-
- Table result=SQL.select(strSql, null, dataModel);
- return result;
-
- }
复制代码 |
|