主题：求助：编号代码

Select e.DataCol.Name
    Case "年份", "月份"
        If e.DataRow("辅助列") = Nothing Then
            Dim flag As Boolean = False
            Dim lb As String = e.DataRow("年份") &"-"& e.DataRow("月份")
            Dim bhs As List(of String) = e.DataTable.sqlGetValues("工令单号", "工令单号 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
e.DataRow.Save