intro.cs

中国海洋大学211工程网站的全部源码

using System;
using System.Data.OleDb;
using System.Data;
//5_1_a_s_p_x.c_o_m

namespace _211
{
	/// <summary>
	/// Intro 的摘要说明。
	/// </summary>
	public class Intro:IDisposable
	{
		private OleDbConnection conn;
		private OleDbCommand cmd;
		private string IntroContent;

		public Intro()
		{
			conn=DBConnection.getConn();
			conn.Open();
			cmd=new OleDbCommand("select top 1 * from [Intro]",conn);
			try
			{
				OleDbDataReader dr=cmd.ExecuteReader();
				dr.Read();
				IntroContent=dr.GetValue(1).ToString();
			}
			catch
			{
				IntroContent="";
			}
			finally
			{
				cmd.Dispose();
				conn.Close();
			}
		}

		public Intro(string IC)
		{
			IntroContent=StringManager.StringSelected(IC);
		}

		public void CloseConn()
		{
			if(conn.State==ConnectionState.Open)
				conn.Close();
		}

		public void Dispose()
		{
			if(conn.State==ConnectionState.Open)
				conn.Close();
			conn.Dispose();
			GC.SuppressFinalize(this);
		}

		public void Update()
		{
			if(conn.State==ConnectionState.Closed)
				conn.Open();
			cmd=new OleDbCommand("update [Intro] set IntroContent='"+IntroContent+"'",conn);
			try
			{
				cmd.ExecuteNonQuery();
			}
			catch(Exception ex)
			{
				throw ex;
			}
			finally
			{
				cmd.Dispose();
				conn.Close();
			}
		}

		public string getIntroContent()
		{
			return IntroContent;
		}

		public void setIntroContent(string IC)
		{
			IntroContent=StringManager.StringSelected(IC);
		}
	}
}