using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using System.Windows;
|
using System.Windows.Controls;
|
using System.Windows.Data;
|
using System.Windows.Documents;
|
using System.Windows.Input;
|
using System.Windows.Media;
|
using System.Windows.Media.Imaging;
|
using System.Windows.Navigation;
|
using System.Windows.Shapes;
|
using XCommon.Log;
|
using XImagingXhandler.XDAL;
|
using Microsoft.Win32;
|
using XCore;
|
using XHandler.Class;
|
using HandyControl.Data;
|
using XCommon.Tip;
|
using System.CodeDom.Compiler;
|
using System.IO;
|
|
namespace XHandler.View.MethodProperty
|
{
|
/// <summary>
|
/// VariableImportProperty.xaml 的交互逻辑
|
/// </summary>
|
public partial class VariableImportProperty : UserControl
|
{
|
public MethodVariableImport methodVariableImport { get; set; }
|
public MethodVariableImport currmethodVariableImport = null;
|
|
#region 全局属性变量
|
string isrun = "";
|
string status = "";
|
string name = "";
|
string label = "";
|
|
string filePath = "";
|
DataTable transferDataTable = new DataTable();
|
|
int mark = 0;
|
#endregion
|
|
public VariableImportProperty()
|
{
|
InitializeComponent();
|
}
|
|
public VariableImportProperty(MethodEx method)
|
{
|
InitializeComponent();
|
mark = 0;
|
methodVariableImport = new MethodVariableImport();
|
methodVariableImport.name = method.method_name;
|
methodVariableImport.label = method.method_name;
|
|
this.DataContext = methodVariableImport;
|
if (method.tag != null)
|
{
|
methodVariableImport = (MethodVariableImport)method.tag;
|
|
currmethodVariableImport = methodVariableImport;
|
|
isrun = methodVariableImport.isrun;
|
status = methodVariableImport.status;
|
name = methodVariableImport.name;
|
label = methodVariableImport.label;
|
|
filePath = methodVariableImport.filePath;
|
transferDataTable = methodVariableImport.transferDataTable;
|
}
|
}
|
|
private void tbxCommandName_TextChanged(object sender, TextChangedEventArgs e)
|
{
|
try
|
{
|
if (string.IsNullOrEmpty(tbxCommandName.Text))
|
{
|
xcError.Text = "命令名称不能为空";
|
return;
|
}
|
else
|
{
|
xcError.Text = "";
|
}
|
if (methodVariableImport != null)
|
{
|
methodVariableImport.name = tbxCommandName.Text;
|
}
|
}
|
catch (Exception ex)
|
{
|
LoggerHelper.ErrorLog("ERROR:", ex);
|
}
|
}
|
|
private void btnSelectFile_Click(object sender, RoutedEventArgs e)
|
{
|
OpenFileDialog dlg = new OpenFileDialog();
|
dlg.Title = "请选择Excel文件";
|
dlg.FileName = string.Empty;
|
dlg.FilterIndex = 1;
|
dlg.RestoreDirectory = true;
|
dlg.Filter = "excel files(*.xls)|*.xls|csv files(*.csv)|*.csv|All files(*.*)|*.*";
|
dlg.Multiselect = false;
|
if (!string.IsNullOrEmpty(tbExcelFile.Text.Trim()))
|
{
|
try
|
{
|
if (System.IO.Path.HasExtension(tbExcelFile.Text.Trim()))
|
dlg.InitialDirectory = System.IO.Path.GetDirectoryName(tbExcelFile.Text.Trim());
|
else
|
dlg.InitialDirectory = tbExcelFile.Text.Trim();
|
}
|
catch (Exception ex)
|
{
|
|
}
|
}
|
if (dlg.ShowDialog() == true)
|
{
|
string fullPath = dlg.FileName;
|
tbExcelFile.Text = fullPath;
|
if (methodVariableImport != null)
|
{
|
methodVariableImport.filePath = fullPath;
|
}
|
|
SelectFile(fullPath);
|
}
|
}
|
|
private void SelectFile(string file)
|
{
|
string ext = System.IO.Path.GetExtension(file);
|
DataTable transferData = null;
|
if (string.Compare(ext, ".csv", true) == 0)
|
transferData = ExcelAndCsvHelper.GetDataTableFromCsvFile(file);
|
else
|
transferData = ExcelAndCsvHelper.GetDataTableFromExcelFile(file, true);
|
|
if (transferData != null)
|
{
|
//判断表头是否符合要求
|
if(transferData.Columns.Contains("paraName")&& transferData.Columns.Contains("paraValue"))
|
{
|
CodeDomProvider provider = CodeDomProvider.CreateProvider("C#");
|
foreach (DataRow dataRow in transferData.Rows)
|
{
|
if (provider.IsValidIdentifier(dataRow["paraName"].ToString()))
|
{
|
|
}
|
else
|
{
|
ShowTip.ShowNotice(string.Format("{0}{1}{2}", "提醒", Environment.NewLine, "表格内容列'" + dataRow["paraName"].ToString() + "'不符合规范,未能加载"), InfoType.Warning);
|
dgTransferFileData.ItemsSource = null;
|
return;
|
}
|
}
|
|
if (methodVariableImport != null)
|
{
|
methodVariableImport.transferDataTable = transferData;
|
}
|
dgTransferFileData.ItemsSource = transferData.DefaultView;
|
|
List<TransferFileHeader> transferFileHeaders = new TransferFileBll().GetTransferFileHeaders(transferData);
|
}
|
else
|
{
|
ShowTip.ShowNotice(string.Format("{0}{1}{2}", "提醒", Environment.NewLine, "表格头不符合规范,未能加载"), InfoType.Warning);
|
dgTransferFileData.ItemsSource = null;
|
}
|
|
|
}
|
}
|
|
private void UserControl_Loaded(object sender, RoutedEventArgs e)
|
{
|
mark += 1;
|
try
|
{
|
if (mark > 1)
|
{
|
return;
|
}
|
|
if (!string.IsNullOrEmpty(filePath))
|
{
|
tbxCommandName.Text = name;
|
|
dgTransferFileData.ItemsSource = transferDataTable.DefaultView;
|
tbExcelFile.Text = filePath;
|
|
if (currmethodVariableImport != null)
|
{
|
methodVariableImport = currmethodVariableImport;
|
}
|
}
|
else
|
{
|
if (currmethodVariableImport != null)
|
{
|
methodVariableImport = currmethodVariableImport;
|
}
|
}
|
}
|
catch (Exception ex)
|
{
|
LoggerHelper.ErrorLog("ERROR:", ex);
|
}
|
}
|
|
private void tbExcelFile_TextChanged(object sender, TextChangedEventArgs e)
|
{
|
try
|
{
|
if (methodVariableImport != null)
|
{
|
methodVariableImport.filePath = tbExcelFile.Text;
|
}
|
}
|
catch (Exception ex)
|
{
|
LoggerHelper.ErrorLog("ERROR:", ex);
|
}
|
}
|
|
private void tbExcelFile_PreviewKeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.Key == Key.Enter)
|
{
|
if (!string.IsNullOrEmpty(tbExcelFile.Text.Trim()))
|
{
|
if (System.IO.Path.HasExtension(tbExcelFile.Text.Trim()))
|
{
|
if (System.IO.File.Exists(tbExcelFile.Text.Trim()))
|
{
|
SelectFile(tbExcelFile.Text.Trim());
|
}
|
}
|
}
|
}
|
}
|
|
private void btnDownloadTemplate_Click(object sender, RoutedEventArgs e)
|
{
|
//弹出保存对话框
|
try
|
{
|
string fileDir = string.Empty;
|
SaveFileDialog dlg = new SaveFileDialog();
|
dlg.Title = "另存为";
|
dlg.FileName = $"{DateTime.Now.ToString("yyyyMMddHHmmss")}.csv"; // Default file name
|
dlg.DefaultExt = ".xls"; // Default file extension
|
dlg.Filter = "excel files(*.xls)|*.xls|csv files(*.csv)|*.csv";// Filter files by extension
|
dlg.InitialDirectory = System.AppDomain.CurrentDomain.BaseDirectory;
|
|
if (dlg.ShowDialog() == true)
|
{
|
string directoryBase = System.AppDomain.CurrentDomain.BaseDirectory;
|
string sourceFilePath = directoryBase + "TempData\\variableImport.csv";
|
File.Copy(sourceFilePath, dlg.FileName, true);
|
ShowTip.ShowNotice(string.Format("{0}成功{1}{2}", "下载保存", Environment.NewLine, dlg.FileName), InfoType.Warning);
|
}
|
}
|
catch (Exception ex)
|
{
|
ShowTip.ShowNotice(string.Format("{0}失败{1}{2}", "下载保存", Environment.NewLine, ""), InfoType.Warning);
|
LoggerHelper.ErrorLog("btnDownloadTemplate_Click ERROR:", ex);
|
}
|
}
|
}
|
}
|
