VoltAndCurrent.cs 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323
  1. using CommonDevHostApp.Devices;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Linq;
  5. using System.Text;
  6. using System.Threading;
  7. using System.IO;
  8. using System.Threading.Tasks;
  9. using Tps_LQ_Transmitter.com;
  10. using System.Drawing;
  11. namespace Tps_LQ_Transmitter.models
  12. {
  13. class VoltAndCurrent: BaseModel
  14. {
  15. public VoltAndCurrent()
  16. {
  17. TemplateName = "电压及电流测试";
  18. }
  19. /// <summary>
  20. /// 功率及频率稳定度测试
  21. /// </summary>
  22. public override bool Run(TestNode parameters)
  23. {
  24. object[] TableCell;
  25. TestParameters result = new TestParameters();
  26. Random random = new Random();
  27. //获取仪器
  28. CommonVisaResource DCPower = new CommonVisaResource();
  29. DCPower.Open(tps.DCPowerAddress);
  30. TransmitterSerialPort SerialClient = new TransmitterSerialPort();
  31. OutData Data = new OutData();
  32. DataType VoltDataPrint = new DataType();
  33. DataType CurrentDataPrint = new DataType();
  34. if (DCPower == 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. ConfigParameter PowerPara = new ConfigParameter();
  46. PowerPara.ComPort = parameters.Parameters.GetParameter<string>("串口");
  47. PowerPara.StartFrequency = parameters.Parameters.GetParameter<double>("起始频率");
  48. PowerPara.StepFrequency = parameters.Parameters.GetParameter<double>("频率步进");
  49. PowerPara.FrequencyNumber = parameters.Parameters.GetParameter<int>("频点数量");
  50. PowerPara.StopFrequency = parameters.Parameters.GetParameter<double>("终止频率");
  51. PowerPara.SPAN = parameters.Parameters.GetParameter<string>("扫描带宽(SPAN)");
  52. PowerPara.REF = parameters.Parameters.GetParameter<string>("参考电平(REF)");
  53. PowerPara.RBW = parameters.Parameters.GetParameter<string>("分辨率带宽(RBW)");
  54. PowerPara.VBW = parameters.Parameters.GetParameter<string>("视频带宽(VBW)");
  55. PowerPara.ControlDelay = parameters.Parameters.GetParameter<int>("控制延时");
  56. PowerPara.VoltLower = parameters.Parameters.GetParameter<double>("电压下限");
  57. PowerPara.VoltUpper= parameters.Parameters.GetParameter<double>("电压上限");
  58. PowerPara.CurrentLower = parameters.Parameters.GetParameter<double>("电流下限");
  59. PowerPara.CurrentUpper = parameters.Parameters.GetParameter<double>("电流上限");
  60. if ((PowerPara.StartFrequency == 0) || ((PowerPara.StepFrequency == 0) && (PowerPara.FrequencyNumber == 0)) || (PowerPara.StopFrequency == 0)
  61. || (PowerPara.SPAN == null) || (PowerPara.REF == null) || (PowerPara.RBW == null) || (PowerPara.VBW == null) || (PowerPara.VoltLower==0)
  62. || (PowerPara.VoltUpper == 0) ||(PowerPara.CurrentLower==0) ||(PowerPara.CurrentUpper==0))
  63. {
  64. ShowMessage(MsgType.Error, string.Format("配置文件中频率参数为空,{0}/{1}无法运行", parameters.Channel, parameters.Name));
  65. return false;
  66. }
  67. if (PowerPara.ControlDelay == 0)
  68. {
  69. PowerPara.ControlDelay = 10;
  70. }
  71. if ((PowerPara.FrequencyNumber != 0) && (PowerPara.FrequencyNumber != 1) && (PowerPara.StepFrequency == 0))
  72. {
  73. PowerPara.StepFrequency = ((int)(((PowerPara.StopFrequency - PowerPara.StartFrequency) / (PowerPara.FrequencyNumber - 1)) * 100)) / 100;
  74. }
  75. if (PowerPara.StepFrequency != 0)
  76. {
  77. PowerPara.FrequencyNumber = ((int)((PowerPara.StopFrequency - PowerPara.StartFrequency) / PowerPara.StepFrequency)) + 1;
  78. }
  79. double CenterFreq;
  80. Data.VoltVal = new string[PowerPara.FrequencyNumber];
  81. Data.CurrentVal = new string[PowerPara.FrequencyNumber];
  82. for (int point = 0; ; point++)
  83. {
  84. CenterFreq = PowerPara.StartFrequency + PowerPara.StepFrequency * point;
  85. if (CenterFreq > PowerPara.StopFrequency || (PowerPara.FrequencyNumber == 1 && point == 1))
  86. {
  87. break;
  88. }
  89. //控制
  90. // SerialClient.DUT_Transmitter_Ctrol(PowerPara.ComPort, Convert.ToByte(point + 1));
  91. Thread.Sleep(PowerPara.ControlDelay);//单位ms
  92. Data.VoltVal[point] = DCPower.Query("MEASure:VOLTage?\n");
  93. Data.CurrentVal[point] = DCPower.Query("MEASure:CURRent?\n");
  94. VoltDataPrint.Test_name = parameters.Channel + "-电压测试-" + CenterFreq.ToString()+"MHz";
  95. VoltDataPrint.Lower = PowerPara.VoltLower;
  96. VoltDataPrint.Upper = PowerPara.VoltUpper;
  97. VoltDataPrint.TestVal = double.Parse(Data.VoltVal[point]);
  98. //VoltDataPrint.TestVal = random.Next(2500, 3000) / 100.0;//随机数
  99. if ((VoltDataPrint.TestVal >= VoltDataPrint.Lower) && (VoltDataPrint.TestVal <= VoltDataPrint.Upper))
  100. {
  101. VoltDataPrint.Result = "是";
  102. }
  103. else
  104. {
  105. VoltDataPrint.Result = "否";
  106. }
  107. CurrentDataPrint.Test_name = parameters.Channel + "-电流测试-" + CenterFreq.ToString() + "MHz";
  108. CurrentDataPrint.Lower = PowerPara.CurrentLower;
  109. CurrentDataPrint.Upper = PowerPara.CurrentUpper;
  110. CurrentDataPrint.TestVal = double.Parse(Data.CurrentVal[point]);
  111. //CurrentDataPrint.TestVal = random.Next(90, 160) / 100.0;
  112. if ((CurrentDataPrint.TestVal >= CurrentDataPrint.Lower) && (CurrentDataPrint.TestVal <= CurrentDataPrint.Upper))
  113. {
  114. CurrentDataPrint.Result = "是";
  115. }
  116. else
  117. {
  118. CurrentDataPrint.Result = "否";
  119. }
  120. tps.TestTableAddCell(CurrentDataPrint.Test_name, CurrentDataPrint.Lower.ToString(), CurrentDataPrint.Upper.ToString(), CurrentDataPrint.TestVal.ToString(), CurrentDataPrint.Result);
  121. tps.TestTableAddCell(VoltDataPrint.Test_name, VoltDataPrint.Lower.ToString(), VoltDataPrint.Upper.ToString(), VoltDataPrint.TestVal.ToString(), VoltDataPrint.Result);
  122. if (parameters.Channel == "通道1")
  123. {
  124. if (point == 0)
  125. {
  126. WriteExcelData(sheet, point - 1, 1, "测试名称", "下限", "上限", "测试值", "通过");
  127. }
  128. WriteExcelData(sheet, point, 1, CurrentDataPrint.Test_name, CurrentDataPrint.Lower.ToString(), CurrentDataPrint.Upper.ToString(), CurrentDataPrint.TestVal.ToString(), CurrentDataPrint.Result);
  129. WriteExcelData(sheet, point+ PowerPara.FrequencyNumber, 1, VoltDataPrint.Test_name, VoltDataPrint.Lower.ToString(), VoltDataPrint.Upper.ToString(), VoltDataPrint.TestVal.ToString(), VoltDataPrint.Result);
  130. //tps.SetTestTableCellValue(point, 5, VoltDataPrint.Result, VoltDataPrint.TestVal);
  131. //tps.SetTestTableCellValue(point, 6, CurrentDataPrint.Result, CurrentDataPrint.TestVal);
  132. }
  133. else if (parameters.Channel == "通道2")
  134. {
  135. if (point == 0)
  136. {
  137. WriteExcelData(sheet, point - 1, 2, "测试名称", "下限", "上限", "测试值", "通过");
  138. }
  139. WriteExcelData(sheet, point, 2, CurrentDataPrint.Test_name, CurrentDataPrint.Lower.ToString(), CurrentDataPrint.Upper.ToString(), CurrentDataPrint.TestVal.ToString(), CurrentDataPrint.Result);
  140. WriteExcelData(sheet, point+ PowerPara.FrequencyNumber, 2, VoltDataPrint.Test_name, VoltDataPrint.Lower.ToString(), VoltDataPrint.Upper.ToString(), VoltDataPrint.TestVal.ToString(), VoltDataPrint.Result);
  141. //tps.SetTestTableCellValue(point + 15, 5, VoltDataPrint.Result, VoltDataPrint.TestVal);
  142. //tps.SetTestTableCellValue(point + 15, 6, CurrentDataPrint.Result, CurrentDataPrint.TestVal);
  143. }
  144. }
  145. SaveExcel(workbook);
  146. return true;
  147. }
  148. //public void OpenExcel(string sheetname, out Spire.Xls.Workbook workbook,out Spire.Xls.Worksheet sheet )
  149. //{
  150. // string TestFilePath = "F:";
  151. // string ModelFile = "F:/Transmitter_model.xlsx";
  152. // string subPath = "F:/发射机测试数据/常温测试/";
  153. // if (false == System.IO.Directory.Exists(subPath))
  154. // {
  155. // System.IO.Directory.CreateDirectory(subPath);
  156. // }
  157. // workbook = new Spire.Xls.Workbook();
  158. // string FileName = subPath + tps.Serial + ".xlsx";
  159. // if (File.Exists(FileName))
  160. // {
  161. // workbook.LoadFromFile(FileName);
  162. // //sheet = workbook.Worksheets[sheetname];
  163. // }
  164. // else if (File.Exists(ModelFile))
  165. // {
  166. // workbook.LoadFromFile(ModelFile);
  167. // //sheet = workbook.Worksheets[sheetname];
  168. // }
  169. // sheet = workbook.Worksheets[sheetname];
  170. // if (!File.Exists(ModelFile))
  171. // {
  172. // sheet = null;
  173. // }
  174. //}
  175. //public void WriteExcelData(Spire.Xls.Worksheet sheet, int row,int channel,string name,double lower,double upper,double val,string result)
  176. //{
  177. // int column = (channel - 1) * 6;
  178. // sheet.Range[row+2, 1 + column].Value2 = name;
  179. // sheet.Range[row+2, 2 + column].Value2 = lower.ToString();
  180. // sheet.Range[row+2, 3 + column].Value2 = upper.ToString();
  181. // sheet.Range[row+2, 4 + column].Value2 = val.ToString();
  182. // sheet.Range[row+2, 5 + column].Value2 = result;
  183. //}
  184. //public void SaveExcel(Spire.Xls.Workbook workbook)
  185. //{
  186. // string subPath = "F:/发射机测试数据/常温测试/";
  187. // string FileName = subPath + tps.Serial + ".xlsx";
  188. // workbook.SaveToFile(FileName);
  189. //}
  190. public class ConfigParameter
  191. {
  192. /// <summary>
  193. /// 串口
  194. /// </summary>
  195. public string ComPort { set; get; }
  196. /// <summary>
  197. /// 产品测试的起始频率
  198. /// </summary>
  199. public double StartFrequency { set; get; }
  200. /// <summary>
  201. /// 产品测试的频率步进
  202. /// </summary>
  203. public double StepFrequency { set; get; }
  204. /// <summary>
  205. /// 产品测试的频点数量
  206. /// </summary>
  207. public int FrequencyNumber { set; get; }
  208. /// <summary>
  209. /// 产品的工作频带上限(终止频率)
  210. /// 功能:用于判断从起始频率按一定的步进测试是否超出产品工作频段上限
  211. /// </summary>
  212. public double StopFrequency { set; get; }
  213. /// <summary>
  214. ///设置频谱仪的SPAN
  215. /// </summary>
  216. public string SPAN { set; get; }
  217. /// <summary>
  218. /// 设置参考电平
  219. /// </summary>
  220. public string REF { set; get; }
  221. /// <summary>
  222. /// 设置RBW
  223. /// </summary>
  224. public string RBW { set; get; }
  225. /// <summary>
  226. /// 设置VBW
  227. /// </summary>
  228. public string VBW { set; get; }
  229. /// <summary>
  230. /// 控制延时
  231. /// </summary>
  232. public int ControlDelay { set; get; }
  233. /// <summary>
  234. /// 电压下限
  235. /// </summary>
  236. public double VoltLower {set;get;}
  237. /// <summary>
  238. /// 电压上限
  239. /// </summary>
  240. public double VoltUpper { set; get; }
  241. /// <summary>
  242. /// 电流下限
  243. /// </summary>
  244. public double CurrentLower { set; get; }
  245. /// <summary>
  246. /// 电流上限
  247. /// </summary>
  248. public double CurrentUpper { set; get; }
  249. }
  250. public class OutData
  251. {
  252. /// <summary>
  253. /// 读电压值
  254. /// </summary>
  255. public string[] VoltVal { set; get; }
  256. /// <summary>
  257. /// 读电流值
  258. /// </summary>
  259. public string[] CurrentVal { set; get; }
  260. }
  261. //public class DataType
  262. //{
  263. // /// <summary>
  264. // /// 测试名称
  265. // /// </summary>
  266. // public string Test_name { set; get; }
  267. // /// <summary>
  268. // /// 指标下限
  269. // /// </summary>
  270. // public double Lower { set; get; }
  271. // /// <summary>
  272. // /// 指标上限
  273. // /// </summary>
  274. // public double Upper { set; get; }
  275. // /// <summary>
  276. // /// 测试值
  277. // /// </summary>
  278. // public double TestVal { set; get; }
  279. // /// <summary>
  280. // /// 判断结果
  281. // /// </summary>
  282. // public string Result { set; get; }
  283. //}
  284. }
  285. }