ATS考勤1.15基础资料（下拉列表源字段、定时导入结果、考勤计算表信息）

--建表脚本--

create table T_ATS_IMPORTLISTSOURCE(

FID int not null  comment '手工引入方案id'

,FVALUE int not null  comment '手工引入下拉值'

,FNAME nvarchar(80) default null  comment '手工引入下拉名称'

,primary key (FID,FVALUE)

) comment = '下拉列表源字段'

--查询--

select FID as "fid",FVALUE as "fvalue",FNAME as "fname" from T_ATS_IMPORTLISTSOURCE

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

select FID as "手工引入方案id",FVALUE as "手工引入下拉值",FNAME as "手工引入下拉名称" from T_ATS_IMPORTLISTSOURCE

--INSERT脚本--

insert into T_ATS_IMPORTLISTSOURCE(FID,FVALUE,FNAME) values (?,?,?)

--UPDATE脚本--

update T_ATS_IMPORTLISTSOURCE set FID=?,FVALUE=?,FNAME=? where FID=? AND FVALUE=?

--delete脚本--

delete from T_ATS_IMPORTLISTSOURCE where FID=? AND FVALUE=?

--给字段加备注--

alter table T_ATS_IMPORTLISTSOURCE comment '下拉列表源字段';

alter table T_ATS_IMPORTLISTSOURCE modify column FID int not null  comment '手工引入方案id';

alter table T_ATS_IMPORTLISTSOURCE modify column FVALUE int not null  comment '手工引入下拉值';

alter table T_ATS_IMPORTLISTSOURCE modify column FNAME nvarchar(80) default null  comment '手工引入下拉名称';

--建表脚本--

create table T_ATS_IMPRESULT(

FENTRYID int not null  comment '内码'

,FID int default null  comment '方案内码'

,FIMPORTFILE nvarchar(255) default null  comment '导入文件'

,FIMPORTTIME datetime default null  comment '导入时间'

,FIMPORTRESULT char(1) default null  comment '导入结果'

,FCONTENT NTEXT default null  comment '导入结果明细'

,primary key (FENTRYID)

) comment = '定时导入结果'

--查询--

select FENTRYID as "fentryid",FID as "fid",FIMPORTFILE as "fimportfile",FIMPORTTIME as "fimporttime",FIMPORTRESULT as "fimportresult",FCONTENT as "fcontent" from T_ATS_IMPRESULT

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

select FENTRYID as "内码",FID as "方案内码",FIMPORTFILE as "导入文件",FIMPORTTIME as "导入时间",FIMPORTRESULT as "导入结果",FCONTENT as "导入结果明细" from T_ATS_IMPRESULT

--INSERT脚本--

insert into T_ATS_IMPRESULT(FENTRYID,FID,FIMPORTFILE,FIMPORTTIME,FIMPORTRESULT,FCONTENT) values (?,?,?,?,?,?)

--UPDATE脚本--

update T_ATS_IMPRESULT set FENTRYID=?,FID=?,FIMPORTFILE=?,FIMPORTTIME=?,FIMPORTRESULT=?,FCONTENT=? where FENTRYID=?

--delete脚本--

delete from T_ATS_IMPRESULT where FENTRYID=?

--给字段加备注--

alter table T_ATS_IMPRESULT comment '定时导入结果';

alter table T_ATS_IMPRESULT modify column FENTRYID int not null  comment '内码';

alter table T_ATS_IMPRESULT modify column FID int default null  comment '方案内码';

alter table T_ATS_IMPRESULT modify column FIMPORTFILE nvarchar(255) default null  comment '导入