父表和子表的传值问题

回复 10# purple


  数据源的名称和数据库的名称都是khgl（不会是这个原因吧） ， 再添加两行代码的运行结果：
10:14:32,623  INFO PrintJsUtil:27 - JsUtil:times------------------------------->
>>>>>Mon May 07 10:14:32 CST 2012
10:14:32,623  INFO PrintJsUtil:27 - JsUtil:ids----------------------------------
->>>>>>>11e1-97e8-79669bb5-a81d-9b8571e34d50
10:14:32,889  INFO AbstractDocStaticTblDAO:1480 - MS SQL Server: SELECT d.* FROM
DBO.TLK_FM_CLIENT d WHERE d.ID=?
10:14:32,904  INFO MssqlDocStaticTblDAO:94 - MS SQL Server: SELECT TOP 10 * FROM
(SELECT ROW_NUMBER() OVER (ORDER BY DOMAINID) AS ROWNUMBER, TABNIC.* FROM (SELE
CT top 2147483647 * FROM (select d.* from tlk_fm_followclient d where  (PARENT =
'11e1-97e8-79669bb5-a81d-9b8571e34d50') and 1 = 1) ordtb WHERE DOMAINID ='11e1-
505f-2875cf29-81db-676e976ca0dc' ORDER BY ordtb.ID) TABNIC) TableNickname WHERE
ROWNUMBER>0
10:14:32,904  INFO AbstractDocStaticTblDAO:1047 - MS SQL Server: SELECT COUNT(*)
  FROM (select d.* from tlk_fm_followclient d where  (PARENT = '11e1-97e8-79669b
b5-a81d-9b8571e34d50') and 1 = 1) doc WHERE doc.DOMAINID ='11e1-505f-2875cf29-81
db-676e976ca0dc'
10:14:32,935  INFO AbstractDocStaticTblDAO:1480 - MS SQL Server: SELECT d.* FROM
DBO.TLK_FM_CLIENT d WHERE d.ID=?
10:14:32,951  INFO AbstractDocStaticTblDAO:1480 - MS SQL Server: SELECT d.* FROM
DBO.TLK_FM_CLIENT d WHERE d.ID=?
10:14:33,731 ERROR XMPPSender:189 - Send Notification failed, XMPPError connecti
ng to localhost:5222.
2012-5-7 10:14:34 org.apache.tomcat.util.http.Parameters processParameters
警告: Parameters: Invalid chunk '=11e1-8f83-fb431241-bcbd-ff4c18f95cd0' ignored.

不是，queryByDsName方法的参数必须是数据源名称，所以跟您确认。您这是在debug模式下的打印信息吗？是只是加了我所贴的那三行代码吗？

回复 12# purple


   脚本 ：var times = getToday();  
println("times------------------------------->>>>>>"+times);
var doc = getParentDocument();
var ids = doc.getId();
println("ids----------------------------------->>>>>>>"+ids);

刚才那个不是debug下打印的，是在前台运行打印的，
debug打印：
2012-5-7 10:32:00 org.apache.tomcat.util.http.Parameters processParameters
警告: Parameters: Invalid chunk '=11e1-94fe-9817b5bd-986e-19845d5cfa87' ignored.

10:32:00,575  INFO AbstractFlowStateRTDAO:442 - MS SQL SERVER: SELECT * FROM DBO
.T_FLOWSTATERT vo WHERE vo.DOCID=?
10:32:00,575  INFO AbstractFlowStateRTDAO:442 - MS SQL SERVER: SELECT * FROM DBO
.T_FLOWSTATERT vo WHERE vo.DOCID=?
10:32:00,591  INFO AbstractDocStaticTblDAO:285 - MS SQL Server: INSERT INTO DBO.
T_DOCUMENT (ID,PARENT,LASTMODIFIED,FORMNAME,STATE,STATEINT,INITIATOR,AUDITUSER,A
UDITDATE,AUTHOR,CREATED,FORMID,ISTMP,VERSIONS,SORTID,APPLICATIONID,STATELABEL,AU
DITORNAMES,LASTFLOWOPERATION,LASTMODIFIER,DOMAINID,AUDITORLIST,MAPPINGID) VALUES
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
10:32:00,591  INFO AbstractDocStaticTblDAO:380 - MS SQL Server: INSERT INTO DBO.
TLK_FM_FOLLOWCLIENT (ITEM_FD_CRTIME,ITEM_FD_WAY,ITEM_FD_TYPE,ITEM_FD_CONTENTS,IT
EM_FD_TITLE,ID,PARENT,LASTMODIFIED,FORMNAME,STATE,STATEINT,AUDITUSER,AUDITDATE,A
UTHOR,CREATED,FORMID,ISTMP,VERSIONS,SORTID,APPLICATIONID,STATELABEL,AUDITORNAMES
,LASTFLOWOPERATION,LASTMODIFIER,DOMAINID,AUDITORLIST) VALUES (?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
10:32:00,591  INFO AbstractFlowStateRTDAO:442 - MS SQL SERVER: SELECT * FROM DBO
.T_FLOWSTATERT vo WHERE vo.DOCID=?
10:32:00,591  INFO AbstractFlowStateRTDAO:442 - MS SQL SERVER: SELECT * FROM DBO
.T_FLOWSTATERT vo WHERE vo.DOCID=?
10:32:00,606  INFO AbstractDocStaticTblDAO:2117 - MS SQL Server: DELETE FROM AUT
H_FM_FOLLOWCLIENT WHERE DOC_ID='11e1-97ec-cfa4de82-a701-7f5826f93ff9'
10:32:00,606  INFO AbstractPendingDAO:135 - MS SQL Server: DELETE FROM DBO.T_PEN
DING WHERE ID = '11e1-97ec-cfa4de82-a701-7f5826f93ff9'
10:32:00,606  INFO AbstractPendingDAO:136 - MS SQL Server: DELETE FROM DBO.T_PEN
DING_ACTOR_SET WHERE DOCID = '11e1-97ec-cfa4de82-a701-7f5826f93ff9'
10:32:00,606  INFO AbstractFlowStateRTDAO:442 - MS SQL SERVER: SELECT * FROM DBO
.T_FLOWSTATERT vo WHERE vo.DOCID=?
10:32:00,622  INFO AbstractFlowStateRTDAO:442 - MS SQL SERVER: SELECT * FROM DBO
.T_FLOWSTATERT vo WHERE vo.DOCID=?
10:32:00,622  INFO AbstractPendingDAO:65 - MS SQL Server: INSERT INTO DBO.T_PEND
ING(ID,FORMID,FORMNAME, FLOWID, CREATED, LASTMODIFIED, AUDITDATE, AUTHOR ,AUDITU
SER, STATELABEL, STATE, AUDITORNAMES, LASTFLOWOPERATION, LASTMODIFIER, SUMMARY,
APPLICATIONID,DOMAINID) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
10:32:00,653  INFO PrintJsUtil:27 - JsUtil:times------------------------------->
>>>>>Mon May 07 10:32:00 CST 2012
10:32:00,653  INFO PrintJsUtil:27 - JsUtil:ids----------------------------------
->>>>>>>11e1-97e8-79669bb5-a81d-9b8571e34d50
10:32:00,934  INFO AbstractDocStaticTblDAO:1480 - MS SQL Server: SELECT d.* FROM
DBO.TLK_FM_CLIENT d WHERE d.ID=?
10:32:00,934  INFO MssqlDocStaticTblDAO:94 - MS SQL Server: SELECT TOP 10 * FROM
(SELECT ROW_NUMBER() OVER (ORDER BY DOMAINID) AS ROWNUMBER, TABNIC.* FROM (SELE
CT top 2147483647 * FROM (select d.* from tlk_fm_followclient d where  (PARENT =
'11e1-97e8-79669bb5-a81d-9b8571e34d50') and 1 = 1) ordtb WHERE DOMAINID ='11e1-
505f-2875cf29-81db-676e976ca0dc' ORDER BY ordtb.ID) TABNIC) TableNickname WHERE
ROWNUMBER>0
10:32:00,950  INFO AbstractDocStaticTblDAO:1047 - MS SQL Server: SELECT COUNT(*)
  FROM (select d.* from tlk_fm_followclient d where  (PARENT = '11e1-97e8-79669b
b5-a81d-9b8571e34d50') and 1 = 1) doc WHERE doc.DOMAINID ='11e1-505f-2875cf29-81
db-676e976ca0dc'
10:32:00,965  INFO AbstractDocStaticTblDAO:1480 - MS SQL Server: SELECT d.* FROM
DBO.TLK_FM_CLIENT d WHERE d.ID=?
10:32:00,981  INFO AbstractDocStaticTblDAO:1480 - MS SQL Server: SELECT d.* FROM
DBO.TLK_FM_CLIENT d WHERE d.ID=?
10:32:00,996  INFO AbstractDocStaticTblDAO:1480 - MS SQL Server: SELECT d.* FROM
DBO.TLK_FM_CLIENT d WHERE d.ID=?
10:32:01,012  INFO AbstractDocStaticTblDAO:1480 - MS SQL Server: SELECT d.* FROM
DBO.TLK_FM_CLIENT d WHERE d.ID=?
10:32:01,683 ERROR XMPPSender:189 - Send Notification failed, XMPPError connecti
ng to localhost:5222.

你好，请问您的操作是不是在主表未保存的时候，就在子表的保存按钮动作执行后脚本里去更新主表字段的值？

回复 14# purple


    嗯，是的！

您好，你的操作不对的，您的主表都没保存，数据库没有对应的记录，怎么可以去更新呢？

回复 16# purple


    我是在修改主表数据的时候才在子表里面进行保存的操作，

回复 17# fei2way


    ???不太明白您的意思。您的业务场景是这条记录已经保存好了，数据库有记录了，只是再打开修改吗？

回复 18# purple


    是的

您好，我这边测试是没问题的哦，方便的话，请加我Q，我这边远程帮您看一下，谢谢。QQ：1946218209