PLM-工作流

--建表脚本--

create table T_PLM_WF_BASEOBJECTBILL(

FID bigint not null  comment '主键'

,FBILLNO nvarchar(30) default null  comment '单据编号'

,FDOCUMENTSTATUS char(1) default ''0''  comment '数据状态'

,FBILLNONAME nvarchar(255) default null  comment '单据名称'

,FCREATORID int not null  comment '创建人'

,FMODIFYDATE datetime default null  comment '修改日期'

,FCREATEDATE datetime default null  comment '创建日期'

,FMODIFIERID int not null  comment '修改人'

,FFLOWTYPE int not null  comment '流程类型'

,FMARK nvarchar(1000) not null  comment '备注'

,primary key (FID)

) comment = 'plm基础对象单据'

--查询--

select FID as "fid",FBILLNO as "fbillno",FDOCUMENTSTATUS as "fdocumentstatus",FBILLNONAME as "fbillnoname",FCREATORID as "fcreatorid",FMODIFYDATE as "fmodifydate",FCREATEDATE as "fcreatedate",FMODIFIERID as "fmodifierid",FFLOWTYPE as "fflowtype",FMARK as "fmark" from T_PLM_WF_BASEOBJECTBILL

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

select FID as "主键",FBILLNO as "单据编号",FDOCUMENTSTATUS as "数据状态",FBILLNONAME as "单据名称",FCREATORID as "创建人",FMODIFYDATE as "修改日期",FCREATEDATE as "创建日期",FMODIFIERID as "修改人",FFLOWTYPE as "流程类型",FMARK as "备注" from T_PLM_WF_BASEOBJECTBILL

--INSERT脚本--

insert into T_PLM_WF_BASEOBJECTBILL(FID,FBILLNO,FDOCUMENTSTATUS,FBILLNONAME,FCREATORID,FMODIFYDATE,FCREATEDATE,FMODIFIERID,FFLOWTYPE,FMARK) values (?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_WF_BASEOBJECTBILL set FID=?,FBILLNO=?,FDOCUMENTSTATUS=?,FBILLNONAME=?,FCREATORID=?,FMODIFYDATE=?,FCREATEDATE=?,FMODIFIERID=?,FFLOWTYPE=?,FMARK=? where FID=?

--delete脚本--

delete from T_PLM_WF_BASEOBJECTBILL where FID=?

--给字段加备注--

alter table T_PLM_WF_BASEOBJECTBILL comment 'plm基础对象单据';

alter table T_PLM_WF_BASEOBJECTBILL modify column FID bigint not null  comment '主键';

alter table T_PLM_WF_BASEOBJECTBILL modify column FBILLNO nvarchar(30) default null  comment '单据编号';

alter table T_PLM_WF_BASEOBJECTBILL modify column FDOCUMENTSTATUS char(1) default ''0''  comment '数据状态';

alter table T_PLM_WF_BASEOBJECTBILL modify column FBILLNONAME nvarchar(255) default null  comment '单据名称';

alter table T_PLM_WF_BASEOBJECTBILL modify column FCREATORID int not null  comment '创建人';

alter table T_PLM_WF_BASEOBJECTBILL modify column FMODIFYDATE datetime default null  comment '修改日期';

alter table T_PLM_WF_BASEOBJECTBILL modify column FCREATEDATE datetime default null  comment '创建日期';

alter table T_PLM_WF_BASEOBJECTBILL modify column FMODIFIERID int not null  comment '修改人';

alter table T_PLM_WF_BASEOBJECTBILL modify column FFLOWTYPE int not null  comment '流程类型';

alter table T_PLM_WF_BASEOBJECTBILL modify column FMARK nvarchar(1000) not null  comment '备注';

--建表脚本--

create table T_PLM_WF_BASEOBJECTBILLENTRY(

FEntryID bigint not null  comment '从表主键'

,FID bigint not null  comment '主键'

,FBASECODE bigint not null  comment '基础对象'

,FICON nvarchar(2000) not null  comment '图标'

,FISCHECK char(1) not null  comment '是否选中对象'

,FROWID nvarchar(50) not null  comment '体行id'

,FPARENTROWID nvarchar(50) not null  comment '父级行id'

,FROWEXPANDTYPE nvarchar(50) not null  comment '展开类型'

,primary key (FEntryID)

) comment = '流程单据子单据体'

--查询--

select FEntryID as "fentryid",FID as "fid",FBASECODE as "fbasecode",FICON as "ficon",FISCHECK as "fischeck",FROWID as "frowid",FPARENTROWID as "fparentrowid",FROWEXPANDTYPE as "frowexpandtype" from T_PLM_WF_BASEOBJECTBILLENTRY

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

select FEntryID as "从表主键",FID as "主键",FBASECODE as "基础对象",FICON as "图标",FISCHECK as "是否选中对象",FROWID as "体行id",FPARENTROWID as "父级行id",FROWEXPANDTYPE as "展开类型" from T_PLM_WF_BASEOBJECTBILLENTRY

--INSERT脚本--

insert into T_PLM_WF_BASEOBJECTBILLENTRY(FEntryID,FID,FBASECODE,FICON,FISCHECK,FROWID,FPARENTROWID,FROWEXPANDTYPE) values (?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_WF_BASEOBJECTBILLENTRY set FEntryID=?,FID=?,FBASECODE=?,FICON=?,FISCHECK=?,FROWID=?,FPARENTROWID=?,FROWEXPANDTYPE=? where FEntryID=?

--delete脚本--

delete from T_PLM_WF_BASEOBJECTBILLENTRY where FEntryID=?

--给字段加备注--

alter table T_PLM_WF_BASEOBJECTBILLENTRY comment '流程单据子单据体';

alter table T_PLM_WF_BASEOBJECTBILLENTRY modify column FEntryID bigint not null  comment '从表主键';

alter table T_PLM_WF_BASEOBJECTBILLENTRY modify column FID bigint not null  comment '主键';

alter table T_PLM_WF_BASEOBJECTBILLENTRY m