using DataMirrorTools;
using DTTest;
using HZ.Common;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

/// <summary>
/// 
/// </summary>
namespace DataMirrorToolsPage
{
    /// <summary>
    /// 
    /// </summary>
    public partial class P_SignalViewer : ModelManagement
    {
        int currenIndex = 0;
        /// <summary>
        /// Tag处理
        /// </summary>
       // public static TagID_Add_Handler tagID_Add_Handler = null;
        /// <summary>
        /// 当前的TagID
        /// </summary>
        string currTagID = "";
        /// <summary>
        /// 当前的TagName
        /// </summary>
        string currTagName = "";
        /// <summary>
        /// 初始化函数
        /// </summary>
        public P_SignalViewer()
        {
            InitializeComponent();
            ControlDoubleBuffered(dgv_SignalViewer);
        }


        /// <summary>
        /// 创建信号点
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_Signal_Create_Click(object sender, EventArgs e)
        {
            SqlOperation.SqlSignalTree.CreateSignal("", PP.ProjectCode,Type_Device.Signal);
            Refresh_SignalViewer();

            if (this.dgv_SignalViewer.Rows.Count > 0)
            {
                this.dgv_SignalViewer.Rows[this.dgv_SignalViewer.Rows.Count-1].Selected = true;
            }
            // ModelBasic.ErrDef.iErrHandler.ErrInfoTransmit("信号添加完成！");
        }


        private void Refresh_SignalViewer()
        {
            var selectSignalName = txt_SelectSignalName.Text.Trim();
            var dt_Signal = SqlOperation.SqlSignalTree.SelectSignal_UseSignalName(selectSignalName, false, PP.ProjectCode);

            currSignalCount = dt_Signal.Rows.Count;
            label_SignalCount.Text = $"{currSignalCount} 个信号";

            dgv_SignalViewer.DataSource = dt_Signal;
            Rendering_dgv_Handler();
        }



        /// <summary>
        /// 退出事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void P_SignalViewer_FormClosing(object sender, FormClosingEventArgs e)
        {
            //   Program.simplifyPdps.UpdateCheckedState_TSM_SignalViewer( 1 == 2 );

            //if (!SimplifyPdps.isCanClose)
            //{
            //    e.Cancel = true;//拦截，不响应操作
            //}
        }

        /// <summary>
        /// 删除信号按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_Signal_Delete_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("确认删除选中信号【" + currTagName + "】？", "删除确认?", MessageBoxButtons.YesNo) == DialogResult.Yes)
            { }
            else
            {
                // ModelBasic.ErrDef.iErrHandler.ErrInfoTransmit("已取消删除信号操作！");
                return;
            }

            SqlOperation.SqlSignalTree.DeleteSignal(currGridSequenceNo, currTagID, PP.ProjectCode);
            Refresh_SignalViewer();
        }

        /// <summary>
        /// 编辑完成事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dgv_SignalViewer_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            var checkedThis = Convert.ToBoolean(GetObjV(e, "选择"));
            var tagID = GetObjV(e, "DeviceCode").ToString();
            var memory = Convert.ToBoolean(GetObjV(e, "内存"));
            var type = GetObjV(e, "类型").ToString();
            var robotSignalName = GetObjV(e, "机器人信号名称").ToString();
            var robotAddress = GetObjV(e, "机器人信号地址").ToString();
            var address = GetObjV(e, "地址").ToString();
            var iecFormat = GetObjV(e, "IEC格式").ToString();
            var isEnable = Convert.ToBoolean(GetObjV(e, "启用"));
            var sName = GetObjV(e, "信号名称").ToString();
            var explain = GetObjV(e, "注释").ToString();
            var isMonitorStr = GetObjV(e, "监控").ToString();
            var isMonitor = true;
            switch (isMonitorStr)
            {
                case "1":
                case "True":
                case "TRUE":
                case "true":
                    isMonitor = true;
                    break;
                default:
                    isMonitor = false;
                    break;
            }

