dataprovider.cs

SharpNuke源代码

using System;
using System.Collections;
using System.Data;

//
// DotNetNuke -  http://www.dotnetnuke.com
// Copyright (c) 2002-2005
// by Shaun Walker ( [e-mail] ) of Perpetual Motion Interactive Systems Inc. ( http://www.perpetualmotion.ca )
//
// Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated
// documentation files (the "Software"), to deal in the Software without restriction, including without limitation
// the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and
// to permit persons to whom the Software is furnished to do so, subject to the following conditions:
//
// The above copyright notice and this permission notice shall be included in all copies or substantial portions
// of the Software.
//
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED
// TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL
// THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF
// CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
// DEALINGS IN THE SOFTWARE.
//

namespace DotNetNuke.Data
{
	
	public abstract class DataProvider
	{
		
		#region "Shared/Static Methods"
		
		// singleton reference to the instantiated object
		private static DataProvider dataProvider = null;
		
		// constructor
		static DataProvider() 
		{
			CreateProvider();
		}
		
		// dynamically create provider
		private static void CreateProvider ()
		{
			dataProvider = ((DataProvider) DotNetNuke.Framework.Reflection.CreateObject("data"));
		}
		
		// return the provider
		public static DataProvider Instance()
		{
			return dataProvider;
		}
		
		#endregion
		
		#region "Abstract Methods"
		
		// upgrade
		public abstract string GetProviderPath();
		public abstract string ExecuteScript(string sql);
		public abstract string ExecuteScript(string sql, bool useTransactions);
		public abstract IDataReader GetDatabaseVersion();
		public abstract void UpdateDatabaseVersion (int major, int minor, int build);
		public abstract IDataReader FindDatabaseVersion(int major, int minor, int build);
		public abstract void UpgradeDatabaseSchema (int major, int minor, int build);
		
		// host
		public abstract IDataReader GetHostSettings();
		public abstract IDataReader GetHostSetting(string settingName);
		public abstract void AddHostSetting (string settingName, string settingValue, bool settingIsSecure);
		public abstract void UpdateHostSetting (string settingName, string settingValue, bool settingIsSecure);
		
		// portal
		public abstract IDataReader GetPortalByAlias(string portalAlias);
		public abstract IDataReader GetPortalByTab(int tabId, string portalAlias);
		public abstract int AddPortalInfo(string portalName, string currency, string firstName, string lastName, 
			string username, string password, string email, DateTime expiryDate, double hostFee, double hostSpace, 
			int siteLogHistory, string homeDirectory);
		public abstract void UpdatePortalInfo (int portalId, string portalName, string logoFile, string footerText, 
			DateTime expiryDate, int userRegistration, int bannerAdvertising, string currency, int administratorId, 
			double hostFee, double hostSpace, string paymentProcessor, string processorUserId, string processorPassword, 
			string description, string keyWords, string backgroundFile, int siteLogHistory, 
			int splashTabId, int homeTabId, int loginTabId, int userTabId, string defaultLanguage, int timeZoneOffset, string homeDirectory);
		public abstract void UpdatePortalSetup (int portalId, int administratorId, int administratorRoleId, int registeredRoleId, 
			int splashTabId, int homeTabId, int loginTabId, int userTabId, int adminTabId);
		public abstract void DeletePortalInfo (int portalId);
		public abstract IDataReader GetPortals();
		public abstract IDataReader GetPortal(int portalId);
		public abstract IDataReader GetPortalSpaceUsed(int portalId);
		public abstract IDataReader VerifyPortalTab(int portalId, int tabId);
		public abstract IDataReader VerifyPortal(int portalId);
		
		// tab
		public abstract int AddTab(int portalId, string tabName, bool isVisible, bool disableLink, int parentId, 
			string iconFile, string title, string description, string keyWords, string url, string skinSrc, string containerSrc, string tabPath, 
			DateTime startDate, DateTime endDate, int refreshInterval, string pageHeadText);
		public abstract void UpdateTab (int tabId, string tabName, bool isVisible, bool disableLink, 
			int parentId, string iconFile, string title, string description, string keyWords, bool isDeleted, 
			string url, string skinSrc, string containerSrc, string tabPath, DateTime startDate, DateTime endDate);
		public abstract void UpdateTab(int tabId, string tabName, bool isVisible, bool disableLink, 
			int parentId, string iconFile, string title, string description, string keyWords, bool isDeleted, 
			string url, string skinSrc, string containerSrc, string tabPath, DateTime startDate, DateTime endDate, int refreshInterval, string pageHeadText);
		public abstract void UpdateTabOrder (int tabId, int tabOrder, int level, int parentId);
		public abstract void DeleteTab (int tabId);
		public abstract IDataReader GetTabs(int portalId);
		public abstract IDataReader GetAllTabs();
		public abstract IDataReader GetTab(int tabId);
		public abstract IDataReader GetTabByName(string tabName, int portalId);
		public abstract IDataReader GetTabsByParentId(int parentId);
		public abstract IDataReader GetPortalTabModules(int portalId, int tabId);
		public abstract IDataReader GetTabPanes(int tabId);
		
