public async void QueryWorkBySerialNo()
{
try
{
await Task.Run(() =>
{
if (QuerySearialNO != null)
{
using var db = new DrillContext();
Workrecs = db.Workrec.Where(w => w.SerialNo.Contains(QuerySearialNO))
.OrderByDescending(w => w.LastTime).ToList();
RecordsCount = Workrecs.Count;
}
});
ConnectStatus = "Success!";
}
catch (Exception e)
{
ConnectStatus = "failure!";
_windowManager.ShowMessageBox("Connect Net DataBase Failure！", "Warning", MessageBoxButton.OK,
MessageBoxImage.Warning);
}
if (Workrecs != null)
{
Workrec = Workrecs.FirstOrDefault();
}
}
public async void QueryWorkByDate()
{
try
{
await Task.Run(() =>
{
using var db = new DrillContext();
Workrecs = db.Workrec.Where(w => w.LastTime >= StartTime && w.LastTime <= EndTime)
.OrderByDescending(w => w.LastTime).ToList();
RecordsCount = Workrecs.Count;
//if (Workrec != null) QueryHole(); //Workrecs变化后会触发dategrid的selectchange 事件 会触发 queryhole 过程
});
ConnectStatus = "Success!";
}
catch (Exception)
{
ConnectStatus = "failure!";
_windowManager.ShowMessageBox("Connect Net DataBase Failure！", "Warning", MessageBoxButton.OK,
MessageBoxImage.Warning);
}
//Workrec与dategrid 的selectitem绑定 如果将下面的Workrec查询放在异步方法中，
//dategrid 的workrecs查询后会导致dategrid 的selectitem变化-》Workrec的变化，导致下面的Workrec查询没起到作用
if (Workrecs != null)
{
Workrec = Workrecs.FirstOrDefault();
}
}
public async void QueryWorkBySerialNO()
{
await Task.Run(() =>
{
if (QuerySearialNO != null)
{
using var db = new AliDbContext();
Workrecs = db.Workrecs.Where(w => w.SerialNo.Contains(QuerySearialNO)).OrderByDescending(w => w.LastTime).ToList();
}
});
if (Workrecs != null)
{
Workrec = Workrecs.FirstOrDefault();
}
}
public async void QueryWorkByDate()
{
await Task.Run(() =>
{
using var db = new DrillContext();
Workrecs = db.Workrec.Where(w => w.LastTime >= StartTime && w.LastTime <= EndTime).OrderByDescending(w => w.LastTime).ToList();
//if (Workrec != null) QueryHole(); //Workrecs变化后会触发dategrid的selectchange 事件 会触发 queryhole 过程
});
//Workrec与dategrid 的selectitem绑定 如果将下面的Workrec查询放在异步方法中，
//dategrid 的workrecs查询后会导致dategrid 的selectitem变化-》Workrec的变化，导致下面的Workrec查询没起到作用
if (Workrecs != null)
{
Workrec = Workrecs.FirstOrDefault();
}
}
public async void QueryWorkBySerialNO()
{
await Task.Run(() =>
{
using var db = new DrillContext();
if (QuerySearialNO != null)
{
Workrecs = db.Workrec.Where(w => w.SerialNo.Contains(QuerySearialNO)).OrderByDescending(w => w.LastTime).ToList();
}
if (Workrecs != null)
{
Workrec = Workrecs.FirstOrDefault();
}
Holerecs.Clear();
foreach (var item in Workrecs)
{
Holerecs.AddRange(db.Holerec.Where(h => h.SerialNo == item.SerialNo).ToList());
}
// QueryHole();
});
}
public async void QueryWorkByDate()
{
try
{
await Task.Run(() =>
{
using var db = new AliDbContext();
Workrecs = db.Workrecs.Where(w => w.LastTime >= StartTime && w.LastTime <= EndTime).OrderByDescending(w => w.LastTime).ToList();
//if (Workrec != null) QueryHole(); //Workrecs变化后会触发dategrid的selectchange 事件 会触发 queryhole 过程
});
}
catch (Exception)
{
_windowManager.ShowMessageBox("网络数据库连接失败！", "警告");
}
//Workrec与dategrid 的selectitem绑定 如果将下面的Workrec查询放在异步方法中，
//dategrid 的workrecs查询后会导致dategrid 的selectitem变化-》Workrec的变化，导致下面的Workrec查询没起到作用
if (Workrecs != null)
{
Workrec = Workrecs.FirstOrDefault();
}
}
public async void QueryWorkByDate()
{
await Task.Run(() =>
{
using (var db = new DrillContext())
{
Workrecs = db.Workrec.Where(w => w.LastTime >= StartTime && w.LastTime <= EndTime).OrderByDescending(w => w.LastTime).ToList();
if (Workrecs != null)
{
Workrec = Workrecs.FirstOrDefault();
}
Holerecs = new List <Holerec>();
Holerecs.Clear();
foreach (var item in Workrecs)
{
var temp = db.Holerec.Where(h => h.SerialNo == item.SerialNo).ToList();
Holerecs.AddRange(temp);
}
};
int i = Holerecs.Count;
// QueryHole();
});
}
