using System;
using System.Collections.Generic;
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 XImagingXhandler.XDAL;
using DataEntity.Page;
using DataRWDAL;
using System.Collections.ObjectModel;
using DataEntity;
using XCommon.Log;
using XHandler.View.BacteriaPickResult;
using XHandler.Class;
using Microsoft.Win32;
using XHandler.View.OperateAudit;

namespace XHandler.View.MoveLiquidReport
{
    /// <summary>
    /// MoveLiquidResult.xaml 的交互逻辑
    /// </summary>
    public partial class MoveLiquidResult : UserControl
    {
        ObservableCollection<ExperimentModel> experimentModelList = new ObservableCollection<ExperimentModel>();
        //LogInformation logInfo = new LogInformation();
        public MainWindow mainWindow = null;

        #region 变量
        // 分页数据
        private Pagination m_pagination = new Pagination();
        #endregion

        public MoveLiquidResult()
        {
            InitializeComponent();
        }

        private void UserControl_Loaded(object sender, RoutedEventArgs e)
        {
            try
            {
                BindingExperimentRunCollection();
            }
            catch (Exception ex)
            {

            }
        }

        private void btnImportReport_Click(object sender, RoutedEventArgs e)
        {

        }

        private void btnRunDetail_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                Button btn = (Button)sender;
                if (btn != null)
                {
                    string experimentId = (string)btn.Tag;

                    MoveLiquidDetails details = new MoveLiquidDetails(experimentId);
                    details.closeEvent += Details_closeEvent;
                    Window wnd = Application.Current.MainWindow;
                    Grid parent = Utilities.FindVisualChild<Grid>(wnd);
                    parent.Children.Add(details);
                }
            }
            catch (Exception ex)
            {
                LoggerHelper.ErrorLog("ERROR:", ex);
            }
        }

        private void Details_closeEvent(object sender, EventArgs e)
        {
            UIElement element = sender as UIElement;
            Window wnd = Application.Current.MainWindow;
            Grid parent = Utilities.FindVisualChild<Grid>(wnd);
            if (parent.Children.Contains(element))
                parent.Children.Remove(element);
            //Window wnd = Application.Current.MainWindow;
            //Grid grid = Utilities.FindVisualChild<Grid>(wnd);

            //UIElement element = sender as UIElement;
            //grid.Children.Remove(element);
        }

        private void btnSearch_Click(object sender, RoutedEventArgs e)
        {
            dgResult.ItemsSource = null;
            pagerToolsControl_paging.Current = PaginationDefaultParameter.Current;
        }

        private void pagerToolsControl_paging_PageCntChanged(object sender, Page.C_EventArgsClass e)
        {
            m_pagination.Current = e.CurrentPageNo;
            DataBinding(m_pagination);
        }

        private void pagerToolsControl_paging_OnePageRowCntChanged(object sender, Page.C_EventArgsClass e)
        {
            m_pagination.Current = e.CurrentPageNo;
            m_pagination.PageSize = e.PagerNum;
            DataBinding(m_pagination);

        }

        private void calendar_SelectedDatesChanged(object sender, SelectionChangedEventArgs e)
        {
            if (e.AddedItems.Count > 0)
            {
                txtStart.Text = calendar.SelectedDates.First().ToString("yyyy/MM/dd");
                txtEnd.Text = calendar.SelectedDates.Last().ToString("yyyy/MM/dd");
            }
        }

        private void DataGridCell_PreviewMouseDoubleClick(object sender, MouseButtonEventArgs e)
        {

        }

        #region 绑定数据集合到界面
        private void BindingExperimentRunCollection()
        {
            DataBinding(m_pagination);
        }
        #endregion

        /// <summary>
        /// 分页绑定
        /// </summary>
        /// <param name="pagination"></param> 
        private void DataBinding(Pagination pagination)
        {
            string startTime = this.txtStart.Text;
            string endTime = this.txtEnd.Text;
            string sourceBarcode = this.txtSrcBarcode.Text;
            string targetBarcode = this.txtTarBarcode.Text;
            experimentModelList=ExperimentDB.GetExperimentCollectionFromdb(startTime, endTime, sourceBarcode, targetBarcode);
            var resultExperimentInformationList = GetPagedData(experimentModelList, pagination.Current, pagination.PageSize);
            var result = new Tuple<IEnumerable<ExperimentModel>, int>(resultExperimentInformationList, experimentModelList.Count());
            if (result != null)
            {
                pagerToolsControl_paging.IsTrigger = false;
                pagerToolsControl_paging.DataCount = result.Item2;   // 当前查到数量
                pagerToolsControl_paging.Current = pagination.Current;
                pagerToolsControl_paging.IsTrigger = true;
                dgResult.ItemsSource = result.Item1;
            }
        }

        #region 集合数据分页方法
        private static IEnumerable<T> GetPagedData<T>(IEnumerable<T> source, int currentPageNumber, int pageSize)
        {
            if (source == null || !source.Any()) return Enumerable.Empty<T>();

            int startIndex = (currentPageNumber - 1) * pageSize;
            int endIndex = Math.Min(startIndex + pageSize, source.Count());

            return source.Skip(startIndex).Take(endIndex - startIndex);
        }
        #endregion

        private void btnDatePick_Click(object sender, RoutedEventArgs e)
        {

        }

        /// <summary>
        /// 导出移液数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnExportReport_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                string fileDir = string.Empty;
                SaveFileDialog dlg = new SaveFileDialog();
                dlg.Title = "另存为";
                string filename = DateTime.Now.ToString("yyyyMMddHHmmss");
                dlg.FileName = $"{filename}.xls";       // 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)
                {
                    Button btn = (Button)sender;
                    if (btn != null)
                    {
                        string experimentId = (string)btn.Tag;
                        ObservableCollection<ExperimentRunDetailModel> experimentRunDetailModelList = ExperimentRunDetailDB.GetMoveLiquidList(experimentId);
                        ExperimentModel experimentModel = ExperimentDB.GetExperimentModelFromdb(experimentId);

                        //把数据转成dataTable
                        System.Data.DataTable dataTable = ExcelAndCsvHelper.ListFormatToDataTable(ExcelAndCsvHelper.ExampleFormatToObject(experimentRunDetailModelList));

                        if (dlg.FileName.Substring(dlg.FileName.LastIndexOf('.') + 1, dlg.FileName.Length - dlg.FileName.LastIndexOf('.') - 1) == "xls")
                        {
                            bool result=ExcelAndCsvHelper.WriteDataTableToExcelFile(dataTable, dlg.FileName, experimentModel.ExperimentName);
                        }
                        else
                        {
                            string fileFullName = dlg.FileName.Substring(0, dlg.FileName.LastIndexOf("\\") + 1) + experimentModel.ExperimentName+"_"+ experimentId+"_"+filename+".csv";
                            ExcelAndCsvHelper.WriteDataTableToCSV(dataTable, fileFullName);
                        }
                        //SaveWorkflow(dlg.FileName, true);
                    }
                }
            }
            catch (Exception ex)
            {
                LoggerHelper.ErrorLog("ERROR:", ex);
            }
        }
    }
}