现在把EXCEL数据导入到临时表,想把临时表数据根据单号不同导入到关联表销售订单明细表里,销售订单主表增加行时自动增加日期及订单单号,不知哪出了问题
DataTables("销售订单导入").Save()
Dim Cols1() As String = {"货物编码","货物名称","规格","单位","数量","单价","金额"}
Dim Cols2() As String = {"货物编码","货物名称","规格","单位","数量","单价","金额"}
Dim s As Table = Tables("销售订单导入")
For i As Integer = 0 To s.Rows.count-1
If s.Rows(i)("单据编码") <> s.Rows(i-1)("单据编码") Then
DataTables("销售订单明细").Save()
DataTables("销售订单").Save()
DataTables("销售订单").AddNew()
If s.Rows(i)("选择")=True Then
Dim dr2 As DataRow = DataTables("销售订单明细").AddNew()
dr2("单据编码")=Forms("销售订单").Controls("TextBox2").text
dr2("日期")=Forms("销售订单").Controls("DateTimePicker1").text
dr2("单据类别")=Forms("销售订单").Controls("DropBox2").text
dr2("往来名称")=Forms("销售订单").Controls("TextBox4").text
dr2("往来编码")=Forms("销售订单").Controls("DropBox3").text
For b As Integer = 0 To Cols1.Length -1
dr2(Cols2(b)) = s.Rows(i)(Cols1(b))
Next
End If
End If
Next
DataTables("销售订单导入").Save()
DataTables("销售订单导入").deletefor("[货物编码] Is not null")