2.6升级至3.5后tree组件不显示组织树，怎么办？

何华平

如图2.6版本与3.5版本下tree组件对比

jishuang

参考http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035把执行的sql打出来看看现在的版本执行的sql是什么

何华平

表示看不懂
exec KSQL: SELECT OA_AM_ExcelTemp.*  FROM OA_AM_ExcelTemp OA_AM_ExcelTemp LIMIT 0, 20
  --> sql:SELECT  OA_AM_ExcelTemp.VERSION AS version, OA_AM_ExcelTemp.FFILENO AS fFileNO,

OA_AM_ExcelTemp.FDOCUMENTNO AS fDocumentNO, OA_AM_ExcelTemp.FARCHIVALNO AS fArchivalNO,

OA_AM_ExcelTemp.FMICRONO AS fMicroNO, OA_AM_ExcelTemp.FSEQUENCE AS fSequence, OA_AM_ExcelTemp.FMENUNO AS

fMenuNO, OA_AM_ExcelTemp.FPAGENO AS fPageNO, OA_AM_ExcelTemp.FBOXNO AS fBoxNO, OA_AM_ExcelTemp.FAMDATE AS

fAMDate, OA_AM_ExcelTemp.FAMLEVEL AS fAMLevel, OA_AM_ExcelTemp.FAMYEAR AS fAMYear,

OA_AM_ExcelTemp.FSECRET AS fSecret, OA_AM_ExcelTemp.FDESCRIPTION AS fDescription,

OA_AM_ExcelTemp.FBUSINESSID AS fBusinessID, OA_AM_ExcelTemp.FFUNCURL AS fFuncURL, OA_AM_ExcelTemp.FTITLE

AS fTitle, OA_AM_ExcelTemp.FSUBTITLE AS fSubTitle, OA_AM_ExcelTemp.FKEYWORD AS fKeyWord,

OA_AM_ExcelTemp.FFONDSID AS fFondsID, OA_AM_ExcelTemp.FFONDSNAME AS fFondsName,

OA_AM_ExcelTemp.FCATEGORYID AS fCategoryID, OA_AM_ExcelTemp.FCATEGORYNAME AS fCategoryName,

OA_AM_ExcelTemp.FROLLID AS fRollID, OA_AM_ExcelTemp.FROLLNAME AS fRollName, OA_AM_ExcelTemp.FFILEDEPTID

AS fFileDeptID, OA_AM_ExcelTemp.FFILEDEPTNAME AS fFileDeptName, OA_AM_ExcelTemp.FRESPONSIBLEID AS

fResponsibleID, OA_AM_ExcelTemp.FRESPONSIBLENAME AS fResponsibleName, OA_AM_ExcelTemp.FFILEDATE AS

fFileDate, OA_AM_ExcelTemp.FKEEPLIMIT AS fKeepLimit, OA_AM_ExcelTemp.FCARRY AS fCarry,

OA_AM_ExcelTemp.FISBORROW AS fIsBorrow, OA_AM_ExcelTemp.FNUM AS fNum, OA_AM_ExcelTemp.FUNIT AS fUnit,

OA_AM_ExcelTemp.FROOM AS fRoom, OA_AM_ExcelTemp.FCHEST AS fChest, OA_AM_ExcelTemp.FGRID AS fGrid,

OA_AM_ExcelTemp.FVERSIONCODE AS fVersionCode, OA_AM_ExcelTemp.FREMARK AS fRemark, OA_AM_ExcelTemp.FSTATE

AS fState, OA_AM_ExcelTemp.FSTATENAME AS fStateName, OA_AM_ExcelTemp.FSIGN AS fSign,

OA_AM_ExcelTemp.FISROLL AS fIsRoll, OA_AM_ExcelTemp.FVOUCHERBEGIN AS fVoucherBegin,

OA_AM_ExcelTemp.FVOUCHEREND AS fVoucherEnd, OA_AM_ExcelTemp.FVOUCHERNUM AS fVoucherNum,

OA_AM_ExcelTemp.FVOUCHERNO AS fVoucherNO, OA_AM_ExcelTemp.FURL AS fURL, OA_AM_ExcelTemp.FRELEVANCEID AS

fRelevanceID, OA_AM_ExcelTemp.FRELEVANCENAME AS fRelevanceName, OA_AM_ExcelTemp.FINVENTORY AS fInventory,

