PLM模块关联内容（一）原创
金蝶云·星空-PLM
金蝶云社区-枯藤老树昏鸦
枯藤老树昏鸦
6人赞赏了该文章 120次浏览 未经作者许可，禁止转载编辑于2024年04月09日 14:35:13

image.png

--建表脚本--

create table T_PLM_CAD_CLIENTMEMORY(

FID bigint not null  comment '标识'

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

,FINTEGRATION int default null  comment '集成软件id'

,FFOLDER bigint default null  comment '文件夹标识'

,FUSER int default null  comment '用户标识'

,FCATEGORY bigint default null  comment '业务类型标识'

,primary key (FID)

) comment = 'cad文件夹记忆'


--查询--

select FID as "fid",FMasterID as "fmasterid",FINTEGRATION as "fintegration",FFOLDER as "ffolder",FUSER as "fuser",FCATEGORY as "fcategory" from T_PLM_CAD_CLIENTMEMORY


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

select FID as "标识",FMasterID as "多组织标识",FINTEGRATION as "集成软件id",FFOLDER as "文件夹标识",FUSER as "用户标识",FCATEGORY as "业务类型标识" from T_PLM_CAD_CLIENTMEMORY


--INSERT脚本--

insert into T_PLM_CAD_CLIENTMEMORY(FID,FMasterID,FINTEGRATION,FFOLDER,FUSER,FCATEGORY) values (?,?,?,?,?,?)


--UPDATE脚本--

update T_PLM_CAD_CLIENTMEMORY set FID=?,FMasterID=?,FINTEGRATION=?,FFOLDER=?,FUSER=?,FCATEGORY=? where FID=?


--delete脚本--

delete from T_PLM_CAD_CLIENTMEMORY where FID=?


--给字段加备注--

alter table T_PLM_CAD_CLIENTMEMORY comment 'cad文件夹记忆';

alter table T_PLM_CAD_CLIENTMEMORY modify column FID bigint not null  comment '标识';

alter table T_PLM_CAD_CLIENTMEMORY modify column FMasterID bigint not null  comment '多组织标识';

alter table T_PLM_CAD_CLIENTMEMORY modify column FINTEGRATION int default null  comment '集成软件id';

alter table T_PLM_CAD_CLIENTMEMORY modify column FFOLDER bigint default null  comment '文件夹标识';

alter table T_PLM_CAD_CLIENTMEMORY modify column FUSER int default null  comment '用户标识';

alter table T_PLM_CAD_CLIENTMEMORY modify column FCATEGORY bigint default null  comment '业务类型标识';

--建表脚本--

create table T_PLM_CFG_ADMIN(

FID bigint not null  comment 'FID'

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

,primary key (FID)

) comment = 'plm管理员单据头'


--查询--

select FID as "fid",FMasterID as "fmasterid" from T_PLM_CFG_ADMIN


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

select FID as "FID",FMasterID as "多组织主键id" from T_PLM_CFG_ADMIN


--INSERT脚本--

insert into T_PLM_CFG_ADMIN(FID,FMasterID) values (?,?)


--UPDATE脚本--

update T_PLM_CFG_ADMIN set FID=?,FMasterID=? where FID=?


--delete脚本--

delete from T_PLM_CFG_ADMIN where FID=?


--给字段加备注--

alter table T_PLM_CFG_ADMIN comment 'plm管理员单据头';

alter table T_PLM_CFG_ADMIN modify column FID bigint not null  comment 'FID';

alter table T_PLM_CFG_ADMIN modify column FMasterID bigint not null  comment '多组织主键id';

--建表脚本--

create table T_PLM_CFG_ADMINROLE(

FEntryID bigint not null  comment 'FEntryID'

,FID bigint not null  comment 'FID'

,FROLE int not null  comment '角色'

,FENABLED char(1) not null  comment '是否启用'

,primary key (FEntryID)

) comment = 'plm管理员单据体'


--查询--

select FEntryID as "fentryid",FID as "fid",FROLE as "frole",FENABLED as "fenabled" from T_PLM_CFG_ADMINROLE


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

select FEntryID as "FEntryID",FID as "FID",FROLE as "角色",FENABLED as "是否启用" from T_PLM_CFG_ADMINROLE


