起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 5991|回复: 2

[结贴] 树形结构查询时自动添加条件

[复制链接]

11

主题

24

帖子

275

积分

中级会员

Rank: 3Rank: 3

积分
275
QQ
发表于 2021-3-4 16:29:01 | 显示全部楼层 |阅读模式
1. 在action中的查询语句是
select ER_CPBOMD_1,ER_CPBOMD_1.version as version,ER_CPBOMD_1.fCPBH_BOM as fCPBH_BOM,ER_CPBOMD_1.fHTBH_BOM as fHTBH_BOM,ER_CPBOMD_1.fDH_BOM as fDH_BOM,ER_CPBOMD_1.fDDMC_BOM as fDDMC_BOM,ER_CPBOMD_1.fXSMC_BOM as fXSMC_BOM,ER_CPBOMD_1.fParent_BOM as fParent_BOM,ER_CPBOMD_1.fLX_BOM as fLX_BOM,ER_CPBOMD_1.fBJMC_BOM as fBJMC_BOM,ER_CPBOMD_1.fBJH_BOM as fBJH_BOM,ER_CPBOMD_1.fBJTS_BOM as fBJTS_BOM,ER_CPBOMD_1.fBJZL_BOM as fBJZL_BOM,ER_CPBOMD_1.fLJH_BOM as fLJH_BOM,ER_CPBOMD_1.fLJTH_BOM as fLJTH_BOM,ER_CPBOMD_1.fLJMC_BOM as fLJMC_BOM,ER_CPBOMD_1.fLJJS_BOM as fLJJS_BOM,ER_CPBOMD_1.fLJRCL_BOM as fLJRCL_BOM,ER_CPBOMD_1.fLJCL_BOM as fLJCL_BOM,ER_CPBOMD_1.fLJCLBM_BOM as fLJCLBM_BOM,ER_CPBOMD_1.fLJJZ_BOM as fLJJZ_BOM,ER_CPBOMD_1.fLJGG_BOM as fLJGG_BOM,ER_CPBOMD_1.fLJBZH_BOM as fLJBZH_BOM,ER_CPBOMD_1.fLJPJH_BOM as fLJPJH_BOM,ER_CPBOMD_1.fLJDW_BOM as fLJDW_BOM,ER_CPBOMD_1.fLJCT as fLJCT,ER_CPBOMD_1.fLRSJ as fLRSJ,ER_CPBOMD_1.fLRR as fLRR,ER_CPBOMD_1.fLRRID as fLRRID,ER_CPBOMD_1.fLRRFID as fLRRFID,ER_CPBOMD_1.fLRRJG as fLRRJG,ER_CPBOMD_1.fLRRJGID as fLRRJGID,ER_CPBOMD_1.fLRRBM as fLRRBM,ER_CPBOMD_1.fLRRBMID as fLRRBMID,ER_CPBOMD_1.fLJLX as fLJLX,ER_CPBOMD_1.fGXLJ_BOM as fGXLJ_BOM,ER_CPBOMD_1.fLJML_BOM as fLJML_BOM,ER_CPBOMD_1.fZDBID as fZDBID,ER_CPBOMD_1.fZT as fZT,ER_CPBOMD_1.fJHBJID as fJHBJID,ER_CPBOMD_1.fQTJS as fQTJS,ER_CPBOMD_1.fSFJY as fSFJY,ER_CPBOMD_1.fLJLXBM_BOM as fLJLXBM_BOM,ER_CPBOMD_1.fLJLXMC_BOM as fLJLXMC_BOM,ER_CPBOMD_1.fSFWDHYT as fSFWDHYT,ER_CPBOMD_1.fLJSX_BOM as fLJSX_BOM,ER_CPBOMD_1.fSFTQJC as fSFTQJC,ER_CPBOMD_1.fTQ_LJ as fTQ_LJ,ER_CPBOMD_1.fTSDH_LJ as fTSDH_LJ,ER_CPBOMD_1.fQY_LJ as fQY_LJ,ER_CPBOMD_1.fGJGZLB as fGJGZLB,ER_CPBOMD_1.fGJGZLBBM as fGJGZLBBM,ER_CPBOMD_1.fSFGZ as fSFGZ,ER_CPBOMD_1.fTZBB as fTZBB
    from ER_CPBOMD ER_CPBOMD
     join ER_CPBOMD ER_CPBOMD_1 on ER_CPBOMD = ER_CPBOMD_1.fParent_BOM
