sqldataprovider.cs

SharpNuke源代码

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

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

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.Announcements
{
	
	/// -----------------------------------------------------------------------------
	/// <summary>
	/// The SqlDataProvider Class is an SQL Server implementation of the DataProvider Abstract
	/// class that provides the DataLayer for the Announcments Module.
	/// </summary>
	/// <returns></returns>
	/// <remarks>
	/// </remarks>
	/// <history>
	/// 	[cnurse]	9/20/2004	Moved Announcements 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]);
			
			string connectionStringName = provider.Attributes["connectionStringName"];
			// Read the attributes for this provider
			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 int AddAnnouncement(int moduleId, string userName, string title, string url, 
			DateTime expireDate, string description, int viewOrder)
		{
			return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddAnnouncement",
				moduleId, userName, title, url, GetNull(expireDate), description, GetNull(viewOrder)));
		}
		
		public override void DeleteAnnouncement (int itemId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeleteAnnouncement", itemId);
		}
		
		public override IDataReader GetAnnouncement(int itemId, int moduleId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetAnnouncement", itemId, moduleId));
		}
		
		public override IDataReader GetAnnouncements(int moduleId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetAnnouncements", moduleId));
		}
		
		public override void UpdateAnnouncement (int itemId, string userName, string title, string url, DateTime expireDate, 
			string description, int viewOrder)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateAnnouncement", 
				itemId, userName, title, url, GetNull(expireDate), description, GetNull(viewOrder));
		}
		
		#endregion
		
	}
	
}