以文本方式查看主题

-  Foxtable(狐表)  (http://www.foxtable.com/bbs/index.asp)
--  专家坐堂  (http://www.foxtable.com/bbs/list.asp?boardid=2)
----  [求助] 防止重复记录  (http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=140178)
--  作者：susanhe
--  发布时间：2019/8/30 23:16:00
--  [求助] 防止重复记录

 

 

你好，以下代码中可不可以帮忙加一个条件，如果表PrintHistory已经存在相同的PartNo，就不再新增该记录。谢谢。

 

 

Dim t1 As Table = Tables("生产任务单")
Dim nmb() As String = {"生产任务单号","产品名称","数量","PrintTime"}
Dim nma() As String = {"生产任务单号","PartNo","Qty","PrintTime"}

For r As Integer = t1.TopPosition To t1.BottomPosition
    Dim dr As Row = Tables("PrintHistory").AddNew
    For i As Integer = 0 To nma.Length - 1
        dr(nma(i)) = t1.rows(r)(nmb(i))
    Next
Next
--  作者：有点蓝
--  发布时间：2019/8/31 8:01:00
--  
Dim t1 As Table = Tables("生产任务单")
Dim nmb() As String = {"生产任务单号","产品名称","数量","PrintTime"}
Dim nma() As String = {"生产任务单号","PartNo","Qty","PrintTime"}
For r As Integer = t1.TopPosition To t1.BottomPosition
    Dim r1 As Row = t1.rows(r)
    Dim dr As DataRow = DataTables("PrintHistory").Find("PartNo=\'" & r1("PartNo") & "\'")
    If dr Is Nothing Then
        dr = DataTables("PrintHistory").AddNew
        For i As Integer = 0 To nma.Length - 1
            dr(nma(i)) = r1(nmb(i))
        Next
    End If
Next