DAL/CourseDAL.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using Model;
using System.Configuration;

namespace DAL
{
    public class CourseDAL
    {
        public bool InsertOneRecord(Course course)
        {
            // 1. 创建连接
            SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["XDF"].ConnectionString);

            // 2. 打开连接
            connection.Open();

            // 2.1 创建命令对象
            SqlCommand command = new SqlCommand("INSERT INTO Course(CourseID, CourseName, TeaID, Grade, Subject, CourseHour,CourseTime,RoomID,Price,CourseIntroduce,BaseID) VALUES(@CourseID, @CourseName, @TeaID, @Grade, @Subject,  @CourseHour, @CourseTime,@RoomID,@Price,@CourseIntroduce,@BaseID)", connection);
            command.Parameters.AddWithValue("@CourseID", course.CourseID);
            command.Parameters.AddWithValue("@CourseName", course.CourseName);
            command.Parameters.AddWithValue("@TeaID", course.TeaID);
            command.Parameters.AddWithValue("@Grade", course.Grade);
            command.Parameters.AddWithValue("@Subject", course.Subject);
            command.Parameters.AddWithValue("@CourseHour", course.CourseHour);
            command.Parameters.AddWithValue("@CourseTime", course.CourseTime);
            command.Parameters.AddWithValue("@RoomID", course.RoomID);
            command.Parameters.AddWithValue("@Price", course.Price);
            command.Parameters.AddWithValue("@CourseIntroduce", course.CourseIntroduce);
            command.Parameters.AddWithValue("@BaseID", course.BaseID);
            // 2.2 执行命令对象
            int result = command.ExecuteNonQuery();

            // 3. 关闭连接
            connection.Close();

            return (result == 1);
        }

        public bool SignUp(Course course)
        {
            // 1. 创建连接
            SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["XDF"].ConnectionString);

            // 2. 打开连接
            connection.Open();

            // 2.1 创建命令对象
            SqlCommand command = new SqlCommand("UPDATE Course SET Num=@Num WHERE CourseID=@CourseID", connection);
            command.Parameters.AddWithValue("@CourseID", course.CourseID);
            command.Parameters.AddWithValue("@Num", course.Num);
            
            // 2.2 执行命令对象
            int result = command.ExecuteNonQuery();

            // 3. 关闭连接
            connection.Close();