比如有一个表A-Z非插卡收货扫描,副本表A-Z非插卡收货扫描_table3。
在我本机操作这么写应该肯定是没问题的,如果分成多个客户端操作,别人需要对这个副本表操作有问题吗?
If (Vars("AZfckshdh").Substring(5,1) = 1) Then
Tables("A-Z非插卡收货扫描_table3").filter = "收货漏扫 = false and 收货单号 = '" & Vars("AZfckshdh") & "'"
Dim sum1 As Integer = DataTables("扫描配货明细").SQLCompute("count(SN)","状态 = '生成收货单' and 收货单号 = '" & Vars("AZfckshdh") & "' and 收货漏扫 = 'false'")
Dim shls As WinForm.Label = e.Form.Controls("Label1")
shls.text = "漏扫的SN有" & sum1 & "个"
ElseIf(Vars("AZfckshdh").Substring(5,1) = 2) Then
Tables("A-Z非插卡收货扫描_table3").filter = "收货漏扫 = false and 收货单号 = '" & Vars("AZfckshdh") & "' and 外内 = '外'"
Dim sum1 As Integer = DataTables("扫描配货明细").SQLCompute("count(SN)","状态 = '生成收货单' and 收货单号 = '" & Vars("AZfckshdh") & "' and 外内 = '外' and 收货漏扫 = 'false'")
Dim shls As WinForm.Label = e.Form.Controls("Label1")
shls.text = "漏扫的SN有" & sum1 & "个"
End If