caterule.cs

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

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

namespace ExamSystem.BusinessRule.ExamsRule
{
	/// <summary>
	/// CateRule 的摘要说明。
	/// </summary>
	public class CateRule
	{
		public CateRule()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		/// <summary>
		/// 获取班级所有的科目
		/// </summary>
		/// <param name="cls"></param>
		/// <returns></returns>
		public DataSet getCate(Class cls)
		{
			DataBaseOperate oper=new DataBaseOperate();
			CateAccess cateAcc=new CateAccess(oper);
			DataSet ds=cateAcc.getCate(cls);
			oper.CloseDataBase();
			return ds;
		}

		public DataSet getCate(Cate cate)
		{
			DataBaseOperate oper=new DataBaseOperate();
			CateAccess cateAcc=new CateAccess(oper);
			DataSet ds=cateAcc.getCate(cate);
			oper.CloseDataBase();
			return ds;
		}
		
		/// <summary>
		/// 判断科目名是否存在
		/// </summary>
		/// <param name="cate">科目对象</param>
		/// <returns></returns>
		private bool hasCateName(Cate cate)
		{
			Cate tmpCate=new Cate();
			tmpCate.CateName=cate.CateName;
			DataBaseOperate oper=new DataBaseOperate();
			CateAccess cateAcc=new CateAccess(oper);
			DataSet ds=cateAcc.getCate(tmpCate);
			oper.CloseDataBase();
			if(ds.Tables[0].Rows.Count>0)
			{
				return true;
			}
			return false;

		}
		public bool insertCate(Cate cate)
		{
			if(hasCateName(cate))
			{
				return false;
			}
			DataBaseOperate oper=new DataBaseOperate();
			CateAccess cateAcc=new CateAccess(oper);
			cateAcc.insertCate(cate);
			oper.CloseDataBase();
			return true;
		}

		public bool updateCate(Cate cate)
		{
			if(hasCateName(cate))
			{
				return false;
			}
			DataBaseOperate oper=new DataBaseOperate();
			CateAccess cateAcc=new CateAccess(oper);
			cateAcc.updateCate(cate);
			oper.CloseDataBase();
			return true;
		}


		public void deleteExam(Cate cate)
		{
			DataBaseOperate oper=new DataBaseOperate();
			CateAccess cateAcc=new CateAccess(oper);
			cateAcc.deleteCate(cate);
			oper.CloseDataBase();
		}
	}
}