--建表脚本--

create table T_ATS_SHIFTRULE_L(

FPKID int not null  comment '多语言内码'

,FID int default null  comment '班次信息内码'

,FLOCALEID int default null  comment '语种'

,FDESCRIPTION nvarchar(255) not null  comment '备注'

,FNAME nvarchar(80) not null  comment '名称'

,primary key (FPKID)

) comment = '轮班规则多语言表'

--查询--

select FPKID as "fpkid",FID as "fid",FLOCALEID as "flocaleid",FDESCRIPTION as "fdescription",FNAME as "fname" from T_ATS_SHIFTRULE_L

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

select FPKID as "多语言内码",FID as "班次信息内码",FLOCALEID as "语种",FDESCRIPTION as "备注",FNAME as "名称" from T_ATS_SHIFTRULE_L

--INSERT脚本--

insert into T_ATS_SHIFTRULE_L(FPKID,FID,FLOCALEID,FDESCRIPTION,FNAME) values (?,?,?,?,?)

--UPDATE脚本--

update T_ATS_SHIFTRULE_L set FPKID=?,FID=?,FLOCALEID=?,FDESCRIPTION=?,FNAME=? where FPKID=?

--delete脚本--

delete from T_ATS_SHIFTRULE_L where FPKID=?

--给字段加备注--

alter table T_ATS_SHIFTRULE_L comment '轮班规则多语言表';

alter table T_ATS_SHIFTRULE_L modify column FPKID int not null  comment '多语言内码';

alter table T_ATS_SHIFTRULE_L modify column FID int default null  comment '班次信息内码';

alter table T_ATS_SHIFTRULE_L modify column FLOCALEID int default null  comment '语种';

alter table T_ATS_SHIFTRULE_L modify column FDESCRIPTION nvarchar(255) not null  comment '备注';

alter table T_ATS_SHIFTRULE_L modify column FNAME nvarchar(80) not null  comment '名称';

--建表脚本--

create table T_ATS_SHIFTTIMEINFO(

FEntryID int not null  comment '内码'

,FID int default null  comment '班次信息内码'

,FTIMEPART int default null  comment '时段序号'

,FCHECKIN datetime default null  comment '上班时间'

,FCHECKINUNIT char(1) default null  comment '上班时间单位'

,FISCHECKIN char(1) default null  comment '上班是否打卡'

,FCHECKINBEGIN datetime default null  comment '上班取卡开始值'

,FCHECKINBEGINUNIT char(1) default null  comment '上班取卡开始单位'

,FCHECKINEND datetime default null  comment '上班取卡结束值'

,FCHECKINENDUNIT char(1) default null  comment '上班取卡结束单位'

,FCHECKINADJUST int default null  comment '上班浮动调整值'

,FRESTTIME int default null  comment '段内休息'

,FCHECKOUT datetime default null  comment '下班时间'

,FCHECKOUTUNIT char(1) default null  comment '下班时间单位'

,FISCHECKOUT char(1) default null  comment '下班是否打卡'

,FCHECKOUTBEGIN datetime default null  comment '下班取卡开始值'

,FCHECKOUTBEGINUNIT char(1) default null  comment '下班取卡开始单位'

,FCHECKOUTEND datetime default null  comment '下班取卡结束值'

,FCHECKOUTENDUNIT char(1) default null  comment '下班取卡结束单位'

,FCHECKOUTADJUST int default null  comment '下班浮动调整值'

,FATTENDTYPE char(1) default null  comment '出勤类型'

,FISEMPTY char(1) default null  comment '是否空行'

,FREALCHECKINBEGIN datetime default null  comment '实际上班取卡开始'

,FREALCHECKINEND datetime default null  comment '实际上班取卡结束'

,FREALCHECKOUTBEGIN datetime default null  comment '实际下班取卡开始'

,FREALCHECKOUTEND datetime default null  comment '实际下班取卡结束'

,FREALCHECKINBEGINUNIT char(1) default null  comment '实际上班取卡开始单位'

,FREALCHECKINENDUNIT char(1) default null  comment '实际上班取卡结束单位'

,FREALCHECKOUTBEGINUNIT char(1) default null  comment '实际下班取卡开始单位'

,FREALCHECKOUTENDUNIT char(1) default null  comment '实际下班取卡结束单位'

,primary key (FEntryID)

) comment = '班次时段信息'

--查询--

