grd_mis_3.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_3 的摘要说明
/// </summary>
namespace grd_MIS
{
    public partial class manager
    {
        public static bool IsExist_StudentInfo_StuID(String id)
        {
            //判断StuID=id的学生是否存在
            //存在返回true;
            StudentInfoEntity studentInfo = new StudentInfoEntity();
            studentInfo.StuID = id;
            try
            {
                studentInfo.Retrieve();
                if (studentInfo.IsPersistent)
                    return true;
                else
                    return false;
            }
            catch
            {
                return false;
            }
        }
        public static bool IsExist_UndergraduateCourse_Term(int term)
        {
            //判断UndergraduateCourse中是否存在Term=trem
            UndergraduateCourseEntity undergraduateCourse = new UndergraduateCourseEntity();
            undergraduateCourse.Term = term;
            try
            {
                undergraduateCourse.Retrieve();
                if (undergraduateCourse.IsPersistent)
                    return true;
                else
                    return false;
            }
            catch
            {
                return true;
            }
        }
        public static DataTable GetData_StudentInfo(String id)
        {
            //列出StudentInfo表和SpvInfo表中StuID=id的信息
            DataTable dt = new DataTable();
            string sqlString = "SELECT * FROM StudentInfo,SpvInfo WHERE StudentInfo.SpvID=SpvInfo.SpvID AND StudentInfo.StuID = '" + id.ToString()+"'" ;
            try
            {
                dt = Query.ProcessSql(sqlString, "GradMIS_Data");
                return dt;
            }
            catch
            {
                return null;
            }

        }
        public static DataTable GetData_ScholarApp_StuID(String id)
        {
            //列出ScholarApp表和ScholarInfo表中StuID=id并且IsChecked=1的信息
            DataTable dt = new DataTable();
            string sqlString = "SELECT * FROM ScholarApp,ScholarInfo WHERE ScholarInfo.ScholarshipInfoID=ScholarApp.ScholarshipInfoID AND ScholarApp.IsChecked = 1 AND ScholarApp.StuID="+ id.ToString();
            try
            {
                dt = Query.ProcessSql(sqlString, "GradMIS_Data");
                return dt;
            }
            catch
            {
                return null;
            }
        }
        public static DataTable GetData_ExcellApp_StuID(String id)
        {
            //列出ExcellApp表和ExcellInfo表中StuID=id并且IsChecked=1的信息
            DataTable dt = new DataTable();
            string sqlString = "SELECT * FROM ExcellApp,ExcellInfo WHERE ExcellInfo.ExcellenceInfoID = ExcellApp.ExcellenceInfoID AND IsChecked = 1 AND ExcellApp.StuID = "+id.ToString();
            try
            {
                dt = Query.ProcessSql(sqlString, "GradMIS_Data");
                return dt;
            }
            catch
            {
                return null;
            }
        }
        public static DataTable GetData_JoinActivStu_StuID(String id)
        {
            //列出JoinActivStu表和ActivityInfo表中StuID=id
            DataTable dt = new DataTable();
            string sqlString = "SELECT * FROM JoinActivStu,ActivityInfo WHERE ActivityInfo.ActivityID=JoinActivStu.ActivityID AND StuID = "+id.ToString();
            try
            {
                dt = Query.ProcessSql(sqlString, "GradMIS_Data");
                return dt;
            }
            catch
            {
                return null;
            }
        }
        public static DataTable GetData_JoinReportStu_StuID(String id)
        {
            //列出JoinReportStu表和ReportInfo表中StuID=id的信息
            DataTable dt = new DataTable();
            string sqlString = "SELECT * FROM JoinReportStu,ReportInfo WHERE ReportInfo.ReportID=JoinReportStu.ReportID AND JoinReportStu.StuID = "+id.ToString();
            try
            {
                dt = Query.ProcessSql(sqlString, "GradMIS_Data");
                return dt;
            }
            catch
            {
                return null;
            }
        }
        public static DataTable GetData_LoanInfo_StuID(String id)
        {
            //列出LoanInfo表中StuID=id的信息
            try
            {
                RetrieveCriteria rc = new RetrieveCriteria(typeof(LoanInfoEntity));
                Condition c = rc.GetNewCondition();
                c.AddEqualTo(LoanInfoEntity.__STUID, id);
                DataTable dt = rc.AsDataTable();
                return dt;
            }
            catch
            {
                return null;
            }
          
 
        }
        public static DataTable GetData_TeachPracApply_StuID(String id)
        {
            //列出TeachPracApply表和UndergraduateCourse表中StuID=id和IsChecked=1的信息
            DataTable dt = new DataTable();
            string sqlString = "SELECT * FROM TeachPracApply,UndergraduateCourse WHERE UndergraduateCourse.UnderCourseID = TeachPracApply.UnderCourseID AND IsChecked=1 AND TeachPracApply.StuID ="+ id.ToString();
            try
            {
                dt = Query.ProcessSql(sqlString, "GradMIS_Data");
                return dt;
            }
            catch
            {
                return null;
            }
        }
        public static DataTable GetData_StationApply_StuID(String id)
        {
            //列出StationApply表和StationInfo表中StuID=id和IsChecked=1的信息
            DataTable dt = new DataTable();
            string sqlString = "SELECT * FROM StationApply,StationInfo WHERE StationInfo.StationID = StationApply.StationID AND IsChecked =1 AND StationApply.StuID = " + id.ToString();
            try
            {
                dt = Query.ProcessSql(sqlString, "GradMIS_Data");
                return dt;
            }
            catch
            {
                return null;
            }
        }
        public static DataTable GetData_SpvInfo_SpvID(int id)
        {
            //列出SpvInfo表SpvID=id的信息
            try
            {
                RetrieveCriteria rc = new RetrieveCriteria(typeof(SpvInfoEntity));
                Condition c = rc.GetNewCondition();
                c.AddEqualTo(SpvInfoEntity.__SPVID, id);
                DataTable dt = rc.AsDataTable();
                return dt;
            }
            catch
            {
                return null;
            }
        }
        public static DataTable GetData_MatriculateTable_SpvID(int id)
        {
            //列出MatriculateTable表SpvID=id并且Enable=1的数据
            try
            {
                RetrieveCriteria rc = new RetrieveCriteria(typeof(MatriculateTableEntity));
                Condition c = rc.GetNewCondition();
                c.AddEqualTo(MatriculateTableEntity.__SPVID, id);
                //c.AddEqualTo(MatriculateTableEntity.__ENABLE, 1);
                DataTable dt = rc.AsDataTable();
                return dt;
            }
            catch
            {
                return null;
            }
        }
        public static DataTable GetData_LoanInfo(DateTime begin, DateTime end)
        {
            //返回StudentInfo表和LoanInfo表中LoanData在begin-end之间的数据
            //返回table中应有LoanInfo表所有信息和StudentInfo表的stuid,stuname
            DataTable dt = new DataTable();
            string sqlString = "SELECT LoanInfo.LoanID,LoanInfo.StuID,IsLoan,LoanData,LoanMoney,LoanInfo.Remark,StudentInfo.StuName FROM StudentInfo,LoanInfo WHERE LoanData BETWEEN  '"+begin.ToString()+"' AND '"+ end.ToString()+"'";
            try
            {
                dt = Query.ProcessSql(sqlString, "GradMIS_Data");
                return dt;
            }
            catch
            {
                return null;
            }
        }
        public static DataTable GetData_ScholarApply(int id, int ischeckd)
        {
            //返回StudentInfo表和ScholarApply表ScholarshipInfoID=id并且IsChecked=ischeckd
            //返回的数据只包含stuid,stuname,GetScholarDate,ScholarshipResume,Remark
            DataTable dt = new DataTable();
            string sqlString = "SELECT StudentInfo.StuID,StuName,GetScholarDate,ScholarshipResume,ScholarApp.Remark FROM ScholarApp,StudentInfo WHERE ScholarApp.StuID = StudentInfo.StuID AND ScholarApp.ScholarshipInfoID ="+id.ToString() +"AND IsChecked = "+ischeckd.ToString();
            try
            {
                dt = Query.ProcessSql(sqlString, "GradMIS_Data");
                return dt;
            }
            catch
            {
                return null;
            }
        }
        public static DataTable GetData_ExcellApply(int id, int ischeckd)
        {
            //返回StudentInfo表和ExcellApp表ExcellenceInfoID=id并且IsChecked=ischeckd
            //返回的数据只包含stuid,stuname,GetExcellDate,ExcellenceResume,Remark
            DataTable dt = new DataTable();
            string sqlString = "SELECT StudentInfo.StuID,StuName,GetExcellDate,ExcellenceResume,ExcellApp.Remark FROM ExcellApp,StudentInfo WHERE StudentInfo.StuID = ExcellApp.StuID AND ExcellenceInfoID ="+id.ToString()+"AND IsChecked = "+ischeckd.ToString();
            try
            {
                dt = Query.ProcessSql(sqlString, "GradMIS_Data");
                return dt;
            }
            catch
            {
                return null;
            }
        }
        public static bool SetData_SpvInfo_BySpvID(int SpvID, String SpvType, int IsDoctor, int RecruitNumber, int AddNumber, DateTime ConfirmDate, String Remark)
        {
            //更新SpvInfo表SpvID=SpvID的值
            try
            {
                UpdateCriteria uc = new UpdateCriteria(typeof(SpvInfoEntity));
                Condition c = uc.GetNewCondition();
                c.AddEqualTo(SpvInfoEntity.__SPVID, SpvID);
                uc.AddAttributeForUpdate(SpvInfoEntity.__SPVTYPE, SpvType);
                uc.AddAttributeForUpdate(SpvInfoEntity.__ISDOCTOR, IsDoctor);
                uc.AddAttributeForUpdate(SpvInfoEntity.__RECRUITNUMBER, RecruitNumber);
                uc.AddAttributeForUpdate(SpvInfoEntity.__ADDNUMBER, AddNumber);
                uc.AddAttributeForUpdate(SpvInfoEntity.__CONFIRMDATE, ConfirmDate);
                uc.AddAttributeForUpdate(SpvInfoEntity.__REMARK, Remark);
                int re = uc.Perform();
                return true;
            }
            catch
            {
                return false;
            }
        }
        public static bool SetData_ReStudyCourse(int traem)
        {
            //将ReStudyCourse表中Term=traem的所有数据项的Enable置为0;
            UpdateCriteria uc = new UpdateCriteria(typeof(ReStudyCourseEntity));
            Condition c = uc.GetNewCondition();
            c.AddEqualTo(ReStudyCourseEntity.__TERM, traem);
            uc.AddAttributeForUpdate(ReStudyCourseEntity.__ENABLE, 0);
            try
            {
                int re = uc.Perform();
                return true;
            }
            catch
            {
                return false;
            }
            
        }
        public static bool SetData_UndergraduateCourse_DisEnable()
        {
            //将UndergraduateCourse表中所有项Enable置为0
            UpdateCriteria uc = new UpdateCriteria(typeof(UndergraduateCourseEntity));
            Condition c = uc.GetNewCondition();
            c.AddEqualTo(UndergraduateCourseEntity.__ENABLE, 1);
            uc.AddAttributeForUpdate(UndergraduateCourseEntity.__ENABLE, 0);
            try
            {
                int re = uc.Perform();
                return true;
            }
            catch
            {

                return false;
            }
        }

       
    }
}