MySchool管理系统

最新推荐文章于 2025-05-26 11:15:59 发布

原创

最新推荐文章于 2025-05-26 11:15:59 发布 · 1.6k 阅读

5 ·

CC 4.0 BY-SA版权

本文将详细介绍MySchool管理系统的设计与实现，包括学生信息管理、课程安排、成绩记录等功能，旨在提升学校行政效率。

MySchool.Model:

1.subject 类:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MySchool.Model
{
    class Subject
    {
        private int _subjectid;
        private string _subjectname;
        private int? _classhour;
        private int _gradeid;
        /// <summary>
        /// 
        /// </summary>
        public int SubjectId
        {
            set { _subjectid = value; }
            get { return _subjectid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string SubjectName
        {
            set { _subjectname = value; }
            get { return _subjectname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? ClassHour
        {
            set { _classhour = value; }
            get { return _classhour; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int GradeId
        {
            set { _gradeid = value; }
            get { return _gradeid; }
        }
    }
}

     studnetExt 类：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MySchool.Model
{
   public class StudentExt:Student
    {
        public string SubjectName{ get; set; }
        public  int StudentResult { get; set; }
    }
}

studentModel类：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MySchool.Model
{
  public  class Student
    {
        	private int _studentno;
		private string _loginpwd;
		private string _studentname;
		private string _gender;
		private int _gradeid=1;
		private string _phone;
		private string _address;
		private DateTime? _birthday;
		private string _email;
		private int? _mytt;
		/// <summary>
		/// 
		/// </summary>
		public int StudentNo
		{
			set{ _studentno=value;}
			get{return _studentno;}
		}
		
		public string LoginPwd
		{
			set{ _loginpwd=value;}
			get{return _loginpwd;}
		}
		
		public string StudentName
		{
			set{ _studentname=value;}
			get{return _studentname;}
		}
		
		public string Gender
		{
			set{ _gender=value;}
			get{return _gender;}
		}
		
		public int GradeId
		{
			set{ _gradeid=value;}
			get{return _gradeid;}
		}
		
		public string Phone
		{
			set{ _phone=value;}
			get{return _phone;}
		}
		
		public string Address
		{
			set{ _address=value;}
			get{return _address;}
		}
		
		public DateTime? Birthday
		{
			set{ _birthday=value;}
			get{return _birthday;}
		}
		
		public string Email
		{
			set{ _email=value;}
			get{return _email;}
		}
		
		public int? MyTT
		{
			set{ _mytt=value;}
			get{return _mytt;}
		}
		
    }
}

                                MySchool.DAL:

studentDAL类:

using System;
using System.CodeDom.Compiler;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System.Linq;
using System.Runtime.CompilerServices;
using System.Runtime.Remoting.Messaging;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using MySchool.Model;
namespace MySchool.DAL
{
  public  class StudentDAL
    {
      //添加学生方法
     
      public bool tianjia(string LoginPwd, string   StudentName, string   Gender, int   GradeId, string   Phone, string   Address, DateTime   Birthday, string   Email)
      {   bool flag = false;
          using (SqlConnection con = new SqlConnection(SqlHelper.str))
          {

              string sql = @"INSERT INTO [Student]
                       ([LoginPwd]
                       ,[StudentName]
                       ,[Gender]
                       ,[GradeId]
                       ,[Phone]
                       ,[Address]
                       ,[Birthday]
                       ,[Email])
                         VALUES
                       ('" + LoginPwd + "','" + StudentName + "','" + Gender + "','" + GradeId + "','" + Phone + "','" +