PowerAndFreqStability.cs 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Threading;
  6. using System.Threading.Tasks;
  7. using Tps_LQ_Transmitter.com;
  8. namespace Tps_LQ_Transmitter.models
  9. {
  10. class PowerAndFreqStability: BaseModel
  11. {
  12. double[,] WTempPowerVal;
  13. double[,] dBTempPowerVal;
  14. string serial = "****";
  15. public PowerAndFreqStability()
  16. {
  17. TemplateName = "功率及频率稳定度测试";
  18. }
  19. /// <summary>
  20. /// 功率及频率稳定度测试
  21. /// </summary>
  22. public override bool Run(TestNode parameters)
  23. {
  24. double y_value, x_value;
  25. Random random = new Random();
  26. //获取仪器
  27. var SA = this.tps.GetDevice("频谱仪");
  28. TransmitterSerialPort SerialClient = new TransmitterSerialPort();
  29. PowerAndFreqStabilityOutData Data = new PowerAndFreqStabilityOutData();
  30. DataType PowerPrint = new DataType();//功率(dBm)
  31. DataType FreqPrint = new DataType();//实测频率
  32. DataType FreqAccuracyPrint = new DataType();//频率稳定度
  33. DataType PowerSumPrint = new DataType();//两路功率总和(w)
  34. DataType PowerFlatnessPrint = new DataType();//两路功率不平度(dB)
  35. if (SA == null)
  36. {
  37. ShowMessage(MsgType.Error, string.Format("仪器不齐全,{0}/{1}无法运行", parameters.Channel, parameters.Name));
  38. return false;
  39. }
  40. // y_value = double.Parse(SA.Query("读通道功率"));
  41. OpenExcel("功率及频率稳定度", out Spire.Xls.Workbook workbook, out Spire.Xls.Worksheet sheet);
  42. if (sheet == null)
  43. {
  44. ShowMessage(MsgType.Error, "找不到" + tps.TestProject + "模板.xlsx");
  45. return false;
  46. }
  47. ConfigParameter PowerPara = new ConfigParameter();
  48. PowerPara.ComPort = parameters.Parameters.GetParameter<string>("串口");
  49. PowerPara.OutLoss = parameters.Parameters.GetParameter<double>("输出损耗");
  50. PowerPara.StartFrequency = parameters.Parameters.GetParameter<double>("起始频率");
  51. PowerPara.StepFrequency = parameters.Parameters.GetParameter<double>("频率步进");
  52. PowerPara.FrequencyNumber = parameters.Parameters.GetParameter<int>("频点数量");
  53. PowerPara.StopFrequency = parameters.Parameters.GetParameter<double>("终止频率");
  54. PowerPara.SPAN = parameters.Parameters.GetParameter<string>("扫描带宽(SPAN)");
  55. PowerPara.ACHBand = parameters.Parameters.GetParameter<string>("通道带宽");
  56. PowerPara.REF = parameters.Parameters.GetParameter<string>("参考电平(REF)");
  57. PowerPara.RBW = parameters.Parameters.GetParameter<string>("分辨率带宽(RBW)");
  58. PowerPara.VBW = parameters.Parameters.GetParameter<string>("视频带宽(VBW)");
  59. PowerPara.ControlDelay = parameters.Parameters.GetParameter<int>("控制延时");
  60. PowerPara.PowerLower = parameters.Parameters.GetParameter<double>("功率下限");
  61. PowerPara.PowerUpper = parameters.Parameters.GetParameter<double>("功率上限");
  62. PowerPara.FreqAccuracyUpper = parameters.Parameters.GetParameter<double>("频率稳定度上限");
  63. PowerPara.PowerSumLower = parameters.Parameters.GetParameter<double>("两路功率总和下限");
  64. PowerPara.PowerFlatnessUpper = parameters.Parameters.GetParameter<double>("功率不平度上限");
  65. if ((PowerPara.StartFrequency == 0) || ((PowerPara.StepFrequency == 0) && (PowerPara.FrequencyNumber == 0)) || (PowerPara.StopFrequency == 0)
  66. || (PowerPara.SPAN == null) || (PowerPara.REF == null) || (PowerPara.RBW == null) || (PowerPara.VBW == null) || (PowerPara.PowerLower == 0)
  67. || (PowerPara.PowerUpper == 0) || (PowerPara.FreqAccuracyUpper == 0) ||(PowerPara.PowerSumLower == 0) || (PowerPara.PowerFlatnessUpper == 0))
  68. {
  69. ShowMessage(MsgType.Error, string.Format("配置文件中频率参数为空,{0}/{1}无法运行", parameters.Channel, parameters.Name));
  70. return false;
  71. }
  72. if (PowerPara.ControlDelay == 0)
  73. {
  74. PowerPara.ControlDelay = 10;
  75. }
  76. if(true)//需具备仪器
  77. {
  78. SA.Write("仪器复位"); SA.Query("OPC");
  79. SA.Write("SPAN", PowerPara.SPAN); SA.Query("OPC");
  80. SA.Write("RBW", PowerPara.RBW); SA.Query("OPC");
  81. SA.Write("VBW", PowerPara.VBW); SA.Query("OPC");
  82. SA.Write("REF", PowerPara.REF); SA.Query("OPC");
  83. if (SA.Query("IDN").Contains("N9030"))
  84. {
  85. SA.Write("设置通道SPAN", PowerPara.SPAN); SA.Query("OPC");
  86. }
  87. SA.Write("设置通道带宽", PowerPara.ACHBand); SA.Query("OPC");
  88. SA.Write("SingleOrCont", "0"); 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. Data.Power = new double[PowerPara.FrequencyNumber];
  100. Data.Freq = new double[PowerPara.FrequencyNumber];
  101. Data.FreqAccuracy = new double[PowerPara.FrequencyNumber];
  102. if (tps.Serial != serial)
  103. {
  104. WTempPowerVal = new double[2, PowerPara.FrequencyNumber] ;
  105. dBTempPowerVal = new double[2, PowerPara.FrequencyNumber];
  106. serial = tps.Serial;
  107. for (int initVal1 = 0; initVal1 < 2; initVal1++)
  108. {
  109. for (int initVal2 = 0; initVal2 < PowerPara.FrequencyNumber; initVal2++)
  110. {
  111. WTempPowerVal[initVal1, initVal2] = -100;
  112. dBTempPowerVal[initVal1, initVal2] = -100;
  113. }
  114. }
  115. }
  116. for (int point = 0; ; point++)
  117. {
  118. CenterFreq = PowerPara.StartFrequency + PowerPara.StepFrequency * point;
  119. if (CenterFreq > PowerPara.StopFrequency || (PowerPara.FrequencyNumber == 1 && point == 1))
  120. {
  121. break;
  122. }
  123. if (true)//需具备仪器
  124. {
  125. //控制
  126. // SerialClient.DUT_Transmitter_Ctrol(PowerPara.ComPort, Convert.ToByte(point + 1));
  127. Thread.Sleep(PowerPara.ControlDelay);//单位ms
  128. SA.Write("CENTER", CenterFreq.ToString()); SA.Query("OPC");
  129. SA.Write("单次扫描"); SA.Query("OPC");
  130. SA.Write("设置通道功率模式"); SA.Query("OPC");
  131. if (SA.Query("IDN").Contains("N9030"))
  132. {
  133. PsaPeakValue_CHTracedata(SA, out y_value, out x_value, true);
  134. y_value = double.Parse(SA.Query("读通道功率").Split(',')[0]);
  135. }
  136. else
  137. {
  138. PsaPeakValue_CHTracedata(SA, out y_value, out x_value, true);
  139. y_value = double.Parse(SA.Query("读通道功率"));
  140. }
  141. Data.Power[point] = y_value + PowerPara.OutLoss;//功率
  142. }
  143. //Data.Power[point] = random.Next(3000, 4000) / 100.0;//随机数
  144. PowerPrint.Test_name = parameters.Channel + "-功率测试(W)-" + CenterFreq.ToString() + "MHz";
  145. PowerPrint.Lower = PowerPara.PowerLower;
  146. PowerPrint.Upper = PowerPara.PowerUpper;
  147. PowerPrint.TestVal = Math.Round(Math.Pow(10, (Data.Power[point] / 10)) / 1000, 2);//功率W
  148. if ((PowerPrint.TestVal >= PowerPrint.Lower) && (PowerPrint.TestVal <= PowerPrint.Upper))
  149. {
  150. PowerPrint.Result = "是";
  151. }
  152. else
  153. {
  154. PowerPrint.Result = "否";
  155. }
  156. FreqPrint.Test_name = parameters.Channel + "-频率测试(MHz)-" + CenterFreq.ToString() + "MHz";
  157. FreqPrint.Lower =Math.Round(0-((PowerPara.FreqAccuracyUpper * CenterFreq) + CenterFreq),2);
  158. FreqPrint.Upper = Math.Round((PowerPara.FreqAccuracyUpper * CenterFreq) + CenterFreq,2);
  159. FreqPrint.TestVal = Math.Round(x_value / 1000000, 3);//实测频率
  160. //FreqPrint.TestVal = random.Next(-600, 6000) / 100.0 + CenterFreq;//随机数
  161. if ((FreqPrint.TestVal >= FreqPrint.Lower) && (FreqPrint.TestVal <= FreqPrint.Upper))
  162. {
  163. FreqPrint.Result = "是";
  164. }
  165. else
  166. {
  167. FreqPrint.Result = "否";
  168. }
  169. FreqAccuracyPrint.Test_name = parameters.Channel + "-频率稳定度测试-" + CenterFreq.ToString() + "MHz";
  170. FreqAccuracyPrint.Upper = PowerPara.FreqAccuracyUpper;
  171. FreqAccuracyPrint.TestVal = Math.Round(Math.Abs(x_value - CenterFreq * 1000000) / (CenterFreq * 1000000), 6);//频率稳定度
  172. //FreqAccuracyPrint.TestVal = Math.Round(Math.Abs((random.Next(-600, 6000) / 100.0 + CenterFreq)*1000000 - CenterFreq * 1000000) / (CenterFreq * 1000000), 6);//随机数
  173. if (FreqAccuracyPrint.TestVal <= FreqAccuracyPrint.Upper)
  174. {
  175. FreqAccuracyPrint.Result = "是";
  176. }
  177. else
  178. {
  179. FreqAccuracyPrint.Result = "否";
  180. }
  181. tps.TestTableAddCell(PowerPrint.Test_name, "/", PowerPrint.Upper.ToString(), PowerPrint.TestVal.ToString(), PowerPrint.Result);
  182. tps.TestTableAddCell(FreqPrint.Test_name, FreqPrint.Lower.ToString(), FreqPrint.Upper.ToString(), FreqPrint.TestVal.ToString(), FreqPrint.Result);
  183. if (parameters.Channel == "通道1")
  184. {
  185. if (point == 0)
  186. {
  187. WriteExcelData(sheet, point - 1, 1, "测试名称", "下限", "上限", "测试值", "通过");
  188. }
  189. WriteExcelData(sheet, point, 1, PowerPrint.Test_name, "/", PowerPrint.Upper.ToString(), PowerPrint.TestVal.ToString(), PowerPrint.Result);
  190. WriteExcelData(sheet, point+15, 1, FreqPrint.Test_name, FreqPrint.Lower.ToString(), FreqPrint.Upper.ToString(), FreqPrint.TestVal.ToString(), FreqPrint.Result);
  191. //tps.SetTestTableCellValue(point, 10, PowerPrint.Result, PowerPrint.TestVal);
  192. //tps.SetTestTableCellValue(point, 7, FreqPrint.Result, FreqPrint.TestVal);
  193. }
  194. else if (parameters.Channel == "通道2")
  195. {
  196. if (point == 0)
  197. {
  198. WriteExcelData(sheet, point - 1, 2, "测试名称", "下限", "上限", "测试值", "通过");
  199. }
  200. WriteExcelData(sheet, point, 2, PowerPrint.Test_name, "/", PowerPrint.Upper.ToString(), PowerPrint.TestVal.ToString(), PowerPrint.Result);
  201. WriteExcelData(sheet, point+15, 2, FreqPrint.Test_name, "/", FreqPrint.Upper.ToString(), FreqPrint.TestVal.ToString(), FreqPrint.Result);
  202. //tps.SetTestTableCellValue(point, 11, PowerPrint.Result, PowerPrint.TestVal);
  203. //tps.SetTestTableCellValue(point + 15, 7, FreqPrint.Result, FreqPrint.TestVal);
  204. }
  205. #region 功率不平度及两路功率总和计算
  206. if (parameters.Channel == "通道1")
  207. {
  208. WTempPowerVal[0, point] = PowerPrint.TestVal;//W
  209. dBTempPowerVal[0, point] = Data.Power[point];//dB
  210. }
  211. else
  212. {
  213. WTempPowerVal[1, point] = PowerPrint.TestVal;//W
  214. dBTempPowerVal[1, point] = Data.Power[point];//dB
  215. }
  216. if (WTempPowerVal[0, point] > -100 && WTempPowerVal[1, point] > -100)
  217. {
  218. PowerSumPrint.Test_name = "两路功率总和(W)-" + CenterFreq.ToString() + "MHz";
  219. PowerSumPrint.Lower = PowerPara.PowerSumLower;
  220. PowerSumPrint.TestVal = Math.Round(WTempPowerVal[0, point] + WTempPowerVal[1, point],2);//W
  221. if ((PowerSumPrint.TestVal >= PowerSumPrint.Lower) && (PowerSumPrint.TestVal <= PowerSumPrint.Upper))
  222. {
  223. PowerSumPrint.Result = "是";
  224. }
  225. else
  226. {
  227. PowerSumPrint.Result = "否";
  228. }
  229. PowerFlatnessPrint.Test_name = "功率不平度(dB)-" + CenterFreq.ToString() + "MHz";
  230. PowerFlatnessPrint.Upper = PowerPara.PowerFlatnessUpper;
  231. PowerFlatnessPrint.TestVal = Math.Round(Math.Abs(dBTempPowerVal[0, point] - dBTempPowerVal[1, point]),2);//dB
  232. if ((PowerFlatnessPrint.TestVal >= PowerFlatnessPrint.Lower) && (PowerFlatnessPrint.TestVal <= PowerFlatnessPrint.Upper))
  233. {
  234. PowerFlatnessPrint.Result = "是";
  235. }
  236. else
  237. {
  238. PowerFlatnessPrint.Result = "否";
  239. }
  240. if (point == 0)
  241. {
  242. WriteExcelData(sheet, point - 1, 3, "测试名称", "下限", "上限", "测试值", "通过");
  243. WriteExcelData(sheet, point - 1, 4, "测试名称", "下限", "上限", "测试值", "通过");
  244. }
  245. tps.TestTableAddCell(PowerSumPrint.Test_name, PowerSumPrint.Lower.ToString(), "/", PowerSumPrint.TestVal.ToString(), PowerSumPrint.Result);
  246. tps.TestTableAddCell(PowerFlatnessPrint.Test_name, PowerFlatnessPrint.Lower.ToString(), "/", PowerFlatnessPrint.TestVal.ToString(), PowerFlatnessPrint.Result);
  247. WriteExcelData(sheet, point, 3, PowerSumPrint.Test_name, PowerSumPrint.Lower.ToString(), "/", PowerSumPrint.TestVal.ToString(), PowerSumPrint.Result);
  248. WriteExcelData(sheet, point, 4, PowerFlatnessPrint.Test_name, PowerFlatnessPrint.Lower.ToString(), "/", PowerFlatnessPrint.TestVal.ToString(), PowerFlatnessPrint.Result);
  249. //tps.SetTestTableCellValue(point, 12, PowerSumPrint.Result, PowerSumPrint.TestVal);
  250. //tps.SetTestTableCellValue(point, 13, PowerFlatnessPrint.Result,PowerFlatnessPrint.TestVal);
  251. }
  252. #endregion
  253. }
  254. SaveExcel(workbook);
  255. return true;
  256. }
  257. public void PsaPeakValue_CHTracedata(AppLibs.Devices.IVISA psa, out double Y_Maxvalue, out double X_Maxvalue, bool IsReturnX = false)
  258. {
  259. System.Threading.Thread.Sleep(20);
  260. X_Maxvalue = 0;
  261. Y_Maxvalue = 0;
  262. psa.Write("单次扫描");
  263. psa.Query("OPC");
  264. //string tracedata = psa.Query("读曲线");
  265. string tracedata = psa.Query("读通道曲线");
  266. string[] tracedatas = tracedata.Split(',');
  267. double[] tracedata_double = new double[tracedatas.Length-1];
  268. for (int i = 0; i < tracedatas.Length-1; i++)
  269. {
  270. tracedata_double[i] = double.Parse(tracedatas[i]);
  271. }
  272. Y_Maxvalue = tracedata_double.Max();
  273. if (IsReturnX)
  274. {
  275. int x = Array.IndexOf(tracedata_double, Y_Maxvalue);
  276. double startfreq = double.Parse(psa.Query("读起始频率"));
  277. double stopfreq = double.Parse(psa.Query("读截止频率"));
  278. double counts = double.Parse(psa.Query("测试点数读取"));
  279. X_Maxvalue = startfreq + (stopfreq - startfreq) * x / (counts - 2);
  280. }
  281. Y_Maxvalue = Math.Round(Y_Maxvalue, 3);
  282. }
  283. public void PsaPeakValue_Tracedata(AppLibs.Devices.IVISA psa, out double Y_Maxvalue, out double X_Maxvalue, bool IsReturnX = false)
  284. {
  285. System.Threading.Thread.Sleep(20);
  286. X_Maxvalue = 0;
  287. Y_Maxvalue = 0;
  288. psa.Write("单次扫描");
  289. psa.Query("OPC");
  290. string tracedata = psa.Query("读曲线");
  291. // string tracedata = psa.Query("读通道曲线");
  292. string[] tracedatas = tracedata.Split(',');
  293. double[] tracedata_double = new double[tracedatas.Length - 1];
  294. for (int i = 0; i < tracedatas.Length - 1; i++)
  295. {
  296. tracedata_double[i] = double.Parse(tracedatas[i]);
  297. }
  298. Y_Maxvalue = tracedata_double.Max();
  299. if (IsReturnX)
  300. {
  301. int x = Array.IndexOf(tracedata_double, Y_Maxvalue);
  302. double startfreq = double.Parse(psa.Query("读起始频率"));
  303. double stopfreq = double.Parse(psa.Query("读截止频率"));
  304. double counts = double.Parse(psa.Query("测试点数读取"));
  305. X_Maxvalue = startfreq + (stopfreq - startfreq) * x / (counts - 2);
  306. }
  307. Y_Maxvalue = Math.Round(Y_Maxvalue, 3);
  308. }
  309. public class ConfigParameter
  310. {
  311. /// <summary>
  312. /// 串口
  313. /// </summary>
  314. public string ComPort { set; get; }
  315. /// <summary>
  316. /// 输出损耗
  317. /// </summary>
  318. public double OutLoss { set; get; }
  319. /// <summary>
  320. /// 产品测试的起始频率
  321. /// </summary>
  322. public double StartFrequency { set; get; }
  323. /// <summary>
  324. /// 产品测试的频率步进
  325. /// </summary>
  326. public double StepFrequency { set; get; }
  327. /// <summary>
  328. /// 产品测试的频点数量
  329. /// </summary>
  330. public int FrequencyNumber { set; get; }
  331. /// <summary>
  332. /// 产品的工作频带上限(终止频率)
  333. /// 功能:用于判断从起始频率按一定的步进测试是否超出产品工作频段上限
  334. /// </summary>
  335. public double StopFrequency { set; get; }
  336. /// <summary>
  337. ///设置频谱仪的SPAN
  338. /// </summary>
  339. public string SPAN { set; get; }
  340. /// <summary>
  341. /// 通道带宽
  342. /// </summary>
  343. public string ACHBand { set; get; }
  344. /// <summary>
  345. /// 设置参考电平
  346. /// </summary>
  347. public string REF { set; get; }
  348. /// <summary>
  349. /// 设置RBW
  350. /// </summary>
  351. public string RBW { set; get; }
  352. /// <summary>
  353. /// 设置VBW
  354. /// </summary>
  355. public string VBW { set; get; }
  356. /// <summary>
  357. /// 控制延时
  358. /// </summary>
  359. public int ControlDelay { set; get; }
  360. /// <summary>
  361. /// 功率下限
  362. /// </summary>
  363. public double PowerLower { set; get; }
  364. /// <summary>
  365. /// 功率上限
  366. /// </summary>
  367. public double PowerUpper { set; get; }
  368. /// <summary>
  369. /// 频率稳定度上限
  370. /// </summary>
  371. public double FreqAccuracyUpper { set; get; }
  372. /// <summary>
  373. /// 两路功率总和下限
  374. /// </summary>
  375. public double PowerSumLower { set; get; }
  376. /// <summary>
  377. /// 功率不平度上限
  378. /// </summary>
  379. public double PowerFlatnessUpper { set; get; }
  380. }
  381. public class PowerAndFreqStabilityOutData
  382. {
  383. /// <summary>
  384. /// 输出功率(W)
  385. /// </summary>
  386. public double[] Power { set; get; }
  387. /// <summary>
  388. /// 频率稳定度
  389. /// </summary>
  390. public double[] FreqAccuracy { set; get; }
  391. /// <summary>
  392. /// 实测频点
  393. /// </summary>
  394. public double[] Freq { set; get; }
  395. /// <summary>
  396. /// 两路功率总和(W)
  397. /// </summary>
  398. public double[] PowerSum { set; get; }
  399. /// <summary>
  400. /// 两路功率不平度(dB)
  401. /// </summary>
  402. public double[] PowerFlatness { set; get; }
  403. }
  404. //public class DataType
  405. //{
  406. // /// <summary>
  407. // /// 测试名称
  408. // /// </summary>
  409. // public string Test_name { set; get; }
  410. // /// <summary>
  411. // /// 指标下限
  412. // /// </summary>
  413. // public double Lower { set; get; }
  414. // /// <summary>
  415. // /// 指标上限
  416. // /// </summary>
  417. // public double Upper { set; get; }
  418. // /// <summary>
  419. // /// 测试值
  420. // /// </summary>
  421. // public double TestVal { set; get; }
  422. // /// <summary>
  423. // /// 判断结果
  424. // /// </summary>
  425. // public bool Result { set; get; }
  426. //}
  427. }
  428. }