ModulationIndexAndMaxFreqOffset.cs 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Threading;
  6. using System.IO;
  7. using System.Threading.Tasks;
  8. using Tps_LQ_Transmitter.com;
  9. namespace Tps_LQ_Transmitter.models
  10. {
  11. class ModulationIndexAndMaxFreqOffset: BaseModel
  12. {
  13. public ModulationIndexAndMaxFreqOffset()
  14. {
  15. TemplateName = "调制指数及最大频偏指标测试";
  16. }
  17. /// <summary>
  18. /// 功率及频率稳定度测试
  19. /// </summary>
  20. public override bool Run(TestNode parameters)
  21. {
  22. double y_value, x_value;
  23. Random random = new Random();
  24. //获取仪器
  25. var SA = this.tps.GetDevice("频谱仪");
  26. TransmitterSerialPort SerialClient = new TransmitterSerialPort();
  27. OutData Data = new OutData();
  28. DataType ModulationIndexPrint = new DataType();
  29. DataType leftModulationIndexPrint = new DataType();
  30. DataType rightModulationIndexPrint = new DataType();
  31. DataType MaxFreqOffsetPrint = new DataType();
  32. DataType leftFreqOffsetPrint = new DataType();
  33. DataType rightFreqOffsetPrint = new DataType();
  34. if (SA == null)
  35. {
  36. ShowMessage(MsgType.Error, string.Format("仪器不齐全,{0}/{1}无法运行", parameters.Channel, parameters.Name));
  37. return false;
  38. }
  39. OpenExcel("调制系数", out Spire.Xls.Workbook workbook, out Spire.Xls.Worksheet sheet);
  40. if (sheet == null)
  41. {
  42. ShowMessage(MsgType.Error, "找不到" + tps.TestProject + "模板.xlsx");
  43. return false;
  44. }
  45. MatchModulaPara CfigModuParas = new MatchModulaPara();
  46. CfigModuParas = LoadModulationWorkBook();
  47. if (CfigModuParas == null)
  48. {
  49. return false;
  50. }
  51. ConfigParameter PowerPara = new ConfigParameter();
  52. PowerPara.StepFrequency = 0;
  53. PowerPara.ComPort = parameters.Parameters.GetParameter<string>("串口");
  54. PowerPara.OutLoss = parameters.Parameters.GetParameter<double>("输出损耗");
  55. PowerPara.StartFrequency = parameters.Parameters.GetParameter<double>("起始频率");
  56. PowerPara.StepFrequency = parameters.Parameters.GetParameter<double>("频率步进");
  57. PowerPara.FrequencyNumber = parameters.Parameters.GetParameter<int>("频点数量");
  58. PowerPara.StopFrequency = parameters.Parameters.GetParameter<double>("终止频率");
  59. PowerPara.SPAN = parameters.Parameters.GetParameter<string>("扫描带宽(SPAN)");
  60. PowerPara.REF = parameters.Parameters.GetParameter<string>("参考电平(REF)");
  61. PowerPara.RBW = parameters.Parameters.GetParameter<string>("分辨率带宽(RBW)");
  62. PowerPara.VBW = parameters.Parameters.GetParameter<string>("视频带宽(VBW)");
  63. PowerPara.ControlDelay = parameters.Parameters.GetParameter<int>("控制延时");
  64. PowerPara.ModulationIndexLower = parameters.Parameters.GetParameter<double>("调制系数下限");
  65. PowerPara.ModulationIndexUpper = parameters.Parameters.GetParameter<double>("调制系数上限");
  66. if ((PowerPara.StartFrequency == 0) || (PowerPara.StopFrequency == 0)
  67. || (PowerPara.SPAN == null) || (PowerPara.REF == null) || (PowerPara.RBW == null) || (PowerPara.VBW == null)||
  68. (PowerPara.ModulationIndexLower==0) || (PowerPara.ModulationIndexUpper==0))
  69. {
  70. ShowMessage(MsgType.Error, string.Format("配置文件中频率参数为空,{0}/{1}无法运行", parameters.Channel, parameters.Name));
  71. return false;
  72. }
  73. if (PowerPara.ControlDelay == 0)
  74. {
  75. PowerPara.ControlDelay = 10;
  76. }
  77. if (true)//需具备仪器
  78. {
  79. SA.Write("仪器复位"); SA.Query("OPC");
  80. SA.Write("SPAN", PowerPara.SPAN); SA.Query("OPC");
  81. SA.Write("RBW", PowerPara.RBW); SA.Query("OPC");
  82. SA.Write("VBW", PowerPara.VBW); SA.Query("OPC");
  83. SA.Write("REF", PowerPara.REF); SA.Query("OPC");
  84. SA.Write("MARK打开", "1"); SA.Query("OPC");
  85. SA.Write("MARK打开", "2"); SA.Query("OPC");
  86. SA.Write("MARK打开", "3"); SA.Query("OPC");
  87. SA.Write("DELT打开", "2"); SA.Query("OPC");
  88. SA.Write("DELT打开", "3"); SA.Query("OPC");
  89. }
  90. if ((PowerPara.FrequencyNumber != 0) && (PowerPara.FrequencyNumber != 1) && (PowerPara.StepFrequency == 0))
  91. {
  92. PowerPara.StepFrequency = ((int)(((PowerPara.StopFrequency - PowerPara.StartFrequency) / (PowerPara.FrequencyNumber - 1)) * 100)) / 100;
  93. }
  94. if(PowerPara.StepFrequency != 0)
  95. {
  96. PowerPara.FrequencyNumber = ((int)((PowerPara.StopFrequency - PowerPara.StartFrequency) / PowerPara.StepFrequency)) + 1;
  97. }
  98. double CenterFreq;
  99. double[] PowerDeltleft = new double[PowerPara.FrequencyNumber];
  100. double[] PowerDeltright = new double[PowerPara.FrequencyNumber];
  101. Data.ModulationIndex = new string[PowerPara.FrequencyNumber];
  102. Data.leftModulationIndex = new string[PowerPara.FrequencyNumber];
  103. Data.rightModulationIndex = new string[PowerPara.FrequencyNumber];
  104. Data.MaxFreqOffset = new string[PowerPara.FrequencyNumber];
  105. Data.leftFreqOffset = new string[PowerPara.FrequencyNumber];
  106. Data.rightFreqOffset = new string[PowerPara.FrequencyNumber];
  107. for (int point = 0;; point++)
  108. {
  109. CenterFreq = PowerPara.StartFrequency + PowerPara.StepFrequency * point;
  110. if (CenterFreq > PowerPara.StopFrequency ||( PowerPara.FrequencyNumber == 1 && point == 1))
  111. {
  112. break;
  113. }
  114. if(true)//需具备仪器
  115. {
  116. // 控制
  117. // SerialClient.DUT_Transmitter_Ctrol(PowerPara.ComPort, Convert.ToByte(point + 1));
  118. Thread.Sleep(PowerPara.ControlDelay);//单位ms
  119. SA.Write("CENTER", CenterFreq.ToString()); SA.Query("OPC");
  120. SA.Write("SingleOrCont", "0"); SA.Query("OPC");
  121. SA.Write("单次扫描"); SA.Query("OPC");
  122. SA.Write("PEAK", "1"); SA.Query("OPC");
  123. SA.Write("PEAK", "2"); SA.Query("OPC");
  124. SA.Write("PEAK", "3"); SA.Query("OPC");
  125. if (SA.Query("IDN").Contains("N9030"))//N9030A型号频谱仪
  126. {
  127. SA.Write("DELT打开", "2"); SA.Query("OPC");
  128. SA.Write("NextPeakLeft", "2"); SA.Query("OPC");
  129. PowerDeltleft[point] = double.Parse(SA.Query("读MARK功率", "2")); SA.Query("OPC");
  130. SA.Write("DELT打开", "3"); SA.Query("OPC");
  131. SA.Write("NextPeakRight", "3"); SA.Query("OPC");
  132. PowerDeltright[point] = double.Parse(SA.Query("读MARK功率", "3")); SA.Query("OPC");
  133. }
  134. else//其他型号频谱仪
  135. {
  136. SA.Write("NextPeakLeft", "2"); SA.Query("OPC");
  137. PowerDeltleft[point] = double.Parse(SA.Query("读DELT功率", "2")); SA.Query("OPC");
  138. SA.Write("NextPeakRight", "3"); SA.Query("OPC");
  139. PowerDeltright[point] = double.Parse(SA.Query("读DELT功率", "3")); SA.Query("OPC");
  140. }
  141. }
  142. // PowerDelt[point] = random.Next(500, 1200) / 100.0;//随机数
  143. double temp = 30;
  144. string RelativeVal= "0";
  145. foreach (KeyValuePair<string, ModulationMatchParameter> kvp in CfigModuParas.ModulaParameters)
  146. {
  147. if ((Math.Abs(Math.Abs(PowerDeltleft[point]) - double.Parse(kvp.Value.CfgRelative))) < temp)
  148. {
  149. temp = Math.Abs(Math.Abs(PowerDeltleft[point]) - double.Parse(kvp.Value.CfgRelative));
  150. RelativeVal = kvp.Value.CfgRelative;
  151. }
  152. }
  153. Data.leftModulationIndex[point] = CfigModuParas.GetModulaParameter(RelativeVal);//左侧调制系数
  154. Data.leftFreqOffset[point] = CfigModuParas.GetFreqOffsetParameter(RelativeVal);//左侧最大频偏
  155. temp = 30;
  156. RelativeVal = "0";
  157. foreach (KeyValuePair<string, ModulationMatchParameter> kvp in CfigModuParas.ModulaParameters)
  158. {
  159. if ((Math.Abs(Math.Abs(PowerDeltright[point]) - double.Parse(kvp.Value.CfgRelative))) < temp)
  160. {
  161. temp = Math.Abs(Math.Abs(PowerDeltright[point]) - double.Parse(kvp.Value.CfgRelative));
  162. RelativeVal = kvp.Value.CfgRelative;
  163. }
  164. }
  165. Data.rightModulationIndex[point] = CfigModuParas.GetModulaParameter(RelativeVal);//右侧调制系数
  166. Data.rightFreqOffset[point] = CfigModuParas.GetFreqOffsetParameter(RelativeVal);//右侧最大频偏
  167. Data.ModulationIndex[point] = Math.Min(double.Parse(Data.leftModulationIndex[point]), double.Parse(Data.rightModulationIndex[point])).ToString();//调制系数
  168. Data.MaxFreqOffset[point] = Math.Min(double.Parse(Data.leftFreqOffset[point]), double.Parse(Data.rightFreqOffset[point])).ToString();//最大频偏
  169. ModulationIndexPrint.Test_name = parameters.Channel + "-调制系数测试-" + CenterFreq.ToString() + "MHz";
  170. leftModulationIndexPrint.Test_name = parameters.Channel + "-fL调制系数测试-" + CenterFreq.ToString() + "MHz";
  171. rightModulationIndexPrint.Test_name = parameters.Channel + "-fH调制系数测试-" + CenterFreq.ToString() + "MHz";
  172. MaxFreqOffsetPrint.Test_name = parameters.Channel + "-最大频偏(KHz)-" + CenterFreq.ToString() + "MHz";
  173. leftFreqOffsetPrint.Test_name = parameters.Channel + "-fL(KHz)-" + CenterFreq.ToString() + "MHz";
  174. rightFreqOffsetPrint.Test_name = parameters.Channel + "-fH(KHz)-" + CenterFreq.ToString() + "MHz";
  175. ModulationIndexPrint.Lower = PowerPara.ModulationIndexLower;
  176. ModulationIndexPrint.Upper = PowerPara.ModulationIndexUpper;
  177. ModulationIndexPrint.TestVal = double.Parse(Data.ModulationIndex[point]);
  178. leftModulationIndexPrint.TestVal = double.Parse(Data.leftModulationIndex[point]);
  179. rightModulationIndexPrint.TestVal = double.Parse(Data.rightModulationIndex[point]);
  180. MaxFreqOffsetPrint.TestVal = double.Parse(Data.MaxFreqOffset[point]);
  181. leftFreqOffsetPrint.TestVal = double.Parse(Data.leftFreqOffset[point]);
  182. rightFreqOffsetPrint.TestVal = double.Parse(Data.rightFreqOffset[point]);
  183. if (ModulationIndexPrint.TestVal >= ModulationIndexPrint.Lower && ModulationIndexPrint.TestVal <= ModulationIndexPrint.Upper)
  184. {
  185. ModulationIndexPrint.Result = "是";
  186. MaxFreqOffsetPrint.Result = "是";
  187. }
  188. else
  189. {
  190. ModulationIndexPrint.Result = "否";
  191. MaxFreqOffsetPrint.Result = "否";
  192. }
  193. if (leftModulationIndexPrint.TestVal >= ModulationIndexPrint.Lower && leftModulationIndexPrint.TestVal <= ModulationIndexPrint.Upper)
  194. {
  195. leftModulationIndexPrint.Result = "是";
  196. leftFreqOffsetPrint.Result = "是";
  197. }
  198. else
  199. {
  200. leftModulationIndexPrint.Result = "否";
  201. leftFreqOffsetPrint.Result = "否";
  202. }
  203. if (rightModulationIndexPrint.TestVal >= ModulationIndexPrint.Lower && rightModulationIndexPrint.TestVal <= ModulationIndexPrint.Upper)
  204. {
  205. rightModulationIndexPrint.Result = "是";
  206. rightFreqOffsetPrint.Result = "是";
  207. }
  208. else
  209. {
  210. rightModulationIndexPrint.Result = "否";
  211. rightFreqOffsetPrint.Result = "否";
  212. }
  213. tps.TestTableAddCell(MaxFreqOffsetPrint.Test_name, leftFreqOffsetPrint.Lower.ToString(), leftFreqOffsetPrint.Upper.ToString(), MaxFreqOffsetPrint.TestVal.ToString(), MaxFreqOffsetPrint.Result);
  214. tps.TestTableAddCell(leftFreqOffsetPrint.Test_name, leftFreqOffsetPrint.Lower.ToString(), leftFreqOffsetPrint.Upper.ToString(), leftFreqOffsetPrint.TestVal.ToString(), leftFreqOffsetPrint.Result);
  215. tps.TestTableAddCell(rightFreqOffsetPrint.Test_name, rightFreqOffsetPrint.Lower.ToString(), rightFreqOffsetPrint.Upper.ToString(), rightFreqOffsetPrint.TestVal.ToString(), rightFreqOffsetPrint.Result);
  216. tps.TestTableAddCell(ModulationIndexPrint.Test_name, ModulationIndexPrint.Lower.ToString(), ModulationIndexPrint.Upper.ToString(), ModulationIndexPrint.TestVal.ToString(), ModulationIndexPrint.Result);
  217. tps.TestTableAddCell(leftModulationIndexPrint.Test_name, ModulationIndexPrint.Lower.ToString(), ModulationIndexPrint.Upper.ToString(), leftModulationIndexPrint.TestVal.ToString(), leftModulationIndexPrint.Result);
  218. tps.TestTableAddCell(rightModulationIndexPrint.Test_name, ModulationIndexPrint.Lower.ToString(), ModulationIndexPrint.Upper.ToString(), rightModulationIndexPrint.TestVal.ToString(), rightModulationIndexPrint.Result);
  219. if (parameters.Channel == "通道1")
  220. {
  221. //tps.SetTestTableCellValue(point, 9, ModulationIndexPrint.Result,Data.ModulationIndex[point]);
  222. WriteExcelData(sheet, point, 1, ModulationIndexPrint.Test_name, ModulationIndexPrint.Lower.ToString(), ModulationIndexPrint.Upper.ToString(), ModulationIndexPrint.TestVal.ToString(), ModulationIndexPrint.Result);
  223. WriteExcelData(sheet, point, 5, leftModulationIndexPrint.Test_name, leftModulationIndexPrint.Lower.ToString(), leftModulationIndexPrint.Upper.ToString(), leftModulationIndexPrint.TestVal.ToString(), leftModulationIndexPrint.Result);
  224. WriteExcelData(sheet, point, 9, rightModulationIndexPrint.Test_name, rightModulationIndexPrint.Lower.ToString(), rightModulationIndexPrint.Upper.ToString(), rightModulationIndexPrint.TestVal.ToString(), rightModulationIndexPrint.Result);
  225. WriteExcelData(sheet, point, 3, MaxFreqOffsetPrint.Test_name, MaxFreqOffsetPrint.Lower.ToString(), MaxFreqOffsetPrint.Upper.ToString(), MaxFreqOffsetPrint.TestVal.ToString(), MaxFreqOffsetPrint.Result);
  226. WriteExcelData(sheet, point, 7, leftFreqOffsetPrint.Test_name, leftFreqOffsetPrint.Lower.ToString(), leftFreqOffsetPrint.Upper.ToString(), leftFreqOffsetPrint.TestVal.ToString(), leftFreqOffsetPrint.Result);
  227. WriteExcelData(sheet, point, 11, rightFreqOffsetPrint.Test_name, rightFreqOffsetPrint.Lower.ToString(), rightFreqOffsetPrint.Upper.ToString(), rightFreqOffsetPrint.TestVal.ToString(), rightFreqOffsetPrint.Result);
  228. // tps.SetTestTableCellValue(point, 6, Data.MaxFreqOffset[point]);
  229. }
  230. else if (parameters.Channel == "通道2")
  231. {
  232. WriteExcelData(sheet, point, 2, ModulationIndexPrint.Test_name, ModulationIndexPrint.Lower.ToString(), ModulationIndexPrint.Upper.ToString(), ModulationIndexPrint.TestVal.ToString(), ModulationIndexPrint.Result);
  233. WriteExcelData(sheet, point, 6, leftModulationIndexPrint.Test_name, leftModulationIndexPrint.Lower.ToString(), leftModulationIndexPrint.Upper.ToString(), leftModulationIndexPrint.TestVal.ToString(), leftModulationIndexPrint.Result);
  234. WriteExcelData(sheet, point, 10, rightModulationIndexPrint.Test_name, rightModulationIndexPrint.Lower.ToString(), rightModulationIndexPrint.Upper.ToString(), rightModulationIndexPrint.TestVal.ToString(), rightModulationIndexPrint.Result);
  235. WriteExcelData(sheet, point, 4, MaxFreqOffsetPrint.Test_name, MaxFreqOffsetPrint.Lower.ToString(), MaxFreqOffsetPrint.Upper.ToString(), MaxFreqOffsetPrint.TestVal.ToString(), MaxFreqOffsetPrint.Result);
  236. WriteExcelData(sheet, point, 8, leftFreqOffsetPrint.Test_name, leftFreqOffsetPrint.Lower.ToString(), leftFreqOffsetPrint.Upper.ToString(), leftFreqOffsetPrint.TestVal.ToString(), leftFreqOffsetPrint.Result);
  237. WriteExcelData(sheet, point, 11, rightFreqOffsetPrint.Test_name, rightFreqOffsetPrint.Lower.ToString(), rightFreqOffsetPrint.Upper.ToString(), rightFreqOffsetPrint.TestVal.ToString(), rightFreqOffsetPrint.Result);
  238. //tps.SetTestTableCellValue(point + 15, 9, ModulationIndexPrint.Result, Data.ModulationIndex[point]);
  239. //tps.SetTestTableCellValue(point + 15, 6, Data.MaxFreqOffset[point]);
  240. }
  241. }
  242. SaveExcel(workbook);
  243. return true;
  244. }
  245. public void PsaPeakValue_Tracedata(AppLibs.Devices.IVISA psa, out double Y_Maxvalue, out double X_Maxvalue, bool IsReturnX = false)
  246. {
  247. System.Threading.Thread.Sleep(20);
  248. X_Maxvalue = 0;
  249. Y_Maxvalue = 0;
  250. psa.Write("单次扫描");
  251. psa.Query("OPC");
  252. string tracedata = psa.Query("读曲线");
  253. string[] tracedatas = tracedata.Split(',');
  254. double[] tracedata_double = new double[tracedatas.Length];
  255. for (int i = 0; i < tracedatas.Length; i++)
  256. {
  257. tracedata_double[i] = double.Parse(tracedatas[i]);
  258. }
  259. Y_Maxvalue = tracedata_double.Max();
  260. if (IsReturnX)
  261. {
  262. int x = Array.IndexOf(tracedata_double, Y_Maxvalue);
  263. double startfreq = double.Parse(psa.Query("读起始频率"));
  264. double stopfreq = double.Parse(psa.Query("读截止频率"));
  265. double counts = double.Parse(psa.Query("测试点数读取"));
  266. X_Maxvalue = startfreq + (stopfreq - startfreq) * x / (counts - 1);
  267. }
  268. Y_Maxvalue = Math.Round(Y_Maxvalue, 3);
  269. }
  270. public MatchModulaPara LoadModulationWorkBook()
  271. {
  272. MatchModulaPara pars = new MatchModulaPara();
  273. string FileName = Path.Combine(Bundle.bundle.BundleDir, "config\\ModulationMode.xlsx");
  274. if (!File.Exists(FileName))
  275. {
  276. ShowMessage(MsgType.Error, "找不到ModulationMode.xlsx");
  277. return null;
  278. }
  279. Spire.Xls.Workbook workbook = new Spire.Xls.Workbook();
  280. workbook.LoadFromFile(FileName);
  281. //获取第一个工作表sheet1
  282. Spire.Xls.Worksheet sheet = workbook.Worksheets[0];
  283. int num = 0;
  284. int blankRows = 0;
  285. while (num++ < 200)
  286. {
  287. //索引从1开始
  288. string col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : "";
  289. col1 = col1.Trim();
  290. if (string.IsNullOrEmpty(col1))
  291. {
  292. blankRows++;
  293. if (blankRows > 5)
  294. {
  295. //连续5个空行以上则退出
  296. break;
  297. }
  298. }
  299. else
  300. {
  301. blankRows = 0;
  302. }
  303. if (col1.Equals("功率变化(dB)"))
  304. {
  305. List<ModulationMatchParameter> ModulationTable = ReadParameters(sheet, num);
  306. foreach (var item in ModulationTable)
  307. {
  308. if (pars.ModulaParameters.ContainsKey(item.CfgRelative))
  309. {
  310. ShowMessage(MsgType.Error, string.Format("调制对应表:{0} 存在同名参数:{1},无法重复添加参数", sheet.Name, item.CfgRelative));
  311. continue;
  312. }
  313. pars.ModulaParameters.Add(item.CfgRelative, item);
  314. }
  315. }
  316. }
  317. return pars;
  318. }
  319. List<ModulationMatchParameter> ReadParameters(Spire.Xls.Worksheet sheet, int rowIndex)
  320. {
  321. List<ModulationMatchParameter> ModulationTable = new List<ModulationMatchParameter>();
  322. string col1 = sheet.Range[rowIndex , 1].Value2 != null ? sheet.Range[rowIndex , 1].Value2.ToString() : "";
  323. string col2 = sheet.Range[rowIndex , 2].Value2 != null ? sheet.Range[rowIndex , 2].Value2.ToString() : "";
  324. string col3 = sheet.Range[rowIndex , 3].Value2 != null ? sheet.Range[rowIndex , 3].Value2.ToString() : "";
  325. if (!(col1 == "功率变化(dB)" && col2 == "调制指数(mf)" && col3 == "最大频偏(KHz)"))
  326. {
  327. ShowMessage(MsgType.Error, "'调制对应表'行首标题位置和格式不正确");
  328. return ModulationTable;
  329. }
  330. int num = rowIndex ;
  331. //默认最多30行
  332. while (num++ < rowIndex + 100)
  333. {
  334. col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : "";
  335. col2 = sheet.Range[num, 2].Value2 != null ? sheet.Range[num, 2].Value2.ToString() : "";
  336. col3 = sheet.Range[num, 3].Value2 != null ? sheet.Range[num, 3].Value2.ToString() : "";
  337. if (string.IsNullOrEmpty(col1) || string.IsNullOrEmpty(col2) || string.IsNullOrEmpty(col3))
  338. {
  339. break;
  340. }
  341. ModulationMatchParameter ObjModulation = new ModulationMatchParameter();
  342. ObjModulation.CfgRelative = col1;
  343. ObjModulation.CfgModulation = col2;
  344. ObjModulation.CfgFreqOffset = col3;
  345. ModulationTable.Add(ObjModulation);
  346. }
  347. return ModulationTable;
  348. }
  349. /// <summary>
  350. /// 一个调制指数的配置信息
  351. /// </summary>
  352. public class MatchModulaPara
  353. {
  354. public Dictionary<string, ModulationMatchParameter> ModulaParameters;
  355. public MatchModulaPara()
  356. {
  357. ModulaParameters = new Dictionary<string, ModulationMatchParameter>();
  358. }
  359. public string GetModulaParameter(string name)
  360. {
  361. if (string.IsNullOrEmpty(name))
  362. return null;
  363. if (this.ModulaParameters.ContainsKey(name) == false)
  364. return null;
  365. string val1 = this.ModulaParameters[name].CfgModulation.Trim();
  366. return val1;
  367. }
  368. public string GetFreqOffsetParameter(string name)
  369. {
  370. if (string.IsNullOrEmpty(name))
  371. return null;
  372. if (this.ModulaParameters.ContainsKey(name) == false)
  373. return null;
  374. string val2 = this.ModulaParameters[name].CfgFreqOffset.Trim();
  375. return val2;
  376. }
  377. }
  378. /// <summary>
  379. /// 调制指数3个对应项
  380. /// </summary>
  381. public class ModulationMatchParameter
  382. {
  383. /// <summary>
  384. /// 功率变化(dB)
  385. /// </summary>
  386. public string CfgRelative{ get; set; }
  387. /// <summary>
  388. /// 调制指数(mf)
  389. /// </summary>
  390. public string CfgModulation { get; set; }
  391. /// <summary>
  392. /// 最大频偏(KHz)
  393. /// </summary>
  394. public string CfgFreqOffset { get; set; }
  395. }
  396. public class ConfigParameter
  397. {
  398. /// <summary>
  399. /// 串口
  400. /// </summary>
  401. public string ComPort { set; get; }
  402. /// <summary>
  403. /// 输出损耗
  404. /// </summary>
  405. public double OutLoss { set; get; }
  406. /// <summary>
  407. /// 产品测试的起始频率
  408. /// </summary>
  409. public double StartFrequency { set; get; }
  410. /// <summary>
  411. /// 产品测试的频率步进
  412. /// </summary>
  413. public double StepFrequency { set; get; }
  414. /// <summary>
  415. /// 产品测试的频点数量
  416. /// </summary>
  417. public int FrequencyNumber { set; get; }
  418. /// <summary>
  419. /// 产品的工作频带上限(终止频率)
  420. /// 功能:用于判断从起始频率按一定的步进测试是否超出产品工作频段上限
  421. /// </summary>
  422. public double StopFrequency { set; get; }
  423. /// <summary>
  424. ///设置频谱仪的SPAN
  425. /// </summary>
  426. public string SPAN { set; get; }
  427. /// <summary>
  428. /// 设置参考电平
  429. /// </summary>
  430. public string REF { set; get; }
  431. /// <summary>
  432. /// 设置RBW
  433. /// </summary>
  434. public string RBW { set; get; }
  435. /// <summary>
  436. /// 设置VBW
  437. /// </summary>
  438. public string VBW { set; get; }
  439. /// <summary>
  440. /// 控制延时
  441. /// </summary>
  442. public int ControlDelay { set; get; }
  443. /// <summary>
  444. /// 调制系数下限
  445. /// </summary>
  446. public double ModulationIndexLower { get; set; }
  447. /// <summary>
  448. ///调制系数上限
  449. /// </summary>
  450. public double ModulationIndexUpper { get; set; }
  451. }
  452. public class OutData
  453. {
  454. /// <summary>
  455. ///调制系数
  456. /// </summary>
  457. public string[] ModulationIndex { set; get; }
  458. /// <summary>
  459. ///主频左侧调制系数
  460. /// </summary>
  461. public string[] leftModulationIndex { set; get; }
  462. /// <summary>
  463. ///主频右侧调制系数
  464. /// </summary>
  465. public string[] rightModulationIndex { set; get; }
  466. /// <summary>
  467. /// 最大频偏
  468. /// </summary>
  469. public string[] MaxFreqOffset { set; get; }
  470. /// <summary>
  471. /// FL频偏
  472. /// </summary>
  473. public string[] leftFreqOffset { set; get; }
  474. /// <summary>
  475. /// FH频偏
  476. /// </summary>
  477. public string[] rightFreqOffset { set; get; }
  478. }
  479. //public class DataType
  480. //{
  481. // /// <summary>
  482. // /// 测试名称
  483. // /// </summary>
  484. // public string Test_name { set; get; }
  485. // /// <summary>
  486. // /// 指标下限
  487. // /// </summary>
  488. // public double Lower { set; get; }
  489. // /// <summary>
  490. // /// 指标上限
  491. // /// </summary>
  492. // public double Upper { set; get; }
  493. // /// <summary>
  494. // /// 测试值
  495. // /// </summary>
  496. // public double TestVal { set; get; }
  497. // /// <summary>
  498. // /// 判断结果
  499. // /// </summary>
  500. // public bool Result { set; get; }
  501. //}
  502. }
  503. }