Else If cnt = 0 Then
Dim drs4 As List(of DataRow) = DataTables("比赛积分").SQLSelect("[棋赛名称] = '" & di1 & "' And [第几轮比赛] = '" & a & "' And [分组] = '" & Str & "'","","日期 Desc,分组,上轮止累计积分 Desc,曾交战对手累计积分")
For ic As Integer = 0 To drs4.Count - 1
dr = DataTables("比赛积分").AddNew
Dim dts2 As DataRow = DataTables("基本信息").SQLFind("[棋赛名称] = '" & di1 & "'And [身份] = '参赛人' And [缺赛轮号] like '%" & di2 & "%' and [编号] = '" & drs4(ic)("编号") & "'")
If dts2 IsNot Nothing Then
dr("排序") = 0
Else
dr("排序") = ((ii2) + 1) \ 2
ii2 + = 1
End If
dr("棋赛名称") = di1
dr("第几轮比赛") = di2
dr("日期") = di3
dr("编号") = drs4(ic)("编号")
dr("姓名") = drs4(ic)("姓名")
dr("轮赛次数值转换") = Val(di2)
dr("分组") = Str
dr("上轮止累计积分") = drs4(ic)("上轮止累计积分") + drs4(ic)("积分")
dr("曾交战对手累计积分") = drs4(ic)("曾交战对手累计积分") + DataTables("比赛积分").SQLCompute("SUM(积分)","[分组] = '" & Str & "' And [排序] = " & drs4(ic)("排序") & "And [编号] <> '" & drs4(ic)("编号") & "'and [姓名] <> '" & drs4(ic)("姓名") & "'")
i2 + = 1
Next
'Dim drs5 As List(of DataRow) = DataTables("比赛积分").SQLSelect("[棋赛名称] = '" & di1 & "'And [第几轮比赛] = '" & di2 & "' And [分组] = '" & Str & "' And [排序] <> 0","","日期 Desc,分组,上轮止累计积分 Desc,曾交战对手累计积分")
DataTables("比赛积分").Load
DataTables("比赛积分").Save()
DataTables("综合组").DataRows.Clear
Dim drs5 As List(of DataRow) = DataTables("比赛积分").SQLSelect("[棋赛名称] = '" & di1 & "'And [第几轮比赛] = '" & di2 & "' And [分组] = '" & Str & "' And [排序] <> 0","","日期 Desc,分组,排序,上轮止累计积分 Desc,曾交战对手累计积分")
For id As Integer = 0 To drs5.count - 1 Step 2
Dim c As Integer = rand.Next(0,2)
Dim c1 As Integer = IIF(c = 0,1,0)
c = id+c
c1 = id+c1
Dim nr As DataRow = DataTables("综合组").AddNew
nr("桌号") = drs5(c)("排序")
If c <= drs5.Count - 1
nr("红方_编号") = drs5(c)("编号")
nr("红方_姓名") = drs5(c)("姓名")
nr("红方_上轮止累计积分") = drs5(c)("上轮止累计积分")
nr("红方_曾交战对手累计积分") = drs5(c)("曾交战对手累计积分")
End If
If c1 <= drs5.Count - 1
nr("黑方_编号") = drs5(c1)("编号")
nr("黑方_姓名") = drs5(c1)("姓名")
nr("黑方_上轮止累计积分") = drs5(c1)("上轮止累计积分")
nr("黑方_曾交战对手累计积分") = drs5(c1)("曾交战对手累计积分")
End If
Next
DataTables("比赛积分").SQLUpdate(drs5)
drs5 = DataTables("比赛积分").SQLSelect("[棋赛名称] = '" & di1 & "'And [第几轮比赛] = '" & di2 & "' And [分组] = '" & Str & "' And [排序] = 0","","日期 Desc,分组,排序,上轮止累计积分 Desc,曾交战对手累计积分")
For id As Integer = 0 To drs5.count - 1 Step 2
Dim c As Integer = rand.Next(0,2)
Dim c1 As Integer = IIF(c = 0,1,0)
c = id+c
c1 = id+c1
Dim nr As DataRow = DataTables("综合组").AddNew
nr("桌号") = 0
If c <= drs5.Count - 1
nr("红方_编号") = drs5(c)("编号")
nr("红方_姓名") = drs5(c)("姓名")
nr("红方_上轮止累计积分") = drs5(c)("上轮止累计积分")
nr("红方_曾交战对手累计积分") = drs5(c)("曾交战对手累计积分")
End If
If c1 <= drs5.Count - 1
nr("黑方_编号") = drs5(c1)("编号")
nr("黑方_姓名") = drs5(c1)("姓名")
nr("黑方_上轮止累计积分") = drs5(c1)("上轮止累计积分")
nr("黑方_曾交战对手累计积分") = drs5(c1)("曾交战对手累计积分")
End If
Next
DataTables("比赛积分").SQLUpdate(drs5)
End If
Tables("比赛积分").Sort = "日期 DESC,棋赛名称,分组,轮赛次数值转换 DESC"