微软版SQLite事务提交函数

// 当前事务实例
private static SqliteTransaction _currentTrans;
// 全局连接（如果你是单连接模式；多连接可自行调整）
private static SqliteConnection _conn;

// 原有查询、ExecuteDataTable、ExecuteNonQuery、ToList 等方法保留...

#region 事务封装
/// <summary>
/// 开启事务
/// </summary>
public static void BeginTransaction()
{
    // 确保连接打开
    if (_conn == null || _conn.State != ConnectionState.Open)
    {
        // 这里替换成你自己的数据库连接初始化逻辑
        _conn = GetSQLiteConnection();
        _conn.Open();
    }
    // 已有事务先回滚再新建
    if (_currentTrans != null)
    {
        RollbackTransaction();
    }
    _currentTrans = _conn.BeginTransaction();
}

/// <summary>
/// 提交事务
/// </summary>
public static void CommitTransaction()
{
    if (_currentTrans != null)
    {
        _currentTrans.Commit();
        _currentTrans.Dispose();
        _currentTrans = null;
    }
}

/// <summary>
/// 回滚事务
/// </summary>
public static void RollbackTransaction()
{
    if (_currentTrans != null)
    {
        _currentTrans.Rollback();
        _currentTrans.Dispose();
        _currentTrans = null;
    }
}
#endregion
public static int ExecuteNonQuery(string sql, Dictionary<string, string> paramDic = null)
{
    using (SqliteCommand cmd = new SqliteCommand(sql, _conn))
    {
        // 绑定当前事务
        if (_currentTrans != null)
        {
            cmd.Transaction = _currentTrans;
        }

        // 赋值参数
        if (paramDic != null && paramDic.Count > 0)
        {
            foreach (var kv in paramDic)
            {
                cmd.Parameters.AddWithValue("@" + kv.Key, kv.Value);
            }
        }
        return cmd.ExecuteNonQuery();
    }
}

UI代码调用：

try
{
    foreach (var tongInfo in tongList)
    {
    var dic = new Dictionary<string, string>
{
    { "BatchID", tongInfo.BatchID },
    { "Lydh", currtime },
    { "Hydh", "" },
    { "IsQingTong", "1" }
};
SQLiteHelper.ExecuteNonQueryCom(upsql, dic);
    SQLiteHelper.CommitTransaction();
}
catch (Exception ex)
{
    SQLiteHelper.RollbackTransaction();
    RecordLog($"批量更新日志异常：{ex.Message}");
    
}