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 "实际开始时间",FREALDETAILSENDTIME as "实际结束时间" from T_ATS_HOLYDETAILS

--INSERT脚本--

insert into T_ATS_HOLYDETAILS(FEntryID,FID,FDATE,FSTANDARDLABOR,FDETAILSSTARTTIME,FDETAILSENDTIME,FTIMELAG,FDATELAG,FISDETAILSWHOLEDAY,FPERSONID,FREALDETAILSSTARTTIME,FREALDETAILSENDTIME) values (?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_ATS_HOLYDETAILS set FEntryID=?,FID=?,FDATE=?,FSTANDARDLABOR=?,FDETAILSSTARTTIME=?,FDETAILSENDTIME=?,FTIMELAG=?,FDATELAG=?,FISDETAILSWHOLEDAY=?,FPERSONID=?,FREALDETAILSSTARTTIME=?,FREALDETAILSENDTIME=? where FEntryID=?

--delete脚本--

delete from T_ATS_HOLYDETAILS where FEntryID=?

--给字段加备注--

alter table T_ATS_HOLYDETAILS comment '请假单明细';

alter table T_ATS_HOLYDETAILS modify column FEntryID int<br> not null  comment 'FEntryID';

alter table T_ATS_HOLYDETAILS modify column FID int<br> default null  comment 'FID';

alter table T_ATS_HOLYDETAILS modify column FDATE datetime<br> default null  comment '出勤日期';

alter table T_ATS_HOLYDETAILS modify column FSTANDARDLABOR decimal(19,6) default null  comment '标准时长';

alter table T_ATS_HOLYDETAILS modify column FDETAILSSTARTTIME datetime<br> default null  comment '开始时间';

alter table T_ATS_HOLYDETAILS modify column FDETAILSENDTIME datetime<br> default null  comment '结束时间';

alter table T_ATS_HOLYDETAILS modify column FTIMELAG decimal(19,6) default null  comment '时长小时';

alter table T_ATS_HOLYDETAILS modify column FDATELAG decimal(19,6) default null  comment '时长天';

alter table T_ATS_HOLYDETAILS modify column FISDETAILSWHOLEDAY char(1) default null  comment '是否整天';

alter table T_ATS_HOLYDETAILS modify column FPERSONID int<br> default null  comment '人员信息';

alter table T_ATS_HOLYDETAILS modify column FREALDETAILSSTARTTIME datetime<br> default null  comment '实际开始时间';

alter table T_ATS_HOLYDETAILS modify column FREALDETAILSENDTIME datetime<br> default null  comment '实际结束时间';