select FEntryID as "fentryid",FID as "fid",FTIMEPART as "ftimepart",FCHECKIN as "fcheckin",FCHECKINUNIT as "fcheckinunit",FISCHECKIN as "fischeckin",FCHECKINBEGIN as "fcheckinbegin",FCHECKINBEGINUNIT as "fcheckinbeginunit",FCHECKINEND as "fcheckinend",FCHECKINENDUNIT as "fcheckinendunit",FCHECKINADJUST as "fcheckinadjust",FRESTTIME as "fresttime",FCHECKOUT as "fcheckout",FCHECKOUTUNIT as "fcheckoutunit",FISCHECKOUT as "fischeckout",FCHECKOUTBEGIN as "fcheckoutbegin",FCHECKOUTBEGINUNIT as "fcheckoutbeginunit",FCHECKOUTEND as "fcheckoutend",FCHECKOUTENDUNIT as "fcheckoutendunit",FCHECKOUTADJUST as "fcheckoutadjust",FATTENDTYPE as "fattendtype",FISEMPTY as "fisempty",FREALCHECKINBEGIN as "frealcheckinbegin",FREALCHECKINEND as "frealcheckinend",FREALCHECKOUTBEGIN as "frealcheckoutbegin",FREALCHECKOUTEND as "frealcheckoutend",FREALCHECKINBEGINUNIT as "frealcheckinbeginunit",FREALCHECKINENDUNIT as "frealcheckinendunit",FREALCHECKOUTBEGINUNIT as "frealcheckoutbeginunit",FREALCHECKOUTENDUNIT as "frealcheckoutendunit" from T_ATS_SHIFTTIMEINFO

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

select FEntryID as "内码",FID as "班次信息内码",FTIMEPART as "时段序号",FCHECKIN as "上班时间",FCHECKINUNIT as "上班时间单位",FISCHECKIN as "上班是否打卡",FCHECKINBEGIN as "上班取卡开始值",FCHECKINBEGINUNIT as "上班取卡开始单位",FCHECKINEND as "上班取卡结束值",FCHECKINENDUNIT as "上班取卡结束单位",FCHECKINADJUST as "上班浮动调整值",FRESTTIME as "段内休息",FCHECKOUT as "下班时间",FCHECKOUTUNIT as "下班时间单位",FISCHECKOUT as "下班是否打卡",FCHECKOUTBEGIN as "下班取卡开始值",FCHECKOUTBEGINUNIT as "下班取卡开始单位",FCHECKOUTEND as "下班取卡结束值",FCHECKOUTENDUNIT as "下班取卡结束单位",FCHECKOUTADJUST as "下班浮动调整值",FATTENDTYPE as "出勤类型",FISEMPTY as "是否空行",FREALCHECKINBEGIN as "实际上班取卡开始",FREALCHECKINEND as "实际上班取卡结束",FREALCHECKOUTBEGIN as "实际下班取卡开始",FREALCHECKOUTEND as "实际下班取卡结束",FREALCHECKINBEGINUNIT as "实际上班取卡开始单位",FREALCHECKINENDUNIT as "实际上班取卡结束单位",FREALCHECKOUTBEGINUNIT as "实际下班取卡开始单位",FREALCHECKOUTENDUNIT as "实际下班取卡结束单位" from T_ATS_SHIFTTIMEINFO

--INSERT脚本--

insert into T_ATS_SHIFTTIMEINFO(FEntryID,FID,FTIMEPART,FCHECKIN,FCHECKINUNIT,FISCHECKIN,FCHECKINBEGIN,FCHECKINBEGINUNIT,FCHECKINEND,FCHECKINENDUNIT,FCHECKINADJUST,FRESTTIME,FCHECKOUT,FCHECKOUTUNIT,FISCHECKOUT,FCHECKOUTBEGIN,FCHECKOUTBEGINUNIT,FCHECKOUTEND,FCHECKOUTENDUNIT,FCHECKOUTADJUST,FATTENDTYPE,FISEMPTY,FREALCHECKINBEGIN,FREALCHECKINEND,FREALCHECKOUTBEGIN,FREALCHECKOUTEND,FREALCHECKINBEGINUNIT,FREALCHECKINENDUNIT,FREALCHECKOUTBEGINUNIT,FREALCHECKOUTENDUNIT) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_ATS_SHIFTTIMEINFO set FEntryID=?,FID=?,FTIMEPART=?,FCHECKIN=?,FCHECKINUNIT=?,FISCHECKIN=?,FCHECKINBEGIN=?,FCHECKINBEGINUNIT=?,FCHECKINEND=?,FCHECKINENDUNIT=?,FCHECKINADJUST=?,FRESTTIME=?,FCHECKOUT=?,FCHECKOUTUNIT=?,FISCHECKOUT=?,FCHECKOUTBEGIN=?,FCHECKOUTBEGINUNIT=?,FCHECKOUTEND=?,FCHECKOUTENDUNIT=?,FCHECKOUTADJUST=?,FATTENDTYPE=?,FISEMPTY=?,FREALCHECKINBEGIN=?,FREALCHECKINEND=?,FREALCHECKOUTBEGIN=?,FREALCHECKOUTEND=?,FREALCHECKINBEGINUNIT=?,FREALCHECKINENDUNIT=?,FREALCHECKOUTBEGINUNIT=?,FREALCHECKOUTENDUNIT=? where FEntryID=?

