mainData中没有数据

qwertyu

autoLoad:true;autoNew:false;
Model.prototype.modelParamsReceive = function(event) {
                //获取参数：主表id
                var currentRowID = this.getContext().getRequestParameter("id");
                alert(currentRowID);
                //var currentRowID = event.params.currentRowID;
                var data = this.comp('mainData');
                data.filters.setFilter("currentRowID", "MKT_INAGREE_PARENT='" + currentRowID + "'");
                data.refreshData();
};

传参数过去以后页面没有数据显示，，将currentRowID 写死也没有数据。
action中的queryMKT_INAGREE_PARENTAction方法在数据库中测试过，是可以查到数据的

jishuang

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

qwertyu

jishuang 发表于 2017-6-12 11:23
参考 http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=33524&pid=165004035
把具体的sql打 ...

2017-06-12 12:11:46 [SQL Time]sql 执行时间：14ms, exec KSQL: SELECT SA_Task.*  FROM SA_Task SA_Task WHERE ((SA_Task.sStatusID='tesReady' or SA_Task.sStatusID='tesExecuting')  and (:_efid0 like concat(SA_Task.sExecutorFID, '%')) and SA_Task.sExecutorFID like '/%' ) ORDER BY sCreateTime DESC LIMIT 0, 1
  --> sql:SELECT  SA_Task.sID AS SA_Task, SA_Task.SAIACTIVE AS sAIActive, SA_Task.SAIID AS sAIID, SA_Task.SAISTATUSID AS sAIStatusID, SA_Task.SAISTATUSNAME AS sAIStatusName, SA_Task.SACTIVE AS sActive, SA_Task.SACTIVITY AS sActivity, SA_Task.SACTIVITYINTEMPLATE AS sActivityInTemplate, SA_Task.SACTIVITYNAME AS sActivityName, SA_Task.SACTIVITYNAMES AS sActivityNames, SA_Task.SACTUALFINISHTIME AS sActualFinishTime, SA_Task.SACTUALSTARTTIME AS sActualStartTime, SA_Task.SCURL AS sCURL, SA_Task.SCATALOGID AS sCatalogID, SA_Task.SCODE AS sCode, SA_Task.SCONTENT AS sContent, SA_Task.SCREATETIME AS sCreateTime, SA_Task.SCREATORDEPTID AS sCreatorDeptID, SA_Task.SCREATORDEPTNAME AS sCreatorDeptName, SA_Task.SCREATORFID AS sCreatorFID, SA_Task.SCREATORFNAME AS sCreatorFName, SA_Task.SCREATOROGNID AS sCreatorOgnID, SA_Task.SCREATOROGNNAME AS sCreatorOgnName, SA_Task.SCREATORPERSONID AS sCreatorPersonID, SA_Task.SCREATORPERSONNAME AS sCreatorPersonName, SA_Task.SCREATORPOSID AS sCreatorPosID, SA_Task.SCREATORPOSNAME AS sCreatorPosName, SA_Task.SCUSTOMERID AS sCustomerID, SA_Task.SCUSTOMERNAME AS sCustomerName, SA_Task.SDATA1 AS sData1, SA_Task.SDATA2 AS sData2, SA_Task.SDATA3 AS sData3, SA_Task.SDATA4 AS sData4, SA_Task.SDISTRIBUTETIME AS sDistributeTime, SA_Task.SEBFIELD51 AS sEBField51, SA_Task.SEBFIELD52 AS sEBField52, SA_Task.SEBFIELD53 AS sEBField53, SA_Task.SEBFIELD54 AS sEBField54, SA_Task.SEDFIELD21 AS sEDField21, SA_Task.SEDFIELD22 AS sEDField22, SA_Task.SEDFIELD23 AS sEDField23, SA_Task.SEDFIELD24 AS sEDField24, SA_Task.SEIFIELD41 AS sEIField41, SA_Task.SEIFIELD42 AS sEIField42, SA_Task.SEIFIELD43 AS sEIField43, SA_Task.SEIFIELD44 AS sEIField44, SA_Task.SENFIELD11 AS sENField11, SA_Task.SENFIELD12 AS sENField12, SA_Task.SENFIELD13 AS sENField13, SA_Task.SENFIELD14 AS sENField14, SA_Task.SESFIELD01 AS sESField01, SA_Task.SESFIELD02 AS sESField02, SA_Task.SESFIELD03 AS sESField03, SA_Task.SESFIELD04 AS sESField04, SA_Task.SESFIELD05 AS sESField05, SA_Task.SESFIELD06 AS sESField06, SA_Task.SESFIELD07 AS sESField07, SA_Task.SESFIELD08 AS sESField08, SA_Task.SETFIELD31 AS sETField31, SA_Task.SETFIELD32 AS sETField32, SA_Task.SETFIELD33 AS sETField33, SA_Task.SETFIELD34 AS sETField34, SA_Task.SEURL AS sEURL, SA_Task.SEMERGENCYID AS sEmergencyID, SA_Task.SEMERGENCYNAME AS sEmergencyName, SA_Task.SEXECUTEMODE AS sExecuteMode, SA_Task.SEXECUTEMODE2 AS sExecuteMode2, SA_Task.SEXECUTETIME AS sExecuteTime, SA_Task.SEXECUTORDEPTID AS sExecutorDeptID, SA_Task.SEXECUTORDEPTNAME AS sExecutorDeptName, SA_Task.SEXECUTORFID AS sExecutorFID, SA_Task.SEXECUTORFNAME AS sExecutorFName, SA_Task.SEXECUTORNAMES AS sExecutorNames, SA_Task.SEXECUTOROGNID AS sExecutorOgnID, SA_Task.SEXECUTOROGNNAME AS sExecutorOgnName, SA_Task.SEXECUTORPERSONID AS sExecutorPersonID, SA_Task.SEXECUTORPERSONNAME AS sExecutorPersonName, SA_Task.SEXECUTORPOSID AS sExecutorPosID, SA_Task.SEXECUTORPOSNAME AS sExecutorPosName, SA_Task.SEXPECTFINISHTIME AS sExpectFinishTime, SA_Task.SEXPECTSTARTTIME AS sExpectStartTime, SA_Task.SFLOWID AS sFlowID, SA_Task.SFRONTID AS sFrontID, SA_Task.SHINTS AS sHints, SA_Task.SIMPORTANCEID AS sImportanceID, SA_Task.SIMPORTANCENAME AS sImportanceName, SA_Task.SKINDID AS sKindID, SA_Task.SLASTMODIFYTIME AS sLastModifyTime, SA_Task.SLIMITTIME AS sLimitTime, SA_Task.SLOCK AS sLock, SA_Task.SNAME AS sName, SA_Task.sParentID AS sParent, SA_Task.SPLANID AS sPlanID, SA_Task.SPLANNAME AS sPlanName, SA_Task.SPREEMPTMODE AS sPreemptMode, SA_Task.SPROCESS AS sProcess, SA_Task.SPROCESSNAME AS sProcessName, SA_Task.SPROCESSTEMPLATEID AS sProcessTemplateID, SA_Task.SPROCESSTEMPLATEID2 AS sProcessTemplateID2, SA_Task.SPROCESSTEMPLATEITEMSEQUENCE AS sProcessTemplateItemSequence, SA_Task.SPROJECTID AS sProjectID, SA_Task.SPROJECTNAME AS sProjectName, SA_Task.SREMARK AS sRemark, SA_Task.SREMINDMODE AS sRemindMode, SA_Task.SRESPONSIBLE AS sResponsible, SA_Task.SSEQUENCE AS sSequence, SA_Task.SSHORTCUT AS sShortcut, SA_Task.SSOURCEID AS sSourceID, SA_Task.SSTATUSID AS sStatusID, SA_Task.SSTATUSNAME AS sStatusName, SA_Task.SSUMMARY AS sSummary, SA_Task.STEMPPERMISSIONID AS sTempPermissionID, SA_Task.STYPEID AS sTypeID, SA_Task.STYPENAME AS sTypeName, SA_Task.SVARIABLE AS sVariable, SA_Task.SWARNINGTIME AS sWarningTime, SA_Task.SWITHDRAW AS sWithdraw, SA_Task.VERSION AS version FROM SA_Task SA_Task  WHERE  ( (SA_Task.SSTATUSID = ?) OR (SA_Task.SSTATUSID = ?) ) AND ( ?  LIKE SA_Task.SEXECUTORFID || ?) AND (SA_Task.SEXECUTORFID LIKE ?)   ORDER BY sCreateTime DESC
