老师好:
我想达到的目的是:
后面的流水号不要规定位数,不管多少位数一直延下去
如:
要:2017-51,2017-52,2017-53;
不要:2017-5001,2017-5002,2017-5003;
请老师帮忙,修改一下代码,多谢!
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