VoltAndCurrent.cs 14 KB

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