以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- DateTimePicker (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=98405) |
-- 作者:huhu -- 发布时间:2017/3/29 10:54:00 -- DateTimePicker Dim startdata As WinForm.DateTimePicker = e.Form.Controls("DateTimePicker3") Dim Enddata As WinForm.DateTimePicker = e.Form.Controls("DateTimePicker4") Dim yck As WinForm.RadioButton = e.Form.Controls("RadioButton1") Dim filter As String If (startdata.Value = "" And Enddata.Value = "" ) Then filter = "出库状态 = 1" ElseIf (startdata.Value > "" And Enddata.Value > "") Then msgbox(1) filter = "导入日期 >= \'" & startdata.Value & "\' And 导入日期 <= \'" & Enddata.Value & "\' And 出库状态 = 1" End If DataTables("销售出库单列表").LoadFilter = filter DataTables("销售出库单列表").Load 提示:从字符串“”到类型“Date”的转换无效。
|
-- 作者:有点色 -- 发布时间:2017/3/29 11:55:00 -- If (startdata.Text = "" And Enddata.text = "" ) Then
filter = "出库状态 = 1"
ElseIf (startdata.text > "" And Enddata.text > "") Then
msgbox(1)
filter = "导入日期 >= \'" & startdata.Value & "\' And 导入日期 <= \'" & Enddata.Value & "\' And 出库状态 = 1"
End If
|