假如表有4列，第一列单号，第二列门店名称，第三列数量，第四列金额，我想相同把门店名称的金额合计和数量合计还有单子的数量合计，按照金额排名，取前十显示在一个临时表，该怎么操作呢？我现在做了一个统计表，但是统计表不能排序，我又增加了一个新临时表，然后可以排序，但是无法控制行数，而且加载速度很慢。Dim g As New GroupTableBuilder("QTXPDHJ", DataTables("SG_Gathering"))
g.Groups.AddDef("vShop")
g.Totals.AddDef("fQuantity")
g.Totals.AddDef("fRealMoney")
g.Totals.AddDef("vMBillID", AggregateEnum.Count)
g.FromServer = False
g.Build()
Dim dt As DataTable = DataTables("DPXSPHB")
dt.DataRows.Clear
Dim Cols1() As String = {"vShop","fQuantity","fRealMoney","vMBillID"}
Dim Cols2() As String = {"MDDM","XSSL","XSJE","XSDS"}
For Each dr1 As DataRow In DataTables("QTXPDHJ").Select("fRealMoney > 1","fRealMoney desc")
Dim dr2 As DataRow = DataTables("DPXSPHB").AddNew()
For i As Integer = 0 To Cols1.Length -1
dr2(Cols2(i)) = dr1(Cols1(i))
Next
Next
[此贴子已经被作者于2020/6/21 5:47:08编辑过]
加好友 
发短信
Post By：2020/6/20 20:55:00 [只看该作者]
