老师：

Dim dr As DataRow = e.DataRow
Select Case e.DataCol.Name
    Case "工号"
        If dr.isnull("工号")  OrElse dr("工号").length <= 2
            dr("铭牌编号") = dr("工号")
        Else
            Dim pattern As String = "[^\\d+]"
            Dim txt = dr("工号").split("-")(1)
            Dim str = System.Text.RegularExpressions.Regex.Replace(txt , pattern ,"")
            dr("铭牌编号") = str
        End If
End Select
If e.DataCol.name = "铭牌编号" OrElse e.DataCol.name="阀门序号1" Then
   If e.DataRow.isnull("铭牌编号")=False AndAlso e.DataRow.isnull("阀门序号1")=False Then
       e.DataRow("铭牌编号1")=e.DataRow("前缀") & e.DataRow("铭牌编号")& e.DataRow("阀门序号1")
   End If
End If

前缀为字母如ABC,阀门序号为3位整数如001，铭牌编号为字符，现在组合后不能实现如A19333001,代码出来为A193331

请老师帮忙看看，谢谢