Foxtable(狐表)用户栏目专家坐堂 → [求助]专业报表 去掉表格最后两行线


  共有1864人关注过本帖平板打印复制链接

主题:[求助]专业报表 去掉表格最后两行线

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


加好友 发短信
等级:八尾狐 帖子:1814 积分:19234 威望:0 精华:0 注册:2013/4/10 14:38:00
[求助]专业报表 去掉表格最后两行线  发帖心情 Post By:2020/6/6 17:50:00 [只看该作者]


此主题相关图片如下:1.jpg
按此在新窗口浏览图片

 


 

Dim doc As New PrintDoc() '定义一个报表
doc.PageSetting.Width = 130 '纸张宽度为100毫米
doc.PageSetting.Height = 190 '纸张高度为120毫米
Doc.PageSetting.LeftMargin = 5 '设置左边距
Doc.PageSetting.RightMargin = 5 '设置右边距
Doc.PageSetting.TopMargin = 5 '设置上边距
Doc.PageSetting.BottomMargin = 5 '设置下边距

Dim rt As New prt.RenderTable() '定义一个表格对象
doc.Body.Children.Add(rt) '将表格对象加入到报表中
rt.Style.GridLines.All = New prt.LineDef '将网格线类型设为默认类型
rt.Width = 120 '表宽为150毫米
rt.Height = 170 '表高为150毫米
rt.Rows.Count = 25 '设置行数
rt.Cols.Count = 8 '设置列数

rt.Style.TextAlignHorz = prt.AlignHorzEnum.Center
rt.Style.TextAlignVert = prt.AlignVertEnum.Center

rt.Rows(0).Height = 12 '标题行高
rt.Cells(0,0).SpanCols = 8 '合拼表头
rt.cells(0,0).text = "胸围制衣厂送货单"
rt.cells(0,0).Style.Font = New Font("宋体", 18, FontStyle.Bold) '设置字体
rt.Rows(0).Style.Borders.All = New prt.LineDef("0mm", Color.white) '去掉第一行表格线
rt.Rows(0).Style.Borders.Bottom = New prt.Linedef '增加第一行底线


rt.Rows(6).Style.TextAlignHorz = prt.AlignHorzEnum.Center
rt.Rows(6).Style.TextAlignVert = prt.AlignVertEnum.Center
rt.Cells(1,1).SpanCols = 4
rt.Cells(1,6).SpanCols = 2
rt.cells(1,0).text = "地    址"
rt.cells(1,1).text = ""
rt.cells(1,5).text = "单号"
rt.cells(1,6).text = ""


rt.Cells(2,1).SpanCols = 4
rt.Cells(2,6).SpanCols = 2
rt.cells(2,0).text = "手    机"
rt.cells(2,1).text = ""
rt.cells(2,5).text = "组名"
rt.cells(2,6).text = ""

rt.Cells(3,1).SpanCols = 4
rt.Cells(3,6).SpanCols = 2
rt.cells(3,0).text = "收货单位"
rt.cells(3,1).text = ""
rt.cells(3,5).text = "款号"
rt.cells(3,6).text = ""
 
rt.Cells(4,1).SpanCols = 4
rt.Cells(4,6).SpanCols = 2
rt.cells(4,0).text = "收货地址"
rt.cells(4,1).text = ""
rt.cells(4,5).text = "颜色"
rt.cells(4,6).text = ""


rt.Cells(5,1).SpanCols = 4
rt.Cells(5,6).SpanCols = 2
rt.cells(5,5).text = "日期"
rt.cells(5,6).text = ""

 

 

 

rt.Cells(6,0).text = "尺码"
rt.Cells(6,1).text = "件数"

rt.Cells(6,2).text = "尺码"
rt.Cells(6,3).text = "件数"

rt.Cells(6,4).text = "尺码"
rt.Cells(6,5).text = "件数"

rt.Cells(6,6).text = "尺码"
rt.Cells(6,7).text = "件数"

'rt.Rows(6).Style.TextAlignHorz = prt.AlignHorzEnum.Center
'rt.Rows(6).Style.TextAlignVert = prt.AlignVertEnum.Center

 

 

 

 

 


rt.Rows(22).Height = 20 '标题行高
rt.cells(22,0).text = "备注"
rt.Cells(22,1).SpanCols = 7

rt.cells(23,0).text = "收货单位"
rt.cells(24,0).text = "及经手人"
rt.Cells(23,1).SpanCols = 3
rt.cells(23,1).SpanRows = 2
rt.cells(23,1).text = "(盖章)"

rt.cells(23,4).text = "送货单位"
rt.cells(24,4).text = "及经手人"
rt.Cells(23,5).SpanCols = 3
rt.cells(23,5).SpanRows = 2
rt.cells(23,5).text = "(盖章)"
'rt.Rows(23).Style.Borders.All = New prt.LineDef("0mm", Color.white) '去掉第一行表格线
'rt.Rows(23).Style.Borders.vert = New prt.LineDef("0mm", Color.white) '去掉第一行表格线

'rt.Rows(24).Style.Borders.All = New prt.LineDef("0mm", Color.white) '去掉第一行表格线
'rt.Rows(0).Style.Borders.Bottom = New prt.Linedef '增加第一行底线


doc.Preview() '预览

 

 

 


此主题相关图片如下:2.jpg
按此在新窗口浏览图片

 

 


此主题相关图片如下:3.jpg
按此在新窗口浏览图片

 回到顶部