PLM开发-操作系列

--建表脚本--

create table T_PLM_CFG_OPERATION(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织主键'

,FCODE nvarchar(50) default null  comment '编码'

,FDLLNAME nvarchar(200) default null  comment '编码名称'

,OPERATIONTYPE varchar(100) default null  comment '操作类型'

,FPLUGINPATH varchar(2000) default null  comment '插件路径'

,FOPXML nvarchar(2000) default null  comment '模版'

,FISBILLBUTTON char(1) default ''1''  comment '是否单据按钮'

,FISLISTBUTTON char(1) default ''0''  comment '是否列表按钮'

,FOPGROUP varchar(20) default null  comment '操作分组'

,FTEMPLATE nvarchar(50) default null  comment '模版操作'

,FBUTTONKEY nvarchar(100) default null  comment '按钮标识'

,FLSTBUTTONKEY nvarchar(100) default null  comment '列表按钮标识'

,FPERMISSIONITEMID nvarchar(50) default null  comment '权限项id'

,FPERMISSIONITEMNAME nvarchar(50) default null  comment '权限项名称'

,FNAME nvarchar(50) default null  comment '名称'

,FBUTTONNAME nvarchar(50) default null  comment '按钮名称'

,FBUTTONPATH nvarchar(50) default null  comment '按钮路径'

,FLSTBUTTONNAME nvarchar(50) default null  comment '列表按钮名称'

,FLSTBUTTONPATH nvarchar(50) default null  comment '列表按钮路径'

,FTARGETSTATUS bigint not null  comment '目标状态'

,FISSYSPRESET char(1) not null  comment '是否预制'

,primary key (FID)

) comment = '操作'

--查询--

select FID as "fid",FMasterID as "fmasterid",FCODE as "fcode",FDLLNAME as "fdllname",OPERATIONTYPE as "operationtype",FPLUGINPATH as "fpluginpath",FOPXML as "fopxml",FISBILLBUTTON as "fisbillbutton",FISLISTBUTTON as "fislistbutton",FOPGROUP as "fopgroup",FTEMPLATE as "ftemplate",FBUTTONKEY as "fbuttonkey",FLSTBUTTONKEY as "flstbuttonkey",FPERMISSIONITEMID as "fpermissionitemid",FPERMISSIONITEMNAME as "fpermissionitemname",FNAME as "fname",FBUTTONNAME as "fbuttonname",FBUTTONPATH as "fbuttonpath",FLSTBUTTONNAME as "flstbuttonname",FLSTBUTTONPATH as "flstbuttonpath",FTARGETSTATUS as "ftargetstatus",FISSYSPRESET as "fissyspreset" from T_PLM_CFG_OPERATION

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

select FID as "主键",FMasterID as "组织主键",FCODE as "编码",FDLLNAME as "编码名称",OPERATIONTYPE as "操作类型",FPLUGINPATH as "插件路径",FOPXML as "模版",FISBILLBUTTON as "是否单据按钮",FISLISTBUTTON as "是否列表按钮",FOPGROUP as "操作分组",FTEMPLATE as "模版操作",FBUTTONKEY as "按钮标识",FLSTBUTTONKEY as "列表按钮标识",FPERMISSIONITEMID as "权限项id",FPERMISSIONITEMNAME as "权限项名称",FNAME as "名称",FBUTTONNAME as "按钮名称",FBUTTONPATH as "按钮路径",FLSTBUTTONNAME as "列表按钮名称",FLSTBUTTONPATH as "列表按钮路径",FTARGETSTATUS as "目标状态",FISSYSPRESET as "是否预制" from T_PLM_CFG_OPERATION

--INSERT脚本--

insert into T_PLM_CFG_OPERATION(FID,FMasterID,FCODE,FDLLNAME,OPERATIONTYPE,FPLUGINPATH,FOPXML,FISBILLBUTTON,FISLISTBUTTON,FOPGROUP,FTEMPLATE,FBUTTONKEY,FLSTBUTTONKEY,FPERMISSIONITEMID,FPERMISSIONITEMNAME,FNAME,FBUTTONNAME,FBUTTONPATH,FLSTBUTTONNAME,FLSTBUTTONPATH,FTARGETSTATUS,FISSYSPRESET) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_OPERATION set FID=?,FMasterID=?,FCODE=?,FDLLNAME=?,OPERATIONTYPE=?,FPLUGINPATH=?,FOPXML=?,FISBILLBUTTON=?,FISLISTBUTTON=?,FOPGROUP=?,FTEMPLATE=?,FBUTTONKEY=?,FLSTBUTTONKEY=?,FPERMISSIONITEMID=?,FPERMISSIONITEMNAME=?,FNAME=?,FBUTTONNAME=?,FBUTTONPATH=?,FLSTBUTTONNAME=?,FLSTBUTTONPATH=?,FTARGETSTATUS=?,FISSYSPRESET=? where FID=?

