using HMI.Base;
|
using HMI.Core.Util;
|
using HMI.Util;
|
using Microsoft.Web.WebView2.Core;
|
using System;
|
using System.Collections.Generic;
|
using System.Collections.ObjectModel;
|
using System.Data;
|
using System.Drawing;
|
using System.IO;
|
using System.Linq;
|
using System.Windows;
|
using System.Windows.Controls;
|
|
namespace Plugin.DataBoard
|
{
|
/// <summary>
|
/// UserControl1.xaml 的交互逻辑
|
/// </summary>
|
public partial class DataBoard : PluginControl
|
{
|
public DataBoard()
|
{
|
DataContext = this;
|
InitializeComponent();
|
webview2.DefaultBackgroundColor = Color.Transparent;//Color.FromArgb(243, 249, 255);
|
}
|
|
private ObservableCollection<OptionData> _options = new ObservableCollection<OptionData> {
|
new OptionData { Name = LangUtil.Get("bd.today"), Value = "today" },
|
//new OptionData { Name = LangUtil.Get("bd.today"), Value = "today" },
|
new OptionData { Name = LangUtil.Get("bd.week"), Value = "week" },
|
new OptionData { Name = LangUtil.Get("bd.month"), Value = "month" }
|
};
|
|
public ObservableCollection<OptionData> Options
|
{
|
get { return _options; }
|
set { Set(ref _options, value); }
|
}
|
|
private void PluginControl_Loaded(object sender, RoutedEventArgs e)
|
{
|
|
}
|
|
private void Button_Click(object sender, RoutedEventArgs e)
|
{
|
var btn = sender as Button;
|
DateTime start, end;
|
switch (btn.Name)
|
{
|
case "btn0":
|
start = dtp00.SelectedDateTime ?? DateTime.Now;
|
end = dtp01.SelectedDateTime ?? DateTime.Now;
|
RefreshChart0(start, end);
|
break;
|
case "btn1":
|
start = dtp10.SelectedDateTime ?? DateTime.Now;
|
end = dtp11.SelectedDateTime ?? DateTime.Now;
|
RefreshChart1(start, end);
|
break;
|
case "btn2":
|
start = dtp20.SelectedDateTime ?? DateTime.Now;
|
end = dtp21.SelectedDateTime ?? DateTime.Now;
|
RefreshChart2(start, end);
|
break;
|
case "btn3":
|
start = dtp30.SelectedDateTime ?? DateTime.Now;
|
end = dtp31.SelectedDateTime ?? DateTime.Now;
|
RefreshChart3(start, end);
|
break;
|
default:
|
break;
|
}
|
}
|
|
private List<SerialData> SelectSerialDataByTime(DateTime start, DateTime end)
|
{
|
string[] files = DbFileHelper.GetDbFiles(BaseFolder, start, end);
|
if (files == null || files.Length <= 0)
|
{
|
return new List<SerialData>();
|
}
|
string sql = $"SELECT * FROM serialData WHERE time BETWEEN '{start:yyyy-MM-dd HH:mm:ss}' AND '{end:yyyy-MM-dd HH:mm:ss}';";
|
|
DataTable dt = new DataTable();
|
foreach (string file in files)
|
{
|
using (SqliteHelper helper = new SqliteHelper(file))
|
{
|
dt.Merge(helper.GetDataTable(sql));
|
}
|
}
|
return BeanUtil.ReadBeanFromDataTable<SerialData>(dt);
|
}
|
|
private void webview2_Loaded(object sender, RoutedEventArgs e)
|
{
|
string path = Path.Combine(PathHelper.AppFolder, "Libs", "Static", "test.html");
|
webview2.Source = new Uri(path);
|
}
|
|
private void Webview2_NavigationCompleted(object sender, CoreWebView2NavigationCompletedEventArgs e)
|
{
|
cb0.SelectedIndex = 0;
|
cb1.SelectedIndex = 0;
|
cb2.SelectedIndex = 0;
|
cb3.SelectedIndex = 0;
|
}
|
|
private void webview2_SizeChanged(object sender, SizeChangedEventArgs e)
|
{
|
var width = this.webview2.ActualWidth - 100;
|
var height = this.webview2.ActualHeight;
|
webview2.CoreWebView2?.ExecuteScriptAsync($"resize({width},{height})");
|
}
|
|
private void RefreshChart0(DateTime start, DateTime end)
|
{
|
dtp00.SelectedDateTime = start;
|
dtp01.SelectedDateTime = end;
|
List<SerialData> datas = SelectSerialDataByTime(start, end);
|
|
datas.OrderByDescending(e => e.time);
|
int all = 0, output = 0;
|
HashSet<string> snCache = new HashSet<string>();
|
foreach (var data in datas)
|
{
|
if (snCache.Contains(data.sn)) continue;
|
snCache.Add(data.sn);
|
all++;
|
if (data.status == "Passed") output++;
|
}
|
var fields = $"['{this.lang("bd.input")}','{this.lang("bd.output")}']";
|
|
webview2.CoreWebView2?.ExecuteScriptAsync($"drawChart0({fields}, [{all},{output}])");
|
}
|
|
private void RefreshChart1(DateTime start, DateTime end)
|
{
|
dtp10.SelectedDateTime = start;
|
dtp11.SelectedDateTime = end;
|
List<SerialData> datas = SelectSerialDataByTime(start, end);
|
|
datas = datas.OrderByDescending(e => e.time).ToList();
|
Dictionary<string, int> pieData = new Dictionary<string, int> {
|
{ "Passed",0},
|
{ "Failed",0},
|
{ "Action",0},
|
{ "Wait",0},
|
};
|
HashSet<string> snCache = new HashSet<string>();
|
foreach (var data in datas)
|
{
|
if (snCache.Contains(data.sn)) continue;
|
snCache.Add(data.sn);
|
if (pieData.ContainsKey(data.status))
|
{
|
pieData[data.status]++;
|
}
|
}
|
string res = "[";
|
foreach (var key in pieData.Keys)
|
{
|
res += $"{{name:'{key}',value:{pieData[key]}}},";
|
}
|
res += "]";
|
webview2.CoreWebView2?.ExecuteScriptAsync($"drawChart1({res})");
|
}
|
|
private void RefreshChart2(DateTime start, DateTime end)
|
{
|
dtp20.SelectedDateTime = start;
|
dtp21.SelectedDateTime = end;
|
List<SerialData> datas = SelectSerialDataByTime(start, end);
|
|
var groups =
|
datas.GroupBy(d => d.time.ToString("yyyy-MM-dd"));
|
|
Dictionary<string, PassRateData> res = new Dictionary<string, PassRateData>();
|
|
foreach (var group in groups)
|
{
|
Dictionary<string, string> snStatusCache = new Dictionary<string, string>();
|
double all = 0, oneTimePass = 0, passed = 0;
|
var groupDatas = group.ToList();
|
groupDatas = groupDatas.OrderBy(e => e.time).ToList();
|
|
foreach (var data in groupDatas)
|
{
|
if (snStatusCache.ContainsKey(data.sn))
|
{
|
if (snStatusCache[data.sn] != "Passed" && data.status == "Passed")
|
{
|
passed++;
|
}
|
else if (snStatusCache[data.sn] == "Passed" && data.status == "Passed")
|
{
|
oneTimePass--;
|
}
|
}
|
else
|
{
|
all++;
|
if (data.status == "Passed")
|
{
|
passed++;
|
oneTimePass++;
|
}
|
snStatusCache.Add(data.sn, data.status);
|
}
|
}
|
res.Add(group.Key, new PassRateData
|
{
|
time = group.Key,
|
onePassRate = oneTimePass / all * 100,
|
passRate = passed / all * 100,
|
});
|
}
|
|
|
|
string fields = "[", vals0 = "[", vals1 = "[";
|
foreach (var key in res.Keys)
|
{
|
fields += $"'{key}',";
|
vals0 += $"{res[key].onePassRate},";
|
vals1 += $"{res[key].passRate},";
|
}
|
fields += "]";
|
vals0 += "]";
|
vals1 += "]";
|
var names = $"['{this.lang("bd.onePassRate")}','{this.lang("bd.passRate")}']";
|
webview2.CoreWebView2?.ExecuteScriptAsync($"drawChart2({fields},{names},{vals0},{vals1})");
|
}
|
|
private void RefreshChart3(DateTime start, DateTime end)
|
{
|
dtp30.SelectedDateTime = start;
|
dtp31.SelectedDateTime = end;
|
List<SerialData> datas = SelectSerialDataByTime(start, end);
|
|
datas = datas.OrderByDescending(e => e.time).ToList();
|
Dictionary<string, int> pieData = new Dictionary<string, int>();
|
|
HashSet<string> snCache = new HashSet<string>();
|
foreach (var data in datas)
|
{
|
//if (snCache.Contains(data.sn)) continue;
|
if (data.status != "Failed") continue;
|
|
snCache.Add(data.sn);
|
if (pieData.ContainsKey(data.step))
|
{
|
pieData[data.step]++;
|
}
|
else
|
{
|
pieData[data.step] = 1;
|
}
|
}
|
string names = string.Empty, vals = string.Empty;
|
foreach (var key in pieData.Keys)
|
{
|
names += $"'{key}',";
|
vals += $"{pieData[key]},";
|
}
|
|
webview2.CoreWebView2?.ExecuteScriptAsync($"drawChart3([{names}],[{vals}])");
|
}
|
|
private void ComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
|
{
|
ComboBox cb = sender as ComboBox;
|
string val = (e.AddedItems[0] as OptionData)?.Value?.ToString();
|
DateTime start, end;
|
if (val == "today")
|
{
|
DateUtil.GetDayTime(out start, out end);
|
}
|
else if (val == "week")
|
{
|
DateUtil.GetWeekTime(out start, out end);
|
}
|
else
|
{
|
DateUtil.GetMonthTime(out start, out end);
|
}
|
|
switch (cb.Name)
|
{
|
case "cb0":
|
RefreshChart0(start, end);
|
break;
|
case "cb1":
|
RefreshChart1(start, end);
|
break;
|
case "cb2":
|
RefreshChart2(start, end);
|
break;
|
case "cb3":
|
RefreshChart3(start, end);
|
break;
|
default:
|
break;
|
}
|
}
|
}
|
}
|
