[适用版本]

8.6sp1

[分析处理]

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

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

//取员工假期制度关联工作日历的工作日天数

//输出变量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_HolidayPolicySet where fid in(select FHolidayPolicySetID from t_hr_ats_atsholidayfile 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);

 }

}