studentsaccess.cs

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

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