流转后修改字段值

波斯大香蕉

jishuang 发表于 2017-3-16 16:07
update AP_YPSQZB sq set sq.FDJZT = '审批完成',sq.FSPR = '" + spr + "',sq.FSPSJ= :currentData() where ...

是的，这样写会报错：报错如下：
VM3349:17 Uncaught Error: __justepServerErrorStart__{"message":"编译模块\"/apply/apply/process/apply\"中的类\"ApplyProcess\"出错 \r\n警告: [options] 未与 -source 1.5 一起设置引导类路径\r\n警告: [options] 源值1.5已过时, 将在未来所有发行版中删除\r\n警告: [options] 目标值1.5已过时, 将在未来所有发行版中删除\r\n警告: [options] 要隐藏有关已过时选项的警告, 请使用 -Xlint:-options。\r\nG:\\BeX5_V3.6\\model\\BIZ\\apply\\apply\\process\\apply\\dsrc\\ApplyProcess.java:61: 错误: 对于executeUpdate(String,String,<空值>), 找不到合适的方法\r\n\t\tKSQL.executeUpdate(sprSql, \"/apply/apply/data\", null);\r\n\t\t    ^\r\n    方法 KSQL.executeUpdate(String,Map<String,Object>,Model,Model)不适用\r\n      (实际参数列表和形式参数列表长度不同)\r\n    方法 KSQL.executeUpdate(String,Map<String,Object>,String,Model)不适用\r\n      (实际参数列表和形式参数列表长度不同)\r\n    方法 KSQL.executeUpdate(String,Map<String,Object>,Model,Model,Transaction)不适用\r\n      (实际参数列表和形式参数列表长度不同)\r\n    方法 KSQL.executeUpdate(String,Map<String,Object>,String,Model,Transaction)不适用\r\n      (实际参数列表和形式参数列表长度不同)\r\n1 个错误\r\n4 个警告\r\n","reason":"","code":"JUSTEP151044","stack":"java.lang.reflect.InvocationTargetException\r\n\tat sun.reflect.GeneratedMethodAccessor138.invoke(Unknown Source)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat java.lang.reflect.Method.invoke(Method.java:497)\r\n\tat com.justep.system.action.Engine.invokeActions(Native Method)\r\n\tat com.justep.system.action.Engine.invokeActions(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doAction(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doExcute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.execService(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat com.justep.x.bs.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\r\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\r\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\r\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\r\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)\r\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\r\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)\r\n\tat org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)\r\n\tat org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)\r\n\tat org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)\r\n\tat java.lang.Thread.run(Thread.java:745)\r\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP151044; 提示: 编译模块\"/apply/apply/process/apply\"中的类\"ApplyProcess\"出错 \r\n警告: [options] 未与 -source 1.5 一起设置引导类路径\r\n警告: [options] 源值1.5已过时, 将在未来所有发行版中删除\r\n警告: [options] 目标值1.5已过时, 将在未来所有发行版中删除\r\n警告: [options] 要隐藏有关已过时选项的警告, 请使用 -Xlint:-options。\r\nG:\\BeX5_V3.6\\model\\BIZ\\apply\\apply\\process\\apply\\dsrc\\ApplyProcess.java:61: 错误: 对于executeUpdate(String,String,<空值>), 找不到合适的方法\r\n\t\tKSQL.executeUpdate(sprSql, \"/apply/apply/data\", null);\r\n\t\t    ^\r\n    方法 KSQL.executeUpdate(String,Map<String,Object>,Model,Model)不适用\r\n      (实际参数列表和形式参数列表长度不同)\r\n    方法 KSQL.executeUpdate(String,Map<String,Object>,String,Model)不适用\r\n      (实际参数列表和形式参数列表长度不同)\r\n    方法 KSQL.executeUpdate(String,Map<String,Object>,Model,Model,Transaction)不适用\r\n      (实际参数列表和形式参数列表长度不同)\r\n    方法 KSQL.executeUpdate(String,Map<String,Object>,String,Model,Transaction)不适用\r\n      (实际参数列表和形式参数列表长度不同)\r\n1 个错误\r\n4 个警告\r\n\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.model.impl.ModelImpl$DynamicClassManager.compile(Unknown Source)\r\n\tat com.justep.model.impl.ModelImpl$DynamicClassManager.getDynamicClass(Unknown Source)\r\n\tat com.justep.model.impl.ModelImpl$DynamicClassManager.getDynamicMethod(Unknown Source)\r\n\tat com.justep.model.impl.ModelImpl.getModelMethod(Unknown Source)\r\n\tat com.justep.system.action.Engine.invokeAction(Native Method)\r\n\tat com.justep.system.action.Engine.invokeAction(Unknown Source)\r\n\tat com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)\r\n\tat com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)\r\n\tat com.justep.system.action.ActionUtils.invokeAction(Unknown Source)\r\n\tat com.justep.system.process.ProcessUtils.advanceProcess(Unknown Source)\r\n\tat ExternalProcessProcedure.advanceProcess(ExternalProcessProcedure.java:30)\r\n\t... 26 more\r\n","messages":["编码: JUSTEP151044; 提示: 编译模块\"/apply/apply/process/apply\"中的类\"ApplyProcess\"出错 \r\n警告: [options] 未与 -source 1.5 一起设置引导类路径\r\n警告: [options] 源值1.5已过时, 将在未来所有发行版中删除\r\n警告: [options] 目标值1.5已过时, 将在未来所有发行版中删除\r\n警告: [options] 要隐藏有关已过时选项的警告, 请使用 -Xlint:-options。\r\nG:\\BeX5_V3.6\\model\\BIZ\\apply\\apply\\process\\apply\\dsrc\\ApplyProcess.java:61: 错误: 对于executeUpdate(String,String,<空值>), 找不到合适的方法\r\n\t\tKSQL.executeUpdate(sprSql, \"/apply/apply/data\", null);\r\n\t\t    ^\r\n    方法 KSQL.executeUpdate(String,Map<String,Object>,Model,Model)不适用\r\n      (实际参数列表和形式参数列表长度不同)\r\n    方法 KSQL.executeUpdate(String,Map<String,Object>,String,Model)不适用\r\n      (实际参数列表和形式参数列表长度不同)\r\n    方法 KSQL.executeUpdate(String,Map<String,Object>,Model,Model,Transaction)不适用\r\n      (实际参数列表和形式参数列表长度不同)\r\n    方法 KSQL.executeUpdate(String,Map<String,Object>,String,Model,Transaction)不适用\r\n      (实际参数列表和形式参数列表长度不同)\r\n1 个错误\r\n4 个警告\r\n"],"url":"","param":""}__justepServerErrorEnd__create @ core.min.js:71Request.errorMessage @ biz.common.min.js:12Request._requestCallback @ biz.common.min.js:12(anonymous function) @ biz.common.min.js:12f @ core.min.js:71add @ core.min.js:71Request.endBatch @ biz.common.min.js:12_doProcess @ VM3349:17advanceExt @ VM3349:17(anonymous function) @ VM3349:17fire @ core.min.js:71fireEvent @ core.min.js:71callParent @ core.min.js:71fireEvent @ common.min.js:15receiverSend @ comp.min.js:144windowEnsure @ comp.min.js:144Model.okBtnClick @ processDialog.m.js:180fire @ core.min.js:71fireEvent @ core.min.js:71callParent @ core.min.js:71fireEvent @ common.min.js:15_doClick @ comp.min.js:144i @ core.min.js:71dispatch @ core.min.js:71g.handle @ core.min.js:71

