对话框选择数据后怎么回显到表单

lugangboy

点击选择合同按钮，在弹出的对话框里选择一条数据，然后把这条数据回显在表单中进行修改某些字段，保存时还要把修改过的字段记录下来存到修改记录表里，请问可以怎么操作

jishuang

用windowDialog设置mapping,主窗口数据操作方式设置为修改当前行数据

lugangboy

恩，能回显了，回显后当修改字段时，需要把修改的字段保存到修改记录表里，该表字段
修改字段
旧值
新值
修改人
修改时间

需要怎么去实现

lugangboy

C:\Users\admin\Desktop\QQ图片20170725110352.png
数据回显修改后点流转，报错
       
保存数据失败！ ,
执行KSQL出错, KSQL: INSERT INTO HT_info HT_info(HT_info, HT_info.version, HT_info.amount, HT_info.attachment, HT_info.beginTime, HT_info.checkState, HT_info.code, HT_info.endTime, HT_info.executor, HT_info.fFID, HT_info.firstCompany, HT_info.moneyType, HT_info.name, HT_info.participator, HT_info.projectStatus, HT_info.property, HT_info.recordCode, HT_info.recordDate, HT_info.registrant, HT_info.remark, HT_info.signDate, HT_info.startOrg, HT_info.status, HT_info.type) VALUES (:HT_info, :version, :amount, :attachment, :beginTime, :checkState, :code, :endTime, :executor, :fFID, :firstCompany, :moneyType, :name, :participator, :projectStatus, :property, :recordCode, :recordDate, :registrant, :remark, :signDate, :startOrg, :status, :type)
编码：JUSTEP150210
隐藏详细
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: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO HT_info HT_info(HT_info, HT_info.version, HT_info.amount, HT_info.attachment, HT_info.beginTime, HT_info.checkState, HT_info.code, HT_info.endTime, HT_info.executor, HT_info.fFID, HT_info.firstCompany, HT_info.moneyType, HT_info.name, HT_info.participator, HT_info.projectStatus, HT_info.property, HT_info.recordCode, HT_info.recordDate, HT_info.registrant, HT_info.remark, HT_info.signDate, HT_info.startOrg, HT_info.status, HT_info.type) VALUES (:HT_info, :version, :amount, :attachment, :beginTime, :checkState, :code, :endTime, :executor, :fFID, :firstCompany, :moneyType, :name, :participator, :projectStatus, :property, :recordCode, :recordDate, :registrant, :remark, :signDate, :startOrg, :status, :type) at com.justep.exception.BusinessException.create(Unknown Source) at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(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.impl.TableImpl.insert(Unknown Source) at com.justep.system.data.impl.TableImpl.save(Unknown Source) at com.justep.system.data.impl.TableImpl.save(Unknown Source) at com.justep.system.data.BizData.save(Unknown Source) at BizProcedure.save(BizProcedure.java:18) ... 27 more Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO HT_INFO (HT_INFO.fID, HT_INFO.VERSION, HT_INFO.AMOUNT, HT_INFO.ATTACHMENT, HT_INFO.BEGINTIME, HT_INFO.CHECKSTATE, HT_INFO.CODE, HT_INFO.ENDTIME, HT_INFO.EXECUTOR, HT_INFO.FFID, HT_INFO.FIRSTCOMPANY, HT_INFO.MONEYTYPE, HT_INFO.NAME, HT_INFO.PARTICIPATOR, HT_INFO.PROJECTSTATUS, HT_INFO.PROPERTY, HT_INFO.RECORDCODE, HT_INFO.RECORDDATE, HT_INFO.REGISTRANT, HT_INFO.REMARK, HT_INFO.SIGNDATE, HT_INFO.STARTORG, HT_INFO.STATUS, HT_INFO.TYPE) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), binds: [5154C27F213D4984A803FB23780FFA24, 0, 123.45, null, 2017-07-17, 未抽查, JUSTEP0113, 2017-07-17, null, null, 12312, 人民币, ce, null, 已完成, 普通合同, null, 2017-07-18 22:09:31.0, system, null, 2017-07-04, 起步软件, null, 其他]出错 at com.justep.exception.BusinessException.create(Unknown Source) at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source) ... 36 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '5154C27F213D4984A803FB23780FFA24' for key 'PRIMARY' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:422) at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) at com.mysql.jdbc.Util.getInstance(Util.java:383) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ... 37 more

jishuang

如果旧值是数据库中本来存在的，可以在saveAction的事件中获取到旧值去存到修改的表中
http://bbs.wex5.com/forum.php?mo ... 6&pid=164970552

如果都是前端新填写的值可以在data的onValueChange事件中获取到旧值去操作

Duplicate entry '5154C27F213D4984A803FB23780FFA24' for key 'PRIMARY'  报错是主键值重复了

lugangboy

