If e.DataCol.Name = "编码" Then Dim dr As DataRow Dim Filter As String Filter = "[供应商] = '" & e.DataRow("供应商") & "' And [编码] = '" & e.DataRow("编码") & "'" dr = DataTables("供应商单价表").Find(Filter) If dr IsNot Nothing Then e.DataRow("核对单价") = dr("单价") Else e.DataRow("核对单价") = Nothing End If Dim d1 As DataRow Dim F1 As String F1 = "[编码] = '" & e.DataRow("编码") & "'" d1 = DataTables("货品资料").Find(F1) If d1 IsNot Nothing Then e.DataRow("类别") = d1("货品类别") Else e.DataRow("类别") = Nothing End If End If
|