If Tables(e.Form.Name & "_table3").Rows.Count > 0 Then
Dim tj As String
For Each r As Row In Tables(e.Form.Name & "_table3").Rows
tj = "'" & r("缸号") & "'," & tj
Next
tj = tj.TrimEnd(",")
DataTables("染色生产表").LoadFilter = "缸号 in (" & tj & ")"
DataTables("染色生产表").Load
'--------------------------------------------------------------------------------------------------------------
Dim Cols1() As String = {"订单明细编号对外","客户","品名大类","品名小类","坯布规格","缸号类型","投坯重量","投坯匹数","颜色","单双染","色号","卡注"}
Dim Cols2() As String = {"订单明细编号对外","客户","品名大类","品名小类","坯布规格","缸号类型","重量","匹数","颜色","单双染","色号","卡注"}
For Each r1 As Row In Tables(e.Form.Name & "_table3").Rows
Dim dr1s As List(of DataRow) = DataTables("染色生产表").Select("缸号 = '" & r1("缸号") & "'")
If dr1s.Count > 0 Then
For Each dr1 As DataRow In dr1s
For i As Integer = 0 To Cols1.Length -1
dr1(Cols2(i)) = r1(Cols1(i))
Next
dr1.Save
Next
End If
Next
DataTables("染色生产表").LoadFilter = "缸号 in (" & tj & ")"
DataTables("染色生产表").Load
End If
加好友 
发短信
Post By：2017/1/4 13:41:00 [显示全部帖子]
