基于 .NET Core 6.0 的快速低成本网站搭建CMS设计源码

/***************************************** * LmgCMS * 系统配置 * 站点管理 * 新闻管理 * 友情链接 * 评论管理 * 菜单管理 * 菜单元素 * 组织机构 * 角色管理 * 用户管理 * 多对多关系集中映射 * 计划任务 * 系统日志 * 系统消息 ********************************************/ --系统配置 if exists (select * from sysobjects where id = OBJECT_ID('Setting') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE Setting CREATE TABLE [dbo].[Setting]( [ID] [NVARCHAR](200) NOT NULL default(newid()), [Name] [NVARCHAR](200) NULL, [Value] [NVARCHAR](200) NULL, [StoreId] [INT] NULL, [OrderBy] [INT] NULL, [AddTime] [DATETIME] NOT NULL default(getdate()), 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'Setting' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Setting', @level2type=N'COLUMN',@level2name=N'ID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Setting', @level2type=N'COLUMN',@level2name=N'Name' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Setting', @level2type=N'COLUMN',@level2name=N'Value' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'仓库' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Setting', @level2type=N'COLUMN',@level2name=N'StoreId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Setting', @level2type=N'COLUMN',@level2name=N'OrderBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'添加时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Setting', @level2type=N'COLUMN',@level2name=N'AddTime' GO --站点管理 if exists (select * from sysobjects where id = OBJECT_ID('Site') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [Site] CREATE TABLE [dbo].[Site]( [ID] [NVARCHAR](200) NOT NULL default(newid()), [Name] [NVARCHAR](200) NULL, [SiteUrl] [NVARCHAR](200) NULL, --网站域名 [SiteLogo] [NVARCHAR](200) NULL,--网站Logo [Summary] [NVARCHAR](200) NULL, --网站描述 [SiteTel] [NVARCHAR](200) NULL, --公司电话 [SiteFax] [NVARCHAR](200) NULL, --公司传真 [SiteEmail] [NVARCHAR](200) NULL,--公司邮箱 [QQ] [NVARCHAR](200) NULL, --公司客服QQ [WeiXin] [NVARCHAR](200) NULL, --微信公众号图片 [WeiBo] [NVARCHAR](200) NULL, --微博链接地址或者二维码 [SiteAddress] [NVARCHAR](200) NULL, --公司地址 [SiteCode] [NVARCHAR](200) NULL, --网站备案号其它等信息 [SeoTitle] [NVARCHAR](200) NULL, --网站SEO标题 [SeoKey] [NVARCHAR](200) NULL, --网站SEO关键字 [SeoDescribe] [NVARCHAR](200) NULL, --网站SEO描述 [SiteCopyright] [NVARCHAR](200) NULL, --网站版权等信息 [Open] [INT] NULL, --网站开启关闭状态 1开启 [CloseInfo] [NVARCHAR](200) NULL, --如果状态关闭，请输入关闭网站原因 [OrderBy] [INT] NULL, [AddTime] [DATETIME] NOT NULL default(getdate()), 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'Site' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'ID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'网站名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'Name' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'网站域名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'SiteUrl' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'网站描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'Summary' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'SiteTel' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司传真' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'SiteFax' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司邮箱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'SiteEmail' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'QQ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'QQ' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'微信' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'WeiXin' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'微博' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'WeiBo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'SiteAddress' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'网站备案号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'SiteCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'网站SEO标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'SeoTitle' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'网站SEO关键字' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'SeoKey' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'网站SEO描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'SeoDescribe' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'版权信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'SiteCopyright' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'关闭网站' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'Open' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'关闭原因' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'CloseInfo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Site', @level2type=N'COLUMN',@level2name=N'Ord