current时间件里用下面2种方式,获得的结果不一样,谁帮我解决一下是哪个正确还是都不对
方式一、
If DataTables("crm_customer").DataRows.Count = 0 Then '如果baidu_client表没有数据
DataTables("crm_customer_track").LoadFilter = "track_id Is Null" '不加载baidu_records
Else
Dim ids As String
For Each dr As DataRow In DataTables("crm_customer").DataRows
ids = ids & "," & dr("customer_id")
Next
ids= ids.Trim(",")
DataTables("crm_customer_track").LoadFilter = "customer_id In (" & ids & ")"
End If
DataTables("crm_customer_track").Load()
Dim t_genjin As Table = Tables("窗口客户_tbl_Genjin")
With Tables("窗口客户_tblKehu")
If .Current Is Nothing Then
t_genjin.filter="false"
Else
t_genjin.Filter = "customer_id = " & .Current("customer_id")
End If
End With
二、sql TABLE方式
Dim aa2 As String="Select* from crm_customer_track where customer_id= " & Tables("窗口客户_tblKehu").Current("customer_id")
Tables("窗口客户_tblCeshi").Fill(aa2,"c2",True)