OA_AM_ExcelTemp.FCREATEOGNID AS fCreateOgnID, OA_AM_ExcelTemp.FCREATEOGNNAME AS fCreateOgnName,

OA_AM_ExcelTemp.FCREATEDEPTID AS fCreateDeptID, OA_AM_ExcelTemp.FCREATEDEPTNAME AS fCreateDeptName,

OA_AM_ExcelTemp.FCREATEPOSID AS fCreatePosID, OA_AM_ExcelTemp.FCREATEPOSNAME AS fCreatePosName,

OA_AM_ExcelTemp.FCREATEPSNID AS fCreatePsnID, OA_AM_ExcelTemp.FCREATEPSNNAME AS fCreatePsnName,

OA_AM_ExcelTemp.FCREATEPSNFID AS fCreatePsnFID, OA_AM_ExcelTemp.FCREATEPSNFNAME AS fCreatePsnFName,

OA_AM_ExcelTemp.FCREATETIME AS fCreateTime, OA_AM_ExcelTemp.FSEPARATE AS fSeparate, OA_AM_ExcelTemp.fID

AS OA_AM_ExcelTemp FROM OA_AM_EXCELTEMP OA_AM_ExcelTemp
--> binds:[]
2016-08-12 13:23:11
exec KSQL: SELECT OA_AM_ExcelTemp.*  FROM OA_AM_ExcelTemp OA_AM_ExcelTemp LIMIT 0, 20
  --> sql:SELECT  OA_AM_ExcelTemp.VERSION AS version, OA_AM_ExcelTemp.FFILENO AS fFileNO,

OA_AM_ExcelTemp.FDOCUMENTNO AS fDocumentNO, OA_AM_ExcelTemp.FARCHIVALNO AS fArchivalNO,

OA_AM_ExcelTemp.FMICRONO AS fMicroNO, OA_AM_ExcelTemp.FSEQUENCE AS fSequence, OA_AM_ExcelTemp.FMENUNO AS

fMenuNO, OA_AM_ExcelTemp.FPAGENO AS fPageNO, OA_AM_ExcelTemp.FBOXNO AS fBoxNO, OA_AM_ExcelTemp.FAMDATE AS

fAMDate, OA_AM_ExcelTemp.FAMLEVEL AS fAMLevel, OA_AM_ExcelTemp.FAMYEAR AS fAMYear,

OA_AM_ExcelTemp.FSECRET AS fSecret, OA_AM_ExcelTemp.FDESCRIPTION AS fDescription,

OA_AM_ExcelTemp.FBUSINESSID AS fBusinessID, OA_AM_ExcelTemp.FFUNCURL AS fFuncURL, OA_AM_ExcelTemp.FTITLE

AS fTitle, OA_AM_ExcelTemp.FSUBTITLE AS fSubTitle, OA_AM_ExcelTemp.FKEYWORD AS fKeyWord,

OA_AM_ExcelTemp.FFONDSID AS fFondsID, OA_AM_ExcelTemp.FFONDSNAME AS fFondsName,

OA_AM_ExcelTemp.FCATEGORYID AS fCategoryID, OA_AM_ExcelTemp.FCATEGORYNAME AS fCategoryName,

OA_AM_ExcelTemp.FROLLID AS fRollID, OA_AM_ExcelTemp.FROLLNAME AS fRollName, OA_AM_ExcelTemp.FFILEDEPTID

AS fFileDeptID, OA_AM_ExcelTemp.FFILEDEPTNAME AS fFileDeptName, OA_AM_ExcelTemp.FRESPONSIBLEID AS

fResponsibleID, OA_AM_ExcelTemp.FRESPONSIBLENAME AS fResponsibleName, OA_AM_ExcelTemp.FFILEDATE AS

fFileDate, OA_AM_ExcelTemp.FKEEPLIMIT AS fKeepLimit, OA_AM_ExcelTemp.FCARRY AS fCarry,

OA_AM_ExcelTemp.FISBORROW AS fIsBorrow, OA_AM_ExcelTemp.FNUM AS fNum, OA_AM_ExcelTemp.FUNIT AS fUnit,

OA_AM_ExcelTemp.FROOM AS fRoom, OA_AM_ExcelTemp.FCHEST AS fChest, OA_AM_ExcelTemp.FGRID AS fGrid,

