MainTps.cs 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Threading.Tasks;
  6. using System.ComponentModel;
  7. using Tps_LQ_Transmitter.com;
  8. using System.IO;
  9. using Tps_LQ_Transmitter.models;
  10. using System.Data;
  11. using AppLibs.Devices;
  12. using System.Windows.Forms;
  13. namespace Tps_LQ_Transmitter
  14. {
  15. public delegate void DltShowMsg(MsgType msgType, string msg);
  16. public delegate void DltCellValueChanged(int row, int cell, bool ok, object value);
  17. public delegate void DltCellValueAdd(string name, string lower, string upper, string testval, string result);
  18. /// <summary>
  19. /// 一个测试文件对应的测试项目
  20. /// </summary>
  21. public class MainTps
  22. {
  23. /// <summary>
  24. /// 测试人员
  25. /// </summary>
  26. public string Tester { get; set; }
  27. //测试地点
  28. public string Place { get; set; }
  29. //环境温度
  30. public string Temperature { get; set; }
  31. //当前测试的产品序列号
  32. public string Serial { get; set; }
  33. //环境湿度
  34. public string Humidity { get; set; }
  35. //待测产品
  36. public string Product { get; set; }
  37. //测试项目
  38. public string TestProject { get; set; }
  39. //配置文件路径
  40. string FilePath;
  41. /// <summary>
  42. /// 设备节点,表示当前测试程序包含的试验设备,绑定到界面的设备列表中
  43. /// </summary>
  44. public IList<DeviceNode> Devices;
  45. /// <summary>
  46. /// 测试节点,表示当前测试程序含有的测试指标,绑定到界面的指标列表中
  47. /// </summary>
  48. public IList<TestNode> TestNodes;
  49. /// <summary>
  50. /// 手工输入表
  51. /// </summary>
  52. public DataTable ManualTable;
  53. /// <summary>
  54. /// 自动测试表
  55. /// </summary>
  56. public DataTable TestTable;
  57. /// <summary>
  58. /// 测试值字典
  59. /// </summary>
  60. public Dictionary<string,double> TestValueDict;
  61. public Dictionary<string,double> GloabConfigDict;
  62. public string DCPowerAddress;//程控电源地址
  63. public string N9030A_SA_Address;//N9030A频谱仪地址
  64. public event DltCellValueChanged ManualTableCellChanged;
  65. public event DltCellValueChanged TestTableCellChanged;
  66. public event DltCellValueAdd AddTestTableCell;
  67. DataTable InitTestTable,InitManualTable; //原始数据的界面,用于初始化或者重置
  68. /// <summary>
  69. /// 测试指标的结构
  70. /// </summary>
  71. List<BaseModelStruct> baseModelStructs;
  72. public MainTps()
  73. {
  74. Devices = new BindingList<DeviceNode>();
  75. TestNodes = new BindingList<TestNode>();
  76. GloabConfigDict = new Dictionary<string, double>();
  77. DCPowerAddress = "";
  78. baseModelStructs = new List<BaseModelStruct>();
  79. LoadBaseModelStructs();
  80. }
  81. #region 模板基础方法
  82. /// <summary>
  83. /// 加载配置文件
  84. /// </summary>
  85. /// <param name="filePath"></param>
  86. /// <returns></returns>
  87. public bool LoadConfigFile(string filePath)
  88. {
  89. bool ok = true;
  90. if (File.Exists(filePath) == false)
  91. {
  92. ShowMessage(MsgType.Error, string.Format("找不到配置文件:{0}", filePath));
  93. return false;
  94. }
  95. this.FilePath = filePath;
  96. using (Spire.Xls.Workbook workbook = new Spire.Xls.Workbook())
  97. {
  98. workbook.LoadFromFile(filePath);
  99. //处理Excel数据,更多请参考官方Demo
  100. Spire.Xls.Worksheet sheet = workbook.Worksheets["自动测试项总表"];
  101. if(sheet == null)
  102. {
  103. ShowMessage(MsgType.Error, "文件中找不到‘自动测试项总表’");
  104. return false;
  105. }
  106. int blankRows = 0; //避免出错
  107. int num = 0;
  108. //默认最多两百行
  109. while (num++ < 200)
  110. {
  111. //索引从1开始
  112. string col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString():"";
  113. col1 = col1.Trim();
  114. if (string.IsNullOrEmpty(col1))
  115. {
  116. blankRows++;
  117. if(blankRows > 5)
  118. {
  119. //连续5个空行以上则退出
  120. break;
  121. }
  122. }
  123. else
  124. {
  125. blankRows = 0;
  126. }
  127. if (col1.Equals("设备配置表"))
  128. {
  129. ok &= readDevices(sheet,num);
  130. //解析行数跳过,实际上还得再加上
  131. num = num + this.Devices.Count+2;
  132. }
  133. else if (col1.Equals("测试指标配置表"))
  134. {
  135. ok &= readTestNodes(workbook,sheet,num);
  136. var items = (from p in TestNodes select p.Name).Distinct().ToArray();
  137. //解析行数跳过,实际上还得再加上
  138. num = num + items.Count() + 3;
  139. }
  140. }
  141. //加载人工测试项总表
  142. sheet = workbook.Worksheets["人工测试项总表"];
  143. if (sheet != null)
  144. {
  145. blankRows = 0; //避免出错
  146. num = 0;
  147. //默认最多两百行
  148. while (num++ < 200)
  149. {
  150. //索引从1开始
  151. string col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : "";
  152. col1 = col1.Trim();
  153. if (string.IsNullOrEmpty(col1))
  154. {
  155. blankRows++;
  156. if (blankRows > 5)
  157. {
  158. //连续5个空行以上则退出
  159. break;
  160. }
  161. }
  162. else
  163. {
  164. blankRows = 0;
  165. }
  166. if (col1.Equals("人工测试项总表"))
  167. {
  168. this.ManualTable = readTable(sheet, num);
  169. if (this.ManualTable != null)
  170. {
  171. this.InitManualTable = this.ManualTable.Copy();
  172. }
  173. }
  174. }
  175. }
  176. //加载人工测试项总表
  177. sheet = workbook.Worksheets["自动测试记录表"];
  178. if (sheet != null)
  179. {
  180. blankRows = 0; //避免出错
  181. num = 0;
  182. //默认最多两百行
  183. while (num++ < 200)
  184. {
  185. //索引从1开始
  186. string col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : "";
  187. col1 = col1.Trim();
  188. if (string.IsNullOrEmpty(col1))
  189. {
  190. blankRows++;
  191. if (blankRows > 5)
  192. {
  193. //连续5个空行以上则退出
  194. break;
  195. }
  196. }
  197. else
  198. {
  199. blankRows = 0;
  200. }
  201. if (col1.Equals("自动测试记录表"))
  202. {
  203. this.TestTable = readTable(sheet, num);
  204. if(this.TestTable != null)
  205. {
  206. this.InitTestTable = this.TestTable.Copy();
  207. }
  208. }
  209. }
  210. }
  211. //加载人工测试项总表
  212. sheet = workbook.Worksheets["供电设置"];
  213. if (sheet != null)
  214. {
  215. blankRows = 0; //避免出错
  216. num = 0;
  217. //默认最多两百行
  218. while (num++ < 200)
  219. {
  220. //索引从1开始
  221. string col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : "";
  222. col1 = col1.Trim();
  223. if (string.IsNullOrEmpty(col1))
  224. {
  225. blankRows++;
  226. if (blankRows > 5)
  227. {
  228. //连续5个空行以上则退出
  229. break;
  230. }
  231. }
  232. else
  233. {
  234. blankRows = 0;
  235. }
  236. if (col1.Equals("参数表"))
  237. {
  238. //电压
  239. string WorkVolt = sheet.Range[3, 3].Value2 != null ? sheet.Range[3, 3].Value2.ToString() : "";
  240. GloabConfigDict.Add("电压", double.Parse(WorkVolt));
  241. //电流
  242. string WorkCurrent = sheet.Range[4, 3].Value2 != null ? sheet.Range[4, 3].Value2.ToString() : "";
  243. GloabConfigDict.Add("电流", double.Parse(WorkCurrent));
  244. DCPowerAddress = sheet.Range[5, 3].Value2 != null ? sheet.Range[5, 3].Value2.ToString() : "";
  245. }
  246. }
  247. }
  248. }
  249. return ok;
  250. }
  251. /// <summary>
  252. /// 读设备配置表
  253. /// </summary>
  254. /// <param name="rowIndex">设备配置表的起始位置</param>
  255. bool readDevices(Spire.Xls.Worksheet sheet, int rowIndex)
  256. {
  257. //检查表的格式正确
  258. string col1 = sheet.Range[rowIndex + 1, 1].Value2 != null ? sheet.Range[rowIndex + 1, 1].Value2.ToString() : "";
  259. string col2 = sheet.Range[rowIndex + 1, 2].Value2 != null ? sheet.Range[rowIndex + 1, 2].Value2.ToString() : "";
  260. string col3 = sheet.Range[rowIndex + 1, 3].Value2 != null ? sheet.Range[rowIndex + 1, 3].Value2.ToString() : "";
  261. string col4 = sheet.Range[rowIndex + 1, 4].Value2 != null ? sheet.Range[rowIndex + 1, 4].Value2.ToString() : "";
  262. if (!(col1 == "设备名称" && col2 == "设备类型" && col3 == "设备型号" && col4 == "控制句柄"))
  263. {
  264. ShowMessage(MsgType.Error, "'设备配置表'行首标题位置和格式不正确");
  265. return false;
  266. }
  267. int num = rowIndex + 1;
  268. //默认最多30行
  269. while (num++ < rowIndex + 30)
  270. {
  271. col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : "";
  272. col2 = sheet.Range[num, 2].Value2 != null ? sheet.Range[num, 2].Value2.ToString() : "";
  273. col3 = sheet.Range[num, 3].Value2 != null ? sheet.Range[num, 3].Value2.ToString() : "";
  274. col4 = sheet.Range[num, 4].Value2 != null ? sheet.Range[num, 4].Value2.ToString() : "";
  275. if ( string.IsNullOrEmpty(col2) || string.IsNullOrEmpty(col3))
  276. {
  277. break;
  278. }
  279. DeviceNode dn = new DeviceNode();
  280. dn.DeviceName = col1;
  281. dn.DeviceType = col2;
  282. dn.DeviceModel = col3;
  283. dn.DeviceHandle = col4;
  284. this.Devices.Add(dn);
  285. }
  286. return true;
  287. }
  288. /// <summary>
  289. /// 读测试指标配置表
  290. /// </summary>
  291. /// <param name="rowIndex">测试指标配置表的起始位置</param>
  292. bool readTestNodes(Spire.Xls.Workbook workbook,Spire.Xls.Worksheet sheet, int rowIndex)
  293. {
  294. List<TestNode> models = new List<TestNode>();
  295. //检查表的格式正确
  296. string col1 = sheet.Range[rowIndex + 2, 1].Value2 != null ? sheet.Range[rowIndex + 2, 1].Value2.ToString() : "";
  297. string col2 = sheet.Range[rowIndex + 2, 2].Value2 != null ? sheet.Range[rowIndex + 2, 2].Value2.ToString() : "";
  298. string col3 = sheet.Range[rowIndex + 2, 3].Value2 != null ? sheet.Range[rowIndex + 2, 3].Value2.ToString() : "";
  299. string col4 = sheet.Range[rowIndex + 2, 4].Value2 != null ? sheet.Range[rowIndex + 2, 4].Value2.ToString() : "";
  300. if (!(col1 == "测试指标" && col2 == "默认勾选" && col3 == "测试模板" && col4 == "测试顺序"))
  301. {
  302. ShowMessage(MsgType.Error, "'测试指标配置表'行首标题位置和格式不正确");
  303. return false;
  304. }
  305. int num = rowIndex + 2;
  306. //默认最多100行,先解析测试指标个数
  307. while (num++ < rowIndex + 100)
  308. {
  309. col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : "";
  310. col2 = sheet.Range[num, 2].Value2 != null ? sheet.Range[num, 2].Value2.ToString() : "";
  311. col3 = sheet.Range[num, 3].Value2 != null ? sheet.Range[num, 3].Value2.ToString() : "";
  312. col4 = sheet.Range[num, 4].Value2 != null ? sheet.Range[num, 4].Value2.ToString() : "";
  313. if (string.IsNullOrEmpty(col1) || string.IsNullOrEmpty(col3))
  314. {
  315. break;
  316. }
  317. TestNode tn = new TestNode();
  318. tn.Name = col1;
  319. if(col2 == "是")
  320. {
  321. tn.IsSelected = true;
  322. }
  323. else
  324. {
  325. tn.IsSelected = false;
  326. }
  327. tn.Template = col3;
  328. int order = Int32.MaxValue;
  329. if (Int32.TryParse(col4, out order))
  330. tn.Order = order;
  331. models.Add(tn);
  332. }
  333. //再解析各通道的配置数据
  334. int colIndex = 5; //通道数据从第5列开始
  335. while(true)
  336. {
  337. col1 = sheet.Range[rowIndex + 3, colIndex].Value2 != null ? sheet.Range[rowIndex + 3, colIndex].Value2.ToString() : "";
  338. col2 = sheet.Range[rowIndex + 3, colIndex + 1].Value2 != null ? sheet.Range[rowIndex + 3, colIndex + 1].Value2.ToString() : "";
  339. //有新通道数据则继续,否则退出
  340. if(string.IsNullOrEmpty(col1) || string.IsNullOrEmpty(col2) || col2 != "启用")
  341. {
  342. break;
  343. }
  344. string channel = sheet.Range[rowIndex + 1, colIndex].Value2 != null ? sheet.Range[rowIndex + 1, colIndex].Value2.ToString() : "";
  345. //按指标个数来解析通道数据
  346. for (int i = 0; i < models.Count; i++)
  347. {
  348. col1 = sheet.Range[rowIndex + 3 + i, colIndex].Value2 != null ? sheet.Range[rowIndex + 3 + i, colIndex].Value2.ToString() : "";
  349. col2 = sheet.Range[rowIndex + 3 + i, colIndex + 1].Value2 != null ? sheet.Range[rowIndex + 3 + i, colIndex + 1].Value2.ToString() : "";
  350. if (col2 != "启用")
  351. continue;
  352. TestNode newNode = models[i].Copy();
  353. newNode.Channel = channel; //通道名
  354. newNode.ParaConfigTable = col1; //测试配置表
  355. //复制已有参数表,或者从文件解析参数表
  356. TestNode preNode = TestNodes.FirstOrDefault(x => x.ParaConfigTable == col1);
  357. if(preNode != null)
  358. {
  359. //存在则复制,避免读文件费时间
  360. newNode.Parameters = preNode.Parameters.Copy();
  361. }
  362. else
  363. {
  364. //否则找到文件中对应的配置表
  365. Spire.Xls.Worksheet paraSheet = workbook.Worksheets[col1];
  366. if (paraSheet == null)
  367. {
  368. ShowMessage(MsgType.Error, "文件中找不到参数配置表:"+ col1);
  369. continue;
  370. }
  371. //解析参数配置表
  372. newNode.Parameters = readTestParameter(paraSheet);
  373. }
  374. //如果已经创建了同名的处理对象,则直接使用,否则则新建,采用单例模式
  375. //如果注释了下面的if,就是多例模式,即同名处理模块是不同的软件对象
  376. TestNode tn = this.TestNodes.FirstOrDefault(x => x.Template == newNode.Template);
  377. if(tn != null && tn.TestModel != null)
  378. {
  379. newNode.TestModel = tn.TestModel;
  380. }
  381. else
  382. {
  383. //根据测试指标的名称,创建BaseModel指标处理对象
  384. newNode.TestModel = CreateModel(newNode.Template);
  385. }
  386. this.TestNodes.Add(newNode);
  387. }
  388. colIndex += 2; //跳过2列
  389. }
  390. return true;
  391. }
  392. BaseModel CreateModel(string template)
  393. {
  394. //如果没有这个名字的软件模块,则返回null
  395. BaseModelStruct bms = baseModelStructs.FirstOrDefault(x => x.ModelName == template);
  396. if (bms == null)
  397. {
  398. ShowMessage(MsgType.Error, "找不到名称为:" + template +" 的测试指标模块。");
  399. return null;
  400. }
  401. BaseModel model = (BaseModel)Activator.CreateInstance(bms.type);
  402. model.tps = this;
  403. model.MessageEvent += ShowMessage;
  404. return model;
  405. }
  406. void LoadBaseModelStructs()
  407. {
  408. try
  409. {
  410. Type[] types = this.GetType().Assembly.GetTypes();
  411. foreach (var item in types)
  412. {
  413. //排除接口本身
  414. if (item.Name != "BaseModel")
  415. {
  416. if (typeof(BaseModel).IsAssignableFrom(item))
  417. {
  418. BaseModel model = (BaseModel)Activator.CreateInstance(item);
  419. BaseModelStruct bms = new BaseModelStruct();
  420. bms.ModelName = model.TemplateName;
  421. bms.type = item;
  422. this.baseModelStructs.Add(bms);
  423. model = null;
  424. }
  425. }
  426. }
  427. }
  428. catch(Exception e)
  429. {
  430. ShowMessage(MsgType.Error, "实例化BaseModel测试指标模块时出现错误,某个测试指标模块创建时发生错误,请检查代码!详细错误见程序日志文件!");
  431. Bundle.log.WriteLog(AppLibs.Host.LogLevel.Error, "类:MainTps,方法:LoadBaseModelStructs", e.Message + e.StackTrace);
  432. }
  433. }
  434. /// <summary>
  435. /// 读参数配置表
  436. /// </summary>
  437. /// <returns></returns>
  438. TestParameters readTestParameter(Spire.Xls.Worksheet sheet)
  439. {
  440. TestParameters pars = new TestParameters();
  441. int blankRows = 0; //避免出错
  442. int num = 0;
  443. //默认最多两百行
  444. while (num++ < 200)
  445. {
  446. //索引从1开始
  447. string col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : "";
  448. col1 = col1.Trim();
  449. if (string.IsNullOrEmpty(col1))
  450. {
  451. blankRows++;
  452. if (blankRows > 5)
  453. {
  454. //连续5个空行以上则退出
  455. break;
  456. }
  457. }
  458. else
  459. {
  460. blankRows = 0;
  461. }
  462. if (col1.Equals("参数表"))
  463. {
  464. ///获取表中的参数
  465. List<ParameterNode> nodes = readParameters(sheet,num);
  466. foreach (var item in nodes)
  467. {
  468. if(pars.Parameters.ContainsKey(item.Name))
  469. {
  470. ShowMessage(MsgType.Error, string.Format("参数配置表:{0} 存在同名参数:{1},无法重复添加参数", sheet.Name, item.Name));
  471. continue;
  472. }
  473. pars.Parameters.Add(item.Name, item);
  474. }
  475. //解析行数跳过,实际上还得再加上
  476. num = num + nodes.Count +1;
  477. }
  478. else if (col1.Equals("测试显示表"))
  479. {
  480. //获取表中的原始显示界面
  481. pars.InitialTable = readTable( sheet, num);
  482. //解析行数跳过,实际上还得再加上
  483. num = num + pars.InitialTable.Rows.Count + 1;
  484. }
  485. }
  486. return pars;
  487. }
  488. /// <summary>
  489. /// 读参数表
  490. /// </summary>
  491. /// <param name="sheet"></param>
  492. /// <returns></returns>
  493. List<ParameterNode> readParameters(Spire.Xls.Worksheet sheet,int rowIndex)
  494. {
  495. List<ParameterNode> nodes = new List<ParameterNode>();
  496. string col1 = sheet.Range[rowIndex + 1, 1].Value2 != null ? sheet.Range[rowIndex + 1, 1].Value2.ToString() : "";
  497. string col2 = sheet.Range[rowIndex + 1, 2].Value2 != null ? sheet.Range[rowIndex + 1, 2].Value2.ToString() : "";
  498. string col3 = sheet.Range[rowIndex + 1, 3].Value2 != null ? sheet.Range[rowIndex + 1, 3].Value2.ToString() : "";
  499. string col4 = sheet.Range[rowIndex + 1, 4].Value2 != null ? sheet.Range[rowIndex + 1, 4].Value2.ToString() : "";
  500. if (!(col1 == "名称" && col2 == "类型" && col3 == "值"))
  501. {
  502. ShowMessage(MsgType.Error, "'参数表'行首标题位置和格式不正确");
  503. return nodes;
  504. }
  505. int num = rowIndex + 1;
  506. //默认最多30行
  507. while (num++ < rowIndex + 200)
  508. {
  509. col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : "";
  510. col2 = sheet.Range[num, 2].Value2 != null ? sheet.Range[num, 2].Value2.ToString() : "";
  511. col3 = sheet.Range[num, 3].Value2 != null ? sheet.Range[num, 3].Value2.ToString() : "";
  512. col4 = sheet.Range[num, 4].Value2 != null ? sheet.Range[num, 4].Value2.ToString() : "";
  513. if (string.IsNullOrEmpty(col1) || string.IsNullOrEmpty(col2) || string.IsNullOrEmpty(col3))
  514. {
  515. break;
  516. }
  517. ParameterNode pn = new ParameterNode();
  518. pn.Name = col1;
  519. pn.Type = col2;
  520. pn.StrValue = col3;
  521. pn.Mark = col4;
  522. nodes.Add(pn);
  523. }
  524. return nodes;
  525. }
  526. /// <summary>
  527. /// 读表格,人工测试表和测试显示表
  528. /// </summary>
  529. /// <param name="sheet"></param>
  530. /// <returns></returns>
  531. DataTable readTable(Spire.Xls.Worksheet sheet, int rowIndex)
  532. {
  533. //先创建列,再创建行
  534. DataTable dt = new DataTable();
  535. int num = 0;
  536. while (num++ < 50)
  537. {
  538. string col = sheet.Range[rowIndex + 1, num].Value2 != null ? sheet.Range[rowIndex + 1, num].Value2.ToString() : "";
  539. if (string.IsNullOrEmpty(col))
  540. break;
  541. dt.Columns.Add(col);
  542. }
  543. //再创建行
  544. num = rowIndex + 1;
  545. //默认最多200行
  546. while (num++ < rowIndex + 200)
  547. {
  548. //首列无值就认为表格结束
  549. string val = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : "";
  550. if (string.IsNullOrEmpty(val.Trim()))
  551. break;
  552. DataRow dr = dt.NewRow();
  553. dt.Rows.Add(dr);
  554. for (int i = 0; i < dt.Columns.Count; i++)
  555. {
  556. val = sheet.Range[num, i+1].Value2 != null ? sheet.Range[num, i+1].Value2.ToString() : "";
  557. dr[i] = val;
  558. }
  559. }
  560. return dt;
  561. }
  562. /// <summary>
  563. /// 检查仪器是否正常配置
  564. /// </summary>
  565. /// <returns></returns>
  566. public bool CheckDevices()
  567. {
  568. bool ok = true;
  569. AppLibs.Devices.IDeviceHost devHost = Bundle.host.GetFirstOrDefaultService<AppLibs.Devices.IDeviceHost>();
  570. foreach (DeviceNode device in this.Devices)
  571. {
  572. DeviceParameter dev = devHost.GetFirstOrDefaultDeviceID(device.DeviceHandle);
  573. if (dev == null || !(device.DeviceType == dev.DeviceType && device.DeviceModel == dev.DeviceModel))
  574. {
  575. device.State = false;
  576. ok = false;
  577. }
  578. else
  579. {
  580. device.State = true;
  581. continue;
  582. }
  583. }
  584. return ok;
  585. }
  586. /// <summary>
  587. ///
  588. /// </summary>
  589. /// <param name="isOrderByChannel">按照指标分组还是按照通道分组</param>
  590. public void Start(bool isOrderByChannel)
  591. {
  592. ShowMessage(MsgType.Info, string.Format("序列号:{0} 测试开始",Serial));
  593. isStop = false;
  594. //清空测试数据
  595. // BaseModel.TestResults.Clear();
  596. //选择勾选项
  597. List<TestNode> nodes = this.TestNodes.Where(x => x.IsSelected == true).ToList();
  598. if(isOrderByChannel)
  599. {
  600. //按照通道分组
  601. int Channel = 1;
  602. foreach (IGrouping<string, TestNode> group in nodes.GroupBy(x => x.Channel))
  603. {
  604. //ShowMessage(MsgType.Notice,$"温馨提示:即将测试第{Channel}通道,请将线缆换到{Channel}通道!");
  605. //Channel++;
  606. //排序后执行
  607. foreach (TestNode testnode in group.OrderBy(a => a.Order))
  608. {
  609. if(isStop == false)
  610. {
  611. ShowMessage(MsgType.Info, string.Format("开始执行测试指标:{0}/{1}", testnode.Channel, testnode.Name));
  612. if(testnode.TestModel != null)
  613. {
  614. //测试中途取消了勾选项
  615. if(testnode.IsSelected)
  616. {
  617. currModel = testnode.TestModel;
  618. testnode.TestModel.Start(testnode);
  619. }
  620. }
  621. else
  622. {
  623. ShowMessage(MsgType.Error, string.Format("测试指标:{0}/{1} 没有实例化执行模块", testnode.Channel, testnode.Name));
  624. }
  625. }
  626. else
  627. {
  628. break;
  629. }
  630. }
  631. }
  632. }
  633. else
  634. {
  635. //按照指标名称进行
  636. foreach (IGrouping<string, TestNode> group in nodes.GroupBy(x => x.Name))
  637. {
  638. //排序后执行
  639. foreach (TestNode testnode in group.OrderBy(a => a.Order))
  640. {
  641. if (isStop == false)
  642. {
  643. ShowMessage(MsgType.Info, string.Format("开始执行测试指标:{0}/{1}", testnode.Channel, testnode.Name));
  644. if (testnode.TestModel != null)
  645. {
  646. currModel = testnode.TestModel;
  647. testnode.TestModel.Start(testnode);
  648. }
  649. else
  650. {
  651. ShowMessage(MsgType.Error, string.Format("测试指标:{0}/{1} 没有实例化执行模块", testnode.Channel, testnode.Name));
  652. }
  653. }
  654. else
  655. {
  656. break;
  657. }
  658. }
  659. }
  660. }
  661. //保存自动测试记录表
  662. SaveTestTable();
  663. ShowMessage(MsgType.Info, string.Format("序列号:{0} 测试完成", Serial));
  664. }
  665. bool isStop = false;
  666. BaseModel currModel = null;
  667. public void Stop()
  668. {
  669. isStop = true;
  670. if(currModel!= null)
  671. {
  672. currModel.Stop();
  673. }
  674. ShowMessage(MsgType.Info, string.Format("序列号:{0} 测试中止", Serial));
  675. }
  676. public event DltShowMsg MessageEvent;
  677. /// <summary>
  678. /// 本对象显示消息,以及测试指标显示消息都经过这个方法
  679. /// </summary>
  680. /// <param name="msgType"></param>
  681. /// <param name="msg"></param>
  682. void ShowMessage(MsgType msgType, string msg)
  683. {
  684. if(MessageEvent != null)
  685. {
  686. MessageEvent(msgType, msg);
  687. }
  688. //if (msgType == MsgType.Notice || msgType == MsgType.Error)
  689. if (msgType == MsgType.Error)
  690. {
  691. MessageBox.Show(msg);
  692. }
  693. }
  694. public void ResetTestTable()
  695. {
  696. if(this.InitTestTable != null)
  697. {
  698. TestTable = this.InitTestTable.Copy();
  699. }
  700. }
  701. public void ResetManualTable()
  702. {
  703. if (this.InitManualTable != null)
  704. {
  705. ManualTable = this.InitManualTable.Copy();
  706. }
  707. }
  708. public AppLibs.Devices.IVISA GetDevice(string name)
  709. {
  710. DeviceNode node = this.Devices.FirstOrDefault(x => x.DeviceName == name);
  711. //不存在或者状态不对,都返回空
  712. if(node == null || node.State == false)
  713. {
  714. return null;
  715. }
  716. else
  717. {
  718. AppLibs.Devices.IDeviceHost devHost = Bundle.host.GetFirstOrDefaultService<AppLibs.Devices.IDeviceHost>();
  719. if (devHost == null)
  720. return null;
  721. DeviceParameter dev = devHost.GetFirstOrDefaultDeviceID(node.DeviceHandle);
  722. //要地址,名称,型号一致
  723. if (dev == null || !(node.DeviceType == dev.DeviceType && node.DeviceModel == dev.DeviceModel))
  724. {
  725. return null;
  726. }
  727. else
  728. {
  729. return (IVISA)dev;
  730. }
  731. }
  732. }
  733. public AppLibs.Devices.IVISA GetDeviceModel(string DeviceHandle)
  734. {
  735. DeviceNode node = this.Devices.FirstOrDefault(x => x.DeviceHandle == DeviceHandle);
  736. //不存在或者状态不对,都返回空
  737. if (node == null && node.State == false)
  738. {
  739. return null;
  740. }
  741. else
  742. {
  743. AppLibs.Devices.IDeviceHost devHost = Bundle.host.GetFirstOrDefaultService<AppLibs.Devices.IDeviceHost>();
  744. if (devHost == null)
  745. return null;
  746. DeviceParameter dev = devHost.GetFirstOrDefaultDeviceID(node.DeviceHandle);
  747. //要地址,名称,型号一致
  748. //if (dev == null || !(node.DeviceType == dev.DeviceType && node.DeviceModel == dev.DeviceModel))
  749. //if (dev == null || !(node.DeviceType == dev.DeviceType ))
  750. if (dev == null)
  751. {
  752. return null;
  753. }
  754. else
  755. {
  756. return (IVISA)dev;
  757. }
  758. }
  759. }
  760. public void SetManualTableCellValue(int row, int col, bool ok, object value)
  761. {
  762. if (ManualTableCellChanged != null)
  763. ManualTableCellChanged(row, col,ok, value);
  764. }
  765. public void SetTestTableCellValue(int row, int col, bool ok, object value)
  766. {
  767. if (TestTableCellChanged != null)
  768. TestTableCellChanged(row, col, ok, value);
  769. }
  770. public void TestTableAddCell(string name, string lower, string upper, string testval,string result)
  771. {
  772. if (AddTestTableCell != null)
  773. AddTestTableCell(name,lower,upper,testval,result);
  774. }
  775. void SaveTestTable()
  776. {
  777. if(string.IsNullOrEmpty(Serial))
  778. {
  779. ShowMessage(MsgType.Info, "序列号为空,数据不保存");
  780. return;
  781. }
  782. AppLibs.Function.IReportHost report = Bundle.host.GetFirstOrDefaultService<AppLibs.Function.IReportHost>();
  783. if(report != null)
  784. {
  785. AppLibs.Models.TableInfo tableInfo = new AppLibs.Models.TableInfo();
  786. tableInfo.data = TestTable;
  787. tableInfo.table = new AppLibs.Models.Table();
  788. tableInfo.table.Result = "合格";
  789. tableInfo.table.Temperature = Temperature;
  790. tableInfo.table.Tester = Tester;
  791. tableInfo.table.Time = DateTime.Now;
  792. tableInfo.table.Place = Place;
  793. tableInfo.table.Serial = Serial;
  794. tableInfo.table.Humidity = Humidity;
  795. tableInfo.table.Type = TestProject;
  796. tableInfo.table.ProductCode = Product;
  797. tableInfo.table.ProductName = Product;
  798. tableInfo.table.Name = TestProject + "#" + Product;
  799. //try
  800. //{
  801. // if (report.WriteAndReplaceTable(tableInfo))
  802. // {
  803. // ShowMessage(MsgType.Info, "自动测试记录表保存成功");
  804. // }
  805. // else
  806. // {
  807. // ShowMessage(MsgType.Info, "自动测试记录表保存失败");
  808. // }
  809. //}
  810. //catch (Exception ex)
  811. //{
  812. // ShowMessage(MsgType.Error, "自动测试记录表保存失败");
  813. //}
  814. }
  815. else
  816. {
  817. ShowMessage(MsgType.Info, "软件未包含数据存储模块");
  818. }
  819. }
  820. //判断某个测试项是否勾选
  821. public bool IsTestItemSelected(string channel , string name)
  822. {
  823. var node = this.TestNodes.FirstOrDefault(x => x.Channel == channel && x.Name == name);
  824. if (node == null)
  825. return false;
  826. return node.IsSelected;
  827. }
  828. #endregion
  829. #region 二次修改的方法
  830. #endregion
  831. }
  832. }