--INSERT脚本--

insert into T_PLM_CFG_ADMINROLE(FEntryID,FID,FROLE,FENABLED) values (?,?,?,?)


--UPDATE脚本--

update T_PLM_CFG_ADMINROLE set FEntryID=?,FID=?,FROLE=?,FENABLED=? where FEntryID=?


--delete脚本--

delete from T_PLM_CFG_ADMINROLE where FEntryID=?


--给字段加备注--

alter table T_PLM_CFG_ADMINROLE comment 'plm管理员单据体';

alter table T_PLM_CFG_ADMINROLE modify column FEntryID bigint not null  comment 'FEntryID';

alter table T_PLM_CFG_ADMINROLE modify column FID bigint not null  comment 'FID';

alter table T_PLM_CFG_ADMINROLE modify column FROLE int not null  comment '角色';

alter table T_PLM_CFG_ADMINROLE modify column FENABLED char(1) not null  comment '是否启用';

--建表脚本--

create table T_PLM_CFG_AD_CATEGRYVIEW(

FEntryID bigint not null  comment 'FEntryID'

,FID bigint not null  comment 'FID'

,FCATEGORYID bigint not null  comment '业务类型id'

,FADVIEWNAME nvarchar(50) not null  comment '将要创建的视图名称'

,primary key (FEntryID)

) comment = '用户自定义视图名称记录表'


--查询--

select FEntryID as "fentryid",FID as "fid",FCATEGORYID as "fcategoryid",FADVIEWNAME as "fadviewname" from T_PLM_CFG_AD_CATEGRYVIEW


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

select FEntryID as "FEntryID",FID as "FID",FCATEGORYID as "业务类型id",FADVIEWNAME as "将要创建的视图名称" from T_PLM_CFG_AD_CATEGRYVIEW


--INSERT脚本--

insert into T_PLM_CFG_AD_CATEGRYVIEW(FEntryID,FID,FCATEGORYID,FADVIEWNAME) values (?,?,?,?)


--UPDATE脚本--

update T_PLM_CFG_AD_CATEGRYVIEW set FEntryID=?,FID=?,FCATEGORYID=?,FADVIEWNAME=? where FEntryID=?


--delete脚本--

delete from T_PLM_CFG_AD_CATEGRYVIEW where FEntryID=?


--给字段加备注--

alter table T_PLM_CFG_AD_CATEGRYVIEW comment '用户自定义视图名称记录表';

alter table T_PLM_CFG_AD_CATEGRYVIEW modify column FEntryID bigint not null  comment 'FEntryID';

alter table T_PLM_CFG_AD_CATEGRYVIEW modify column FID bigint not null  comment 'FID';

alter table T_PLM_CFG_AD_CATEGRYVIEW modify column FCATEGORYID bigint not null  comment '业务类型id';

alter table T_PLM_CFG_AD_CATEGRYVIEW modify column FADVIEWNAME nvarchar(50) not null  comment '将要创建的视图名称';

--建表脚本--

create table T_PLM_CFG_AD_CONFIG(

FID bigint not null  comment 'FID'

,FMasterID bigint not null  comment 'FMasterID'

,FADSYNCHROGAZERDBURL nvarchar(50) not null  comment '数据库地址'

,FADSYNCHROGAZERDBNAME nvarchar(50) not null  comment '数据库名称'

,FADSYNCHROGAZERDBPASSWORD nvarchar(50) not null  comment '数据库密码'

,FADSYNCHROGAZERDBACCOUNT nvarchar(50) not null  comment '数据库账号'

,FADSYNCHRONIZATIONTIME int not null  comment '更新间隔时间'

,FTEMPTIME nvarchar(50) not null  comment '根据单位显示的时间'

,FTIMEUNIT varchar(20) not null  comment '时间单位'

,primary key (FID)

) comment = 'ad数据同步数据库配置表'


--查询--

