Dim st As Date = Date.Now
'要测试耗时的代码
Dim cmd As new SQLCommand
cmd.C
Dim dt1 As DataTable '资料表
Dim dt2 As DataTable '盘点表
Dim dr1 As DataRow
Dim dr2 As DataRow
cmd.CommandText = "selec t * from 条码货号 "
dt1 = cmd.ExecuteReader()
cmd.CommandText = "selec t * from 盘点明细表 where 盘点日期 = '" & Date.Today & "' "
dt2 = cmd.ExecuteReader()
For Each dr2 In dt2.DataRows
dr1 = dt1.sqlfind("ean = '" & dr2("条码") & "'")
If dr1 IsNot Nothing Then
cmd.CommandText = " updat e 盘点明细表 set 货号 = '" & dr1("sku") & "' where 条码 = '" & dr1("ean") & "' and 货号 is null "
cmd.ExecuteNonQuery()
End If
Next
output.Show("耗时: " & (Date.Now - st).TotalSeconds & "秒")