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

yc950710

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
是什么原因啊

jishuang

根过滤条件rootFilter设置为1=1

yc950710

好的 结帖吧