Common/SQLBase.cs

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

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

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Text.RegularExpressions;
namespace Common
{
    public class SQLBase : IDisposable
    {
        private SqlConnection conn;
        private SqlTransaction trans;

        /// <summary>
        /// 用默认数据库连接
        /// </summary>
        public SQLBase()
        {
            this.trans = null;
            this.conn = new SqlConnection(ConnectionString);
            this.conn.Open();
        }

        /// <summary>
        /// 指定外边的数据库连接
        /// </summary>
        /// <param name="strConnection"></param>
        public SQLBase(string strConnection)
        {
            this.trans = null;
            this.conn = new SqlConnection(strConnection);
            //ConnectionString = strConnection;
            this.conn.Open();
        }
        /// <summary>
        /// 用默认数据库连接调用专属的IDataReader时用此函数
        /// </summary>
        /// <param name="option"></param>
        public SQLBase(LinkOption option)
        {
            this.trans = null;
            if (option != LinkOption.Short)
            {
                this.conn = new SqlConnection(ConnectionString);
                this.conn.Open();
            }
        }

        /// <summary>
        /// 指定外部连接和调用专属的IDataReader
        /// </summary>
        /// <param name="strConnection"></param>
        /// <param name="option"></param>
        public SQLBase(string strConnection, LinkOption option)
        {
            this.trans = null;
            // ConnectionString = strConnection;
            if (option != LinkOption.Short)
            {