DataBase/SQLiteHelper.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Data.SQLite;
using System.IO;
using System.Text;

namespace XStart.DataBase {
    public class SqLiteHelper {
        #region 字段

        /// <summary>
        /// 事务的基类
        /// </summary>
        private DbTransaction _dBtrans;
        /// <summary>
        /// 使用静态变量字典解决多线程实例本类，实现一个数据库对应一个clslock
        /// </summary>
        private static readonly Dictionary<string, ClsLock> Rwl = new Dictionary<string, ClsLock>();
        /// <summary>
        /// 数据库地址
        /// </summary>
        private readonly string _mdataFile;
        /// <summary>
        /// 数据库密码
        /// </summary>
        private readonly string _mPassWord;
        private readonly string _lockName;
        /// <summary>
        /// 数据库连接定义
        /// </summary>
        private SQLiteConnection _mConn;

        #endregion

        #region 构造函数

        /// <summary>
        /// 根据数据库地址初始化
        /// </summary>
        /// <param name="dataFile">数据库地址</param>
        public SqLiteHelper(string dataFile) {
            if (null == dataFile) {
                throw new ArgumentNullException(nameof(dataFile));
            }
            this._mdataFile = AppDomain.CurrentDomain.BaseDirectory + dataFile;
            // this.mdataFile = dataFile;
            if (!Rwl.ContainsKey(dataFile)) {
                _lockName = dataFile;
                Rwl.Add(dataFile, new ClsLock());
            }
        }

        /// <summary>
        /// 使用密码打开数据库
        /// </summary>
        /// <param name="dataFile">数据库地址</param>
        /// <param name="passWord">数据库密码</param>
        public SqLiteHelper(string dataFile, string passWord) {