主题：自动编号问题

 参考 http://www.foxtable.com/help/topics/2403.htm

DataColChanged事件

Select e.DataCol.Name
    Case "第一代码", "第二代码"
        If e.DataRow.IsNull("第一代码") OrElse e.DataRow.IsNull("第二代码") Then
            e.DataRow("编号") = Nothing
        Else
            Dim lb As String = "BY" & e.DataRow("第一代码") & e.DataRow("第二代码")
            Dim max As String
            Dim idx As Integer
            max = e.DataTable.Compute("Max(编号)","编号 like '" & lb & "%' And [_Identify] <> " & e.DataRow("_Identify")) '取得该类别的最大编号
            If max > "" Then '如果存在最大编号
                idx = CInt(max.Substring(lb.length)) + 1 '获得最大编号的后三位顺序号,并加1
            Else
                idx = 1 '否则顺序号等于1
            End If
            e.DataRow("编号") = lb & Format(idx,"000")
        End If
End Select

mark 断号

Select e.DataCol.Name
    Case "第一代码", "第二代码"
        If e.DataRow.IsNull("第一代码") OrElse e.DataRow.IsNull("第二代码") Then
            e.DataRow("编号") = Nothing
        Else
            Dim flag As Boolean = False
            Dim lb As String = "BY" & e.DataRow("第一代码") & e.DataRow("第二代码")
            Dim bhs As List(of String) = e.DataTable.GetValues("编号", "编号 Like '" & lb & "%' And [_Identify] <> " & e.DataRow("_Identify"))
            For i As Integer = 1 To bhs.count
                If bhs(i-1) <> lb & Format(i, "000") Then
                    lb = lb & Format(i, "000")
                    flag = True
                    Exit For
                End If
            Next
            If bhs.count = 0 Then
                lb = lb & "001"
            ElseIf flag = False Then
                lb = lb & Format(bhs.count+1, "000")
            End If
            e.DataRow("编号") = lb
        End If
End Select