Datawindow Web ActiveX 应用实例

if exists (select 1 from sysobjects where id = object_id('dbo.Title') and type = 'U') drop table dbo.Title go /*==============================================================*/ /* Table: Title */ /*==============================================================*/ create table dbo.Title ( TitleID int identity, TitleName nvarchar(32) not null, Description nvarchar(1024) null, constraint PK_TITLE primary key (TitleID) ) go execute sp_addextendedproperty 'MS_Description', '职务', 'user', 'dbo', 'table', 'Title' go execute sp_addextendedproperty 'MS_Description', '职务编号', 'user', 'dbo', 'table', 'Title', 'column', 'TitleID' go execute sp_addextendedproperty 'MS_Description', '名称', 'user', 'dbo', 'table', 'Title', 'column', 'TitleName' go execute sp_addextendedproperty 'MS_Description', '描述', 'user', 'dbo', 'table', 'Title', 'column', 'Description' go if exists (select 1 from sysobjects where id = object_id('dbo.DataWindowConfig') and type = 'U') drop table dbo.DataWindowConfig go /*==============================================================*/ /* Table: DataWindowConfig */ /*==============================================================*/ create table dbo.DataWindowConfig ( DataWindowConfigID int identity, DataWindowObject varchar(128) null, FieldName varchar(128) null, ConfigRule int null, ConfigValue varchar(128) null, Remark nvarchar(1024) null, constraint pk_DataWindowConfig primary key (DataWindowConfigID) ) go execute sp_addextendedproperty 'MS_Description', '数据窗口配置', 'user', 'dbo', 'table', 'DataWindowConfig' go execute sp_addextendedproperty 'MS_Description', '数据窗口配置编号', 'user', 'dbo', 'table', 'DataWindowConfig', 'column', 'DataWindowConfigID' go execute sp_addextendedproperty 'MS_Description', '数据窗口对象', 'user', 'dbo', 'table', 'DataWindowConfig', 'column', 'DataWindowObject' go execute sp_addextendedproperty 'MS_Description', '字段名', 'user', 'dbo', 'table', 'DataWindowConfig', 'column', 'FieldName' go execute sp_addextendedproperty 'MS_Description', '配置类型为0（其它配置）时：1=默认焦点； 配置类型为1（数据校验）时：1=必填校验、2=范围校验、3=重复校验、4=唯一校验、5=必空校验； 配置类型为2（数据生成）时：1=初始默认值、2=变化默认值、3=自动编码； 配置类型为3（数据复制）时：1=新增复制、2=变化同步、3=计算同步、4=子数据同步； 配置类型为4（数据联动）时：1=主动过滤、2=被动过滤； ', 'user', 'dbo', 'table', 'DataWindowConfig', 'column', 'ConfigRule' go execute sp_addextendedproperty 'MS_Description', '配置值', 'user', 'dbo', 'table', 'DataWindowConfig', 'column', 'ConfigValue' go execute sp_addextendedproperty 'MS_Description', '备注', 'user', 'dbo', 'table', 'DataWindowConfig', 'column', 'Remark' go if exists (select 1 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F') where r.fkeyid = object_id('dbo.OrgMember') and o.name = 'FK_ORGMEMBE_FK_ORGMEM_STAFF') alter table dbo.OrgMember drop constraint FK_ORGMEMBE_FK_ORGMEM_STAFF go if exists (select 1 from sysobjects where id = object_id('dbo.Staff') and type = 'U') drop table dbo.Staff go if exists (select 1 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F') where r.fkeyid = object_id('dbo.OrgMember') and o.name = 'FK_ORGMEMBE_FK_ORGMEM_STAFF') alter table dbo.OrgMember drop constraint FK_ORGMEMBE_FK_ORGMEM_STAFF go if exists (select 1 from sysobjects where id = object_id('dbo.Staff') and type = 'U') drop table dbo.Staff go /*==============================================================*/ /* Table: Staff */ /*==============================================================*/ create table dbo.Staff ( StaffID int identity, StaffType tinyint null default 3, UserName nvarchar(32) null, DomainUserName nvarchar(64) null, Password varchar(128) null default 'B59C67BF196A4758191E42F76670CEBA', StaffName nvarchar(32) null, StaffJobNum varchar(32) null, StaffGender tinyint null, IDCardNo varchar(32) null, Description nvarchar(1024) null, Email varchar(32) null, Mobile varchar(32) null, Address nvarchar(128) null, ContactWay varchar(128) null, TitleID int null, IsDisabled int null default 0, constraint PK_STAFF primary key (StaffID) on "PRIMARY" ) on "PRIMARY" go execute sp_addextendedproperty 'MS_Description', '人员', 'user', 'dbo', 'table', 'Staff' go execute sp_addextendedproperty 'MS_Description', '职务编号', 'user', 'dbo', 'table', 'Staff', 'column', 'TitleID' go execute sp_addextendedproperty 'MS_Description', '人员编号', 'user', 'dbo', 'table', 'Staff', 'column', 'StaffID' go execute sp_addextendedproperty 'MS_Description', '1：用户；2：职员；3：既是用户也是职员', 'user', 'dbo', 'table', 'Staff', 'column', 'StaffType' go execute sp_addextendedproperty 'MS_Description', '系统用户名', 'user', 'dbo', 'table', 'Staff', 'column', 'UserName' go execute sp_addextendedproperty 'MS_Description', '域用户名', 'user', 'dbo', 'table', 'Staff', 'column', 'DomainUserName' go execute sp_addextendedproperty 'MS_Description', '系统密码', 'user', 'dbo', 'table', 'Staff', 'column', 'Password' go execute sp_addextendedproperty 'MS_Description', '姓名', 'user', 'dbo', 'table', 'Staff', 'column', 'StaffName' go execute sp_addextendedproperty 'MS_Description', '工号', 'user', 'dbo', 'table', 'Staff', 'column', 'StaffJobNum' go execute sp_addextendedproperty 'MS_Description', '性别', 'user', 'dbo', 'table', 'Staff', 'column', 'StaffGender' go execute sp_addextendedproperty 'MS_Description', '身份证号码', 'user', 'dbo', 'table', 'Staff', 'column', 'IDCardNo' go execute sp_addextendedproperty 'MS_Description', '人员描述', 'user', 'dbo', 'table', 'Staff', 'column', 'Description' go execute sp_addextendedproperty 'MS_Description', '联系邮箱', 'user', 'dbo', 'table', 'Staff', 'column', 'Email' go execute sp_addextendedproperty 'MS_Description', '联系手机', 'user', 'dbo', 'table', 'Staff', 'column', 'Mobile' go execute sp_addextendedproperty 'MS_Description', '联系地址', 'user', 'dbo', 'table', 'Staff', 'column', 'Address' go execute sp_addextendedproperty 'MS_Description', '联系方式', 'user', 'dbo', 'table', 'Staff', 'column', 'ContactWay' go execute sp_addextendedproperty 'MS_Description', '0：启用；1：停用', 'user', 'dbo', 'table', 'Staff', 'column', 'IsDisabled' go