ATS考勤2.21考勤计算（出差单明细）

--建表脚本--

create table T_ATS_TRIPDETAILS(

FENTRYID int not null  comment '分录主键'

,FID int not null  comment '出差单id'

,FDATE datetime default null  comment '考勤日期'

,FDETAILSSTARTTIME datetime default null  comment '开始时间'

,FDETAILSENDTIME datetime default null  comment '结束时间'

,FSHIFTID int default null  comment '班次id'

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

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

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

,FPERSONID int default null  comment '人员id'

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

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

,primary key (FENTRYID)

) comment = '出差单明细'

--查询--

select FENTRYID as "fentryid",FID as "fid",FDATE as "fdate",FDETAILSSTARTTIME as "fdetailsstarttime",FDETAILSENDTIME as "fdetailsendtime",FSHIFTID as "fshiftid",FTIMELAG as "ftimelag",FISDETAILSWHOLEDAY as "fisdetailswholeday",FDATELAG as "fdatelag",FPERSONID as "fpersonid",FREALDETAILSSTARTTIME as "frealdetailsstarttime",FREALDETAILSENDTIME as "frealdetailsendtime" from T_ATS_TRIPDETAILS

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

select FENTRYID as "分录主键",FID as "出差单id",FDATE as "考勤日期",FDETAILSSTARTTIME as "开始时间",FDETAILSENDTIME as "结束时间",FSHIFTID as "班次id",FTIMELAG as "时长",FISDETAILSWHOLEDAY as "是否整天",FDATELAG as "天数",FPERSONID as "人员id",FREALDETAILSSTARTTIME as "实际开始时间",FREALDETAILSENDTIME as "实际结束时间" from T_ATS_TRIPDETAILS

--INSERT脚本--

insert into T_ATS_TRIPDETAILS(FENTRYID,FID,FDATE,FDETAILSSTARTTIME,FDETAILSENDTIME,FSHIFTID,FTIMELAG,FISDETAILSWHOLEDAY,FDATELAG,FPERSONID,FREALDETAILSSTARTTIME,FREALDETAILSENDTIME) values (?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_ATS_TRIPDETAILS set FENTRYID=?,FID=?,FDATE=?,FDETAILSSTARTTIME=?,FDETAILSENDTIME=?,FSHIFTID=?,FTIMELAG=?,FISDETAILSWHOLEDAY=?,FDATELAG=?,FPERSONID=?,FREALDETAILSSTARTTIME=?,FREALDETAILSENDTIME=? where FENTRYID=?

--delete脚本--

delete from T_ATS_TRIPDETAILS where FENTRYID=?

--给字段加备注--

alter table T_ATS_TRIPDETAILS comment '出差单明细';

alter table T_ATS_TRIPDETAILS modify column FENTRYID int not null  comment '分录主键';

alter table T_ATS_TRIPDETAILS modify column FID int not null  comment '出差单id';

alter table T_ATS_TRIPDETAILS modify column FDATE datetime default null  comment '考勤日期';

alter table T_ATS_TRIPDETAILS modify column FDETAILSSTARTTIME datetime default null  comment '开始时间';

alter table T_ATS_TRIPDETAILS modify column FDETAILSENDTIME datetime default null  comment '结束时间';

alter table T_ATS_TRIPDETAILS modify column FSHIFTID int default null  comment '班次id';

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

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

alter table T_ATS_TRIPDETAILS modify column FDATELAG decimal(19,6) default null  comment '天数';

alter table T_ATS_TRIPDETAILS modify column FPERSONID int default null  comment '人员id';

alter table T_ATS_TRIPDETAILS modify column FREALDETAILSSTARTTIME datetime default null  comment '实际开始时间';

alter table T_ATS_TRIPDETAILS modify column FREALDETAILSENDTIME datetime default null  comment '实际结束时间';