// 注入数据库上下文 public void Clear(RecordDbContext context) { _logger.LogDebug("Invoke the AutoClearJob"); // 查询未签退列表 var unsignOutList = (from r in context.Records where r.SignOutTime == null select r).ToList(); // 对未签退的人进行处理 foreach (var record in unsignOutList) { if (record.IsTimeOut()) { record.SignOutWithTimeOut(); } else { record.SignOut(); } } // 写入数据库 try { context.UpdateRange(unsignOutList); context.SaveChanges(); } catch (Exception e) { _logger.LogError(e.Message); } }
public Guid Save(Record record) { using (var db = new RecordDbContext()) { var requestNumber = new Guid(); record.RequestNumber = requestNumber; db.Records.Add(record); db.SaveChanges(); return(requestNumber); } }
public static void RecordTime(string process) { using (var dbContext = new RecordDbContext()) { dbContext.TimeRecords.Add( new timeRecord() { Time = DateTime.Now.ToString(), Process = process } ); dbContext.SaveChanges(); } }
public Guid Save(IEnumerable <Record> recordList) { using (var db = new RecordDbContext()) { var requestNumber = Guid.NewGuid(); foreach (var record in recordList) { record.RequestNumber = requestNumber; } db.Records.AddRange(recordList); db.SaveChanges(); return(requestNumber); } }