From c401a2f2fd1a509cdeb33e850bb5c2827074af48 Mon Sep 17 00:00:00 2001
From: alielie <alielie@git.com>
Date: 星期一, 17 三月 2025 08:44:51 +0800
Subject: [PATCH] 完善框架，新增两个close方法；
---
HMI.DataViewer/DataViewer.xaml.cs | 370 +++++++++++++++++++++++++++++++++++++++++-----------
1 files changed, 289 insertions(+), 81 deletions(-)
diff --git a/HMI.DataViewer/DataViewer.xaml.cs b/HMI.DataViewer/DataViewer.xaml.cs
index 6c3ac20..a1e2400 100644
--- a/HMI.DataViewer/DataViewer.xaml.cs
+++ b/HMI.DataViewer/DataViewer.xaml.cs
@@ -2,7 +2,8 @@
using HMI.Core.Util;
using HMI.DataViewer.Entity;
using HMI.UI.Util;
-using Panuon.WPF.UI;
+using NPOI.SS.UserModel;
+using NPOI.XSSF.UserModel;
using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
@@ -12,7 +13,7 @@
using System.Windows;
using System.Windows.Controls;
using System.Windows.Controls.Primitives;
-using System.Windows.Data;
+using System.Windows.Forms;
using System.Windows.Media;
namespace HMI.DataViewer
@@ -48,15 +49,20 @@
private void Button_Click(object sender, RoutedEventArgs e)
{
- Button btn = sender as Button;
+ System.Windows.Controls.Button btn = sender as System.Windows.Controls.Button;
switch (btn.Name)
{
case "addBtn":
- OpenSettingModal(new DataBase_Setting());
+ OpenSettingModal(-1, new DataBase_Setting());
+ break;
+ case "editBtn":
+ EditSettingModal();
break;
case "rfhBtn":
+ LoadData();
break;
case "delBtn":
+ DeleteDatasource();
break;
case "srhBtn":
SearchData();
@@ -64,80 +70,74 @@
case "resetBtn":
ResetDataTable();
break;
+ case "exportBtn":
+ ExportData();
+ break;
default:
break;
}
}
-
- private void OpenSettingModal(DataBase_Setting data)
+ private void DeleteDatasource()
{
- DbSettingModal modal = new DbSettingModal(log)
- {
- Title = "鏂板鏁版嵁婧�",
- Owner = Window.GetWindow(this)
- };
- if (modal.Open(-1, data, Settings, SourceFilePath) == true)
- {
- LoadData();
- }
- }
-
- private void SearchData()
- {
- string program = programInput.Text;
- if (!Map.ContainsKey(program))
- {
- ToastHelper.Error(Window.GetWindow(this), "鍙傛暟寮傚父锛岃鍒锋柊閲嶈瘯");
- return;
- }
-
- var datas = Datas?.Where(d => !string.IsNullOrEmpty(d.Value)).ToList();
- if (datas == null || datas.Count <= 0)
- {
- ToastHelper.Warning(Window.GetWindow(this), "璇疯缃煡璇㈡潯浠跺��");
- return;
- }
-
- DataBase_Setting setting = Map[program];
-
-
- string fields = string.Join(",", Datas?.Select(d => $"[{d.Key}]").ToList());
-
- string conditon = string.Join(" AND ", datas.Select(d => $"[{d.Key}] {d.Condition} '{d.Value}'").ToList());
- string timeCol = setting.TimeCol;
- if (string.IsNullOrEmpty(timeCol))
- {
- timeCol = "time";
- }
- if (!string.IsNullOrEmpty(startTimeInput.Text))
- {
- conditon += $" AND {timeCol} >= '{startTimeInput.Text}'";
- }
- if (!string.IsNullOrEmpty(endTimeInput.Text))
- {
- conditon += $" AND {timeCol} < '{endTimeInput.Text}'";
- }
- conditon = string.IsNullOrEmpty(conditon) ? string.Empty : $" WHERE {conditon}";
-
- SqliteHelper helper = null;
- string sql = string.Empty;
try
{
- helper = new SqliteHelper(setting.DBFilePath);
- sql = $"SELECT {fields} FROM {setting.TableName} {conditon}";
- DataTable dt = helper.GetDataTable(sql);
- HMI.UI.DpUtil.DataGridHelper.SetSelectedColumn(dataTable, null);
- dataTable.ItemsSource = dt.DefaultView;
+ var key = programInput.Text;
+ if (string.IsNullOrEmpty(key))
+ {
+ ToastHelper.Warning(Window.GetWindow(this), this.lang("Dv.SelectDatasourceFirst"));
+ return;
+ }
+ if (!Map.ContainsKey(key))
+ {
+ ToastHelper.Error(Window.GetWindow(this), this.lang("App.ParameterException"));
+ return;
+ }
+ DataBase_Setting setting = Map[key];
+ if (MsgBoxHelper.WarnMessage(Window.GetWindow(this), this.lang("HMI.MakeSureDeleteSingle", setting.Program))
+ == MessageBoxResult.OK)
+ {
+ var temp = XmlHelper.DeepClone(Settings);
+ temp.RemoveAt(Settings.IndexOf(setting));
+ XmlHelper.SerializeToXml(SourceFilePath, temp);
+ ToastHelper.Success(Window.GetWindow(this), this.lang("App.DeleteSuccess"));
+ LoadData();
+ }
}
catch (Exception ex)
{
- log.Error($"Select Data Failed. SQL: {sql}", ex);
- ToastHelper.Error(Window.GetWindow(this), $"鏌ヨ澶辫触锛亄ex.Message}");
+ log.Error("Delete Datasource Failed.", ex);
+ ToastHelper.Success(Window.GetWindow(this), $"{this.lang("App.DeleteFailed")}: {ex.Message}");
}
- finally
+ }
+
+ private void EditSettingModal()
+ {
+ var key = programInput.Text;
+ if (string.IsNullOrEmpty(key))
{
- helper?.Close();
+ ToastHelper.Warning(Window.GetWindow(this), this.lang("Dv.SelectDatasourceFirst"));
+ return;
+ }
+ if (!Map.ContainsKey(key))
+ {
+ ToastHelper.Error(Window.GetWindow(this), this.lang("App.ParameterException"));
+ return;
+ }
+ DataBase_Setting setting = Map[key];
+ OpenSettingModal(Settings.IndexOf(setting), setting);
+ }
+
+ private void OpenSettingModal(int index, DataBase_Setting data)
+ {
+ DbSettingModal modal = new DbSettingModal(log)
+ {
+ Title = this.lang("Dv.AddDatasource"),
+ Owner = Window.GetWindow(this)
+ };
+ if (modal.Open(index, data, Settings, SourceFilePath) == true)
+ {
+ LoadData();
}
}
@@ -166,26 +166,43 @@
private void LoadData()
{
+ ObservableCollection<DataBase_Setting> settings = new ObservableCollection<DataBase_Setting>();
if (File.Exists(SourceFilePath))
{
- List<string> names = new List<string>();
- Settings = XmlHelper.DeserializeFromXml<ObservableCollection<DataBase_Setting>>(SourceFilePath);
- Map.Clear();
- foreach (var data in Settings)
- {
- Map.Add(data.Program, data);
- names.Add(data.Program);
- }
- programInput.ItemsSource = names;
+ settings = XmlHelper.DeserializeFromXml<ObservableCollection<DataBase_Setting>>(SourceFilePath);
}
+ List<string> names = new List<string>();
+
+ Map.Clear();
+ foreach (var data in settings)
+ {
+ Map.Add(data.Program, data);
+ names.Add(data.Program);
+ }
+ programInput.ItemsSource = names;
+ //ResetInput();
+ UpdateAdvanced();
+ Settings = settings;
}
- private void programInput_SelectionChanged(object sender, SelectionChangedEventArgs e)
+ private void ResetInput()
{
- var key = e.AddedItems[0].ToString();
+ programInput.Text = string.Empty;
+ Datas.Clear();
+
+ var temp = dataTable.Columns[0];
+ HMI.UI.DpUtil.DataGridHelper.SetSelectedColumn(dataTable, null);
+ dataTable.Columns.Clear();
+ dataTable.Columns.Add(temp);
+ currentColumns?.Clear();
+ }
+
+ private void UpdateAdvanced()
+ {
+ var key = programInput.Text;
if (!Map.ContainsKey(key))
{
- ToastHelper.Error(Window.GetWindow(this), "鍙傛暟寮傚父锛岃鍒锋柊閲嶈瘯");
+ ResetInput();
return;
}
DataBase_Setting setting = Map[key];
@@ -196,21 +213,54 @@
HMI.UI.DpUtil.DataGridHelper.SetSelectedColumn(dataTable, null);
dataTable.Columns.Clear();
dataTable.Columns.Add(temp);
+
+ List<DataGridTextColumn> columns = new List<DataGridTextColumn>();
foreach (var data in Datas)
{
- AddDataGridTextColumn(data.Name, data.Key);
+ columns.Add(AddDataGridTextColumn(data.Name, data.Key));
}
+ currentColumns = columns;
}
- private void AddDataGridTextColumn(string header, string bindingPath)
+ private void programInput_SelectionChanged(object sender, SelectionChangedEventArgs e)
+ {
+ if (e.AddedItems == null || e.AddedItems.Count <= 0) return;
+ var key = e.AddedItems[0].ToString();
+ if (!Map.ContainsKey(key))
+ {
+ ToastHelper.Error(Window.GetWindow(this), this.lang("App.ParameterException"));
+ programInput.Text = string.Empty;
+ return;
+ }
+ DataBase_Setting setting = Map[key];
+ Datas = new ObservableCollection<QueryData>(
+ setting?.Condition?.Select(d => new QueryData { Key = d.Key, Name = d.Desc, Condition = "=" }).ToList());
+
+ var temp = dataTable.Columns[0];
+ HMI.UI.DpUtil.DataGridHelper.SetSelectedColumn(dataTable, null);
+ dataTable.Columns.Clear();
+ dataTable.Columns.Add(temp);
+
+ List<DataGridTextColumn> columns = new List<DataGridTextColumn>();
+ foreach (var data in Datas)
+ {
+ columns.Add(AddDataGridTextColumn(data.Name, data.Key));
+ }
+ currentColumns = columns;
+ }
+
+ private List<DataGridTextColumn> currentColumns;
+
+ private DataGridTextColumn AddDataGridTextColumn(string header, string bindingPath)
{
DataGridTextColumn textColumn = new DataGridTextColumn
{
Header = header,
- Binding = new Binding(bindingPath),
+ Binding = new System.Windows.Data.Binding(bindingPath),
Width = new DataGridLength(1, DataGridLengthUnitType.Star)
};
dataTable.Columns.Add(textColumn);
+ return textColumn;
}
private void dataTable_PreviewMouseLeftButtonDown(object sender, System.Windows.Input.MouseButtonEventArgs e)
@@ -252,10 +302,168 @@
}
}
+ private DataTable DoSearchData(DataBase_Setting setting, List<QueryData> datas)
+ {
+ string fields = string.Join(",", Datas?.Select(d => $"[{d.Key}]").ToList());
+
+ string conditon = string.Join(" AND ", datas.Select(d => $"[{d.Key}] {d.Condition} '{d.Value}'").ToList());
+ string timeCol = setting.TimeCol;
+ if (string.IsNullOrEmpty(timeCol))
+ {
+ timeCol = "time";
+ }
+ if (!string.IsNullOrEmpty(startTimeInput.Text))
+ {
+ conditon += $" AND {timeCol} >= '{startTimeInput.Text}'";
+ }
+ if (!string.IsNullOrEmpty(endTimeInput.Text))
+ {
+ conditon += $" AND {timeCol} < '{endTimeInput.Text}'";
+ }
+ conditon = string.IsNullOrEmpty(conditon) ? string.Empty : $" WHERE {conditon}";
+
+ SqliteHelper helper = null;
+ string sql = string.Empty;
+ try
+ {
+ helper = new SqliteHelper(setting.DBFilePath);
+ sql = $"SELECT {fields} FROM {setting.TableName} {conditon}";
+ DataTable dt = helper.GetDataTable(sql);
+ HMI.UI.DpUtil.DataGridHelper.SetSelectedColumn(dataTable, null);
+ dataTable.ItemsSource = dt.DefaultView;
+ return dt;
+ }
+ catch (Exception ex)
+ {
+ log.Error($"Select Data Failed. SQL: {sql}", ex);
+ throw ex;
+ }
+ finally
+ {
+ helper?.Close();
+ }
+ }
+
+ private void SearchData()
+ {
+ string program = programInput.Text;
+ if (!Map.ContainsKey(program))
+ {
+ ToastHelper.Error(Window.GetWindow(this), this.lang("App.ParameterException"));
+ return;
+ }
+
+ var datas = Datas?.Where(d => !string.IsNullOrEmpty(d.Value)).ToList();
+ if (datas == null || datas.Count <= 0)
+ {
+ ToastHelper.Warning(Window.GetWindow(this), this.lang("Dv.QueryCantBeEmpty"));
+ return;
+ }
+
+ DataBase_Setting setting = Map[program];
+
+ try
+ {
+ DoSearchData(setting, datas);
+ }
+ catch (Exception ex)
+ {
+ ToastHelper.Error(Window.GetWindow(this), $"{this.lang("App.QueryFailed")}: {ex.Message}");
+ }
+ }
+
+ private void ExportData()
+ {
+ try
+ {
+ string program = programInput.Text;
+ if (string.IsNullOrEmpty(program))
+ {
+ ToastHelper.Warning(Window.GetWindow(this), this.lang("Dv.SelectDatasourceFirst"));
+ return;
+ }
+
+ if (!Map.ContainsKey(program))
+ {
+ ToastHelper.Error(Window.GetWindow(this), this.lang("App.ParameterException"));
+ return;
+ }
+
+ var datas = Datas?.Where(d => !string.IsNullOrEmpty(d.Value)).ToList();
+ if (datas == null || datas.Count <= 0)
+ {
+ ToastHelper.Warning(Window.GetWindow(this), this.lang("Dv.QueryCantBeEmpty"));
+ return;
+ }
+
+ DataBase_Setting setting = Map[program];
+ DataTable dt;
+ try
+ {
+ dt = DoSearchData(setting, datas);
+ }
+ catch (Exception ex)
+ {
+ ToastHelper.Error(Window.GetWindow(this), $"{this.lang("App.QueryFailed")}: {ex.Message}");
+ return;
+ }
+
+ if (currentColumns == null) return;
+ var dataView = dt?.DefaultView;
+ if (dataView == null) return;
+
+ string fname = string.Empty;
+ SaveFileDialog sfd = new SaveFileDialog();
+
+ sfd.Filter = "";
+ sfd.DefaultExt = "xls";
+ sfd.FileName = setting.Program;
+ if (sfd.ShowDialog() == DialogResult.OK)
+ {
+ fname = sfd.FileName;
+ }
+
+ /*瀵煎嚭褰撳墠dataGridView涓殑鎵�鏈夋暟鎹埌xls鏂囦欢
+ 1.寮曞叆搴撴枃浠�,鏂板缓lib鏂囦欢澶癸紝澶嶅埗鐩稿叧鏂囦欢
+ 2.鍦ㄩ」鐩腑娣诲姞瀵硅繖鍑犱釜dll鐨勫紩鐢�
+ 3.鍦ㄥ唴瀛樹腑寤虹珛 excel琛ㄦ枃浠� */
+ XSSFWorkbook workbook = new XSSFWorkbook();
+ workbook.CreateSheet("sheet1");////鏂板缓涓�涓伐浣滆〃
+ XSSFSheet SheetOne = (XSSFSheet)workbook.GetSheet("Sheet1"); ////鑾峰彇鍚嶇О涓篠heet1鐨勫伐浣滆〃,鍒涘缓鏍囬澶�
+ IRow row1 = SheetOne.CreateRow(0);////鑾峰彇Sheet1宸ヤ綔琛ㄧ殑棣栬,璁剧疆琛ㄥご锛岃幏鍙栧垪
+ //XSSFCell[] SheetCell = new XSSFCell[currentColumns.Count];
+ for (int i = 0; i < currentColumns.Count; i++)
+ {
+ row1.CreateCell(i).SetCellValue(currentColumns[i].Header.ToString());
+ }
+
+ for (int i = 0; i < dataView.Count; i++)
+ {
+ IRow rowTemp = SheetOne.CreateRow(i + 1);
+ for (int j = 0; j < currentColumns.Count; j++)
+ {
+ string name = ((System.Windows.Data.Binding)currentColumns[j].Binding).Path.Path;
+ var value = dataView[i][name].ToString();
+ rowTemp.CreateCell(j).SetCellValue(value);
+ }
+ }
+
+ using (FileStream fs = new FileStream(fname, FileMode.Create))
+ {
+ workbook.Write(fs);
+ }
+ ToastHelper.Success(Window.GetWindow(this), this.lang("App.ExportSuccess"));
+ }
+ catch (Exception ex)
+ {
+ log.Error("Export Data Failed.", ex);
+ ToastHelper.Error(Window.GetWindow(this), $"{this.lang("App.ExportFailed")}: {ex.Message}");
+ }
+ }
+
private void MenuItem_Click(object sender, RoutedEventArgs e)
{
DataGridColumn column = HMI.UI.DpUtil.DataGridHelper.GetSelectedColumn(dataTable);
-
}
}
}
--
Gitblit v1.9.1