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