老师，表属性代码错误，请帮忙看一下，谢谢。
Dim cmd As new SQLCommand
cmd.C
Dim dt As DataTable
dt = cmd.ExecuteReader(True)
If e.DataCol.Name = "AssemblingStartingDate" Or e.DataCol.Name = "AssemblingFinishingDate" Or e.DataCol.Name = "QtyCompleted" Or e.DataCol.Name = "Assembler" Or e.DataCol.Name = "AssStatus" Or e.DataCol.Name = "AssStartingScantimes" Or e.DataCol.Name = "WKNumber" Or e.DataCol.Name = "TimeKeeping" Or e.DataCol.Name = "MaterialPreparation" Then
cmd.CommandText = "u pdate ICMO set FHeadSelfJ0193 = a.MaterialPreparation,FHeadSelfJ0194 = a.AssemblingStartingDate,FHeadSelfJ0198 = a.AssemblingFinishingDate,FHeadSelfJ0195 = a.WKNumber,FHeadSelfJ01101 =a.AssStatus,FHeadSelfJ0199 =a.QtyCompleted,FHeadSelfJ0197 =a.TimeKeeping,FHeadSelfJ0196=a.AssStartingScantimes from 生产任务单 As a where a.生产任务单号 = ICMO.FBillNo"
cmd.ExecuteNonQuery
dt.Save()
End If
此主题相关图片如下：捕获.png
[此贴子已经被作者于2021/1/30 21:10:47编辑过]
加好友 
发短信
Post By：2021/1/30 21:10:00 [只看该作者]