            SqlOperation.SqlSignalTree.UpdateSignal(tagID, checkedThis, memory, type, robotSignalName, robotAddress, address,
                   isEnable, sName, explain, isMonitor, PP.ProjectCode);

        }


        private object GetObjV(DataGridViewCellEventArgs e, string Name)
        {
            return dgv_SignalViewer.Rows[e.RowIndex].Cells[Name].Value;
        }

        /// <summary>
        /// 点击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dgv_SignalViewer_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex > -1)
            {
                try
                {
                    currTagID = GetObjV(e, "DeviceCode").ToString();
                    currTagName = GetObjV(e, "信号名称").ToString();
                    var region = GetObjV(e, "Region").ToString();
                    currGridSequenceNo = Convert.ToInt32(GetObjV(e, "序号").ToString());

                    var ResourcesCode = GetObjV(e, "资源").ToString();

                    RefreshCurrSequenceNo(currGridSequenceNo);

                    //if (tagID_Add_Handler != null)
                    //{
                    //    tagID_Add_Handler.ExecCurrSelectSignal(currTagID, currTagName, ResourcesCode);
                    //}


                    if (GlobalEventInterface.E_DeviceSignalSimGantt_TransmitTagToDeviceSignalSim != null)
                    {
                        GlobalEventInterface.E_DeviceSignalSimGantt_TransmitTagToDeviceSignalSim(currTagID, currTagName);
                    }
                    if (GlobalEventInterface.E_SignalLabelForm_TransmitSelect != null)
                    {
                        GlobalEventInterface.E_SignalLabelForm_TransmitSelect(Cmd_Frame.SignalWrite, currTagID, currTagName);
                    }
                    if (GlobalEventInterface.E_LogicalBlock_AddSignal != null)
                    {
                        GlobalEventInterface.E_LogicalBlock_AddSignal(new LogicalBlock.LB_Device_Signal()
                        {
                            SignalCode = currTagID,
                            SignalName = currTagName,
                            SignalRegion = region,
                        });
                    }


                }
                catch (Exception err)
                {
                    LogNet.LogisTrac.WriteLog(typeof(P_SignalViewer), err);

                    Console.WriteLine(err);
                }

            }
        }


        /// <summary>
        /// 信号导入按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_Signal_Import_Excel_Click(object sender, EventArgs e)
        {

            MessageBox.Show("暂时禁用！！——2021.11.18");
            return;


            if (MessageBox.Show($"确认导入信号表？", "导入确认", MessageBoxButtons.YesNo) == DialogResult.Yes)
            {
            }
            else
            {
                //MessageBox.Show("您已取消导入信号表操作！");
                return;
            }


            var importOpenFileDialog = new OpenFileDialog();
            var importDialogResult = importOpenFileDialog.ShowDialog();
            var localFilePath = importOpenFileDialog.FileName;

            if (importDialogResult == DialogResult.OK)
            {
                var t1 = DateTime.Now.ToFileTimeUtc();
                DataTable dt_Signal = OExcel.ExeclHelper_Model.ExcelToDataTable(localFilePath, "MES_基本变量原始数据", true);

                var t2 = DateTime.Now.ToFileTimeUtc();
                var D1 = ((t2 - t1) / 10000).ToString();
                ImportSignalToSql(dt_Signal);

                var t3 = DateTime.Now.ToFileTimeUtc();
                var D2 = ((t3 - t2) / 10000).ToString();
                MessageBox.Show("信号表文件导入成功！\n"
                              + "读取耗时：" + D1 + " ms\n"
                              + "转换存储耗时：" + D2 + " ms\n");

                Refresh_SignalViewer();
            }
            //else
            //{
            //    MessageBox.Show("您已取消了信号导入操作！");
            //}


        }

        public void ImportSignalToSql(DataTable dt)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                //信号名        是内存   数据类型   机器人信号名  地址    是连接PLC    外部连接        资源        解释     项目代码
                //[signalName],[Memory],[Type],[RobotSignalName],[Address],[启用], **************  ,[Resources],[Explain],[ProjectCode]

                var signalName = dt.Rows[i]["TagID"].ToString();
                var tagID = Convert.ToInt32(signalName);
                if (tagID < 41010001)
                {
                    var memory = false;
                    var type = dt.Rows[i]["变量类型"].ToString();
                    var robotSignalName = "无";
                    var address = dt.Rows[i]["变量地址"].ToString() + dt.Rows[i]["变量其它"].ToString();
                    var iecFormat = dt.Rows[i]["DbName"].ToString();
                    var isEnable = true;
                    var resources = "Excel导入";
                    var explain = dt.Rows[i]["测量项目"].ToString();

                    SqlOperation.SqlSignalTree.AddOrUpdateSignal(signalName, memory, type, robotSignalName, address, iecFormat,
                     isEnable, resources, explain, PP.ProjectCode);
                }

            }
        }

        /// <summary>
        /// 信号导出按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_Signal_Export_Excel_Click(object sender, EventArgs e)
        {
            var exportOpenFileDialog = new SaveFileDialog();
            //设置文件类型
            exportOpenFileDialog.Filter = "Microsoft Excel（*.xls）|*.xls";
            //设置默认文件类型显示顺序
            exportOpenFileDialog.FilterIndex = 1;
            //保存对话框是否记忆上次打开的目录
            exportOpenFileDialog.RestoreDirectory = true;
            var exportDialogResult = exportOpenFileDialog.ShowDialog();

            //点了保存按钮进入
            if (exportDialogResult == DialogResult.OK)
            {
                var localFilePath = exportOpenFileDialog.FileName;//获得文件路径
                var fileNameExt = localFilePath.Substring(localFilePath.LastIndexOf("\\") + 1); //获取文件名，不带路径
                var fileExtension = localFilePath.Substring(localFilePath.LastIndexOf(".") + 1); //获取文件扩展名
                var fileExtensionToLower = fileExtension.ToLower();
                var dt_SignalViewer = SqlOperation.SqlSignalTree.SelectSignal_UseSignalName("", false, PP.ProjectCode);
                var col = dt_SignalViewer.Columns;
                if (col.Contains("Checked"))
                    col.Remove("Checked");
                if (col.Contains("Memory"))
                    col.Remove("Memory");
                if (col.Contains("RobotSignalName"))
                    col.Remove("RobotSignalName");
                if (col.Contains("IsEnable"))
                    col.Remove("IsEnable");

                var success = OExcel.ExeclHelper_Model.DataTableToExcel(dt_SignalViewer, "SignalViewer", localFilePath);
                if (success == false)
                {
                    // ModelBasic.ErrDef.iErrHandler.ErrInfoTransmit("项目数据导出Excel【错误】");
                    return;
                }

            }
            //else
            //{
            //    MessageBox.Show("您已取消了导出数据操作！");
            //}


        }


        private void btn_Signal_Import_S7_Click(object sender, EventArgs e)
        {

        }

        #region 显示缓存2021.3.31

        private void ControlDoubleBuffered(Control c)
        {
            //设置双缓冲，解决datagridview显示数据缓慢
            Type type = c.GetType();
            System.Reflection.PropertyInfo pi = type.GetProperty("DoubleBuffered",
            System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic);
            pi.SetValue(c, true, null);
        }



        #endregion


        private void btn_MoveUp_Click(object sender, EventArgs e)
        {
            if (operationing)
            {
                operationing = false;

                if (currGridSequenceNo >= 2)
                {
                    this.dgv_SignalViewer.Rows[currGridSequenceNo - 1].Selected = false;

                    SqlOperation.SqlSignalTree.MoveUpSignal(currGridSequenceNo, PP.ProjectCode);
                    Refresh_SignalViewer();
                    currGridSequenceNo--;
                    RefreshCurrSequenceNo(currGridSequenceNo);

                    this.dgv_SignalViewer.Rows[currGridSequenceNo - 1].Selected = true;
                    dgv_SignalViewer_CellClick(dgv_SignalViewer, new DataGridViewCellEventArgs(0, currGridSequenceNo - 1));
                    //dgv_SignalViewer_CellClick(dgv_SignalViewer, new DataGridViewCellEventArgs(dgv_SignalViewer.SelectedCells[0].ColumnIndex, dgv_SignalViewer.SelectedCells[currGridSequenceNo - 1].RowIndex));

                }
                else
                {
                    // ModelBasic.ErrDef.iErrHandler.ErrInfoTransmit("已经是第一个工序，不能再移动了！");
                }

                operationing = true;

            }
        }

        private void btn_MoveDown_Click(object sender, EventArgs e)
        {
            if (operationing)
            {
                operationing = false;

                if (currGridSequenceNo < currSignalCount)
                {
                    this.dgv_SignalViewer.Rows[currGridSequenceNo - 1].Selected = false;

                    SqlOperation.SqlSignalTree.MoveDownSignal(currGridSequenceNo, PP.ProjectCode);
                    Refresh_SignalViewer();
                    currGridSequenceNo++;
                    RefreshCurrSequenceNo(currGridSequenceNo);

                    this.dgv_SignalViewer.Rows[currGridSequenceNo - 1].Selected = true;
                    dgv_SignalViewer_CellClick(dgv_SignalViewer, new DataGridViewCellEventArgs(0, currGridSequenceNo - 1));
                    //dgv_SignalViewer_CellClick(dgv_SignalViewer, new DataGridViewCellEventArgs(dgv_SignalViewer.SelectedCells[0].ColumnIndex, dgv_SignalViewer.SelectedCells[currGridSequenceNo - 1].RowIndex));

                }
                else
                {
                    // ModelBasic.ErrDef.iErrHandler.ErrInfoTransmit("已经是最后一个工序，不能再移动了！");
                }

                operationing = true;

            }
        }
        /// <summary>
        /// 操作中
        /// </summary>
        bool operationing = true;
        /// <summary>
        /// 当前选中的工序排序
        /// </summary>
        public static int currGridSequenceNo = -1;
        /// <summary>
        /// 信号数量
        /// </summary>
        int currSignalCount = 0;

        private void RefreshCurrSequenceNo(int sequenceNo)
        {
            txt_CurrSequenceNo.Text = sequenceNo.ToString();
        }


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


        DelayAction delayAction1 = new DelayAction();
        private void txt_SelectSignalName_TextChanged(object sender, EventArgs e)
        {
            delayAction1.Delay(750, dgv_SignalViewer, SelectTask);
        }

        private void SelectTask()
        {
            Refresh_SignalViewer();
        }

        public void Rendering_dgv_Handler()
        {
            var tagIDList = SqlOperation.SqlTag_Handler.SelectDistinctTagID_Handler( PP.ProjectCode);
            Rendering_dgv(tagIDList, Color.GreenYellow);
        }

        private void Rendering_dgv(List<String> tagIDList, Color c)
        {
            if (dgv_SignalViewer.CurrentRow == null) return;
            currenIndex = dgv_SignalViewer.CurrentRow.Index;
            DataGridView dgv = this.dgv_SignalViewer;

            if (!dgv.Columns.Contains("DeviceCode"))
            {
                return;
            }

            for (int k = 0; k < dgv.RowCount; k++)
            {
                for (int cl = 0; cl < dgv.ColumnCount; cl++)
                    dgv.Invoke(new Action(delegate ()
                    {
                        dgv.Rows[k].Cells[cl].Style.BackColor = Color.White;
                    }));

            }
            foreach (string thisTagID in tagIDList)
            {
                for (int j = 0; j < dgv.RowCount; j++)
                {
                    if (dgv.Rows[j].Cells["DeviceCode"].Value.ToString().Trim() == thisTagID)
                    {
                        for (int cl = 0; cl < dgv.ColumnCount; cl++)
                            dgv.Invoke(new Action(delegate ()
                            {
                                dgv.Rows[j].Cells[cl].Style.BackColor = c;
                            }));

                    }

                }
            }
            if(this.dgv_SignalViewer.Rows.Count> currenIndex)
            {
                this.dgv_SignalViewer.Rows[currenIndex].Selected = true;
            }
        }

        #region 调试信号查询2021.10.8.LLX

        /// <summary>
        /// 行为查找TagID
        /// 2021.5.11
        /// </summary>
        /// <param name="actCode"></param>
        public void ActSelect_TagID_Handler(string actCode)
        {
            var tagIDList = SqlOperation.SqlTag_Handler.SelectTagID_Handler(actCode, Type_TagIDHandler.Craft, PP.ProjectCode);
            Rendering_dgv(tagIDList, Color.Red);
        }
        public void ModelSelect_SignalTagID(string modelCode)
        {
            var tagIDList = SqlOperation.SqlTag_Handler.ModelSelect_SignalTagID(modelCode, PP.ProjectCode);
            Rendering_dgv(tagIDList, Color.Red);
        }
        /// <summary>
        /// 行为对应的查找TagID
        /// 2021.5.11
        /// </summary>
        /// <param name="tagID"></param>
        public void TagIDSelect_TagID_Handler(string tagID)
        {
            var tagIDList = new List<String>() { tagID };
            Rendering_dgv(tagIDList, Color.Red);
        }








        #endregion
        /// <summary>
        /// 信号处理编辑器
        /// 2021.10.8.LLX
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_SignalHandlerEditor_Click(object sender, EventArgs e)
        {
            //if (tagID_Add_Handler != null)
            //{
            //    tagID_Add_Handler.Close();
            //    tagID_Add_Handler = null;
            //}

            //tagID_Add_Handler = new TagID_Add_Handler();
            //tagID_Add_Handler.Show(this);
        }

        private void P_SignalViewer_Load(object sender, EventArgs e)
        {
            Refresh_SignalViewer();

            GlobalEventInterface.E_SignalViewer_ActSelect_TagID_Handler -= GlobalEventInterface_E_SignalViewer_ActSelect_TagID_Handler;
            GlobalEventInterface.E_SignalViewer_ActSelect_TagID_Handler += GlobalEventInterface_E_SignalViewer_ActSelect_TagID_Handler;

            GlobalEventInterface.E_SignalViewer_TagIDSelect_TagID_Handler -= GlobalEventInterface_E_SignalViewer_TagIDSelect_TagID_Handler;
            GlobalEventInterface.E_SignalViewer_TagIDSelect_TagID_Handler += GlobalEventInterface_E_SignalViewer_TagIDSelect_TagID_Handler;

            GlobalEventInterface.E_SignalViewer_Rendering_dgv_Handler -= GlobalEventInterface_E_SignalViewer_Rendering_dgv_Handler;
            GlobalEventInterface.E_SignalViewer_Rendering_dgv_Handler += GlobalEventInterface_E_SignalViewer_Rendering_dgv_Handler;
        }

        private void GlobalEventInterface_E_SignalViewer_Rendering_dgv_Handler()
        {
            Rendering_dgv_Handler();
        }

        private void GlobalEventInterface_E_SignalViewer_ActSelect_TagID_Handler(string actCode)
        {
            ActSelect_TagID_Handler(actCode);
        }

        private void GlobalEventInterface_E_SignalViewer_TagIDSelect_TagID_Handler(string tagID)
        {
            TagIDSelect_TagID_Handler(tagID);
        }

        private List<String> GetDgvSelectedRows(DataGridView dgv)
        {
            var list = new List<String>();
            foreach (DataGridViewRow row in dgv.SelectedRows)
                list.Insert(0, row.Cells["DeviceCode"].Value.ToString());
            return list;
        }
        private Dictionary<String, Int32> GetDgvSelectedRows_TagID_SequenceNo(DataGridView dgv)
        {
            var dc = new Dictionary<String, Int32>();
            foreach (DataGridViewRow row in dgv.SelectedRows)
                dc.Add(row.Cells["DeviceCode"].Value.ToString(), Convert.ToInt32(row.Cells["序号"].Value.ToString()));
            return dc;
        }

        private void TSM_UpdateSignalConnect_Click(object sender, EventArgs e)
        {
            var connectSelect = new ConnectSelect();
            var result = connectSelect.ShowDialog();
            if (result == DialogResult.OK)
            {
                var connectCode = connectSelect.connCode;
                if (connectCode.Length > 1)
                {
                    foreach (string tagID in GetDgvSelectedRows(dgv_SignalViewer))
                    {
                        SqlOperation.SqlSignalTree.UpdateSimSignal_Connect(tagID, connectCode, PP.ProjectCode);
                    }
                }

            }
            Refresh_SignalViewer();

        }

        private void TSM_DeleteSignalConnect_Click(object sender, EventArgs e)
        {
            var connectCode = "";
            foreach (string tagID in GetDgvSelectedRows(dgv_SignalViewer))
            {
                SqlOperation.SqlSignalTree.UpdateSimSignal_Connect(tagID, connectCode, PP.ProjectCode);
            }
            Refresh_SignalViewer();
        }

        private void TSM_SignalViewer_Add_Click(object sender, EventArgs e)
        {
            foreach (string tagID in GetDgvSelectedRows(dgv_SignalViewer))
            {
                SqlOperation.SqlSignalTree.UpdateSignalChecked(tagID, true, PP.ProjectCode);
            }
            Refresh_SignalViewer();
        }

        private void TSM_SignalViewer_Remove_Click(object sender, EventArgs e)
        {
            foreach (string tagID in GetDgvSelectedRows(dgv_SignalViewer))
            {
                SqlOperation.SqlSignalTree.UpdateSignalChecked(tagID, false, PP.ProjectCode);
            }
            Refresh_SignalViewer();
        }

        private void TSM_Delete_SelectRaws_Click(object sender, EventArgs e)
        {
            // MessageBox.Show("存在排序问题，暂时还未开发！");

            foreach (KeyValuePair<String, Int32> TagID_SequenceNo in GetDgvSelectedRows_TagID_SequenceNo(dgv_SignalViewer))
            {
                var tagID = TagID_SequenceNo.Key;
                var sequenceNo = TagID_SequenceNo.Value;
                SqlOperation.SqlSignalTree.DeleteSignal(sequenceNo, tagID, PP.ProjectCode);
            }
            Refresh_SignalViewer();


        }

        private void btn_btn_Refresh_Click(object sender, EventArgs e)
        {
            Refresh_SignalViewer();
        }

        private void TSM_UpdateSignalRegion_Click(object sender, EventArgs e)
        {
            var signalRegion = new SignalRegion();
            var result = signalRegion.ShowDialog();
            if (result == DialogResult.OK)
            {
                var region = signalRegion.region;
                foreach (string tagID in GetDgvSelectedRows(dgv_SignalViewer))
                {
                    SqlOperation.SqlSignalTree.UpdateSignalRegion(tagID, region, PP.ProjectCode);
                }
                Refresh_SignalViewer();
            }


        }



        private void tsmi_INT16_Click(object sender, EventArgs e)
        {
            UpdateSignalType(Type_Signal_Raw.INT16);
        }

        private void tsmi_INT32_Click(object sender, EventArgs e)
        {
            UpdateSignalType(Type_Signal_Raw.INT32);
        }

        private void tsmi_FLOAT_Click(object sender, EventArgs e)
        {
            UpdateSignalType(Type_Signal_Raw.FLOAT);
        }

        private void tsmi_UINT64_Click(object sender, EventArgs e)
        {
            UpdateSignalType(Type_Signal_Raw.UINT64);
        }

        private void tsmi_STRING_Click(object sender, EventArgs e)
        {
            UpdateSignalType(Type_Signal_Raw.STRING);
        }

        private void tsmi_BOOL_Click(object sender, EventArgs e)
        {
            UpdateSignalType(Type_Signal_Raw.BOOL);
        }

        private void tsmi_BYTE_Click(object sender, EventArgs e)
        {
            UpdateSignalType(Type_Signal_Raw.BYTE);
        }

        private void tsmi_UINT16_Click(object sender, EventArgs e)
        {
            UpdateSignalType(Type_Signal_Raw.UINT16);
        }

        private void tsmi_DOUBLE_Click(object sender, EventArgs e)
        {
            UpdateSignalType(Type_Signal_Raw.DOUBLE);
        }

        private void UpdateSignalType(Type_Signal_Raw signalType)
        {
            foreach (string tagID in GetDgvSelectedRows(dgv_SignalViewer))
            {
                SqlOperation.SqlSignalTree.UpdateSignal_DataType(tagID, signalType.ToString(), PP.ProjectCode);
            }
            Refresh_SignalViewer();
        }

        private void dgv_SignalViewer_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex > -1)
            {
                var col = dgv_SignalViewer.Columns[e.ColumnIndex];
                if (col is DataGridViewButtonColumn)
                {
                    var DeviceCode = dgv_SignalViewer.Rows[e.RowIndex].Cells["DeviceCode"].Value.ToString();
                    CMS_SignalType.Show(Cursor.Position);

                }

            }
        }

        private void btn_OutScadaTable_Click(object sender, EventArgs e)
        {
            var exportOpenFileDialog = new SaveFileDialog();
            //设置文件类型
            exportOpenFileDialog.Filter = "Microsoft Excel（*.xls）|*.xls";
            //设置默认文件类型显示顺序
            exportOpenFileDialog.FilterIndex = 1;
            //保存对话框是否记忆上次打开的目录
            exportOpenFileDialog.RestoreDirectory = true;

            var exportDialogResult = exportOpenFileDialog.ShowDialog();

            //点了保存按钮进入
            if (exportDialogResult == DialogResult.OK)
            {
                var localFilePath = exportOpenFileDialog.FileName;//获得文件路径
                var fileNameExt = localFilePath.Substring(localFilePath.LastIndexOf("\\") + 1); //获取文件名，不带路径
                var fileExtension = localFilePath.Substring(localFilePath.LastIndexOf(".") + 1); //获取文件扩展名

                var fileExtensionToLower = fileExtension.ToLower();

                GetSignalTable(out DataTable dt_Signal, out DataTable dt_Device);
                dt_Signal.TableName = "MES_基本变量原始数据";
                dt_Device.TableName = "设备类型对应表";

                DataSet outDataSet = new DataSet();
                outDataSet.Tables.Add(dt_Signal);
                outDataSet.Tables.Add(dt_Device);

                var success = OExcel.ExeclHelper_Model.DataSetToExcel(outDataSet, localFilePath);
                if (success == false)
                {
                    // ModelBasic.ErrDef.iErrHandler.ErrInfoTransmit("信号表数据导出Excel【错误】!!");
                    return;
                }

            }
            //else
            //{
            //    MessageBox.Show("您已取消了导出数据操作！");
            //}


        }

        private void P_SignalViewer_FormClosed(object sender, FormClosedEventArgs e)
        {
            GlobalEventInterface.E_SignalViewer_ActSelect_TagID_Handler -= GlobalEventInterface_E_SignalViewer_ActSelect_TagID_Handler;
            GlobalEventInterface.E_SignalViewer_TagIDSelect_TagID_Handler -= GlobalEventInterface_E_SignalViewer_TagIDSelect_TagID_Handler;
            GlobalEventInterface.E_SignalViewer_Rendering_dgv_Handler -= GlobalEventInterface_E_SignalViewer_Rendering_dgv_Handler;
        }

        private void TSM_UpdateResources_Click(object sender, EventArgs e)
        {
            var updateResources = new UpdateResources();
            updateResources.Show(this);

            new TaskFactory().StartNew(delegate ()
            {
                while (updateResources.IsOpen)
                {
                    System.Threading.Thread.Sleep(100);
                }
                foreach (string tagID in GetDgvSelectedRows(dgv_SignalViewer))
                {
                    SqlOperation.SqlSignalTree.UpdateSignalResources(tagID, PP.ModelCode, PP.ProjectCode);
                }
                Refresh_SignalViewer();
            });
        }

        private void TSM_UpdateSignalDataType_Click(object sender, EventArgs e)
        {
            CMS_SignalType.Show(Cursor.Position);
        }

        private void btn_SignalRobot_Create_Click(object sender, EventArgs e)
        {
            SqlOperation.SqlSignalTree.CreateSignal("", PP.ProjectCode, Type_Device.SignalRobot);
            Refresh_SignalViewer();

            if (this.dgv_SignalViewer.Rows.Count > 0)
            {
                this.dgv_SignalViewer.Rows[this.dgv_SignalViewer.Rows.Count - 1].Selected = true;
            }
            // ModelBasic.ErrDef.iErrHandler.ErrInfoTransmit("信号添加完成！");
        }
    }
}