sqldataprovider.cs

SharpNuke源代码

				sql.Append("from dbo.sysobjects o ");
				sql.Append("where ( OBJECTPROPERTY(o.id, N\'IsProcedure\') = 1 or OBJECTPROPERTY(o.id, N\'IsExtendedProc\') = 1 or OBJECTPROPERTY(o.id, N\'IsReplProc\') = 1 ) ");
				sql.Append("and OBJECTPROPERTY(o.id, N\'IsMSShipped\') = 0 ");
				sql.Append("and o.name not like N\'#%%\' ");
				sql.Append("and (left(o.name,len(\'" + ObjectQualifier + "\')) = \'" + ObjectQualifier + "\' or left(o.name,7) = \'aspnet_\') ");
				sql.Append("open sp_cursor ");
				sql.Append("fetch sp_cursor into @name ");
				sql.Append("while @@fetch_status >= 0 ");
				sql.Append("begin");
				sql.Append("  select @exec = \'grant " + permission + " on \' +  @name  + \' to " + loginOrRole + "\'");
				sql.Append("  execute (@exec)");
				sql.Append("  fetch sp_cursor into @name ");
				sql.Append("end ");
				sql.Append("deallocate sp_cursor");
				SqlHelper.ExecuteNonQuery(UpgradeConnectionString, CommandType.Text, sql.ToString());
			}
			catch (SqlException sqlException)
			{
				exceptions.Append(sqlException.ToString() + "\n\n" + sql.ToString() + "\n\n");
			}
			return exceptions.ToString();
		}
		
		public override IDataReader GetDatabaseVersion()
		{
			return ((IDataReader) SqlHelper.ExecuteReader(UpgradeConnectionString, DatabaseOwner + ObjectQualifier + "GetDatabaseVersion", null));
		}

		public override void UpdateDatabaseVersion (int major, int minor, int build)
		{
			SqlHelper.ExecuteNonQuery(UpgradeConnectionString, DatabaseOwner + ObjectQualifier + "UpdateDatabaseVersion", major, minor, build);
		}

		public override IDataReader FindDatabaseVersion(int major, int minor, int Build)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(UpgradeConnectionString, DatabaseOwner + ObjectQualifier + "FindDatabaseVersion", major, minor, Build));
		}

		public override void UpgradeDatabaseSchema (int major, int minor, int build)
		{
			// not necessary for SQL Server - use Transact-SQL scripts
		}
		#endregion

		#region host
		public override IDataReader GetHostSettings()
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetHostSettings", null));
		}

		public override IDataReader GetHostSetting(string SettingName)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetHostSetting", SettingName));
		}

		public override void AddHostSetting (string settingName, string settingValue, bool settingIsSecure)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "AddHostSetting", settingName, settingValue, settingIsSecure);
		}

		public override void UpdateHostSetting (string settingName, string settingValue, bool settingIsSecure)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateHostSetting", settingName, settingValue, settingIsSecure);
		}
		#endregion
		
		#region portal
		public override IDataReader GetPortalByAlias(string portalAlias)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetPortalByAlias", portalAlias));
		}

		public override IDataReader GetPortalByTab(int tabId, string portalAlias)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetPortalByTab", tabId, portalAlias));
		}

		public override 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)
		{
			return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddPortalInfo", 
				portalName, currency, firstName, lastName, username, password, email, GetNull(expiryDate), hostFee, hostSpace, 
				GetNull(siteLogHistory), homeDirectory));
		}
		public override 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)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdatePortalInfo", portalId, 
				portalName, GetNull(logoFile), GetNull(footerText), GetNull(expiryDate), userRegistration, bannerAdvertising, currency, 
				GetNull(administratorId), hostFee, hostSpace, GetNull(paymentProcessor), GetNull(processorUserId), GetNull(processorPassword), 
				GetNull(description), GetNull(keyWords), GetNull(backgroundFile), GetNull(siteLogHistory), GetNull(splashTabId), GetNull(homeTabId), 
				GetNull(loginTabId), GetNull(userTabId), GetNull(defaultLanguage), GetNull(timeZoneOffset), homeDirectory);
		}

		public override void UpdatePortalSetup (int portalId, int administratorId, int administratorRoleId, 
			int registeredRoleId, int splashTabId, int homeTabId, int loginTabId, int userTabId, int adminTabId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdatePortalSetup", 
				portalId, administratorId, administratorRoleId, registeredRoleId, splashTabId, homeTabId, loginTabId, userTabId, adminTabId);
		}

		public override void DeletePortalInfo (int portalId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeletePortalInfo", portalId);
		}

		public override IDataReader GetPortals()
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetPortals", null));
		}

		public override IDataReader GetPortal(int portalId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetPortal", portalId));
		}

		public override IDataReader GetPortalSpaceUsed(int portalId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetPortalSpaceUsed", GetNull(portalId)));
		}

		public override IDataReader VerifyPortalTab(int portalId, int tabId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "VerifyPortalTab", portalId, tabId));
		}

		public override IDataReader VerifyPortal(int portalId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "VerifyPortal", portalId));
		}
		#endregion

		#region tab
		public override int AddTab(int portalId, string tabName, bool visible, 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 pageHeaderText)
		{
			return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddTab", 
				GetNull(portalId), tabName, visible, disableLink, GetNull(parentId), iconFile, title, description, 
				keyWords, url, GetNull(skinSrc), GetNull(containerSrc), tabPath, GetNull(startDate), GetNull(endDate), 
				GetNull(refreshInterval), GetNull(pageHeaderText)	));
		}

		[Obsolete("This method is used for legacy support during the upgrade process (pre v3.1.1). It has been replaced by one that adds the RefreshInterval and PageHeadText variables.")]
		public override void UpdateTab (int tabId, string tabName, bool visible, bool disableLink, int parentId, string iconFile, 
			string title, string description, string keyWords, bool deleted, string url, string skinSrc, string containerSrc, 
			string tabPath, DateTime startDate, DateTime endDate)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateTab", tabId, tabName, 
				visible, disableLink, GetNull(parentId), iconFile, title, description, keyWords, deleted, url, 
				GetNull(skinSrc), GetNull(containerSrc), tabPath, GetNull(startDate), GetNull(endDate));
		}

		public override void UpdateTab (int tabId, string tabName, bool visible, bool disableLink, int parentId, string iconFile, 
			string title, string description, string keyWords, bool deleted, string url, string skinSrc, string containerSrc, 
			string tabPath, DateTime startDate, DateTime endDate, int refreshInterval, string pageHeaderText)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateTab", tabId, tabName, 
				visible, disableLink, GetNull(parentId), iconFile, title, description, keyWords, deleted, url, 
				GetNull(skinSrc), GetNull(containerSrc), tabPath, GetNull(startDate), GetNull(endDate), GetNull(refreshInterval), GetNull(pageHeaderText));
		}

		public override void UpdateTabOrder (int tabId, int tabOrder, int level, int parentId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateTabOrder", tabId, tabOrder, level, GetNull(parentId));
		}

		public override void DeleteTab (int tabId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeleteTab", tabId);
		}

		public override IDataReader GetTabs(int portalId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetTabs", portalId));
		}

		public override IDataReader GetAllTabs()
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetAllTabs", null));
		}

		public override IDataReader GetTab(int tabId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetTab", tabId));
		}

		public override IDataReader GetTabByName(string tabName, int portalId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetTabByName", tabName, GetNull(portalId)));
		}

		public override IDataReader GetTabsByParentId(int parentId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetTabsByParentId", parentId));
		}

		public override IDataReader GetTabPanes(int tabId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetTabPanes", tabId));
		}

		public override IDataReader GetPortalTabModules(int portalId, int tabId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetPortalTabModules", portalId, tabId));
		}
		#endregion
		
		#region module
		public override IDataReader GetAllModules()
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetAllModules", null));
		}

		public override IDataReader GetModules(int portalId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetModules", portalId));
		}

		public override IDataReader GetAllTabsModules(int portalId, bool allTabs)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetAllTabsModules", portalId, allTabs));
		}

		public override IDataReader GetModule(int moduleId, int tabId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetModule", moduleId, GetNull(tabId)));
		}

		public override IDataReader GetModuleByDefinition(int portalId, string friendlyName)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetModuleByDefinition", GetNull(portalId), friendlyName));
		}

		public override int AddModule(int portalID, int moduleDefID, string moduleTitle, bool allTabs, string header, string footer, 
			DateTime startDate, DateTime endDate, bool inheritViewPermissions, bool deleted)
		{
			return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddModule", 
				GetNull(portalID), moduleDefID, moduleTitle, allTabs, GetNull(header), GetNull(footer), GetNull(startDate), GetNull(endDate), inheritViewPermissions, deleted));
		}

		public override void UpdateModule (int moduleId, string moduleTitle, bool allTabs, string header, string footer, 
			DateTime startDate, DateTime endDate, bool inheritViewPermissions, bool deleted)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateModule", moduleId, moduleTitle, allTabs, 
				GetNull(header), GetNull(footer), GetNull(startDate), GetNull(endDate), inheritViewPermissions, deleted);
		}

		public override void DeleteModule (int moduleId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeleteModule", moduleId);
		}
		
		public override IDataReader GetTabModuleOrder(int tabId, string paneName)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetTabModuleOrder", tabId, paneName));
		}

		public override void UpdateModuleOrder (int tabId, int moduleId, int moduleOrder, string paneName)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateModuleOrder", tabId, moduleId, moduleOrder, paneName);
		}
		
		public override 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)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "AddTabModule", tabId, moduleId, 
				moduleOrder, PaneName, cacheTime, GetNull(alignment), GetNull(color), GetNull(border), 
				GetNull(iconFile), visibility, GetNull(containerSrc), displayTitle, displayPrint, displaySyndicate);
		}

		public override 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)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateTabModule", tabId, 
				moduleId, moduleOrder, paneName, cacheTime, GetNull(alignment), GetNull(color), GetNull(border),
				GetNull(iconFile), visibility, GetNull(containerSrc), displayTitle, displayPrint, displaySyndicate);
		}

		public override void DeleteTabModule (int tabId, int moduleId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeleteTabModule", tabId, moduleId);
		}

		public override IDataReader GetSearchModules(int portalId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetSearchModules", portalId));
		}

		public override IDataReader GetModuleSettings(int moduleId)