grd_mis_2.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>
/// grd_MIS_2 的摘要说明
/// </summary>
namespace grd_MIS
{
    public partial class manager
    {
		//
		// TODO: 在此处添加构造函数逻辑
		//
        public static bool AddData_UndergraduateCourse(String TeaClassID, String CourseID, String CourseName, String CourseType, String Teacher, String TeacherPhone, String ClassDate, String ClassAddress, String ClassWeeks, int Term, String Remark, int Enable)
        {
            //UndergraduateCourse表中添加一条记录
            UndergraduateCourseEntity undergraduateCourse = new UndergraduateCourseEntity();
            undergraduateCourse.TeaClassID = TeaClassID;
            undergraduateCourse.CourseID = CourseID;
            undergraduateCourse.CourseName = CourseName;
            undergraduateCourse.CourseType = CourseType;
            undergraduateCourse.Teacher = Teacher;
            undergraduateCourse.TeacherPhone = TeacherPhone;
            undergraduateCourse.ClassDate = ClassDate;
            undergraduateCourse.ClassAddress = ClassAddress;
            undergraduateCourse.ClassWeeks = ClassWeeks;
            undergraduateCourse.Term = Term;
            undergraduateCourse.Remark = Remark;
            undergraduateCourse.Enable = Enable;
            try
            {
                undergraduateCourse.Save();
                return true;
            }
            catch
            {
                return false;
            }
 
        }
        public static bool AddData_StationInfo(String StationName,String StationDescrip,String Remark,int Enable,int IsApplied)
        {
            // 向StationInfo表添加一条记录
            StationInfoEntity stationInfo = new StationInfoEntity();
            stationInfo.StationName = StationName;
            stationInfo.StationDescrip = StationDescrip;
            stationInfo.Remark = Remark;
            stationInfo.Enable = Enable;
            stationInfo.IsApplied2 = IsApplied;
            try
            {
                stationInfo.Save();
                return true;
            }
            catch
            {
                return false;
            }
        }
        public static bool AddData_ReStudyCourse(String TeaClassID, String CourseID, String CourseName, String CourseType, String Teacher, String TeacherPhone, String ClassDate, String ClassAddress, String ClassWeeks, int Term, String Remark, int Enable)
        {
            //UndergraduateCourse表中添加一条记录
            ReStudyCourseEntity reStudyCourse = new ReStudyCourseEntity();
            reStudyCourse.TeaClassID = TeaClassID;
            reStudyCourse.CourseID = CourseID;
            reStudyCourse.CourseName = CourseName;
            reStudyCourse.CourseType = CourseType;
            reStudyCourse.Teacher = Teacher;
            reStudyCourse.ClassDate = ClassDate;
            reStudyCourse.ClassAddress = ClassAddress;
            reStudyCourse.ClassWeeks = ClassWeeks;
            reStudyCourse.Term = Term;
            reStudyCourse.Remark = Remark;
            reStudyCourse.Enable = Enable;
            try
            {
                reStudyCourse.Save();
                return true;
            }
            catch
            {
                return true;
            }
        }
        public static DataTable GetData_UndergraduateCourse()
        {
            //返回UndergraduateCourse表中Term项数据，Term值不能重复，按降序排列
            DataTable dt = new DataTable();
            string sqlString = "SELECT DISTINCT Term FROM UndergraduateCourse ORDER BY Term DESC";
            try
            {
                dt = Query.ProcessSql(sqlString, "GradMIS_Data");
                return dt;
            }
            catch
            {
                return null;
            }

        }
        public static DataTable GetData_UndergraduateCourse(int id)
        {
            //返回UndergraduateCourse表中Term=id,降叙排列
            try
            {

                RetrieveCriteria rc = new RetrieveCriteria(typeof(UndergraduateCourseEntity));
                Condition c = rc.GetNewCondition();
                c.AddEqualTo(UndergraduateCourseEntity.__TERM, id);
                rc.OrderBy(UndergraduateCourseEntity.__TERM, false);
                DataTable dt = rc.AsDataTable();
                return dt;
            }
            catch
            {
                return null;
            }
            
            
 
        }
        public static DataRow GetData_UndergraduateCourse_ByUnderCourseID(int id)
        {
            //返回UndergraduateCourse表中nderCourseID＝id的一条记录
            try
            {
                RetrieveCriteria rc = new RetrieveCriteria(typeof(UndergraduateCourseEntity));
                Condition c = rc.GetNewCondition();
                c.AddEqualTo(UndergraduateCourseEntity.__UNDERCOURSEID, id);
                DataTable dt = rc.AsDataTable();
                return dt.Rows[0];
            }
            catch
            {
                return null;
            }
            
        }
        public static DataTable GetData_TeachPracApply_ByUnderCourseID(int id)
        {
            //返回TeachPracApply和StudentInfo表UnderCourseID=id的数据降叙
            DataTable dt = new DataTable();
            string sqlString = "SELECT * FROM TeachPracApply,StudentInfo WHERE TeachPracApply.StuID=StudentInfo.StuID AND TeachPracApply.UnderCourseID = " + id.ToString()+"ORDER BY UnderCourseID DESC";
            try
            {
                dt = Query.ProcessSql(sqlString, "GradMIS_Data");
                return dt;
            }
            catch
            {
                return null;
            }
        }
        public static DataTable GetData_StationInfo()
        {
            //ID降叙排列返回StationInfo表所有信息
            try
            {
                RetrieveCriteria rc = new RetrieveCriteria(typeof(StationInfoEntity));
                Condition c = rc.GetNewCondition();
                rc.OrderBy(StationInfoEntity.__STATIONID, false);
                DataTable dt = rc.AsDataTable();
                return dt;
            }
            catch
            {
                return null;
            }
        }
         public static DataRow GetData_StationInfo(int id)
         {
             //返回StationInfo表中StationID=id的信息
             try
             {
                 RetrieveCriteria rc = new RetrieveCriteria(typeof(StationInfoEntity));
                 Condition c = rc.GetNewCondition();
                 c.AddEqualTo(StationInfoEntity.__STATIONID, id);
                 DataTable dt = rc.AsDataTable();
                 return dt.Rows[0];
             }
             catch
             {
                 return null;
             }
         }
        public static DataTable GetData_StationApply_StationID(int id)
        {
            //返回StationApply表和StudentInfo表中StationID=id的信息
            //StationApplyID降叙排列
            DataTable dt = new DataTable();
            string sqlString = "SELECT * FROM StudentInfo,StationApply WHERE StationApply.StuID = StudentInfo.StuID AND StationApply.StationID = " + id.ToString()+"ORDER BY StationID DESC";
            try
            {
                dt = Query.ProcessSql(sqlString, "GradMIS_Data");
                return dt;
            }
            catch
            {
                return null;
            }
        }
        public static DataTable GetData_ReStudyCourse_ByTerm()
        {
            //返回的DataTable里只包含Term，按trem降序排列
            DataTable dt = new DataTable();
            string sqlString = "SELECT DISTINCT Term FROM ReStudyCourse ORDER BY Term DESC";
            try
            {
                dt = Query.ProcessSql(sqlString, "GradMIS_Data");
                return dt;
            }
            catch
            {
                return null;
            }
        }
        public static DataTable GetData_ReStudyCourse_ReStudyCourseID(int id)
        {
            //返回的ReStudyCourse表中ReStudyCourseID=id的表
            try
            {
                RetrieveCriteria rc = new RetrieveCriteria(typeof(ReStudyCourseEntity));
                Condition c = rc.GetNewCondition();
                c.AddEqualTo(ReStudyCourseEntity.__RESTUDYCOURSEID, id);
                DataTable dt = rc.AsDataTable();
                return dt;
            }
            catch
            {
                return null;
            }
 
        }
        public static DataTable GetData_ReStudyCourse_Term(int trem)
        {
            //返回的ReStudyCourse表的Term=trem
            try
            {
                RetrieveCriteria rc = new RetrieveCriteria(typeof(ReStudyCourseEntity));
                Condition c = rc.GetNewCondition();
                c.AddEqualTo(ReStudyCourseEntity.__TERM, trem);
                DataTable dt = rc.AsDataTable();
                return dt;
            }
            catch
            {
                return null;
            }
        }
        public static DataTable GetData_RestStudyList_ReStudyCourseID(int id)
        {
            //返回RestStudyList表和StudentInfo表ReStudyCourseID=id;
            //按ID降叙排列
            DataTable dt = new DataTable();
            string sqlString = "SELECT RestStudyList.StuID,StudentInfo.StuName FROM StudentInfo,RestStudyList WHERE StudentInfo.StuID=RestStudyList.StuID AND RestStudyList.ReStudyCourseID = " + id.ToString() + "ORDER BY RestStudyList.ReStudyCourseID DESC";
            try
            {
                dt = Query.ProcessSql(sqlString, "GradMIS_Data");
                return dt;
            }
            catch
            {
                return null;
            }
        }
       
            public static bool DelData_UndergraduateCourse(int id)
        {
            //删除UndergraduateCourse表中Term＝id的所有数据
            DeleteCriteria dc = new DeleteCriteria(typeof(UndergraduateCourseEntity));
            Condition c = dc.GetNewCondition();
            c.AddEqualTo(UndergraduateCourseEntity.__TERM, id);
            try
            {
                int re = dc.Perform();
                if (re > 0)
                    return true;
                else
                    return false;