--
Dim filter=""
Dim chk As WinForm.CheckBox
chk = e.Form.Controls("chk_bh")
If chk.Checked = True
If filter = "" Then
filter= "工號=\'" & e.Form.Controls("txt_bh").text & "\' "
End If
End If
If e.Form.Controls("姓名").checked= True Then
If filter= "" Then
filter= "姓名 Like \'%" & e.Form.Controls("txt_name").text & "%\' "
Else
filter+= " and 姓名 Like \'%" & e.Form.Controls("txt_name").text & "%\' "
End If
End If
If e.Form.Controls("部门").checked= True Then
If filter= "" Then
filter= "部門 Like \'%" & e.Form.Controls("cmb_dept").text & "%\' "
Else
filter+= " and 部門 Like \'%" & e.Form.Controls("cmb_dept").text & "%\' "
End If
End If
If e.Form.Controls(e.Form.Controls("职务")).checked= True Then
If filter= "" Then
filter= "職務 Like \'%" & e.Form.Controls("cmb_post").text & "%\'"
Else
filter+= " and 職務 Like \'%" & e.Form.Controls("cmb_post").text & "%\'"
End If
End If
DataTables("tbl_rsfile").LoadFilter=filter
DataTables("tbl_rsfile").Load
Tables("tbl_rsfile").Sort="工號"