密码:888888
在排座时有时忘了选时间,如果窗口已关闭,控件上原选定的数据全没了,只能重新选定,我想实现重新选定后在保存按钮中保存或修改时间,这段代码比赛积分表上的时间并没有替换。
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 bsrq As WinForm.DateTimePicker = e.Form.Controls("rq")
Dim di3 As Date = bsrq.Value
Dim fz As WinForm.ComboBox = e.Form.Controls("fenzhu")
Dim Str As String = fz.Value
For Each nr As Row In Tables("综合组").Rows
Dim dr As DataRow = DataTables("比赛积分").SQLfind("[棋赛名称] = '" & di1 & "' And [第几轮比赛] = '" & di2 & "' And [分组] = '" & Str & "' And [编号] = '" & nr("红方_编号") & "'")
If di3 = "" Then
dr("日期").Cancel = True
Else
dr("日期") = di3
End If
If dr IsNot Nothing Then
dr("桌号") = nr("桌号")
dr("红黑方") = "红方"
dr("积分") = nr("当前局成绩_红方")
dr.Save
End If
dr = DataTables("比赛积分").SQLfind("[棋赛名称] = '" & di1 & "' And [第几轮比赛] = '" & di2 & "' And [分组] = '" & Str & "' And [编号]='" & nr("黑方_编号") & "'")
If dr IsNot Nothing Then
dr("桌号") = nr("桌号")
dr("红黑方") = "黑方"
dr("积分") = nr("当前局成绩_黑方")
dr.Save
End If
Next