using DevExpress.XtraCharts;
using DevExpress.XtraEditors;
using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using System.Data;
using System.IO;
using Yw;
using Yw.WinFrmUI;

namespace IBox.WinFrmUI
{
    public partial class IBoxFormMonitor : DocumentPage
    {

        private string startCode = "[&start&]";
        private string endCode = "[&end&]";
        private string paramCode = "[&param&]";
        private string getbaseCode = "getbase";
        private string getrealrecordCode = "getrealrecord";
        private string gethistoryrecordCode = "gethistoryrecord";
        private string getalarmbydayCode = "getalarmbyday";
        private string getbysignalidofdayrangeCode = "getbysignalidofdayrange";

        //Stopwatch sw = new Stopwatch();
        //string swstr=string.Empty;
        private List<MonitorValueAlarmRecord> monitorValueAlarmRecords = new List<MonitorValueAlarmRecord>();

        private List<DataGridMonitorViewModel> dataGridMonitorViewModels = new List<DataGridMonitorViewModel>();
        private List<PumpRunStatusViewModel> pumpRunStatusModels = new List<PumpRunStatusViewModel>();
        private List<PumpEnergyViewModel> pumpEnergyViewModels = new List<PumpEnergyViewModel>();

        public IBoxFormMonitor()
        {
            this.PageTitle.Caption = "实时监测";
            InitializeComponent();
            this.gridView1.SetNormalView();

            this.dateEdit1.Text = DateTime.Now.ToString("yyyy-MM-dd");
            this.dateEdit2.Text = DateTime.Now.ToString("yyyy-MM-dd");

            _points.View.Color = Color.Red;
            _points.CrosshairEnabled = DevExpress.Utils.DefaultBoolean.False;
            _points.ShowInLegend = false;
            _line.ShowInLegend = true;


            // _line.LegendTextPattern = "";
        }

        //private void WebMessageReceived(object sender, CoreWebView2WebMessageReceivedEventArgs e)
        //{
        //    var j = JsonHelper.Json2Object<FixationReceivedViewModel>(e.WebMessageAsJson);
        //    var oper = new
        //    {
        //        oper = "setToken",
        //        dataValue = ""
        //    };
        //    switch (j.Oper)
        //    {
        //        case "loadCompleted":
        //            break;
        //    }
        //}

        private void TestData()
        {
            #region 测试数据

            this.pumpRunStatusModels = new List<PumpRunStatusViewModel>();
            this.pumpRunStatusModels.Add(new PumpRunStatusViewModel()
            {
                ID = 1,
                Name = "1#机组",
                BootTimes = 50,
                ContinutRunTime = 1000,
                DateTime = DateTime.Now,
                RunStatus = 1,
                TotalRunTime = 1000,
            });
            this.pumpRunStatusModels.Add(new PumpRunStatusViewModel()
            {
                ID = 2,
                Name = "2#机组",
                BootTimes = 100,
                ContinutRunTime = 1300,
                DateTime = DateTime.Now,
                RunStatus = 0,
                TotalRunTime = 1800,
            });
            this.pumpRunStatusModels.Add(new PumpRunStatusViewModel()
            {
                ID = 3,
                Name = "3#机组",
                BootTimes = 400,
                ContinutRunTime = 1500,
                DateTime = DateTime.Now,
                RunStatus = 1,
                TotalRunTime = 2000,
            });
            this.pumpRunStatusModels.Add(new PumpRunStatusViewModel()
            {
                ID = 4,
                Name = "4#机组",
                BootTimes = 100,
                ContinutRunTime = 800,
                DateTime = DateTime.Now,
                RunStatus = 0,
                TotalRunTime = 1300,
            });
            this.Invoke(new Action(() =>
            {
                this.pumpRunStatusViewModelBindingSource.DataSource = this.pumpRunStatusModels;
            }));

            pumpEnergyViewModels = new List<PumpEnergyViewModel>();
            pumpEnergyViewModels.Add(new PumpEnergyViewModel()
            {
                Day = "2024-4-14",
                Electricity = 4172,
                Supply = 50510,
                EnergyOfWater = (decimal)82.04
            });

            pumpEnergyViewModels.Add(new PumpEnergyViewModel()
            {
                Day = "2024-4-15",
                Electricity = 3308,
                Supply = 32530,
                EnergyOfWater = (decimal)80.14
            });

            pumpEnergyViewModels.Add(new PumpEnergyViewModel()
            {
                Day = "2024-4-16",
                Electricity = 3378,
                Supply = 42630,
                EnergyOfWater = (decimal)73.34
            });

            pumpEnergyViewModels.Add(new PumpEnergyViewModel()
            {
                Day = "2024-4-17",
                Electricity = 4178,
                Supply = 51530,
                EnergyOfWater = (decimal)81.34
            });

            this.Invoke(new Action(() =>
            {
                this.pumpEnergyViewModelBindingSource.DataSource = pumpEnergyViewModels;
            }));

            #endregion 测试数据
        }

