constants.cs

学生学籍管理

using System;
using System.Collections.Generic;
using System.Text;

namespace SchoolMIS.DataAccess.Teacher.SQLServer
{
    class Constants
    {
        /// <summary>
        /// 数据库连接字符串
        /// </summary>
        public static readonly string ConnString =
            @"Data Source=(local);Initial Catalog=student;User ID=sa;Password=1234";

        /// <summary>
        /// 教师登陆
        /// </summary>
        public static readonly string TeacherLogin =
            @"SELECT COUNT(*) FROM [users]
              WHERE   UserName = @teaName 
              AND UserPassword = @teaPassword
              AND Usertype = '教师' ";

        /// <summary>
        /// 修改密码
        /// </summary>
        public static readonly string ChangePassword =
            @"UPDATE [users] SET UserPassword = @teaPassword
              WHERE UserName = @teaName";

        /// <summary>
        /// 添加课程信息
        /// </summary>
        public static readonly string AddCourse =
            @"INSERT INTO [course] 
                (
                    courseName,courseTime,courseStartTime,
                    courseEndTime,courseCredit,courseTeacher,
                    courseDesc,courseAddress
                )
              VALUES
                (
                    @courseName,@courseTime,@courseStartTime,
                    @courseEndtime,@courseCredit,@courseTeacher,
                    @courseDesc,@courseAddress
                )";

        /// <summary>
        /// 获取指定教师的所有的课程信息
        /// </summary>
        public static readonly string GetAllCourseByTeaName =
            @"SELECT courseID AS 编号,
                     courseName AS 名称,
                     courseTime AS 上课时间,
                     courseAddress AS 上课地点,
                     courseStartTime AS 开课时间,
                     courseEndTime AS 结课时间,
                     courseCredit AS 学分,
                     courseDesc AS 其他信息   
              FROM [course]
              WHERE  courseTeacher = @teaName";

        /// <summary>
        /// 删除指定标号的课程信息
        /// </summary>
        public static readonly string DeleteCourseByCourseID =
            @"DELETE FROM [course] WHERE courseID = @courseID";

        /// <summary>
        /// 删除指定课程编号的学生选课信息
        /// </summary>
        public static readonly string DeleteStuCourseByCourseID =
            @"DELETE FROM [stuCourse] WHERE courseID = @courseID";

        /// <summary>
        /// 依据课程编号获取所有选课学生的学生信息
        /// </summary>
        public static readonly string GetStuCourseByCourseID =
            @"SELECT [stuCourse].scID AS 选课编号,
                     [course].courseName AS 课程名称,
                     [student].stuName AS 学生姓名,
                     [stuCourse].stuID AS 学生学号,
                     [stuCourse].scScore AS 学生成绩
              FROM   [course],[stuCourse],[student]
              WHERE  [course].courseID = [stuCourse].courseID
              AND    [stuCourse].stuID = [student].stuID
              AND    [stuCourse].courseID = @courseID";

        /// <summary>
        /// 给指定的学生选课记录评分
        /// </summary>
        public static readonly string UpdateScore =
            @"UPDATE    stuCourse 
              SET       scScore = @score
              WHERE     scID = @scID";
    }
}