using System;
using System.Configuration;

namespace _36Hang.Data
{
	/// <summary>
	/// Connection 的摘要說明。
	/// </summary>
	public class Connection
	{	
		private string _Server;
		private string _Database;
		private string _Username;
		private string _Password;

		public Connection(string Server,string Database,string Username,string Password)
		{
			_Server = Server;
			_Database = Database;
			_Username = Username;
			_Password = Password;
		}

		/// <summary>
		/// 執(zhí)行數據庫查詢
		/// </summary>
		/// <param name="Sql">數據庫查詢語句</param>
		public void Execute(string Sql)
		{
			try
			{
				SqlClient.Connection objConnection = new SqlClient.Connection(_Server,_Database,_Username,_Password);
				objConnection.Execute(Sql);
			}
			catch(Exception e)
			{
				throw(e);
			}
		}

		/// <summary>
		/// 獲得數據庫查詢結果
		/// 用于獲得全部查詢結果
		/// </summary>
		/// <param name="Sql">數據庫查詢語句</param>
		/// <returns>數據庫查詢結果</returns>
		public string Records(string Sql)
		{
			try
			{
				SqlClient.Connection objConnection = new SqlClient.Connection(_Server,_Database,_Username,_Password);
				return objConnection.Records(Sql);
			}
			catch(Exception e)
			{
				throw(e);
			}
		}

		/// <summary>
		/// 獲得數據庫查詢結果
		/// 用于獲取由 Page、Length 參數指定條件的查詢結果
		/// </summary>
		/// <param name="Sql">數據庫查詢語句</param>
		/// <param name="Page">數據庫查詢結果的頁數</param>
		/// <param name="Length">數據庫查詢結果的頁長</param>
		/// <returns>數據庫查詢結果</returns>
		public string Records(string Sql,int Page,int Length)
		{
			try
			{
				SqlClient.Connection objConnection = new SqlClient.Connection(_Server,_Database,_Username,_Password);
				return objConnection.Records(Sql,Page,Length);
			}
			catch(Exception e)
			{
				throw(e);
			}
		}
	}
}