老师，以下代码是因为分别写的没有合并而导致执行时间稍微长点吗？谢谢
Dim cmd As New SQLCommand
cmd.C
cmd.CommandText = "UPDATE a s et a.制造费用_水费 = b.费用基数 * a.循环时间 from 工序跟踪表 as a ,生产成本总表 as b where a.月份 = b.月份 and b.费用明细 = '水费' and b.项目 = '制造费用'"
cmd.ExecuteNonQuery()
Dim cmd1 As New SQLCommand
cmd1.C
cmd1.CommandText = "UPDATE a1 s et a1.制造费用_电费 = b1.费用基数 * a1.循环时间 from 工序跟踪表 as a1 ,生产成本总表 as b1 where a1.月份 = b1.月份 and b1.费用明细 = '电费' and b1.项目 = '制造费用'"
cmd1.ExecuteNonQuery()
Dim cmd2 As New SQLCommand
cmd2.C
cmd2.CommandText = "UPDATE a2 s et a2.制造费用_外协费用 = b2.费用基数 * a2.循环时间 from 工序跟踪表 as a2 ,生产成本总表 as b2 where a2.月份 = b2.月份 and b2.费用明细 = '外协费用' and b2.项目 = '制造费用'"
cmd2.ExecuteNonQuery()
Dim cmd3 As New SQLCommand
cmd3.C
cmd3.CommandText = "UPDATE a3 s et a3.制造费用_运输费 = b3.费用基数 * a3.循环时间 from 工序跟踪表 as a3 ,生产成本总表 as b3 where a3.月份 = b3.月份 and b3.费用明细 = '运输费' and b3.项目 = '制造费用'"
cmd3.ExecuteNonQuery()
加好友 
发短信
Post By：2022/11/28 23:24:00 [显示全部帖子]
