topicrule.cs

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

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

		/// <summary>
		/// 修改试题
		/// </summary>
		/// <param name="top">要修改的试题对象</param>
		/// <returns></returns>
		public void updateTopic(Topics top)
		{
			DataBaseOperate oper=new DataBaseOperate();
			TopicsAccess topAcc=new TopicsAccess(oper);
			topAcc.updateTopics(top);
			oper.CloseDataBase();
		}

		/// <summary>
		/// 插入试题
		/// </summary>
		/// <param name="top">要插入的试题对象</param>
		/// <returns></returns>
		public void insertTopic(Topics top)
		{
			DataBaseOperate oper=new DataBaseOperate();
			TopicsAccess topAcc=new TopicsAccess(oper);
			topAcc.insertTops(top);
			oper.CloseDataBase();
		}

		/// <summary>
		/// 获取试题信息,用And方式
		/// </summary>
		/// <param name="top">试题对象</param>
		/// <returns></returns>
		public DataSet getTopicByAnd(Topics top,SearchType type)
		{
			
			DataBaseOperate oper=new DataBaseOperate();
			TopicsAccess topAcc=new TopicsAccess(oper);
			DataSet ds=topAcc.selectTopicsByAnd(top,type);
			oper.CloseDataBase();
			return ds;
		}

		/// <summary>
		/// 获取试题信息,用Or方式
		/// </summary>
		/// <param name="top">试题对象</param>
		/// <returns></returns>
		public DataSet getTopicByOr(Topics top,SearchType type)
		{
			
			DataBaseOperate oper=new DataBaseOperate();
			TopicsAccess topAcc=new TopicsAccess(oper);
			DataSet ds=topAcc.selectTopicsByOr(top,type);
			oper.CloseDataBase();
			return ds;
		}

		/// <summary>
		/// 删除试题
		/// </summary>
		/// <param name="top">要删除试题的对象</param>
		/// <returns></returns>
		public void deleteTopic(Topics top)
		{
			DataBaseOperate oper=new DataBaseOperate();
			TopicsAccess topAcc=new TopicsAccess(oper);
			topAcc.deleteTopics(top);
			oper.CloseDataBase();
		}

		public DataSet selectTopicID(Class cls)
		{
			DataBaseOperate oper=new DataBaseOperate();
			TopicsAccess topAcc=new TopicsAccess(oper);
			DataSet ds=topAcc.selectTopicsID(cls);
			oper.CloseDataBase();
			return ds;
		}

		public DataSet selectTopicID(Exam exam)
		{
			DataBaseOperate oper=new DataBaseOperate();
			TopicsAccess topAcc=new TopicsAccess(oper);
			DataSet ds=topAcc.selectTopicsID(exam);
			oper.CloseDataBase();
			return ds;
		}
		public DataSet getTopicByIDs(ArrayList idList)
		{
			string ids="";
			for(int i=0;i<idList.Count;i++)
			{
				ids+=idList[i].ToString();
				if(i<idList.Count-1)
				{
					ids+=",";
				}
			}
			DataBaseOperate oper=new DataBaseOperate();
			TopicsAccess topAcc=new TopicsAccess(oper);
			DataSet ds=topAcc.getTopicByIDs(ids);
			oper.CloseDataBase();
			return ds;
		}
	}
}