cateaccess.cs

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

using System;
using System.Data;
using System.Data.SqlClient;
using ExamSystem.Common.Objects;
using ExamSystem.Common.DB;
using ExamSystem.Common;
namespace ExamSystem.DataAccess.ExamAccess
{
	/// <summary>
	/// CateAccess 的摘要说明。
	/// </summary>
	public class CateAccess
	{
		DataBaseOperate oper;
		/// <summary>
		/// 实例化考试数据访问对象
		/// </summary>
		/// <param name="dataBaseOperate">数据连接对象</param>
		public CateAccess(DataBaseOperate dataBaseOperate)
		{
			oper=dataBaseOperate;
		}

		/// <summary>
		/// 获取班级所有的科目
		/// </summary>
		/// <param name="cls"></param>
		/// <returns></returns>
		public DataSet getCate(Class cls)
		{
			string sql="select CateID,CateName,GradeID from Cate cate where Cate.isDel=0 and GradeID in(select Grade from Class where Class.Grade=cate.GradeID";
			ParamList pList=new ParamList();
			if(cls.ClassID>-1)
			{
				sql+=" and Class.ClassID=@ClassID";
				pList.AddNew("@ClassID",SqlDbType.Int,cls.ClassID);
			}
			
			if(cls.ClassName!="")
			{
				sql+=" and Class.ClassName=@ClassName";
				pList.AddNew("@ClassName",SqlDbType.VarChar,cls.ClassName);
			}
			
			if(cls.GradeID>-1)
			{
				sql+=" and Class.Grade=@Grade";
				pList.AddNew("@Grade",SqlDbType.Int,cls.GradeID);
			}
			sql+=") or Cate.CateID=0";
			DataSet ds=oper.Query(sql,"Cate",pList);
			return ds;
		}
		
		public DataSet getCate(Cate cate)
		{
			string sql="select CateID,CateName,GradeID from Cate where isDel=0";
			ParamList list=new ParamList();
			if(cate.CateID>0)
			{
				sql+=" and CateID=@CateID";
				list.AddNew("@CateID",SqlDbType.Int,cate.CateID);
			}
			if(cate.CateName!="")
			{
				sql+=" and CateName=@CateName";
				list.AddNew("@CateName",SqlDbType.VarChar,cate.CateName);
			}
			if(cate.GradeID>=0)
			{
				sql+=" and GradeID=@GradeID";
				list.AddNew("@GradeID",SqlDbType.Int,cate.GradeID);
			}

			DataSet ds=oper.Query(sql,"Cate",list);
			return ds;
		}

		public void insertCate(Cate cate)
		{
			string sql="insert into Cate(CateName,GradeID) values(@CateName,@GradeID)";
			ParamList list=new ParamList();
			list.AddNew("@CateName",SqlDbType.VarChar,cate.CateName);
			list.AddNew("@GradeID",SqlDbType.Int,cate.GradeID);
			oper.Execute(sql,list);
		}

		public void updateCate(Cate cate)
		{
			string sql="update Cate set isDel=0";

			ParamList list=new ParamList();
			if(cate.CateName!="")
			{
				sql+=",CateName=@CateName";
				list.AddNew("@CateName",SqlDbType.VarChar,cate.CateName);
			}
			if(cate.GradeID>=0)
			{
				sql+=",GradeID=@GradeID";
				list.AddNew("@GradeID",SqlDbType.Int,cate.GradeID);
			}
			sql+="where CateID=@CateID";
//			list.AddNew("@CateName",SqlDbType.VarChar,cate.CateName);
			list.AddNew("@CateID",SqlDbType.Int,cate.CateID);
			oper.Execute(sql,list);
		}


		public void deleteCate(Cate cate)
		{
			string sql="update Cate set isDel=1 where isDel=0";
			ParamList list=new ParamList();
			
			if(cate.CateID>0)
			{
				sql+=" and CateID=@CateID";
				list.AddNew("@CateID",SqlDbType.Int,cate.CateID);
			} 
			if(cate.CateName!="")
			{
				sql+=" and CateName=@CateName";
				list.AddNew("@CateName",SqlDbType.VarChar,cate.CateName);
			}
			if(cate.GradeID>=0)
			{
				sql+=",GradeID=@GradeID";
				list.AddNew("@GradeID",SqlDbType.Int,cate.GradeID);
			}
			oper.Execute(sql,list);
		}

	}
}