HotelDAL/DBHelper.cs

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

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

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

using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace HotelDAL
{
    /// <summary>
    /// 数据访问层
    /// </summary>
    public static class DBHelper
    {
        private static SqlConnection connection;
        #region 联接相关
        public static SqlConnection Connection
        {
            get
            {
                if (connection == null)
                {
                    //connection = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\网上书店 2008-10-12\DataBase\MyBookShop.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
                    //从配置文件中读取数据库联接字符串
                    connection = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlConnection"].ConnectionString);
                    //使用时要添加Configuration引用
                    connection.Open();
                }
                else if (connection.State == ConnectionState.Closed)
                {
                    connection.Open();
                }
                else if (connection.State == ConnectionState.Broken)
                {
                    connection.Close();
                    connection.Open();
                }
                return connection;
            }
        }
        #endregion

        #region 增、删、改
        /// <summary>
        /// 执行增、删、改 的方法
        /// </summary>
        /// <param name="commandText">sql,prc</param>
        /// <param name="commandType">CommandType</param>
        /// <param name="para">参数数组</param>
        /// <returns></returns>
        public static int ExecuteNonQuery(string commandText, CommandType commandType, SqlParameter[] para)
        {
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = Connection;
            cmd.CommandText = commandText;
            cmd.CommandType = commandType;
            try
            {
                if (para != null)