idbmanage2000.cs

很不错的公文流转系统

using System; 
using System.Web; 
using System.Web.SessionState ;
using System.Data;
using System.Data.SqlClient; 

namespace  OI.Modules
{
	/// <summary>
	/// iDBManage2000 的摘要说明。
	/// </summary>
	public class iDBManage2000: System.IDisposable
	{
		public string Connectionstring=System.Configuration.ConfigurationSettings.AppSettings["conn"].ToString();
		public SqlConnection Connection; 

		public iDBManage2000()
		{
			
			//Connectionstring="server=csx;uid=sa;pwd=;database=iwebdbdemo";
	        

		}
		~iDBManage2000()
		{
			this.Dispose ();
		}
		public void Dispose()
		{
			if(Connection.State ==System.Data.ConnectionState .Open )
			{
				Connection.Close();
				Connection.Dispose ();
				Connection=null;
				GC.SuppressFinalize (true);
			}
		}

		public void Open()
		{
			
			Connection = new SqlConnection(Connectionstring);
			Connection.Open();
		}

		public void Close()
		{
			Connection.Close()  ;
		}

		public string  GetDateTime()
		{
			System.DateTime SystemTime;
			SystemTime=DateTime.Now;
			
			return (SystemTime.ToString("yyyy-MM-dd HH:mm:ss"));

		}

	}
}