执行多条SQL语句，实现数据库事务。解决添加一个成功 有一个失败全部添加失败 全部成功才是真的成功

/// <summary>
        /// 执行多条SQL语句，实现数据库事务。
        /// </summary>
        /// <param name="SQLStringList">多条SQL语句</param>        
        public int dragon_ExecuteSqlTran(List<String> SQLStringList, string connstr)
        {
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                conn.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = conn;
                SqlTransaction tx = conn.BeginTransaction();
                cmd.Transaction = tx;
                LogInfo info = new LogInfo();
                string strsql = "";
                try
                {
                    int count = 0;
                    for (int n = 0; n < SQLStringList.Count; n++)
                    {
                        strsql = SQLStringList[n];
                        if (strsql.Trim().Length > 1)
                        {
                            cmd.CommandText = strsql;
                            count = cmd.ExecuteNonQuery();
                            if (count == 0)
                            {
                                tx.Rollback();
                                info.WriteLogfile("[无效Sql][" + strsql + "][受影响行数0]");
                                return 0;
                            }
                        }
                    }
                    tx.Commit();
                    return count;
                }
                catch (Exception ex)
                {
                    info.WriteLogfile("[Sql错误][" + strsql + "][" + ex.ToString() + "]");
                    tx.Rollback();
                    return 0;
                }
            }
        }