--> binds:[tesReady, tesExecuting, /100000.ogn/100005.dpt/201621@100005.psm, %, /%]
2017-06-12 12:11:46 [SQL Time]sql 执行时间：4ms, exec KSQL:
  --> sql:SELECT count(*) FROM SA_Task SA_Task  WHERE  ( (SA_Task.SSTATUSID = ?) OR (SA_Task.SSTATUSID = ?) ) AND ( ?  LIKE SA_Task.SEXECUTORFID || ?) AND (SA_Task.SEXECUTORFID LIKE ?)
--> binds:[tesReady, tesExecuting, /100000.ogn/100005.dpt/201621@100005.psm, %, /%]
2017-06-12 12:11:48 [SQL Time]sql 执行时间：5ms, exec KSQL: SELECT p FROM SA_OPPerson p where p.sValidState=1
  --> sql:SELECT  p.sID FROM SA_OPPerson p  WHERE p.SVALIDSTATE = ?
--> binds:[1]
2017-06-12 12:11:48 [SQL Time]sql 执行时间：3ms, exec KSQL:
  --> sql:SELECT count(*) FROM SA_OPPerson p  WHERE p.SVALIDSTATE = ?
--> binds:[1]

qwertyu

qwertyu 发表于 2017-6-12 12:39
2017-06-12 12:11:46 [SQL Time]sql 执行时间：14ms, exec KSQL: SELECT SA_Task.*  FROM SA_Task SA_Tas ...

