保存后待办中无数据

阿里快睡觉

填写完表单，保存后，不流转，再回到自己的待办任务中，待办任务中没有数据，全部为空；

jishuang

除了mainActivity.w中data的autoNew设置为true，autoLoad设置为false
把其他几个.w中的autoNew设置false,autoLoad设置true

阿里快睡觉

jishuang 发表于 2015-10-29 16:55
除了mainActivity.w中data的autoNew设置为true，autoLoad设置为false
把其他几个.w中的autoNew设置false,au ...

按你说的做了，但还是不行。

jishuang

阿里快睡觉 发表于 2015-10-29 17:37
按你说的做了，但还是不行。

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

阿里快睡觉

点击保存按钮时的sql:
exec KSQL: insert into SA_Task i (i, i.sResponsible, i.sCreatorOgnName, i.sCreatorPersonID, i.sExecutorOgnID, i.sLastModifyTime, i.sExecutorDeptID, i.sCreatorFName, i.sProcessTemplateID2, i.sExecutorPosName, i.sCURL, i.sCreatorDeptID, i.sProcess, i.sFlowID, i.sCatalogID, i.sExecutorDeptName, i.sExecutorPersonID, i.sAIID, i.sActivity, i.sExecuteMode, i.sCreatorPosID, i.sCreateTime, i.sProcessName, i.sCreatorOgnID, i.sActivityInTemplate, i.sExpectStartTime, i.sCreatorFID, i.sPreemptMode, i.sEURL, i.sExecutorNames, i.sCreatorPosName, i.sStatusID, i.sCreatorDeptName, i.sActivityName, i.sData1, i.sCreatorPersonName, i.sStatusName, i.sExecutorOgnName, i.sExecutorFName, i.sTypeName, i.sAIStatusID, i.sExecutorFID, i.sLock, i.sVariable, i.sExecutorPersonName, i.sExecutorPosID, i.sName, i.sKindID, i.sActualStartTime, i.version, i.sParent) values ('2873F1493ADF48C1B6CA0BAE8F11811C', :sResponsible, :sCreatorOgnName, :sCreatorPersonID, :sExecutorOgnID, :sLastModifyTime, :sExecutorDeptID, :sCreatorFName, :sProcessTemplateID2, :sExecutorPosName, :sCURL, :sCreatorDeptID, :sProcess, :sFlowID, :sCatalogID, :sExecutorDeptName, :sExecutorPersonID, :sAIID, :sActivity, :sExecuteMode, :sCreatorPosID, :sCreateTime, :sProcessName, :sCreatorOgnID, :sActivityInTemplate, :sExpectStartTime, :sCreatorFID, :sPreemptMode, :sEURL, :sExecutorNames, :sCreatorPosName, :sStatusID, :sCreatorDeptName, :sActivityName, :sData1, :sCreatorPersonName, :sStatusName, :sExecutorOgnName, :sExecutorFName, :sTypeName, :sAIStatusID, :sExecutorFID, :sLock, :sVariable, :sExecutorPersonName, :sExecutorPosID, :sName, :sKindID, :sActualStartTime, 0, '8D3E7F7A24FF46A4B95367A46184A89A')
--> sql:INSERT INTO SA_Task (SA_Task.sID, SA_Task.SRESPONSIBLE, SA_Task.SCREATOROGNNAME, SA_Task.SCREATORPERSONID, SA_Task.SEXECUTOROGNID, SA_Task.SLASTMODIFYTIME, SA_Task.SEXECUTORDEPTID, SA_Task.SCREATORFNAME, SA_Task.SPROCESSTEMPLATEID2, SA_Task.SEXECUTORPOSNAME, SA_Task.SCURL, SA_Task.SCREATORDEPTID, SA_Task.SPROCESS, SA_Task.SFLOWID, SA_Task.SCATALOGID, SA_Task.SEXECUTORDEPTNAME, SA_Task.SEXECUTORPERSONID, SA_Task.SAIID, SA_Task.SACTIVITY, SA_Task.SEXECUTEMODE, SA_Task.SCREATORPOSID, SA_Task.SCREATETIME, SA_Task.SPROCESSNAME, SA_Task.SCREATOROGNID, SA_Task.SACTIVITYINTEMPLATE, SA_Task.SEXPECTSTARTTIME, SA_Task.SCREATORFID, SA_Task.SPREEMPTMODE, SA_Task.SEURL, SA_Task.SEXECUTORNAMES, SA_Task.SCREATORPOSNAME, SA_Task.SSTATUSID, SA_Task.SCREATORDEPTNAME, SA_Task.SACTIVITYNAME, SA_Task.SDATA1, SA_Task.SCREATORPERSONNAME, SA_Task.SSTATUSNAME, SA_Task.SEXECUTOROGNNAME, SA_Task.SEXECUTORFNAME, SA_Task.STYPENAME, SA_Task.SAISTATUSID, SA_Task.SEXECUTORFID, SA_Task.SLOCK, SA_Task.SVARIABLE, SA_Task.SEXECUTORPERSONNAME, SA_Task.SEXECUTORPOSID, SA_Task.SNAME, SA_Task.SKINDID, SA_Task.SACTUALSTARTTIME, SA_Task.VERSION, SA_Task.sParentID) VALUES (?,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? , ?, ?)
--> binds:[2873F1493ADF48C1B6CA0BAE8F11811C, false, 上海久壬信息科技有限公司, 1A8B0B5FE978450392BFDA16AD36FD1E, FC00F818509E4FBBAE836A5F20AEDEB3, 2015-10-30 14:11:34.035, EC246E4ED3374BC4B4FE9CA9F66AD98E, /上海久壬信息科技有限公司/合肥办事处/弱电配置技术员/李彭, , 弱电配置技术员, /jrentekOA/BusinessApplication/SolutionsMgmt/PreparationOfThePlan/PreparationOfThePlan/process/PreparationOfThePlan/businessActivity1.a, EC246E4ED3374BC4B4FE9CA9F66AD98E, /jrentekOA/BusinessApplication/SolutionsMgmt/PreparationOfThePlan/PreparationOfThePlan/process/PreparationOfThePlan/preparationOfThePlanProcess, 8D3E7F7A24FF46A4B95367A46184A89A, tsProcess, 合肥办事处, 1A8B0B5FE978450392BFDA16AD36FD1E, 2873F1493ADF48C1B6CA0BAE8F11811C, businessActivity1, temPreempt, 8AAD3AEBA670470EB086A626E743336F, 2015-10-30 14:11:33.98, 方案中选申报, FC00F818509E4FBBAE836A5F20AEDEB3, businessActivity1, 2015-10-30 14:11:34.031, /FC00F818509E4FBBAE836A5F20AEDEB3.ogn/EC246E4ED3374BC4B4FE9CA9F66AD98E.dpt/8AAD3AEBA670470EB086A626E743336F.pos/1A8B0B5FE978450392BFDA16AD36FD1E@8AAD3AEBA670470EB086A626E743336F.psm, tpmOpen, /jrentekOA/BusinessApplication/SolutionsMgmt/PreparationOfThePlan/PreparationOfThePlan/process/PreparationOfThePlan/businessActivity1.a, 李彭, 弱电配置技术员, tesExecuting, 合肥办事处, 方案员填写, A7E93D75358B4778A462BEC9FDCE183F, 李彭, 正在处理, 上海久壬信息科技有限公司, /上海久壬信息科技有限公司/合肥办事处/弱电配置技术员/李彭, 方案中选申报, run, /FC00F818509E4FBBAE836A5F20AEDEB3.ogn/EC246E4ED3374BC4B4FE9CA9F66AD98E.dpt/8AAD3AEBA670470EB086A626E743336F.pos/1A8B0B5FE978450392BFDA16AD36FD1E@8AAD3AEBA670470EB086A626E743336F.psm, F9D60AEB42B7409BAE05E9BBA34AD9C2, x=;, 李彭, 8AAD3AEBA670470EB086A626E743336F, 方案员填写:方案中选申报, tkTask, 2015-10-30 14:11:34.031, 0, 8D3E7F7A24FF46A4B95367A46184A89A]

