123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819 |
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.IO;
- using System.Threading;
- using Tps_LQ_Transmitter.com;
- using System.Diagnostics;
- namespace Tps_LQ_Transmitter.models
- {
- /// <summary>
- /// 常温检查测试
- /// </summary>
- class NormalTemperatureTest : BaseModel
- {
- public NormalTemperatureTest()
- {
- TemplateName = "常温检查测试";
- }
- public override bool Run(TestNode parameters, List<TestNode> nodes)
- {
- // DateTime currentTime1 = new DateTime();
- // Random random = new Random();
-
- // //获取仪器
- // var SA = this.tps.GetDevice("频谱仪");
- // var DC = this.tps.GetDevice("程控电源");
- // /*
- // if (DC == null || 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;
- // }
-
- // ConfigParameter PowerPara = new ConfigParameter();
- // PowerPara.IntervalTime = parameters.Parameters.GetParameter<int>("相对时间");//min
- // PowerPara.TestTime = parameters.Parameters.GetParameter<int>("测试次数");//min
- // int IntervalTime = (int)(PowerPara.IntervalTime * 60);//将min转换成s
-
- // int time=0;
- // Stopwatch TimesCounter = new Stopwatch();
-
- // while ( time < PowerPara.TestTime)
- // {
- // currentTime1 = DateTime.Now;
- // TimesCounter.Restart();
-
- // //tps.SetTestTableCellValue(time, 3, true, currentTime1.Hour.ToString()+":"+ currentTime1.Minute.ToString());//测试时间
- // //tps.SetTestTableCellValue(time + PowerPara.TestTime, 3, true, currentTime1.Hour.ToString() + ":" + currentTime1.Minute.ToString());//测试时间
- // tps.TestTableAddCell("绝对时间","/", "/", currentTime1.Hour.ToString() + ":" + currentTime1.Minute.ToString(), "/");
- // WriteExcelData(sheet, 1 + time * 10, 1,"绝对时间", "/", "/", currentTime1.Hour.ToString() + ":" + currentTime1.Minute.ToString(), "/");
-
- // MainTest(parameters,time,workbook,sheet);
- // if (time == 3)
- // {
- // IntervalTime = IntervalTime * 2;
- // }
- // while (TimesCounter.Elapsed.TotalSeconds <= IntervalTime && time!= PowerPara.TestTime-1)
- // {
- // Thread.Sleep(100);
- // if (IsRuning == false)
- // {
- // return false;
- // }
- // }
- // TimesCounter.Stop();
- // time = time + 1;
- // }
- // SaveExcel(workbook);
- // return true;
- //}
- //public bool MainTest(TestNode parameters,int time, Spire.Xls.Workbook workbook, Spire.Xls.Worksheet sheet)
- //{
-
- // Random random = new Random();
- // DataType VoltDataPrint = new DataType();
- // DataType CurrentDataPrint = new DataType();
- // DataType PowerPrint = new DataType();//功率(dBm)
- // DataType FreqPrint = new DataType();//实测频率
- // DataType FreqAccuracyPrint = new DataType();//频率稳定度
- // DataType PowerSumPrint = new DataType();//两路功率总和(w)
- // DataType PowerFlatnessPrint = new DataType();//两路功率不平度(dB)
- // DataType ModulationIndexPrint = new DataType();
- // DataType MaxFreqOffsetPrint = new DataType();
- // DataType DBMaxFreqOffsetPrint = new DataType();
- // DataType SpuriousSuppressionPrint = new DataType();
- // DataType HarmonicSuppressionPrint = new DataType();
- // //获取仪器
- // var SA = this.tps.GetDevice("频谱仪");
- // var DC = this.tps.GetDevice("程控电源");
- // TransmitterSerialPort SerialClient = new TransmitterSerialPort();
- // TestPara Data = new TestPara();
- // /*
- // if (DC == null || SA == null)
- // {
- // ShowMessage(MsgType.Error, string.Format("仪器不齐全,{0}/{1}无法运行", parameters.Channel, parameters.Name));
- // return false;
- // }
- // */
- // MatchModulaPara CfigModuParas = new MatchModulaPara();
- // CfigModuParas = LoadModulationWorkBook();
- // ConfigParameter PowerPara = new ConfigParameter();
- // PowerPara.ComPort = parameters.Parameters.GetParameter<string>("串口");
- // PowerPara.OutLoss = parameters.Parameters.GetParameter<double>("输出损耗");
- // PowerPara.ChannelPara = parameters.Parameters.GetParameter<int>("通道数");
- // PowerPara.StartFrequency = parameters.Parameters.GetParameter<double>("起始频率");
- // PowerPara.StepFrequency = parameters.Parameters.GetParameter<double>("频率步进");
- // PowerPara.FrequencyNumber = parameters.Parameters.GetParameter<int>("频点数量");
- // PowerPara.StopFrequency = 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.VoltLower = parameters.Parameters.GetParameter<double>("电压下限");
- // PowerPara.VoltUpper = parameters.Parameters.GetParameter<double>("电压上限");
- // PowerPara.CurrentLower = parameters.Parameters.GetParameter<double>("电流下限");
- // PowerPara.CurrentUpper = parameters.Parameters.GetParameter<double>("电流上限");
- // PowerPara.PowerLower = parameters.Parameters.GetParameter<double>("功率下限");
- // PowerPara.PowerUpper = parameters.Parameters.GetParameter<double>("功率上限");
- // //PowerPara.FreqAccuracyUpper = parameters.Parameters.GetParameter<double>("频率稳定度上限");
- // // PowerPara.PowerFlatnessUpper = parameters.Parameters.GetParameter<double>("功率不平度上限");
- // // PowerPara.ModulationIndexLower = parameters.Parameters.GetParameter<double>("调制系数下限");
- // // PowerPara.ModulationIndexUpper = parameters.Parameters.GetParameter<double>("调制系数上限");
- // PowerPara.MaxFreqOffsetLower = parameters.Parameters.GetParameter<double>("最大频偏(KHz)下限");
- // PowerPara.MaxFreqOffsetUpper = parameters.Parameters.GetParameter<double>("最大频偏(KHz)上限");
- // PowerPara.SpuriousSuppressionLower = parameters.Parameters.GetParameter<double>("杂波抑制下限");
- // PowerPara.HarmonicSuppressionLower = parameters.Parameters.GetParameter<double>("谐波抑制下限");
- // if ((PowerPara.StartFrequency == 0) ||(PowerPara.ChannelPara == 0) ||((PowerPara.StepFrequency == 0) && (PowerPara.FrequencyNumber == 0)) || (PowerPara.StopFrequency == 0)
- // || (PowerPara.SPAN == null) || (PowerPara.REF == null) || (PowerPara.RBW == null) || (PowerPara.VBW == null) || (PowerPara.PowerLower == 0)
- // || (PowerPara.PowerUpper == 0) || (PowerPara.MaxFreqOffsetLower == 0) || (PowerPara.MaxFreqOffsetUpper == 0) || (PowerPara.SpuriousSuppressionLower == 0)
- // ||(PowerPara.HarmonicSuppressionLower == 0))
- // {
- // ShowMessage(MsgType.Error, string.Format("配置文件中频率参数为空,{0}/{1}无法运行", parameters.Channel, parameters.Name));
- // return false;
- // }
- // if (PowerPara.ControlDelay == 0)
- // {
- // PowerPara.ControlDelay = 10;
- // }
- // if ((PowerPara.FrequencyNumber != 0) && (PowerPara.FrequencyNumber != 1) && (PowerPara.StepFrequency == 0))
- // {
- // PowerPara.StepFrequency = ((int)(((PowerPara.StopFrequency - PowerPara.StartFrequency) / (PowerPara.FrequencyNumber - 1)) * 100)) / 100;
- // }
- // if (PowerPara.StepFrequency != 0)
- // {
- // PowerPara.FrequencyNumber = ((int)((PowerPara.StopFrequency - PowerPara.StartFrequency) / PowerPara.StepFrequency)) + 1;
- // }
- // int channel = 0;
- // int point = 0;
- // string Result;
- // double CenterFreq;
- // double[] PowerDelt = new double[PowerPara.FrequencyNumber];
- // Data.Power = new double[PowerPara.FrequencyNumber];
- // Data.Freq = new double[PowerPara.FrequencyNumber];
- // Data.FreqAccuracy = new double[PowerPara.FrequencyNumber];
- // Data.ModulationIndex = new string[PowerPara.FrequencyNumber];
- // Data.MaxFreqOffset = new string[PowerPara.FrequencyNumber];
- // Data.DBMaxFreqOffset = new string[PowerPara.FrequencyNumber];
- // for (channel = 0; channel < PowerPara.ChannelPara; channel++)
- // {
- // #region 输出功率、频率、电压、电流、调制频偏dB、调制频偏KHz测试
- // //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("REF", PowerPara.REF); SA.Query("OPC");
- // //SA.Write("SingleOrCont", "0"); SA.Query("OPC");
- // //SA.Write("MARK打开", "1"); SA.Query("OPC");
- // //SA.Write("MARK打开", "2"); SA.Query("OPC");
- // //SA.Write("DELT打开", "2"); SA.Query("OPC");
- // for (point = 0; ; point++)
- // {
- // CenterFreq = PowerPara.StartFrequency + PowerPara.StepFrequency * point;
- // if (CenterFreq > PowerPara.StopFrequency || (PowerPara.FrequencyNumber == 1 && point == 1))
- // {
- // break;
- // }
- // //控制
- // //SerialClient.DUT_Transmitter_Ctrol(PowerPara.ComPort, Convert.ToByte(point + 1));
- // Thread.Sleep(PowerPara.ControlDelay);//单位ms
- // #region 电压、电流测试
- // //Data.VoltVal[point] = DC.Query("读取电压");
- // //Data.CurrentVal[point] = DC.Query("读取电流");
- // VoltDataPrint.Test_name = "通道" + (channel+1).ToString() + "-" + "电压测试-" + CenterFreq.ToString() + "MHz";
- // VoltDataPrint.Lower = PowerPara.VoltLower;
- // VoltDataPrint.Upper = PowerPara.VoltUpper;
- // //VoltDataPrint.TestVal = double.Parse(Data.VoltVal[point]);
- // VoltDataPrint.TestVal = random.Next(2500, 3000) / 100.0;//随机数
- // Judge(VoltDataPrint.Lower, VoltDataPrint.Upper, VoltDataPrint.TestVal, out Result);
- // VoltDataPrint.Result = Result;
- // CurrentDataPrint.Test_name = "通道" + (channel + 1).ToString() + "-" + "电流测试-" + CenterFreq.ToString() + "MHz";
- // CurrentDataPrint.Lower = PowerPara.CurrentLower;
- // CurrentDataPrint.Upper = PowerPara.CurrentUpper;
- // //CurrentDataPrint.TestVal = double.Parse(Data.CurrentVal[point]);
- // CurrentDataPrint.TestVal = random.Next(90, 160) / 100.0;
- // Judge(CurrentDataPrint.Lower, CurrentDataPrint.Upper, CurrentDataPrint.TestVal, out Result);
- // CurrentDataPrint.Result = Result;
- // #endregion
- // #region 输出功率、频率测试
- // //SA.Write("CENTER", CenterFreq.ToString()); SA.Query("OPC");
- // //SA.Write("PEAK", "1"); SA.Query("OPC");
- // //SA.Write("NextPeak", "2"); SA.Query("OPC");
- // // PsaPeakValue_Tracedata(SA, out y_value, out x_value, true);
- // // Data.Power[point] = y_value + PowerPara.OutLoss;//功率
- // Data.Power[point] = random.Next(3000, 4000) / 100.0;//随机数
- // PowerPrint.Test_name = "通道" + (channel + 1).ToString() + "-" + "功率测试(W)-" + CenterFreq.ToString() + "MHz";
- // PowerPrint.Lower = PowerPara.PowerLower;
- // PowerPrint.Upper = PowerPara.PowerUpper;
- // PowerPrint.TestVal = Math.Round(Math.Pow(10, (Data.Power[point] / 10)) / 1000, 2);//功率W
- // Judge(PowerPrint.Lower, PowerPrint.Upper, PowerPrint.TestVal, out Result);
- // PowerPrint.Result = Result;
- // FreqPrint.Test_name = "通道" + (channel + 1).ToString() + "-" + "频率测试(MHz)-" + CenterFreq.ToString() + "MHz";
- // FreqPrint.Lower = 0 - ((PowerPara.FreqAccuracyUpper * CenterFreq) + CenterFreq);
- // FreqPrint.Upper = (PowerPara.FreqAccuracyUpper * CenterFreq) + CenterFreq;
- // // FreqPrint.TestVal = Math.Round(x_value / 1000000, 3);//实测频率
- // FreqPrint.TestVal = random.Next(-600, 6000) / 100.0 + CenterFreq;//随机数
- // Judge(FreqPrint.Lower, FreqPrint.Upper, FreqPrint.TestVal, out Result);
- // FreqPrint.Result = Result;
- // #endregion
- // #region 调制测试
- // //PowerDelt[point] = double.Parse(SA.Query("读DELT功率", "2")); SA.Query("OPC");
- // PowerDelt[point] = random.Next(500, 1200) / 100.0;//随机数
- // double temp = 30;
- // string RelativeVal = "0";
- // foreach (KeyValuePair<string, ModulationMatchParameter> kvp in CfigModuParas.ModulaParameters)
- // {
- // if ((Math.Abs(PowerDelt[point] - double.Parse(kvp.Value.CfgRelative))) < temp)
- // {
- // temp = Math.Abs(PowerDelt[point] - double.Parse(kvp.Value.CfgRelative));
- // RelativeVal = kvp.Value.CfgRelative;
- // }
- // }
- // //Data.ModulationIndex[point] = CfigModuParas.GetModulaParameter(RelativeVal);//调制系数
-
- // Data.MaxFreqOffset[point] = CfigModuParas.GetFreqOffsetParameter(RelativeVal);//最大频偏kHz
- // Data.DBMaxFreqOffset[point] = PowerDelt[point].ToString();//最大频偏dB
- // //ModulationIndexPrint.TestVal = double.Parse(Data.ModulationIndex[point]);
- // //Judge (PowerPara.ModulationIndexLower, PowerPara.ModulationIndexUpper, ModulationIndexPrint.TestVal, out Result);
- // //ModulationIndexPrint.Result = Result;
- // MaxFreqOffsetPrint.Test_name = "通道" + (channel + 1).ToString() + "-" + "调制频偏(KHz)-" + CenterFreq.ToString() + "MHz";
- // DBMaxFreqOffsetPrint.Test_name = "通道" + (channel + 1).ToString() + "-" + "调制频偏(dB)-" + CenterFreq.ToString() + "MHz";
- // MaxFreqOffsetPrint.Lower = PowerPara.MaxFreqOffsetLower;
- // MaxFreqOffsetPrint.Upper = PowerPara.MaxFreqOffsetUpper;
- // MaxFreqOffsetPrint.TestVal = double.Parse(Data.MaxFreqOffset[point]);
- // DBMaxFreqOffsetPrint.TestVal = double.Parse(Data.DBMaxFreqOffset[point]);
- // Judge(MaxFreqOffsetPrint.Lower, MaxFreqOffsetPrint.Upper, MaxFreqOffsetPrint.TestVal, out Result);
- // MaxFreqOffsetPrint.Result = Result;
- // DBMaxFreqOffsetPrint.Result = Result;
- // tps.TestTableAddCell(VoltDataPrint.Test_name, VoltDataPrint.Lower.ToString(), VoltDataPrint.Upper.ToString(), VoltDataPrint.TestVal.ToString(), VoltDataPrint.Result);
- // tps.TestTableAddCell(CurrentDataPrint.Test_name, CurrentDataPrint.Lower.ToString(), CurrentDataPrint.Upper.ToString(), CurrentDataPrint.TestVal.ToString(), CurrentDataPrint.Result);
- // tps.TestTableAddCell(FreqPrint.Test_name, FreqPrint.Lower.ToString(), FreqPrint.Upper.ToString(), FreqPrint.TestVal.ToString(), FreqPrint.Result);
- // tps.TestTableAddCell(DBMaxFreqOffsetPrint.Test_name, DBMaxFreqOffsetPrint.Lower.ToString(), DBMaxFreqOffsetPrint.Upper.ToString(), DBMaxFreqOffsetPrint.TestVal.ToString(), DBMaxFreqOffsetPrint.Result);
- // tps.TestTableAddCell(MaxFreqOffsetPrint.Test_name, MaxFreqOffsetPrint.Lower.ToString(), MaxFreqOffsetPrint.Upper.ToString(), MaxFreqOffsetPrint.TestVal.ToString(), MaxFreqOffsetPrint.Result);
- // tps.TestTableAddCell(PowerPrint.Test_name, PowerPrint.Lower.ToString(), PowerPrint.Upper.ToString(), PowerPrint.TestVal.ToString(), PowerPrint.Result);
- // #endregion
- // if (channel == 0)
- // {
- // WriteExcelData(sheet, point + 2 + time * 10, 1, VoltDataPrint.Test_name, VoltDataPrint.Lower.ToString(), VoltDataPrint.Upper.ToString(), VoltDataPrint.TestVal.ToString(), VoltDataPrint.Result);
- // WriteExcelData(sheet, point + 3 + time * 10, 1, CurrentDataPrint.Test_name, CurrentDataPrint.Lower.ToString(), CurrentDataPrint.Upper.ToString(), CurrentDataPrint.TestVal.ToString(), CurrentDataPrint.Result);
- // WriteExcelData(sheet, point + 4 + time * 10, 1, FreqPrint.Test_name, FreqPrint.Lower.ToString(), FreqPrint.Upper.ToString(), FreqPrint.TestVal.ToString(), FreqPrint.Result);
- // WriteExcelData(sheet, point + 5 + time * 10, 1, DBMaxFreqOffsetPrint.Test_name, DBMaxFreqOffsetPrint.Lower.ToString(), DBMaxFreqOffsetPrint.Upper.ToString(), DBMaxFreqOffsetPrint.TestVal.ToString(), DBMaxFreqOffsetPrint.Result);
- // WriteExcelData(sheet, point + 6 + time * 10, 1, MaxFreqOffsetPrint.Test_name, MaxFreqOffsetPrint.Lower.ToString(), MaxFreqOffsetPrint.Upper.ToString(), MaxFreqOffsetPrint.TestVal.ToString(), MaxFreqOffsetPrint.Result);
- // WriteExcelData(sheet, point + 7 + time * 10, 1, PowerPrint.Test_name, PowerPrint.Lower.ToString(), PowerPrint.Upper.ToString(), PowerPrint.TestVal.ToString(), PowerPrint.Result);
- // //tps.SetTestTableCellValue(point + time, 4, VoltDataPrint.Result, VoltDataPrint.TestVal);//供电电压(V)
- // //tps.SetTestTableCellValue(point + time, 5, CurrentDataPrint.Result, CurrentDataPrint.TestVal);//消耗电流(A)
- // //tps.SetTestTableCellValue(point + time, 6, FreqPrint.Result, FreqPrint.TestVal);//输出频率(kHz)
- // //tps.SetTestTableCellValue(point + time, 7, DBMaxFreqOffsetPrint.Result, DBMaxFreqOffsetPrint.TestVal);//调制频偏(dB)
- // //tps.SetTestTableCellValue(point + time, 8, MaxFreqOffsetPrint.Result, MaxFreqOffsetPrint.TestVal);//调制频偏(kHz)
- // //tps.SetTestTableCellValue(point + time, 9, PowerPrint.Result, PowerPrint.TestVal);//输出功率(W)
- // }
- // else if (channel == 1)
- // {
- // WriteExcelData(sheet, point + 2 + time * 10, 2, VoltDataPrint.Test_name, VoltDataPrint.Lower.ToString(), VoltDataPrint.Upper.ToString(), VoltDataPrint.TestVal.ToString(), VoltDataPrint.Result);
- // WriteExcelData(sheet, point + 3 + time * 10, 2, CurrentDataPrint.Test_name, CurrentDataPrint.Lower.ToString(), CurrentDataPrint.Upper.ToString(), CurrentDataPrint.TestVal.ToString(), CurrentDataPrint.Result);
- // WriteExcelData(sheet, point + 4 + time * 10, 2, FreqPrint.Test_name, FreqPrint.Lower.ToString(), FreqPrint.Upper.ToString(), FreqPrint.TestVal.ToString(), FreqPrint.Result);
- // WriteExcelData(sheet, point + 5 + time * 10, 2, DBMaxFreqOffsetPrint.Test_name, DBMaxFreqOffsetPrint.Lower.ToString(), DBMaxFreqOffsetPrint.Upper.ToString(), DBMaxFreqOffsetPrint.TestVal.ToString(), DBMaxFreqOffsetPrint.Result);
- // WriteExcelData(sheet, point + 6 + time * 10, 2, MaxFreqOffsetPrint.Test_name, MaxFreqOffsetPrint.Lower.ToString(), MaxFreqOffsetPrint.Upper.ToString(), MaxFreqOffsetPrint.TestVal.ToString(), MaxFreqOffsetPrint.Result);
- // WriteExcelData(sheet, point + 7 + time * 10, 2, PowerPrint.Test_name, PowerPrint.Lower.ToString(), PowerPrint.Upper.ToString(), PowerPrint.TestVal.ToString(), PowerPrint.Result);
- // //tps.SetTestTableCellValue(point + time + 5, 4, VoltDataPrint.Result, VoltDataPrint.TestVal);//供电电压(V)
- // //tps.SetTestTableCellValue(point + time + 5, 5, CurrentDataPrint.Result, CurrentDataPrint.TestVal);//消耗电流(A)
- // //tps.SetTestTableCellValue(point + time + 5, 6, FreqPrint.Result, FreqPrint.TestVal);//输出频率(kHz)
- // //tps.SetTestTableCellValue(point + time + 5, 7, DBMaxFreqOffsetPrint.Result, DBMaxFreqOffsetPrint.TestVal);//调制频偏(dB)
- // //tps.SetTestTableCellValue(point + time + 5, 8, MaxFreqOffsetPrint.Result, MaxFreqOffsetPrint.TestVal);//调制频偏(kHz)
- // //tps.SetTestTableCellValue(point + time + 5, 9, PowerPrint.Result, PowerPrint.TestVal);//输出功率(W)
- // }
- // }
- // #endregion
- // #region 杂波抑制
- // //SA.Write("仪器复位"); SA.Query("OPC");
- // //SA.Write("SPAN", PowerPara.SPAN); SA.Query("OPC");
- // //SA.Write("REF", PowerPara.SmallSignalREF); 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");
- // for (point = 0; ; point++)
- // {
- // CenterFreq = PowerPara.StartFrequency + PowerPara.StepFrequency * point;
- // if (CenterFreq > PowerPara.StopFrequency || (PowerPara.FrequencyNumber == 1 && point == 1))
- // {
- // break;
- // }
- // //// 控制
- // //SerialClient.DUT_Transmitter_Ctrol(PowerPara.ComPort, Convert.ToByte(point + 1));
- // //Thread.Sleep(PowerPara.ControlDelay);//单位ms
- // //SA.Write("CENTER", CenterFreq.ToString()); SA.Query("OPC");
- // //PsaPeakValue_Tracedata(SA, out y_value, out x_value, false);
- // //Power = y_value;
- // ////测主频左侧杂散
- // //SA.Write("START", PowerPara.LeftStart.ToString()); SA.Query("OPC");
- // //SA.Write("STOP", (CenterFreq - PowerPara.LeftOffset).ToString()); SA.Query("OPC");
- // //PsaPeakValue_Tracedata(SA, out y_value, out x_value, false);
- // //PowerLeft = Power - y_value;
- // ////测主频右侧杂散
- // //SA.Write("START", (CenterFreq + PowerPara.RightOffset).ToString()); SA.Query("OPC");
- // //SA.Write("STOP", PowerPara.RightStop.ToString()); SA.Query("OPC");
- // //PsaPeakValue_Tracedata(SA, out y_value, out x_value, false);
- // //PowerRigth = Power - y_value;
- // SpuriousSuppressionPrint.Test_name = "通道" + (channel + 1).ToString() + "-" + "杂波抑制测试(KHz)-" + CenterFreq.ToString() + "MHz";
- // SpuriousSuppressionPrint.Lower = PowerPara.SpuriousSuppressionLower;
- // //SpuriousSuppressionPrint.TestVal = Math.Round(Math.Min(PowerLeft, PowerRigth), 2);
- // SpuriousSuppressionPrint.TestVal = random.Next(4000, 12000) / 100.0;//随机数
- // Judge(SpuriousSuppressionPrint.Lower, 201, SpuriousSuppressionPrint.TestVal, out Result);
- // SpuriousSuppressionPrint.Result = Result;
- // tps.TestTableAddCell(SpuriousSuppressionPrint.Test_name, SpuriousSuppressionPrint.Lower.ToString(), SpuriousSuppressionPrint.Upper.ToString(), SpuriousSuppressionPrint.TestVal.ToString(), SpuriousSuppressionPrint.Result);
- // if (channel == 0)
- // {
- // WriteExcelData(sheet, point + 8 + time * 10, 1, SpuriousSuppressionPrint.Test_name, SpuriousSuppressionPrint.Lower.ToString(), SpuriousSuppressionPrint.Upper.ToString(), SpuriousSuppressionPrint.TestVal.ToString(), SpuriousSuppressionPrint.Result);
- // //tps.SetTestTableCellValue(point + time, 10, SpuriousSuppressionPrint.Result, SpuriousSuppressionPrint.TestVal);//杂波抑制(dBc)
- // }
- // else if (channel == 1)
- // {
- // WriteExcelData(sheet, point + 8 + time * 10, 2, SpuriousSuppressionPrint.Test_name, SpuriousSuppressionPrint.Lower.ToString(), SpuriousSuppressionPrint.Upper.ToString(), SpuriousSuppressionPrint.TestVal.ToString(), SpuriousSuppressionPrint.Result);
- // //tps.SetTestTableCellValue(point + time + 5, 10, SpuriousSuppressionPrint.Result, SpuriousSuppressionPrint.TestVal);//杂波抑制(dBc)
- // }
- // }
- // #endregion
- // #region 谐波抑制
- // //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");
- // for (point = 0; ; point++)
- // {
- // CenterFreq = PowerPara.StartFrequency + PowerPara.StepFrequency * point;
- // if (CenterFreq > PowerPara.StopFrequency || (PowerPara.FrequencyNumber == 1 && point == 1))
- // {
- // break;
- // }
- // // 控制
- // //SerialClient.DUT_Transmitter_Ctrol(PowerPara.ComPort, Convert.ToByte(point + 1));
- // //Thread.Sleep(PowerPara.ControlDelay);//单位ms
- // //SA.Write("CENTER", CenterFreq.ToString()); SA.Query("OPC");
- // //PsaPeakValue_Tracedata(SA, out y_value, out x_value, false);
- // //Power = y_value;
- // double[] HarmonicTimeVal = new double[PowerPara.HarmonicTime.Length];
- // double HarmonicMinTimeVal = 0;
- // //for ( harmonic_num = 0; harmonic_num < PowerPara.HarmonicTime.Length; harmonic_num++)
- // //{
- // // SA.Write("CENTER", (CenterFreq * PowerPara.HarmonicTime[harmonic_num]).ToString()); SA.Query("OPC");//N次谐波
- // // PsaPeakValue_Tracedata(SA, out y_value, out x_value, false);
- // // Data.HarmonicSuppression[point,harmonic_num] = Math.Round( Power - y_value,2 );
- // // HarmonicTimeVal[harmonic_num] = Data.HarmonicSuppression[point, harmonic_num];
- // //}
- // //if (PowerPara.HarmonicTime.Length > 1)//计算几次谐波中的最小值
- // //{
- // // HarmonicMinTimeVal = HarmonicTimeVal.Min();
- // //}
- // //else
- // //{
- // // HarmonicMinTimeVal = HarmonicTimeVal[0];
- // //}
- // HarmonicSuppressionPrint.Test_name = "通道" + (channel + 1).ToString() + "-" + "谐波抑制测试(KHz)-" + CenterFreq.ToString() + "MHz";
- // HarmonicSuppressionPrint.Lower = PowerPara.HarmonicSuppressionLower;
- // HarmonicSuppressionPrint.TestVal = HarmonicMinTimeVal;
- // HarmonicSuppressionPrint.TestVal = random.Next(4000, 12000) / 100.0;//随机数
- // Judge(HarmonicSuppressionPrint.Lower, 201, HarmonicSuppressionPrint.TestVal, out Result);
- // HarmonicSuppressionPrint.Result = Result;
- // tps.TestTableAddCell(HarmonicSuppressionPrint.Test_name, HarmonicSuppressionPrint.Lower.ToString(), HarmonicSuppressionPrint.Upper.ToString(), HarmonicSuppressionPrint.TestVal.ToString(), HarmonicSuppressionPrint.Result);
- // if (channel == 0)
- // {
- // WriteExcelData(sheet, point + 9 + time * 10, 1, HarmonicSuppressionPrint.Test_name, HarmonicSuppressionPrint.Lower.ToString(), HarmonicSuppressionPrint.Upper.ToString(), HarmonicSuppressionPrint.TestVal.ToString(), HarmonicSuppressionPrint.Result);
- // //tps.SetTestTableCellValue(point + time, 11, HarmonicSuppressionPrint.Result, HarmonicSuppressionPrint.TestVal);//谐波抑制(dBc)
- // }
- // else if (channel == 1)
- // {
- // WriteExcelData(sheet, point + 9 + time * 10, 2, HarmonicSuppressionPrint.Test_name, HarmonicSuppressionPrint.Lower.ToString(), HarmonicSuppressionPrint.Upper.ToString(), HarmonicSuppressionPrint.TestVal.ToString(), HarmonicSuppressionPrint.Result);
- // //tps.SetTestTableCellValue(point + time + 5, 11, HarmonicSuppressionPrint.Result, HarmonicSuppressionPrint.TestVal);//谐波抑制(dBc)
- // }
- // }
- // #endregion
-
- // }
-
- return true;
-
- }
- /// <summary>
- /// 判断上下限
- /// </summary>
- /// <returns></returns>
- public void Judge(double Lower,double Upper,double TestValue,out string JudgeResult)
- {
- if (Upper >= 200)
- {
- if (TestValue >= Lower)
- {
- JudgeResult = "是";
- }
- else
- {
- JudgeResult = "否";
- }
- }
- else if (Lower <= -200)
- {
- if (TestValue <= Upper)
- {
- JudgeResult = "是";
- }
- else
- {
- JudgeResult = "否";
- }
- }
- else
- {
- if (TestValue >= Lower && TestValue <= Upper)
- {
- JudgeResult = "是";
- }
- else
- {
- JudgeResult = "否";
- }
- }
-
- }
- public MatchModulaPara LoadModulationWorkBook()
- {
- MatchModulaPara pars = new MatchModulaPara();
- string FileName = Path.Combine(Bundle.bundle.BundleDir, "config\\ModulationMode.xlsx");
- if (!File.Exists(FileName))
- {
- ShowMessage(MsgType.Error, "找不到ModulationMode.xlsx");
- return null;
- }
- Spire.Xls.Workbook workbook = new Spire.Xls.Workbook();
- workbook.LoadFromFile(FileName);
- //获取第一个工作表sheet1
- Spire.Xls.Worksheet sheet = workbook.Worksheets[0];
- int num = 0;
- int blankRows = 0;
- while (num++ < 200)
- {
- //索引从1开始
- string col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : "";
- col1 = col1.Trim();
- if (string.IsNullOrEmpty(col1))
- {
- blankRows++;
- if (blankRows > 5)
- {
- //连续5个空行以上则退出
- break;
- }
- }
- else
- {
- blankRows = 0;
- }
- if (col1.Equals("功率变化(dB)"))
- {
- List<ModulationMatchParameter> ModulationTable = ReadParameters(sheet, num);
- foreach (var item in ModulationTable)
- {
- if (pars.ModulaParameters.ContainsKey(item.CfgRelative))
- {
- ShowMessage(MsgType.Error, string.Format("调制对应表:{0} 存在同名参数:{1},无法重复添加参数", sheet.Name, item.CfgRelative));
- continue;
- }
- pars.ModulaParameters.Add(item.CfgRelative, item);
- }
- }
- }
- return pars;
- }
- List<ModulationMatchParameter> ReadParameters(Spire.Xls.Worksheet sheet, int rowIndex)
- {
- List<ModulationMatchParameter> ModulationTable = new List<ModulationMatchParameter>();
- string col1 = sheet.Range[rowIndex, 1].Value2 != null ? sheet.Range[rowIndex, 1].Value2.ToString() : "";
- string col2 = sheet.Range[rowIndex, 2].Value2 != null ? sheet.Range[rowIndex, 2].Value2.ToString() : "";
- string col3 = sheet.Range[rowIndex, 3].Value2 != null ? sheet.Range[rowIndex, 3].Value2.ToString() : "";
- if (!(col1 == "功率变化(dB)" && col2 == "调制指数(mf)" && col3 == "最大频偏(KHz)"))
- {
- ShowMessage(MsgType.Error, "'调制对应表'行首标题位置和格式不正确");
- return ModulationTable;
- }
- int num = rowIndex;
- //默认最多30行
- while (num++ < rowIndex + 100)
- {
- col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : "";
- col2 = sheet.Range[num, 2].Value2 != null ? sheet.Range[num, 2].Value2.ToString() : "";
- col3 = sheet.Range[num, 3].Value2 != null ? sheet.Range[num, 3].Value2.ToString() : "";
- if (string.IsNullOrEmpty(col1) || string.IsNullOrEmpty(col2) || string.IsNullOrEmpty(col3))
- {
- break;
- }
- ModulationMatchParameter ObjModulation = new ModulationMatchParameter();
- ObjModulation.CfgRelative = col1;
- ObjModulation.CfgModulation = col2;
- ObjModulation.CfgFreqOffset = col3;
- ModulationTable.Add(ObjModulation);
- }
- return ModulationTable;
- }
- /// <summary>
- /// 一个调制指数的配置信息
- /// </summary>
- public class MatchModulaPara
- {
- public Dictionary<string, ModulationMatchParameter> ModulaParameters;
- public MatchModulaPara()
- {
- ModulaParameters = new Dictionary<string, ModulationMatchParameter>();
- }
- public string GetModulaParameter(string name)
- {
- if (string.IsNullOrEmpty(name))
- return null;
- if (this.ModulaParameters.ContainsKey(name) == false)
- return null;
- string val1 = this.ModulaParameters[name].CfgModulation.Trim();
- return val1;
- }
- public string GetFreqOffsetParameter(string name)
- {
- if (string.IsNullOrEmpty(name))
- return null;
- if (this.ModulaParameters.ContainsKey(name) == false)
- return null;
- string val2 = this.ModulaParameters[name].CfgFreqOffset.Trim();
- return val2;
- }
- }
- /// <summary>
- /// 调制指数3个对应项
- /// </summary>
- public class ModulationMatchParameter
- {
- /// <summary>
- /// 功率变化(dB)
- /// </summary>
- public string CfgRelative { get; set; }
- /// <summary>
- /// 调制指数(mf)
- /// </summary>
- public string CfgModulation { get; set; }
- /// <summary>
- /// 最大频偏(KHz)
- /// </summary>
- public string CfgFreqOffset { get; set; }
- }
- public class ConfigParameter
- {
- /// <summary>
- /// 串口
- /// </summary>
- public string ComPort { set; get; }
- /// <summary>
- /// 输出损耗
- /// </summary>
- public double OutLoss { set; get; }
- /// <summary>
- /// 通道数量
- /// </summary>
- public int ChannelPara { set; get; }
- /// <summary>
- /// 测试次数
- /// </summary>
- public int TestTime { set; get; }
- /// <summary>
- /// 相对时间
- /// </summary>
- public int IntervalTime { 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 PowerLower { set; get; }
- /// <summary>
- /// 功率上限
- /// </summary>
- public double PowerUpper { set; get; }
- /// <summary>
- /// 频率稳定度上限
- /// </summary>
- public double FreqAccuracyUpper { set; get; }
- /// <summary>
- /// 两路功率总和下限
- /// </summary>
- public double PowerSumLower { set; get; }
- /// <summary>
- /// 功率不平度上限
- /// </summary>
- public double PowerFlatnessUpper { set; get; }
- /// <summary>
- /// 调制系数下限
- /// </summary>
- public double ModulationIndexLower { get; set; }
- /// <summary>
- ///调制系数上限
- /// </summary>
- public double ModulationIndexUpper { get; set; }
- /// <summary>
- /// 最大频偏kHz下限
- /// </summary>
- public double MaxFreqOffsetLower { get; set; }
- /// <summary>
- ///最大频偏kHz调制系数上限
- /// </summary>
- public double MaxFreqOffsetUpper { get; set; }
- /// <summary>
- /// 杂波抑制下限
- /// </summary>
- public double SpuriousSuppressionLower { set; get; }
- // <summary>
- /// 谐波抑制下限
- /// </summary>
- public double HarmonicSuppressionLower { set; get; }
- /// <summary>
- /// 电压下限
- /// </summary>
- public double VoltLower { set; get; }
- /// <summary>
- /// 电压上限
- /// </summary>
- public double VoltUpper { set; get; }
- /// <summary>
- /// 电流下限
- /// </summary>
- public double CurrentLower { set; get; }
- /// <summary>
- /// 电流上限
- /// </summary>
- public double CurrentUpper { set; get; }
- }
- public class TestPara
- {
- /// <summary>
- /// 读电压值
- /// </summary>
- public string[] VoltVal { set; get; }
- /// <summary>
- /// 读电流值
- /// </summary>
- public string[] CurrentVal { set; get; }
- /// <summary>
- /// 输出功率(W)
- /// </summary>
- public double[] Power { set; get; }
- /// <summary>
- /// 频率稳定度
- /// </summary>
- public double[] FreqAccuracy { set; get; }
- /// <summary>
- /// 实测频点
- /// </summary>
- public double[] Freq { set; get; }
- /// <summary>
- /// 两路功率总和(W)
- /// </summary>
- public double[] PowerSum { set; get; }
- /// <summary>
- /// 两路功率不平度(dB)
- /// </summary>
- public double[] PowerFlatness { set; get; }
- /// <summary>
- ///调制系数
- /// </summary>
- public string[] ModulationIndex { set; get; }
- /// <summary>
- /// 最大频偏KHz
- /// </summary>
- public string[] MaxFreqOffset { set; get; }
- /// <summary>
- /// 最大频偏dB
- /// </summary>
- public string[] DBMaxFreqOffset { set; get; }
- }
-
- }
-
- }
|