teachermanage.cs

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

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