阿里快睡觉

jishuang 发表于 2015-10-30 13:13
http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=33524&pid=165004035
参考这个帖子 ...

点击保存按钮时的sql：
exec KSQL: insert into SA_Task i (i, i.sResponsible, i.sCreatorOgnName, i.sCreatorPersonID, i.sExecutorOgnID, i.sLastModifyTime, i.sExecutorDeptID, i.sCreatorFName, i.sProcessTemplateID2, i.sExecutorPosName, i.sCURL, i.sCreatorDeptID, i.sProcess, i.sFlowID, i.sCatalogID, i.sExecutorDeptName, i.sExecutorPersonID, i.sAIID, i.sActivity, i.sExecuteMode, i.sCreatorPosID, i.sCreateTime, i.sProcessName, i.sCreatorOgnID, i.sActivityInTemplate, i.sExpectStartTime, i.sCreatorFID, i.sPreemptMode, i.sEURL, i.sExecutorNames, i.sCreatorPosName, i.sStatusID, i.sCreatorDeptName, i.sActivityName, i.sData1, i.sCreatorPersonName, i.sStatusName, i.sExecutorOgnName, i.sExecutorFName, i.sTypeName, i.sAIStatusID, i.sExecutorFID, i.sLock, i.sVariable, i.sExecutorPersonName, i.sExecutorPosID, i.sName, i.sKindID, i.sActualStartTime, i.version, i.sParent) values ('2873F1493ADF48C1B6CA0BAE8F11811C', :sResponsible, :sCreatorOgnName, :sCreatorPersonID, :sExecutorOgnID, :sLastModifyTime, :sExecutorDeptID, :sCreatorFName, :sProcessTemplateID2, :sExecutorPosName, :sCURL, :sCreatorDeptID, :sProcess, :sFlowID, :sCatalogID, :sExecutorDeptName, :sExecutorPersonID, :sAIID, :sActivity, :sExecuteMode, :sCreatorPosID, :sCreateTime, :sProcessName, :sCreatorOgnID, :sActivityInTemplate, :sExpectStartTime, :sCreatorFID, :sPreemptMode, :sEURL, :sExecutorNames, :sCreatorPosName, :sStatusID, :sCreatorDeptName, :sActivityName, :sData1, :sCreatorPersonName, :sStatusName, :sExecutorOgnName, :sExecutorFName, :sTypeName, :sAIStatusID, :sExecutorFID, :sLock, :sVariable, :sExecutorPersonName, :sExecutorPosID, :sName, :sKindID, :sActualStartTime, 0, '8D3E7F7A24FF46A4B95367A46184A89A')
--> sql:INSERT INTO SA_Task (SA_Task.sID, SA_Task.SRESPONSIBLE, SA_Task.SCREATOROGNNAME, SA_Task.SCREATORPERSONID, SA_Task.SEXECUTOROGNID, SA_Task.SLASTMODIFYTIME, SA_Task.SEXECUTORDEPTID, SA_Task.SCREATORFNAME, SA_Task.SPROCESSTEMPLATEID2, SA_Task.SEXECUTORPOSNAME, SA_Task.SCURL, SA_Task.SCREATORDEPTID, SA_Task.SPROCESS, SA_Task.SFLOWID, SA_Task.SCATALOGID, SA_Task.SEXECUTORDEPTNAME, SA_Task.SEXECUTORPERSONID, SA_Task.SAIID, SA_Task.SACTIVITY, SA_Task.SEXECUTEMODE, SA_Task.SCREATORPOSID, SA_Task.SCREATETIME, SA_Task.SPROCESSNAME, SA_Task.SCREATOROGNID, SA_Task.SACTIVITYINTEMPLATE, SA_Task.SEXPECTSTARTTIME, SA_Task.SCREATORFID, SA_Task.SPREEMPTMODE, SA_Task.SEURL, SA_Task.SEXECUTORNAMES, SA_Task.SCREATORPOSNAME, SA_Task.SSTATUSID, SA_Task.SCREATORDEPTNAME, SA_Task.SACTIVITYNAME, SA_Task.SDATA1, SA_Task.SCREATORPERSONNAME, SA_Task.SSTATUSNAME, SA_Task.SEXECUTOROGNNAME, SA_Task.SEXECUTORFNAME, SA_Task.STYPENAME, SA_Task.SAISTATUSID, SA_Task.SEXECUTORFID, SA_Task.SLOCK, SA_Task.SVARIABLE, SA_Task.SEXECUTORPERSONNAME, SA_Task.SEXECUTORPOSID, SA_Task.SNAME, SA_Task.SKINDID, SA_Task.SACTUALSTARTTIME, SA_Task.VERSION, SA_Task.sParentID) VALUES (?,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? , ?, ?)
--> binds:[2873F1493ADF48C1B6CA0BAE8F11811C, false, 上海久壬信息科技有限公司, 1A8B0B5FE978450392BFDA16AD36FD1E, FC00F818509E4FBBAE836A5F20AEDEB3, 2015-10-30 14:11:34.035, EC246E4ED3374BC4B4FE9CA9F66AD98E, /上海久壬信息科技有限公司/合肥办事处/弱电配置技术员/李彭, , 弱电配置技术员, /jrentekOA/BusinessApplication/SolutionsMgmt/PreparationOfThePlan/PreparationOfThePlan/process/PreparationOfThePlan/businessActivity1.a, EC246E4ED3374BC4B4FE9CA9F66AD98E, /jrentekOA/BusinessApplication/SolutionsMgmt/PreparationOfThePlan/PreparationOfThePlan/process/PreparationOfThePlan/preparationOfThePlanProcess, 8D3E7F7A24FF46A4B95367A46184A89A, tsProcess, 合肥办事处, 1A8B0B5FE978450392BFDA16AD36FD1E, 2873F1493ADF48C1B6CA0BAE8F11811C, businessActivity1, temPreempt, 8AAD3AEBA670470EB086A626E743336F, 2015-10-30 14:11:33.98, 方案中选申报, FC00F818509E4FBBAE836A5F20AEDEB3, businessActivity1, 2015-10-30 14:11:34.031, /FC00F818509E4FBBAE836A5F20AEDEB3.ogn/EC246E4ED3374BC4B4FE9CA9F66AD98E.dpt/8AAD3AEBA670470EB086A626E743336F.pos/1A8B0B5FE978450392BFDA16AD36FD1E@8AAD3AEBA670470EB086A626E743336F.psm, tpmOpen, /jrentekOA/BusinessApplication/SolutionsMgmt/PreparationOfThePlan/PreparationOfThePlan/process/PreparationOfThePlan/businessActivity1.a, 李彭, 弱电配置技术员, tesExecuting, 合肥办事处, 方案员填写, A7E93D75358B4778A462BEC9FDCE183F, 李彭, 正在处理, 上海久壬信息科技有限公司, /上海久壬信息科技有限公司/合肥办事处/弱电配置技术员/李彭, 方案中选申报, run, /FC00F818509E4FBBAE836A5F20AEDEB3.ogn/EC246E4ED3374BC4B4FE9CA9F66AD98E.dpt/8AAD3AEBA670470EB086A626E743336F.pos/1A8B0B5FE978450392BFDA16AD36FD1E@8AAD3AEBA670470EB086A626E743336F.psm, F9D60AEB42B7409BAE05E9BBA34AD9C2, x=;, 李彭, 8AAD3AEBA670470EB086A626E743336F, 方案员填写:方案中选申报, tkTask, 2015-10-30 14:11:34.031, 0, 8D3E7F7A24FF46A4B95367A46184A89A]