        private void EboxForm_Load(object sender, EventArgs e)
        {
            //BluetoothHelper.GetInstance().SMR -= null;
            //BluetoothHelper.GetInstance().SMR += new BluetoothHelper.ShowMessReturn(GetReceive);
            //BluetoothHelper.GetInstance().ListenerData();
            Thread.Sleep(500);
            SendText(startCode + getbaseCode + paramCode + endCode);
            _diagram.EnableAxisXScrolling = true;
            _diagram.EnableAxisYScrolling = true;
            _diagram.EnableAxisXZooming = true;
            _diagram.EnableAxisYZooming = true;
            //SetTimer();
            
        }

        public void GetReceive(string msg)
        {
            if (!this.IsHandleCreated || this.IsDisposed || string.IsNullOrEmpty(msg)) return;
            if (msg.StartsWith("error:") && msg.Contains("目标主机坏了"))
            {
                MessageBoxHelper.ShowError("m 蓝牙设备连接失败，请重试!"); return;
            }
            if (!string.IsNullOrEmpty(msg) && msg.Contains(startCode))
            {
                var order = msg.Replace(endCode, "").Replace(startCode, "").Trim();
                SetOrder(order);
            }
            else MessageBoxHelper.ShowError("m 蓝牙设备连接失败!");
        }

        private void SetOrder(string order)
        {
            var smsg = order.Split(new string[] { paramCode }, StringSplitOptions.RemoveEmptyEntries);
            if (smsg.Length < 2)
            {
                _diagram.DefaultPane.Visibility = ChartElementVisibility.Hidden;
                return;
            }
            _diagram.DefaultPane.Visibility = ChartElementVisibility.Visible;

            switch (smsg[0].Trim())
            {
                case "getbase":
                    var getbaselist = JsonHelper.Json2Object<List<StationMonitorListGroupMobileDto>>(smsg[1].Trim());
                    BindGrid(getbaselist);
                    WaitFormHelper.HideWaitForm();
                    break;

                case "gethistoryrecord":
                    var b = smsg[1].Trim();
                    var gethistoryrecordlist = new List<MonitorRecord>();

                    if (!string.IsNullOrEmpty(b))
                    {
                        var c = b.Split('|');
                        foreach (var item in c)
                        {
                            var m = new MonitorRecord().FromString(item);
                            gethistoryrecordlist.Add(m);
                        }
                    }
                    //SetChartData(gethistoryrecordlist);
                    break;

                case "getalarmbyday":
                    //var getalarmbydaylist = JsonHelper.Json2Object<List<MonitorValueAlarmRecord>>(smsg[1].Trim());
                    //monitorValueAlarmRecords = getalarmbydaylist;
                    //this.bindingSource1.DataSource = dataGridMonitorViewModels;
                    var l = smsg[1].Trim();
                    SetAlarmByDay(l);
                    //this.gridView2.RefreshData();
                    break;

                case "getbysignalidofdayrange":
                    var getbysignalidofdayrangelist = JsonHelper.Json2Object<List<MonitorValueAlarmRecord>>(smsg[1].Trim());
                    break;

                case "getrealrecord":
                    var getrealrecordlist = JsonHelper.Json2Object<List<MonitorRealRecord>>(smsg[1].Trim());
                    SetRealRecord(getrealrecordlist);
                    break;
            }
        }

