classrule.cs

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

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

namespace ExamSystem.BusinessRule.TeacherRule
{
	/// <summary>
	/// ClassRule 的摘要说明。
	/// </summary>
	public class ClassRule
	{
		public ClassRule()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public DataSet getClass(Class cls)
		{
			DataBaseOperate oper=new DataBaseOperate();
			ClassMan clsMan=new ClassMan(oper);
			DataSet ds=clsMan.getClasses(cls);
			oper.CloseDataBase();
			return ds;
		}

		/// <summary>
		/// 检验有没有重复的班级名
		/// </summary>
		/// <param name="cls">要检验的班级对象</param>
		/// <returns></returns>
		private bool hasClass(Class cls)
		{
			Class tmpCls=new Class();
			tmpCls.ClassName=cls.ClassName;
			DataBaseOperate oper=new DataBaseOperate();
			ClassMan clsMan=new ClassMan(oper);
			DataSet ds=clsMan.getClasses(tmpCls);
			oper.CloseDataBase();
			if(ds.Tables[0].Rows.Count>0)
			{
				return true;
			}
			return false;
		}
		
		/// <summary>
		/// 更新班级
		/// </summary>
		/// <param name="cls">要更新的班级对象</param>
		/// <returns></returns>
		public bool updateClass(Class cls)
		{
			if(hasClass(cls))
			{
				return false;
			}
			DataBaseOperate oper=new DataBaseOperate();
			ClassMan clsMan=new ClassMan(oper);
			clsMan.updateClass(cls);
			oper.CloseDataBase();
			return true;
		}
		
		/// <summary>
		/// 插入班级
		/// </summary>
		/// <param name="cls">要插入的班级对象</param>
		/// <returns></returns>
		public bool insertClass(Class cls)
		{
			if(hasClass(cls))
			{
				return false;
			}
			DataBaseOperate oper=new DataBaseOperate();
			ClassMan clsMan=new ClassMan(oper);
			clsMan.insertClass(cls);
			oper.CloseDataBase();
			return true;
		}

		/// <summary>
		/// 删除班级
		/// </summary>
		/// <param name="cls">要删除班级对象</param>
		public void deleteClass(Class cls)
		{
			DataBaseOperate oper=new DataBaseOperate();
			StudentManage stuMan=new StudentManage(oper);
			ClassMan clsMan=new ClassMan(oper);
			Student stu=new Student();
			stu.StuClass=cls.ClassID;

			try
			{
				stuMan.delStudent(stu);//删除班级下的所有学生
				clsMan.deleteClass(cls);//删除班级
				oper.Commit();
			}
			catch(Exception ex)
			{
				throw ex;
			}
			finally
			{
				try
				{
					oper.CloseDataBase();
				}
				catch{}
			}
		}

	}
}