03.01.00.sqldataprovider

SharpNuke源代码

/************************************************************/
/*****              SqlDataProvider                     *****/
/*****                                                  *****/
/*****                                                  *****/
/***** Note: To manually execute this script you must   *****/
/*****       perform a search and replace operation     *****/
/*****       for {databaseOwner} and {objectQualifier}  *****/
/*****                                                  *****/
/************************************************************/

ALTER TABLE {databaseOwner}{objectQualifier}DesktopModules
	ADD [FolderName] nvarchar(128) NULL,
		[ModuleName] nvarchar(128) NULL,
		[SupportedFeatures] int NOT NULL CONSTRAINT DF_{objectQualifier}DesktopModules_SupportedFeatures DEFAULT 0
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [FolderName] = FriendlyName,
		[ModuleName] = FriendlyName
GO

ALTER TABLE {databaseOwner}{objectQualifier}DesktopModules
	ALTER COLUMN [FolderName] nvarchar(128) NOT NULL
GO

ALTER TABLE {databaseOwner}{objectQualifier}DesktopModules
	ALTER COLUMN [ModuleName] nvarchar(128) NOT NULL
GO

ALTER TABLE {databaseOwner}{objectQualifier}DesktopModules 
	ADD CONSTRAINT IX_{objectQualifier}DesktopModules_ModuleName UNIQUE NONCLUSTERED (ModuleName) ON [PRIMARY]
GO

ALTER TABLE {databaseOwner}{objectQualifier}DesktopModules
	DROP CONSTRAINT IX_{objectQualifier}DesktopModules
GO

CREATE NONCLUSTERED INDEX IX_{objectQualifier}DesktopModules_FriendlyName ON {databaseOwner}{objectQualifier}DesktopModules (FriendlyName) ON [PRIMARY]
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [ModuleName] = 'DNN_Announcements',
		[Version] = '03.01.00',
		[SupportedFeatures] = 3
	WHERE [ModuleName] = 'Announcements'
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [FolderName] = 'Forum',
		[ModuleName] = 'DNN_Blog',
		[SupportedFeatures] = 3
	WHERE [ModuleName] = 'Blog'
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [ModuleName] = 'DNN_Contacts',
		[Version] = '03.01.00',
		[SupportedFeatures] = 3
	WHERE [ModuleName] = 'Contacts'
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [ModuleName] = 'DNN_Discussions',
		[Version] = '03.01.00',
		[SupportedFeatures] = 2
	WHERE [ModuleName] = 'Discussions'
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [ModuleName] = 'DNN_Documents',
		[Version] = '03.01.00',
		[SupportedFeatures] = 3
	WHERE [ModuleName] = 'Documents'
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [ModuleName] = 'DNN_Events',
		[Version] = '03.01.00',
		[SupportedFeatures] = 3
	WHERE [ModuleName] = 'Events'
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [ModuleName] = 'DNN_FAQs',
		[Version] = '03.01.00',
		[SupportedFeatures] = 3
	WHERE [ModuleName] = 'FAQs'
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [ModuleName] = 'DNN_Feedback',
		[Version] = '03.01.00'
	WHERE [ModuleName] = 'Feedback'
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [ModuleName] = 'DNN_Forum',
		[SupportedFeatures] = 3
	WHERE [ModuleName] = 'Forum'
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [ModuleName] = 'DNN_Gallery'
	WHERE [ModuleName] = 'Gallery'
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [ModuleName] = 'DNN_IFrame',
		[Version] = '03.01.00'
	WHERE [ModuleName] = 'IFrame'
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [FolderName] = 'Images',
		[ModuleName] = 'DNN_Image',
		[Version] = '03.01.00',
		[SupportedFeatures] = 3
	WHERE [ModuleName] = 'Image'
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [ModuleName] = 'DNN_Links',
		[Version] = '03.01.00',
		[SupportedFeatures] = 3
	WHERE [ModuleName] = 'Links'
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [FolderName] = 'News',
		[ModuleName] = 'DNN_NewsFeeds',
		[Version] = '03.01.00'
	WHERE [ModuleName] = 'News Feeds (RSS)'
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [FolderName] = 'HTML',
		[ModuleName] = 'DNN_HTML',
		[Version] = '03.01.00',
		[SupportedFeatures] = 3
	WHERE [ModuleName] = 'Text/HTML'
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [ModuleName] = 'DNN_Survey',
		[Version] = '03.01.00'
	WHERE [ModuleName] = 'Survey'
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [FolderName] = 'UserDefinedTable',
		[ModuleName] = 'DNN_UserDefinedTable',
		[Version] = '03.01.00',
		[SupportedFeatures] = 2
	WHERE [ModuleName] = 'User Defined Table'
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [ModuleName] = 'DNN_UsersOnline',
		[Version] = '03.01.00'
	WHERE [ModuleName] = 'UsersOnline'
