student2.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>
/// student2 的摘要说明
/// </summary>
namespace Student
{
    public partial class Student
    {	//
		//
		// TODO: 在此处添加构造函数逻辑
	
        //
        public static DataTable GetTeachPratiseSuccess_Doing_Failure_Current(string StuID)
        {//返回学号为：StuID的学生的所申请的所有成功的和正在评定的和失败的教学实践，并且所选择的教学实践的课程必须是有效的，
            //也就是说课程的Enable必须是有效的。
            //必须包含以下字段
            //UnderCourseID本科课程id
            //CourseID课程id
            //CourseName课程名称
            //Teacher教师
            //TeaClassID班号
            //IsChecked
            //如果没有成功return null;
            string SqlString = "select UndergraduateCourse.*,TeachPracApply.IsChecked from TeachPracApply,UndergraduateCourse where UndergraduateCourse.Enable=1";
            SqlString = SqlString + " and TeachPracApply.UnderCourseID=UndergraduateCourse.UnderCourseID and TeachPracApply.StuID='" + StuID.ToString()+"'";
            DataTable dt = new DataTable();
            dt = Query.ProcessSql(SqlString, "GradMIS_Data");
            if (dt.Rows.Count > 0)
            {
                return dt;
            }
            return null;

            

        }
        public static DataRow GetTheDetailInfoFromUndergraduateCourseandTeachPracApply(string StuID, int UnderCourseID)
        {//返回学生StuID所申请的教学实践课程号为：UnderCourseID的详细信息：
            //返回的DataRow中必须包含以下字段：
            //TeachPracApply.Remark as TPARemark,
            //UndergraduateCourse.Remark as UnGCRemark,
            //UnderCourseID,TeaClassID,CourseID,CourseName,CourseType,Teacher,TeacherPhone,ClassDate,ClassAddress,ClassWeeks,Term,IsApplied
            //如果没有成功return null;
            string SqlString = "select TeachPracApply.Remark as TPARemark,UndergraduateCourse.Remark as UnGCRemark,UndergraduateCourse.*";
            SqlString = SqlString + " from TeachPracApply,UndergraduateCourse where TeachPracApply.StuID='" + StuID.ToString()+"'";
            SqlString = SqlString + " and TeachPracApply.UnderCourseID=" + UnderCourseID.ToString();
            SqlString = SqlString + " and TeachPracApply.UnderCourseID=UndergraduateCourse.UnderCourseID";
            DataTable dt = Query.ProcessSql(SqlString, "GradMIS_Data");
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0];
            }
            return null;

        }
       
        public static DataRow GetTheDetailInfoFromReStudyCourse(int  ReStudyCourseID)
        {
            //获得ReStudyCourse表中除了Enable之外的详细信息；ReStudyCourseID为补修课程号；
            string SqlString = "select * from ReStudyCourse where ReStudyCourseID=" + ReStudyCourseID.ToString();
            DataTable dt = Query.ProcessSql(SqlString, "GradMIS_Data");
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0];
            }
            return null;

        }
        public static DataTable GetReStudyCourseSuccess_Failure_Doing_Current(string StuID)
        {//返回学号为：StuID的学生的所申请的所有有效的补修课程，也就是说ReStudyCourse中的Enable必须有效
            ////DataTable 中必须含有以下几个字段
            //从本科课程表中至少返回以下几个字段
            /*ReStudyCourseID
            * CourseID
            * CourseName
            * CourseID
            * Teacher
            * */
            //如果没有成功return null;
            string SqlString = "select ReStudyCourse.ReStudyCourseID,ReStudyCourse.CourseID,ReStudyCourse.TeaClassID,ReStudyCourse.CourseName,ReStudyCourse.Teacher from";
            SqlString = SqlString + " ReStudyCourse,RestStudyList where RestStudyList.ReStudyCourseID=ReStudyCourse.ReStudyCourseID and";
            SqlString = SqlString + " ReStudyCourse.Enable=1 and RestStudyList.StuID='" + StuID.ToString()+"'";
            DataTable dt = Query.ProcessSql(SqlString, "GradMIS_Data");
            if (dt.Rows.Count > 0)
            {
                return dt;
            }
            return null;

            
        }
        public static DataRow GetReStudyCourseSuccess_Failure_DoingDetailInfo(String StuID, int ReStudyCourseID)
        {
            //返回学号为：StuID的学生的所申请,补修课程号为：ReStudyCourseID的所有课程；
            ////DataTable 中必须含有以下几个字段
            //ReStudyCourseID，TeaClassID，CourseID，CourseName，CourseType，Teacher，ClassDate，ClassAddress，ClassWeeks，Term，Remark
            //ReStudyCourse.Remark as ReSCRemark
            //RestStudyList.Remark as ReSLRemark
            string SqlString = "select RestStudyList.Remark as ReSLRemark,ReStudyCourse.Remark as ReSCRemark,ReStudyCourse.*";
            SqlString = SqlString + " from ReStudyCourse,RestStudyList where RestStudyList.StuID='" + StuID.ToString()+"'";
            SqlString = SqlString + " and RestStudyList.ReStudyCourseID=" + ReStudyCourseID.ToString();
            SqlString = SqlString + " and RestStudyList.ReStudyCourseID=ReStudyCourse.ReStudyCourseID";
            DataTable dt = Query.ProcessSql(SqlString, "GradMIS_Data");
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0];
            }
            return null;


        }
        public static DataTable GetHelpTeacher_Success_Doing_Failure_Current(String StuID)
        {
            //返回学号为：StuID的学生的所申请的所有成功的和正在评定的和失败的助教信息，并且所选择的助教的信息必须是有效的，
            //也就是说助教信息中的Enable必须是有效的。
            //必须包含以下字段
            //StationIDD岗位编号i
            //StationName岗位名称
            //IsApplied2申请人数
            //如果没有成功return null;
            DataTable dt;
            string sqlString = "select StationInfo.StationID,StationInfo.StationName,StationApply.IsChecked,StationInfo.IsApplied2 from StationInfo,StationApply";
            sqlString = sqlString + " where StationInfo.StationID=StationApply.StationID" + " and StationApply.StuID='" + StuID.ToString()+"'";
            sqlString = sqlString + " and StationInfo.Enable=1";
            dt = Query.ProcessSql(sqlString, "GradMIS_Data");
            if (dt.Rows.Count > 0)
            {
                return dt;
            }
            return null;

        }
        public static DataTable GetIndividualTeaPracApplySuccess(string StuID)
        {//返回个人申请的所有成功的教学实践；
           //字段包括。
            //本科课程编号 课程名称 教师姓名 本科课程 课程班号 
            string SqlString = "select UndergraduateCourse.UnderCourseID,UndergraduateCourse.CourseName,UndergraduateCourse.Teacher,";
            SqlString = SqlString + "UndergraduateCourse.CourseID,UndergraduateCourse.TeaClassID from UndergraduateCourse,";
            SqlString = SqlString + "TeachPracApply where TeachPracApply.StuID='" + StuID.ToString() + "'and TeachPracApply.IsChecked=1";
            SqlString = SqlString + " and TeachPracApply.UnderCourseID=UndergraduateCourse.UnderCourseID";
            DataTable dt = Query.ProcessSql(SqlString, "GradMIS_Data");
            if (dt.Rows.Count > 0)
            {
                return dt;
            }
            return null;

        }