[适用版本]

通用

[分析处理]

问题:工作流如何获取请假时段所在年度的病假累计额度?

处理方案:工作流脚本实现,参考如下

//流程变量说明:

//输入变量:personid是职员id , beginleavedate 请假开始时间

//输出变量:leavelength

StringBuffer tStrSql = new StringBuffer();  

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

String bld = sdf.format(beginleavedate);

tStrSql.append(select sum(case when fleaveunit=2 then FLEAVELENGTH/8 else FLEAVELENGTH end ) yearlength from t_hr_ats_leavebilldetail

where fproposerid='+personid+' and year(fleavedate)=year('+bld+') and FPOLICYID in(select fid from t_hr_Ats_holidaypolicy where fname_l2='病假'));

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

if(rowSet!=null)

{

 while(rowSet.next()){

 leavelength = rowSet.getString(1);

 }

}