以下是引用有点甜在2014-11-13 16:49:00的发言:
你设置了筛选?加入筛选代码。
这是我“缺省”按钮的代码。关键是点击“缺省”,状态为空的行是可以加载,但一旦这行是由submitted,然后点击确定,那么这行就加载不了。
If User.Name.Trim() = "liujiyong@bdcom.com.cn" Then
DataTables("临时版本跟踪表").loadFilter = "状态 = 'Confirming' or 状态 = 'Bound' or 状态 = 'Submitted' or 状态 = 'Nopass' or 状态 is null"
DataTables("临时版本跟踪表").Load()
Else
Select Case user.Group
Case "协议一组","协议二组","交换组","R驱动组","S驱动组","EPON组","ONU组","网管组","网络组","路由组","PTN应用组","链路组"
If user.Roles = "研发组长" Then
Dim str As String = "1=2"
For Each u As UserInfo In users
If u.Group = user.Group Then
str &= " or 研发邮箱 like '%" & User.Name.trim() & "%' And (状态 = 'Confirming' or 状态 = 'Bound' or 状态 = 'Submitted' or 状态 = 'Nopass' or 状态 is null)"
End If
Next
DataTables("临时版本跟踪表").LoadFilter = str
DataTables("临时版本跟踪表").Load()
Else
DataTables("临时版本跟踪表").LoadFilter = "研发邮箱 like '%" & User.Name.trim() & "%' And (状态 = 'Confirming' or 状态 = 'Bound' or 状态 = 'Submitted' or 状态 = 'Nopass' or 状态 is null)"
End If
DataTables("临时版本跟踪表").Load()
Case "测试epon"
DataTables("临时版本跟踪表").LoadFilter = "邮件通知 like '%eponver@bdcom.com.cn%' And (状态 = 'Confirming' or 状态 = 'Bound' or 状态 = 'Submitted' or 状态 = 'Nopass' or 状态 is null)"
DataTables("临时版本跟踪表").Load()
Case "测试switch"
DataTables("临时版本跟踪表").LoadFilter = "邮件通知 like '%switchver@bdcom.com.cn%' And (状态 = 'Confirming' or 状态 = 'Bound' or 状态 = 'Submitted' or 状态 = 'Nopass' or 状态 is null)"
DataTables("临时版本跟踪表").Load()
Case "测试router"
DataTables("临时版本跟踪表").LoadFilter = "邮件通知 like '%routerver@bdcom.com.cn%' And (状态 = 'Confirming' or 状态 = 'Bound' or 状态 = 'Submitted' or 状态 = 'Nopass' or 状态 is null)"
DataTables("临时版本跟踪表").Load()
Case "配置管理"
DataTables("临时版本跟踪表").LoadFilter = ""
DataTables("临时版本跟踪表").Load()
End Select
End If
DataTables("临时版本跟踪表").Load()