2. 将action引用到ui2中的bizData
3. biz属性:isTree=true,父关系=fParent_BOM,节点类型关系=fXSMC_BOM
4. 用一个按钮过滤这个bizData
5. 结果:
SELECT  ER_CPBOMD_1.fID, ER_CPBOMD_1.FBJH_BOM AS fBJH_BOM, ER_CPBOMD_1.FBJMC_BOM AS fBJMC_BOM, ER_CPBOMD_1.FBJTS_BOM AS fBJTS_BOM, ER_CPBOMD_1.FBJZL_BOM AS fBJZL_BOM, ER_CPBOMD_1.FCPBH_BOM AS fCPBH_BOM, ER_CPBOMD_1.FDDMC_BOM AS fDDMC_BOM, ER_CPBOMD_1.FDH_BOM AS fDH_BOM, ER_CPBOMD_1.FGJGZLB AS fGJGZLB, ER_CPBOMD_1.FGJGZLBBM AS fGJGZLBBM, ER_CPBOMD_1.FGXLJ_BOM AS fGXLJ_BOM, ER_CPBOMD_1.FHTBH_BOM AS fHTBH_BOM, ER_CPBOMD_1.FJHBJID AS fJHBJID, ER_CPBOMD_1.FLJBZH_BOM AS fLJBZH_BOM, ER_CPBOMD_1.FLJCLBM_BOM AS fLJCLBM_BOM, ER_CPBOMD_1.FLJCL_BOM AS fLJCL_BOM, ER_CPBOMD_1.FLJCT AS fLJCT, ER_CPBOMD_1.FLJDW_BOM AS fLJDW_BOM, ER_CPBOMD_1.FLJGG_BOM AS fLJGG_BOM, ER_CPBOMD_1.FLJH_BOM AS fLJH_BOM, ER_CPBOMD_1.FLJJS_BOM AS fLJJS_BOM, ER_CPBOMD_1.FLJJZ_BOM AS fLJJZ_BOM, ER_CPBOMD_1.FLJLX AS fLJLX, ER_CPBOMD_1.FLJLXBM_BOM AS fLJLXBM_BOM, ER_CPBOMD_1.FLJLXMC_BOM AS fLJLXMC_BOM, ER_CPBOMD_1.FLJMC_BOM AS fLJMC_BOM, ER_CPBOMD_1.FLJML_BOM AS fLJML_BOM, ER_CPBOMD_1.FLJPJH_BOM AS fLJPJH_BOM, ER_CPBOMD_1.FLJRCL_BOM AS fLJRCL_BOM, ER_CPBOMD_1.FLJSX_BOM AS fLJSX_BOM, ER_CPBOMD_1.FLJTH_BOM AS fLJTH_BOM, ER_CPBOMD_1.FLRR AS fLRR, ER_CPBOMD_1.FLRRBM AS fLRRBM, ER_CPBOMD_1.FLRRBMID AS fLRRBMID, ER_CPBOMD_1.FLRRFID AS fLRRFID, ER_CPBOMD_1.FLRRID AS fLRRID, ER_CPBOMD_1.FLRRJG AS fLRRJG, ER_CPBOMD_1.FLRRJGID AS fLRRJGID, ER_CPBOMD_1.FLRSJ AS fLRSJ, ER_CPBOMD_1.FLX_BOM AS fLX_BOM, ER_CPBOMD_1.FPARENT_BOM AS fParent_BOM, ER_CPBOMD_1.FQTJS AS fQTJS, ER_CPBOMD_1.FQY_LJ AS fQY_LJ, ER_CPBOMD_1.FSFGZ AS fSFGZ, ER_CPBOMD_1.FSFJY AS fSFJY, ER_CPBOMD_1.FSFTQJC AS fSFTQJC, ER_CPBOMD_1.FSFWDHYT AS fSFWDHYT, ER_CPBOMD_1.FTQ_LJ AS fTQ_LJ, ER_CPBOMD_1.FTSDH_LJ AS fTSDH_LJ, ER_CPBOMD_1.FTZBB AS fTZBB, ER_CPBOMD_1.FXSMC_BOM AS fXSMC_BOM, ER_CPBOMD_1.FZDBID AS fZDBID, ER_CPBOMD_1.FZT AS fZT, ER_CPBOMD_1.VERSION AS version FROM ER_CPBOMD ER_CPBOMD JOIN ER_CPBOMD ER_CPBOMD_1 ON ER_CPBOMD.fID = ER_CPBOMD_1.FPARENT_BOM  WHERE  (ER_CPBOMD.FHTBH_BOM = ?) AND (ER_CPBOMD_1.FPARENT_BOM IS NULL)
6. 多出语句:ER_CPBOMD_1.FPARENT_BOM IS NULL
是什么原因啊


91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35878
发表于 2021-3-5 19:53:47 | 显示全部楼层
根过滤条件rootFilter设置为1=1
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

11

主题

24

帖子

275

积分

中级会员

Rank: 3Rank: 3

积分
275
QQ
 楼主| 发表于 2021-3-8 13:11:18 | 显示全部楼层
好的 结帖吧
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2024-3-29 07:24 , Processed in 0.094738 second(s), 23 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表