使用如下代码,有问题:
Dim drs AS List(of Datarow)
Dim dr0 AS Datarow=e.Datarow
Dim dr1,dr2,dr3 AS Datarow
Dim filter1,filter2 AS String
filter1="[Replacement For] like '*" & e.Datarow("电池型号") & "*'"
filter2="[Replacement For] like '*" & e.Datarow("电池型号") & "*' and [Capacity]='" & e.Datarow("容量") & "'"
If e.Datacol.Name= "电池型号" Then
If e.NewValue Is Nothing Then
dr0("BPBPN1")=Nothing
dr0("BPBPN2")=Nothing
dr0("capacity2")=Nothing
dr0("BPBPN3")=Nothing
dr0("capacity3")=Nothing
Else
drs=Datatables("BPB量产电池").Select(filter1)
If drs IsNot Nothing Then
dr1=drs(0)
dr2=drs(1)
dr3=drs(2)
dr0("BPBPN1")=dr1("产品名称")
dr0("BPBPN2")=dr2("产品名称")
dr0("BPBPN3")=dr3("产品名称")
dr0("capacity2")=dr2("capacity")
dr0("capacity3")=dr3("capacity")
Else
dr0("BPBPN1")="NULL"
End If
End If
End If
使用如下代码,正常:
If e.Datacol.Name="电池型号" Then
Dim drs AS list(of Datarow)
Dim filter As String
filter="[Replacement For] Like '*" & e.Datarow("电池型号") & "*' "
drs=Datatables("BPB量产电池").SELECT(filter)
If drs IsNot Nothing Then '如果不为空
Dim dr AS DATAROW=drs(0)
e.Datarow("BPBPN1")=dr("产品名称")
Else
e.Datarow("BPBPN1")="NULL"
END IF
END If