studentsaccess.cs

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

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

		public Student login(Student stu)
		{
			string sql="select StuID,StuPass,StuClass,StuNumber,StuName,StuBirday,StuSex from StuLogin where isDel=0 and StuNumber=@StuNumber and StuPass=@StuPass and StuClass=@StuClass";
			ParamList listParam=new ParamList();
			listParam.AddNew("@StuNumber",SqlDbType.Int,stu.StuNum);
			listParam.AddNew("@StuPass",SqlDbType.VarChar,stu.StuPass);
			listParam.AddNew("@StuClass",SqlDbType.Int,stu.StuClass);
			SqlDataReader reader=oper.Query(sql,listParam);
			if(reader.Read())
			{
				Student retStu=new Student();
				retStu.StuID=(int)reader["StuID"];
				retStu.StuNum=(int)reader["StuNumber"];
				retStu.StuName=reader["StuName"].ToString();
				retStu.StuBirday=(DateTime)reader["StuBirday"];
				if(Convert.ToInt32(reader["StuSex"])==1)
				{
					retStu.StuSex=SearchBooleans.True;
				}
				else
				{
					retStu.StuSex=SearchBooleans.False;
				}
				retStu.StuPass=reader["StuPass"].ToString();
				retStu.StuClass=(int)reader["StuClass"];
				return retStu;
			}
			return null;
		}
	}
}