private void GetFileToDatabaseEvent(DriveInfo drive, List <UsnEntry> data)
{
List <UsnFiles> temp = new List <UsnFiles>();
if (ListTool.HasElements(data))
{
for (int i = 0; i < data.Count; i++)
{
temp.Add(new UsnFiles()
{
Name = data[i].FileName,
IsFolder = data[i].IsFolder,
Number = NumberStringTool.ToString(data[i].FileReferenceNumber),
ParentNumber = NumberStringTool.ToString(data[i].ParentFileReferenceNumber),
Drive = drive.Name,
Usn = data[i].Usn,
CreateTime = DateTimeConvert.DetailString(DateTime.Now)
});
NewFileCount++;
}
}
using (var db = new Muse())
{
db.Adds(temp);
}
UISetFileCount(drive.Name, NewFileCount);
}
private void GetFileToDatabase()
{
var drives = FileQueryEngine.GetReadyNtfsDrives().OrderBy(x => x.Name);
if (ListTool.HasElements(drives))
{
foreach (var drive in drives)
{
NewFileCount = 0;
//if (!drive.Name.Contains("J")) continue;//测试只读取D盘
//if (drive.Name.Contains("D")) continue;//测试时跳过D盘
//if (drive.Name.Contains("F")) continue;//测试时跳过F盘
using (var db = new Muse())
{
//检测磁盘是否格式化，如果格式化则清空USN记录
DateTime dt1 = DriveTool.GetLastFormatTime(drive.Name);
var ds = db.Get <UsnDrives>(x => x.Name == drive.Name, null);
if ((ds == null) || (ds != null && ds.LastFormatTime != dt1.ToString()))
{
var deleteSql = db.Context.Database.ExecuteSqlCommand("DELETE FROM usnfiles WHERE drive = @p0;", drive.Name);
if (ds == null)
{
db.Add(new UsnDrives()
{
Name = drive.Name, LastFormatTime = dt1.ToString()
});
}
else
{
ds.LastFormatTime = dt1.ToString();
db.Update(ds, true);
}
}
//查询上次读取到的位置（最后一条记录）
ulong filenumber = 0;
long usn = 0;
if (db.Any <UsnFiles>(x => x.Drive == drive.Name, null))
{
int lastId = db.Do <UsnFiles>().Where(x => x.Drive == drive.Name).Max(x => x.Id);
UsnFiles lastRec = db.Get <UsnFiles>(x => x.Id == lastId, null);
usn = lastRec.Usn;
filenumber = NumberStringTool.ToUlong(lastRec.Number);
//usn = db.Do<UsnFiles>().Where(x => x.Drive == drive.Name).Max(x => x.Usn);
//string filenumberstr = db.Do<UsnFiles>().Where(x => x.Drive == drive.Name).Max(x => x.Number);
//filenumber = NumberStringTool.ToUlong(filenumberstr);
}
//从上次FileNumber记录开始读取
var usnOperator = new UsnOperator(drive);
usnOperator.GetEntries(usn, filenumber, GetFileToDatabaseEvent, 1000);
}
}
}
}
