student1.cs

一个研究生管理系统 具体的情况自己看了

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using PersistenceLayer;
using BusinessEntity;

/// <summary>
/// Student1 的摘要说明
/// </summary>
namespace Student
{
    public partial class Student
    {	//
		// TODO: 在此处添加构造函数逻辑
		//

        public static  DataTable GetTeacherPratiseValid()
        {
            //返回所有的还可以填写申请的教学实践项目
            //DataTable 中必须含有以下几个字段
            //从本科课程表中至少返回以下几个字段
            /*UnderCourseID
            * TeaClassID
            * CourseName
            * CourseID
            * Teacher
            * */
            RetrieveCriteria rc = new RetrieveCriteria(typeof(UndergraduateCourseEntity));
            Condition cd = rc.GetNewCondition();
            cd.AddEqualTo(UndergraduateCourseEntity.__ENABLE, 1);
            DataTable dt=rc.AsDataTable();
            if(dt.Rows.Count>0)
            {
                return dt;
            }
            return null;
        }

        public static bool IsUndergraduateCourseValid()
        {
           //如果存在有效的项目即Enable值有效
            //return true
            //否则返回return false
            RetrieveCriteria rc = new RetrieveCriteria(typeof(UndergraduateCourseEntity));
            Condition cd = rc.GetNewCondition();
            cd.AddEqualTo(UndergraduateCourseEntity.__ENABLE, 1);
            DataTable dt = rc.AsDataTable();
            if (dt.Rows.Count > 0)
            {
                return true;
            }
            return false;
        }
        public static bool IsUnderCourseIDValid(int UnderCourseID)
        {
            //在本科课程表中是否存在该课程
            //如果存在返回true;
            //如果不存在返回false
            RetrieveCriteria rc = new RetrieveCriteria(typeof(UndergraduateCourseEntity));
            Condition cd = rc.GetNewCondition();
            cd.AddEqualTo(UndergraduateCourseEntity.__UNDERCOURSEID, UnderCourseID);
            DataTable dt = rc.AsDataTable();
            if (dt.Rows.Count > 0)
            {
                return true;
            }
            return false;
        }
        public static string GetTeacherPhoneFromUndergraduateCourse(string UnderCoureID)
        {
            //返回该本科课程表中本科课程号对应的老师的电话号码；
            string phoneNum;
            RetrieveCriteria rc = new RetrieveCriteria(typeof(UndergraduateCourseEntity));
            Condition cd = rc.GetNewCondition();
            cd.AddEqualTo(UndergraduateCourseEntity.__UNDERCOURSEID, UnderCoureID);
            UndergraduateCourseEntity ucEty = (UndergraduateCourseEntity)rc.AsEntity();
            if (ucEty != null)
            {
                phoneNum = ucEty.TeacherPhone.ToString();
                return phoneNum;
            }
            return "";
        }
        public static bool SetTeachPracApply(string StuID, int UnderCourseID, string TeacherPhone)
        {
            //在教学实践申请表里添加一条记录，添加的是这三个字段。
             /*StuID:学生学号
             * UnderCourseID 本科课程表里的主键；
             * TeacherPhone：教师电话；
             * 
             * */
            int i;
            TeachPracApplyEntity tpae = new TeachPracApplyEntity();
            tpae.StuID = StuID;
            tpae.UnderCourseID = UnderCourseID;
            tpae.TeacherPhone = TeacherPhone;
            i=tpae.Save();
            if (i > 0)
            {
                return true;
            }
            return false;
        }
        public static bool HasStuAppliedTeachPrac(string StuID, string UnderCourseID)
        {
            //判断学生学号为：StuID的学生是否已经申请了本科课程号为UnderCourseID
            //如果已经申请return true;
            //否则返回return false;
            RetrieveCriteria rc = new RetrieveCriteria(typeof(TeachPracApplyEntity));
            Condition cd = rc.GetNewCondition();
            cd.AddEqualTo(TeachPracApplyEntity.__STUID,StuID);
            cd.AddEqualTo(TeachPracApplyEntity.__UNDERCOURSEID,UnderCourseID);
            DataTable dt=rc.AsDataTable();
            if(dt.Rows.Count>0)
            {
                return true;
            }
            return false;

        }
        public static bool DeleteTeachPracApply(string StuID, string UnderCourseID)
        {
            //删除已经知道数据库中存在该学生申请的一个课程
            //这里直接删除无须判断是否存在；
            //删除成功return true;
            //删除失败 return false
            DeleteCriteria dc = new DeleteCriteria(typeof(TeachPracApplyEntity));
            Condition cd = dc.GetNewCondition();
            cd.AddEqualTo(TeachPracApplyEntity.__STUID, StuID);
            cd.AddEqualTo(TeachPracApplyEntity.__UNDERCOURSEID,UnderCourseID);
            if(dc.Perform()>0)
            {
                return true;
            }
            return false;

        }
        public static DataRow GetTheDetailInfoFromUndergraduateCourse(string UnderCourseID)
        {
            //返回UnderCourseID对应的详细信息DataRow中包含所有的字段
            //如果没有找到UnderCourseID返回null
            //
            RetrieveCriteria rc = new RetrieveCriteria(typeof(UndergraduateCourseEntity));
            Condition cd = rc.GetNewCondition();
            cd.AddEqualTo(UndergraduateCourseEntity.__UNDERCOURSEID, UnderCourseID);
            DataTable dt = rc.AsDataTable();
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0];
            }
            return null;
        }
        public static bool IsStationIfoValid()
        {
            //岗位信息表里的数据是否存在有效的信息，没有过时的信息：
            //如果存在就return true;
            //否则返回return false;
            RetrieveCriteria rc = new RetrieveCriteria(typeof(StationInfoEntity));
            Condition cd = rc.GetNewCondition();
            rc.AddSelect(StationInfoEntity.__ENABLE);
            DataTable dt = rc.AsDataTable();
            foreach (DataRow type in dt.Rows)
            {
                if((int)type["Enable"]==1)
                {
                    return true;
                }
            }
            return false;
        }
        public static DataTable GetHelpTeacherInfo()
        {
            
            //获取所有的助教岗位信息，包括
            //岗位名称，岗位编号，和是否被申请（当前申请人数）
            //对应的字段分别为：StationID,StationName,IsApplied2

            //所返回的DataTable中必须含有这三个字段
            //注意返回的必须是有效的岗位信息,也就是说可以被人申请的，还没有公布结果的岗位信息
            //如果没有找到return null;
            RetrieveCriteria rc = new RetrieveCriteria(typeof(StationInfoEntity));
            Condition cd = rc.GetNewCondition();
            cd.AddEqualTo(StationInfoEntity.__ENABLE, 1);
            rc.AddSelect(StationInfoEntity.__STATIONID);
            rc.AddSelect(StationInfoEntity.__STATIONNAME);
            rc.AddSelect(StationInfoEntity.__ISAPPLIED2);
            DataTable dt = rc.AsDataTable();
            if (dt.Rows.Count > 0)
            {
                return dt;
            }
            return null;
        }
        public static DataRow GetSingleHelpTeacherDetailInfo(int StationID)
        {
            //根据StationID返回该岗位的详细信息，
            //必须包含以下字段；
            /*
             * StationID：岗位编号
             * StationName：岗位名称：
             * StationDescrip：岗位描述
             * IsApplied2：是否被申请（当前申请人数）
             * Remark：备注
             * */
            RetrieveCriteria rc = new RetrieveCriteria(typeof(StationInfoEntity));
            Condition cd = rc.GetNewCondition();
            cd.AddEqualTo(StationInfoEntity.__STATIONID, StationID);
            DataTable dt = rc.AsDataTable();
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0];
            }
            //如果没有找到返回return null;
            return null;
        }
        public static bool HasStuAppliedHelpTeacher(string StuID, int  StationID)
        {
            //判断学生学号为：StuID的学生是否已经申请了助教岗位
            //如果已经申请return true;
            //否则返回return false;
            RetrieveCriteria rc = new RetrieveCriteria(typeof(StationApplyEntity));
            Condition cd=rc.GetNewCondition();
            cd.AddEqualTo(StationApplyEntity.__STUID,StuID);
            cd.AddEqualTo(StationApplyEntity.__STATIONID,StationID);
            cd.AddEqualTo(StationApplyEntity.__ISCHECKED, 0);

            DataTable dt=rc.AsDataTable();
            if(dt.Rows.Count>0)
            {
                return true;
            }
            return false;
        }
       
        public static bool SetHelpTeacherApply(string StuID, int  StationID, string ApplyStation)
        {