sqldataprovider.cs

SharpNuke源代码

using System;
using System.Configuration;
using System.Data;
using System.Collections;
using System.Data.SqlClient;

using DotNetNuke.Framework.Providers;
using DotNetNuke.Common.Utilities;

using Microsoft.ApplicationBlocks.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.Modules.Html
{
	
	/// -----------------------------------------------------------------------------
	/// <summary>
	/// The SqlDataProvider Class is an SQL Server implementation of the DataProvider Abstract
	/// class that provides the DataLayer for the HTML Module.
	/// </summary>
	/// <returns></returns>
	/// <remarks>
	/// </remarks>
	/// <history>
	/// 	[cnurse]	9/21/2004	Moved HTML to a separate Project
	/// </history>
	/// -----------------------------------------------------------------------------
	public class SqlDataProvider :  DataProvider
	{
		#region "Private Members"
		
		private const string providerType = "data";
		
		private ProviderConfiguration providerConfiguration;
		private string connectionString;
		private string providerPath;
		private string objectQualifier;
		private string databaseOwner;
		
		#endregion
		
		#region "Constructors"
		
		public SqlDataProvider() 
		{
			providerConfiguration = ProviderConfiguration.GetProviderConfiguration(providerType);
			
			// Read the configuration specific information for this provider
			Provider provider = ((Provider) providerConfiguration.Providers[providerConfiguration.DefaultProvider]);
			
			// Read the attributes for this provider
			string connectionStringName = provider.Attributes["connectionStringName"];
			if (connectionStringName != null && connectionStringName.Length > 0)
			{
				connectionString = ConfigurationSettings.AppSettings[connectionStringName];
			}
			if (connectionString == null || connectionString.Length == 0)
			{
				connectionString = provider.Attributes["connectionString"];
			}
			
			providerPath = provider.Attributes["providerPath"];
			
			objectQualifier = provider.Attributes["objectQualifier"];
			if (objectQualifier != "" && !objectQualifier.EndsWith("_"))
			{
				objectQualifier += "_";
			}
			
			databaseOwner = provider.Attributes["databaseOwner"];
			if (databaseOwner != "" && !databaseOwner.EndsWith("."))
			{
				databaseOwner += ".";
			}
			
		}
		
		#endregion
		
		#region "Properties"
		
		public string ConnectionString
		{
			get { return connectionString; }
		}
		
		public string ProviderPath
		{
			get { return providerPath; }
		}
		
		public string ObjectQualifier
		{
			get { return objectQualifier; }
		}
		
		public string DatabaseOwner
		{
			get { return databaseOwner; }
		}
		
		#endregion
		
		#region "Public Methods"
		
		private object GetNull(object Field)
		{
			return Null.GetNull(Field, DBNull.Value);
		}
		
		public override void AddHtmlText (int moduleId, string desktopHtml, string desktopSummary, int userID)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "AddHtmlText", moduleId, desktopHtml, desktopSummary, userID);
		}
		
		public override IDataReader GetHtmlText(int moduleId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetHtmlText", moduleId));
		}
		
		public override void UpdateHtmlText (int moduleId, string desktopHtml, string desktopSummary, int userID)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateHtmlText", moduleId, desktopHtml, desktopSummary, userID);
		}
		
		#endregion
		
	}
	
}