存储过程2

USE [GTACMSSZZXZT2]
GO
/****** Object: StoredProcedure [dbo].[SP_InitWebSite] Script Date: 08/20/2018 16:05:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[SP_InitWebSite] 
@SiteId INT --站点ID
AS
BEGIN

DECLARE @NewColumnId INT;
DECLARE @NewModelId INT;
BEGIN
INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'首页', NULL, 10,0, @SiteId, 1, 1, 0, GETDATE(),0);
SET @NewColumnId = @@IDENTITY;

INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'网站logo', @NewColumnId, 110, 0, @SiteId, 1, 1, 0, GETDATE(),1);
SET @NewModelId = @@IDENTITY;
INSERT [WebAreas] ([Name], [ShowName],[FrontSettingId],[PageSize],[HasColumnTwo],[Type],[OrderIndex], [ColumnId], [WebSiteId], [IsDeleted], [CreateDate]) VALUES (N'网站logo', 'logo', 0,1,0,0,10,@NewModelId, @SiteId, 0, GETDATE());
INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'Banner轮播图', @NewColumnId, 120, 0, @SiteId, 4, 4, 0, GETDATE(),1);
SET @NewModelId = @@IDENTITY;


INSERT [WebAreas] ([Name], [ShowName],[FrontSettingId],[PageSize],[HasColumnTwo],[Type],[OrderIndex], [ColumnId], [WebSiteId], [IsDeleted], [CreateDate]) VALUES (N'首页Banner图', '首页Banner图', 0,3,0,0,20,@NewModelId, @SiteId, 0, GETDATE());

INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'资源中心', @NewColumnId, 120, 0, @SiteId, 1, 1, 0, GETDATE(),1);
SET @NewModelId = @@IDENTITY;


INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'资源列表一', @NewModelId, 130, 0, @SiteId, 6, 6, 0, GETDATE(),0);
INSERT [WebAreas] ([Name], [ShowName],[FrontSettingId],[PageSize],[HasColumnTwo],[Type], [OrderIndex],[ColumnId], [WebSiteId], [IsDeleted], [CreateDate]) VALUES (N'资源中心', '资源中心',0,1,0,0,60, @NewModelId, @SiteId, 0, GETDATE());
INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'相关网站链接', @NewColumnId, 140, 0, @SiteId, 4, 4, 0, GETDATE(),1);
SET @NewModelId = @@IDENTITY;
INSERT [WebAreas] ([Name], [ShowName],[FrontSettingId],[PageSize],[HasColumnTwo],[Type], [OrderIndex],[ColumnId], [WebSiteId], [IsDeleted], [CreateDate]) VALUES (N'相关网站链接', '相关网站链接',0,40,0,0,70, @NewModelId, @SiteId, 0, GETDATE());
INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'教学互动平台图片', @NewColumnId, 150, 0, @SiteId, 4, 4, 0, GETDATE(),1);
SET @NewModelId = @@IDENTITY;


INSERT [WebAreas] ([Name], [ShowName],[FrontSettingId],[PageSize],[HasColumnTwo],[Type], [OrderIndex],[ColumnId], [WebSiteId], [IsDeleted], [CreateDate]) VALUES (N'教学互动平台图片', '教学互动平台图片',0,1,0,0,90, @NewModelId, @SiteId, 0, GETDATE());

INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'资源中心图片', @NewColumnId, 160, 0, @SiteId, 4, 4, 0, GETDATE(),1);
SET @NewModelId = @@IDENTITY;
INSERT [WebAreas] ([Name], [ShowName],[FrontSettingId],[PageSize],[HasColumnTwo],[Type], [OrderIndex],[ColumnId], [WebSiteId], [IsDeleted], [CreateDate]) VALUES (N'资源中心图片', '资源中心图片',0,1,0,0,900, @NewModelId, @SiteId, 0, GETDATE());

INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'专业概况', NULL, 100,0, @SiteId, 1, 1, 0, GETDATE(),0);
SET @NewColumnId = @@IDENTITY;
INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'专业简介', @NewColumnId, 170, 0, @SiteId, 1, 1, 0, GETDATE(),1);
SET @NewModelId = @@IDENTITY;
INSERT [WebAreas] ([Name], [ShowName],[FrontSettingId],[PageSize],[HasColumnTwo],[Type], [OrderIndex],[ColumnId], [WebSiteId], [IsDeleted], [CreateDate]) VALUES (N'专业简介', '专业简介',0,1,0,0,30, @NewModelId, @SiteId, 0, GETDATE());

INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'专业动态', @NewColumnId, 180, 0, @SiteId, 1, 1, 0, GETDATE(),1);
SET @NewModelId = @@IDENTITY;
INSERT [WebAreas] ([Name], [ShowName],[EnglishName],[FrontSettingId],[PageSize],[HasColumnTwo],[Type], [OrderIndex],[ColumnId], [WebSiteId], [IsDeleted], [CreateDate]) VALUES (N'专业动态', '专业动态','News',0,8,0,0,40, @NewModelId, @SiteId, 0, GETDATE());

INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'课程设置', NULL, 101,0, @SiteId, 1, 1, 0, GETDATE(),0);
SET @NewColumnId = @@IDENTITY;
INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'课程介绍', @NewColumnId, 190, 0, @SiteId, 1, 1, 0, GETDATE(),0);

INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'教学团队', NULL, 102,0, @SiteId, 1, 1, 0, GETDATE(),0);
SET @NewColumnId = @@IDENTITY;
INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'师资队伍', @NewColumnId, 200, 0, @SiteId, 5, 5, 0, GETDATE(),0);

INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'教学环境', NULL, 103,0, @SiteId, 1, 1, 0, GETDATE(),0);
SET @NewColumnId = @@IDENTITY;
INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'校内实训室', @NewColumnId, 210, 0, @SiteId, 1, 1, 0, GETDATE(),0);
INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'校内实训基地', @NewColumnId, 220, 0, @SiteId, 1, 1, 0, GETDATE(),0);
INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'教学成果', NULL, 104,0, @SiteId, 1, 1, 0, GETDATE(),0);
SET @NewColumnId = @@IDENTITY;
INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'学生风采展示', @NewColumnId, 230, 0, @SiteId, 4, 4, 0, GETDATE(),1);
SET @NewModelId = @@IDENTITY;
INSERT [WebAreas] ([Name], [ShowName],[EnglishName],[FrontSettingId],[PageSize],[HasColumnTwo],[Type], [OrderIndex],[ColumnId], [WebSiteId], [IsDeleted], [CreateDate]) VALUES (N'学生风采展示', '教学成果','Teach',0,40,0,0,80, @NewModelId, @SiteId, 0, GETDATE());

INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'合作办学', NULL, 105,0, @SiteId, 1, 1, 0, GETDATE(),0);

INSERT [Columns] ([Name], [ParentId], [OrderIndex], [IsHidden], [WebSiteId], [Type], [DetailType], [IsDeleted], [CreateDate],[IsIndexShow]) VALUES (N'专业论坛', NULL, 106,0, @SiteId, 7, 1, 0, GETDATE(),1);
SET @NewModelId = @@IDENTITY;
INSERT [WebAreas] ([Name], [ShowName],[EnglishName],[FrontSettingId],[PageSize],[HasColumnTwo],[Type], [OrderIndex],[ColumnId], [WebSiteId], [IsDeleted], [CreateDate]) VALUES (N'教学互动平台', '教学互动平台','Teach',0,1,0,0,50, @NewModelId, @SiteId, 0, GETDATE());

END
END