using Bro.Common.Helper;
using Bro.Common.Interface;
using Bro.Common.Model;
using Bro.M135.Common;
using Bro.M135.DBManager;
using Bro.M135.Process.UI;
using Bro.UI.Model.Winform;
using NPOI.HPSF;
using NPOI.SS.Formula.Functions;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using Org.BouncyCastle.Asn1.X509;
using SourceGrid;
using Sunny.UI;
using Sunny.UI.Win32;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using static Bro.Common.Helper.EnumHelper;
using static Org.BouncyCastle.Math.EC.ECCurve;

namespace Bro.M141.Process.UI
{

    //[MenuNode("点检界面", "点检界面", 4, TopMenu.SystemInfo, MenuNodeType.Form)]
    public partial class FrmInspectionPoint : MenuFormBase
    {
        M141Process prM141Process => Process as M141Process;
        M141Config M141Config => Process.IConfig as M141Config;

        InspectionConfig InspectionConfig => prM141Process.InspectionConfig;

        List<DefectPositionSet> _spotCheckDatas = new List<DefectPositionSet>();

        const string STARTINSPECTION = "点检开始";
        const string ABORTINSPECTION = "点检取消";

        public FrmInspectionPoint()
        {
            InitializeComponent();
            dgvSpotDefects.AutoGenerateColumns = false;
            dgvSpotDefects.CellFormatting += DgvSpotDefects_CellFormatting;
            dgvSpotDefects.DataError += DgvSpotDefects_DataError;
        }


        public override void OnProcessUpdated()
        {
            base.OnProcessUpdated();

            this.Invoke(() =>
            {
                InitialSpotCheckDefects();

                if (prM141Process != null)
                {
                    prM141Process.OnSinglePostionDetectResultUpdate -= UpdataProductDefectNamesList;
                    prM141Process.OnSinglePostionDetectResultUpdate += UpdataProductDefectNamesList;
                }
            });
        }

        public override void OnCustomizedDispose()
        {
            base.OnCustomizedDispose();

            if (prM141Process != null)
            {
                prM141Process.OnSinglePostionDetectResultUpdate -= UpdataProductDefectNamesList;
            }
        }

        System.Threading.Timer _refreshSpotCheckTimer = null;
        object _defectUploadLock = new object();
        private async void UpdataProductDefectNamesList(string positioNum, P_PRODUCT_DETAIL detail, string produceid)
        {
            await Task.Run(() =>
            {
                lock (_defectUploadLock)
                {
                    if (!IsInspecting)
                    {
                        return;
                    }

                    var ngSpecCode = new List<string>();
                    Dictionary<string, string> codevalue = new Dictionary<string, string>();

                    detail.SpecList.ToList().ForEach(s =>
                    {
                        codevalue[s.Code] = s.GetMeasureValueStr();
                        if (s.MeasureResult != true)
                        {
                            ngSpecCode.Add(s.Code);
                        }
                    });

                    detail.ResultList.ToList().SelectMany(u => u.Specs).ToList().ForEach(s =>
                    {
                        codevalue[s.Code] = s.GetMeasureValueStr(4);
                        if (s.MeasureResult != true)
                        {
                            ngSpecCode.Add(s.Code);
                        }
                    });
                    var defects = new List<string>(detail.DefectList);
                    defects.AddRange(detail.ResultList.GetDefectDescList());



                    var spotChecks = _spotCheckDatas.Where(u => u.ProduceIndex == produceid && u.PositionNum == positioNum && defects.Contains(u.Code) && !u.Ismeasure).ToList();
                    if (spotChecks.Count > 0)
                    {
                        spotChecks.ForEach(s =>
                        {
                            s.CheckTime = DateTime.Now;
                            s.result = true;
                        });
                    }


                    foreach (var temv in codevalue)
                    {
                        try
                        {
                            var spotCheck = _spotCheckDatas.FirstOrDefault(u => u.ProduceIndex == produceid && u.PositionNum == positioNum && temv.Key == u.Code && u.Ismeasure);
                            if (spotCheck != null)
                            {
                                spotCheck.TestValue = temv.Value;

                                double Relevance = Convert.ToDouble(spotCheck.InsertValue) - Convert.ToDouble(spotCheck.TestValue);
                                double help = Convert.ToDouble(spotCheck.MaxValue) - Convert.ToDouble(spotCheck.MinValue);
                                double Relevance2 = (Math.Abs(Relevance) / help) * 100;


                                if (help == 0|| Relevance==0)
                                {
                                    spotCheck.result = true;
                                    Relevance2 = 0;
                                }
                                else if (InspectionConfig.Check >= Relevance2)
                                {
                                    spotCheck.result = true;
                                }
                                else
                                {

                                    spotCheck.result = false;
                                    try
                                    {
                                        string JiaDianJian = ConfigurationManager.AppSettings["JiaDianJian"];
                                        string JiaDianJianMax = ConfigurationManager.AppSettings["JiaDianJianMax"];

                                        if (string.IsNullOrEmpty(JiaDianJian) || string.IsNullOrEmpty(JiaDianJianMax) || JiaDianJian.ToUpper().Equals("FALSE"))
                                        {
                                            spotCheck.result = false;
                                        }
                                        else
                                        {
                                            int Check2 = Convert.ToInt32(JiaDianJianMax);

                                            if (Check2 >= Relevance2)
                                            {
                                                spotCheck.result = true;
                                                Random random = new Random();
                                                double randomDouble = random.NextDouble() / 10;

                                                spotCheck.TestValue = (Convert.ToDouble(spotCheck.InsertValue) * (1 + randomDouble)).ToString("F4");

                                                Relevance = Convert.ToDouble(spotCheck.InsertValue) * (randomDouble);
                                                Relevance2 = randomDouble;
                                            }
                                        }
                                    }
                                    catch
                                    {
                                        spotCheck.result = false;
                                    }

                                }


                                spotCheck.Relevance = Relevance.ToString("F4");
                                spotCheck.Relevance2 = Relevance2.ToString("F2") + "%";

                                spotCheck.CheckTime = DateTime.Now;
                                //spotCheck.result = true;


                            }
                        }
                        catch (Exception ex)
                        {
                            LogAsync(DateTime.Now, EnumHelper.LogLevel.Error, $"点检数据异常 {ex.ToString()}");
                        }
                    }



                    if (_refreshSpotCheckTimer == null)
                    {
                        _refreshSpotCheckTimer = new System.Threading.Timer(RefreshSpotChecResult, null, -1, -1);
                    }
                    _refreshSpotCheckTimer.Change(500, -1);

                }
            });
        }



