classman.cs

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

using System;
using System.Data;
using System.Data.SqlClient;
using ExamSystem.Common.Objects;
using ExamSystem.Common.DB;

namespace ExamSystem.DataAccess.TeacherAccess
{
	/// <summary>
	/// ClassMan 的摘要说明。
	/// </summary>
	public class ClassMan
	{
		DataBaseOperate oper;
		/// <summary>
		/// 实例化班级数据访问对象
		/// </summary>
		/// <param name="dataBaseOperate">数据连接对象</param>
		public ClassMan(DataBaseOperate dataBaseOperate)
		{
			oper=dataBaseOperate;
		}

		/// <summary>
		/// 查找班级
		/// </summary>
		/// <param name="cls">要查找的班级条件</param>
		/// <returns></returns>
		public DataSet getClasses(Class cls)
		{
			string sql="select * from Class where isDel=0";
			ParamList pList=new ParamList();
			if(cls.ClassID>-1)
			{
				sql+=" and ClassID=@ClassID";
				pList.AddNew("@ClassID",SqlDbType.Int,cls.ClassID);
			}
			
			if(cls.ClassName!="")
			{
				sql+=" and ClassName=@ClassName";
				pList.AddNew("@ClassName",SqlDbType.VarChar,cls.ClassName);
			}
			
			if(cls.GradeID>-1)
			{
				sql+=" and Grade=@Grade";
				pList.AddNew("@Grade",SqlDbType.Int,cls.GradeID);
			}
			DataSet ds=oper.Query(sql,"Class",pList);
			return ds;
		}
		
		public void updateClass(Class cls)
		{
			string sql="update Class set isDel=0";
			ParamList list=new ParamList();

			if(cls.ClassName!="")
			{
				sql+=",ClassName=@ClassName";
				list.AddNew("@ClassName",SqlDbType.VarChar,cls.ClassName);
			}

			if(cls.GradeID>=0)
			{
				sql+=",Grade=@Grade";
				list.AddNew("@Grade",SqlDbType.Int,cls.GradeID);
			}

			sql+=" where ClassID=@ClassID";
			list.AddNew("@ClassID",SqlDbType.Int,cls.ClassID);
			oper.Execute(sql,list);
		}
		
		/// <summary>
		/// 删除班级
		/// </summary>
		/// <param name="cls">班级对象</param>
		public void deleteClass(Class cls)
		{
			string sql="update Class set isDel=1 where isDel=0";
			ParamList pList=new ParamList();
			
			if(cls.ClassID>-1)
			{
				sql+=" and ClassID=@ClassID";
				pList.AddNew("@ClassID",SqlDbType.Int,cls.ClassID);
			}
			
			if(cls.ClassName!="")
			{
				sql+=" and ClassName=@ClassName";
				pList.AddNew("@ClassName",SqlDbType.VarChar,cls.ClassName);
			}
			
			if(cls.GradeID>-1)
			{
				sql+=" and Grade=@Grade";
				pList.AddNew("@Grade",SqlDbType.Int,cls.GradeID);
			}
			oper.Execute(sql,pList);
		}

		/// <summary>
		/// 插入班级
		/// </summary>
		/// <param name="cls">要插入的班级对象</param>
		public void insertClass(Class cls)
		{
			string sql="insert into Class(ClassName,Grade) values(@ClassName,@Grade)";
			ParamList list=new ParamList();
			list.AddNew("@ClassName",SqlDbType.VarChar,cls.ClassName);
			list.AddNew("@Grade",SqlDbType.Int,cls.GradeID);
			oper.Execute(sql,list);
		}
	}
}