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=?,FFUNA