DAL/RoomDAL.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 RoomDAL
    {
        public bool InsertOneRecord(Room room)
        {
            // 1. 创建连接
            SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["XDF"].ConnectionString);

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

            // 2.1 创建命令对象
            SqlCommand command = new SqlCommand("INSERT INTO [Room](RoomID, BaseID, Type,Capacity,Address) VALUES(@RoomID, @BaseID, @Type,@Capacity,@Address)", connection);
            command.Parameters.AddWithValue("@RoomID", room.RoomID);
            command.Parameters.AddWithValue("@BaseID", room.BaseID);
            command.Parameters.AddWithValue("@Type", room.Type);
            command.Parameters.AddWithValue("@Capacity", room.Capacity);
            command.Parameters.AddWithValue("@Address", room.Address);
            // 2.2 执行命令对象
            int result = command.ExecuteNonQuery();

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

            return (result == 1);
        }
        public bool ModifyInfo(Room room)
        {

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

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

            // 2.1 创建命令对象
            SqlCommand command = new SqlCommand("UPDATE Room SET Capacity=@Capacity,Address=@Address,Type=@Type WHERE RoomID=@RoomID", connection);
            command.Parameters.AddWithValue("@RoomID", room.RoomID);
            
            command.Parameters.AddWithValue("@Type", room.Type);
            command.Parameters.AddWithValue("@Capacity", room.Capacity);
            command.Parameters.AddWithValue("@Address", room.Address);
            

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

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

            return (result == 1);