Dim trv As WinForm.TreeView = e.Form.Controls("TreeView1") Dim Name As String For Each nd As WinForm.TreeNode In trv.AllNodes If nd.Checked = True Then Name = Name & "'" & nd.Text & "'," End If Next Dim f1 As New Filler f1.SourceTable = DataTables("长期医嘱") f1.SourceCols = "患者姓名,住院号,拼音码,项目类别,项目名称,sys_单位,sys_规格,单价" f1.ExcludeExistValue= True f1.DataTable = DataTables("费用结算") f1.DataCols = "患者姓名,住院号,拼音码,项目类别,项目名称,单位,规格,单价" f1.Filter = "住院号 In (" & Name.Trim(",") & ")" f1.Distinct = True f1.Fill()
|