基于事务执行多条SQL语句

        /// <summary>
        /// 基于事务执行多条SQL语句
        /// </summary>
        /// <param name="listCommand"></param>
        /// <returns></returns>
        public static bool UpdateByTran(List<string> listCommand)
        {
            SqlConnection conn = new SqlConnection(connString);
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            try
            {
                conn.Open();
                //开启事务
                cmd.Transaction = conn.BeginTransaction();
                //遍历命令表,提交数据
                foreach (string item in listCommand)
                {
                    cmd.CommandText = item;                 
                    cmd.ExecuteNonQuery();
                }
                //提交事务
                cmd.Transaction.Commit();
                return true;
            }
            catch (Exception ex)
            {
                if (cmd.Transaction != null)
                    //回滚事务
                    cmd.Transaction.Rollback();
                throw new Exception("SQLHelper.UpdateByTran()操作错误!"+ex.Message);
            }
          finally
            {
               cmd.Transaction = null;  //清除事务                
                conn.Close();
            }
           
        }