以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.com/bbs/index.asp)
--  专家坐堂  (http://foxtable.com/bbs/list.asp?boardid=2)
----  为什么在Access数据库中,为什么会出现断号?  (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=152693)

--  作者:ZJZK2018
--  发布时间:2020/7/18 22:58:00
--  为什么在Access数据库中,为什么会出现断号?

为什么在Access数据库中,为什么会出现断号?

 

Select Case e.DataCol.Name
    Case "客户名称","客户类型","录入日期"
        If dr.IsNull("客户名称") OrElse dr.IsNull("客户类型") OrElse dr.IsNull("录入日期") Then    \'其中有一个是空时
            dr("客户编号") = Nothing
        Else
            If dr("审核") = False  Then
                Dim flag As Boolean = False
                Dim d As Date = e.DataRow("录入日期")   \'提取开标日期的年份
                Dim bh As String = Format(d, "yyyy")
                Dim lb As String = "CH" & bh & "-"
                Dim bhs As List(of String) = e.DataTable.SQLGetValues("客户编号", "客户编号 Like \'" & lb & "%\' And [_Identify] <> " & dr("_Identify"))
                For i As Integer = 1 To bhs.Count
                    If bhs(i-1) <> lb & Format(i, "0000") Then
                        lb = lb & Format(i, "0000")
                        flag = True
                        Exit For
                    End If
                Next
                If bhs.Count = 0 Then
                    lb = lb & "0001"
                ElseIf flag = False Then
                    lb = lb & Format(bhs.Count + 1, "0000")
                End If
                e.DataRow("客户编号") = lb
                e.DataRow.Save()
            Else
                Return
            End If
        End If
End Select

[此贴子已经被作者于2020/7/18 23:10:16编辑过]

--  作者:有点蓝
--  发布时间:2020/7/19 20:50:00
--  
断号是很正常的事。比如删除记录,并发使用等等