以文本方式查看主题

-  Foxtable(狐表)  (http://www.foxtable.com/bbs/index.asp)
--  专家坐堂  (http://www.foxtable.com/bbs/list.asp?boardid=2)
----  移动版数据汇总小计  (http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=114580)

--  作者:有点蓝
--  发布时间:2018/2/9 20:41:00
--  
For Each dr As DataRow In DataTables("财务流水").Select("[经手人] = \'" & U & "\'","日期 Desc")
    With wb.AddPreview("","pv" & dr("_Identify"),"经手人",dr("经手人")&"/-出:"&dr("支出")&"/-入:"&dr("收入"))
        .AddItem("科目",dr("科目"))
        .AddItem("收入",dr("收入"))
        .AddItem("支出",dr("支出"))
        .AddItem("摘要",dr("摘要"))
        .AddItem("附页",dr("附页"))
        .AddItem("流水编号", dr("流水编号"))
        .AddItem("说明", dr("说明"))
        .AddItem("汇总", DataTables("财务流水").Compute("sum(支出金额)","经手人=\'" & dr("经手人") & "\'"))
        .Addbutton("点赞", "", 1, "")
    End With
    wb.AppendHTML("<br/>")
Next