2017-06-12 12:11:48 [SQL Time]sql 执行时间：4ms, exec KSQL: select SA_OPPerson, SA_OPPerson.sName from SA_OPPerson SA_OPPerson where SA_OPPerson.sValidState=1
  --> sql:SELECT  SA_OPPerson.sID, SA_OPPerson.SNAME AS sName FROM SA_OPPerson SA_OPPerson  WHERE SA_OPPerson.SVALIDSTATE = ?
--> binds:[1]
2017-06-12 12:11:48 [SQL Time]sql 执行时间：8ms, exec KSQL: select DISTINCT o.sPersonID as SA_OPPerson, o.sName from SA_OPOrg o where o.sValidState=1 and o.sOrgKindID='psm'
  --> sql:SELECT  DISTINCT  o.SPERSONID AS SA_OPPerson, o.SNAME AS sName FROM SA_OPOrg o  WHERE  (o.SVALIDSTATE = ?) AND (o.SORGKINDID = ?)
--> binds:[1, psm]
2017-06-12 12:11:49 [SQL Time]sql 执行时间：3ms, exec KSQL: select SA_DocLinkDefine,SA_DocLinkDefine.sDefineItems,SA_DocLinkDefine.sActivity,SA_DocLinkDefine.sPersonFID from SA_DocLinkDefine SA_DocLinkDefine where (SA_DocLinkDefine.sProcess='/ERP/MKT/inagree/process/frameAgree/frameAgreeProcess' and (SA_DocLinkDefine.sActivity='' or SA_DocLinkDefine.sActivity IS NULL)) or (SA_DocLinkDefine.sProcess='/ERP/MKT/inagree/process/frameAgree/frameAgreeProcess' and SA_DocLinkDefine.sActivity='frameAgreeInfo')  order by SA_DocLinkDefine.sActivity desc
  --> sql:SELECT  SA_DocLinkDefine.sID, SA_DocLinkDefine.SDEFINEITEMS AS sDefineItems, SA_DocLinkDefine.SACTIVITY AS sActivity, SA_DocLinkDefine.SPERSONFID AS sPersonFID FROM SA_DocLinkDefine SA_DocLinkDefine  WHERE  ( (SA_DocLinkDefine.SPROCESS = ?) AND ( (SA_DocLinkDefine.SACTIVITY = ?) OR (SA_DocLinkDefine.SACTIVITY IS NULL) ) ) OR ( (SA_DocLinkDefine.SPROCESS = ?) AND (SA_DocLinkDefine.SACTIVITY = ?) )   ORDER BY SA_DocLinkDefine.SACTIVITY DESC
