《团队-排课系统-开发文档》

项目GitHub地址：https://github.com/hkbdegithub/paike
参加后台数据库开发与维护

class ClassInfo//班级信息
{
    //Control
    ClassName//班级编号
    Grade//年级
    ClassNameAndGrade//年纪+班级编号
    Major//专业
}

class ClassroomInfo //教师信息
{
    ClassroomNumber //教室编号
    ClassroomGalleryful //教室容纳人数
    ClassroomType //教师类型
    DetInfo //教室编号+教室容纳人数
}

// 连接数据库获取课程信息
ConnectDbForTeachingProject();

public void ConnectDbForTeachingProject()
        {
            // 获取数据库路径
            var path0 = Environment.CurrentDirectory;
            var path1 = path0.Substring(0, path0.LastIndexOf("\\", StringComparison.Ordinal));
            var path2 = path1.Substring(0, path1.LastIndexOf("\\", StringComparison.Ordinal));
            var dbPath = path2 + "\\DB\\course_scheduling_system.db";
            #region
            using (var conn = new SQLiteConnection())
            {
                var connsb = new SQLiteConnectionStringBuilder { DataSource = dbPath };
                conn.ConnectionString = connsb.ToString();
                conn.Open();
                using (new SQLiteCommand(conn))
                {
                    const string sql = "SELECT * FROM tb_teachingproject";
                    var command = new SQLiteCommand(sql, conn);
                    var reader = command.ExecuteReader();
                    while (reader.Read())
                    {
                        var tp = new TeachingProject
                        {
                            Grade = reader["grade"].ToString(),
                            Major = reader["major"].ToString(),
                            CourseName = reader["course_name"].ToString(),
                            TotalHours = reader["total_hours"].ToString(),
                            WeekOfTeaching = reader["week_of_teaching"].ToString(),
                            NumberOfPeople = reader["number_of_people"].ToString(),
                            Teacher = reader["teacher"].ToString(),
                            UseComputerRoom = reader["use_computer_room"].ToString(),
                            UseClassroomHours = reader["use_classroom_hours"].ToString(),
                            UsePcClassroom = reader["use_pc_classroom"].ToString(),
                            TeacherSchedulingTime = reader["teacher_scheduling_time"].ToString(),
                            TeacherCurriculumRequirements = reader["teacher_curriculum_requirements"].ToString(),
                            CourseNameAndTeacher = reader["course_name"] + "\t" + reader["teacher"]
                        };
                        _teachingProjectsList.Add(tp);
                    }
                }
            }
            #endregion
        }

ConnectDbForClassroomInfo();
// 连接数据库获取班级信息表数据

public void ConnectDbForClassroomInfo()
        {
            // 获取数据库路径
            var path0 = Environment.CurrentDirectory;
            var path1 = path0.Substring(0, path0.LastIndexOf("\\", StringComparison.Ordinal));
            var path2 = path1.Substring(0, path1.LastIndexOf("\\", StringComparison.Ordinal));
            var dbPath = path2 + "\\DB\\course_scheduling_system.db";
            #region
            using (var conn = new SQLiteConnection())
            {
                var connsb = new SQLiteConnectionStringBuilder { DataSource = dbPath };
                conn.ConnectionString = connsb.ToString();
                conn.Open();
                using (new SQLiteCommand(conn))
                {
                    const string sql = "SELECT * FROM tb_classroominfo";
                    var command = new SQLiteCommand(sql, conn);
                    var reader = command.ExecuteReader();
                    while (reader.Read())
                    {
                        var ci = new ClassroomInfo
                        {
                            ClassroomNumber = reader["classroom_number"].ToString(),
                            ClassroomGalleryful = reader["classroom_galleryful"].ToString(),
                            ClassroomType = reader["classroom_type"].ToString(),
                            DetInfo = reader["classroom_number"] + "\t" + reader["classroom_type"]
                        };
                        _classroomInfosList.Add(ci);
                    }
                }
            }
            #endregion
        }

转载于:https://www.cnblogs.com/iZyx/p/7780101.html