ASP.NETCMS站群内容管理系统（可视化模版编辑）源码

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CNVP_Admin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CNVP_Admin] ; CREATE TABLE [dbo].[CNVP_Admin] ( [AdminID] [int] IDENTITY (1, 1) NOT NULL , [AdminName] [varchar] (50) NULL , [AdminPass] [varchar] (50) NULL , [AdminEMail] [varchar] (100) NULL , [AdminTrueName] [varchar] (50) NULL , [AdminMobile] [varchar] (50) NULL , [AdminTelPhone] [varchar] (50) NULL , [IDCard] [varchar] (50) NULL , [TokenID] [varchar] (50) NULL , [PostTime] [datetime] NULL , [ISLock] [tinyint] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[CNVP_Admin] WITH NOCHECK ADD CONSTRAINT [PK_CNVP_Admin] PRIMARY KEY CLUSTERED ( [AdminID] ) ON [PRIMARY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CNVP_Group]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CNVP_Group] ; CREATE TABLE [dbo].[CNVP_Group] ( [GroupID] [int] IDENTITY (1, 1) NOT NULL , [GroupName] [varchar] (50) NULL , [GroupDes] [varchar] (200) NULL , [ISDefault] [tinyint] NULL , [PostTime] [datetime] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[CNVP_Group] WITH NOCHECK ADD CONSTRAINT [PK_CNVP_Group] PRIMARY KEY CLUSTERED ( [GroupID] ) ON [PRIMARY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CNVP_AdminGroup]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CNVP_AdminGroup] ; CREATE TABLE [dbo].[CNVP_AdminGroup] ( [AdminID] [int] NULL , [GroupID] [int] NULL ) ON [PRIMARY] GO INSERT INTO [dbo].[CNVP_AdminGroup] (AdminID,GroupID) Values (1,1) ; if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CNVP_Department]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CNVP_Department] ; CREATE TABLE [dbo].[CNVP_Department] ( [DepID] [int] IDENTITY (1, 1) NOT NULL , [DepName] [varchar] (50) NULL , [DepDes] [varchar] (500) NULL , [PostTime] [datetime] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[CNVP_Department] WITH NOCHECK ADD CONSTRAINT [PK_CNVP_Department] PRIMARY KEY CLUSTERED ( [DepID] ) ON [PRIMARY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CNVP_AdminDep]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CNVP_AdminDep] ; CREATE TABLE [dbo].[CNVP_AdminDep] ( [AdminID] [int] NULL , [DepID] [int] NULL , [ReadAll] [tinyint] NULL ) ON [PRIMARY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CNVP_Permissions]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CNVP_Permissions] ; CREATE TABLE [dbo].[CNVP_Permissions] ( [GroupID] [int] NULL , [ColumnID] [int] NULL, [AdminID] [int] NULL, [PlugInID] [varchar] (20) NULL, [OperateCode] [varchar] (20) NULL, [ISColumnAdmin] [tinyint] NULL ) ON [PRIMARY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CNVP_Route]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CNVP_Route] ; CREATE TABLE [dbo].[CNVP_Route] ( [RouteID] [int] IDENTITY (1, 1) NOT NULL , [RouteName] [varchar] (50) NULL , [RouteValue] [varchar] (50) NULL , [RouteMenuUrl] [varchar] (100) NULL , [RouteMainUrl] [varchar] (100) NULL , [RouteFlag] [varchar] (10) NULL , [ParentID] [int] NULL , [OrderID] [int] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[CNVP_Route] WITH NOCHECK ADD CONSTRAINT [PK_CNVP_Route] PRIMARY KEY CLUSTERED ( [RouteID] ) ON [PRIMARY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CNVP_Module]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CNVP_Module] ; CREATE TABLE [dbo].[CNVP_Module] ( [ModuleID] [int] IDENTITY (1, 1) NOT NULL , [ModuleKey] [varchar] (50) NULL , [ModuleName] [varchar] (50) NULL , [ModuleVersion] [varchar] (10) NULL , [PostTime] [datetime] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[CNVP_Module] WITH NOCHECK ADD CONSTRAINT [PK_CNVP_Module] PRIMARY KEY CLUSTERED ( [ModuleID] ) ON [PRIMARY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CNVP_Template]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CNVP_Template] ; CREATE TABLE [dbo].[CNVP_Template] ( [TemplateID] [int] IDENTITY (1, 1) NOT NULL , [ColumnID] [int] NULL , [TemplateType] [tinyint] NULL , [ProjectName] [varchar] (50) NULL , [TemplateUrl] [varchar] (100) NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[CNVP_Template] WITH NOCHECK ADD CONSTRAINT [PK_CNVP_Template] PRIMARY KEY CLUSTERED ( [TemplateID] ) ON [PRIMARY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CNVP_FileSources]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CNVP_FileSources] ; CREATE TABLE [dbo].[CNVP_FileSources] ( [FileID] [int] IDENTITY (1, 1) NOT NULL , [ParentID] [int] NULL , [ProjectName] [varchar] (50) NULL , [FullPath] [varchar] (100) NULL , [FileName] [varchar] (50) NULL , [FileType] [varchar] (10) NULL , [FileExtension] [varchar] (50) NULL , [PostTime] [datetime] NULL , [UpdateTime] [datetime] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[CNVP_FileSources] WITH NOCHECK ADD CONSTRAINT [PK_CNVP_FileSources] PRIMARY KEY CLUSTERED ( [FileID] ) ON [PRIMARY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CNVP_UnitStyle]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CNVP_UnitStyle] ; CREATE TABLE [dbo].[CNVP_UnitStyle] ( [UnitID] [int] IDENTITY (1, 1) NOT NULL , [StyleID] [int] NULL , [ProjectName] [varchar] (50) NULL , [UnitName] [varchar] (50) NULL , [UnitHTML] [text] NULL, [UnitStyleBak] [text] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[CNVP_UnitStyle] WITH NOCHECK ADD CONSTRAINT [PK_CNVP_UnitStyle] PRIMARY KEY CLUSTERED ( [UnitID] ) ON [PRIMARY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CNVP_Column]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CNVP_Column] ; CREATE TABLE [dbo].[CNVP_Column] ( [ColumnID] [int] IDENTITY (1, 1) NOT NULL , [ColumnNumber] [varchar] (10) NULL , [ColumnType] [tinyint] NULL , [ColumnExpire] [tinyint] NULL , [ColumnName] [varchar] (50) NULL , [ColumnImages] [varchar] (300) NULL , [ColumnUrl] [varchar] (100) NULL , [ColumnRemark] [varchar] (4000) NULL , [ColumnKeyword] [varchar] (1000) NULL , [ColumnDescription] [varchar] (1000) NULL , [ISBlank] [tinyint] NULL , [ISLock] [tinyint] NULL , [ISAuditing] [tinyint] NULL , [ISMember] [tinyint] NULL , [ISReview] [tinyint] NULL , [ISShow] [tinyint] NULL , [ISRemote] [tinyint] NULL , [ISPublic] [tinyint] NULL , [ISMobile] [tinyint] NULL , [ISInShow] [tinyint] NULL , [OrderID] [int] NULL , [ParentID] [int] NULL , [PostTime] [datetime] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[CNVP_Column] WITH NOCHECK ADD CONSTRAINT [PK_CNVP_Column] PRIMARY KEY CLUSTERED ( [ColumnID] ) ON [PRIMARY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CNVP_NewsInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CNVP_NewsInfo] ; CREATE TABLE [dbo].[CNVP_NewsInfo] ( [NewsID] [int] IDENTITY (1, 1) NOT NULL , [ColumnID] [int] NULL , [AuthorID] [int] NULL , [NewsTitle] [varchar] (200) NULL , [SubNewsTitle] [varchar] (200) NULL , [NewsBrief] [varchar] (4000) NULL , [NewsEditor] [varchar] (100) NULL , [FontColor] [varchar] (50) NULL , [TitleBold] [int] NULL , [TitleItalic] [int] NULL , [NewsOutLink] [varchar] (100) NULL , [NewsImages] [varchar] (100) NULL , [NewsFocusImages] [varchar] (100) NULL , [NewsFiles] [varchar] (100) NULL , [KeyWord] [varchar] (500) NULL , [Author] [varchar] (50) NULL , [Source] [varchar] (50) NULL , [Clicks] [int] NULL , [