主题：这样的代码还能优化吗

普通的：

Select Case e.DataCol.name
    Case "电雕在制明细"
        If e.DataRow.IsNull("电雕在制明细") Then
            e.DataRow("电雕在制支数")="0"
        Else
            e.DataRow("电雕在制支数") = e.newvalue.split(",").Length
        End If
    Case "机加在制明细"
        If e.DataRow.IsNull("机加在制明细") Then
            e.DataRow("机加在制支数")="0"
        Else
            e.DataRow("机加在制支数") = e.newvalue.split(",").Length
        End If
    Case "镀铜在制明细"
        If e.DataRow.IsNull("镀铜在制明细") Then
            e.DataRow("镀铜在制支数")="0"
        Else
            e.DataRow("镀铜在制支数") = e.newvalue.split(",").Length
        End If
    Case "车研在制明细"
        If e.DataRow.IsNull("车研在制明细") Then
            e.DataRow("车研在制支数")="0"
        Else
            e.DataRow("车研在制支数") = e.newvalue.split(",").Length
        End If
    Case "镀铬在制明细"
        If e.DataRow.IsNull("镀铬在制明细") Then
            e.DataRow("镀铬在制支数")="0"
        Else
            e.DataRow("镀铬在制支数") = e.newvalue.split(",").Length
        End If
End Select

邪门的：

If  e.DataCol.name.EndsWith("在制明细") Then
    Dim zh As String = e.DataCol.name
    zh = zh.SubString(0, zh.Length-2) & "支数"
    If e.DataRow.IsNull(e.DataCol.name) Then
        e.DataRow(zh) = 0
    Else
        e.DataRow(zh) = e.newvalue.split(",").Length
    End If
End If

飞那个代码不严谨，要改一下：

Dim ArrColName1() As String = {"电雕在制明细","机加在制明细","镀铜在制明细","车研在制明细","镀铬在制明细"}
Dim ArrColName2() As String = {"电雕在制支数","机加在制支数","镀铜在制支数","车研在制支数","镀铬在制支数"}
Dim Index As Integer = Array.IndexOf(ArrColName1,e.DataCol.name)
If Index < 0 Then Return
If e.DataRow.IsNull(e.DataCol.name) Then
    e.DataRow(ArrColName2(Index)) = 0
Else
    e.DataRow(ArrColName2(Index)) = e.newvalue.split(",").Length
End If