studentrule.cs

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

using System;
using ExamSystem.DataAccess.TeacherAccess;
using ExamSystem.Common.Objects;
using System.Data;
using ExamSystem.Common.DB;
namespace ExamSystem.BusinessRule.TeacherRule
{
	/// <summary>
	/// StudentRule 的摘要说明。
	/// </summary>
	public class StudentRule
	{
		public StudentRule()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		
		/// <summary>
		/// 获取一个班级里边的学生
		/// </summary>
		/// <param name="cls">班级</param>
		/// <returns></returns>
		public DataSet getStuByClass(Class cls)
		{
			DataBaseOperate oper=new DataBaseOperate();
			StudentManage stuMan=new StudentManage(oper);
			DataSet ds=stuMan.getStudentsByClass(cls);
			oper.CloseDataBase();
			return ds;
		}

		
		
		/// <summary>
		/// 判断这个班有没有相同学号的记录
		/// </summary>
		/// <param name="stu">学生对象</param>
		/// <returns></returns>
		private bool hasNum(Student stu)
		{
			if(stu.StuNum<0 || stu.StuClass<0)
			{
				return false;
			}
			Student tmpStu=new Student();
			tmpStu.StuNum=stu.StuNum;
			tmpStu.StuClass=stu.StuClass;
			DataBaseOperate oper=new DataBaseOperate();
			StudentManage stuMan=new StudentManage(oper);
			DataSet ds=stuMan.getStudent(tmpStu);
			oper.CloseDataBase();
			if(ds.Tables[0].Rows.Count>0)
			{
				return true;
			}
			return false;
		}

		/// <summary>
		/// 修改学生
		/// </summary>
		/// <param name="stu">要修改的学生对象</param>
		/// <returns></returns>
		public bool insertStudent(Student stu)
		{
			if(hasNum(stu))
			{
				return false;
			}
			DataBaseOperate oper=new DataBaseOperate();
			stu.StuPass="111111";//设置初始密码
			StudentManage stuMan=new StudentManage(oper);
			stuMan.insertStudent(stu);
			oper.CloseDataBase();
			return true;
		}

		/// <summary>
		/// 获取学生信息
		/// </summary>
		/// <param name="stu">学生对象</param>
		/// <returns></returns>
		public DataSet getStudent(Student stu)
		{
			
			DataBaseOperate oper=new DataBaseOperate();
			StudentManage stuMan=new StudentManage(oper);
			DataSet ds=stuMan.getStudent(stu);
			oper.CloseDataBase();
			return ds;
		}

		/// <summary>
		/// 更新学生成绩
		/// </summary>
		/// <param name="stu">学生对象</param>
		/// <returns></returns>
		public bool updateStudent(Student stu)
		{
			if(hasNum(stu))//判断这个班有没有这个学号存在
			{
				return false;
			}
			DataBaseOperate oper=new DataBaseOperate();
			StudentManage stuMan=new StudentManage(oper);
			stuMan.updateStudent(stu);
			oper.CloseDataBase();
			return true;
		}


		public void deleteStudent(Student stu)
		{
			DataBaseOperate oper=new DataBaseOperate();
			StudentManage stuMan=new StudentManage(oper);
			stuMan.delStudent(stu);
			oper.CloseDataBase();
		}

		public void deleteStudent(Grade grd)
		{
			DataBaseOperate oper=new DataBaseOperate();
			StudentManage stuMan=new StudentManage(oper);
			stuMan.delStudent(grd);
			oper.CloseDataBase();
		}
		
	}
}