studentmanage.cs

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

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>
	/// StudentManage 的摘要说明。
	/// </summary>
	public class StudentManage
	{
		DataBaseOperate oper;

		/// <summary>
		/// 实例化学生数据访问对象
		/// </summary>
		/// <param name="dataBaseOperate">数据连接对象</param>
		public StudentManage(DataBaseOperate dataBaseOperate)
		{
			oper=dataBaseOperate;
		}

		/// <summary>
		/// 根据班级查找该学生
		/// </summary>
		/// <param name="cls">班级  </param>
		/// <returns></returns>
		public DataSet getStudentsByClass(Class cls)
		{
			string sql="select StuID,StuNumber,StuName,StuBirday,StuSex from StuLogin,Class where Class.isDel=0 and Class.ClassID=StuLogin.StuClass";
			ParamList pList=new ParamList();
			if(cls.ClassID>-1)
			{ 
				sql+=" and Class.ClassID=@ClassID";
				pList.AddNew("@ClassID",SqlDbType.Int,cls.ClassID);
			}

			if(cls.ClassName!="")
			{
				sql+=" and Class.ClassName=@ClassName";
				pList.AddNew("@ClassName",SqlDbType.VarChar,cls.ClassName);
			}

			sql+=" and StuLogin.isDel=0";
			DataSet ds=oper.Query(sql,"Student",pList);
			
			return ds;
		}

		

		public void insertStudent(Student stu)
		{
			string sql="insert into StuLogin(StuNumber,StuName,StuPass,StuClass,StuBirday,StuSex";
			if(stu.StuPic!=null)
			{
				sql+=",StuPic";
			}
			if(stu.StuRemark!="")
			{
				sql+=",StuRemark";
			}
			sql+=")";
			ParamList list=new ParamList();
			sql+="values(@StuNumber,@StuName,@StuPass,@StuClass,@StuBirday,@StuSex";
			list.AddNew("@StuNumber",SqlDbType.Int,stu.StuNum);
			list.AddNew("@StuName",SqlDbType.VarChar,stu.StuName);
			list.AddNew("@StuPass",SqlDbType.VarChar,stu.StuPass);
			list.AddNew("@StuClass",SqlDbType.Int,stu.StuClass);
			list.AddNew("@StuBirday",SqlDbType.DateTime,stu.StuBirday);
			list.AddNew("@StuSex",SqlDbType.Bit,(int)stu.StuSex);
			if(stu.StuPic!=null)
			{
				sql+=",@StuPic";
				list.AddNew("@StuPic",SqlDbType.Image,stu.StuPic);
			}
			if(stu.StuRemark!="")
			{
				sql+=",@StuRemark";
				list.AddNew("@StuRemark",SqlDbType.VarChar,stu.StuRemark);
			}
			sql+=")";
			
			oper.Execute(sql,list);
		}

		public DataSet getStudent(Student stu)
		{
			string sql="select StuID,StuNumber,StuName,StuBirday,StuSex from StuLogin where isDel=0";
			ParamList pList=new ParamList();
			if(stu.StuID>-1)
			{ 
				sql+=" and StuID=@stuID";
				pList.AddNew("@stuID",SqlDbType.Int,stu.StuID);
			}

			if(stu.StuNum>=0)
			{ 
				sql+=" and StuNumber=@StuNumber";
				pList.AddNew("@StuNumber",SqlDbType.Int,stu.StuNum);
			}

			if(stu.StuName!="")
			{
				sql+=" and StuName=@StuName";
				pList.AddNew("@StuName",SqlDbType.VarChar,stu.StuName);
			}

			if(stu.StuClass>=0)
			{
				sql+=" and StuClass=@StuClass";
				pList.AddNew("@StuClass",SqlDbType.Int,stu.StuClass);
			}

			if(stu.StuBirday!=DateTime.MinValue)
			{
				sql+=" and StuBirday=@StuBirday";
				pList.AddNew("@StuBirday",SqlDbType.DateTime,stu.StuBirday);
			}

			
			if(stu.StuSex!=SearchBooleans.NULL)
			{
				sql+=" and StuSex=@StuSex";
				pList.AddNew("@StuSex",SqlDbType.Bit,(int)stu.StuSex);
			}

			sql+=" and isDel=0";
			DataSet ds=oper.Query(sql,"Student",pList);
			return ds;
		}
		
		/// <summary>
		/// 更新学生
		/// </summary>
		/// <param name="stu">要更新的学生对象</param>
		public void updateStudent(Student stu)
		{
			string sql="update StuLogin set isDel=0";
			ParamList list=new ParamList();
			if(stu.StuNum>=0)
			{
				sql+=",StuNumber=@StuNumber";
				list.AddNew("@StuNumber",SqlDbType.Int,stu.StuNum);
			}

			if(stu.StuName!="")
			{
				sql+=",StuName=@StuName";
				list.AddNew("@StuName",SqlDbType.VarChar,stu.StuName);
			}

			if(stu.StuClass>=0)
			{
				sql+=",StuClass=@StuClass";
				list.AddNew("@StuClass",SqlDbType.Int,stu.StuClass);
			}

			if(stu.StuPass!="")
			{
				sql+=",StuPass=@StuPass";
				list.AddNew("@StuPass",SqlDbType.VarChar,stu.StuPass);
			}

			if(stu.StuBirday!=DateTime.MinValue)
			{
				sql+=",StuBirday=@StuBirday";
				list.AddNew("@StuBirday",SqlDbType.DateTime,stu.StuBirday);
			}

			if(stu.StuSex!=SearchBooleans.NULL)
			{
				sql+=",StuSex=@StuSex";
				list.AddNew("@StuSex",SqlDbType.Bit,(int)stu.StuSex);
			}

			if(stu.StuPic!=null)
			{
				sql+=",StuPic=@StuPic";
				list.AddNew("@StuPic",SqlDbType.Image,stu.StuPic);
			}

			if(stu.StuRemark!="")
			{
				sql+=",StuRemark=@StuRemark";
				list.AddNew("@StuRemark",SqlDbType.VarChar,stu.StuRemark);
			}

			sql+=" where StuID=@StuID";
			list.AddNew("@StuID",SqlDbType.Int,stu.StuID);
			oper.Execute(sql,list);
		}
		
		/// <summary>
		/// 删除学生
		/// </summary>
		/// <param name="stu">要删除的学生</param>
		public void delStudent(Student stu)
		{
			string sql="update StuLogin set isDel=1 where isDel=0";
			ParamList pList=new ParamList();
			if(stu.StuID>-1)
			{ 
				sql+=" and StuID=@stuID";
				pList.AddNew("@stuID",SqlDbType.Int,stu.StuID);
			}

			if(stu.StuNum>=0)
			{ 
				sql+=" and StuNumber=@StuNumber";
				pList.AddNew("@StuNumber",SqlDbType.Int,stu.StuNum);
			}

			if(stu.StuName!="")
			{
				sql+=" and StuName=@StuName";
				pList.AddNew("@StuName",SqlDbType.VarChar,stu.StuName);
			}

			if(stu.StuClass>=0)
			{
				sql+=" and StuClass=@StuClass";
				pList.AddNew("@StuClass",SqlDbType.Int,stu.StuClass);
			}

			if(stu.StuBirday!=DateTime.MinValue)
			{
				sql+=" and StuBirday=@StuBirday";
				pList.AddNew("@StuBirday",SqlDbType.DateTime,stu.StuBirday);
			}

			
			if(stu.StuSex!=SearchBooleans.NULL)
			{
				sql+=" and StuSex=@StuSex";
				pList.AddNew("@StuSex",SqlDbType.Bit,(int)stu.StuSex);
			}
			oper.Execute(sql,pList);
		}

		/// <summary>
		/// 删除学生
		/// </summary>
		/// <param name="grd">要删除学生所对应的班级</param>
		public void delStudent(Grade grd)
		{
			string sql="update StuLogin set isDel=1 where isDel=0 and StuClass in (select ClassID from Class where Grade=@Grade)";
			ParamList list=new ParamList();
			list.AddNew("@Grade",SqlDbType.Int,grd.GradeID);
			oper.Execute(sql,list);
		}


		
	}
}