sqldataprovider.cs

SharpNuke源代码

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

using Microsoft.ApplicationBlocks.Data;

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

//
// 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.Services.Scheduling.DNNScheduling
{
	
	public class SqlDataProvider : DataProvider
	{
		
		private const string providerType = "data";
		
		private ProviderConfiguration providerConfiguration;
		private string connectionString;
		private string providerPath;
		private string objectQualifier;
		private string databaseOwner;
		
		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
			// 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 += ".";
			}
		}
		
		public string ConnectionString
		{
			get { return this.connectionString; }
		}
		
		public string ProviderPath
		{
			get { return this.providerPath; }
		}
		
		public string ObjectQualifier
		{
			get { return this.objectQualifier; }
		}
		
		public string DatabaseOwner
		{
			get { return this.databaseOwner; }
		}
		
		// general
		private object GetNull(object field)
		{
			return Null.GetNull(field, DBNull.Value);
		}
		
		public override IDataReader GetSchedule()
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetSchedule", DBNull.Value));
		}

		public override IDataReader GetSchedule(string server)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetSchedule", GetNull(server)));
		}

		public override IDataReader GetSchedule(int scheduleID)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetScheduleByScheduleID", scheduleID));
		}

		public override IDataReader GetSchedule(string typeFullName, string server)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetScheduleByTypeFullName", typeFullName, GetNull(server)));
		}

		public override IDataReader GetNextScheduledTask(string server)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetScheduleNextTask", GetNull(server)));
		}

		public override IDataReader GetScheduleByEvent(string eventName, string server)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetScheduleByEvent", eventName, GetNull(server)));
		}

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

		public override int AddSchedule(string typeFullName, int timeLapse, string timeLapseMeasurement, int retryTimeLapse, 
			string retryTimeLapseMeasurement, int retainHistoryNum, string attachToEvent, bool catchUpEnabled, bool enabled, 
			string objectDependencies, string servers)
		{
			return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddSchedule", 
				typeFullName, timeLapse, timeLapseMeasurement, retryTimeLapse, retryTimeLapseMeasurement, retainHistoryNum, 
				attachToEvent, catchUpEnabled, enabled, objectDependencies, GetNull(servers)));
		}

		public override void UpdateSchedule (int scheduleID, string typeFullName, int timeLapse, string timeLapseMeasurement, 
			int retryTimeLapse, string retryTimeLapseMeasurement, int retainHistoryNum, string attachToEvent, bool catchUpEnabled, 
			bool enabled, string objectDependencies, string servers)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateSchedule", scheduleID, 
				typeFullName, timeLapse, timeLapseMeasurement, retryTimeLapse, retryTimeLapseMeasurement, retainHistoryNum, 
				attachToEvent, catchUpEnabled, enabled, objectDependencies, GetNull(servers));
		}

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

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

		public override int AddScheduleHistory(int scheduleID, DateTime startDate, string server)
		{
			return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddScheduleHistory", scheduleID, startDate, server));
		}

		public override void UpdateScheduleHistory (int scheduleHistoryID, DateTime endDate, bool succeeded, string logNotes, DateTime nextStart)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateScheduleHistory", 
				scheduleHistoryID, GetNull(endDate), GetNull(succeeded), logNotes, GetNull(nextStart));
		}

		public override void PurgeScheduleHistory ()
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "PurgeScheduleHistory", null);
		}
	}
	
}