阿里快睡觉

看不出来sql  哪有问题。。。

jishuang

把控制台的信息清了，然后打开功能页后把控制的sql发一下
打开功能查数据执行的是select
你发的全都是insert的应该是流转时候的

阿里快睡觉

jishuang 发表于 2015-10-30 17:39
把控制台的信息清了，然后打开功能页后把控制的sql发一下
打开功能查数据执行的是select
你发的全都是inser ...

exec KSQL: SELECT PreparationOfThePlan.*,V_sa_task.sStatusID as sStatusID,PlanPreparation.*,PotentialProjects.fXMMC as XMMC,V_SA_OPPerson.sName as sName,V_sa_opperson1.sName as ywjlName  FROM PreparationOfThePlan PreparationOfThePlan  optional  join V_sa_task V_sa_task on PreparationOfThePlan = V_sa_task.sData1 AND V_sa_task.sParentID is null optional  join PlanPreparation PlanPreparation on PreparationOfThePlan.fFABBID = PlanPreparation.fFABBBH optional  join PotentialProjects PotentialProjects on PlanPreparation.fXMMCID = PotentialProjects optional  join V_SA_OPPerson V_SA_OPPerson on PlanPreparation.fFAY = V_SA_OPPerson optional  join V_sa_opperson1 V_sa_opperson1 on PreparationOfThePlan.fYWJLID_ = V_sa_opperson1 WHERE (V_sa_task.sStatusID = 'tesFinished') AND ((PreparationOfThePlan='F16C981B1201470B96C80ADF5D6A8246')) LIMIT 0, 20
  --> sql:SELECT  PlanPreparation.fID AS PlanPreparation, PreparationOfThePlan.fID AS PreparationOfThePlan, PotentialProjects.FXMMC AS XMMC, PlanPreparation.FBBSJ AS fBBSJ, PlanPreparation.FBJ AS fBJ, PlanPreparation.FFA AS fFA, PlanPreparation.FFABBBH AS fFABBBH, PreparationOfThePlan.FFABBID AS fFABBID, PlanPreparation.FFAY AS fFAY, PreparationOfThePlan.FNQDSJ AS fNQDSJ, PreparationOfThePlan.FOID AS fOID, PlanPreparation.FPZJBJ AS fPZJBJ, PlanPreparation.FQT AS fQT, PlanPreparation.FSFJT AS fSFJT, PlanPreparation.FSFZB AS fSFZB, PreparationOfThePlan.FSQR AS fSQR, PreparationOfThePlan.FSQSJ AS fSQSJ, PlanPreparation.FTJGF AS fTJGF, PlanPreparation.FTZ AS fTZ, PlanPreparation.FXMLBID AS fXMLBID, PlanPreparation.FXMMC AS fXMMC, PlanPreparation.FXMMCID AS fXMMCID, PlanPreparation.FXMXQ AS fXMXQ, PlanPreparation.FYWJLID AS fYWJLID, PreparationOfThePlan.FYWJLID_ AS fYWJLID_, PlanPreparation.FYZX AS fYZX, PreparationOfThePlan.FZBDW AS fZBDW, PlanPreparation.FZDF AS fZDF, PreparationOfThePlan.FZXJ AS fZXJ, PlanPreparation.FZXLCP AS fZXLCP, V_SA_OPPerson.SNAME AS sName, V_sa_task.SSTATUSID AS sStatusID, PreparationOfThePlan.VERSION AS version, V_sa_opperson1.SNAME AS ywjlName FROM PREPARATIONOFTHEPLAN PreparationOfThePlan LEFT JOIN v_sa_task V_sa_task ON  (PreparationOfThePlan.fID = V_sa_task.SDATA1) AND (V_sa_task.sParentID IS NULL)  LEFT JOIN PlanPreparation PlanPreparation ON PreparationOfThePlan.FFABBID = PlanPreparation.FFABBBH LEFT JOIN POTENTIALPROJECTS PotentialProjects ON PlanPreparation.FXMMCID = PotentialProjects.fID LEFT JOIN v_sa_opperson V_SA_OPPerson ON PlanPreparation.FFAY = V_SA_OPPerson.SID LEFT JOIN v_sa_opperson1 V_sa_opperson1 ON PreparationOfThePlan.FYWJLID_ = V_sa_opperson1.SID  WHERE  (V_sa_task.SSTATUSID = ?) AND (PreparationOfThePlan.fID = ?)