--delete脚本--

delete from T_PLM_CFG_OPERATION where FID=?

--给字段加备注--

alter table T_PLM_CFG_OPERATION comment '操作';

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

alter table T_PLM_CFG_OPERATION modify column FMasterID bigint not null  comment '组织主键';

alter table T_PLM_CFG_OPERATION modify column FCODE nvarchar(50) default null  comment '编码';

alter table T_PLM_CFG_OPERATION modify column FDLLNAME nvarchar(200) default null  comment '编码名称';

alter table T_PLM_CFG_OPERATION modify column OPERATIONTYPE varchar(100) default null  comment '操作类型';

alter table T_PLM_CFG_OPERATION modify column FPLUGINPATH varchar(2000) default null  comment '插件路径';

alter table T_PLM_CFG_OPERATION modify column FOPXML nvarchar(2000) default null  comment '模版';

alter table T_PLM_CFG_OPERATION modify column FISBILLBUTTON char(1) default ''1''  comment '是否单据按钮';

alter table T_PLM_CFG_OPERATION modify column FISLISTBUTTON char(1) default ''0''  comment '是否列表按钮';

alter table T_PLM_CFG_OPERATION modify column FOPGROUP varchar(20) default null  comment '操作分组';

alter table T_PLM_CFG_OPERATION modify column FTEMPLATE nvarchar(50) default null  comment '模版操作';

alter table T_PLM_CFG_OPERATION modify column FBUTTONKEY nvarchar(100) default null  comment '按钮标识';

alter table T_PLM_CFG_OPERATION modify column FLSTBUTTONKEY nvarchar(100) default null  comment '列表按钮标识';

alter table T_PLM_CFG_OPERATION modify column FPERMISSIONITEMID nvarchar(50) default null  comment '权限项id';

alter table T_PLM_CFG_OPERATION modify column FPERMISSIONITEMNAME nvarchar(50) default null  comment '权限项名称';

alter table T_PLM_CFG_OPERATION modify column FNAME nvarchar(50) default null  comment '名称';

alter table T_PLM_CFG_OPERATION modify column FBUTTONNAME nvarchar(50) default null  comment '按钮名称';

alter table T_PLM_CFG_OPERATION modify column FBUTTONPATH nvarchar(50) default null  comment '按钮路径';

alter table T_PLM_CFG_OPERATION modify column FLSTBUTTONNAME nvarchar(50) default null  comment '列表按钮名称';

alter table T_PLM_CFG_OPERATION modify column FLSTBUTTONPATH nvarchar(50) default null  comment '列表按钮路径';

alter table T_PLM_CFG_OPERATION modify column FTARGETSTATUS bigint not null  comment '目标状态';

alter table T_PLM_CFG_OPERATION modify column FISSYSPRESET char(1) not null  comment '是否预制';

--建表脚本--

create table T_PLM_CFG_OPERATIONLIST(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织id'

,FOPERATIONLIST_NAME nvarchar(50) not null  comment '操作名'

,FOPERATIONLIST_ENABLE char(1) not null  comment '是否启用操作'

,FSN int not null  comment '序号'

,FOPERATIONID int not null  comment '操作id'

,FRELATIONTYPE int not null  comment '关系类别'

,primary key (FID)

) comment = '操作列表'

--查询--

select FID as "fid",FMasterID as "fmasterid",FOPERATIONLIST_NAME as "foperationlistName",FOPERATIONLIST_ENABLE as "foperationlistEnable",FSN as "fsn",FOPERATIONID as "foperationid",FRELATIONTYPE as "frelationtype" from T_PLM_CFG_OPERATIONLIST

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

select FID as "主键",FMasterID as "组织id",FOPERATIONLIST_NAME as "操作名",FOPERATIONLIST_ENABLE as "是否启用操作",FSN as "序号",FOPERATIONID as "操作id",FRELATIONTYPE as "关系类别" from T_PLM_CFG_OPERATIONLIST

--INSERT脚本--

