/// <summary>
/// 批量插入数据
/// </summary>
/// <param name="table">数据表</param>
/// <param name="targetTableName">数据库目标表名</param>
/// <returns></returns>
public bool ExcuteBulkData(DataTable table, string targetTableName)
{
    bool result = false;
    using (OracleConnection conn = new OracleConnection(connectionString))
    {
        using (OracleBulkCopy bulkCopy = new OracleBulkCopy(connectionString,OracleBulkCopyOptions.Default))
        {
            if (table != null && table.Rows.Count > 0)
            {
                
                bulkCopy.DestinationTableName = targetTableName;
                
                for (int i = 0; i<table.Columns.Count; i++)
                {
                    string col = table.Columns[i].ColumnName;
                    bulkCopy.ColumnMappings.Add(col, col); 
                }
                conn.Open();
                bulkCopy.WriteToServer(table);
                result = true;
            }
        }
    }
    return result;
}