Select Case e.DataCol.name Case "批号" Dim dr As DataRow = DataTables("入库标签").Find("批号 = '" & e.OldValue & "'") If dr Is Nothing Then If e.DataRow("检验结果")="合格" AndAlso e.DataRow("检验结果")="让步接受" Then dr = DataTables("入库标签").AddNew() dr("批号") = e.DataRow("批号") dr("检验结果") = e.DataRow("检验结果") dr("检验日期") = e.DataRow("检验日期") End If Else dr("批号") = e.DataRow("批号") End If Case "检验日期","检验结果" Dim dr As DataRow = DataTables("入库标签").Find("批号 = '" & e.DataRow("批号") & "'") If dr Is Nothing AndAlso e.DataRow("检验结果")="合格" AndAlso e.DataRow("检验结果")="让步接受" Then dr = DataTables("入库标签").AddNew() dr("批号") = e.DataRow("批号") dr("检验结果") = e.DataRow("检验结果") dr("检验日期") = e.DataRow("检验日期") End If If dr IsNot Nothing Then dr(e.DataCol.Name) = e.DataRow(e.DataCol.Name) End If End Select
|