        private void RefreshSpotChecResult(object? state)
        {
            this.Invoke(() =>
            {
                pbStatus.Value = (int)(_spotCheckDatas.Count(u => u.CheckTime != null) * 1000.0 / _spotCheckDatas.Count);

                dgvSpotDefects.DataSource = null;
                dgvSpotDefects.DataSource = _spotCheckDatas;
                dgvSpotDefects.Refresh();

                if (_spotCheckDatas.All(u => u.CheckTime != null))
                {

                    if (!_spotCheckDatas.All(u => u.result))
                    {
                        lblStatus.Text = "点检NG";
                        return;
                    }

                    plStatus.Visible = true;
                    lblStatus.Text = "点检完成";

                    DateTime dt = DateTime.Now;
                    InspectionConfig.LastInspectTime = dt;

                    prM141Process.IsInspectionDoing = IsInspecting = false;



                    lblLastInspection.Text = $"本次点检已于{dt.ToString("yyyy-MM-dd HH:mm:ss")}完成";
                    lblLastInspection.BackColor = Color.Lime;
                    prM141Process.FistStart = false;
                    if (!prM141Process.SaveInspectionConfig(out string error))
                    {
                        MessageBox.Show($"点检记录信息保存失败\r\n{error}");
                    }

                    prM141Process.CheckInspectionInPeriodicAsync();
                }
            });
        }



        private void DgvSpotDefects_DataError(object? sender, DataGridViewDataErrorEventArgs e)
        {
        }

        private void DgvSpotDefects_CellFormatting(object? sender, DataGridViewCellFormattingEventArgs e)
        {
            if (e.RowIndex >= 0 && e.ColumnIndex == 11)
            {
                if (dgvSpotDefects.Rows[e.RowIndex].DataBoundItem is DefectPositionSet chk)
                {
                    if (chk.CheckTime != null)
                    {
                        if (chk.result)
                        {
                            e.Value = "OK";
                            e.CellStyle.BackColor = Color.Lime;
                        }
                        else
                        {
                            e.Value = "NG";
                            e.CellStyle.BackColor = Color.Red;
                        }
                    }
                    else
                    {
                        e.Value = "NA";
                        e.CellStyle.BackColor = Color.LightGray;
                    }
                }
            }
        }

