using LB_SmartVision.CSV;
|
using LB_SmartVision.SQL;
|
using LB_SmartVisionCommon;
|
using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Globalization;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using System.Windows.Forms;
|
|
namespace LB_SmartVision.Forms.Pages.HistoricalData
|
{
|
public partial class HistoricalDataEditPage : UserControl
|
{
|
public Action<string, LogInfoType> LogInfo;
|
// 保存原始数据的列表
|
private List<DataGridViewRow> originalRows = new List<DataGridViewRow>();
|
|
private int row2OriginalHeight;
|
private int row3OriginalHeight;
|
|
List<RecordProductData> RecordProductDatas = new List<RecordProductData>();
|
public HistoricalDataEditPage()
|
{
|
Name = "HistoricalDataEditPage";
|
Text = "历史数据查询";
|
|
InitializeComponent();
|
|
// 保存原始行高度
|
row2OriginalHeight = (int)tableLayoutPanel3.RowStyles[1].Height;
|
row3OriginalHeight = (int)tableLayoutPanel3.RowStyles[2].Height;
|
|
InitializeDataGridView();
|
InitializeComboBox();
|
}
|
|
/// <summary>
|
/// 数据显示表格初始化
|
/// </summary>
|
private void InitializeDataGridView()
|
{
|
this.dataGridViewHD.DataSource = RecordProductDatas;
|
|
dataGridViewHD.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
|
|
// 禁止编辑单元格（可选）
|
dataGridViewHD.ReadOnly = true;
|
|
// 允许多行选择（可选）
|
dataGridViewHD.MultiSelect = false;
|
|
// 显示行标题（可选）
|
dataGridViewHD.RowHeadersVisible = true;
|
}
|
|
/// <summary>
|
/// 选择依据下拉框初始化
|
/// </summary>
|
private void InitializeComboBox()
|
{
|
comboBoxSearchBasis.Items.Add("日期");
|
comboBoxSearchBasis.Items.Add("SN号");
|
|
// 设置默认选择项
|
comboBoxSearchBasis.SelectedIndex = 0;
|
}
|
|
/// <summary>
|
/// 下拉框控制选项视图变换
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void comboBoxSearchBasis_SelectedIndexChanged(object sender, EventArgs e)
|
{
|
ComboBox cb = sender as ComboBox;
|
|
if (cb.SelectedIndex == 0)
|
{
|
ShowRow2();
|
}
|
else if (cb.SelectedIndex == 1)
|
{
|
ShowRow3();
|
}
|
}
|
|
private void ShowRow2()
|
{
|
// 显示Row2（恢复高度）
|
tableLayoutPanel3.RowStyles[1].SizeType = SizeType.Absolute;
|
tableLayoutPanel3.RowStyles[1].Height = row2OriginalHeight;
|
|
// 隐藏Row3（高度设为0）
|
tableLayoutPanel3.RowStyles[2].SizeType = SizeType.Absolute;
|
tableLayoutPanel3.RowStyles[2].Height = 0;
|
|
// 显示Row2中的控件
|
foreach (Control ctrl in tableLayoutPanel3.Controls)
|
{
|
int row = tableLayoutPanel3.GetRow(ctrl);
|
if (row == 1)
|
ctrl.Visible = true;
|
else if (row == 2)
|
ctrl.Visible = false;
|
}
|
}
|
|
private void ShowRow3()
|
{
|
// 隐藏Row2（高度设为0）
|
tableLayoutPanel3.RowStyles[1].SizeType = SizeType.Absolute;
|
tableLayoutPanel3.RowStyles[1].Height = 0;
|
|
// 显示Row3（恢复高度）
|
tableLayoutPanel3.RowStyles[2].SizeType = SizeType.Absolute;
|
tableLayoutPanel3.RowStyles[2].Height = row3OriginalHeight;
|
|
// 显示Row3中的控件
|
foreach (Control ctrl in tableLayoutPanel3.Controls)
|
{
|
int row = tableLayoutPanel3.GetRow(ctrl);
|
if (row == 1)
|
ctrl.Visible = false;
|
else if (row == 2)
|
ctrl.Visible = true;
|
}
|
}
|
|
private void dateTimePickerStart_ValueChanged(object sender, EventArgs e)
|
{
|
dateTimePickerEnd.MinDate = dateTimePickerStart.Value;
|
}
|
public string OpenFileForSave()
|
{
|
using (SaveFileDialog saveFileDialog = new SaveFileDialog())
|
{
|
// 设置默认文件名和扩展名
|
saveFileDialog.FileName = $"历史数据_{DateTime.Now:yyyyMMdd_HHmmss}";
|
saveFileDialog.DefaultExt = "xlsx";
|
|
// 设置文件过滤器
|
saveFileDialog.Filter = "Excel文件 (*.xlsx)|*.xlsx|" +
|
"CSV文件 (*.csv)|*.csv|" +
|
"文本文件 (*.txt)|*.txt|" +
|
"所有文件 (*.*)|*.*";
|
|
saveFileDialog.Title = "选择文件保存位置";
|
saveFileDialog.RestoreDirectory = true; // 记住上次打开的目录
|
saveFileDialog.OverwritePrompt = true; // 覆盖时提示
|
|
if (saveFileDialog.ShowDialog() == DialogResult.OK)
|
{
|
string filePathHD = saveFileDialog.FileName;
|
return filePathHD;
|
}
|
}
|
|
return null;
|
}
|
private void btnHisDataExport_Click(object sender, EventArgs e)
|
{
|
CsvDataHelperRecordProductData.SaveToCsv(OpenFileForSave(), RecordProductDatas);
|
}
|
|
private void btnHisDataFind_Click(object sender, EventArgs e)
|
{
|
|
DateTime startDate = dateTimePickerStart.Value.Date;
|
DateTime endDate = dateTimePickerEnd.Value.Date;
|
|
switch(comboBoxSearchBasis.SelectedIndex)
|
{
|
//依据日期查询
|
case 0:
|
RecordProductDatas = RecordProductDataRepository.GetRecordsByTimeRange(DateTime.Parse(this.dateTimePickerStart.Value.ToString()), DateTime.Parse(this.dateTimePickerEnd.Value.ToString()));
|
break;
|
//依据SN号查询
|
case 1:
|
if(string.IsNullOrEmpty(textBoxSN.Text))
|
{
|
MessageBox.Show("请填写SN号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
}
|
else
|
{
|
RecordProductDatas = RecordProductDataRepository.GetRecordsByProductNumber(textBoxSN.Text);
|
}
|
break;
|
}
|
|
this.dataGridViewHD.DataSource = RecordProductDatas;
|
this.dataGridViewHD.AutoGenerateColumns = true;
|
|
}
|
|
}
|
}
|
