grademanager.cs

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

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

namespace ExamSystem.DataAccess.TeacherAccess
{
	/// <summary>
	/// GradeManager 的摘要说明。
	/// </summary>
	public class GradeManager
	{
		DataBaseOperate oper;

		/// <summary>
		/// 实例化年级数据访问对象
		/// </summary>
		/// <param name="dataBaseOperate">数据连接对象</param>
		public GradeManager(DataBaseOperate dataBaseOperate)
		{
			oper=dataBaseOperate;
		}
		

		public DataSet getGrades(Grade grd)
		{
			string sql="select * from Grade where isDel=0";
			ParamList pList=new ParamList();
			if(grd.GradeID>-1)
			{
				sql+=" and GradeID=@GradeID";
				pList.AddNew("@GradeID",SqlDbType.Int,grd.GradeID);
			}
			if(grd.GradeName!="")
			{
				sql+=" and GradeName=@GradeName";
				pList.AddNew("@GradeName",SqlDbType.VarChar,grd.GradeName);
			}
			DataSet ds=oper.Query(sql,"Grade",pList);
			return ds;
		}

		public void updateGrades(Grade grd)
		{
			string sql="update Grade set isDel=0";
			ParamList list=new ParamList();

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

			sql+=" where GradeID=@GradeID";
			list.AddNew("@GradeID",SqlDbType.Int,grd.GradeID);
			oper.Execute(sql,list);
		}

		public void deleteGrade(Grade grd)
		{
			string sql="update Grade set isDel=1 where isDel=0";
			ParamList pList=new ParamList();
			if(grd.GradeID>-1)
			{
				sql+=" and GradeID=@GradeID";
				pList.AddNew("@GradeID",SqlDbType.Int,grd.GradeID);
			}
			if(grd.GradeName!="")
			{
				sql+=" and GradeName=@GradeName";
				pList.AddNew("@GradeName",SqlDbType.VarChar,grd.GradeName);
			}
			
			oper.Execute(sql,pList);
		}

		/// <summary>
		/// 插入年级
		/// </summary>
		/// <param name="grd">要插入的年级对象</param>
		public void insertGrade(Grade grd)
		{
			string sql="insert into Grade(GradeName) values(@GradeName)";
			ParamList list=new ParamList();
			list.AddNew("@GradeName",SqlDbType.VarChar,grd.GradeName);
			oper.Execute(sql,list);
		}
	}
}