--> binds:[/ERP/MKT/inagree/process/frameAgree/frameAgreeProcess, , /ERP/MKT/inagree/process/frameAgree/frameAgreeProcess, frameAgreeInfo]
2017-06-12 12:11:49 [SQL Time]sql 执行时间：18ms, exec KSQL: SELECT DISTINCT MKT_INAGREE_PARENT.*,MTK_INAGREEINVAILD.fInvalidInAgreeNo as fInvalidInAgreeNo,MTK_INAGREEINVAILD.invalidProcessStatus as invalidProcessStatus  FROM MKT_INAGREE_PARENT MKT_INAGREE_PARENT  optional  join MTK_INAGREEINVAILD MTK_INAGREEINVAILD on MKT_INAGREE_PARENT.inAgreeNo = MTK_INAGREEINVAILD.fInvalidInAgreeNo WHERE ((1=0)) LIMIT 0, 2000000
  --> sql:SELECT  DISTINCT  MKT_INAGREE_PARENT.AGREEENDDATE AS AgreeEndDate, MKT_INAGREE_PARENT.AGREEEXCEPTDATE AS AgreeExceptDate, MKT_INAGREE_PARENT.AGREESTARTDATE AS AgreeStartDate, MKT_INAGREE_PARENT.ASSISTDEPT AS AssistDept, MKT_INAGREE_PARENT.ASSISTDEPTLEADERCODES AS AssistDeptLeaderCodes, MKT_INAGREE_PARENT.ASSISTDEPTLEADERNAMES AS AssistDeptLeaderNames, MKT_INAGREE_PARENT.ID AS ID, MKT_INAGREE_PARENT.IDBEFORECHANGE AS IDBeforeChange, MKT_INAGREE_PARENT.INAGREECHANGED AS InAgreeChanged, MKT_INAGREE_PARENT.INAGREEOFF AS InAgreeOff, MKT_INAGREE_PARENT.ID AS MKT_INAGREE_PARENT, MKT_INAGREE_PARENT.REMARK AS ReMark, MKT_INAGREE_PARENT.ACCOUNTTIME AS accountTime, MKT_INAGREE_PARENT.CHANGERATE AS changeRate, MKT_INAGREE_PARENT.DEPTLEADERCODES AS deptLeaderCodes, MKT_INAGREE_PARENT.DEPTLEADERNAMES AS deptLeaderNames, MKT_INAGREE_PARENT.FACTIVITY AS fActivity, MKT_INAGREE_PARENT.FACTIVITYNAME AS fActivityName, MKT_INAGREE_PARENT.FCREATDTIME AS fCreatdTime, MKT_INAGREE_PARENT.FCREATEDEPTCODE AS fCreateDeptCode, MKT_INAGREE_PARENT.FCREATEDEPTID AS fCreateDeptID, MKT_INAGREE_PARENT.FCREATEDEPTNAME AS fCreateDeptName, MKT_INAGREE_PARENT.FCREATEPERSONCODE AS fCreatePersonCode, MKT_INAGREE_PARENT.FCREATEPERSONFID AS fCreatePersonFID, MKT_INAGREE_PARENT.FCREATEPERSONID AS fCreatePersonID, MKT_INAGREE_PARENT.FCREATEPERSONNAME AS fCreatePersonName, MKT_INAGREE_PARENT.FDELFLAG AS fDelFlag, MKT_INAGREE_PARENT.FEXECUTORPERSONNAME AS fExecutorPersonName, MTK_INAGREEINVAILD.FINVALIDINAGREENO AS fInvalidInAgreeNo, MKT_INAGREE_PARENT.FPROCESSID AS fProcessID, MKT_INAGREE_PARENT.FTASKID AS fTaskID, MKT_INAGREE_PARENT.FUPDATETIME AS fUpdateTime, MKT_INAGREE_PARENT.FYFNAME AS fYfName, MKT_INAGREE_PARENT.HASOUTSOURCING AS hasOutSourcing, MKT_INAGREE_PARENT.HISTORYNO AS historyNo, MKT_INAGREE_PARENT.INAGREEAMOUNT AS inAgreeAmount, MKT_INAGREE_PARENT.INAGREEAMOUNTTYPE AS inAgreeAmountType, MKT_INAGREE_PARENT.INAGREEATTACHMENT AS inAgreeAttachment, MKT_INAGREE_PARENT.INAGREECBPERSON AS inAgreeCBPerson, MKT_INAGREE_PARENT.INAGREEFILEDATE AS inAgreeFileDate, MKT_INAGREE_PARENT.INAGREEFLEADER AS inAgreeFleader, MKT_INAGREE_PARENT.INAGREEMAINTYPE AS inAgreeMainType, MKT_INAGREE_PARENT.INAGREEMANAGETYPE AS inAgreeManageType, MKT_INAGREE_PARENT.INAGREEMANAGMENT AS inAgreeManagment, MKT_INAGREE_PARENT.INAGREENAME AS inAgreeName, MKT_INAGREE_PARENT.INAGREENO AS inAgreeNo, MKT_INAGREE_PARENT.INAGREESEALDATE AS inAgreeSealDate, MKT_INAGREE_PARENT.INAGREESIGNDATE AS inAgreeSignDate, MKT_INAGREE_PARENT.INAGREESTATUS AS inAgreeStatus, MKT_INAGREE_PARENT.INAGREESUMMARY AS inAgreeSummary, MKT_INAGREE_PARENT.INAGREETEMPLATETYPE AS inAgreeTemplateType, MKT_INAGREE_PARENT.INAGREELASTEDVERSION AS inAgreelastedVersion, MKT_INAGREE_PARENT.INAGREEID AS inagreeID, MKT_INAGREE_PARENT.INAGREEPAGES AS inagreePages, MTK_INAGREEINVAILD.INVALIDPROCESSSTATUS AS invalidProcessStatus, MKT_INAGREE_PARENT.ISHISTORY AS isHistory, MKT_INAGREE_PARENT.ISINVALID AS isInvalid, MKT_INAGREE_PARENT.ISNEEDFINCIALAUDIT AS isNeedFincialAudit, MKT_INAGREE_PARENT.ISLASTAMONT AS islastAmont, MKT_INAGREE_PARENT.ISNEEDSEAL AS isneedSeal, MKT_INAGREE_PARENT.MCITY AS mCity, MKT_INAGREE_PARENT.MCONNECTDEPT AS mConnectDept, MKT_INAGREE_PARENT.MCONNECTEMAIL AS mConnectEmail, MKT_INAGREE_PARENT.MCONNECTJOB AS mConnectJob, MKT_INAGREE_PARENT.MCONNECTNAME AS mConnectName, MKT_INAGREE_PARENT.MCONNECTPHONE AS mConnectPhone, MKT_INAGREE_PARENT.MCONNECTTELEPHONE AS mConnectTelePhone, MKT_INAGREE_PARENT.MINAGREENO AS mInAgreeNo, MKT_INAGREE_PARENT.MNO AS mNO, MKT_INAGREE_PARENT.MNAME AS mName, MKT_INAGREE_PARENT.MPCOMPANY AS mPCompany, MKT_INAGREE_PARENT.MPROVINCE AS mProvince, MKT_INAGREE_PARENT.MRELATETRANSTYPE AS mRelateTransType, MKT_INAGREE_PARENT.MTYPE AS mType, MKT_INAGREE_PARENT.PRJNAME AS prjName, MKT_INAGREE_PARENT.PRJNO AS prjNo, MKT_INAGREE_PARENT.PROCESSSTATUS AS processStatus, MKT_INAGREE_PARENT.RELATEINAGREE AS relateinAgree, MKT_INAGREE_PARENT.RELATIONAGREENO AS relationAgreeNo, MKT_INAGREE_PARENT.SUBPRJALLOT AS subPrjAllot, MKT_INAGREE_PARENT.SUBPRJEXCEPTGET AS subPrjExceptGet, MKT_INAGREE_PARENT.SUBPRJINAGREEAMONTCOUNT AS subPrjInAgreeAmontCount, MKT_INAGREE_PARENT.VERSION AS version, MKT_INAGREE_PARENT.YINAGREEAMONT AS yinAgreeAmont FROM MKT_INAGREE_PARENT MKT_INAGREE_PARENT LEFT JOIN MTK_INAGREEINVAILD MTK_INAGREEINVAILD ON MKT_INAGREE_PARENT.INAGREENO = MTK_INAGREEINVAILD.FINVALIDINAGREENO  WHERE ? = ?
--> binds:[1, 0]

qwertyu

jishuang 发表于 2017-6-12 11:23
参考 http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=33524&pid=165004035
把具体的sql打 ...

算了，太多了，我先慢慢看

jishuang

1.把bizData上的autoLoad设置false
2.只看看页面打开后MKT_INAGREE_PARENT相关的select语句

qwertyu

jishuang 发表于 2017-6-12 14:24
1.把bizData上的autoLoad设置false
2.只看看页面打开后MKT_INAGREE_PARENT相关的select语句 ...

已经解决了，是where1=0的问题