For n As Integer = 1 To Sheet.Rows.Count -1
Dim bh As String = sheet(n,0).Text
Dim bh1 As String = sheet(n,11).Text
Dim dr As DataRow = DataTables("齐套信息").SqlFind("工单号 = '" & bh & "' and 备料料号 = '" & bh1 & "'")
If dr Is Nothing Then '如果不存在同编号的订单
dr = DataTables("齐套信息").AddNew()
End If
For m As Integer = 0 To nms.Length - 1
dr(nms(m)) = Sheet(n,m).Value
Next
dr.save
Next