2、比赛跑道中4、5道最好，依次为3、6道，2、7道，1、8道。为了公平，每个单位尽量均等的分配1至8道。如管理系某个运动员在1组中分配了4道，

那么管理系的另一个运动员在2组中最好分配1道或者8道。

3、以上只是理论上的要求，只要大至符合就可以了，表B是个参考。

请问“分组分道”按键代码应该如何编写？

Dim dt As DataTable = DataTables("表A")

dt.ReplaceFor("组别", Nothing, Tables("表A").Filter)

dt.ReplaceFor("道次", Nothing, Tables("表A").Filter)

Dim dws As List(Of String) = dt.GetValues("单位", Tables("表A").Filter)

Dim filter As String = iif(Tables("表A").Filter > "", " and 组别 is null and 道次 is null and " & Tables("表A").Filter, " and 组别 is null and 道次 is null")

Dim rcount As Integer = Tables("表A").Rows.count

Dim msg As String = ""

For i As Integer = 1 To rcount \\ 8

    Dim ary(3) As String

    For j As Integer = 1 To 4

        Dim giveup As Integer = 0

        Do While giveup < 10

            Dim dw As String = dws(Rand.Next(dws.count))

            If Array.Indexof(ary, dw) > -1 Then

                giveup += 1

            Else

                Dim fdr As DataRow = dt.Find("单位 = \'" & dw & "\'" & filter)

                If fdr IsNot Nothing Then

                    fdr("组别") = i

                    fdr("道次") = j

                    ary(j-1) = dw

                    Exit Do

                End If

                

            End If

        Loop

        If giveup >= 10 Then

            Do While 1

                Dim dw As String = dws(Rand.Next(dws.count))

                Dim fdr As DataRow = dt.Find("单位 = \'" & dw & "\'" & filter)

                If fdr IsNot Nothing Then

                    fdr("组别") = i

                    fdr("道次") = j

                    ary(j-1) = dw

                    Exit Do

                End If

            Loop

        End If

    Next

    For j As Integer = 5 To 8

        Dim fdr As DataRow = dt.Find("单位 = \'" & ary(j-5) & "\'" & filter)

        If fdr Is Nothing Then

            msg += "(" & i & "," & j & ")缺值" & vbcrlf

        Else

            fdr("组别") = i

            fdr("道次") = j

        End If

    Next

Next

output.show(msg)

Tables("表A").sort = "组别, 道次"