/// <summary>
/// 确保数据库已被创建
/// </summary>
public void EnsureDbCreated()
{
using (var context = new TimeDataContext(options))
{
context.Database.EnsureCreated();
}
}
/// <summary>
/// 从数据库中读出所有实体
/// </summary>
public void LoadDataFromDb()
{
using (var context = new TimeDataContext(options))
{
UserActivityPieces = context.UserActivityPieces.ToList();
KilledActivities = context.KilledActivities.ToList();
}
}
/// <summary>
/// 将新增加的实体写入数据库
/// </summary>
public void SaveDataToDb()
{
using (var context = new TimeDataContext(options))
{
int savedUAPCount = context.UserActivityPieces.Count();
int savedKACount = context.KilledActivities.Count();
int newUAPCount = UserActivityPieces.Count - savedUAPCount - 1; // 数组中最后一个UAP总是未完成的，未完成的UAP不记录入数据库中
int newKACount = KilledActivities.Count - savedKACount;
if (newUAPCount > 0)
{
context.UserActivityPieces.AddRange(UserActivityPieces.GetRange(savedUAPCount, newUAPCount));
}
if (newKACount > 0)
{
context.KilledActivities.AddRange(KilledActivities.GetRange(savedKACount, newKACount));
}
context.SaveChanges();
}
}