OA_AM_ExcelTemp.FVERSIONCODE AS fVersionCode, OA_AM_ExcelTemp.FREMARK AS fRemark, OA_AM_ExcelTemp.FSTATE

AS fState, OA_AM_ExcelTemp.FSTATENAME AS fStateName, OA_AM_ExcelTemp.FSIGN AS fSign,

OA_AM_ExcelTemp.FISROLL AS fIsRoll, OA_AM_ExcelTemp.FVOUCHERBEGIN AS fVoucherBegin,

OA_AM_ExcelTemp.FVOUCHEREND AS fVoucherEnd, OA_AM_ExcelTemp.FVOUCHERNUM AS fVoucherNum,

OA_AM_ExcelTemp.FVOUCHERNO AS fVoucherNO, OA_AM_ExcelTemp.FURL AS fURL, OA_AM_ExcelTemp.FRELEVANCEID AS

fRelevanceID, OA_AM_ExcelTemp.FRELEVANCENAME AS fRelevanceName, OA_AM_ExcelTemp.FINVENTORY AS fInventory,

OA_AM_ExcelTemp.FCREATEOGNID AS fCreateOgnID, OA_AM_ExcelTemp.FCREATEOGNNAME AS fCreateOgnName,

OA_AM_ExcelTemp.FCREATEDEPTID AS fCreateDeptID, OA_AM_ExcelTemp.FCREATEDEPTNAME AS fCreateDeptName,

OA_AM_ExcelTemp.FCREATEPOSID AS fCreatePosID, OA_AM_ExcelTemp.FCREATEPOSNAME AS fCreatePosName,

OA_AM_ExcelTemp.FCREATEPSNID AS fCreatePsnID, OA_AM_ExcelTemp.FCREATEPSNNAME AS fCreatePsnName,

OA_AM_ExcelTemp.FCREATEPSNFID AS fCreatePsnFID, OA_AM_ExcelTemp.FCREATEPSNFNAME AS fCreatePsnFName,

OA_AM_ExcelTemp.FCREATETIME AS fCreateTime, OA_AM_ExcelTemp.FSEPARATE AS fSeparate, OA_AM_ExcelTemp.fID

AS OA_AM_ExcelTemp FROM OA_AM_EXCELTEMP OA_AM_ExcelTemp
--> binds:[]
2016-08-12 13:23:11 sql 执行时间：2ms
2016-08-12 13:23:11 sql 执行时间：2ms
2016-08-12 13:23:11
exec KSQL:
  --> sql:SELECT count(*) FROM OA_AM_EXCELTEMP OA_AM_ExcelTemp
--> binds:[]
2016-08-12 13:23:11
exec KSQL:
  --> sql:SELECT count(*) FROM OA_AM_EXCELTEMP OA_AM_ExcelTemp
--> binds:[]
2016-08-12 13:23:11 sql 执行时间：0ms
2016-08-12 13:23:11 sql 执行时间：0ms
exec KSQL: select SA_OPOrg.sName from SA_OPOrg SA_OPOrg where SA_OPOrg.sOrgKindID='ogn'
  --> sql:SELECT  SA_OPOrg.SNAME AS sName FROM SA_OPOrg SA_OPOrg  WHERE SA_OPOrg.SORGKINDID = ?
--> binds:[ogn]
2016-08-12 13:23:39
exec KSQL: select SA_OPOrg.sName from SA_OPOrg SA_OPOrg where SA_OPOrg.sOrgKindID='ogn'
  --> sql:SELECT  SA_OPOrg.SNAME AS sName FROM SA_OPOrg SA_OPOrg  WHERE SA_OPOrg.SORGKINDID = ?
--> binds:[ogn]

jishuang

你的bizdata对应的概念是那个？

何华平

OA_AM_Archival

jishuang

3楼发的语句中没有关于这个概念的啊

何华平

tree关联的是一个data鄙视bizdata

jishuang

关联的是data，那是自己写的action，给data加载的数据
在js中加debugger看看加载的数据是什么

何华平

3.5版本下event.source.expandRow("archival")：不触发tree的展开事件。怎么办？

jishuang

具体在什么事件中操作的

数据是延迟加载的用id展开，那么树要先展开id这个节点，然后用id展开的时候就会展开这行的子