-- 作者: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编辑过]
|