examrule.cs

考试管理系统考试管理系统考试管理系统考试管理系统考试管理系统考试管理系统考试管理系统考试管理系统

using System;
using ExamSystem.DataAccess.ExamAccess;
using ExamSystem.Common.Objects;
using System.Data; 
using ExamSystem.Common.DB;

namespace ExamSystem.BusinessRule.ExamsRule
{
	/// <summary>
	/// ExamRule 的摘要说明。
	/// </summary>
	public class ExamRule
	{
		public ExamRule()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		
		public DataSet getExam(Exam exam)
		{
			DataBaseOperate oper=new DataBaseOperate();
			ExamsAccess examAcc=new ExamsAccess(oper);
			DataSet ds=examAcc.getExam(exam);
			oper.CloseDataBase();
			return ds;
		}

		public DataSet getExam(Student stu)
		{
			DataBaseOperate oper=new DataBaseOperate();
			ExamsAccess examAcc=new ExamsAccess(oper);
			DataSet ds=examAcc.getExam(stu);
			oper.CloseDataBase();
			return ds;
		}
		
		/// <summary>
		/// 判断这考试的名字有没有重复
		/// </summary>
		/// <param name="exam">考试对象</param>
		/// <returns></returns>
		private bool hasExamName(Exam exam)
		{
			Exam tmpExam=new Exam();
			tmpExam.ExamName=exam.ExamName;
			DataBaseOperate oper=new DataBaseOperate();
			ExamsAccess examAcc=new ExamsAccess(oper);
			DataSet ds=examAcc.getExam(tmpExam);
			oper.CloseDataBase();
			if(ds.Tables[0].Rows.Count>0)
			{
				return true;
			}
			return false;
		}

		public bool insertExam(Exam exam)
		{
			if(hasExamName(exam))
			{
				return false;
			}
			DataBaseOperate oper=new DataBaseOperate();
			ExamsAccess examAcc=new ExamsAccess(oper);
			examAcc.insertExam(exam);
			oper.CloseDataBase();
			return true;
		}

		public bool updateExam(Exam exam)
		{
			if(hasExamName(exam))
			{
				return false;
			}
			DataBaseOperate oper=new DataBaseOperate();
			ExamsAccess examAcc=new ExamsAccess(oper);
			examAcc.updateExam(exam);
			oper.CloseDataBase();
			return true;
		}

		public void deleteExam(Exam exam)
		{
			DataBaseOperate oper=new DataBaseOperate();
			ExamsAccess examAcc=new ExamsAccess(oper);
			examAcc.deleteExam(exam);
			oper.CloseDataBase();
		}
	}
}