graderule.cs

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

using System;
using ExamSystem.DataAccess.TeacherAccess;
using ExamSystem.Common.Objects;
using System.Data;
using ExamSystem.Common.DB;
namespace ExamSystem.BusinessRule.TeacherRule
{
	/// <summary>
	/// GradeRule 的摘要说明。
	/// </summary>
	public class GradeRule
	{
		public GradeRule()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		/// <summary>
		/// 检验有没有重复的年级名
		/// </summary>
		/// <param name="grd">要检验的年级对象</param>
		/// <returns></returns>
		private bool hasGrade(Grade grd)
		{
			Grade tmpGrd=new Grade();
			tmpGrd.GradeName=grd.GradeName;
			DataBaseOperate oper=new DataBaseOperate();
			GradeManager grdMan=new GradeManager(oper);
			DataSet ds=grdMan.getGrades(tmpGrd);
			oper.CloseDataBase();
			if(ds.Tables[0].Rows.Count>0)
			{
				return true;
			}
			return false;
		}
		public DataSet getGrade(Grade grd)
		{
			DataBaseOperate oper=new DataBaseOperate();
			GradeManager grdMan=new GradeManager(oper);
			DataSet ds=grdMan.getGrades(grd);
			oper.CloseDataBase();
			return ds;
		}

		public bool updateGrade(Grade grd)
		{
			if(hasGrade(grd))
			{
				return false;
			}
			DataBaseOperate oper=new DataBaseOperate();
			GradeManager grdMan=new GradeManager(oper);
			grdMan.updateGrades(grd);
			oper.CloseDataBase();
			return true;
		}

		public bool insertGrade(Grade grd)
		{
			if(hasGrade(grd))
			{
				return false;
			}
			DataBaseOperate oper=new DataBaseOperate();
			GradeManager grdMan=new GradeManager(oper);
			grdMan.insertGrade(grd);
			oper.CloseDataBase();
			return true;
		}

		public void deleteGrade(Grade grd)
		{
			DataBaseOperate oper=new DataBaseOperate();
			GradeManager grdMan=new GradeManager(oper);
			StudentManage stuMan=new StudentManage(oper);
			ClassMan clsMan=new ClassMan(oper);

			//建立一个班级对象，指向该年级的所有班级
			Class cls=new Class();
			cls.GradeID=grd.GradeID;
			try
			{
				oper.StartTransation();//开启事务
				stuMan.delStudent(grd);//删除年级里边所有的学生
				clsMan.deleteClass(cls);//删除年级里边的所有班级
				grdMan.deleteGrade(grd);//删除年级
				oper.Commit();//提交事务
				
			}
			catch(Exception ex)
			{
				throw ex;
			}
			finally
			{
				try
				{
					oper.CloseDataBase();
				}
				catch{}
			}
		}
	}
}