insert into T_PLM_CFG_OPERATIONLIST(FID,FMasterID,FOPERATIONLIST_NAME,FOPERATIONLIST_ENABLE,FSN,FOPERATIONID,FRELATIONTYPE) values (?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_OPERATIONLIST set FID=?,FMasterID=?,FOPERATIONLIST_NAME=?,FOPERATIONLIST_ENABLE=?,FSN=?,FOPERATIONID=?,FRELATIONTYPE=? where FID=?

--delete脚本--

delete from T_PLM_CFG_OPERATIONLIST where FID=?

--给字段加备注--

alter table T_PLM_CFG_OPERATIONLIST comment '操作列表';

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

alter table T_PLM_CFG_OPERATIONLIST modify column FMasterID bigint not null  comment '组织id';

alter table T_PLM_CFG_OPERATIONLIST modify column FOPERATIONLIST_NAME nvarchar(50) not null  comment '操作名';

alter table T_PLM_CFG_OPERATIONLIST modify column FOPERATIONLIST_ENABLE char(1) not null  comment '是否启用操作';

alter table T_PLM_CFG_OPERATIONLIST modify column FSN int not null  comment '序号';

alter table T_PLM_CFG_OPERATIONLIST modify column FOPERATIONID int not null  comment '操作id';

alter table T_PLM_CFG_OPERATIONLIST modify column FRELATIONTYPE int not null  comment '关系类别';

--建表脚本--

create table T_PLM_CFG_OPERATIONREC(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织主键'

,FBASEOBJECT bigint not null  comment '操作对象'

,FCATEGORY bigint not null  comment '业务类型'

,FPRESHORTCUTID int not null  comment '快照主键'

,FOBJECTSTATUS nvarchar(50) default null  comment '对象状态'

,FAFTERSHORTCUTID int not null  comment '操作后对象快照主键'

,FCREATORID int not null  comment '创建人'

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

,primary key (FID)

) comment = '操作记录'

--查询--

select FID as "fid",FMasterID as "fmasterid",FBASEOBJECT as "fbaseobject",FCATEGORY as "fcategory",FPRESHORTCUTID as "fpreshortcutid",FOBJECTSTATUS as "fobjectstatus",FAFTERSHORTCUTID as "faftershortcutid",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate" from T_PLM_CFG_OPERATIONREC

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

select FID as "主键",FMasterID as "组织主键",FBASEOBJECT as "操作对象",FCATEGORY as "业务类型",FPRESHORTCUTID as "快照主键",FOBJECTSTATUS as "对象状态",FAFTERSHORTCUTID as "操作后对象快照主键",FCREATORID as "创建人",FCREATEDATE as "创建日期" from T_PLM_CFG_OPERATIONREC

--INSERT脚本--

insert into T_PLM_CFG_OPERATIONREC(FID,FMasterID,FBASEOBJECT,FCATEGORY,FPRESHORTCUTID,FOBJECTSTATUS,FAFTERSHORTCUTID,FCREATORID,FCREATEDATE) values (?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_OPERATIONREC set FID=?,FMasterID=?,FBASEOBJECT=?,FCATEGORY=?,FPRESHORTCUTID=?,FOBJECTSTATUS=?,FAFTERSHORTCUTID=?,FCREATORID=?,FCREATEDATE=? where FID=?

--delete脚本--

delete from T_PLM_CFG_OPERATIONREC where FID=?

--给字段加备注--

alter table T_PLM_CFG_OPERATIONREC comment '操作记录';

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

alter table T_PLM_CFG_OPERATIONREC modify column FMasterID bigint not null  comment '组织主键';

alter table T_PLM_CFG_OPERATIONREC modify column FBASEOBJECT bigint not null  comment '操作对象';

alter table T_PLM_CFG_OPERATIONREC modify column FCATEGORY bigint not null  comment '业务类型';

alter table T_PLM_CFG_OPERATIONREC modify column FPRESHORTCUTID int not null  comment '快照主键';

alter table T_PLM_CFG_OPERATIONREC modify column FOBJECTSTATUS nvarchar(50) default null  comment '对象状态';

alter table T_PLM_CFG_OPERATIONREC modify column FAFTERSHORTCUTID int not null  comment '操作后对象快照主键';

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

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

--建表脚本--

create table T_PLM_CFG_OPERATION_REF(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织中标识'

,OBJECTID nvarchar(50) default null  comment '单据标识'

,FOPERATION bigint default null  comment '操作'

,primary key (FID)

) comment = '单据操作'

--查询--

select FID as "fid",FMasterID as "fmasterid",OBJECTID as "objectid",FOPERATION as "foperation" from T_PLM_CFG_OPERATION_REF

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

select FID as "主键",FMasterID as "组织中标识",OBJECTID as "单据标识",FOPERATION as "操作" from T_PLM_CFG_OPERATION_REF

--INSERT脚本--

insert into T_PLM_CFG_OPERATION_REF(FID,FMasterID,OBJECTID,FOPERATION) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_OPERATION_REF set FID=?,FMasterID=?,OBJECTID=?,FOPERATION=? where FID=?

--delete脚本--

delete from T_PLM_CFG_OPERATION_REF where FID=?

--给字段加备注--

alter table T_PLM_CFG_OPERATION_REF comment '单据操作';

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

alter table T_PLM_CFG_OPERATION_REF modify column FMasterID bigint not null  comment '组织中标识';

alter table T_PLM_CFG_OPERATION_REF modify column OBJECTID nvarchar(50) default null  comment '单据标识';

alter table T_PLM_CFG_OPERATION_REF modify column FOPERATION bigint default null  comment '操作';

--建表脚本--

create table T_PLM_CFG_OPPLUGIN(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织中标识'

,FPNAME nvarchar(50) default null  comment '文件名称'

,FMULCOMBO varchar(100) default null  comment '插件选择'

,FCREATEDATE datetime default null  comment '创建时间'

,primary key (FID)

) comment = '操作对象_插件'

--查询--

select FID as "fid",FMasterID as "fmasterid",FPNAME as "fpname",FMULCOMBO as "fmulcombo",FCREATEDATE as "fcreatedate" from T_PLM_CFG_OPPLUGIN

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

select FID as "主键",FMasterID as "组织中标识",FPNAME as "文件名称",FMULCOMBO as "插件选择",FCREATEDATE as "创建时间" from T_PLM_CFG_OPPLUGIN

--INSERT脚本--

insert into T_PLM_CFG_OPPLUGIN(FID,FMasterID,FPNAME,FMULCOMBO,FCREATEDATE) values (?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_OPPLUGIN set FID=?,FMasterID=?,FPNAME=?,FMULCOMBO=?,FCREATEDATE=? where FID=?

--delete脚本--

delete from T_PLM_CFG_OPPLUGIN where FID=?

--给字段加备注--

alter table T_PLM_CFG_OPPLUGIN comment '操作对象_插件';

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

alter table T_PLM_CFG_OPPLUGIN modify column FMasterID bigint not null  comment '组织中标识';

alter table T_PLM_CFG_OPPLUGIN modify column FPNAME nvarchar(50) default null  comment '文件名称';

alter table T_PLM_CFG_OPPLUGIN modify column FMULCOMBO varchar(100) default null  comment '插件选择';

alter table T_PLM_CFG_OPPLUGIN modify column FCREATEDATE datetime default null  comment '创建时间';

--建表脚本--

create table T_PLM_CFG_OPPLUGINS(

FEntityId bigint not null  comment '分录标识'

,FID bigint not null  comment '外键'

,FPLUGINNAME nvarchar(500) default null  comment '插件描述'

,FPLUGINVALUE nvarchar(500) default null  comment '插件名称'

,FSTATUS char(1) default ''0''  comment '是否启用'

,primary key (FEntityId)

) comment = '操作对象_插件分录'

--查询--

select FEntityId as "fentityid",FID as "fid",FPLUGINNAME as "fpluginname",FPLUGINVALUE as "fpluginvalue",FSTATUS as "fstatus" from T_PLM_CFG_OPPLUGINS

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

select FEntityId as "分录标识",FID as "外键",FPLUGINNAME as "插件描述",FPLUGINVALUE as "插件名称",FSTATUS as "是否启用" from T_PLM_CFG_OPPLUGINS

--INSERT脚本--

insert into T_PLM_CFG_OPPLUGINS(FEntityId,FID,FPLUGINNAME,FPLUGINVALUE,FSTATUS) values (?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_OPPLUGINS set FEntityId=?,FID=?,FPLUGINNAME=?,FPLUGINVALUE=?,FSTATUS=? where FEntityId=?

--delete脚本--

delete from T_PLM_CFG_OPPLUGINS where FEntityId=?

--给字段加备注--

alter table T_PLM_CFG_OPPLUGINS comment '操作对象_插件分录';

alter table T_PLM_CFG_OPPLUGINS modify column FEntityId bigint not null  comment '分录标识';

alter table T_PLM_CFG_OPPLUGINS modify column FID bigint not null  comment '外键';

alter table T_PLM_CFG_OPPLUGINS modify column FPLUGINNAME nvarchar(500) default null  comment '插件描述';

alter table T_PLM_CFG_OPPLUGINS modify column FPLUGINVALUE nvarchar(500) default null  comment '插件名称';

alter table T_PLM_CFG_OPPLUGINS modify column FSTATUS char(1) default ''0''  comment '是否启用';