做gird多行删除时 只能删除第一行且会紧接着弹出一个报错。

qinglangxiatian

2016-12-09 09:28:32 excute stream action, params:{"accept":"application/json","action":"saveJC_B_RKWLMX_DMAction","actionFlag":"__action_0__","activity":"entryStorage","contentType":"json","executeContext":"","executor":"","parameters":{"table":{"@type":"table","rows":[{"fCHL":{},"fDJ":{"value":8},"fFMainID":{"value":"133FE34E7922459FBFE937A6CD5A915B"},"fJLDW":{"value":"个"},"fJSHW":{},"fJSKQ":{},"fSHGYS":{},"fSHKF":{},"fSL":{},"fWPLB":{"value":"010604"},"fWPMC":{"value":"NKR 缓冲胶 "},"fWZBH":{"value":"0106040001"},"fXH":{},"fXZHW":{},"relation0":{},"userdata":{"id":{"value":"338EC998D3654B2D8DD01B3F4C507C54"},"isModified":false,"recordState":"delete"},"version":{"value":0}},{"fCHL":{},"fDJ":{"value":200},"fFMainID":{"value":"133FE34E7922459FBFE937A6CD5A915B"},"fJLDW":{"value":"件"},"fJSHW":{},"fJSKQ":{},"fSHGYS":{},"fSHKF":{},"fSL":{},"fWPLB":{"value":"011201"},"fWPMC":{"value":"康明斯鞍座"},"fWZBH":{"value":"0112010001"},"fXH":{},"fXZHW":{},"relation0":{},"userdata":{"id":{"value":"89753D5120AB4EE8AE3DAAB03BE34550"},"isModified":false,"recordState":"delete"},"version":{"value":0}}],"userdata":{"idColumnDefine":"JC_B_RKWLMX_DM","idColumnName":"JC_B_RKWLMX_DM","idColumnType":"String","model":"/greenPower/storehouseManagement/entryStorageManager/data","relationAlias":"fCHL,fDJ,fFMainID,fJLDW,fJSHW,fJSKQ,fSHGYS,fSHKF,fSL,fWPLB,fWPMC,fWZBH,fXH,fXZHW,relation0,version","relationTypes":"Float,Float,String,String,String,String,String,String,Float,String,String,String,String,String,String,Integer","relations":"JC_B_RKWLMX_DM.fCHL,JC_B_RKWLMX_DM.fDJ,JC_B_RKWLMX_DM.fFMainID,JC_B_RKWLMX_DM.fJLDW,JC_B_RKWLMX_DM.fJSHW,JC_B_RKWLMX_DM.fJSKQ,JC_B_RKWLMX_DM.fSHGYS,JC_B_RKWLMX_DM.fSHKF,JC_B_RKWLMX_DM.fSL,JC_B_RKWLMX_DM.fWPLB,JC_B_RKWLMX_DM.fWPMC,JC_B_RKWLMX_DM.fWZBH,JC_B_RKWLMX_DM.fXH,JC_B_RKWLMX_DM.fXZHW,EXPRESS,JC_B_RKWLMX_DM.version","sys.count":3,"sys.rowid":"JC_B_RKWLMX_DM","updateMode":"whereVersion"}}},"process":"/greenPower/storehouseManagement/entryStorageManager/process/entryStorage/entryStorageProcess"}
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: 编码: JUSTEP150180; 提示: 删除记录JC_B_RKWLMX_DM, JC_B_RKWLMX_DM, key="338EC998D3654B2D8DD01B3F4C507C54"出错, 不存在符合条件的数据, DELETE FROM JC_B_RKWLMX_DM JC_B_RKWLMX_DM WHERE JC_B_RKWLMX_DM= :JC_B_RKWLMX_DM AND JC_B_RKWLMX_DM.version = :version; 可能的原因: 数据被其他用户修改了; 数据被其他用户删除了
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableImpl.delete(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

qinglangxiatian

获取到的选中行的第二条信息id不正确导致的。下图附alert窗口获取的ID和数据库中ID两张图。
代码：Model.prototype.deleteBtnClick = function(event){
                var grid = this.comp("detailGrid");
                var rowIDs = grid.getCheckeds();//获取多选选中行的id.返回的是list数组
                alert(rowIDs)
                var data = this.comp("detailData");
                var rows = [];   
                for(var i=0;i<rowIDs.length;i++){//遍历多选选中的行id
            rows.push(data.getRowByID(rowIDs[i])) ; //通过行id获取到行，并push到中 }
            if (rows.length > 0){      
        data.deleteData(rows);
         };
         };
          };

qinglangxiatian

下图是我多选行时和alert窗口获取删除内容ID、数据库中对应物品的ID号不匹配

jishuang

data中的数据怎么来的？
这个跟多选无关，就是数据的问题

qinglangxiatian

数据就是正常INPUT写入数据库的，这不是选取行数据的ID错误吗

qinglangxiatian

是多选删除的问题，刚刚试了下即使能准确获取到两行准确的ID，依然只能删除一行。

jishuang

获取的ID就是你data中的数据，数据加载的是什么获取的就是什么

把数据库中的那条数据删了刷新页面看看数据还显示吗？

qinglangxiatian

什么意思？数据库手动删除数据吗？

jishuang

对，手动到数据库中把异常的这个记录删了，看看页面中还实现这个条数据吗？删除其他的还报错吗

chenhuiyu

刚遇到这个问题，现在解决了，不知楼主解决没有，可以参考下我的解决方式


Model.prototype.deleteBtnClick = function(event){
                var grid = this.comp("detailGrid");
                var rowIDs = grid.getCheckeds();//获取多选选中行的id.返回的是list数组
                alert(rowIDs)
                var data = this.comp("detailData");
                var rows = [];   
                for(var i=0;i<rowIDs.length;i++){//遍历多选选中的行id
            rows.push(data.getRowByID(rowIDs[i])) ; //通过行id获取到行，并push到中 }
            if (rows.length > 0){      
        data.deleteData(rows);
         };
         };
          };




//通过行id获取到行，并push到中 }
这个注释把“}”也注释了，把if移出循环试下