CTRL控件库-ALL

--建表脚本--

create table t_Ctrl_CtrlAttrDetail(

FAttrDetailID nvarchar(150) not null  comment '属性'

,FEntryID nvarchar(500) default ' '  comment '控件描述id'

,FATTRID nvarchar(150) default ' '  comment 'FATTRID'

,FATTRSEQ int default 0  comment '次序'

,FATTRNAME nvarchar(1000) default ' '  comment '属性名称'

,FATTRTYPE varchar(50) default '' ''  comment '类型'

,FATTRDEFALUTVALUE varchar(1500) default '' ''  comment '默认值'

,FATTRDES varchar(1500) default '' ''  comment '属性描述'

,primary key (FAttrDetailID)

) comment = '属性单据体'

--查询--

select FAttrDetailID as "fattrdetailid",FEntryID as "fentryid",FATTRID as "fattrid",FATTRSEQ as "fattrseq",FATTRNAME as "fattrname",FATTRTYPE as "fattrtype",FATTRDEFALUTVALUE as "fattrdefalutvalue",FATTRDES as "fattrdes" from t_Ctrl_CtrlAttrDetail

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

select FAttrDetailID as "属性",FEntryID as "控件描述id",FATTRID as "FATTRID",FATTRSEQ as "次序",FATTRNAME as "属性名称",FATTRTYPE as "类型",FATTRDEFALUTVALUE as "默认值",FATTRDES as "属性描述" from t_Ctrl_CtrlAttrDetail

--INSERT脚本--

insert into t_Ctrl_CtrlAttrDetail(FAttrDetailID,FEntryID,FATTRID,FATTRSEQ,FATTRNAME,FATTRTYPE,FATTRDEFALUTVALUE,FATTRDES) values (?,?,?,?,?,?,?,?)

--UPDATE脚本--

update t_Ctrl_CtrlAttrDetail set FAttrDetailID=?,FEntryID=?,FATTRID=?,FATTRSEQ=?,FATTRNAME=?,FATTRTYPE=?,FATTRDEFALUTVALUE=?,FATTRDES=? where FAttrDetailID=?

--delete脚本--

delete from t_Ctrl_CtrlAttrDetail where FAttrDetailID=?

--给字段加备注--

alter table t_Ctrl_CtrlAttrDetail comment '属性单据体';

alter table t_Ctrl_CtrlAttrDetail modify column FAttrDetailID nvarchar(150) not null  comment '属性';

alter table t_Ctrl_CtrlAttrDetail modify column FEntryID nvarchar(500) default ' '  comment '控件描述id';

alter table t_Ctrl_CtrlAttrDetail modify column FATTRID nvarchar(150) default ' '  comment 'FATTRID';

alter table t_Ctrl_CtrlAttrDetail modify column FATTRSEQ int default 0  comment '次序';

alter table t_Ctrl_CtrlAttrDetail modify column FATTRNAME nvarchar(1000) default ' '  comment '属性名称';

alter table t_Ctrl_CtrlAttrDetail modify column FATTRTYPE varchar(50) default '' ''  comment '类型';

alter table t_Ctrl_CtrlAttrDetail modify column FATTRDEFALUTVALUE varchar(1500) default '' ''  comment '默认值';

alter table t_Ctrl_CtrlAttrDetail modify column FATTRDES varchar(1500) default '' ''  comment '属性描述';

--建表脚本--

create table t_Ctrl_CtrlEvent(

FEventDetailID varchar(150) not null  comment '控件事件id'

,FEntryID varchar(150) default '' ''  comment '控件id'

,FEEVENTSEQ int default 0  comment '事件次序'

,FEVENTID varchar(150) default '' ''  comment '事件id'

,FEVENTNAME varchar(150) default '' ''  comment '事件名称'

,FEVENTARGS varchar(1500) default '' ''  comment '事件参数'

,FEVENTDES varchar(1500) default '' ''  comment '事件描述'

,primary key (FEventDetailID)

) comment = '控件事件'

--查询--

select FEventDetailID as "feventdetailid",FEntryID as "fentryid",FEEVENTSEQ as "feeventseq",FEVENTID as "feventid",FEVENTNAME as "feventname",FEVENTARGS as "feventargs",FEVENTDES as "feventdes" from t_Ctrl_CtrlEvent

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

select FEventDetailID as "控件事件id",FEntryID as "控件id",FEEVENTSEQ as "事件次序",FEVENTID as "事件id",FEVENTNAME as "事件名称",FEVENTARGS as "事件参数",FEVENTDES as "事件描述" from t_Ctrl_CtrlEvent

--INSERT脚本--

insert into t_Ctrl_CtrlEvent(FEventDetailID,FEntryID,FEEVENTSEQ,FEVENTID,FEVENTNAME,FEVENTARGS,FEVENTDES) values (?,?,?,?,?,?,?)

