dbaccess.cs

实施医院管理系统

using System;
using comman;
using System.Data;
using System.Data.SqlClient;

namespace DataAccess
{
	/// <summary>
	/// DBAccess 的摘要说明。
	/// </summary>
	internal sealed class DBAccess
	{
		private DBAccess()
		{
		}

		public static void OpenConnection(SqlConnection con)
		{
			if(con.State != ConnectionState.Open)
				con.Open();
		}
		public static void CloseConnection(SqlConnection con)
		{
			if(con.State != ConnectionState.Closed)
				con.Close();

		}
		public static int ExcuteCommand(SqlConnection connection,string commandText)
		{
			SqlCommand comd = connection.CreateCommand();
			comd.CommandText = commandText;

			OpenConnection(connection);
			int row = comd.ExecuteNonQuery();
			CloseConnection(connection);

			return row;
		}
		public static DataTable ExcuteDataTable(SqlConnection connection,string commandText)
		{
			SqlDataAdapter da = new SqlDataAdapter(commandText,connection);
			DataTable ta = new DataTable();

			OpenConnection(connection);
			da.Fill(ta);
			CloseConnection(connection);

			return ta;

		}

	}
}