Foxtable(狐表)用户栏目专家坐堂 → 请教专业报表:控制每页9行


  共有4454人关注过本帖树形打印复制链接

主题:请教专业报表:控制每页9行

帅哥哟,离线,有人找我吗?
有点甜
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:版主 帖子:85326 积分:427815 威望:0 精华:5 注册:2012/10/18 22:13:00
  发帖心情 Post By:2013/11/27 20:00:00 [显示全部帖子]

 如下代码,测试有效


Dim doc As New Printdoc
Dim rx As prt.RenderText
Dim rt As prt.RenderTable
Dim Rows As List(Of DataRow)
Dim tbl As Table = Tables("订单")

doc.PageSetting.Width = 240 '纸张宽度为100毫米
doc.PageSetting.Height = 140 '纸张高度为120毫米
Doc.PageSetting.LeftMargin = 8 '设置左边距
Doc.PageSetting.RightMargin = 8 '设置右边距
Doc.PageSetting.TopMargin = 15 '设置上边距
Doc.PageSetting.BottomMargin = 8 '设置下边距
For i As Integer = tbl.TopRow To tbl.BottomRow
    Rows = Tables("订单").Rows(i).DataRow.GetChildRows("订单明细")
    For j As Integer = 0 To math.Ceiling(Rows.Count / 9) - 1
        rx = New prt.RenderText
        rx.BreakBefore = prt.BreakEnum.Page '另起一页再打印
        rx.Style.FontSize = 14
        rx.Style.FontBold = True
        rx.Style.Spacing.Bottom = 5
        rx.Text = "订单编号: " & Tables("订单").Rows(i)("订单编号")
        doc.Body.Children.Add(rx)
        rt = New prt.RenderTable
        rt.Style.TextAlignHorz = prt.AlignHorzEnum.Center
        rt.Style.TextAlignVert = prt.AlignVertEnum.Center
        rt.Style.Borders.Bottom = New prt.LineDef(0.3,Color.LightGray)
        rt.CellStyle.Spacing.All = 1
        rt.Cols.Count = 4
        rt.Cells(0,0).Text = "商品名称"
        rt.Cells(0,1).Text = "规格型号"
        rt.Cells(0,2).Text = "计量单位"
        rt.Cells(0,3).Text = "数量"
        rt.Cells(0,4).Text = "单价"
        rt.Cells(0,5).Text = "金额"
        rt.rows(0).Style.Borders.Top = New prt.LineDef(0.1,Color.LightGray)
        rt.rows(0).Style.Borders.Bottom = New prt.LineDef(0.1,Color.LightGray)
        
        For r As Integer = j*9 To (j+1)*9-1
            If r < Rows.count
                rt.Cells(r+1,0).Text = rows(r)("商品名称")
                rt.Cells(r+1,1).Text = rows(r)("规格型号")
                rt.Cells(r+1,2).Text = rows(r)("计量单位")
                rt.Cells(r+1,3).Text = rows(r)("数量")
                rt.Cells(r+1,4).Text = rows(r)("单价")
                rt.Cells(r+1,5).Text = rows(r)("金额")
            End If
        Next
        doc.Body.Children.Add(rt)
        rx = New prt.RenderText
        rx.Style.FontBold = True
        rx.Style.Spacing.Top = 3
        rx.Text = "产品数目: " & Rows.Count
        rx.Style.TextAlignHorz = prt.AlignHorzEnum.Right
        
        doc.Body.Children.Add(rx)
        
    Next
Next
doc.Preview

 回到顶部