关于数据回填至上个页面

比如说由detail页面回填至main页面，在save 的jobunit后面，加上两个jobunit。第一个是url为formatstring的jobunit getsql，然后是url为executsql的jobunit slipupdate。在getsql jobunit里需要把下面的sql语句作为value传进去。

update  expenseslip  set totalamount = (select   sum (a.amount) AS totalamount from  employeegroup d, expenseslipdetail a WHERE 1=1  AND a.relatedtransactionid=d.employeegroupid  and a.expenseslipid=%a1  ), numofattachments = (select  sum (a.numofattachments) AS totalamount FROM employeegroup d, expenseslipdetail a  WHERE 1=1   AND a.relatedtransactionid=d.employeegroupid    and a.expenseslipid=%a1 )  where   expenseslipid=%a1

可以在数据库里预先测试效果如何。