private async void Button_Click_2(object sender, RoutedEventArgs e)
{
cts = new CancellationTokenSource();
cts.Token.Register(() => { HandyControl.Controls.Growl.Info("取消当前任务！", "DBManageGrowl"); });
ct = cts.Token;
//数据库管理
var cb = CheckBoxWrapPanel.Children.OfType <CheckBox>().ToList();
string path = "";
if (vieModel_DBManagement.CurrentDataBase.ToLower() == "info")
{
path = $"{vieModel_DBManagement.CurrentDataBase}";
}
else
{
path = $"DataBase\\{vieModel_DBManagement.CurrentDataBase}";
}
MySqlite db = new MySqlite(path);
if ((bool)cb[1].IsChecked || (bool)cb[2].IsChecked)
{
WaitingPanel.Visibility = Visibility.Visible;
}
if ((bool)cb[0].IsChecked)
{
//重置信息
db.DeleteTable("movie");
db.CreateTable(DataBase.SQLITETABLE_MOVIE);
HandyControl.Controls.Growl.Success("成功重置信息", "DBManageGrowl");
}
if ((bool)cb[1].IsChecked)
{
//删除不存在影片
long num = 0;
await Task.Run(() =>
{
var movies = db.SelectMoviesBySql("select * from movie");
try
{
movies.ForEach(movie =>
{
ct.ThrowIfCancellationRequested();
if (!File.Exists(movie.filepath))
{
db.DeleteByField("movie", "id", movie.id);
num++;
}
});
}
catch (OperationCanceledException ex)
{
Console.WriteLine($"{nameof(OperationCanceledException)} thrown with message: {ex.Message}");
return(false);
}
return(true);
}, ct);
HandyControl.Controls.Growl.Success($"成功删除 {num} 个不存在的影片", "DBManageGrowl");
}
if ((bool)cb[2].IsChecked)
{
var movies = db.SelectMoviesBySql("select * from movie");
StringCollection ScanPath = ReadScanPathFromConfig(vieModel_DBManagement.CurrentDataBase);
long num = 0;
await Task.Run(() =>
{
try
{
movies.ForEach(movie =>
{
ct.ThrowIfCancellationRequested();
if (!IsPathIn(movie.filepath, ScanPath))
{
db.DeleteByField("movie", "id", movie.id);
num++;
}
});
}
catch (OperationCanceledException ex)
{
Console.WriteLine($"{nameof(OperationCanceledException)} thrown with message: {ex.Message}");
return(false);
}
return(true);
}, ct);
HandyControl.Controls.Growl.Success($"成功删除 {num} 个不位于指定目录的影片", "DBManageGrowl");
}
db.Vacuum();
db.CloseDB();
cts.Dispose();
WaitingPanel.Visibility = Visibility.Hidden;
await Task.Run(() => { Task.Delay(500).Wait(); });
Main main = null;
Window window = Jvedio.GetWindow.Get("Main");
if (window != null)
{
main = (Main)window;
}
main?.vieModel.Reset();
}
private async void Button_Click_2(object sender, RoutedEventArgs e)
{
Button button = (Button)sender;
button.IsEnabled = false;
cts = new CancellationTokenSource();
cts.Token.Register(() => { HandyControl.Controls.Growl.Info(Jvedio.Language.Resources.Cancel, GrowlToken); });
ct = cts.Token;
//数据库管理
var cb = CheckBoxWrapPanel.Children.OfType <CheckBox>().ToList();
string path = $"DataBase\\{vieModel_DBManagement.CurrentDataBase}";
MySqlite db = new MySqlite(path);
if ((bool)cb[0].IsChecked)
{
//重置信息
db.DeleteTable("movie");
db.CreateTable(DataBase.SQLITETABLE_MOVIE);
//清空最近播放和最近创建
ClearDateBefore(DateTime.Now);
db.Vacuum();
HandyControl.Controls.Growl.Success(Jvedio.Language.Resources.Message_Success, GrowlToken);
}
if ((bool)cb[1].IsChecked)
{
//删除不存在影片
long num = 0;
await Task.Run(() =>
{
var movies = db.SelectMoviesBySql("select * from movie");
try
{
vieModel_DBManagement.ProgressBarValue = 0;
for (int i = 0; i < movies.Count; i++)
{
ct.ThrowIfCancellationRequested();
if (!File.Exists(movies[i].filepath))
{
db.DeleteByField("movie", "id", movies[i].id);
num++;
}
if (movies.Count > 0)
{
vieModel_DBManagement.ProgressBarValue = (int)((double)(i + 1) / (double)movies.Count * 100);
}
}
db.Vacuum();
}
catch (OperationCanceledException ex)
{
Console.WriteLine($"{nameof(OperationCanceledException)} thrown with message: {ex.Message}");
}
}, ct);
HandyControl.Controls.Growl.Success($"{ Jvedio.Language.Resources.SuccessDelete} {num}", GrowlToken);
}
if ((bool)cb[2].IsChecked)
{
var movies = db.SelectMoviesBySql("select * from movie");
StringCollection ScanPath = ReadScanPathFromConfig(vieModel_DBManagement.CurrentDataBase);
long num = 0;
await Task.Run(() =>
{
try
{
vieModel_DBManagement.ProgressBarValue = 0;
for (int i = 0; i < movies.Count; i++)
{
ct.ThrowIfCancellationRequested();
if (!IsPathIn(movies[i].filepath, ScanPath))
{
db.DeleteByField("movie", "id", movies[i].id);
num++;
}
if (movies.Count > 0)
{
vieModel_DBManagement.ProgressBarValue = (int)((double)(i + 1) / (double)movies.Count * 100);
}
}
db.Vacuum();
}
catch (OperationCanceledException ex)
{
Console.WriteLine($"{nameof(OperationCanceledException)} thrown with message: {ex.Message}");
}
}, ct);
HandyControl.Controls.Growl.Success($"{Jvedio.Language.Resources.SuccessDelete} {num}", GrowlToken);
}
if ((bool)cb[3].IsChecked)
{
if (Properties.Settings.Default.SaveInfoToNFO)
{
var detailMovies = db.SelectDetailMoviesBySql("select * from movie");
await Task.Run(() =>
{
try
{
vieModel_DBManagement.ProgressBarValue = 0;
for (int i = 0; i < detailMovies.Count; i++)
{
ct.ThrowIfCancellationRequested();
FileProcess.SaveNfo(detailMovies[i]);
if (detailMovies.Count > 0)
{
vieModel_DBManagement.ProgressBarValue = (int)((double)(i + 1) / (double)detailMovies.Count * 100);
}
}
}
catch (OperationCanceledException ex)
{
Console.WriteLine($"{nameof(OperationCanceledException)} thrown with message: {ex.Message}");
}
}, ct);
HandyControl.Controls.Growl.Success($"{Jvedio.Language.Resources.Message_Success}", GrowlToken);
}
else
{
HandyControl.Controls.Growl.Success($"{Jvedio.Language.Resources.setnfo}", GrowlToken);
}
}
db.CloseDB();
cts.Dispose();
await Task.Run(() => { Task.Delay(500).Wait(); });
Main main = (Main)GetWindowByName("Main");
main?.vieModel.Reset();
button.IsEnabled = true;
}