public async void Confirm()
{
try
{
await Task.Run(() =>
{
Indicate = "Visible";
Workrecs = new List <Workrec>();
Holerecs = new List <Holerec>();
using (var db = new DrillContext())
{
Workrecs = db.Workrec.Where(w => w.LastTime >= StartTime && w.LastTime <= EndTime).AsNoTracking().ToList();
Holerecs = db.Holerec.Where(h => h.TestTime >= StartTime && h.TestTime <= EndTime).AsNoTracking().ToList();
}
using (var alidb = new AliDbContext())
{
var aliworkrecs = new List <Workrec>();
var aliholerecs = new List <Holerec>();
aliworkrecs = alidb.Workrecs.AsNoTracking().ToList(); //一次性缓存
aliholerecs = alidb.Holerecs.AsNoTracking().ToList(); //
foreach (var item in Workrecs)
{
//if (alidb.Workrecs.Any(w => w.Id == item.Id)==false)
if (aliworkrecs.Any(w => w.Id == item.Id) == false)
{
alidb.Workrecs.Add(item);
}
else
{
alidb.Workrecs.Update(item);
}
}
foreach (var item in Holerecs)
{
//if(alidb.Holerecs.Any(h => h.Id == item.Id) == false)
if (aliholerecs.Any(h => h.Id == item.Id) == false)
{
alidb.Holerecs.Add(item);
}
else
{
alidb.Holerecs.Update(item);
}
}
alidb.SaveChanges();
}
});
Indicate = "Hidden";
_windowManager.ShowMessageBox("上传完成", "信息", MessageBoxButton.OK);
}
catch (Exception)
{
Indicate = "Hidden";
_windowManager.ShowMessageBox("网络数据库连接失败！", "警告");
}
}
public async void DeleteHoleRec()
{
if (Holerec != null && _windowManager.ShowMessageBox("确认要删除工件" + Workrec.SerialNo + "洞号" + Holerec.HoleNumber +
"的记录?", "警告", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
{
await Task.Run(() =>
{
var db = new AliDbContext();
db.Holerecs.Remove(Holerec);
db.SaveChanges();
});
QueryHole();
}
}
public async void DeleteWorkRec()
{
if (Workrec != null && _windowManager.ShowMessageBox("确认要删除工件号为" + Workrec.SerialNo +
"的记录?", "警告", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
{
await Task.Run(() =>
{
var db = new AliDbContext();
var temph = db.Holerecs.Where(h => h.SerialNo == Workrec.SerialNo).ToList();
db.Workrecs.Remove(Workrec);
db.Holerecs.RemoveRange(temph);
db.SaveChanges();
});
Query();
}
}