// 注入数据库上下文
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);
}
}