/// <summary>
/// 删除模糊排除关键字
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button_Click_1(object sender, RoutedEventArgs e)
{
var exclude = guolvList.SelectedItem as exclude;
if (exclude == null)
{
return;
}
var guanjianzi = exclude.excludeappname;
var result = MessageBox.Show("确定删除已排除的关键字[" + guanjianzi + "]?", "删除确认", MessageBoxButton.OKCancel, MessageBoxImage.Information);
if (result == MessageBoxResult.OK)
{
using (var db = SqlSugarHelper.GetInstance())
{
var count = db.Deleteable <exclude>(exclude).ExecuteCommand();
if (count > 0)
{
excludeList.Remove(exclude);
//MessageBox.Show("已从排除的名称库中删除:[" + guanjianzi + "]关键字.");
}
else
{
MessageBox.Show("删除关键字失败,请联系管理员.");
}
}
}
}
/// <summary>
/// 谁在用这个APP
/// </summary>
/// <param name="appName"></param>
private void LoadWhoUsed(string appName)
{
appsList.Clear();
using (var db = SqlSugarHelper.GetInstance())
{
var li = db.Queryable <apps>().Where(c => c.appname == appName).ToList();
foreach (var item in li)
{
appsList.Add(item);
}
whoUsed.ItemsSource = appsList;
}
}
/// <summary>
/// 加载统计
/// </summary>
private void LoadStatistics()
{
using (var db = SqlSugarHelper.GetInstance())
{
var li = db.Queryable <statistics_apps>().OrderBy("count desc").ToList();
foreach (var item in li)
{
statistics_appsList.Add(item);
}
lvStatistics.ItemsSource = statistics_appsList;
loadTime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff");
}
}
/// <summary>
/// 加载排除的名称列表
/// </summary>
private void LoadExclude()
{
using (var db = SqlSugarHelper.GetInstance())
{
var li = db.Queryable <exclude>().OrderBy("excludeappname asc").ToList();
foreach (var item in li)
{
excludeList.Add(item);
}
guolvList.ItemsSource = excludeList;
guolvList.DisplayMemberPath = "excludeappname";
}
}
/// <summary>
/// 刷新
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button_Click_2(object sender, RoutedEventArgs e)
{
using (var db = SqlSugarHelper.GetInstance())
{
var li = db.Queryable <statistics_apps>().OrderBy("count desc").ToList();
statistics_appsList.Clear();
foreach (var item in li)
{
statistics_appsList.Add(item);
}
loadTime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff");
}
}
/// <summary>
/// 添加模糊排除关键字
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button_Click(object sender, RoutedEventArgs e)
{
var guanjianzi = tbAppName.Text.Trim();
if (guanjianzi.Length == 0)
{
return;
}
bool findFlag = false;
foreach (var item in excludeList)
{
if (item.excludeappname == guanjianzi)
{
findFlag = true;
break;
}
}
if (!findFlag)
{
using (var db = SqlSugarHelper.GetInstance())
{
try
{
var id = db.Insertable <exclude>(new exclude()
{
excludeappname = guanjianzi
}).ExecuteReturnIdentity();
if (id > 0)
{
var exclude = db.Queryable <exclude>().Single(c => c.id == id);
if (exclude != null)
{
excludeList.Insert(0, exclude);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
private void MainWindow_Loaded(object sender, RoutedEventArgs e)
{
SqlSugarHelper.Init("server=192.168.90.11;port=3306;database=companyapps;uid=companyapps;pwd=companyapps;SslMode=None;");
LoadExclude();
LoadStatistics();
}
