using Microsoft.Win32;
using System;
using System.Collections.Generic;
using System.Data;
using System.Text.RegularExpressions;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Input;
using XCommon.Log;
using XCore;
using XHandler.Class;
using XHandler.Class.DataEx;
using XImagingXhandler.XDAL;

namespace XHandler.View.MethodProperty
{
    /// <summary>
    /// DataImportProperty.xaml 的交互逻辑
    /// </summary>
    public partial class DataImportProperty : UserControl
    {
        TransferFileBll transferFileBll = new TransferFileBll();

        public MethodDataImport methodDataImport { get; set; }
        public MethodDataImport currmethodDataImport = null;

        #region 全局属性变量
        string isrun = "";
        string status = "";
        string name = "";
        string label = "";

        string filePath = "";
        int beginLine = 0;
        DataTable transferDataTable = new DataTable();
        string sourceLabware = "";
        string sourceWell = "";
        string sourceLabwareCode = "";
        string destVolume = "";

        int mark = 0;
        #endregion

        public DataImportProperty()
        {
            InitializeComponent();
        }

        public DataImportProperty(MethodEx method)
        {
            InitializeComponent();
            mark = 0;
            methodDataImport = new MethodDataImport();
            methodDataImport.name = method.method_name;
            methodDataImport.label = method.method_name;

            this.DataContext = methodDataImport;
            if (method.tag != null)
            {
                methodDataImport = (MethodDataImport)method.tag;

                currmethodDataImport = methodDataImport;

                isrun = methodDataImport.isrun;
                status = methodDataImport.status;
                name = methodDataImport.name;
                label = methodDataImport.label;

                filePath = methodDataImport.filePath;
                beginLine = methodDataImport.beginLine;
                transferDataTable = methodDataImport.transferDataTable;
                sourceLabware = methodDataImport.sourceLabware;
                sourceWell = methodDataImport.sourceWell;
                sourceLabwareCode = methodDataImport.sourceLabwareCode;
                destVolume = methodDataImport.destVolume;
            }
        }
        #region 选择文件
        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()))
            {
                if (System.IO.Path.HasExtension(tbExcelFile.Text.Trim()))
                    dlg.InitialDirectory = System.IO.Path.GetDirectoryName(tbExcelFile.Text.Trim());
                else
                    dlg.InitialDirectory = tbExcelFile.Text.Trim();
            }
            if (dlg.ShowDialog() == true)
            {
                string fullPath = dlg.FileName;
                tbExcelFile.Text = fullPath;
                if (methodDataImport != null)
                {
                    methodDataImport.filePath = fullPath;
                }

                SelectFile(fullPath);
            }

        }
        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 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 (methodDataImport != null)
                {
                    methodDataImport.transferDataTable = transferData;
                }
                dgTransferFileData.ItemsSource = transferData.DefaultView;

                List<TransferFileHeader> transferFileHeaders = transferFileBll.GetTransferFileHeaders(transferData);

                cbSourceBoardCode.ItemsSource = transferFileHeaders;
                cbSourceBoard.ItemsSource = transferFileHeaders;
                cbSourceWell.ItemsSource = transferFileHeaders;
                cbVolumn.ItemsSource = transferFileHeaders;
            }
        }
        #endregion

        private void tbxCommandName_TextChanged(object sender, TextChangedEventArgs e)
        {
            try
            {
                if (string.IsNullOrEmpty(tbxCommandName.Text))
                {
                    xcError.Text = "命令名称不能为空";
                    return;
                }
                else
                {
                    xcError.Text = "";
                }
                if (methodDataImport != null)
                {
                    methodDataImport.name = tbxCommandName.Text;
                }
            }
            catch (Exception ex)
            {
                LoggerHelper.ErrorLog("ERROR:", ex);
            }
        }

        private void tbExcelFile_TextChanged(object sender, TextChangedEventArgs e)
        {
            try
            {
                if (methodDataImport != null)
                {
                    methodDataImport.filePath = tbExcelFile.Text;
                }
            }
            catch (Exception ex)
            {
                LoggerHelper.ErrorLog("ERROR:", ex);
            }
        }

        private void tbxbeginLine_TextChanged(object sender, TextChangedEventArgs e)
        {
            try
            {
                if (!Regex.IsMatch(tbxbeginLine.Text, @"^[0-9]\d*$"))
                {
                    blError.Text = "请输入正整数";
                    return;
                }
                else
                {
                    blError.Text = "";
                }

                if (methodDataImport != null)
                {
                    methodDataImport.beginLine = Convert.ToInt32(tbxbeginLine.Text);
                }
            }
            catch (Exception ex)
            {
                LoggerHelper.ErrorLog("ERROR:", ex);
            }
        }

        private void cbSourceBoardCode_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            try
            {
                if (cbSourceBoardCode.SelectedItem != null)
                {
                    TransferFileHeader transferFileHeader = cbSourceBoardCode.SelectedItem as TransferFileHeader;
                    if (methodDataImport != null)
                    {
                        methodDataImport.sourceLabwareCode = transferFileHeader.header_name.ToString();
                    }
                }
            }
            catch (Exception ex)
            {
                LoggerHelper.ErrorLog("ERROR:", ex);
            }
        }

        private void cbSourceBoard_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            try
            {
                if (cbSourceBoard.SelectedItem != null)
                {
                    TransferFileHeader transferFileHeader = cbSourceBoard.SelectedItem as TransferFileHeader;
                    if (methodDataImport != null)
                    {
                        methodDataImport.sourceLabware = transferFileHeader.header_name.ToString();
                    }
                }
            }
            catch (Exception ex)
            {
                LoggerHelper.ErrorLog("ERROR:", ex);
            }
        }

        private void cbSourceWell_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            try
            {
                if (cbSourceWell.SelectedItem != null)
                {
                    TransferFileHeader transferFileHeader = cbSourceWell.SelectedItem as TransferFileHeader;
                    if (methodDataImport != null)
                    {
                        methodDataImport.sourceWell = transferFileHeader.header_name.ToString();
                    }
                }
            }
            catch (Exception ex)
            {
                LoggerHelper.ErrorLog("ERROR:", ex);
            }
        }

        private void cbVolumn_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            try
            {
                if (cbVolumn.SelectedItem != null)
                {
                    TransferFileHeader transferFileHeader = cbVolumn.SelectedItem as TransferFileHeader;
                    if (methodDataImport != null)
                    {
                        methodDataImport.destVolume = transferFileHeader.header_name.ToString();
                    }
                }
            }
            catch (Exception ex)
            {
                LoggerHelper.ErrorLog("ERROR:", ex);
            }
        }

        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;

                    //更新所有下拉列表
                    List<TransferFileHeader> transferFileHeaders = transferFileBll.GetTransferFileHeaders(transferDataTable);

                    cbSourceBoard.ItemsSource = transferFileHeaders;

                    cbSourceWell.ItemsSource = transferFileHeaders;

                    cbVolumn.ItemsSource = transferFileHeaders;

                    cbSourceBoardCode.ItemsSource = transferFileHeaders;

                    //if (methodTransferFile.transferDataTable.Columns.Count >= 5)
                    //{
                    cbSourceBoard.Text = sourceLabware;
                    cbSourceWell.Text = sourceWell;
                    cbVolumn.Text = destVolume.ToString();
                    cbSourceBoardCode.Text = sourceLabwareCode;


                    if (currmethodDataImport != null)
                    {
                        methodDataImport = currmethodDataImport;
                    }
                }
                else
                {
                    if (currmethodDataImport != null)
                    {
                        methodDataImport = currmethodDataImport;
                    }
                }
            }
            catch (Exception ex)
            {
                LoggerHelper.ErrorLog("ERROR:", ex);
            }
        }
    }
}