Dim b1 As New SQLGroupTableBuilder("统计表1","统计表")
b1.ConnectionName = "Sale"
b1.Groups.AddDef("部门名称")
b1.Groups.AddDef("年份")
b1.Groups.AddDef("月份")
b1.Totals.AddDef("保底")
b1.Totals.AddDef("保底期")
b1.Totals.AddDef("实际")
b1.build
DataTables("统计表1").dataCols.add("月度差距", Gettype(Double))
DataTables("统计表1").dataCols.add("累计差距", Gettype(Double))
Dim t1 As Table = Tables("统计表1")
For Each r1 As Row In t1.Rows
r1("月度差距") =r1("实际")-r1("保底")
Next
Dim bjs As List(Of String) = DataTables("统计表1").GetValues("部门名称|保底期")
For Each bj As String In bjs
Dim drs As List(Of DataRow) = DataTables("统计表1").Select("部门名称 = '" & bj(0) & "' and 保底期 = '" & bj(1) & "'")
For n As Integer = 0 To drs.Count - 1
If n > 0 Then
drs(n)("累计差距") = drs(n-1)("月度差距")+drs(n)("月度差距")
End If
Next
Next
改成这样,出现以下错误,看不懂
无法将类型为“System.Collections.Generic.List`1[System.String[]]”的对象强制转换为类型“System.Collections.Generic.List`1[System.String]”。