resultrule.cs

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

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

		/// <summary>
		/// 判断成绩是否已经存在
		/// </summary>
		/// <param name="result">要判断的成绩对象</param>
		/// <returns></returns>
		private bool hasResult(ExamResult result)
		{
			ExamResult tmpResult=new ExamResult();
			tmpResult.StuID=result.StuID;
			tmpResult.ExamID=result.ExamID;
			DataBaseOperate oper=new DataBaseOperate();
			ResultAccess resAcc=new ResultAccess(oper);
			DataSet ds=resAcc.getResult(tmpResult);
			oper.CloseDataBase();
			if(ds.Tables[0].Rows.Count>0)
			{
				return true;
			}
			return false;
		}
		
		public void updateResult(ExamResult result)
		{
//			if(hasResult())
//			{
//				return false;
//			}
			DataBaseOperate oper=new DataBaseOperate();
			ResultAccess resAcc=new ResultAccess(oper);
			resAcc.updateResult(result);
			oper.CloseDataBase();
		}

		public DataSet getResultDetile(ExamResult result)
		{
			DataBaseOperate oper=new DataBaseOperate();
			ResultAccess resAcc=new ResultAccess(oper);
			DataSet ds=resAcc.getResultDetile(result);
			oper.CloseDataBase();
			return ds;
		}
		
		public bool insertResult(ExamResult result)
		{
			if(hasResult(result))
			{
				return false;
			}
			DataBaseOperate oper=new DataBaseOperate();
			ResultAccess resAcc=new ResultAccess(oper);
			resAcc.insertResult(result);
			oper.CloseDataBase();
			return true;
		}

		
		public DataSet getResult(ExamResult result)
		{
			DataBaseOperate oper=new DataBaseOperate();
			ResultAccess resAcc=new ResultAccess(oper);
			DataSet ds=resAcc.getResult(result);
			oper.CloseDataBase();
			return ds;
		}

		public void deleteResult(ExamResult result)
		{
			DataBaseOperate oper=new DataBaseOperate();
			ResultAccess resAcc=new ResultAccess(oper);
			resAcc.deleteResult(result);
			oper.CloseDataBase();
		}
	}
}