Dim cmd As new SQLCommand
cmd.C
cmd.CommandText = "UPD ATE {产品用板明细} SET 审核 = REPLACE(审核,null,'Y') WHERE 产品ID = '" & e.Form.Controls("Txt产品ID").text & "'"
cmd.ExecuteNonQuery()
cmd.CommandText = "UP DATE {产品用板明细} SET 日期 = REPLACE(日期,null,'" & Functions.Execute("返回服务器日期") & "') WHERE 产品ID = '" & e.Form.Controls("Txt产品ID").text & "'"
cmd.ExecuteNonQuery()
Dim dt As DataTable = Tables(e.Form.Name & "_Table1").DataTable
dt.ReplaceFor("审核","Y","产品代码 = '" & e.Form.Controls("Txt产品代码").text & "'")
dt.ReplaceFor("日期",Functions.Execute("返回服务器日期"),"产品代码 = '" & e.Form.Controls("Txt产品代码").text & "'")
老师，以上红色代码中的空值替换为审核状态和日期，没办法生成，数据库是SQL数据库
加好友 
发短信
Post By：2020/2/7 14:51:00 [显示全部帖子]