--UPDATE脚本--

update t_Ctrl_CtrlEvent set FEventDetailID=?,FEntryID=?,FEEVENTSEQ=?,FEVENTID=?,FEVENTNAME=?,FEVENTARGS=?,FEVENTDES=? where FEventDetailID=?

--delete脚本--

delete from t_Ctrl_CtrlEvent where FEventDetailID=?

--给字段加备注--

alter table t_Ctrl_CtrlEvent comment '控件事件';

alter table t_Ctrl_CtrlEvent modify column FEventDetailID varchar(150) not null  comment '控件事件id';

alter table t_Ctrl_CtrlEvent modify column FEntryID varchar(150) default '' ''  comment '控件id';

alter table t_Ctrl_CtrlEvent modify column FEEVENTSEQ int default 0  comment '事件次序';

alter table t_Ctrl_CtrlEvent modify column FEVENTID varchar(150) default '' ''  comment '事件id';

alter table t_Ctrl_CtrlEvent modify column FEVENTNAME varchar(150) default '' ''  comment '事件名称';

alter table t_Ctrl_CtrlEvent modify column FEVENTARGS varchar(1500) default '' ''  comment '事件参数';

alter table t_Ctrl_CtrlEvent modify column FEVENTDES varchar(1500) default '' ''  comment '事件描述';

--建表脚本--

create table t_Ctrl_CtrlFunDetail(

FFunDetailId varchar(150) not null  comment ' 控件方法id'

,FEntryID varchar(150) default '' ''  comment '控件id'

,FFUNSEQ int default 0  comment '次序'

,FFUNID varchar(200) default '' ''  comment '方法'

,FFUNNAME varchar(500) default '' ''  comment '方法名称'

,FFUNRETURNVALUE varchar(1500) default '' ''  comment '方法返回值'

,FFUNDEFAULTVALUE varchar(1500) default '' ''  comment '方法默认值'

,FFUNDES varchar(1500) default '' ''  comment '方法描述'

,primary key (FFunDetailId)

) comment = '控件方法'

--查询--

select FFunDetailId as "ffundetailid",FEntryID as "fentryid",FFUNSEQ as "ffunseq",FFUNID as "ffunid",FFUNNAME as "ffunname",FFUNRETURNVALUE as "ffunreturnvalue",FFUNDEFAULTVALUE as "ffundefaultvalue",FFUNDES as "ffundes" from t_Ctrl_CtrlFunDetail

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

select FFunDetailId as " 控件方法id",FEntryID as "控件id",FFUNSEQ as "次序",FFUNID as "方法",FFUNNAME as "方法名称",FFUNRETURNVALUE as "方法返回值",FFUNDEFAULTVALUE as "方法默认值",FFUNDES as "方法描述" from t_Ctrl_CtrlFunDetail

--INSERT脚本--

insert into t_Ctrl_CtrlFunDetail(FFunDetailId,FEntryID,FFUNSEQ,FFUNID,FFUNNAME,FFUNRETURNVALUE,FFUNDEFAULTVALUE,FFUNDES) values (?,?,?,?,?,?,?,?)

--UPDATE脚本--

update t_Ctrl_CtrlFunDetail set FFunDetailId=?,FEntryID=?,FFUNSEQ=?,FFUNID=?,FFUNNAME=?,FFUNRETURNVALUE=?,FFUNDEFAULTVALUE=?,FFUNDES=? where FFunDetailId=?

--delete脚本--

delete from t_Ctrl_CtrlFunDetail where FFunDetailId=?

--给字段加备注--

alter table t_Ctrl_CtrlFunDetail comment '控件方法';

alter table t_Ctrl_CtrlFunDetail modify column FFunDetailId varchar(150) not null  comment ' 控件方法id';

alter table t_Ctrl_CtrlFunDetail modify column FEntryID varchar(150) default '' ''  comment '控件id';

alter table t_Ctrl_CtrlFunDetail modify column FFUNSEQ int default 0  comment '次序';

alter table t_Ctrl_CtrlFunDetail modify column FFUNID varchar(200) default '' ''  comment '方法';

alter table t_Ctrl_CtrlFunDetail modify column FFUNNAME varchar(500) default '' ''  comment '方法名称';

alter table t_Ctrl_CtrlFunDetail modify column FFUNRETURNVALUE varchar(1500) default '' ''  comment '方法返回值';

alter table t_Ctrl_CtrlFunDetail modify column FFUNDEFAULTVALUE varchar(1500) default '' ''  comment '方法默认值';

alter table t_Ctrl_CtrlFunDetail modify column FFUNDES varchar(1500) default '' ''  comment '方法描述';

--建表脚本--

