using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading; using System.IO; using System.Threading.Tasks; using Tps_LQ_Transmitter.com; namespace Tps_LQ_Transmitter.models { class ModulationIndexAndMaxFreqOffset: BaseModel { public ModulationIndexAndMaxFreqOffset() { TemplateName = "调制指数及最大频偏指标测试"; } /// /// 功率及频率稳定度测试 /// 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 ModulationIndexPrint = new DataType(); DataType leftModulationIndexPrint = new DataType(); DataType rightModulationIndexPrint = new DataType(); DataType MaxFreqOffsetPrint = new DataType(); DataType leftFreqOffsetPrint = new DataType(); DataType rightFreqOffsetPrint = 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; } MatchModulaPara CfigModuParas = new MatchModulaPara(); CfigModuParas = LoadModulationWorkBook(); if (CfigModuParas == null) { return false; } ConfigParameter PowerPara = new ConfigParameter(); //PowerPara.StepFrequency = 0; ////PowerPara.ComPort = parameters.Parameters.GetParameter("串口"); //PowerPara.OutLoss = parameters.Parameters.GetParameter("输出损耗"); //PowerPara.StartFrequency = parameters.Parameters.GetParameter("起始频率"); //PowerPara.StepFrequency = parameters.Parameters.GetParameter("频率步进"); //PowerPara.FrequencyNumber = parameters.Parameters.GetParameter("频点数量"); //PowerPara.StopFrequency = parameters.Parameters.GetParameter("终止频率"); PowerPara.SPAN = parameters.Parameters.GetParameter("扫描带宽(SPAN)"); PowerPara.REF = parameters.Parameters.GetParameter("参考电平(REF)"); PowerPara.RBW = parameters.Parameters.GetParameter("分辨率带宽(RBW)"); PowerPara.VBW = parameters.Parameters.GetParameter("视频带宽(VBW)"); PowerPara.ControlDelay = parameters.Parameters.GetParameter("控制延时"); PowerPara.ModulationIndexLower = parameters.Parameters.GetParameter("调制系数下限"); PowerPara.ModulationIndexUpper = parameters.Parameters.GetParameter("调制系数上限"); if ( (PowerPara.SPAN == null) || (PowerPara.REF == null) || (PowerPara.RBW == null) || (PowerPara.VBW == null)|| (PowerPara.ModulationIndexLower==0) || (PowerPara.ModulationIndexUpper==0)) { ShowMessage(MsgType.Error, string.Format("配置文件中频率参数为空,{0}/{1}无法运行", parameters.Channel, parameters.Name)); return false; } //if (PowerPara.ControlDelay == 0) //{ // PowerPara.ControlDelay = 10; //} 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("REF", PowerPara.REF); SA.Query("OPC"); SA.Write("MARK打开", "1"); SA.Query("OPC"); SA.Write("MARK打开", "2"); SA.Query("OPC"); SA.Write("MARK打开", "3"); SA.Query("OPC"); SA.Write("DELT打开", "2"); SA.Query("OPC"); SA.Write("DELT打开", "3"); SA.Query("OPC"); } //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; //} //double CenterFreq; double[] PowerDeltleft = new double[parameters.PointTotal]; double[] PowerDeltright = new double[parameters.PointTotal]; Data.ModulationIndex = new string[parameters.PointTotal]; Data.leftModulationIndex = new string[parameters.PointTotal]; Data.rightModulationIndex = new string[parameters.PointTotal]; Data.MaxFreqOffset = new string[parameters.PointTotal]; Data.leftFreqOffset = new string[parameters.PointTotal]; Data.rightFreqOffset = new string[parameters.PointTotal]; // for (int point = 0;; point++) { //CenterFreq = PowerPara.StartFrequency + PowerPara.StepFrequency * point; //if (CenterFreq > PowerPara.StopFrequency ||( PowerPara.FrequencyNumber == 1 && point == 1)) //{ // break; //} if(true)//需具备仪器 { // 控制 // SerialClient.DUT_Transmitter_Ctrol(PowerPara.ComPort, Convert.ToByte(point + 1)); //Thread.Sleep(PowerPara.ControlDelay);//单位ms SA.Write("CENTER", parameters.CenterFreq.ToString()); SA.Query("OPC"); SA.Write("SingleOrCont", "0"); SA.Query("OPC"); SA.Write("单次扫描"); SA.Query("OPC"); SA.Write("PEAK", "1"); SA.Query("OPC"); SA.Write("PEAK", "2"); SA.Query("OPC"); SA.Write("PEAK", "3"); SA.Query("OPC"); if (SA.Query("IDN").Contains("N9030"))//N9030A型号频谱仪 { SA.Write("DELT打开", "2"); SA.Query("OPC"); SA.Write("NextPeakLeft", "2"); SA.Query("OPC"); PowerDeltleft[parameters.PointIndex] = double.Parse(SA.Query("读MARK功率", "2")); SA.Query("OPC"); SA.Write("DELT打开", "3"); SA.Query("OPC"); SA.Write("NextPeakRight", "3"); SA.Query("OPC"); PowerDeltright[parameters.PointIndex] = double.Parse(SA.Query("读MARK功率", "3")); SA.Query("OPC"); } else//其他型号频谱仪 { SA.Write("NextPeakLeft", "2"); SA.Query("OPC"); PowerDeltleft[parameters.PointIndex] = double.Parse(SA.Query("读DELT功率", "2")); SA.Query("OPC"); SA.Write("NextPeakRight", "3"); SA.Query("OPC"); PowerDeltright[parameters.PointIndex] = double.Parse(SA.Query("读DELT功率", "3")); SA.Query("OPC"); } } // PowerDelt[point] = random.Next(500, 1200) / 100.0;//随机数 double temp = 30; string RelativeVal= "0"; foreach (KeyValuePair kvp in CfigModuParas.ModulaParameters) { if ((Math.Abs(Math.Abs(PowerDeltleft[parameters.PointIndex]) - double.Parse(kvp.Value.CfgRelative))) < temp) { temp = Math.Abs(Math.Abs(PowerDeltleft[parameters.PointIndex]) - double.Parse(kvp.Value.CfgRelative)); RelativeVal = kvp.Value.CfgRelative; } } Data.leftModulationIndex[parameters.PointIndex] = CfigModuParas.GetModulaParameter(RelativeVal);//左侧调制系数 Data.leftFreqOffset[parameters.PointIndex] = CfigModuParas.GetFreqOffsetParameter(RelativeVal);//左侧最大频偏 temp = 30; RelativeVal = "0"; foreach (KeyValuePair kvp in CfigModuParas.ModulaParameters) { if ((Math.Abs(Math.Abs(PowerDeltright[parameters.PointIndex]) - double.Parse(kvp.Value.CfgRelative))) < temp) { temp = Math.Abs(Math.Abs(PowerDeltright[parameters.PointIndex]) - double.Parse(kvp.Value.CfgRelative)); RelativeVal = kvp.Value.CfgRelative; } } Data.rightModulationIndex[parameters.PointIndex] = CfigModuParas.GetModulaParameter(RelativeVal);//右侧调制系数 Data.rightFreqOffset[parameters.PointIndex] = CfigModuParas.GetFreqOffsetParameter(RelativeVal);//右侧最大频偏 Data.ModulationIndex[parameters.PointIndex] = Math.Min(double.Parse(Data.leftModulationIndex[parameters.PointIndex]), double.Parse(Data.rightModulationIndex[parameters.PointIndex])).ToString();//调制系数 Data.MaxFreqOffset[parameters.PointIndex] = Math.Min(double.Parse(Data.leftFreqOffset[parameters.PointIndex]), double.Parse(Data.rightFreqOffset[parameters.PointIndex])).ToString();//最大频偏 ModulationIndexPrint.Test_name = parameters.Channel + "-调制系数测试-" + parameters.CenterFreq.ToString() + "MHz"; leftModulationIndexPrint.Test_name = parameters.Channel + "-fL调制系数测试-" + parameters.CenterFreq.ToString() + "MHz"; rightModulationIndexPrint.Test_name = parameters.Channel + "-fH调制系数测试-" + parameters.CenterFreq.ToString() + "MHz"; MaxFreqOffsetPrint.Test_name = parameters.Channel + "-最大频偏(KHz)-" + parameters.CenterFreq.ToString() + "MHz"; leftFreqOffsetPrint.Test_name = parameters.Channel + "-fL(KHz)-" + parameters.CenterFreq.ToString() + "MHz"; rightFreqOffsetPrint.Test_name = parameters.Channel + "-fH(KHz)-" + parameters.CenterFreq.ToString() + "MHz"; ModulationIndexPrint.Lower = PowerPara.ModulationIndexLower; ModulationIndexPrint.Upper = PowerPara.ModulationIndexUpper; ModulationIndexPrint.TestVal = double.Parse(Data.ModulationIndex[parameters.PointIndex]); leftModulationIndexPrint.TestVal = double.Parse(Data.leftModulationIndex[parameters.PointIndex]); rightModulationIndexPrint.TestVal = double.Parse(Data.rightModulationIndex[parameters.PointIndex]); MaxFreqOffsetPrint.TestVal = double.Parse(Data.MaxFreqOffset[parameters.PointIndex]); leftFreqOffsetPrint.TestVal = double.Parse(Data.leftFreqOffset[parameters.PointIndex]); rightFreqOffsetPrint.TestVal = double.Parse(Data.rightFreqOffset[parameters.PointIndex]); if ((ModulationIndexPrint.TestVal >= ModulationIndexPrint.Lower) &&( ModulationIndexPrint.TestVal <= ModulationIndexPrint.Upper)) { ModulationIndexPrint.Result = "是"; MaxFreqOffsetPrint.Result = "是"; } else { ModulationIndexPrint.Result = "否"; MaxFreqOffsetPrint.Result = "否"; } if ((leftModulationIndexPrint.TestVal >= ModulationIndexPrint.Lower) && (leftModulationIndexPrint.TestVal <= ModulationIndexPrint.Upper)) { leftModulationIndexPrint.Result = "是"; leftFreqOffsetPrint.Result = "是"; } else { leftModulationIndexPrint.Result = "否"; leftFreqOffsetPrint.Result = "否"; } if ((rightModulationIndexPrint.TestVal >= ModulationIndexPrint.Lower) && (rightModulationIndexPrint.TestVal <= ModulationIndexPrint.Upper)) { rightModulationIndexPrint.Result = "是"; rightFreqOffsetPrint.Result = "是"; } else { rightModulationIndexPrint.Result = "否"; rightFreqOffsetPrint.Result = "否"; } tps.TestTableAddCell(MaxFreqOffsetPrint.Test_name, "/", "/", MaxFreqOffsetPrint.TestVal.ToString(), MaxFreqOffsetPrint.Result); tps.TestTableAddCell(leftFreqOffsetPrint.Test_name, "/", "/", leftFreqOffsetPrint.TestVal.ToString(), leftFreqOffsetPrint.Result); tps.TestTableAddCell(rightFreqOffsetPrint.Test_name, "/", "/", rightFreqOffsetPrint.TestVal.ToString(), rightFreqOffsetPrint.Result); tps.TestTableAddCell(ModulationIndexPrint.Test_name, ModulationIndexPrint.Lower.ToString(), ModulationIndexPrint.Upper.ToString(), ModulationIndexPrint.TestVal.ToString(), ModulationIndexPrint.Result); tps.TestTableAddCell(leftModulationIndexPrint.Test_name, ModulationIndexPrint.Lower.ToString(), ModulationIndexPrint.Upper.ToString(), leftModulationIndexPrint.TestVal.ToString(), leftModulationIndexPrint.Result); tps.TestTableAddCell(rightModulationIndexPrint.Test_name, ModulationIndexPrint.Lower.ToString(), ModulationIndexPrint.Upper.ToString(), rightModulationIndexPrint.TestVal.ToString(), rightModulationIndexPrint.Result); if (parameters.Channel == "通道1") { //tps.SetTestTableCellValue(point, 9, ModulationIndexPrint.Result,Data.ModulationIndex[point]); WriteExcelData(sheet, parameters.PointIndex, 1, ModulationIndexPrint.Test_name, ModulationIndexPrint.Lower.ToString(), ModulationIndexPrint.Upper.ToString(), ModulationIndexPrint.TestVal.ToString(), ModulationIndexPrint.Result); WriteExcelData(sheet, parameters.PointIndex, 5, leftModulationIndexPrint.Test_name, leftModulationIndexPrint.Lower.ToString(), leftModulationIndexPrint.Upper.ToString(), leftModulationIndexPrint.TestVal.ToString(), leftModulationIndexPrint.Result); WriteExcelData(sheet, parameters.PointIndex, 9, rightModulationIndexPrint.Test_name, rightModulationIndexPrint.Lower.ToString(), rightModulationIndexPrint.Upper.ToString(), rightModulationIndexPrint.TestVal.ToString(), rightModulationIndexPrint.Result); WriteExcelData(sheet, parameters.PointIndex, 3, MaxFreqOffsetPrint.Test_name, "/", "/", MaxFreqOffsetPrint.TestVal.ToString(), MaxFreqOffsetPrint.Result); WriteExcelData(sheet, parameters.PointIndex, 7, leftFreqOffsetPrint.Test_name, "/", "/", leftFreqOffsetPrint.TestVal.ToString(), leftFreqOffsetPrint.Result); WriteExcelData(sheet, parameters.PointIndex, 11, rightFreqOffsetPrint.Test_name, "/", "/", rightFreqOffsetPrint.TestVal.ToString(), rightFreqOffsetPrint.Result); // tps.SetTestTableCellValue(point, 6, Data.MaxFreqOffset[point]); } else if (parameters.Channel == "通道2") { WriteExcelData(sheet, parameters.PointIndex, 2, ModulationIndexPrint.Test_name, ModulationIndexPrint.Lower.ToString(), ModulationIndexPrint.Upper.ToString(), ModulationIndexPrint.TestVal.ToString(), ModulationIndexPrint.Result); WriteExcelData(sheet, parameters.PointIndex, 6, leftModulationIndexPrint.Test_name, leftModulationIndexPrint.Lower.ToString(), leftModulationIndexPrint.Upper.ToString(), leftModulationIndexPrint.TestVal.ToString(), leftModulationIndexPrint.Result); WriteExcelData(sheet, parameters.PointIndex, 10, rightModulationIndexPrint.Test_name, rightModulationIndexPrint.Lower.ToString(), rightModulationIndexPrint.Upper.ToString(), rightModulationIndexPrint.TestVal.ToString(), rightModulationIndexPrint.Result); WriteExcelData(sheet, parameters.PointIndex, 4, MaxFreqOffsetPrint.Test_name, "/", "/", MaxFreqOffsetPrint.TestVal.ToString(), MaxFreqOffsetPrint.Result); WriteExcelData(sheet, parameters.PointIndex, 8, leftFreqOffsetPrint.Test_name, "/", "/", leftFreqOffsetPrint.TestVal.ToString(), leftFreqOffsetPrint.Result); WriteExcelData(sheet, parameters.PointIndex, 11, rightFreqOffsetPrint.Test_name, "/", "/", rightFreqOffsetPrint.TestVal.ToString(), rightFreqOffsetPrint.Result); //tps.SetTestTableCellValue(point + 15, 9, ModulationIndexPrint.Result, Data.ModulationIndex[point]); //tps.SetTestTableCellValue(point + 15, 6, Data.MaxFreqOffset[point]); } } 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]; for (int i = 0; i < tracedatas.Length; 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 - 1); } Y_Maxvalue = Math.Round(Y_Maxvalue, 3); } 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 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 ReadParameters(Spire.Xls.Worksheet sheet, int rowIndex) { List ModulationTable = new List(); 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; } /// /// 一个调制指数的配置信息 /// public class MatchModulaPara { public Dictionary ModulaParameters; public MatchModulaPara() { ModulaParameters = new Dictionary(); } 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; } } /// /// 调制指数3个对应项 /// public class ModulationMatchParameter { /// /// 功率变化(dB) /// public string CfgRelative{ get; set; } /// /// 调制指数(mf) /// public string CfgModulation { get; set; } /// /// 最大频偏(KHz) /// public string CfgFreqOffset { get; set; } } public class ConfigParameter { /// /// 串口 /// public string ComPort { set; get; } /// /// 输出损耗 /// public double OutLoss { set; get; } /// /// 产品测试的起始频率 /// public double StartFrequency { set; get; } /// /// 产品测试的频率步进 /// public double StepFrequency { set; get; } /// /// 产品测试的频点数量 /// public int FrequencyNumber { set; get; } /// /// 产品的工作频带上限(终止频率) /// 功能:用于判断从起始频率按一定的步进测试是否超出产品工作频段上限 /// public double StopFrequency { set; get; } /// ///设置频谱仪的SPAN /// public string SPAN { set; get; } /// /// 设置参考电平 /// public string REF { set; get; } /// /// 设置RBW /// public string RBW { set; get; } /// /// 设置VBW /// public string VBW { set; get; } /// /// 控制延时 /// public int ControlDelay { set; get; } /// /// 调制系数下限 /// public double ModulationIndexLower { get; set; } /// ///调制系数上限 /// public double ModulationIndexUpper { get; set; } } public class OutData { /// ///调制系数 /// public string[] ModulationIndex { set; get; } /// ///主频左侧调制系数 /// public string[] leftModulationIndex { set; get; } /// ///主频右侧调制系数 /// public string[] rightModulationIndex { set; get; } /// /// 最大频偏 /// public string[] MaxFreqOffset { set; get; } /// /// FL频偏 /// public string[] leftFreqOffset { set; get; } /// /// FH频偏 /// public string[] rightFreqOffset { set; get; } } //public class DataType //{ // /// // /// 测试名称 // /// // public string Test_name { set; get; } // /// // /// 指标下限 // /// // public double Lower { set; get; } // /// // /// 指标上限 // /// // public double Upper { set; get; } // /// // /// 测试值 // /// // public double TestVal { set; get; } // /// // /// 判断结果 // /// // public bool Result { set; get; } //} } }