caterule.cs

来自「考试管理系统CS架构 不需更多说明」· CS 代码 · 共 100 行

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();
		}
	}
}