using DevExpress.Mvvm.POCO;
using DevExpress.Utils;
using DevExpress.XtraCharts;
using DevExpress.XtraGrid.Columns;
using DevExpress.XtraGrid.Views.Grid;
using Org.BouncyCastle.Tls.Crypto;
using System.Data;
using System.IO;
using Yw.WinFrmUI;

namespace PBS.WinFrmUI.DataAnalysis
{
    public partial class EnergyAnalysis : DocumentPage
    {
        public EnergyAnalysis()
        {
            InitializeComponent();
            InitialChart();
        }

        private List<FlowPressChartViewModel> _datalist;

        private DataTable _datatable;

        private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            //导入文件
            var dlg = new System.Windows.Forms.OpenFileDialog();
            dlg.Filter = "EXCEL 文件(*.xls)|*.xls";
            dlg.CheckFileExists = true;
            if (dlg.ShowDialog() != System.Windows.Forms.DialogResult.OK)
                return;
            _datalist = new List<FlowPressChartViewModel>();
            _datatable = new DataTable();
            ParseExcel(dlg.FileName, out _datalist, out _datatable);
            if (_datalist.Any())
            {
                SetBindingData(_datalist, _datatable);
            }
        }

        private double _totalPrice = 0;

        #region Private Variable

        private XYDiagram _diagram;
        private XYDiagramDefaultPane _default_pane;

        private AxisX _axis_x_flow;
        private AxisY _axis_y_head;
        private SecondaryAxisY _axis_y_eff;

        #endregion Private Variable

        private class PowerData
        {
            public double Power;

            public DateTime Time;
        }

        private List<PowerData> _oldData;
        private List<PowerData> _newData;

        /// <summary>
        /// 初始化图表
        /// </summary>
        private void InitialChart()
        {
            this.chartControl1.RuntimeHitTesting = true;

            this.chartControl1.Legend.Visibility = DefaultBoolean.True;
            _diagram = (XYDiagram)this.chartControl1.Diagram;
            _diagram.EnableAxisXScrolling = true;
            _diagram.EnableAxisYScrolling = true;
            _diagram.EnableAxisXZooming = true;
            _diagram.EnableAxisYZooming = true;
            _default_pane = _diagram.DefaultPane;

            _diagram.AxisX.DateTimeScaleOptions.MeasureUnit = DateTimeMeasureUnit.Second;
            _diagram.AxisX.DateTimeScaleOptions.ScaleMode = ScaleMode.Continuous;

            _axis_x_flow = _diagram.AxisX;
            _axis_y_head = _diagram.AxisY;
            _axis_y_eff = _diagram.SecondaryAxesY.GetAxisByName("AxisYEff");
            _axis_y_eff.Alignment = AxisAlignment.Far;

            _axis_x_flow.GridLines.Visible = false;
            _axis_y_head.GridLines.Visible = false;
            _axis_y_eff.GridLines.Visible = false;

            this.chartControl1.CrosshairEnabled = DefaultBoolean.True;
        }

