DAL/OrderDAL.cs

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

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

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

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

            // 2.1 创建命令对象
            SqlCommand command = new SqlCommand("INSERT INTO [Order](OrderID, CourseID, StuID,Amount) VALUES(@OrderID, @CourseID, @StuID,@Amount)", connection);
            command.Parameters.AddWithValue("@OrderID", order.OrderID);
            command.Parameters.AddWithValue("@CourseID", order.CourseID);
            command.Parameters.AddWithValue("@StuID", order.StuID);
            command.Parameters.AddWithValue("@Amount", order.Amount);
            // 2.2 执行命令对象
            int result = command.ExecuteNonQuery();

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

            return (result == 1);
        }

        public bool Cancel(Order order)
        {

            // 1. 创建连接
            SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["XDF"].ConnectionString);

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

            // 2.1 创建命令对象
            SqlCommand command = new SqlCommand("UPDATE [Order] SET State='已取消',CancelTime=@CancelTime WHERE OrderID=@OrderID ", connection);
            command.Parameters.AddWithValue("@OrderID", order.OrderID);
            command.Parameters.AddWithValue("@CancelTime", order.CancelTime);

            // 2.2 执行命令对象
            int result = command.ExecuteNonQuery();

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

            return (result == 1);
        }
    }
}