Rss & SiteMap
Foxtable(狐表) http://www.foxtable.com
主题规范醒目 → 则容易吸引眼球 → 则人气旺盛 → 则有利狐表发展!
如:
【狐求助】请教跨表统计的代码
......
主题规范醒目 → 则容易吸引眼球 → 则人气旺盛 → 则有利狐表发展!
如:
【狐求助】请教跨表统计的代码
......
呵呵
Dim T2 As DataRow = e.DataRow
Dim Str As String
Str = "[IO] = '" & T2("IO") & "' And [口岸] = '" & T2("口岸") & "'And [色号] = '" & T2("色号") & "'And [色名] = '" & T2("色名") & "'And [运输方式] = '" & T2("运输方式") & "'and[包装]='" & T2("包装") & "'"
Select Case e.DataCol.Name
Case "IO","口岸","色号","色名","运输方式","包装"
T2("XS") = DataTables("装箱单").Compute("Sum(XS)",Str)*DataTables("装箱单").Compute("Sum(箱数)",Str)
T2("S") = DataTables("装箱单").Compute("Sum(S)",Str)
T2("M") = DataTables("装箱单").Compute("Sum(M)",Str)
T2("L") = DataTables("装箱单").Compute("Sum(L)",Str)
T2("XL") = DataTables("装箱单").Compute("Sum(XL)",Str)
T2("XXL") = DataTables("装箱单").Compute("Sum(XXL)",Str)
T2("XXXL") = DataTables("装箱单").Compute("Sum(XXXL)",Str)
End Select
Dim T2 As DataRow = e.DataRow
Dim Str As String
Str = "[IO] = '" & T2("IO") & "' And [口岸] = '" & T2("口岸") & "'And [色号] = '" & T2("色号") & "'And [色名] = '" & T2("色名") & "'And [运输方式] = '" & T2("运输方式") & "'and[包装]='" & T2("包装") & "'"
Select Case e.DataCol.Name
Case "IO","口岸","色号","色名","运输方式","包装"
T2("XS") = DataTables("装箱单").Compute("Sum(XS)",Str)*DataTables("装箱单").Compute("Sum(箱数)",Str)
T2("S") = DataTables("装箱单").Compute("Sum(S)",Str)
T2("M") = DataTables("装箱单").Compute("Sum(M)",Str)
T2("L") = DataTables("装箱单").Compute("Sum(L)",Str)
T2("XL") = DataTables("装箱单").Compute("Sum(XL)",Str)
T2("XXL") = DataTables("装箱单").Compute("Sum(XXL)",Str)
T2("XXXL") = DataTables("装箱单").Compute("Sum(XXXL)",Str)
End Select
呵呵,适合这个:【狐狸糊涂】 | → | 糊涂糊涂 |