        /// <summary>
        /// 设置图表
        /// </summary>
        public void SetBindingData(List<FlowPressChartViewModel> vm_list, DataTable dataTable)
        {
            var view = gridControl1.MainView as GridView;
            view.Columns.Clear();

            this.chartControl1.BeginInit();
            //this.chartControl1.Series.Clear();
            for (int i = this.chartControl1.AnnotationRepository.Count - 1; i > 0; i--)
            {
                if (i == 0)
                    break;
                this.chartControl1.AnnotationRepository.RemoveAt(i);
            }
            this.chartControl1.Legend.CustomItems.Clear();
            if (IsInvalidData())
            {
                this.chartControl1.EndInit();
                return;
            }

            AxisXBase axis_x = null;
            AxisYBase axis_y = null;
            XYDiagramPaneBase pane = null;

            var colTime = new GridColumn();
            colTime.FieldName = "时间";
            colTime.Caption = "时间";
            colTime.Visible = true;
            view.Columns.Add(colTime);
            var totalFlow = new List<double>();
            foreach (var vm in vm_list)
            {
                if (!vm.Name.Contains("压力"))
                {
                    axis_x = _axis_x_flow;
                    axis_y = _axis_y_head;
                    pane = _default_pane;
                    totalFlow = vm.Datas.Select(c => c.Y).ToList();
                }
                else
                {
                    axis_x = _axis_x_flow;
                    axis_y = _axis_y_eff;
                    pane = _default_pane;
                }
                var col = new GridColumn();
                col.FieldName = vm.Name;
                col.Caption = vm.Name;
                col.Visible = true;
                view.Columns.Add(col);

                AddLineSeries(vm.Name, axis_x, axis_y, pane, vm.Datas);
            }

            double totalEl = 0;
            double totalOldEl = 0;
            var tempdatas = vm_list.FirstOrDefault(c => c.Name.Contains("压力"));
            var tempflow = vm_list.FirstOrDefault(c => c.Name.Contains("流量"));
            _oldData = new List<PowerData>();
            _newData = new List<PowerData>();
            foreach (var item in tempdatas.Datas)
            {
                var flow = tempflow.Datas.FirstOrDefault(c => c.Time == item.Time);
                if (flow != null)
                {
                    var oldpressM = Yw.Pump.CalculationHelper.Mpa2M(Press);
                    var newpressM = Yw.Pump.CalculationHelper.Mpa2M(item.Y);
                    var oldel = Yw.Pump.CalculationHelper.CalcuP(flow.Y, oldpressM, Efficiency);
                    var newel = Yw.Pump.CalculationHelper.CalcuP(flow.Y, newpressM, Efficiency);
                    _oldData.Add(new PowerData
                    {
                        Power = oldel / 60,
                        Time = DateTime.Parse(item.Time)
                    });
                    _newData.Add(new PowerData
                    {
                        Power = newel / 60,
                        Time = DateTime.Parse(item.Time)
                    });
                    var el = oldel / 60 - newel / 60;
                    totalOldEl += oldel / 60;
                    totalEl += el;
                    var Fy = ElecPriceHelper.CalcuShysElectricityFees(DateTime.Parse(item.Time), el);
                    //totalFy += Fy;
                }
                //item.Y = Press;//Yw.Pump.CalculationHelper.CalcuP();
            }

            AddLineSeries("原泵后压力", axis_x, _axis_y_eff, _default_pane, tempdatas.Datas);

            var min_x = vm_list.SelectMany(x => x.Datas).Min(x => DateTime.Parse(x.Time));
            var max_x = vm_list.SelectMany(x => x.Datas).Max(x => DateTime.Parse(x.Time));

            _axis_x_flow.NumericScaleOptions.AutoGrid = false;
            _axis_x_flow.WholeRange.SideMarginsValue = 0;
            _axis_x_flow.VisualRange.SideMarginsValue = 0;
            _axis_x_flow.WholeRange.SetMinMaxValues(min_x, max_x);
            _axis_x_flow.VisualRange.SetMinMaxValues(min_x, max_x);

            var diff_days = max_x - min_x;
            textEdit1.Text = Math.Round(diff_days.TotalDays).ToString();
            textEdit2.Text = Math.Round(totalFlow.Sum() / 60).ToString();
            textEdit3.Text = Math.Round(totalEl).ToString();
            textEdit4.Text = Math.Round(totalEl / totalOldEl * 100).ToString();
            gridControl1.DataSource = dataTable;
            this.chartControl1.EndInit();
            SetEffData();
            SetEffPriceData();
        }

        private void SetEffData()
        {
            double totalEffBefore = 0;
            double totalEffAfter = 0;
            var SeriseOld = this.chartControl1.GetSeriesByName("改造前(度)");
            SeriseOld.Points.Clear();
            if (_oldData != null)
            {
                foreach (var item in _oldData)
                {
                    totalEffBefore += item.Power;
                    SeriseOld.Points.Add(new SeriesPoint(item.Time, item.Power));
                }
            }
            this.textEditEffBefore.Text = Math.Round(totalEffBefore).ToString();
            var SeriseNew = this.chartControl1.GetSeriesByName("改造后(度)");
            SeriseNew.Points.Clear();
            if (_newData != null)
            {
                foreach (var item in _newData)
                {
                    totalEffAfter += item.Power;
                    SeriseNew.Points.Add(new SeriesPoint(item.Time, item.Power));
                }
            }
            this.textEditEffAfter.Text = Math.Round(totalEffAfter).ToString();

            var SeriesDef = this.chartControl1.GetSeriesByName("节省值(度)");
            SeriesDef.Points.Clear();

            if (_oldData != null && _newData != null)
            {
                for (int i = 0; i < _oldData.Count; i++)
                {
                    var def = _oldData[i].Power - _newData[i].Power;
                    SeriesDef.Points.Add(new SeriesPoint(_newData[i].Time, def));
                }
            }
        }

