ATS考勤2.10考勤计算（请假单明细）

--建表脚本--

create table T_ATS_HOLYDETAILS(

FEntryID int<br> not null  comment 'FEntryID'

,FID int<br> default null  comment 'FID'

,FDATE datetime<br> default null  comment '出勤日期'

,FSTANDARDLABOR decimal(19,6) default null  comment '标准时长'

,FDETAILSSTARTTIME datetime<br> default null  comment '开始时间'

,FDETAILSENDTIME datetime<br> default null  comment '结束时间'

,FTIMELAG decimal(19,6) default null  comment '时长小时'

,FDATELAG decimal(19,6) default null  comment '时长天'

,FISDETAILSWHOLEDAY char(1) default null  comment '是否整天'

,FPERSONID int<br> default null  comment '人员信息'

,FREALDETAILSSTARTTIME datetime<br> default null  comment '实际开始时间'

,FREALDETAILSENDTIME datetime<br> default null  comment '实际结束时间'

,primary key (FEntryID)

) comment = '请假单明细'

--查询--

select FEntryID as "fentryid",FID as "fid",FDATE as "fdate",FSTANDARDLABOR as "fstandardlabor",FDETAILSSTARTTIME as "fdetailsstarttime",FDETAILSENDTIME as "fdetailsendtime",FTIMELAG as "ftimelag",FDATELAG as "fdatelag",FISDETAILSWHOLEDAY as "fisdetailswholeday",FPERSONID as "fpersonid",FREALDETAILSSTARTTIME as "frealdetailsstarttime",FREALDETAILSENDTIME as "frealdetailsendtime" from T_ATS_HOLYDETAILS

--查询(中文字段)--

select FEntryID as "FEntryID",FID as "FID",FDATE as "出勤日期",FSTANDARDLABOR as "标准时长",FDETAILSSTARTTIME as "开始时间",FDETAILSENDTIME as "结束时间",FTIMELAG as "时长小时",FDATELAG as "时长天",FISDETAILSWHOLEDAY as "是否整天",FPERSONID as "人员信息",FREALDETAILSSTARTTIME as "实际开始时间",FREALD