grademanager.cs

来自「考试管理系统CS架构 不需更多说明」· CS 代码 · 共 92 行

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);
		}
	}
}