//=====================================================================================
// 作者：二十四畫生
// Email：mailto:esshs@tom.com
// Blog：http://esshs.cnblogs.com
//=====================================================================================

using System;
using System.Data;

using Microsoft.ApplicationBlocks.Data;

using Esshs.Common.Framework;
using Esshs.DAL;

namespace Esshs.DAL.SQLDataProvider
{
	/// <summary>
	/// SQL Server數據訪問的具體實現
	/// </summary>
	public class SqlDataProvider : DataProvider
	{
		private const string ProviderType = "data";
		// 獲取數據庫訪問Provider的配置信息
		private ProviderConfiguration _providerConfiguration = ProviderConfiguration.GetProviderConfiguration(ProviderType);
		private string _connectionString;

		/// <summary>
		/// 構造函數
		/// </summary>
		public SqlDataProvider()
		{
			// 讀取默認的Provider對象
			Provider objProvider = (Provider)_providerConfiguration.Providers[_providerConfiguration.DefaultProvider];
			// 獲取connectionString屬性的信息
			if (objProvider.Attributes["connectionStringName"] != "" && System.Configuration.ConfigurationSettings.AppSettings[objProvider.Attributes["connectionStringName"]] != "")
			{
				_connectionString = System.Configuration.ConfigurationSettings.AppSettings[objProvider.Attributes["connectionStringName"]];
			}
			else
			{
				_connectionString = objProvider.Attributes["connectionString"];
			}
		}

		/// <summary>
		/// 連接字符串屬性
		/// </summary>
		public string ConnectionString
		{
			get
			{
				return _connectionString;
			}
		}

		#region 實現抽象方法

		/// <summary>
		/// 獲取所有的分類信息
		/// </summary>
		/// <returns></returns>
		public override DataSet GetCategories()
		{
			return SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text ,"select * from Categories");
		}

		#endregion
	}
}