jishuang

报错的是参数的问题，把完整的java代码发一下看看

波斯大香蕉

jishuang 发表于 2017-3-16 16:44
报错的是参数的问题，把完整的java代码发一下看看

String key = ProcessUtils.getProcessData1();
                // 审批人
                String spr = ContextHelper.getOperator().getName();
                String sprSql = "update AP_YPSQZB sq set sq.FDJZT = '审批完成',sq.FSPR = '" + spr + "',sq.FSPSJ= :currentData() where sq = '" + key + "'";
                KSQL.executeUpdate(sprSql, "/apply/apply/data", null);

jishuang

KSQL.executeUpdate是4个参数，你的只有3个
KSQL.executeUpdate(sprSql,null, "/apply/apply/data", null);

波斯大香蕉

jishuang 发表于 2017-3-17 13:58
KSQL.executeUpdate是4个参数，你的只有3个
KSQL.executeUpdate(sprSql,null, "/apply/apply/data", null); ...

改了之后报错如下：
2017-03-17 15:03:14 excute stream action, params:{"actions":[{"accept":"application/json","action":"externalAdvanceProcessAction","actionFlag":"__action_0__","activity":"businessActivity2","contentType":"application/json","executeContext":"","executor":"","parameters":{"control":{"class":"com.justep.system.process.ProcessControl","object":{"@@tag":"process-control","customized-enabled":"false","dialog-enabled":"true","jump-enabled":"false","message":"","notice":[],"postscript":"","save-history":"true","status":"none","task-join":"false","task-join-mode":"tjmMultiple","to":[{"@activity-id":"2B31D2F1C0F44955B54B3F06637F2472","@id":"2B31D2F1C0F44955B54B3F06637F2472","@is-end":"true","@readonly":"true","@selected":"true","executor-kinds":"","executor-range":[],"executors":[],"process":"/apply/apply/process/apply/applyProcess","task-relation-value":{"@@tag":"task-relation-value","SA_Task":"DF0DBFB98007458386FFAEF4A7D0C667","sActivityInTemplate":"end1","sActivityName":"","sLastModifyTime":"2017-03-17T15:02:43.223Z","sLock":"CBF66A6CA214482184665DB092266345","sProcess":"/apply/apply/process/apply/applyProcess","sProcessName":"样品申领","sProcessTemplateID2":"","sTypeName":"样品申领"},"template":"","unit":"end1"}]}},"task":"7B4B2721DC11483796A8A55A11E0A2EF"},"process":"/apply/apply/process/apply/applyProcess"}]}
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        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.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:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeAction(Native Method)
        at com.justep.system.action.Engine.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
        at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
        at com.justep.system.process.ProcessUtils.advanceProcess(Unknown Source)
        at ExternalProcessProcedure.advanceProcess(ExternalProcessProcedure.java:30)
        ... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: update AP_YPSQZB sq set sq.FDJZT = '审批完成',sq.FSPR = 'system',sq.FSPSJ= :currentData() where sq = '4BB08F4004C2420AA197ACB4AFAE0F03'
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlUpdate(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at ApplyProcess.businessActivity2AfterAdvance(ApplyProcess.java:60)
        ... 38 more
Caused by: com.justep.model.exception.ModelException: 编码: JUSTEP154064; 提示: 计算表达式currentData()出错
        at com.justep.model.exception.ModelException.create(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.evaluate(Unknown Source)
        at com.justep.system.ksql.visitor.SQLStruct.generateBinds(Unknown Source)
        at com.justep.system.ksql.visitor.SQLStruct.generateBinds(Unknown Source)
        ... 44 more
Caused by: com.justep.model.exception.ModelException: 编码: JUSTEP154075; 提示: 调用函数currentData出错
        at com.justep.model.exception.ModelException.create(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.functionExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.constExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.unaryExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.multiExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.addExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.compExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.notExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.andExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.orExpression(Unknown Source)
        ... 47 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154067; 提示: 模块/system/logic/fn中找不到函数currentData定义
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.getMethod(Unknown Source)
        ... 56 more

jishuang

:currentDate()

波斯大香蕉

jishuang 发表于 2017-3-17 16:24
:currentDate()

String key = ProcessUtils.getProcessData1();
// 审批人
String spr = ContextHelper.getOperator().getName();
String sprSql = "update AP_YPSQZB sq set sq.FDJZT = '审批完成',sq.FSPR = '" + spr + "',sq.FSPSJ= :currentData() where sq = '" + key + "'";
KSQL.executeUpdate(sprSql,null, "/apply/apply/data", null);

jishuang

函数拼错了改一下啊

yyy66887

在KQL.select方法中有一个参数fnModel，这个参数类型是Model类型的，但是前面传过来是String类型的，我想问下如何将String转成Model类型？我查了下API好像没找到。