Dim t As Table = Tables("同品名异归类")
Dim cs1 As C1.Win.C1FlexGrid.CellStyle = t.Grid.Styles.Add("样式1")
cs1.backcolor = Color.red
Dim cs2 As C1.Win.C1FlexGrid.CellStyle = t.Grid.Styles.Add("样式2")
cs2.backcolor = Color.green
Dim idx = t.grid.Cols("商品编码").Index
For i As Integer = 0 To t.Position
t.Grid.SetCellStyle(i, idx, "")
Next
For i As Integer = t.Position To t.Rows.count-1
If i <> t.Position Then
If t.Rows(i)("商品名称") <> t.Rows(i-1)("商品名称") Then
t.position = i
Exit For
End If
If t.Rows(i)("商品编码") <> t.Rows(i-1)("商品编码") Then
t.Grid.SetCellStyle(i+1, idx, cs2)
Dim c = cs1
cs1 = cs2
cs2 = c
Else
t.Grid.SetCellStyle(i+1, idx, cs1)
End If
Else
t.Grid.SetCellStyle(i+1, idx, cs1)
End If
Next