GO

UPDATE {databaseOwner}{objectQualifier}DesktopModules
	SET [FolderName] = 'XML',
		[ModuleName] = 'DNN_XML',
		[Version] = '03.01.00'
	WHERE [ModuleName] = 'XML/XSL'
GO

UPDATE {databaseOwner}{objectQualifier}ModuleControls
	SET [HelpUrl] = N'http://www.dotnetnuke.com/default.aspx?tabid=787'
FROM	{databaseOwner}{objectQualifier}DesktopModules 
	INNER JOIN {databaseOwner}{objectQualifier}ModuleDefinitions ON {databaseOwner}{objectQualifier}DesktopModules.DesktopModuleID = {databaseOwner}{objectQualifier}ModuleDefinitions.DesktopModuleID
	INNER JOIN {databaseOwner}{objectQualifier}ModuleControls ON {databaseOwner}{objectQualifier}ModuleDefinitions.ModuleDefID = {databaseOwner}{objectQualifier}ModuleControls.ModuleDefID
WHERE	({databaseOwner}{objectQualifier}DesktopModules.ModuleName = N'DNN_Announcements') 
	OR	({databaseOwner}{objectQualifier}DesktopModules.ModuleName = N'DNN_Contacts') 
	OR	({databaseOwner}{objectQualifier}DesktopModules.ModuleName = N'DNN_Discussions')
	OR	({databaseOwner}{objectQualifier}DesktopModules.ModuleName = N'DNN_Documents')
	OR	({databaseOwner}{objectQualifier}DesktopModules.ModuleName = N'DNN_Events')
	OR	({databaseOwner}{objectQualifier}DesktopModules.ModuleName = N'DNN_FAQs')
	OR	({databaseOwner}{objectQualifier}DesktopModules.ModuleName = N'DNN_Feedback')
	OR	({databaseOwner}{objectQualifier}DesktopModules.ModuleName = N'DNN_IFrame')
	OR	({databaseOwner}{objectQualifier}DesktopModules.ModuleName = N'DNN_Image')
	OR	({databaseOwner}{objectQualifier}DesktopModules.ModuleName = N'DNN_Links')
	OR	({databaseOwner}{objectQualifier}DesktopModules.ModuleName = N'DNN_NewsFeeds')
	OR	({databaseOwner}{objectQualifier}DesktopModules.ModuleName = N'DNN_HTML')
	OR	({databaseOwner}{objectQualifier}DesktopModules.ModuleName = N'DNN_Survey')
	OR	({databaseOwner}{objectQualifier}DesktopModules.ModuleName = N'DNN_UserDefinedTable')
	OR	({databaseOwner}{objectQualifier}DesktopModules.ModuleName = N'DNN_UsersOnline')
	OR	({databaseOwner}{objectQualifier}DesktopModules.ModuleName = N'DNN_XML')
GO

DROP procedure {databaseOwner}{objectQualifier}AddDesktopModule
GO