--delete脚本--

delete from T_ATS_SHIFTTIMEINFO where FEntryID=?

--给字段加备注--

alter table T_ATS_SHIFTTIMEINFO comment '班次时段信息';

alter table T_ATS_SHIFTTIMEINFO modify column FEntryID int not null  comment '内码';

alter table T_ATS_SHIFTTIMEINFO modify column FID int default null  comment '班次信息内码';

alter table T_ATS_SHIFTTIMEINFO modify column FTIMEPART int default null  comment '时段序号';

alter table T_ATS_SHIFTTIMEINFO modify column FCHECKIN datetime default null  comment '上班时间';

alter table T_ATS_SHIFTTIMEINFO modify column FCHECKINUNIT char(1) default null  comment '上班时间单位';

alter table T_ATS_SHIFTTIMEINFO modify column FISCHECKIN char(1) default null  comment '上班是否打卡';

alter table T_ATS_SHIFTTIMEINFO modify column FCHECKINBEGIN datetime default null  comment '上班取卡开始值';

alter table T_ATS_SHIFTTIMEINFO modify column FCHECKINBEGINUNIT char(1) default null  comment '上班取卡开始单位';

alter table T_ATS_SHIFTTIMEINFO modify column FCHECKINEND datetime default null  comment '上班取卡结束值';

alter table T_ATS_SHIFTTIMEINFO modify column FCHECKINENDUNIT char(1) default null  comment '上班取卡结束单位';

alter table T_ATS_SHIFTTIMEINFO modify column FCHECKINADJUST int default null  comment '上班浮动调整值';

alter table T_ATS_SHIFTTIMEINFO modify column FRESTTIME int default null  comment '段内休息';

alter table T_ATS_SHIFTTIMEINFO modify column FCHECKOUT datetime default null  comment '下班时间';

alter table T_ATS_SHIFTTIMEINFO modify column FCHECKOUTUNIT char(1) default null  comment '下班时间单位';

alter table T_ATS_SHIFTTIMEINFO modify column FISCHECKOUT char(1) default null  comment '下班是否打卡';

alter table T_ATS_SHIFTTIMEINFO modify column FCHECKOUTBEGIN datetime default null  comment '下班取卡开始值';

alter table T_ATS_SHIFTTIMEINFO modify column FCHECKOUTBEGINUNIT char(1) default null  comment '下班取卡开始单位';

alter table T_ATS_SHIFTTIMEINFO modify column FCHECKOUTEND datetime default null  comment '下班取卡结束值';

alter table T_ATS_SHIFTTIMEINFO modify column FCHECKOUTENDUNIT char(1) default null  comment '下班取卡结束单位';

alter table T_ATS_SHIFTTIMEINFO modify column FCHECKOUTADJUST int default null  comment '下班浮动调整值';

alter table T_ATS_SHIFTTIMEINFO modify column FATTENDTYPE char(1) default null  comment '出勤类型';

alter table T_ATS_SHIFTTIMEINFO modify column FISEMPTY char(1) default null  comment '是否空行';

alter table T_ATS_SHIFTTIMEINFO modify column FREALCHECKINBEGIN datetime default null  comment '实际上班取卡开始';

alter table T_ATS_SHIFTTIMEINFO modify column FREALCHECKINEND datetime default null  comment '实际上班取卡结束';

alter table T_ATS_SHIFTTIMEINFO modify column FREALCHECKOUTBEGIN datetime default null  comment '实际下班取卡开始';

alter table T_ATS_SHIFTTIMEINFO modify column FREALCHECKOUTEND datetime default null  comment '实际下班取卡结束';

alter table T_ATS_SHIFTTIMEINFO modify column FREALCHECKINBEGINUNIT char(1) default null  comment '实际上班取卡开始单位';

alter table T_ATS_SHIFTTIMEINFO modify column FREALCHECKINENDUNIT char(1) default null  comment '实际上班取卡结束单位';

alter table T_ATS_SHIFTTIMEINFO modify column FREALCHECKOUTBEGINUNIT char(1) default null  comment '实际下班取卡开始单位';

alter table T_ATS_SHIFTTIMEINFO modify column FREALCHECKOUTENDUNIT char(1) default null  comment '实际下班取卡结束单位';