搜索输入“500*200”出现错误，只输入“500*”没问题
代码如下：
Dim t1 As WinForm.Table = e.Form.Controls("Table1")
Dim ids As List(Of String) = t1.Table.DataTable.GetValues("计划单号",t1.Table.Filter)
Dim t2 As WinForm.Table = e.Form.Controls("Table2")
Dim filter As String = "计划单号 in ('" & String.Join("','",ids.ToArray()) & "') "
Dim txt As WinForm.TextBox = e.Form.Controls("TextBox1")
If txt.Text > "" Then
filter = filter & " and 材料名称 like '%" & txt.Text & "%' or 规格型号 Like '*" & txt.text & "*' Or Convert([数量],'System.String') like '%" & txt.text & "%' "
t2.Table.Filter = filter
End If
此主题相关图片如下：搜索 带通配符 出现错误.jpg
加好友 
发短信
Post By：2016/9/30 10:21:00 [显示全部帖子]