		// module
		public abstract IDataReader GetAllModules();
		public abstract IDataReader GetModules(int portalId);
		public abstract IDataReader GetAllTabsModules(int portalId, bool allTabs);
		public abstract IDataReader GetModule(int moduleId, int tabId);
		public abstract IDataReader GetModuleByDefinition(int portalId, string friendlyName);
		public abstract IDataReader GetSearchModules(int portalId);
		public abstract int AddModule(int portalID, int moduleDefID, string moduleTitle, bool allTabs, 
			string header, string footer, DateTime startDate, DateTime endDate, bool inheritViewPermissions, bool isDeleted);
		public abstract void UpdateModule (int moduleId, string moduleTitle, bool allTabs, string header, string footer, 
			DateTime startDate, DateTime endDate, bool inheritViewPermissions, bool isDeleted);
		public abstract void DeleteModule (int moduleId);
		public abstract IDataReader GetTabModuleOrder(int tabId, string paneName);
		public abstract void UpdateModuleOrder (int tabId, int moduleId, int moduleOrder, string paneName);
		
		public abstract void AddTabModule (int tabId, int moduleId, int moduleOrder, string paneName, int cacheTime, string alignment, 
			string color, string border, string iconFile, int visibility, string containerSrc, bool displayTitle, bool displayPrint, bool displaySyndicate);
		public abstract void UpdateTabModule (int tabId, int moduleId, int moduleOrder, string paneName, int cacheTime, 
			string alignment, string color, string border, string iconFile, int visibility, string containerSrc, 
			bool displayTitle, bool displayPrint, bool displaySyndicate);
		public abstract void DeleteTabModule (int tabId, int moduleId);
		
		public abstract IDataReader GetModuleSettings(int moduleId);
		public abstract IDataReader GetModuleSetting(int moduleId, string settingName);
		public abstract void AddModuleSetting (int moduleId, string settingName, string settingValue);
		public abstract void UpdateModuleSetting (int moduleId, string settingName, string settingValue);
		
		public abstract IDataReader GetTabModuleSettings(int tabModuleId);
		public abstract IDataReader GetTabModuleSetting(int tabModuleId, string settingName);
		public abstract void AddTabModuleSetting (int tabModuleId, string settingName, string settingValue);
		public abstract void UpdateTabModuleSetting (int tabModuleId, string settingName, string settingValue);
		
		// module definition
		public abstract IDataReader GetDesktopModule(int desktopModuleId);
		public abstract IDataReader GetDesktopModuleByFriendlyName(string friendlyName);
		public abstract IDataReader GetDesktopModuleByModuleName(string moduleName);
		public abstract IDataReader GetDesktopModules();
		public abstract IDataReader GetDesktopModulesByPortal(int portalID);
		public abstract int AddDesktopModule(string moduleName, string folderName, string friendlyName, 
			string description, string version, bool isPremium, bool isAdmin, string businessControllerClass, 
			int supportedFeatures);
		public abstract void UpdateDesktopModule (int desktopModuleId, string moduleName, string folderName, string friendlyName, 
			string description, string version, bool isPremium, bool isAdmin, string businessControllerClass, int supportedFeatures);
		public abstract void DeleteDesktopModule (int desktopModuleId);
		
		public abstract IDataReader GetPortalDesktopModules(int portalID, int desktopModuleID);
		public abstract int AddPortalDesktopModule(int portalID, int desktopModuleID);
		public abstract void DeletePortalDesktopModules (int portalID, int desktopModuleID);
		
		public abstract IDataReader GetModuleDefinitions(int desktopModuleId);
		public abstract IDataReader GetModuleDefinition(int moduleDefId);
		public abstract IDataReader GetModuleDefinitionByName(int desktopModuleId, string friendlyName);
		public abstract int AddModuleDefinition(int desktopModuleId, string friendlyName, int defaultCacheTime);
		public abstract void DeleteModuleDefinition (int moduleDefId);
		public abstract void UpdateModuleDefinition (int moduleDefId, string friendlyName, int defaultCacheTime);
		
		public abstract IDataReader GetModuleControl(int moduleControlId);
		public abstract IDataReader GetModuleControls(int moduleDefID);
		public abstract IDataReader GetModuleControlsByKey(string controlKey, int moduleDefId);
		public abstract IDataReader GetModuleControlByKeyAndSrc(int moduleDefID, string controlKey, string controlSrc);
		public abstract int AddModuleControl(int moduleDefId, string controlKey, string controlTitle, string controlSrc, 
			string iconFile, int controlType, int viewOrder, string helpUrl);
		public abstract void UpdateModuleControl (int moduleControlId, int moduleDefId, string controlKey, 
			string controlTitle, string controlSrc, string iconFile, int controlType, int viewOrder, string helpUrl);
		public abstract void DeleteModuleControl (int moduleControlId);
		
		// files
		public abstract IDataReader GetFiles(int portalId, string folder);
		public abstract IDataReader GetFile(string fileName, int portalId, string folder);
		public abstract IDataReader GetFileById(int fileId, int portalId);
		public abstract void DeleteFile (int portalId, string fileName, string folder);
		public abstract void DeleteFiles (int portalId);
		public abstract int AddFile(int portalId, string fileName, string extension, long size, int width, int height, string contentType, string folder);
		public abstract void UpdateFile (int fileId, string fileName, string extension, long size, int width, int height, string contentType, string folder);
		public abstract DataTable GetAllFiles();

		
		// site log
		public abstract void AddSiteLog (DateTime dateTime, int portalId, int userId, string referrer, string url, string userAgent, 
			string userHostAddress, string userHostName, int tabId, int affiliateId);
		public abstract IDataReader GetSiteLogReports();
		public abstract IDataReader GetSiteLog(int portalId, string portalAlias, string reportName, DateTime startDate, DateTime endDate);
		public abstract void DeleteSiteLog (DateTime dateTime, int portalId);
		
		// database
		public abstract IDataReader ExecuteSQL(string script);
		public abstract IDataReader GetTables();
		public abstract IDataReader GetFields(string tableName);