不同数据库间事务操作(服务器也可不同)--事务回滚

时间:2025-05-08 07:04:25
/// <summary>
        /// 不同服务器上数据库的事务操作
        /// </summary>
        /// <param name="alCon">数据库连接字符串集</param>
        /// <param name="alSql">sql语句集,同一服务器的数据库sql语句合并为一条处理</param>
        /// <returns>返回是否执行成功1表示成功,-1表示失败</returns>
        public override int ExcuteTransactions(ArrayList alCon, ArrayList alSql)
        {
            int iFlag = 1; //用于返回是否执行成功
            ArrayList alTran = new ArrayList();
            ArrayList alCons = new ArrayList();
            try
            {
                for (int i = 0; i < ; i++)
                {
                    SqlConnection sqlCon = new SqlConnection(alCon[i].ToString());
                    SqlCommand sqlCom = new SqlCommand();
                    = sqlCon;
                    //打开数据库
                    ();
                    //创建事务
                    SqlTransaction tranNew = ();
                    //临时保存数据,以便事务回滚
                    (sqlCon);
                    (tranNew);