JG_TpsLabStudio_LTS/tps/TpsLabStudio/models/HarmonicSuppression.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using Tps_LQ_Transmitter.com;

namespace Tps_LQ_Transmitter.models
{
    class HarmonicSupperssion : BaseModel
    {
        public HarmonicSupperssion()
        {
            TemplateName = "谐波抑制测试";
        }
        /// <summary>
        /// 谐波抑制测试
        /// </summary>
        public override bool Run(TestNode parameters)
        {
            double y_value, x_value;
            Random random = new Random();
            //获取仪器
            var SA = this.tps.GetDevice("频谱仪");
            //TransmitterSerialPort SerialClient = new TransmitterSerialPort();
            OutData Data = new OutData();
            DataType HarmonicSuppressionPrint = new DataType();

            if (SA == null)
            {
                ShowMessage(MsgType.Error, string.Format("仪器不齐全，{0}/{1}无法运行", parameters.Channel, parameters.Name));
                return false;
            }
            OpenExcel("谐波抑制", out Spire.Xls.Workbook workbook, out Spire.Xls.Worksheet sheet);
            if (sheet == null)
            {
                ShowMessage(MsgType.Error, "找不到" + tps.TestProject + "模板.xlsx");
                return false;
            }

            sheet.Range["L1"].Value2 = tps.Serial;
            ConfigParameter PowerPara = new ConfigParameter();
          //  MatchComPara CfigComParas = new MatchComPara();

            //CfigComParas = LoadComWorkBook();

            //if (CfigComParas == null)
            //{
            //    return false;
            //}

            //byte FourthByte = 0x00;
            //string ComPort = CfigComParas.GetComPort("1");
            //byte ThridByte = Convert.ToByte(CfigComParas.GetThirdByte("1"), 16);
          
           // PowerPara.OutLoss = parameters.Parameters.GetParameter<double>("输出损耗");
            PowerPara.SPAN = parameters.Parameters.GetParameter<string>("扫描带宽（SPAN）");
            PowerPara.REF = parameters.Parameters.GetParameter<string>("参考电平（REF）");
            PowerPara.SmallSignalREF = parameters.Parameters.GetParameter<string>("小信号参考电平（REF）");
            PowerPara.RBW = parameters.Parameters.GetParameter<string>("分辨率带宽（RBW）");
            PowerPara.VBW = parameters.Parameters.GetParameter<string>("视频带宽（VBW）");
            PowerPara.HarmonicTime = parameters.Parameters.GetParameterToArray<int>("谐波次数");
            //PowerPara.ControlDelay = parameters.Parameters.GetParameter<int>("控制延时");
            PowerPara.HarmonicSuppressionLower = parameters.Parameters.GetParameter<double>("谐波抑制下限");
            PowerPara.HarmonicSuppressionUpper = parameters.Parameters.GetParameter<double>("谐波抑制上限");
            if ( (PowerPara.SPAN == null) || (PowerPara.REF == null) ||(PowerPara.SmallSignalREF==null)|| (PowerPara.RBW == null) || (PowerPara.VBW == null) || (PowerPara.HarmonicTime == null)
                ||(PowerPara.HarmonicSuppressionLower==0))
            {
                ShowMessage(MsgType.Error, string.Format("配置文件中频率参数为空，{0}/{1}无法运行", parameters.Channel, parameters.Name));
                return false;
            }
            //if (PowerPara.ControlDelay == 0)
            //{
            //    PowerPara.ControlDelay = 10;
            //}
            //SerialClient.SerialOpen(ComPort);
            if (true)//需具备仪器
            {
                SA.Write("仪器复位"); SA.Query("OPC");
                SA.Write("SPAN", PowerPara.SPAN); SA.Query("OPC");
                SA.Write("RBW", PowerPara.RBW); SA.Query("OPC");
                SA.Write("VBW", PowerPara.VBW); SA.Query("OPC");
              //  SA.Write("SingleOrCont", "0"); SA.Query("OPC");
            }

            double CenterFreq;
            int harmonic_num;
            double Power, Freq;
            Data.HarmonicSuppression = new double[parameters.PointTotal, PowerPara.HarmonicTime.Length];
           
            //for (int point = 0; ; point++)
            {

                //CenterFreq = PowerPara.StartFrequency + PowerPara.StepFrequency * point;
              
                if(true)//需具备仪器
                {
                    //控制
                   // SerialClient.DUT_Transmitter_Ctrol(PowerPara.ComPort, Convert.ToByte(point + 1));
                    //Thread.Sleep(PowerPara.ControlDelay);//单位ms

                    SA.Write("REF", PowerPara.REF); SA.Query("OPC");
                    SA.Write("CENTER", parameters.CenterFreq.ToString()); SA.Query("OPC");
                    SA.Write("SingleOrCont", "0"); SA.Query("OPC");
                    PsaPeakValue_Tracedata(SA, out y_value, out x_value, true);
                    Freq=x_value;
                    Power = y_value;

                }


                double[] HarmonicTimeVal = new double[PowerPara.HarmonicTime.Length];
                double HarmonicMinTimeVal = 0;
                HarmonicSuppressionPrint.Lower = PowerPara.HarmonicSuppressionLower;
                HarmonicSuppressionPrint.Upper  = PowerPara.HarmonicSuppressionUpper;
                if (true)//需具备仪器
                {
                    SA.Write("REF", PowerPara.SmallSignalREF); SA.Query("OPC");

                    for (harmonic_num = 0; harmonic_num < PowerPara.HarmonicTime.Length; harmonic_num++)
                    {
                        SA.Write("CENTER", (Freq/1000000 * PowerPara.HarmonicTime[harmonic_num]).ToString()); SA.Query("OPC");//N次谐波
                       // SA.Write("SingleOrCont", "0"); SA.Query("OPC");
                        SA.Write("单次扫描"); SA.Query("OPC");
                        PsaPeakValue_Tracedata(SA, out y_value, out x_value, false);
                        Data.HarmonicSuppression[parameters.PointIndex, harmonic_num] = Math.Round(Power - y_value, 2);
                        HarmonicSuppressionPrint.Test_name = parameters.Channel + "-"+ PowerPara.HarmonicTime[harmonic_num].ToString()+ "次-谐波抑制测试-" + parameters.CenterFreq.ToString() + "MHz";
                        HarmonicTimeVal[harmonic_num] = Data.HarmonicSuppression[parameters.PointIndex, harmonic_num];
                        if ((HarmonicTimeVal[harmonic_num] >= HarmonicSuppressionPrint.Lower) && (HarmonicTimeVal[harmonic_num] <= HarmonicSuppressionPrint.Upper))
                        {
                            HarmonicSuppressionPrint.Result = "是";
                        }
                        else
                        {
                            HarmonicSuppressionPrint.Result = "否";
                        }
                        tps.TestTableAddCell(HarmonicSuppressionPrint.Test_name, HarmonicSuppressionPrint.Lower.ToString(), HarmonicSuppressionPrint.Upper.ToString(), HarmonicTimeVal[harmonic_num].ToString(), HarmonicSuppressionPrint.Result);
                        if (parameters.Channel == "通道1")
                        {

                            WriteExcelData(sheet, parameters.PointIndex, 1+2*(harmonic_num+1), HarmonicSuppressionPrint.Test_name, HarmonicSuppressionPrint.Lower.ToString(), HarmonicSuppressionPrint.Upper.ToString(), HarmonicSuppressionPrint.TestVal.ToString(), HarmonicSuppressionPrint.Result);
                            // tps.SetTestTableCellValue(point, 15, HarmonicSuppressionPrint.Result, HarmonicSuppressionPrint.TestVal);
                        }
                        else if (parameters.Channel == "通道2")
                        {

                            WriteExcelData(sheet, parameters.PointIndex, 2 + 2 * (harmonic_num + 1), HarmonicSuppressionPrint.Test_name, HarmonicSuppressionPrint.Lower.ToString(), HarmonicSuppressionPrint.Upper.ToString(), HarmonicSuppressionPrint.TestVal.ToString(), HarmonicSuppressionPrint.Result);
                            // tps.SetTestTableCellValue(point + 15, 15, HarmonicSuppressionPrint.Result, HarmonicSuppressionPrint.TestVal);
                        }
                    }

                    if (PowerPara.HarmonicTime.Length > 1)//计算几次谐波中的最小值
                    {
                        HarmonicMinTimeVal = HarmonicTimeVal.Min();
                    }
                    else
                    {
                        HarmonicMinTimeVal = HarmonicTimeVal[0];
                    }

                }

                HarmonicSuppressionPrint.Test_name = parameters.Channel + "-谐波抑制测试-" + parameters.CenterFreq.ToString() + "MHz";
               
                HarmonicSuppressionPrint.TestVal = HarmonicMinTimeVal;
              //  HarmonicSuppressionPrint.TestVal = random.Next(4000, 12000) / 100.0;//随机数
                if ((HarmonicTimeVal[harmonic_num] >= HarmonicSuppressionPrint.Lower) && (HarmonicTimeVal[harmonic_num] <= HarmonicSuppressionPrint.Upper))
                {
                    HarmonicSuppressionPrint.Result = "是";
                }
                else
                {
                    HarmonicSuppressionPrint.Result = "否";
                }
                tps.TestTableAddCell(HarmonicSuppressionPrint.Test_name, HarmonicSuppressionPrint.Lower.ToString(), HarmonicSuppressionPrint.Upper.ToString(), HarmonicSuppressionPrint.TestVal.ToString(), HarmonicSuppressionPrint.Result);
                if (parameters.Channel == "通道1")
                {
                    
                    WriteExcelData(sheet, parameters.PointIndex, 1, HarmonicSuppressionPrint.Test_name, HarmonicSuppressionPrint.Lower.ToString(), HarmonicSuppressionPrint.Upper.ToString(), HarmonicSuppressionPrint.TestVal.ToString(), HarmonicSuppressionPrint.Result);
                   // tps.SetTestTableCellValue(point, 15, HarmonicSuppressionPrint.Result, HarmonicSuppressionPrint.TestVal);
                }
                else if (parameters.Channel == "通道2")
                {
                    
                    WriteExcelData(sheet, parameters.PointIndex, 2, HarmonicSuppressionPrint.Test_name, HarmonicSuppressionPrint.Lower.ToString(), HarmonicSuppressionPrint.Upper.ToString(), HarmonicSuppressionPrint.TestVal.ToString(), HarmonicSuppressionPrint.Result);
                   // tps.SetTestTableCellValue(point + 15, 15, HarmonicSuppressionPrint.Result, HarmonicSuppressionPrint.TestVal);
                }

            }

            SaveExcel(workbook);
            return true;
        }

