[适用版本]

通用

[解决方案]

问题:获取从申请日期到请假开始日期之间,事务执行人工作日历相差工作日天数

处理方案:自定义工作流脚本处理,参考脚本如下

//输出变量preDays

StringBuffer tStrSql = new StringBuffer();

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

String startdate= sdf.format(AtsLeaveBill.createTime);

String enddate= sdf.format(AtsLeaveBill.entries.beginTime);

string tsql=select count(1) counts from T_HR_ATS_WorkCalendaritem ;

tsql=tsql+where FDayType=0 and fdate>={ts '+ startdate +'} and fdate<={ts '+ enddate +'} ;

tsql=tsql+and FCalendarGroupID in(select FWorkCalendarID from T_HR_ATS_AttencePolicy where fid in(select FAttencePolicyID from t_hr_Ats_attendancefile where FPROPOSERID ='+ AtsLeaveBill.entries.person.id +') );

tStrSql.append(tsql);

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

if(rowSet!=null)

{

while(rowSet.next()){

preDays= rowSet.getDouble(1);

}

}