Foxtable(狐表)用户栏目专家坐堂 → 拼接语句


  共有2037人关注过本帖树形打印复制链接

主题:拼接语句

帅哥哟,离线,有人找我吗?
有点蓝
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:超级版主 帖子:110574 积分:562760 威望:0 精华:9 注册:2015/6/24 9:21:00
  发帖心情 Post By:2016/9/18 16:20:00 [显示全部帖子]

Select Case user.Group
    Case  "录入","审核","协议一组","协议二组","交换组","R驱动组","S驱动组","EPON组","ONU组","网管组","网络组","路由组","PTN应用组","链路组","测试epon","测试switch","测试router"
        Dim filter = DataTables("临时版本跟踪表").LoadFilter
        If filter > "" Then filter &= " and "
        If kh.text = "" Then
            DataTables("临时版本跟踪表").LoadFilter = filter & "需求提交时间 > '" & startdate.Value & "' And 需求提交时间 < '"  & enddate.value.AddDays(1) & "'"
        Else
            DataTables("临时版本跟踪表").LoadFilter = filter & "需求提交时间 > '" & startdate.Value & "' And 需求提交时间 < '"  & enddate.value.AddDays(1) & "' and  客户 = '" & kh.text & "'"
        End If
End Select

 回到顶部