create table t_Ctrl_FunArgs(

FFunArgDetailID varchar(150) not null  comment '控件方法参数id'

,FFunDetailId varchar(150) default '' ''  comment '控件方id'

,FFUNARGSSEQ int default 0  comment '次序'

,FFUNARGID varchar(150) default '' ''  comment '参数'

,FFUNARGNAME varchar(500) default '' ''  comment '参数名称'

,FFUNARGTYPE varchar(50) default '' ''  comment '参数类型'

,FFUNARGDEFVAL varchar(1500) default '' ''  comment '参数默认值'

,FFUNARGDES varchar(1500) default '' ''  comment '方法参数描述'

,primary key (FFunArgDetailID)

) comment = '控件方法参数'

--查询--

select FFunArgDetailID as "ffunargdetailid",FFunDetailId as "ffundetailid",FFUNARGSSEQ as "ffunargsseq",FFUNARGID as "ffunargid",FFUNARGNAME as "ffunargname",FFUNARGTYPE as "ffunargtype",FFUNARGDEFVAL as "ffunargdefval",FFUNARGDES as "ffunargdes" from t_Ctrl_FunArgs

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

select FFunArgDetailID as "控件方法参数id",FFunDetailId as "控件方id",FFUNARGSSEQ as "次序",FFUNARGID as "参数",FFUNARGNAME as "参数名称",FFUNARGTYPE as "参数类型",FFUNARGDEFVAL as "参数默认值",FFUNARGDES as "方法参数描述" from t_Ctrl_FunArgs

--INSERT脚本--

insert into t_Ctrl_FunArgs(FFunArgDetailID,FFunDetailId,FFUNARGSSEQ,FFUNARGID,FFUNARGNAME,FFUNARGTYPE,FFUNARGDEFVAL,FFUNARGDES) values (?,?,?,?,?,?,?,?)

--UPDATE脚本--

update t_Ctrl_FunArgs set FFunArgDetailID=?,FFunDetailId=?,FFUNARGSSEQ=?,FFUNARGID=?,FFUNARGNAME=?,FFUNARGTYPE=?,FFUNARGDEFVAL=?,FFUNARGDES=? where FFunArgDetailID=?

--delete脚本--

delete from t_Ctrl_FunArgs where FFunArgDetailID=?

--给字段加备注--

alter table t_Ctrl_FunArgs comment '控件方法参数';

alter table t_Ctrl_FunArgs modify column FFunArgDetailID varchar(150) not null  comment '控件方法参数id';

alter table t_Ctrl_FunArgs modify column FFunDetailId varchar(150) default '' ''  comment '控件方id';

alter table t_Ctrl_FunArgs modify column FFUNARGSSEQ int default 0  comment '次序';

alter table t_Ctrl_FunArgs modify column FFUNARGID varchar(150) default '' ''  comment '参数';

alter table t_Ctrl_FunArgs modify column FFUNARGNAME varchar(500) default '' ''  comment '参数名称';

alter table t_Ctrl_FunArgs modify column FFUNARGTYPE varchar(50) default '' ''  comment '参数类型';

alter table t_Ctrl_FunArgs modify column FFUNARGDEFVAL varchar(1500) default '' ''  comment '参数默认值';

alter table t_Ctrl_FunArgs modify column FFUNARGDES varchar(1500) default '' ''  comment '方法参数描述';

--建表脚本--

create table t_Ctrl_CtrlDes(

FEntryID varchar(50) not null  comment 'FEntryID'

,FID varchar(50) default '' ''  comment 'FID'

,FCtrlName varchar(200) default '' ''  comment 'FCtrlName'

,FCtrlDes varchar(2000) default '' ''  comment 'FCtrlDes'

,FCtrlSeq int default 0  comment 'FCtrlSeq'

,FCtrlPrxy varchar(200) default '' ''  comment 'FCtrlPrxy'

,primary key (FEntryID)

) comment = 't_Ctrl_CtrlDes'

--查询--

select FEntryID as "fentryid",FID as "fid",FCtrlName as "fctrlname",FCtrlDes as "fctrldes",FCtrlSeq as "fctrlseq",FCtrlPrxy as "fctrlprxy" from t_Ctrl_CtrlDes

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

select FEntryID as "FEntryID",FID as "FID",FCtrlName as "FCtrlName",FCtrlDes as "FCtrlDes",FCtrlSeq as "FCtrlSeq",FCtrlPrxy as "FCtrlPrxy" from t_Ctrl_CtrlDes

--INSERT脚本--

insert into t_Ctrl_CtrlDes(FEntryID,FID,FCtrlName,FCtrlDes,FCtrlSeq,FCtrlPrxy) values (?,?,?,?,?,?)

--UPDATE脚本--

update t_Ctrl_CtrlDes set FEntryID=?,FID=?,FCtrlName=?,FCtrlDes=?,FCtrlSeq=?,FCtrlPrxy=? where FEntryID=?

