主题：取表中多个列的数值进自动编号怎么弄

 

Dim lb As string = e.DataRow("电压") & e.DataRow("容量") & e.DataRow("膜厚") & e.DataRow("相别")

 

max = e.DataTable.Compute("max(产品编号)", "产品编号 like '" & lb & "%' and _Identify <> " & e.DataRow("_Identify"))

贴出你写的代码

Select e.DataCol.Name
    Case "容量","电压","外壳直径","膜厚","相别"
          If e.DataRow.IsNull("外壳直径") orelse e.datarow.isnull("电压") orelse e.datarow.isnull("外壳直径") orelse e.datarow.isnull("膜厚") orelse e.datarow.isnull("相别") Then
            e.DataRow("产品编号") = Nothing
        Else
           Dim lb As String = e.DataRow("电压") & e.DataRow("容量") & e.DataRow("膜厚") & e.DataRow("相别") & e.DataRow("外壳直径")
            If e.DataRow("产品编号").StartsWith(lb) = False '如果单据编号前缀不符
                Dim max As String
                Dim idx As Integer
                max = e.DataTable.Compute("max(产品编号)", "产品编号 like '" & lb & "%' and _Identify <> " & e.DataRow("_Identify"))  '取得该类别的最大编号
                If max > "" Then '如果存在最大编号
                    idx = CInt(max.Substring(lb.length,3)) + 1 '获得最大编号的后三位顺序号,并加1
                Else
                    idx = 1 '否则顺序号等于1
                End If
                e.DataRow("产品编号") = lb & Format(idx,"000")
            End If
        End If
End Select