C# 中dataTable中的数据批量增加至数据表中

  /// <summary>
        /// 批量添加
        /// </summary>
        /// <param name="dt"></param>
        public static bool AddExchangeBulkCopy(DataTable dt, string table_name)
        {
            bool ret = false;

            using (SqlConnection Connection = new SqlConnection(CONN_STRING_NON_DTC))
            {

                Connection.Open();

                SqlTransaction sqlbulkTransaction = Connection.BeginTransaction();

                using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(Connection, SqlBulkCopyOptions.CheckConstraints, sqlbulkTransaction))
                {

                    //源列字段：A，目标数据源字段：B
                    //@o_id,ticket,@order_id,@product_id,@amount

                    sqlBulkCopy.ColumnMappings.Add(0, "return_orderid");

                    sqlBulkCopy.ColumnMappings.Add(1, "phone");

                    sqlBulkCopy.ColumnMappings.Add(2, "real_amount");

                    sqlBulkCopy.ColumnMappings.Add(3, "finish_date");

                    sqlBulkCopy.ColumnMappings.Add(4, "supplier");

                    sqlBulkCopy.ColumnMappings.Add(5, "is_sign");

                    sqlBulkCopy.ColumnMappings.Add(6, "msg_error");


                    sqlBulkCopy.BatchSize = dt.Rows.Count;

                    sqlBulkCopy.BulkCopyTimeout = 60;

                    sqlBulkCopy.DestinationTableName = table_name;

                    if (dt != null && dt.Rows.Count != 0)
                    {
                        try
                        {
                            sqlBulkCopy.WriteToServer(dt);

                            sqlbulkTransaction.Commit();
                            ret = true;
                        }
                        catch (Exception ex)
                        {
                            try
                            {
                                sqlbulkTransaction.Rollback();
                                ret = false;
                            }
                            catch
                            {
                                ret = false;
                            }
                            throw ex;
                        }
                        finally
                        {
                        }
                    }
                }
            }
            return ret;
        }