代码提交

zjh

4 天以前 661e24b717604dfc5c0f1c6385931943c2a9192e

 StandardPda/MES.Service/DB/OracleSQLHelper.cs

@@ -228,4 +228,23 @@
    //     }
    //     return result;
    // }
    // 打开连接并开启事务
    public (OracleConnection, OracleTransaction) BeginTransaction()
    {
        var connection = new OracleConnection(_connectionString);
        connection.Open();
        var transaction = connection.BeginTransaction();
        return (connection, transaction);
    }

    // 关闭连接（提交或回滚后用）
    public void CloseConnection(OracleConnection connection)
    {
        if (connection != null && connection.State != ConnectionState.Closed)
        {
            connection.Close();
            connection.Dispose();
        }
    }

}