        public void SetAlarmByDay(string l, bool isBlue = true)
        {
            var getalarmbydaylist = new List<MonitorValueAlarmRecord>();

            if (!string.IsNullOrEmpty(l))
            {
                var c = l.Split('|');
                foreach (var item in c)
                {
                    var ml = new MonitorValueAlarmRecord().FromString(item);
                    getalarmbydaylist.Add(ml);
                }
                monitorValueAlarmRecords = getalarmbydaylist;
            }
            if (isBlue)
            {
                this.Invoke(new Action(() =>
                {
                    this.monitorValueAlarmRecordBindingSource.DataSource = monitorValueAlarmRecords;
                }));
            }
            else
            {
                this.monitorValueAlarmRecordBindingSource.DataSource = monitorValueAlarmRecords;
            }
        }

        public void SetRealRecord(List<MonitorRealRecord> getrealrecordlist, bool isBlue = true)
        {
            foreach (var item in dataGridMonitorViewModels)
            {
                var mf = getrealrecordlist.FirstOrDefault(bc => bc.SignalID == item.SignalID);
                if (mf != null)
                {
                    item.DataValue = mf.DataValue;
                    item.DataTime = mf.DataTime.ToString("yyyy-MM-dd HH:mm:ss");
                    //item.DataStatus =mf.DataStatus!=null && mf.DataStatus.Contains("2") ? eDataStatus.Warn : eDataStatus.Normal;
                }
            }
            if (isBlue)
            {
                this.Invoke(new Action(() =>
                {
                    this.bindingSource1.DataSource = dataGridMonitorViewModels;
                    this.gridView1.RefreshData();
                }));
            }
            else
            {
                this.bindingSource1.DataSource = dataGridMonitorViewModels;
                this.gridView1.RefreshData();
            }
        }
        private List<DataGridMonitorViewModel> dataList = null;

        public void BindGrid(List<StationMonitorListGroupMobileDto> list, bool isBlue = true)
        {
            dataList = new List<DataGridMonitorViewModel>();
            foreach (var item in list)
            {
                foreach (var ml in item.MonitorList)
                {
                    dataList.Add(new DataGridMonitorViewModel()
                    {
                        DataTime = !ml.DataTime.HasValue ? "-" : ml.DataTime?.ToString("yyyy-MM-dd HH:mm:ss"),
                        DataValue = string.IsNullOrEmpty(ml.DataValue) ? "-" : ml.DataValue,
                        GroupID = item.ID,
                        GroupName = item.Name,
                        MonitorName = ml.Name,
                        SignalID = ml.SignalID,
                        UnitName = ml.UnitName,
                        DataStatus = ml.DataStatus,
                    });
                }
            }
            if (isBlue)
            {
                this.Invoke(new Action(() =>
                {
                    dataGridMonitorViewModels = dataList;
                    this.bindingSource1.DataSource = dataGridMonitorViewModels;
                }));
            }
            else
            {

                dataGridMonitorViewModels = dataList;
                this.bindingSource1.DataSource = dataGridMonitorViewModels;
                this.gridView1.RefreshData();

            }
            //var am = new GetAlarmByDayModel() { Day = DateTime.Now };
            //SendText(startCode + getalarmbydayCode + paramCode + JsonHelper.Object2Json(am) + endCode);
            //WaitFrmHelper.HideWaitForm();
        }

        private void gridView1_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
        {
            currModel = this.gridView1.GetFocusedRow() as DataGridMonitorViewModel;
        }

