student1.cs

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

            //在岗位申请表里添加以下三个字段
             /*StuID:学生学号
             * StationID 岗位编号
             * ApplyStation：申请岗位个人陈述；
             * 
             * */
            StationApplyEntity saEty = new StationApplyEntity();
            saEty.StuID = StuID;
            saEty.StationID = StationID;
            saEty.ApplyStation = ApplyStation;
            try
            {
                if (saEty.Save() > 0)
                {
                    return true;
                }
                return false;
            }
            catch
            {
                return false; 
            }
        }
        public static bool DeleteHelpTeacherApply(string StuID, int StationID)
        {
            //已经知道数据库中存在该学生申请的一个岗位
            //这里直接删除无须判断是否存在；
            //删除成功return true;
            //删除失败 return false
            DeleteCriteria dc = new DeleteCriteria(typeof(StationApplyEntity));
            Condition cd = dc.GetNewCondition();
            cd.AddEqualTo(StationApplyEntity.__STUID, StuID);
            cd.AddEqualTo(StationApplyEntity.__STATIONID, StationID);
            try
            {
                if (dc.Perform() > 0)
                {
                    return true;
                }
                return false;
            }
            catch
            {
                return false;
            }

        }
        public static DataRow  GetTheDetailInfoFromStationInfo(int StationID)
        {
            //返回StationID对应的详细信息DataRow中包含以下字段
            //StationID，StationName，StationDescrip，IsApplied2，Remark
            //如果没有找到StationID返回null
            //
            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;
        }
        public static DataTable GetAllFromStationApplySuccess(string StuID)
        {
            //获取所有的助教岗位申请成功的记录IsChecked为1就是成功
            //DataTable中必须有以下几个字段
            //StationID,StationName
            //如果没有找到返回return null;
            ////int stationID;
            ////RetrieveCriteria rc = new RetrieveCriteria(typeof(StationApplyEntity));
            ////Condition cd = rc.GetNewCondition();
            ////cd.AddEqualTo(StationApplyEntity.__STUID, StuID);
            ////cd.AddEqualTo(StationApplyEntity.__ISCHECKED, 1);
            ////rc.AddSelect(StationApplyEntity.__STATIONID);
            ////DataTable dt=rc.AsDataTable();
            DataTable dt;
            string sqlString="select StationInfo.StationID,StationInfo.StationName from StationInfo , StationApply";
            sqlString = sqlString + " where StationApply.StuID='" + StuID + "' and StationApply.IsChecked=1 ";
            sqlString=sqlString+"and StationInfo.StationID=StationApply.StationID";
            try
            {
            dt=Query.ProcessSql(sqlString,"GradMIS_Data");
            

                if (dt.Rows.Count > 0)
                {
                    return dt;
                }
                return null;
            }
            catch
            {
                return null;
            }
        }
        public static DataTable GetAllFromStationApplyFailure(string StuID)
        {
            //获取所有的助教岗位申请成功的记录IsChecked为２就是失败
            //DataTable中必须有以下几个字段
            //StationID,StationName
            //如果没有找到返回return null;
            DataTable dt;
            string sqlString = "select StationInfo.StationID,StationInfo.StationName from StationInfo ,StationApply";
            sqlString = sqlString + " where StationApply.StuID='" + StuID + "' and StationApply.IsChecked=2 ";
            sqlString = sqlString + "and StationInfo.StationID=StationApply.StationID";
            try
            {
            dt = Query.ProcessSql(sqlString, "GradMIS_Data");
            

                if (dt.Rows.Count > 0)
                {
                    return dt;
                }
                return null;
            }
            catch
            {
                return null;
            }

        }
        public static DataTable  GetAllFromStationApplyDoing(string StuID)
        {
            //获取所有的助教岗位申请成功的记录IsChecked为0就是正在审查中
            //DataTable中必须有以下几个字段
            //StationID,StationName
            //如果没有找到返回return null;
            DataTable dt;
            string sqlString = "select StationInfo.StationID,StationInfo.StationName from StationInfo , StationApply";
            sqlString = sqlString + " where StationApply.StuID='"+StuID +"'and StationApply.IsChecked=0 ";
            sqlString = sqlString + "and StationInfo.StationID=StationApply.StationID";
            try
            {
             dt = Query.ProcessSql(sqlString, "GradMIS_Data");
            
                if (dt.Rows.Count > 0)
                {
                    return dt;
                }
                return null;
            }
            catch
            {
                return null;
            }

        }
        public static bool IsReStudyCourseValid()
        {
            //如果存在有效的项目即Enable值有效
            //return true
            //否则返回return false
            RetrieveCriteria rc = new RetrieveCriteria(typeof(ReStudyCourseEntity));
            Condition cd = rc.GetNewCondition();
            cd.AddEqualTo(ReStudyCourseEntity.__ENABLE, 1);
            DataTable dt = rc.AsDataTable();
            if (dt.Rows.Count > 0)
            {
                return true;
            }
            return false;
        }
        public static DataTable GetReStudyCourseValid()
        {
            //返回所有的还可以选择的补修课程项目
            //DataTable 中必须含有以下几个字段
            //从本科课程表中至少返回以下几个字段
            /*ReStudyCourseID
            * CourseID
            * CourseName
            * CourseID
            * Teacher
            * */
            RetrieveCriteria rc = new RetrieveCriteria(typeof(ReStudyCourseEntity));
            Condition cd = rc.GetNewCondition();
            cd.AddEqualTo(ReStudyCourseEntity.__ENABLE, 1);
            DataTable dt = rc.AsDataTable();
            if (dt.Rows.Count > 0)
            {
                return dt;
            }
            return null;
        }
        public static bool HasStuAppliedReStudyCourse(string StuID, int ReStudyCourseID)
        {
            //判断学生学号为：StuID的学生是否已经选择了了序列号为ReStudyCourseID的本科课程补修项目
            //如果已经申请return true;
            //否则返回return false;
            RetrieveCriteria rc = new RetrieveCriteria(typeof(RestStudyListEntity));
            Condition cd = rc.GetNewCondition();
            cd.AddEqualTo(RestStudyListEntity.__STUID, StuID);
            cd.AddEqualTo(RestStudyListEntity.__RESTUDYCOURSEID, ReStudyCourseID);
            DataTable dt = rc.AsDataTable();
            if (dt.Rows.Count > 0)
            {
                return true;
            }
            return false;

        }
        public static bool SetRestStudyApply(string StuID, int ReStudyCourseID)
        {
            //在教学实践申请表里添加一条记录，添加的是这２个字段。
            /*StuID:学生学号
            * ReStudyCourseID 课程序列号为补修表里的主键；
            * 成功return true;
             * else return false;
            * */
            RestStudyListEntity rsEty = new RestStudyListEntity();
            rsEty.StuID = StuID;
            rsEty.ReStudyCourseID = ReStudyCourseID;
            if (rsEty.Save() > 0)
            {
                return true;
            }
            return false;
        }
        public static bool DeleteRestStudyApply(string StuID, int ReStudyCourseID)
        {
            //已经知道数据库中存在该学生选择了这个补修课程
            //这里直接删除无须判断是否存在；
            //删除成功return true;
            //删除失败 return false
            DeleteCriteria dc = new DeleteCriteria(typeof(RestStudyListEntity));
            Condition cd = dc.GetNewCondition();
            cd.AddEqualTo(RestStudyListEntity.__STUID, StuID);
            cd.AddEqualTo(RestStudyListEntity.__RESTUDYCOURSEID, ReStudyCourseID);
            if (dc.Perform() > 0)
            {
                return true;
            }
            return false;
        }

	}
    
}