c#通用数据库连接，执行sql语句

public static void ExecSQLNoQueryByTransaction(string[] sql, params IEnumerable<MySqlParameter>[] paras)
        {
            int result = sql.Count();
            DbConnection dbConnection = new SqlConnection("server=192.168.1.187;userid=root;pwd=\"zkzl1-1=0\";port=3306;database=dbhealth82;sslmode=none");
            try
            {
                dbConnection.Open();
                DbTransaction dbTransaction = dbConnection.BeginTransaction();
                DbCommand cmd = dbConnection.CreateCommand();
                cmd.Transaction = dbTransaction;
                for (int i = 0; i < sql.Count(); i++)
                {
                    cmd.CommandText = sql[i];
                    if (paras != null && paras[i] != null)
                        foreach (MySqlParameter para in paras[i])
                            cmd.Parameters.Add(para);
                    if (cmd.ExecuteNonQuery() > 0)
                        result--;
                    cmd.Parameters.Clear();
                }
                if (result == 0)
                    dbTransaction.Commit();
                else
                    dbTransaction.Rollback();
                cmd.Dispose();
                dbConnection.Close();
                dbConnection.Dispose();
            }
            catch (Exception ex)
            {
                LogerHelper.Error("执行sql异常===>" + ex.Message);
            }
        }