--> binds:[tesFinished, F16C981B1201470B96C80ADF5D6A8246]
2015-11-02 09:18:16
exec KSQL: SELECT PreparationOfThePlan.*,V_sa_task.sStatusID as sStatusID,PlanPreparation.*,PotentialProjects.fXMMC as XMMC,V_SA_OPPerson.sName as sName,V_sa_opperson1.sName as ywjlName  FROM PreparationOfThePlan PreparationOfThePlan  optional  join V_sa_task V_sa_task on PreparationOfThePlan = V_sa_task.sData1 AND V_sa_task.sParentID is null optional  join PlanPreparation PlanPreparation on PreparationOfThePlan.fFABBID = PlanPreparation.fFABBBH optional  join PotentialProjects PotentialProjects on PlanPreparation.fXMMCID = PotentialProjects optional  join V_SA_OPPerson V_SA_OPPerson on PlanPreparation.fFAY = V_SA_OPPerson optional  join V_sa_opperson1 V_sa_opperson1 on PreparationOfThePlan.fYWJLID_ = V_sa_opperson1 WHERE (V_sa_task.sStatusID = 'tesFinished') AND ((PreparationOfThePlan='F16C981B1201470B96C80ADF5D6A8246')) LIMIT 0, 20
  --> sql:SELECT  PlanPreparation.fID AS PlanPreparation, PreparationOfThePlan.fID AS PreparationOfThePlan, PotentialProjects.FXMMC AS XMMC, PlanPreparation.FBBSJ AS fBBSJ, PlanPreparation.FBJ AS fBJ, PlanPreparation.FFA AS fFA, PlanPreparation.FFABBBH AS fFABBBH, PreparationOfThePlan.FFABBID AS fFABBID, PlanPreparation.FFAY AS fFAY, PreparationOfThePlan.FNQDSJ AS fNQDSJ, PreparationOfThePlan.FOID AS fOID, PlanPreparation.FPZJBJ AS fPZJBJ, PlanPreparation.FQT AS fQT, PlanPreparation.FSFJT AS fSFJT, PlanPreparation.FSFZB AS fSFZB, PreparationOfThePlan.FSQR AS fSQR, PreparationOfThePlan.FSQSJ AS fSQSJ, PlanPreparation.FTJGF AS fTJGF, PlanPreparation.FTZ AS fTZ, PlanPreparation.FXMLBID AS fXMLBID, PlanPreparation.FXMMC AS fXMMC, PlanPreparation.FXMMCID AS fXMMCID, PlanPreparation.FXMXQ AS fXMXQ, PlanPreparation.FYWJLID AS fYWJLID, PreparationOfThePlan.FYWJLID_ AS fYWJLID_, PlanPreparation.FYZX AS fYZX, PreparationOfThePlan.FZBDW AS fZBDW, PlanPreparation.FZDF AS fZDF, PreparationOfThePlan.FZXJ AS fZXJ, PlanPreparation.FZXLCP AS fZXLCP, V_SA_OPPerson.SNAME AS sName, V_sa_task.SSTATUSID AS sStatusID, PreparationOfThePlan.VERSION AS version, V_sa_opperson1.SNAME AS ywjlName FROM PREPARATIONOFTHEPLAN PreparationOfThePlan LEFT JOIN v_sa_task V_sa_task ON  (PreparationOfThePlan.fID = V_sa_task.SDATA1) AND (V_sa_task.sParentID IS NULL)  LEFT JOIN PlanPreparation PlanPreparation ON PreparationOfThePlan.FFABBID = PlanPreparation.FFABBBH LEFT JOIN POTENTIALPROJECTS PotentialProjects ON PlanPreparation.FXMMCID = PotentialProjects.fID LEFT JOIN v_sa_opperson V_SA_OPPerson ON PlanPreparation.FFAY = V_SA_OPPerson.SID LEFT JOIN v_sa_opperson1 V_sa_opperson1 ON PreparationOfThePlan.FYWJLID_ = V_sa_opperson1.SID  WHERE  (V_sa_task.SSTATUSID = ?) AND (PreparationOfThePlan.fID = ?)
