8,494
社区成员




if (db.D_BIAO.Any(p=>p.MESSAGE_ID == MESSAGE_ID)
{
D_BIAO dbiao = db.D_BIAO.Where(p=>p.MESSAGE_ID == MESSAGE_ID).First();
dbiao.AUDIT_FLAG=变量1值;
dbiao. AUDIT_NAME=变量2值;
dbiao.AUDIT_DATE=DateTime.Now();
dbiao.AUDIT_NOTE=变量3值;
db.SubmitChanges();
}
else
{
Console.WriteLine("没有需要更新的记录");
}
var query = ( from f in db.D_BIAO
where (f.MESSAGE_ID == MESSAGE_ID)
select f).FirstOrDefault();
if(query!=null)
{
query.AUDIT_FLAG = auditFlag;
//and so on
}
db.SubmitChanges();