工作流中如何获取请假时间段生效的剩余额度总和

问题:工作流中如何获取请假时间段生效的剩余额度总和

处理方案:

1、定义流程变量“syed”,如下图所示

2、在提交节点,添加后置脚本,如下图所示

//输出参数:syed 请假时间段生效的剩余额度总和

SimpleDateFormat sdf = new java . text . SimpleDateFormat ( "yyyy-MM-dd" ) ;

String sd = sdf . format ( bizObj.entries.beginTime ) ;

String ed = sdf . format ( bizObj.entries.endTime ) ;

java . sql . Connection con = com . kingdee . bos . framework . ejb . EJBFactory . getConnection ( __bosContext ) ;

java . sql . Statement st = con . createStatement ( ) ;

java . sql . ResultSet rs = null ;

String tsql = "select sum(FRemainLimit) ed " ;

tsql  = tsql + "from t_hr_Ats_holidaylimit " ;

tsql  = tsql +  "where  ((FDelayDate >={ts '"+sd+"'} and FEffectDate <= {ts '"+sd+"'} ) " ;

tsql  = tsql +  " or (FDelayDat