[适用版本]

通用

[解决方案]

设置工作流脚本处理,参考如下:

//输出变量:leavelength多人请假单总时长

StringBuffer tStrSql = new StringBuffer();

tStrSql.append(select sum(FLEAVELENGTH) FLEAVELENGTH from t_hr_ats_leavebillentry where fbillid='+LeaveBill.id+' );

com.kingdee.jdbc.rowset.IRowSet rowSet = com.kingdee.eas.util.app.DbUtil.executeQuery(__bosContext,tStrSql.toString());

if(rowSet!=null)

{

while(rowSet.next()){

leavelength= rowSet.getDouble(1);

}

}