我只是做更新，主键重复相当于新增了，是不是要自定义action写更新的方法

jishuang

在data的新增事件中加alert提示看看新增执行了几次

lugangboy

自定义了更新的方法

1. public class Htmanage {
   
2.       
   
3.         public static Boolean htChange(String HT_info,java.sql.Date beginTime,java.sql.Date endTime,BigDecimal amount,String moneyType,String checkState){
   
4.                
   
5.                 String ksql="update HT_info h set h.beginTime=:beginTime,h.endTime=:endTime,h.amount=:amount,h.moneyType=:moneyType,h.checkState=:checkState where h=:HT_info";
   
6.                 Map<String,Object> params=new HashMap<String, Object>();
   
7.                 params.put("HT_info", HT_info);
   
8.                 params.put("beginTime",beginTime);
   
9.                 params.put("endTime",endTime);
   
10.                 params.put("amount", amount);
    
11.                 params.put("moneyType", moneyType);
    
12.                 params.put("checkState", checkState);
    
13.                 KSQL.executeUpdate(ksql,params, "/ht/htmanage/data", null);
    
14.                 return true;
    
15.         }
    
16. }

复制代码

在.w页面点流转的时候调用

1. Model.prototype.advanceBtnClick = function(event){
   
2.                 var data=this.comp("mainData");
   
3.                 //创建参数对象实例
   
4.                 var params=new Request.ActionParam();
   
5.                 params.setString("HT_info",data.getValue("HT_info"));
   
6.                 params.setData("beginTime",data,getValue("beginTime"));
   
7.                 params.setData("endTime",data.getValue("endTime"));
   
8.                 params.setDecimal("amount",data,getValue("amount"));
   
9.                 params.setString("moneyType",data.getValue("moneyType"));
   
10.                 params.setString("checkState",data.getValue("checkState"));
    
11.                 $UI/system/lib/base/request.sendBizRequest({
    
12.                         process:justep.Context.getCurrentProcess(),
    
13.                         activity:justep.Context.getCurrentActivity(),
    
14.                         executor:justep.Context.getExecutor(),
    
15.                         async:false,//是否异步请求
    
16.                         contentType:"application/json",
    
17.                         dataType:"json",
    
18.                         action:"htChange",
    
19.                         callback:function(result){
    
20.                                 if(result.state){
    
21.                                         alert("流转成功！");
    
22.                                 }else {
    
23.                                         throw new Error("流转失败！|"+result.response.message);
    
24.                                 }
    
25.                         }
    
26.                        
    
27.                
    
28.                 });
    
29.                
    
30.         };

复制代码

结果报错：
       
保存数据失败！ ,
"/ht/htmanage/process/htChange/htChange"没有定义参数"table"
编码：JUSTEP150084
隐藏详细
com.justep.exception.BusinessException: 编码: JUSTEP150084; 提示: "/ht/htmanage/process/htChange/htChange"没有定义参数"table" at com.justep.exception.BusinessException.create(Unknown Source) at com.justep.util.Utils.check(Unknown Source) at com.justep.system.transform.RequestTransform.transActionParams(Unknown Source) at com.justep.system.transform.RequestTransform.transform(Unknown Source) at com.justep.system.action.Engine.translateParameters(Unknown Source) 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)

jishuang

1.可以把调用action放到process的流转查询前事件或者在data的保存事件中
2.

1. $UI/system/lib/base/request.sendBizRequest({
   
2.                         process:justep.Context.getCurrentProcess(),
   
3.                         activity:justep.Context.getCurrentActivity(),
   
4.                         executor:justep.Context.getExecutor(),
   
5.                         async:false,//是否异步请求
   
6.                         contentType:"application/json",
   
7.                         dataType:"json",
   
8.                         action:"htChange",
   
9.                         callback:function(result){
   
10.                                 if(result.state){
    
11.                                         alert("流转成功！");
    
12.                                 }else {
    
13.                                         throw new Error("流转失败！|"+result.response.message);
    
14.                                 }
    
15.                         }
    
16.                         

复制代码

改为：

1. Request.sendBizRequest({
   
2.                         process:this.getContext().getCurrentProcess(),
   
3.                         activity:this.getContext().getCurrentActivity(),
   
4.                         executor:this.getContext().getExecutor(),
   
5.                         contentType:"application/json",
   
6.                         dataType:"json",
   
7.                         action:"htChange",
   
8.                         callback:function(result){
   
9.                                 if(result.state){
   
10.                                         alert("流转成功！");
    
11.                                 }else {
    
12.                                         throw new Error("流转失败！|"+result.response.message);
    
13.                                 }
    
14.                         }

复制代码

lugangboy

改了还是报上面这个错
保存数据失败！ ,
"/ht/htmanage/process/htChange/htChange"没有定义参数"table"
编码：JUSTEP150084