DA/SqlHelpers.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data .SqlClient;

namespace DA
{
   public class SqlHelpers : IDisposable
    {
         private string _sCon;//连接字符串

        private SqlConnection _sqlCon;  //连接对象
        private SqlCommand _sqlCom;      //命令对象
        private SqlDataAdapter _sqlDa;  //适配器对象
        public SqlDataReader _sqlDr;  //
        private SqlTransaction _sqlTr;  //事物对象

        private bool _isConnected = false;//标识是否连接数据库
        private bool _isTransaction = false;//标识是否启动事务

        /// <summary>
        /// 构造函数，该函数初始化了连接字符串
        /// </summary>
        public SqlHelpers()
        {
        
            string ss = System.Configuration.ConfigurationManager.ConnectionStrings["TeaManageConnectionString"].ConnectionString;        
           this._sCon = ss;
        }

        /// <summary>
        /// 构造函数，该函数可传入自定义的连接字符串
        /// </summary>
        /// <param name="connectionString">连接字符串</param>
        public SqlHelpers(string sCon)
        {
            this._sCon = sCon;
        }

        /// <summary>
        /// 连接数据库，该函数创建了SqlConnection，SqlCommand对象，并打开了连接
        /// </summary>
        /// <returns></returns>
        private bool ConnectDatabase()
        {
            if (!this._isConnected)//如果已经连接，则不需要再连接
            {
                this._sqlCon = new SqlConnection(this._sCon);   //创建连接对象
                this._sqlCom = new SqlCommand();    //创建命令对象
                this._sqlCom.Connection = this._sqlCon;
                try
                {
                    this._sqlCon.Open();
                    this._isConnected = true;
                }
                catch (Exception ex)
                {
                    throw ex;
                }