--> binds:[tesFinished, F16C981B1201470B96C80ADF5D6A8246]

阿里快睡觉

jishuang 发表于 2015-10-30 17:39
把控制台的信息清了，然后打开功能页后把控制的sql发一下
打开功能查数据执行的是select
你发的全都是inser ...

sql:SELECT count(*) FROM PREPARATIONOFTHEPLAN PreparationOfThePlan LEFT JOIN v_sa_task V_sa_task ON  (PreparationOfThePlan.fID = V_sa_task.SDATA1) AND (V_sa_task.sParentID IS NULL)  LEFT JOIN PlanPreparation PlanPreparation ON PreparationOfThePlan.FFABBID = PlanPreparation.FFABBBH LEFT JOIN POTENTIALPROJECTS PotentialProjects ON PlanPreparation.FXMMCID = PotentialProjects.fID LEFT JOIN v_sa_opperson V_SA_OPPerson ON PlanPreparation.FFAY = V_SA_OPPerson.SID LEFT JOIN v_sa_opperson1 V_sa_opperson1 ON PreparationOfThePlan.FYWJLID_ = V_sa_opperson1.SID  WHERE  (V_sa_task.SSTATUSID = ?) AND (PreparationOfThePlan.fID = ?)
--> binds:[tesFinished, F16C981B1201470B96C80ADF5D6A8246]