/// <summary>
        /// 执行多条SQL语句，实现数据库事务。
        /// </summary>
        /// <param name="SQLStringList">SQL语句的（key为sql语句，value是该语句的SqlParameter[]）</param>
        public static void ExecuteSqlTran(List<SqlKeys> SQLStringList)
        {
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                conn.Open();
                using (SqlTransaction trans = conn.BeginTransaction())
                {
                    SqlCommand cmd = new SqlCommand();
                    try
                    {
                        //循环
                        foreach (SqlKeys myDE in SQLStringList)
                        {
                            string cmdText = myDE.Sql;
                            SqlParameter[] cmdParms = myDE.SqlParameter;
                            PrepareCommand(cmd, conn, trans, cmdText, cmdParms);
                            int val = cmd.ExecuteNonQuery();
                            cmd.Parameters.Clear();
                        }
                        trans.Commit();
                    }
                    catch
                    {
                        trans.Rollback();
                        throw;
                    }
                }
            }
        }
        public class SqlKeys
        {
            private string _sql;
            private SqlParameter[] _sqlParameter;

            public SqlKeys() { }
            public SqlKeys(string sSql, SqlParameter[] spSqlParameter)
            {
                this.Sql = sSql;
                this.SqlParameter = spSqlParameter;
            }

            public string Sql
            {
                get { return this._sql; }
                set { this._sql = value; }
            }

            public SqlParameter[] SqlParameter
            {
                get { return this._sqlParameter; }
                set { this._sqlParameter = value; }
            }
        }

SqlTransaction tran = null;
            try
            {
                string connectionString = ConfigurationManager.ConnectionStrings["connctionString"].ConnectionString;
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();
                     tran = conn.BeginTransaction();
                    using (SqlCommand cmd = conn.CreateCommand())
                    {
                        cmd.Transaction = tran;
                        cmd.CommandText = "insert into A values(@AName);select @@Identity";
                        cmd.Parameters.Add("@AName", "testName");
                        int id = Convert.ToInt32(cmd.ExecuteScalar());
                        cmd.CommandText = "insert into B values(@BName,@AID)";
                        cmd.Parameters.Add("@BName", "testName");
                        cmd.Parameters.Add("@AID", id);
                        cmd.ExecuteNonQuery();
                        MessageBox.Show("插入成功");
                    }
                    tran.Commit();
                }
            }
            catch (Exception ex)
            {
                tran.Rollback();
                throw;
            }