按钮是先新增一个条目
Dim r As Row = Tables("样车参数").Current
If e.Form.Controls("DateTimePicker1") Is Nothing Then
MessageBox.Show("请填写入库时间!", "提示")
Return
End If
If e.Form.Controls("TextBox2").text ="" Then
MessageBox.Show("请完善车辆信息!", "提示")
Return
End If
'''''''''''样车编号'''''''''''''''''''
Dim dt As Date = e.Form.Controls("DateTimePicker1").value
Dim bh As String = Format(dt,"yyyyMMdd") '取得车辆编号的8位前缀
If r("车辆编号").StartsWith(bh) = False '如果车辆编号的前8位不符
Dim max As String
Dim idx As Integer
max = DataTables("样车参数").SQLCompute("Max(车辆编号)","入库时间 = #" & dt & "# And [_Identify] <> " & r("_Identify")) '取得该天的最大车辆编号
If max > "" Then '如果存在最大车辆编号
idx = CInt(max.Substring(9,3)) + 1 '获得最大车辆编号的后三位顺序号,并加1
Else
idx = 1 '否则顺序号等于1
End If
r("车辆编号") = bh & "-" & Format(idx,"000")
End If
'''''''''''''''''''''''''''''''''''''''
DataTables("样车参数").save()
Dim msg As String = "A#" & "样车参数" & "#" & e.Form.Controls("r").text
For Each bd As QQBuddy In QQClient.Buddies
If bd.Online Then
QQClient.Send(bd.name, msg)
End If
Next
e.Form.close()