--delete脚本--

delete from t_Ctrl_CtrlDes where FEntryID=?

--给字段加备注--

alter table t_Ctrl_CtrlDes comment 't_Ctrl_CtrlDes';

alter table t_Ctrl_CtrlDes modify column FEntryID varchar(50) not null  comment 'FEntryID';

alter table t_Ctrl_CtrlDes modify column FID varchar(50) default '' ''  comment 'FID';

alter table t_Ctrl_CtrlDes modify column FCtrlName varchar(200) default '' ''  comment 'FCtrlName';

alter table t_Ctrl_CtrlDes modify column FCtrlDes varchar(2000) default '' ''  comment 'FCtrlDes';

alter table t_Ctrl_CtrlDes modify column FCtrlSeq int default 0  comment 'FCtrlSeq';

alter table t_Ctrl_CtrlDes modify column FCtrlPrxy varchar(200) default '' ''  comment 'FCtrlPrxy';

--建表脚本--

create table t_Ctrl_CtrlType(

FID varchar(50) not null  comment 'FID'

,FNUMBER varchar(50) default '' ''  comment 'FNUMBER'

,FDOCUMENTSTATUS char(1) default ''C''  comment 'FDOCUMENTSTATUS'

,FFORBIDSTATUS char(1) default ''A''  comment 'FFORBIDSTATUS'

,FSeq int default 0  comment 'FSeq'

,primary key (FID)

) comment = '控件类型表'

--查询--

select FID as "fid",FNUMBER as "fnumber",FDOCUMENTSTATUS as "fdocumentstatus",FFORBIDSTATUS as "fforbidstatus",FSeq as "fseq" from t_Ctrl_CtrlType

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

select FID as "FID",FNUMBER as "FNUMBER",FDOCUMENTSTATUS as "FDOCUMENTSTATUS",FFORBIDSTATUS as "FFORBIDSTATUS",FSeq as "FSeq" from t_Ctrl_CtrlType

--INSERT脚本--

insert into t_Ctrl_CtrlType(FID,FNUMBER,FDOCUMENTSTATUS,FFORBIDSTATUS,FSeq) values (?,?,?,?,?)

--UPDATE脚本--

update t_Ctrl_CtrlType set FID=?,FNUMBER=?,FDOCUMENTSTATUS=?,FFORBIDSTATUS=?,FSeq=? where FID=?

--delete脚本--

delete from t_Ctrl_CtrlType where FID=?

--给字段加备注--

alter table t_Ctrl_CtrlType comment '控件类型表';

alter table t_Ctrl_CtrlType modify column FID varchar(50) not null  comment 'FID';

alter table t_Ctrl_CtrlType modify column FNUMBER varchar(50) default '' ''  comment 'FNUMBER';

alter table t_Ctrl_CtrlType modify column FDOCUMENTSTATUS char(1) default ''C''  comment 'FDOCUMENTSTATUS';

alter table t_Ctrl_CtrlType modify column FFORBIDSTATUS char(1) default ''A''  comment 'FFORBIDSTATUS';

alter table t_Ctrl_CtrlType modify column FSeq int default 0  comment 'FSeq';

--建表脚本--

create table t_Ctrl_CtrlType_L(

FPKID varchar(40) not null  comment 'FPKID'

,FID varchar(50) default '' ''  comment 'FID'

,FLocaleID int default 0  comment 'FLocaleID'

,FNAME varchar(2000) default '' ''  comment 'FNAME'

,primary key (FPKID)

) comment = '控件类型多语言表'

--查询--

select FPKID as "fpkid",FID as "fid",FLocaleID as "flocaleid",FNAME as "fname" from t_Ctrl_CtrlType_L

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

select FPKID as "FPKID",FID as "FID",FLocaleID as "FLocaleID",FNAME as "FNAME" from t_Ctrl_CtrlType_L

--INSERT脚本--

insert into t_Ctrl_CtrlType_L(FPKID,FID,FLocaleID,FNAME) values (?,?,?,?)

--UPDATE脚本--

update t_Ctrl_CtrlType_L set FPKID=?,FID=?,FLocaleID=?,FNAME=? where FPKID=?

--delete脚本--

delete from t_Ctrl_CtrlType_L where FPKID=?

--给字段加备注--

alter table t_Ctrl_CtrlType_L comment '控件类型多语言表';

alter table t_Ctrl_CtrlType_L modify column FPKID varchar(40) not null  comment 'FPKID';

alter table t_Ctrl_CtrlType_L modify column FID varchar(50) default '' ''  comment 'FID';

alter table t_Ctrl_CtrlType_L modify column FLocaleID int default 0  comment 'FLocaleID';

alter table t_Ctrl_CtrlType_L modify column FNAME varchar(2000) default '' ''  comment 'FNAME';