前面的sql语句都不用改.
Dim ef As String = ""
If dr("类别") = 1 Then
ef = "C"
ElseIf dr("类别") = 2 Then
ef = "D"
EndIf
dr("编号") = “C" & pf & Format(key, "00000") & ef