cyf
99 lines
3.8 KiB
Plaintext
99 lines
3.8 KiB
Plaintext
alter table p_systempopupmenu add visible1 int default(0)
|
|
alter table p_systempopupmenu add visible2 int default(0)
|
|
|
|
alter table p_systembillflow add stepBackText varchar(20)
|
|
go
|
|
alter table p_systembillflow add stepApplyContent varchar(50)
|
|
go
|
|
alter table p_systembillflow add stepBackContent varchar(50)
|
|
go
|
|
update p_systembillflow set stepBackText='返退',stepApplyContent='同意',stepBackContent='不同意'
|
|
go
|
|
alter table p_systemdlltabflow add stepBackText varchar(20)
|
|
go
|
|
alter table p_systemdlltabflow add stepApplyContent varchar(50)
|
|
go
|
|
alter table p_systemdlltabflow add stepBackContent varchar(50)
|
|
go
|
|
update p_systemdlltabflow set stepBackText='返退',stepApplyContent='同意',stepBackContent='不同意'
|
|
go
|
|
alter table p_systemDlltab add printSQL varchar(2000)
|
|
alter table p_systemDlltab add printSQL1 varchar(2000)
|
|
alter table p_systemDlltab add printSQL2 varchar(2000)
|
|
alter table p_systemDlltab add printFile varchar(200)
|
|
alter table p_systemDlltab add printType int
|
|
|
|
--增加分组功能
|
|
alter table p_systemwordbooktab add GroupId int default(0) not null
|
|
|
|
CREATE TABLE [dbo].[p_systemAddGroup](
|
|
[id] [int] IDENTITY(1,1) NOT NULL,
|
|
[GroupName] [nvarchar](50) NULL,
|
|
[controlLeft] [int] NOT NULL,
|
|
[controlTop] [int] NOT NULL,
|
|
[controlHeight] [int] NOT NULL,
|
|
[controlWidth] [int] NOT NULL,
|
|
[formKey] [uniqueidentifier] NOT NULL,
|
|
[controlType] [smallint] NOT NULL,
|
|
CONSTRAINT [PK_p_systemAddGroup] PRIMARY KEY CLUSTERED
|
|
(
|
|
[id] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'左边距' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'p_systemAddGroup', @level2type=N'COLUMN',@level2name=N'controlLeft'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上边距' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'p_systemAddGroup', @level2type=N'COLUMN',@level2name=N'controlTop'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'控件高度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'p_systemAddGroup', @level2type=N'COLUMN',@level2name=N'controlHeight'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'控件宽度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'p_systemAddGroup', @level2type=N'COLUMN',@level2name=N'controlWidth'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'关联模块' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'p_systemAddGroup', @level2type=N'COLUMN',@level2name=N'formKey'
|
|
GO
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'控件类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'p_systemAddGroup', @level2type=N'COLUMN',@level2name=N'controlType'
|
|
GO
|
|
|
|
alter table dbo.p_systemControlLocation add GroupId int default(0) not null
|
|
GO
|
|
|
|
|
|
CREATE TABLE [dbo].[p_systemdlltabChart](
|
|
[id] [int] IDENTITY(1,1) NOT NULL,
|
|
[tab] [varchar](20) NULL,
|
|
[tabKey] [uniqueidentifier] NULL,
|
|
[chartType] [int] NULL,
|
|
[chartTitle] [varchar](50) NULL,
|
|
[chartColor] [varchar](20) NULL,
|
|
[chartColorDf] [varchar](20) NULL,
|
|
[chart3D] [int] NULL,
|
|
[gridLineVisible] [int] NULL,
|
|
[XLabelField] [varchar](30) NULL,
|
|
[YValueField] [varchar](30) NULL,
|
|
[XAxisTitle] [varchar](20) NULL,
|
|
[YAxisTitle] [varchar](20) NULL,
|
|
[YAxisShared] [int] NULL,
|
|
[markVisible] [int] NULL,
|
|
[legendVisible] [int] NULL,
|
|
[isVisible] [int] NULL,
|
|
[orderId] [int] NULL,
|
|
CONSTRAINT [PK_p_systemdlltabChart] PRIMARY KEY CLUSTERED
|
|
(
|
|
[id] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
|
|
GO
|
|
|
|
SET ANSI_PADDING OFF
|
|
GO
|
|
|
|
|