Rss & SiteMap
Foxtable(狐表) http://www.foxtable.com
Dim drs As List(of DataRow) = DataTables("出库").Select("出库日期 = #" & Date.Today & "#") '筛选出符合条件的行 If drs.Count > 0 Then '如果存在符合条件的行 Dim tm As String = ProjectPath & "Attachments\出库单.doc" '指定模板文件 Dim fl As String = ProjectPath & "Reports\出库单.doc" '指定目标文件 Dim wrt As New WordReport(Tables("出库"),tm,fl) '定义一个WordReport Dim dr2 As DataRow For Each dr As DataRow In drs '逐行生成报表 wrt.BuildOne(dr) if dr("拆分")="Y" then dr2 = DataTables("出库").addnew For Each dc As DataCol in DataTables("出库").DataCols dr2(dc.Name) = dr(dc.name) Next dr2("流水编码") = dr("流水编码") & "-1" wrt.BuildOne(dr2) dr2.delete end if Next wrt.Show() '显示报表 End If |