|
Dim gx As object
Dim nms() As String = {"TextBox1","TextBox2","ComboBox1","ComboBox2","ComboBox3","ComboBox4","CheckBox1"}
Dim fgf() As String = {"'%","%'","'%","%'","'","'","'","'","'","'","'","'","'","'"}
Dim bjf() As String = {" Like "," Like "," = "," = "," = "," = "," = "}
Dim lms() As String = {"规格型号","mark","类别_大类","类别_小类","封装_类型","封装_引脚","同意采购"}
Dim filter As String
For i As Integer = 0 To nms.Length - 1
If Forms("技术部审核").Controls(nms(i)).value IsNot Nothing
If Forms("技术部审核").Controls(nms(i)).Name = "CheckBox1"
gx = Forms("技术部审核").Controls(nms(i)).Checked
Else
gx = Forms("技术部审核").Controls(nms(i)).value
End If
If filter > ""
filter = filter & " And "
End If
filter = filter & lms(i) & bjf(i) & fgf(i * 2) & gx & fgf(i * 2 + 1)
msgbox(filter)
End If
Next
Dim tnm As String = Forms("技术部审核").Name
'Forms("技术部审核").Controls("Table1").Table.filter = filter
|
加好友 
发短信
Post By：2016/3/31 11:37:00 [只看该作者]
