subjects.cs

三层体系结构的应用-学员管理系统 一个学校需要一个学生管理系统。分以下功能: 管理班档案 管理学生档案 学校开了多门课程

using System;
using System.Data;

namespace Aptech.Student.DataAccess
{
	using Aptech.Student.Common;

	public class Subjects
	{
		private DataBaseOperate cDbObject = null;
		private bool bConn = false;
	
		
		public Subjects()
		{
			cDbObject = new DataBaseOperate();
			bConn = false;
		}
		

		public Subjects(DataBaseOperate dbOperate)
		{
			cDbObject = dbOperate;
			bConn = true;
		}

		/// <summary>
		/// 从数据库获取科目信息
		/// </summary>
		/// <param name="iSubjectId">科目ID</param>
		/// <param name="sSubjectName">科目名称</param>
		/// <returns>科目信息的DataSet</returns>
		public DataSet SelectSubject(
			int		iSubjectId,
			string	sSubjectName)
		{
			string sSql = "select * from Subject where 1 = 1";
			if(iSubjectId != -1)
			{
				sSql += " and SubjectId = " + iSubjectId.ToString(); 
			}
			if(sSubjectName != "")
			{
				sSql += " and SubjectName like '%" + sSubjectName + "%'"; 
			}
	
			DataSet dataSet = new DataSet();

			try
			{
				dataSet = cDbObject.Search(
					sSql,
					"Subject");
			}
			catch(Exception e)
			{
				throw e;
			}
			return dataSet;
		}

		public bool DeleteSubject(
			int		iSubjectId)
		{
			string sSql = 
				" delete Subject"
				+ " where SubjectId = " + iSubjectId.ToString();
			try
			{
				cDbObject.Execute(sSql);
			}
			catch(Exception e)
			{
				throw(e);
			}
			return true;
		}

		public bool InsertSubject(
			string	sSubjectName,
			string	sRemark)
		{
			string sSql = 
				"insert Subject("
				+ " SubjectName"
				+ ",Remark"
				+ ")"
				+ " values("
				+ "'" + sSubjectName + "'"
				+ ",'" + sRemark + "'"
				+ ")";
			try
			{
				cDbObject.Execute(sSql);
			}
			catch(Exception e)
			{
				throw e;
			}
			return true;
		}

		public bool UpdateSubject(
			int		iSubjectId,
			string	sSubjectName,
			string	sRemark)
		{
			string sSql = 
				"update Subject set"
				+ " SubjectName = '" + sSubjectName + "'"
				+ ",Remark = '" + sRemark + "'"
				+ " where SubjectId = " + iSubjectId; 

			try
			{
				cDbObject.Execute(sSql);
			}
			catch(Exception e)
			{
				throw(e);
			}
			return true;
		}

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

		public virtual void Dispose(bool disposing)
		{
			if(!disposing)
			{
				return;
			}
			
			if(!bConn)
			{
				cDbObject.CloseDataBase();
			}
		}
	}
}