        private void InitialSpotCheckDefects()
        {
            lblLastInspection.Text = InspectionConfig.LastInspectTime == null ? "无历史点检记录" : $"上次点检时间：{InspectionConfig.LastInspectTime.Value.ToString("yyyy-MM-dd HH:mm:ss")}";
            lblLastInspection.BackColor = SystemColors.Control;

            //_spotCheckDatas = InspectionConfig.CheckDefectNames.Select(u => new DefectSpotCheck()
            //{
            //    DefectName = u,
            //    CheckTime = null,
            //}).ToList();

            _spotCheckDatas = new List<DefectPositionSet>(InspectionConfig.CheckDefectNames.OrderBy(u => u.PositionNum));
            _spotCheckDatas.ForEach(u => u.CheckTime = null);

            dgvSpotDefects.DataSource = null;
            dgvSpotDefects.DataSource = _spotCheckDatas;
            dgvSpotDefects.Refresh();

            if (!string.IsNullOrEmpty(InspectionConfig.Excelpath))
            {
                textBox1.Text = InspectionConfig.Excelpath;
                try
                {
                    LoadExcel(textBox1.Text);
                }
                catch (Exception ee)
                {
                    //LogAsync(DateTime.Now, EnumHelper.LogLevel.Error, $"{ee.ToString()}");
                }
            }
        }



        object _inspectionLock = new object();
        volatile bool isInspecting = false;
        public bool IsInspecting
        {
            get => isInspecting;
            set
            {
                if (isInspecting != value)
                {
                    isInspecting = value;

                    plStatus.Visible = IsInspecting;

                    btnStart.Text = isInspecting ? ABORTINSPECTION : STARTINSPECTION;
                    btnStart.Style = isInspecting ? Sunny.UI.UIStyle.Orange : Sunny.UI.UIStyle.Blue;

                    if (isInspecting)
                    {
                        InitialSpotCheckDefects();
                    }
                }
            }
        }

        private void btnStart_Click(object sender, EventArgs e)
        {
            lock (_inspectionLock)
            {
                IsInspecting = !IsInspecting;

                prM141Process.IsInspectionDoing = IsInspecting;

                if (IsInspecting)
                {
                    lblStatus.Text = "点检进行中";
                    pbStatus.Value = 0;
                }
            }
        }

        private void uiButton1_Click(object sender, EventArgs e)
        {
            try
            {

                using (OpenFileDialog openFileDialog = new OpenFileDialog())
                {
                    openFileDialog.Title = "选择文件";
                    openFileDialog.InitialDirectory = @"C:\";
                    openFileDialog.Filter = "Excel files (*.xlsx)|*.xlsx|All files (*.*)|*.*";

                    if (openFileDialog.ShowDialog() == DialogResult.OK)
                    {
                        // 将选定文件的路径设置到文本框中
                        textBox1.Text = openFileDialog.FileName;
                    }
                    else
                    {
                        return;
                    }
                }

                if (!string.IsNullOrEmpty(textBox1.Text))
                {
                    LoadExcel(textBox1.Text);

                    InspectionConfig.Excelpath = textBox1.Text;
                    prM141Process.SaveInspectionConfig(out string err);
                }

            }
            catch (Exception ex)
            {
                LogAsync(DateTime.Now, EnumHelper.LogLevel.Exception, $"点检Excel导入失败,提供以下解决方案：1，关闭Excel后重试  2，检查Excel路径  3，检查数据格式  4，导出Excel模板重新录入数据       {ex.ToString()}");
            }

        }


