teachermanage.cs

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

using System;
using System.Data;
using System.Data.SqlClient;
using ExamSystem.Common.Objects;
using ExamSystem.Common.DB;
namespace ExamSystem.DataAccess.TeacherAccess
{
	/// <summary>
	/// 老师管理的类
	/// </summary>
	public class TeacherManage
	{
		DataBaseOperate oper;
		/// <summary>
		/// 实例化班级数据访问对象
		/// </summary>
		/// <param name="dataBaseOperate">数据连接对象</param>
		public TeacherManage(DataBaseOperate dataBaseOperate)
		{
			oper=dataBaseOperate;
		}
		public Teacher login(Teacher tea)
		{
//			bool ret=false;
			string sql="select TeacherID,TeacherName from TeacherLogin where TeacherName=@name and TeacherPass=@pass";
			ParamList listParam=new ParamList();
			listParam.AddNew("@name",SqlDbType.VarChar,tea.TeaName);
			listParam.AddNew("@pass",SqlDbType.VarChar,tea.TeaPass);
			SqlDataReader reader=oper.Query(sql,listParam);
			if(reader.Read())
			{
				Teacher teacher=new Teacher();
				teacher.TeaID=Convert.ToInt32(reader["TeacherID"]);
				teacher.TeaName=reader["TeacherName"].ToString();
				return teacher;
			}
			return null;
		}
	}
}