        private void simpleButton1_Click(object sender, EventArgs e)
        {
            if (currModel == null)
            {
                MessageBoxHelper.ShowWarning("请先选中监测数据!");
                return;
            }
            GetHistoryData();
            //WaitFrmHelper.ShowWaitForm();
        }

        private void simpleButton2_Click(object sender, EventArgs e)
        {
            this.dateEdit1.Text = this.dateEdit2.Text = DateTime.Parse(this.dateEdit1.Text).AddDays(-1).ToString("yyyy-MM-dd");
            GetHistoryData();
        }

        private void simpleButton3_Click(object sender, EventArgs e)
        {
            this.dateEdit1.Text = this.dateEdit2.Text = DateTime.Parse(this.dateEdit1.Text).AddDays(1).ToString("yyyy-MM-dd");

            GetHistoryData();
        }

        private void simpleButton4_Click(object sender, EventArgs e)
        {
            this.dateEdit1.Text = DateTime.Now.AddDays(-3).ToString("yyyy-MM-dd");
            this.dateEdit2.Text = DateTime.Now.ToString("yyyy-MM-dd");
            GetHistoryData();
        }

        private Series _line
        {
            get
            {
                var s = this.chartControl1.GetSeriesByName("SeriesDataValue");
                return s;
            }
        }

        private Series _points
        {
            get
            {
                var s = this.chartControl1.GetSeriesByName("SeriesAlarm");
                return s;
            }
        }

        private XYDiagram _diagram
        { get { return this.chartControl1.Diagram as XYDiagram; } }

        List<MonitorRecord> _realList = null;
        public void SetChartData(List<MonitorRecord> list, bool isBlue)
        {
            _realList = list;
            if (isBlue)
            {
                this.Invoke(new Action(() =>
                {
                    this.chartControl1.BeginInit();

                    var maxY = list.Max(x => x.DataValue);
                    var minY = list.Min(x => x.DataValue);

                    _line.BindToData(list, "DataTime", "DataValue");

                    var alarmList = list.Where(d => d.DataStatus != null && d.DataStatus.Contains("2")).ToList();
                    _points.BindToData(alarmList, "DataTime", "DataValue");

                    _diagram.AxisY.VisualRange.SetMinMaxValues(minY, maxY);
                    _diagram.AxisY.WholeRange.SetMinMaxValues(minY, maxY);
                    this.chartControl1.EndInit();
                }));
            }
            else
            {
                this.chartControl1.BeginInit();

                var maxY = list.Max(x => string.IsNullOrEmpty(x.DataValue) ? 0 : double.Parse(x.DataValue));
                var minY = list.Min(x => string.IsNullOrEmpty(x.DataValue) ? 0 : double.Parse(x.DataValue));

                _line.BindToData(list, "DataTime", "DataValue");

                var alarmList = list.Where(d => d.DataStatus != null && d.DataStatus.Contains("2")).ToList();
                _points.BindToData(alarmList, "DataTime", "DataValue");

                _diagram.AxisY.VisualRange.SetMinMaxValues(minY, maxY);
                _diagram.AxisY.WholeRange.SetMinMaxValues(minY, maxY);
                this.chartControl1.EndInit();
            }
        }

        private void gridView1_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e)
        {
            currModel = this.gridView1.GetFocusedRow() as DataGridMonitorViewModel;
        }

        private DataGridMonitorViewModel currModel = null;

        private void gridView1_DoubleClick(object sender, EventArgs e)
        {
            //WaitFrmHelper.ShowWaitForm();
            var r = this.gridView1.GetFocusedRow() as DataGridMonitorViewModel;
            currModel = r;
            //sw.Restart();
            GetHistoryData();
        }

