tree的设置和显示-------------在线等啊

justepX5007

自己新建一张数据表，用于存放显示数据。A为单位、B为部门、C为人员。不同单位对应不同部门，不同部门对应不同人员。请问，在新建表的时候，应该如何设置父节点ID、子节点ID。以及在tree-option中应该如何parent、root-filter等属性，可以具体分析下吗？

zhaixin

和一般的树形数据没有区别，多加一列类型区分单位、部门、人员即可
树形数据的配置参考 快速开发指南 7.1 树形实例

justepX5007

zhaixin 发表于 2013-8-13 15:07
和一般的树形数据没有区别，多加一列类型区分单位、部门、人员即可
树形数据的配置参考 快速开发指南 7.1  ...

看实例。意思父和子这两个关系是必须要添加的啊，sParent、sChild；以及业务数据关系——类型代码和类型名称也都是缺一不可的啊

zhaixin

如果不使用级联删除，sChild可以没有
业务数据关系，只有名称就可以

justepX5007

zhaixin 发表于 2013-8-13 15:26
如果不使用级联删除，sChild可以没有
业务数据关系，只有名称就可以

你好！遇到新问题一个：刷新界面时报错了ksql:SELECT SAL_XCBBB.* FROM SAL_XCBBB SAL_XCBBB LIMIT 0, -1时出错！ 详细

MaHZ

justepX5007 发表于 2013-8-13 17:30
你好！遇到新问题一个：刷新界面时报错了ksql:SELECT SAL_XCBBB.* FROM SAL_XCBBB SAL_XCBBB LIMIT 0, -1 ...

后台错误信息贴上来

justepX5007

MaHZ 发表于 2013-8-13 17:33
后台错误信息贴上来

Caused by: com.justep.model.exception.ModelException: 执行ksql:SELECT SAL_XCBBB.*  FROM SAL_XCBBB SAL_XCBBB WHERE (("PARID is null")) LIMIT 0, -1时出错！
        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)
        ... 26 more
Caused by: com.justep.model.exception.ModelException: 关系SAL_XCBBB.fZJD定义了互逆，但找不到它的类型指向的概念String
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.system.ksql.ConceptMapping.fillDefaultMapping(Unknown Source)
        at com.justep.system.ksql.ConceptMapping.getConceptMapping(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.confirmSymTable(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.handleAllRelation(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unknown Source)
        at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
        at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
        ... 31 more

jishuang

概念中fZJD的关系类型定义的什么?

justepX5007

jishuang 发表于 2013-8-14 09:37
概念中fZJD的关系类型定义的什么?

父子类型都是String

justepX5007

jishuang 发表于 2013-8-14 09:37
概念中fZJD的关系类型定义的什么?

你好！我将关系类型改成概念
com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
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.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at com.justep.system.action.Engine.invokeActions(Native Method)
... 21 more
Caused by: com.justep.model.exception.ModelException: 执行ksql:SELECT SAL_XCBBB.* FROM SAL_XCBBB SAL_XCBBB WHERE (("PARID is null")) LIMIT 0, -1时出错！
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)
... 26 more
Caused by: com.justep.system.ksql.matcher.TokenMatchException: _XCBBB WHERE ((^^"PARID is null" 中未找到需要的token, 位置：53 需要下列之一：STRING, NUMBER, ONE_RELATION, IDENTIFER, VARIABLE
at com.justep.system.ksql.parser.AbstractParser.constExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.unaryExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.multiExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.addExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.compExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.notExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.andExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.orExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.unaryExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.multiExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.addExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.compExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.notExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.andExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.orExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.unaryExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.multiExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.addExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.compExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.notExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.andExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.orExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.conditionExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.whereExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
... 31 more

url:/UI/system/service/common/bizAction.j
param:0-1