效果作出来了,数据也跟比赛积分表的匹配了,开心。
Dim qsmc As WinForm.ComboBox = e.Form.Controls("棋赛名称")
Dim di1 As String = qsmc.Value
Dim m As WinForm.TextBox = e.Form.Controls("第几轮")
Dim di2 As String = m.Value
Dim fz As WinForm.ComboBox = e.Form.Controls("fenzhu")
Dim Str As String = fz.Value
DataTables("查询").DataRows.Clear
Dim drs6 As List(of DataRow) = DataTables("比赛积分").SQLSelect("[棋赛名称] = '" & di1 & "'And [第几轮比赛] = '" & di2 & "' And [分组] = '" & Str & "' And [桌号] > 0","","桌号")
Dim drs7 As List(of DataRow) = DataTables("比赛积分").SQLSelect("[棋赛名称] = '" & di1 & "'And [第几轮比赛] = '" & di2 & "' And [分组] = '" & Str & "' And [桌号] > 0 And [红黑方] = '红方'","","桌号")
Dim drs8 As List(of DataRow) = DataTables("比赛积分").SQLSelect("[棋赛名称] = '" & di1 & "'And [第几轮比赛] = '" & di2 & "' And [分组] = '" & Str & "' And [桌号] > 0 And [红黑方] = '黑方'","","桌号")
For ci As Integer = 0 To (drs6.Count) \ 2
Dim cx As DataRow = DataTables("查询").AddNew
If ci < drs7.count - 1 And ci <= drs8.count - 1 Then
cx("桌号") = drs7(ci)("桌号")
cx("红方_编号") = drs7(ci)("编号")
cx("红方_姓名") = drs7(ci)("姓名")
cx("红方_上轮止累计积分") = drs7(ci)("上轮止累计积分")
cx("红方_曾交战对手累计积分") = drs7(ci)("曾交战对手累计积分")
cx("当前局成绩_红方") = IIF(drs7(ci).IsNull("积分"),"0",drs7(ci)("积分"))
cx("黑方_编号") = drs8(ci)("编号")
cx("黑方_姓名") = drs8(ci)("姓名")
cx("黑方_上轮止累计积分") = drs8(ci)("上轮止累计积分")
cx("黑方_曾交战对手累计积分") = drs8(ci)("曾交战对手累计积分")
cx("当前局成绩_黑方") = IIF(drs8(ci).IsNull("积分"),"0",drs8(ci)("积分"))
End If
If ci <= drs7.count - 1 And ci > drs8.count - 1 Then
cx("桌号") = drs7(ci)("桌号")
cx("红方_编号") = drs7(ci)("编号")
cx("红方_姓名") = drs7(ci)("姓名")
cx("红方_上轮止累计积分") = drs7(ci)("上轮止累计积分")
cx("红方_曾交战对手累计积分") = drs7(ci)("曾交战对手累计积分")
cx("当前局成绩_红方") = IIF(drs7(ci).IsNull("积分"),"0",drs7(ci)("积分"))
cx("黑方_编号") = Nothing
cx("黑方_姓名") = Nothing
cx("黑方_上轮止累计积分") = 0
cx("黑方_曾交战对手累计积分") = 0
cx("当前局成绩_黑方") = 0
End If
If ci > drs7.count - 1 And ci <= drs8.count - 1 Then
cx("红方_编号") = Nothing
cx("红方_姓名") = Nothing
cx("红方_上轮止累计积分") = 0
cx("红方_曾交战对手累计积分") = 0
cx("当前局成绩_红方") = 0
cx("桌号") = drs8(ci)("桌号")
cx("黑方_编号") = drs8(ci)("编号")
cx("黑方_姓名") = drs8(ci)("姓名")
cx("黑方_上轮止累计积分") = drs8(ci)("上轮止累计积分")
cx("黑方_曾交战对手累计积分") = drs8(ci)("曾交战对手累计积分")
cx("当前局成绩_黑方") = IIF(drs8(ci).IsNull("积分"),"0",drs8(ci)("积分"))
End If
Next
Dim drs9 As List(of DataRow) = DataTables("比赛积分").SQLSelect("[棋赛名称] = '" & di1 & "'And [第几轮比赛] = '" & di2 & "' And [分组] = '" & Str & "' And [桌号] = 0","","桌号")
Dim drs10 As List(of DataRow) = DataTables("比赛积分").SQLSelect("[棋赛名称] = '" & di1 & "'And [第几轮比赛] = '" & di2 & "' And [分组] = '" & Str & "' And [桌号] = 0 And [红黑方] = '红方'","","桌号")
Dim drs11 As List(of DataRow) = DataTables("比赛积分").SQLSelect("[棋赛名称] = '" & di1 & "'And [第几轮比赛] = '" & di2 & "' And [分组] = '" & Str & "' And [桌号] = 0 And [红黑方] = '黑方'","","桌号")
For hi As Integer = 0 To (drs9.Count) \ 2
Dim cx As DataRow = DataTables("查询").AddNew
If hi <= drs10.count - 1 And hi < drs11.count - 1 Then
cx("桌号") = 0
cx("红方_编号") = drs10(hi)("编号")
cx("红方_姓名") = drs10(hi)("姓名")
cx("红方_上轮止累计积分") = drs10(hi)("上轮止累计积分")
cx("红方_曾交战对手累计积分") = drs10(hi)("曾交战对手累计积分")
cx("当前局成绩_红方") = IIF(drs10(hi).IsNull("积分"),"0",drs10(hi)("积分"))
cx("黑方_编号") = drs11(hi)("编号")
cx("黑方_姓名") = drs11(hi)("姓名")
cx("黑方_上轮止累计积分") = drs11(hi)("上轮止累计积分")
cx("黑方_曾交战对手累计积分") = drs11(hi)("曾交战对手累计积分")
cx("当前局成绩_黑方") = IIF(drs11(hi).IsNull("积分"),"0",drs11(hi)("积分"))
End If
If hi <= drs10.count - 1 And hi > drs11.count - 1 Then
cx("桌号") = 0
cx("红方_编号") = drs10(hi)("编号")
cx("红方_姓名") = drs10(hi)("姓名")
cx("红方_上轮止累计积分") = drs10(hi)("上轮止累计积分")
cx("红方_曾交战对手累计积分") = drs10(hi)("曾交战对手累计积分")
cx("当前局成绩_红方") = IIF(drs10(hi).IsNull("积分"),"0",drs10(hi)("积分"))
cx("黑方_编号") = Nothing
cx("黑方_姓名") = Nothing
cx("黑方_上轮止累计积分") = 0
cx("黑方_曾交战对手累计积分") = 0
cx("当前局成绩_黑方") = 0
End If
If hi > drs10.count - 1 And hi <= drs11.count - 1 Then
cx("红方_编号") = Nothing
cx("红方_姓名") = Nothing
cx("红方_上轮止累计积分") = 0
cx("红方_曾交战对手累计积分") = 0
cx("当前局成绩_红方") = 0
cx("桌号") = 0
cx("黑方_编号") = drs11(hi)("编号")
cx("黑方_姓名") = drs11(hi)("姓名")
cx("黑方_上轮止累计积分") = drs11(hi)("上轮止累计积分")
cx("黑方_曾交战对手累计积分") = drs11(hi)("曾交战对手累计积分")
cx("当前局成绩_黑方") = IIF(drs11(hi).IsNull("积分"),"0",drs11(hi)("积分"))
End If
Next
[此贴子已经被作者于2020/6/30 13:52:38编辑过]