VoltAndCurrent.cs 13 KB

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