CREATE procedure {databaseOwner}{objectQualifier}AddDesktopModule
    
	@ModuleName			nvarchar(128),
	@FolderName			nvarchar(128),
	@FriendlyName		nvarchar(128),
	@Description		nvarchar(2000),
	@Version			nvarchar(8),
	@IsPremium			bit,
	@IsAdmin			bit,
	@BusinessController nvarchar(200),
	@SupportedFeatures	int

as

insert into {objectQualifier}DesktopModules (
	ModuleName,
	FolderName,
	FriendlyName,
	Description,
	Version,
	IsPremium,
	IsAdmin,
	BusinessControllerClass,
	SupportedFeatures
)
values (
	@ModuleName,
	@FolderName,
	@FriendlyName,
	@Description,
	@Version,
	@IsPremium,
	@IsAdmin,
	@BusinessController,
	@SupportedFeatures
)

select SCOPE_IDENTITY()

GO

DROP  procedure {databaseOwner}{objectQualifier}UpdateDesktopModule
GO

CREATE  procedure {databaseOwner}{objectQualifier}UpdateDesktopModule

	@DesktopModuleId	int,    
	@ModuleName			nvarchar(128),
	@FolderName			nvarchar(128),
	@FriendlyName		nvarchar(128),
	@Description		nvarchar(2000),
	@Version			nvarchar(8),
	@IsPremium			bit,
	@IsAdmin			bit,
	@BusinessController nvarchar(200),
	@SupportedFeatures	int

as

update {objectQualifier}DesktopModules
set    
	ModuleName    = @ModuleName,
	FolderName    = @FolderName,
	FriendlyName    = @FriendlyName,
	Description     = @Description,
	Version         = @Version,
	IsPremium       = @IsPremium,
	IsAdmin         = @IsAdmin,
	BusinessControllerClass = @BusinessController,
	SupportedFeatures    = @SupportedFeatures
where  DesktopModuleId = @DesktopModuleId

GO

DROP  procedure {databaseOwner}{objectQualifier}GetDesktopModuleByName
GO

CREATE procedure {databaseOwner}{objectQualifier}GetDesktopModuleByFriendlyName

	@FriendlyName    nvarchar(128)

as

select *
from   {objectQualifier}DesktopModules
where  FriendlyName = @FriendlyName

GO

CREATE procedure {databaseOwner}{objectQualifier}GetDesktopModuleByModuleName

	@ModuleName    nvarchar(128)

as

select *
from   {objectQualifier}DesktopModules
where  ModuleName = @ModuleName

GO

ALTER TABLE {databaseOwner}{objectQualifier}ModuleDefinitions ADD
	DefaultCacheTime int NOT NULL CONSTRAINT DF_{objectQualifier}ModuleDefinitions_DefaultCacheTime DEFAULT 0
GO

DROP procedure {databaseOwner}{objectQualifier}AddModuleDefinition
GO

CREATE procedure {databaseOwner}{objectQualifier}AddModuleDefinition

	@DesktopModuleId int,    
	@FriendlyName    nvarchar(128),
	@DefaultCacheTime int

as

insert into {objectQualifier}ModuleDefinitions (
  DesktopModuleId,
  FriendlyName,
  DefaultCacheTime
)
values (
  @DesktopModuleId,
  @FriendlyName,
  @DefaultCacheTime
)

select SCOPE_IDENTITY()

GO

CREATE procedure {databaseOwner}{objectQualifier}UpdateModuleDefinition

	@ModuleDefId int,    
	@FriendlyName    nvarchar(128),
	@DefaultCacheTime int

as

update {objectQualifier}ModuleDefinitions 
	SET FriendlyName = @FriendlyName,
		DefaultCacheTime = @DefaultCacheTime
	WHERE ModuleDefId = @ModuleDefId
GO

DROP PROCEDURE {databaseOwner}{objectQualifier}GetSearchModules
GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}GetSearchModules

@PortalID int

as

select M.ModuleID,
       M.ModuleDefID,
       M.ModuleTitle,
       M.AllTabs,
       M.IsDeleted,
       M.InheritViewPermissions,
       M.Header,
       M.Footer,
       M.StartDate,
       M.EndDate,