        private void SetEffPriceData()
        {
            _totalPrice = default;
            double totalBeforePrice = 0;
            double totalAfterPrice = 0;
            List<PowerData> oldPrice = null;
            List<PowerData> newPrice = null;
            var SeriseOld = this.chartControl1.GetSeriesByName("改造前(元)");
            SeriseOld.Points.Clear();
            if (_oldData != null)
            {
                oldPrice = new List<PowerData>();
                foreach (var item in _oldData)
                {
                    var price = ElecPriceHelper.CalcuShysElectricityFees(item.Time, item.Power);
                    totalBeforePrice += price;
                    SeriseOld.Points.Add(new SeriesPoint(item.Time, price));
                    oldPrice.Add(new PowerData { Time = item.Time, Power = item.Power });
                }
            }
            this.textEditPriceBefore.Text = Math.Round(totalBeforePrice).ToString();
            var SeriseNew = this.chartControl1.GetSeriesByName("改造后(元)");
            SeriseNew.Points.Clear();
            if (_newData != null)
            {
                newPrice = new List<PowerData>();
                foreach (var item in _newData)
                {
                    var price = ElecPriceHelper.CalcuShysElectricityFees(item.Time, item.Power);
                    totalAfterPrice += price;
                    SeriseNew.Points.Add(new SeriesPoint(item.Time, price));
                    newPrice.Add(new PowerData { Time = item.Time, Power = item.Power });
                }
            }
            this.textEditPriceAfter.Text = Math.Round(totalAfterPrice).ToString();
            var SeriesDef = this.chartControl1.GetSeriesByName("节省值(元)");
            SeriesDef.Points.Clear();

            if (oldPrice != null && newPrice != null)
            {
                for (int i = 0; i < oldPrice.Count; i++)
                {
                    var def = oldPrice[i].Power - newPrice[i].Power;
                    _totalPrice += def;
                    SeriesDef.Points.Add(new SeriesPoint(oldPrice[i].Time, def));
                }
            }
            textEdit5.Text = Math.Round(_totalPrice).ToString();
        }

        //是否是无效数据
        private bool IsInvalidData()
        {
            return false;
        }

        private void AddLineSeries(string id, AxisXBase axis_x, AxisYBase axis_y, XYDiagramPaneBase pane, List<TimeChartViewModel> pt_list, DevExpress.XtraCharts.DashStyle dash = DevExpress.XtraCharts.DashStyle.Solid)
        {
            if (pt_list == null || !pt_list.Any())
                return;

            var view = new DevExpress.XtraCharts.LineSeriesView();
            view.LineStyle.DashStyle = dash;
            view.LineStyle.LineJoin = System.Drawing.Drawing2D.LineJoin.Round;
            view.LineStyle.Thickness = 2;
            if (dash != DashStyle.Solid)
            {
                view.LineStyle.Thickness = 3;
            }

            view.EnableAntialiasing = DefaultBoolean.True;
            view.MarkerVisibility = DefaultBoolean.False;
            view.AxisX = axis_x;
            view.AxisY = axis_y;
            view.EmptyPointOptions.Color = Color.Transparent;
            view.Pane = pane;

            var series_pt_list = pt_list.Select(x => new SeriesPoint(DateTime.Parse(x.Time), x.Y)).ToArray();
            var series = this.chartControl1.GetSeriesByName(id);
            series.Points.Clear();
            series.Tag = id;
            //series.ShowInLegend = false;
            series.Name = id;
            series.ArgumentScaleType = DevExpress.XtraCharts.ScaleType.DateTime;
            series.DateTimeSummaryOptions.MeasureUnit = DateTimeMeasureUnit.Second;

            series.LabelsVisibility = DevExpress.Utils.DefaultBoolean.False;
            series.CrosshairEnabled = DefaultBoolean.True;
            series.CrosshairLabelPattern = id + ":{V:N2}  {A:yyyy-MM-dd HH:mm:ss}";
            series.ToolTipEnabled = DefaultBoolean.False;
            series.SeriesPointsSorting = SortingMode.None;
            series.Visible = true;
            series.View = view;
            series.Points.AddRange(series_pt_list);

            //this.chartControl1.Series.Add(series);
        }

