【适用版本】

通用

【概述】

问题：单笔补签卡在工作流或者补签当天的日期类型

方案：设置工作流脚本处理，参考如下：

//输入变量：billId 补签卡单据id  personid  职员id

//输出变量：ft 日期类型  当ft为0的时候说明是工作日

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

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

java . sql . ResultSet rs = null ; 

tsql="select sum(ft)ft from (select distinct a.FAttendDate,case when b.FDayType is  null then d.FDayType else b.FDayType end as FT"

+" from T_HR_ATS_FillSignCardEntry a"

+" left join T_HR_ATS_ScheduleShift b  on a.FPersonID=b.fproposerid and a.FAttendDate=b.FATTENDDATE and a.FPERSONID ='"+ personid+"'"

+" left join (select c.FPROPOSERID,e.FDate,e.FDayType from t_hr_ats_attendancefile c right join T_HR_ATS_WorkCalendaritem e on c.FcalendarID=e.FCalendarGroupID )d  on a.FAttendDate=d.FDate and a.FPersonID=d.FPROPOSERID and a.FPERSONID ='"+ personid+"'"

+" where a.fbillid ='"+billId+"' )X";

rs = st . executeQuery ( tsql ) ;

if ( rs . next ) { 

ft= rs . getDouble ( "ft" ) ; 

}

com . kingdee . util . db . SQLUtils . cleanup ( st , con1 ) ; 

com . kingdee . util . db . SQLUtils . cleanup ( con1 ) ;