using System;
using System.Data;
using System.Data.SqlClient;
using System.ComponentModel;

namespace 圖書館管理系統
{
	/// <summary>
	/// DataBase 的摘要說明。
	/// </summary>
	public class DataBase : IDisposable
	{

		private SqlConnection sqlConn;
		public static string sConn = "Persist Security Info=False;Integrated Security=SSPI;database=libbook;server=localhost;Connect Timeout=30";


		public DataBase()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//
		}

		
		public  void Dispose()
		{
			Dispose( true );
			GC.SuppressFinalize( true );
		}

		protected void Dispose( bool disposing )
		{
			if ( !disposing )
			{
				return;
			}
			if ( sqlConn != null )
			{
				sqlConn.Dispose();
				sqlConn = null;
			}
		}

		public void Open()
		{
			if ( sqlConn == null )
			{
				sqlConn = new SqlConnection( sConn );
				sqlConn.Open();
			}
		}

		public void Close()
		{
			if ( sqlConn != null )
			{
				sqlConn.Close();
			}
		}

		public DataView RunSelectSQL( string sSQLString )
		{
			this.Open();
			DataSet SqlDS = new DataSet();
			SqlDataAdapter SqlDA = new SqlDataAdapter( sSQLString, this.sqlConn );
			SqlDA.Fill( SqlDS );
			return SqlDS.Tables[ 0 ].DefaultView;
		}

		public void RunDelOrInsSQL( string sSQLString )
		{
			this.Open();
			SqlCommand SqlComm = new SqlCommand( sSQLString, this.sqlConn );
			SqlComm.ExecuteNonQuery();
		}
	
	}
}