        public static string ParseExcel(string fileName, out List<FlowPressChartViewModel> datalist, out DataTable dataTable)
        {
            datalist = new List<FlowPressChartViewModel>();
            dataTable = new DataTable();
            if (!File.Exists(fileName))
                return "文件不存在";
            int line = 0;

            //初始化文件
            NPOI.HSSF.UserModel.HSSFWorkbook theBook = null;
            using (FileStream file = new FileStream(fileName, FileMode.Open, FileAccess.ReadWrite))
            {
                theBook = new NPOI.HSSF.UserModel.HSSFWorkbook(file);
            }

            //检查表格是否符合
            NPOI.SS.UserModel.ISheet sheet1 = theBook.GetSheet("Sheet1");
            if (sheet1 == null)
            {
                sheet1 = theBook.GetSheetAt(0);
                if (sheet1 == null)
                    return ("无Sheet数据");
            }

            //标题行
            int title_line_index = 0;

            var row_title = sheet1.GetRow(title_line_index);
            if (row_title == null)
            {
                return ("第一行第一列不能空");
            }

            //开始读取的行
            int start_line = title_line_index + 1;
            var cell_0 = row_title.GetCell(0);
            if (cell_0 == null)
            {
                return ("无法读取表头文件");
            }

            var totalcell = row_title.Cells.Count;
            for (int i = 0; i < totalcell; i++)
            {
                var row_cell = row_title.GetCell(i);

                if (i > 0)
                {
                    if (row_cell != null)
                    {
                        datalist.Add(new FlowPressChartViewModel()
                        {
                            Name = row_cell.StringCellValue,
                            Datas = new List<TimeChartViewModel>()
                        });
                    }
                    dataTable.Columns.Add(row_cell.StringCellValue, typeof(double));
                }
                else
                {
                    dataTable.Columns.Add(row_cell.StringCellValue, typeof(string));
                }
            }

            NPOI.SS.UserModel.IRow row_temp = null;
            NPOI.SS.UserModel.ICell cell;

            for (line = start_line; line < 10000; line++)
            {
                row_temp = sheet1.GetRow(line);
                if (row_temp == null)
                    break;
                var rowData = new object[totalcell];
                for (int i = 0; i < totalcell; i++)
                {
                    try
                    {
                        if (i > 0)
                        {
                            var cell_temp = row_temp.GetCell(i);
                            double yvalue = cell_temp.NumericCellValue;
                            var timevalue = row_temp.GetCell(0).StringCellValue;
                            datalist[i - 1].Datas.Add(new TimeChartViewModel()
                            {
                                Time = timevalue, //DateTime.FromOADate(timevalue).ToString("YYYY-MM-dd HH:mm:ss"),
                                Y = yvalue,
                            });
                            rowData[i] = yvalue;
                        }
                        else
                        {
                            var timevalue = row_temp.GetCell(0).StringCellValue;
                            rowData[i] = timevalue;//DateTime.FromOADate(timevalue).ToString("YYYY-MM-dd HH:mm:ss");
                        }
                    }
                    catch (Exception ex)
                    {
                        //var a = ex.Message;
                    }
                }

                dataTable.Rows.Add(rowData);
            }

            return "";
        }

        private double Press = 0.6;
        private double Efficiency = 75;
        private SetPressForm dlg = new SetPressForm();

        private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            if (dlg.ShowDialog() == DialogResult.OK)
            {
                Press = dlg.Press;
                Efficiency = dlg.Efficiency;
            }
        }

        private void BtnRefresh_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            if (_datalist.Any())
            {
                WaitFormHelper.ShowWaitForm();
                SetBindingData(_datalist, _datatable);
                WaitFormHelper.HideWaitForm();
            }
        }
    }
}