主从表对话框的问题

ef61

以主表建对话框页面的话，从表的数据就传不回去，就算windowDialog mapping 选的是从表概念。而且主表搜索出来后，不会出现对应从表的值。

但以从表建立的话，搜索功能就不能用了。

jishuang

不用模板向导，自己创建一个页面，设置主从，然后用windowDialog去关联这个页面操作看看

ef61

jishuang 发表于 2018-7-24 13:27
不用模板向导，自己创建一个页面，设置主从，然后用windowDialog去关联这个页面操作看看 ...

1.        
   
2. 刷新数据失败！ ,
   
3. 执行KSQL出错, KSQL: SELECT BASE_car.* FROM BASE_car BASE_car WHERE (((upper(BASE_cartree.fName) LIKE '%东%'))) LIMIT 0, 20
   
4. --> sql:
   
5. --> binds: []
   
6. 编码：JUSTEP150210
   
7. 隐藏详细
   
8. java.lang.reflect.InvocationTargetException at sun.reflect.GeneratedMethodAccessor154.invoke(Unknown Source) 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 com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 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: SELECT BASE_car.* FROM BASE_car BASE_car WHERE (((upper(BASE_cartree.fName) LIKE '%东%'))) LIMIT 0, 20 --> sql: --> binds: [] at com.justep.exception.BusinessException.create(Unknown Source) at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source) at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source) at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source) at com.justep.system.data.BizData.query(Unknown Source) at BizProcedure.query(BizProcedure.java:12) ... 29 more Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154041; 提示: KSQL语法错误, 未声明的符号BASE_cartree.fName at com.justep.exception.BusinessException.create(Unknown Source) at com.justep.util.Utils.check(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.checkSymTable(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source) ... 34 more
   

复制代码

在查询时遇到这个错误

ef61

process加了两个查询action了

jishuang

操作的都不是一个概念

ef61

jishuang 发表于 2018-7-24 17:14
操作的都不是一个概念

1. <?xml version="1.0" encoding="utf-8"?>
   
2. 
   
3. <div xmlns="http://www.w3.org/1999/xhtml" component="$UI/system/components/justep/window/window" xid="window" design="device:pc;">  
   
4.   <div component="$UI/system/components/justep/model/model" xid="model" style="height:auto;left:463px;top:331px;">
   
5.     <div component="$UI/system/components/justep/data/bizData" xid="dialogData"
   
6.       autoLoad="true" autoNew="false" concept="BASE_cartree" columns=""
   
7.       isTree="true">
   
8.       <reader action="/carFin/base/logic/action/queryBASE_cartreeAction"/>
   
9.       <treeOption parentRelation="fBaCarTreeUplink" nodeKindRelation=""
   
10.         rootFilter=""/>
    
11.     </div>
    
12.     <div component="$UI/system/components/justep/data/bizData" xid="searchData"
    
13.       autoLoad="true" autoNew="false" concept="BASE_car" isTree="false">
    
14.       <reader action="/carFin/base/logic/action/queryBASE_carAction"/>
    
15.     </div>
    
16.   <div component="$UI/system/components/justep/data/bizData" autoLoad="true" xid="carData" concept="BASE_car"><reader xid="default1" action="/carFin/base/logic/action/queryBASE_carAction"></reader>
    
17.   <master xid="default2" data="dialogData" relation="fBaCarDetailUplink"></master></div></div>  
    
18.   <span component="$UI/system/components/justep/windowReceiver/windowReceiver"
    
19.     xid="windowReceiver" style="top:2px;left:606px;" onReceive="windowReceiverReceive"/>  
    
20.   <div component="$UI/system/components/justep/panel/panel" class="x-panel x-full"
    
21.     xid="panel1">
    
22.     <div class="x-panel-top" xid="top2">
    
23.       <div component="$UI/system/components/bootstrap/row/row" class="row"
    
24.         xid="row1">
    
25.         <div class="col col-xs-6 col-md-4" xid="col1">
    
26.           <div component="$UI/system/components/justep/smartFilter/smartFilter"
    
27.             xid="smartFilter1" filterData="dialogData" filterCols="fName" onFilter="smartFilterFilter">
    
28.             <input type="text" class="form-control" placeholder="搜索" data-bind="valueUpdate: ['input', 'afterkeydown']"
    
29.               bind-value="$model.comp($element.parentElement).searchText" bind-change="$model.comp($element.parentElement).onInputChange.bind($model.comp($element.parentElement))"
    
30.               xid="input1"/>
    
31.           </div>
    
32.         </div>
    
33.       </div>
    
34.     </div>  
    
35.     <div class="x-panel-content" xid="content1">
    
36.         
    
37.       
    
38.     <div component="$UI/system/components/bootstrap/row/row" class="row" xid="row2">
    
39.    <div class="col col-xs-4" xid="col2"><div style="height:100%;overflow-x: hidden;" bind-visible="!showFilterGird.get()" class="x-bordered">
    
40.         <div component="$UI/system/components/justep/grid/grid" appearance="tree" data="dialogData" expandColumn="fName" useVirtualRoot="true" virtualRootLabel="车辆品牌" xid="treeGrid" class="x-grid-no-bordered" height="auto" width="100%" onRowClick="treeGridRowClick">
    
41.           <columns xid="columns2">
    
42.             <column name="fName" />
    
43.           </columns>
    
44.         </div>
    
45.       </div><div class="x-bordered" style="display:none;height:0;" bind-visible="showFilterGird" xid="searchDiv">
    
46.         <div component="$UI/system/components/justep/dataTables/dataTables" flexibleWidth="true" data="searchData" rowActiveClass="active" class="table" xid="searchGrid" scrollCollapse="false" ordering="false" lengthMenu="20" onRowSelect="searchGridRowSelect">
    
47.           <columns>
    
48.             <column name="fName" />
    
49.           </columns>
    
50.         </div>
    
51.       </div></div>
    
52.    <div class="col col-xs-4" xid="col4"><div component="$UI/system/components/justep/dataTables/dataTables" flexibleWidth="true" data="carData" rowActiveClass="active" class="table" xid="dataTables" scrollCollapse="false" ordering="false" lengthMenu="20" onRowSelect="dataTablesRowSelect">
    
53.    <columns xid="columns1">
    
54.     <column name="fName" xid="column1"></column></columns> </div></div></div></div>  
    
55.     <div class="x-panel-bottom" xid="bottom1" height="42">
    
56.       <a component="$UI/system/components/justep/button/button" class="btn btn-link btn-only-label x-dialog-button"
    
57.         label="取消" xid="cancelBtn" onClick='{"operation":"windowReceiver.windowCancel"}'>
    
58.         <i xid="i2"/>  
    
59.         <span xid="span2">取消</span>
    
60.       </a>  
    
61.       <a component="$UI/system/components/justep/button/button" class="btn btn-primary x-dialog-button"
    
62.         label="确定" xid="OKBtn" onClick="OKBtnClick" bind-enable="canOK">
    
63.         <i xid="i1"/>  
    
64.         <span xid="span1">确定</span>
    
65.       </a>
    
66.     </div>
    
67.   </div>
    
68. </div>

复制代码

1. define(function(require){
   
2.         var $ = require("jquery");
   
3.         var justep = require("$UI/system/lib/justep");
   
4.         var Data = require("$UI/system/components/justep/data/data");
   
5. 
   
6.         var Model = function(){
   
7.                 this.showFilterGird = justep.Bind.observable(false);
   
8.                 this.initOK = justep.Bind.observable(false);
   
9.                 this.result = justep.Bind.observable();
   
10.                
    
11.                 this.canOK = justep.Bind.computed(function(){
    
12.                         if(!this.initOK.get()) return false;
    
13.                         if(this.getSelected()) return true;
    
14.                         else return false;
    
15.                 },this);
    
16.                
    
17.                 this.callParent();
    
18.         };
    
19. 
    
20.         Model.prototype.getSelected = function(){
    
21.                 return this.result.get();
    
22.         };
    
23.         
    
24.         Model.prototype.OKBtnClick = function(event){
    
25.                 this.comp('windowReceiver').windowEnsure(this.getSelected());
    
26.         };
    
27. 
    
28.         Model.prototype.getTreeData = function(){
    
29.                 return this.comp('dialogData');
    
30.         };
    
31.         
    
32.         Model.prototype.setSelected = function(selected) {
    
33.                 return this.result.set(selected);
    
34.         };
    
35.         
    
36.         Model.prototype.windowReceiverReceive = function(event){
    
37.                 if (event.data) {
    
38.                         if (event.data.selected) {
    
39.                                 this.comp('dataTables').setSelection(event.data.selected);
    
40.                         }
    
41.                 }
    
42.                 this.initOK.set(true);
    
43.         };
    
44.         
    
45.         Model.prototype.smartFilterFilter = function(event){
    
46.                 var filter = event.source;
    
47.                 var v = filter.getFilterStr();
    
48.                 var selectedRow = null;
    
49.                 if(v){
    
50.                         this.showFilterGird.set(true);
    
51.                         $(this.getElementsByXid('searchDiv')).css({height:'100%',position: 'relative'});
    
52.                         var searchData = this.comp('searchData');
    
53.                         searchData.setFilter(filter.getFilterFlag(), filter.getFilterStr());
    
54.                         searchData.refreshData();
    
55.                         selectedRow = searchData.getCurrentRow();
    
56.                 }else{
    
57.                         this.showFilterGird.set(false);
    
58.                         $(this.getElementsByXid('searchDiv')).css({height:0,position: 'absolute'});
    
59.                         this.comp('treeGrid').autoSize();
    
60.                         selectedRow = null;
    
61.                 }
    
62.                 this.setSelected(selectedRow);
    
63.         };
    
64.         
    
65.         Model.prototype.treeGridRowClick = function(event){
    
66.                 this.setSelected(this.getTreeData().getRowByID(event.rowID));
    
67.         };
    
68.         
    
69.         Model.prototype.searchGridRowSelect = function(event){
    
70.                 this.setSelected(event.row);
    
71.         };
    
72.         
    
73.         Model.prototype.dataTablesRowSelect = function(event){
    
74.                 this.setSelected(event.row);
    
75.         };
    
76.         
    
77.         return Model;
    
78. });

复制代码

现在做的还是在模板上改的，不知道查询这个在哪里修改
carData是从表。

jishuang

组件关联的data正确吗？事件中操作的data正确吗？

ef61

jishuang 发表于 2018-7-25 10:19
组件关联的data正确吗？事件中操作的data正确吗？

searchData那里没改的问题。
但搜索后，点击主表就不会出现对应的从表数据。

jishuang

把sql语句打看从表执行的sql是什么
http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035

ef61

jishuang 发表于 2018-7-25 11:19
把sql语句打看从表执行的sql是什么
http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=33524 ...

1. 2018-07-25 11:40:28 [SQL Time]sql 执行时间：19ms, exec KSQL: SELECT BASE_cartree.*  FROM BASE_cartree BASE_cartree WHERE (((upper(BASE_cartree.fName) LIKE '%东%'))) LIMIT 0, 20
   
2.   --> sql:SELECT  BASE_cartree.fID AS BASE_cartree, BASE_cartree.FBACARTREEUPLINK AS fBaCarTreeUplink, BASE_cartree.FCARTHREEID AS fCarThreeid, BASE_cartree.FCODE AS fCode, BASE_cartree.FCOMPANY AS fCompany, BASE_cartree.FCREATETIME AS fCreateTime, BASE_cartree.FCREATEUSER AS fCreateUser, BASE_cartree.FDESCRIPTION AS fDescription, BASE_cartree.FGROUPNAME AS fGroupName, BASE_cartree.FISLEAF AS fIsLeaf, BASE_cartree.FLASTUPDATETIME AS fLastUpdateTime, BASE_cartree.FLASTUPDATEUSER AS fLastUpdateUser, BASE_cartree.FLEVEL AS fLevel, BASE_cartree.FLONGNAME AS fLongName, BASE_cartree.FLONGNUMBER AS fLongNumber, BASE_cartree.FNAME AS fName, BASE_cartree.FNUMBER AS fNumber, BASE_cartree.FSTATUS AS fStatus, BASE_cartree.FSYNCTIME AS fSyncTime FROM base_cartree BASE_cartree  WHERE UPPER(BASE_cartree.FNAME) LIKE ?
   
3. --> binds:[%东%]
   
4. 2018-07-25 11:40:28 [SQL Time]sql 执行时间：5ms, exec KSQL:
   
5.   --> sql:SELECT count(*) FROM base_cartree BASE_cartree  WHERE UPPER(BASE_cartree.FNAME) LIKE ?
   
6. --> binds:[%东%]

复制代码

搜索后没有从表的select操作