        public void PsaPeakValue_Tracedata(AppLibs.Devices.IVISA psa, out double Y_Maxvalue, out double X_Maxvalue, bool IsReturnX = false)
        {
            System.Threading.Thread.Sleep(20);
            X_Maxvalue = 0;
            Y_Maxvalue = 0;

            psa.Write("单次扫描");

            psa.Query("OPC");
            string tracedata = psa.Query("读曲线");
            string[] tracedatas = tracedata.Split(',');
            double[] tracedata_double = new double[tracedatas.Length-1];
            for (int i = 0; i < tracedatas.Length-1; i++)
            {
                tracedata_double[i] = double.Parse(tracedatas[i]);
            }
            Y_Maxvalue = tracedata_double.Max();
            if (IsReturnX)
            {
                int x = Array.IndexOf(tracedata_double, Y_Maxvalue);
                double startfreq = double.Parse(psa.Query("读起始频率"));
                double stopfreq = double.Parse(psa.Query("读截止频率"));
                double counts = double.Parse(psa.Query("测试点数读取"));
                X_Maxvalue = startfreq + (stopfreq - startfreq) * x / (counts - 2);
            }
            Y_Maxvalue = Math.Round(Y_Maxvalue, 3);
        }
        public class ConfigParameter
        {
            /// <summary>
            /// 串口
            /// </summary>
            public string ComPort { set; get; }
            /// <summary>
            /// 输出损耗
            /// </summary>
            public double OutLoss { set; get; }
            /// <summary>
            /// 产品测试的起始频率
            /// </summary>
            public double StartFrequency { set; get; }
            /// <summary>
            /// 产品测试的频率步进
            /// </summary>
            public double StepFrequency { set; get; }
            /// <summary>
            /// 产品测试的频点数量
            /// </summary>
            public int FrequencyNumber { set; get; }
            /// <summary>
            /// 产品的工作频带上限(终止频率)
            /// 功能：用于判断从起始频率按一定的步进测试是否超出产品工作频段上限
            /// </summary>
            public double StopFrequency { set; get; }
            /// <summary>
            ///设置频谱仪的SPAN
            /// </summary>
            public string SPAN { set; get; }
            /// <summary>
            /// 设置参考电平
            /// </summary>
            public string REF { set; get; }
            /// <summary>
            /// 设置小信号参考电平
            /// </summary>
            public string SmallSignalREF { set; get; }
            /// <summary>
            /// 设置RBW
            /// </summary>
            public string RBW { set; get; }
            /// <summary>
            /// 设置VBW
            /// </summary>
            public string VBW { set; get; }
            /// <summary>
            /// 谐波次数
            /// </summary>
            public int[] HarmonicTime { set; get; }
            /// <summary>
            /// 控制延时
            /// </summary>
            public int ControlDelay { set; get; }
            /// <summary>
            /// 谐波抑制下限
            /// </summary>
            public double HarmonicSuppressionLower { set; get; }
            /// <summary>
            /// 谐波抑制上限
            /// </summary>
            public double HarmonicSuppressionUpper{ set; get; }
        }
        public class OutData
        {
            /// <summary>
            //谐波抑制
            /// </summary>
            public double[,] HarmonicSuppression { set; get; }
           
            

        }
        //public class DataType
        //{

        //    /// <summary>
        //    /// 测试名称
        //    /// </summary>
        //    public string Test_name { set; get; }
        //    /// <summary>
        //    /// 指标下限
        //    /// </summary>
        //    public double Lower { set; get; }
        //    /// <summary>
        //    /// 指标上限
        //    /// </summary>
        //    public double Upper { set; get; }
        //    /// <summary>
        //    /// 测试值
        //    /// </summary>
        //    public double TestVal { set; get; }
        //    /// <summary>
        //    /// 判断结果
        //    /// </summary>
        //    public bool Result { set; get; }


        //}
    }
    

}