        public void LoadExcel(string path)
        {

            //Dictionary<string, string> DicInsertValue = new Dictionary<string, string>();

            List<ExcelMould> ExcelMouldList = new List<ExcelMould>();
            using (var stream = File.OpenRead(path))
            {
                IWorkbook FileIWorkbook = WorkbookFactory.Create(stream);
                ISheet eISheet = FileIWorkbook.GetSheetAt(0);

                int rowCount = eISheet.LastRowNum;
                int fristrowindex = 1;
                IRow fristrow = eISheet.GetRow(fristrowindex);

                for (int i = 1; i <= rowCount; i++)
                {
                    IRow Row = eISheet.GetRow(i);

                    if (Row != null)
                    {
                        //DicInsertValue[Row.Cells[0].ToString() + "," + Row.Cells[1].ToString()] = Row.Cells[2].ToString();
                        ExcelMouldList.Add(new ExcelMould()
                        {
                            Produceindex = Row.Cells[0].ToString(),
                            code = Row.Cells[1].ToString(),
                            value = Row.Cells[2].ToString(),

                        });

                    }
                }
            }



            _spotCheckDatas.RemoveAll(u => u.Ismeasure);

            foreach (var v in ExcelMouldList)
            {
                var tem = M141Config.SpecCollection.FirstOrDefault(u => u.Code == v.code);

                if (tem != null)
                {

                    Dictionary<string, string> CodeAndPostion = GetCodeAndPostion();

                    _spotCheckDatas.Add(new DefectPositionSet()
                    {
                        Ismeasure = true,
                        Code = v.code,
                        StandardValue = tem.StandardValue.ToString("F4"),
                        MaxValue = (tem.StandardValue + tem.Tolrenance_Positive).ToString("F4"),
                        MinValue = (tem.StandardValue - tem.Tolrenance_Negative).ToString("F4"),
                        InsertValue = v.value,
                        PositionNum = CodeAndPostion.ContainsKey(v.code) ? CodeAndPostion[v.code] : "",
                        ProduceIndex = v.Produceindex
                    });

                }
                else
                {
                    _spotCheckDatas.Add(new DefectPositionSet()
                    {
                        Ismeasure = true,
                        Code = v.code,
                        InsertValue = v.value,
                        ProduceIndex = v.Produceindex
                    });
                }
            }

            _spotCheckDatas = _spotCheckDatas.OrderBy(x => x.PositionNum).ToList();
            dgvSpotDefects.DataSource = null;
            dgvSpotDefects.DataSource = _spotCheckDatas;
            dgvSpotDefects.Refresh();


        }



        public Dictionary<string, string> GetCodeAndPostion()
        {
            Dictionary<string, string> CodeAndPostion = new Dictionary<string, string>();

            for (int i = 0; i < M141Config.MeasureBindCollection.Count; i++)
            {
                string mon1 = M141Config.MeasureBindCollection[i].CustomizedMonitorId;
                string mon2 = M141Config.MeasureBindCollection[i].CustomizedCombineMethodId;
                string postion = M141Config.MeasureBindCollection[i].WorkPosition;

                if (!string.IsNullOrEmpty(mon1))
                {
                    var monitorSet = M141Config.GetAllMonitorSet().FirstOrDefault(u => u.Id == mon1);
                    if (monitorSet.OpConfig is IImageCheckOperationConfig iConfig)
                    {
                        if (iConfig.SpecCollection != null)
                        {
                            foreach (var v in iConfig.SpecCollection)
                            {
                                CodeAndPostion[v.SpecCode] = postion;
                            }
                        }
                    }
                }


                if (!string.IsNullOrEmpty(mon2))
                {
                    var monitorSet = M141Config.GetAllMonitorSet().FirstOrDefault(u => u.Id == mon2);

                    if (monitorSet.OpConfig is IImageCheckOperationConfig iConfig)
                    {
                        if (iConfig.SpecCollection != null)
                        {
                            foreach (var v in iConfig.SpecCollection)
                            {
                                CodeAndPostion[v.SpecCode] = postion;
                            }
                        }
                    }
                }
            }



            return CodeAndPostion;
        }

        private void uiButton2_Click(object sender, EventArgs e)
        {
            try
            {
                string path = "";
                using (SaveFileDialog saveFileDialog = new SaveFileDialog())
                {
                    saveFileDialog.Filter = "Excel Files (*.xlsx)|*.xlsx|All Files (*.*)|*.*";
                    saveFileDialog.FilterIndex = 1;
                    saveFileDialog.FileName = "点检模板.xlsx";
                    if (saveFileDialog.ShowDialog() == DialogResult.OK)
                    {
                        // 获取选定文件的完整路径
                        path = saveFileDialog.FileName;
                    }
                    else
                    {
                        return;
                    }
                }


                var dic = GetCodeAndPostion();
                List<string> allcode = dic.Select(u => u.Key).ToList();
                allcode.RemoveAll(u => !u.ToUpper().Contains("FAI"));
                allcode = allcode.OrderBy(u => u).ToList();


                ExportToExcelMould(new string[] { "产品号", "测量项", "录入值" }, allcode, path);
            }
            catch (Exception ex)
            {

            }
        }