select FID as "fid",FMasterID as "fmasterid",FADSYNCHROGAZERDBURL as "fadsynchrogazerdburl",FADSYNCHROGAZERDBNAME as "fadsynchrogazerdbname",FADSYNCHROGAZERDBPASSWORD as "fadsynchrogazerdbpassword",FADSYNCHROGAZERDBACCOUNT as "fadsynchrogazerdbaccount",FADSYNCHRONIZATIONTIME as "fadsynchronizationtime",FTEMPTIME as "ftemptime",FTIMEUNIT as "ftimeunit" from T_PLM_CFG_AD_CONFIG


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

select FID as "FID",FMasterID as "FMasterID",FADSYNCHROGAZERDBURL as "数据库地址",FADSYNCHROGAZERDBNAME as "数据库名称",FADSYNCHROGAZERDBPASSWORD as "数据库密码",FADSYNCHROGAZERDBACCOUNT as "数据库账号",FADSYNCHRONIZATIONTIME as "更新间隔时间",FTEMPTIME as "根据单位显示的时间",FTIMEUNIT as "时间单位" from T_PLM_CFG_AD_CONFIG


--INSERT脚本--

insert into T_PLM_CFG_AD_CONFIG(FID,FMasterID,FADSYNCHROGAZERDBURL,FADSYNCHROGAZERDBNAME,FADSYNCHROGAZERDBPASSWORD,FADSYNCHROGAZERDBACCOUNT,FADSYNCHRONIZATIONTIME,FTEMPTIME,FTIMEUNIT) values (?,?,?,?,?,?,?,?,?)


--UPDATE脚本--

update T_PLM_CFG_AD_CONFIG set FID=?,FMasterID=?,FADSYNCHROGAZERDBURL=?,FADSYNCHROGAZERDBNAME=?,FADSYNCHROGAZERDBPASSWORD=?,FADSYNCHROGAZERDBACCOUNT=?,FADSYNCHRONIZATIONTIME=?,FTEMPTIME=?,FTIMEUNIT=? where FID=?


--delete脚本--

delete from T_PLM_CFG_AD_CONFIG where FID=?


--给字段加备注--

alter table T_PLM_CFG_AD_CONFIG comment 'ad数据同步数据库配置表';

alter table T_PLM_CFG_AD_CONFIG modify column FID bigint not null  comment 'FID';

alter table T_PLM_CFG_AD_CONFIG modify column FMasterID bigint not null  comment 'FMasterID';

alter table T_PLM_CFG_AD_CONFIG modify column FADSYNCHROGAZERDBURL nvarchar(50) not null  comment '数据库地址';

alter table T_PLM_CFG_AD_CONFIG modify column FADSYNCHROGAZERDBNAME nvarchar(50) not null  comment '数据库名称';

alter table T_PLM_CFG_AD_CONFIG modify column FADSYNCHROGAZERDBPASSWORD nvarchar(50) not null  comment '数据库密码';

alter table T_PLM_CFG_AD_CONFIG modify column FADSYNCHROGAZERDBACCOUNT nvarchar(50) not null  comment '数据库账号';

alter table T_PLM_CFG_AD_CONFIG modify column FADSYNCHRONIZATIONTIME int not null  comment '更新间隔时间';

alter table T_PLM_CFG_AD_CONFIG modify column FTEMPTIME nvarchar(50) not null  comment '根据单位显示的时间';

alter table T_PLM_CFG_AD_CONFIG modify column FTIMEUNIT varchar(20) not null  comment '时间单位';

上传图片


图标赞 6
6人点赞
还没有人点赞，快来当第一个点赞的人吧！
图标打赏
0人打赏
还没有人打赏，快来当第一个打赏的人吧！

推荐阅读

金蝶云社区PLM模块关联内容（二）

PLM模块关联内容（二）

    文章

    139

出纳模块和应收应付模块关联

环境：3.0 补丁打至上周补丁； 问题描述： 3.0版本为什么把出纳管理和应收应付强制关联了，现在应收应付不启用，出纳管理收付款单据都无法使用了，这个要怎么处理 …

    文章

    1,751

PLM项目增加页签，页签内容为单据类型

PLM 项目 增加页签，页签内容为单据类型 新增页签和面板 [图片] （图一） 新增一个动态表单，里面放一个单据体，可参考项目采购列表，之后会用代码把这个动态表 …

    文章

    703