        private void GetHistoryData()
        {
            var m = new MonitorHistoryQuery()
            {
                SignalID = currModel.SignalID,
                StartTime = dateEdit1.Text,//.Equals(DateTime.Now.ToString("yyyy-MM-dd")) ? DateTime.Now.AddMinutes(-20).ToString("yyyy-MM-dd HH:mm:ss") : dateEdit1.Text,
                EndTime = dateEdit2.Text//.Equals(DateTime.Now.ToString("yyyy-MM-dd")) ? DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") : dateEdit2.Text,
            };
            SendText(startCode + gethistoryrecordCode + paramCode + JsonHelper.Object2Json(m) + endCode);
        }

        private void GetAlarmRange()
        {
            var m = new GetBySignalIDOfDayRangeModel()
            {
                SignalID = currModel.SignalID,
                StartDay = DateTime.Parse(dateEdit1.Text),
                EndDay = DateTime.Parse(dateEdit1.Text),
            };

            SendText(startCode + getbysignalidofdayrangeCode + paramCode + JsonHelper.Object2Json(m) + endCode);
        }

        private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
            SetTimer();
        }

        private void SetTimer()
        {
            if (dataList == null)
            {
                return;
            }
            timer1.Interval = 5000;
            timer1.Enabled = true;
            timer1.Tick += new EventHandler(GetRealData);
        }

        private void GetRealData(object sender, EventArgs e)
        {
            SendText(startCode + getrealrecordCode + paramCode + endCode);
        }

        private void comboBox1_SelectedValueChanged(object sender, EventArgs e)
        {
            SetTimer();
        }

        private void gridView1_CustomDrawCell(object sender, DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventArgs e)
        {
            if (e.Column.FieldName.Equals("DataValue"))
            {
                var b = gridView1.GetRow(e.RowHandle) as DataGridMonitorViewModel;
                if (b.DataStatus == eDataStatus.Warn)
                    e.Appearance.ForeColor = Color.Red;
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            BluetoothHelper.GetInstance().Close();
        }

        private void tabbedControlGroup1_SelectedPageChanged(object sender, DevExpress.XtraLayout.LayoutTabPageChangedEventArgs e)
        {
            //MessageBox.Show(tabbedControlGroup1.SelectedTabPage.Tag.ToString());
        }

        private void gridControl2_Click(object sender, EventArgs e)
        {
        }

        public event EventHandler<string> SendData;
        private void SendText(string content)
        {
            //BluetoothHelper.GetInstance().SendData(content);
            SendData?.Invoke(null, content);
        }

        private void simpleButton5_Click(object sender, EventArgs e)
        {
            ExportXLS();
        }

        public void ExportXLS()
        {
            try
            {
                if (_realList == null || _realList.Count == 0)
                {
                    XtraMessageBox.Show("没有可导出的数据!");
                    return;
                }

                var dlg = new SaveFileDialog();
                dlg.Filter = "EXCEL 文件(*.xls)|*.xls";
                if (dlg.ShowDialog() != DialogResult.OK)
                    return;

                HSSFWorkbook theBook = new HSSFWorkbook();
                var theSheet1 = theBook.CreateSheet("Sheet1");

                IRow rowTile = theSheet1.CreateRow(0);
                rowTile.CreateCell(0).SetCellValue("时间");
                rowTile.CreateCell(1).SetCellValue(currModel.MonitorName + "(" + currModel.UnitName + ")");


                for (int rowIndex = 1; rowIndex <= _realList.Count; rowIndex++)
                {
                    int col = 0;
                    IRow row = theSheet1.CreateRow(rowIndex);

                    row.CreateCell(col).SetCellValue(_realList[rowIndex - 1].DataTime.ToString("yyyy/MM/dd HH:mm:00"));
                    col++;
                    row.CreateCell(col).SetCellValue(_realList[rowIndex - 1].DataValue);
                    col++;
                }

                //强制Excel在打开时重新计算所有公式
                theSheet1.ForceFormulaRecalculation = true;
                using (FileStream fs = File.OpenWrite(dlg.FileName))
                {
                    theBook.Write(fs);
                }
                XtraMessageBox.Show("导出成功");

            }
            catch (Exception ex)
            {
                XtraMessageBox.Show(ex.ToString());
            }
        }
    }
}