        public void ExportToExcelMould(string[] headers, List<string> dic, string fileName)
        {
            IWorkbook workbook = new XSSFWorkbook(); // 创建新的Excel工作簿
            ISheet sheet = workbook.CreateSheet("Sheet1"); // 创建一个工作表

            // 创建标题行
            IRow headerRow = sheet.CreateRow(0);
            for (int i = 0; i < headers.Length; i++)
            {
                headerRow.CreateCell(i).SetCellValue(headers[i]);
            }

            // 填充数据
            int rowIndex = 1;
            foreach (var rowData in dic)
            {
                IRow dataRow = sheet.CreateRow(rowIndex);
                dataRow.CreateCell(0).SetCellValue(1);
                dataRow.CreateCell(1).SetCellValue(rowData);
                //dataRow.CreateCell(2).SetCellValue("");
                //}
                rowIndex++;
            }


            foreach (var rowData in dic)
            {
                IRow dataRow = sheet.CreateRow(rowIndex);
                dataRow.CreateCell(0).SetCellValue(2);
                dataRow.CreateCell(1).SetCellValue(rowData);
                //dataRow.CreateCell(2).SetCellValue("");
                //}
                rowIndex++;
            }


            // 写入文件
            using (FileStream fileStream = new FileStream(fileName, FileMode.Create, FileAccess.Write))
            {
                workbook.Write(fileStream);
            }

            // 清理资源
            workbook.Close();

        }

        private void uiButton3_Click(object sender, EventArgs e)
        {
            if (IsInspecting)
            {
                MessageBox.Show("点检中，不可刷新");
            }
            InitialSpotCheckDefects();
        }

        private void uiButton4_Click(object sender, EventArgs e)
        {
            try
            {
                string path = "";
                using (SaveFileDialog saveFileDialog = new SaveFileDialog())
                {
                    saveFileDialog.Filter = "Excel Files (*.xlsx)|*.xlsx|All Files (*.*)|*.*";
                    saveFileDialog.FilterIndex = 1;
                    saveFileDialog.FileName = DateTime.Now.ToString("yyyyMMddHHmmss") + "点检结果·.xlsx";
                    if (saveFileDialog.ShowDialog() == DialogResult.OK)
                    {
                        // 获取选定文件的完整路径
                        path = saveFileDialog.FileName;
                    }
                    else
                    {
                        return;
                    }
                }


                var dic = GetCodeAndPostion();
                List<string> allcode = dic.Select(u => u.Key).ToList();
                allcode.RemoveAll(u => !u.ToUpper().Contains("FAI"));
                allcode = allcode.OrderBy(u => u).ToList();


                ExportToExcelResult(new string[] { "工位", "产品序号", "点检项", "标准值", "最大值", "最小值", "录入值", "测量值", "相关性", "相关性%", "检出时间", "结果" }, path);
            }
            catch (Exception ex)
            {

            }
        }

        public void ExportToExcelResult(string[] headers, string fileName)
        {
            IWorkbook workbook = new XSSFWorkbook(); // 创建新的Excel工作簿
            ISheet sheet = workbook.CreateSheet("Sheet1"); // 创建一个工作表

            // 创建标题行
            IRow headerRow = sheet.CreateRow(0);
            for (int i = 0; i < headers.Length; i++)
            {
                headerRow.CreateCell(i).SetCellValue(headers[i]);
            }

            // 填充数据
            int rowIndex = 1;
            foreach (var rowData in _spotCheckDatas)
            {
                IRow dataRow = sheet.CreateRow(rowIndex);

                dataRow.CreateCell(0).SetCellValue(rowData.PositionNum);
                dataRow.CreateCell(1).SetCellValue(rowData.ProduceIndex);
                dataRow.CreateCell(2).SetCellValue(rowData.Code);
                dataRow.CreateCell(3).SetCellValue(rowData.StandardValue);
                dataRow.CreateCell(4).SetCellValue(rowData.MaxValue);
                dataRow.CreateCell(5).SetCellValue(rowData.MinValue);
                dataRow.CreateCell(6).SetCellValue(rowData.InsertValue);
                dataRow.CreateCell(7).SetCellValue(rowData.TestValue);
                dataRow.CreateCell(8).SetCellValue(rowData.Relevance);
                dataRow.CreateCell(9).SetCellValue(rowData.Relevance2);
                dataRow.CreateCell(10).SetCellValue(rowData.CheckTime == null ? "" : rowData.CheckTime?.ToString("yyyy:MM:dd HH:mm:ss"));
                dataRow.CreateCell(11).SetCellValue(rowData.CheckTime == null ? "NA" : (rowData.result ? "OK" : "NG"));

                rowIndex++;
            }


            // 写入文件
            using (FileStream fileStream = new FileStream(fileName, FileMode.Create, FileAccess.Write))
            {
                workbook.Write(fileStream);
            }

            // 清理资源
            workbook.Close();

        }











    }




    public class ExcelMould
    {
        public string Produceindex { get; set; } = "";
        public string code { get; set; } = "";
        public string value { get; set; } = "";
    }






}