using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.ComponentModel; using Tps_LQ_Transmitter.com; using System.IO; using Tps_LQ_Transmitter.models; using System.Data; using AppLibs.Devices; namespace Tps_LQ_Transmitter { public delegate void DltShowMsg(MsgType msgType, string msg); public delegate void DltCellValueChanged(int row, int cell, bool ok, object value); /// /// 一个测试文件对应的测试项目 /// public class MainTps { /// /// 测试人员 /// public string Tester { get; set; } //测试地点 public string Place { get; set; } //环境温度 public string Temperature { get; set; } //当前测试的产品序列号 public string Serial { get; set; } //环境湿度 public string Humidity { get; set; } //待测产品 public string Product { get; set; } //测试项目 public string TestProject { get; set; } //配置文件路径 string FilePath; /// /// 设备节点,表示当前测试程序包含的试验设备,绑定到界面的设备列表中 /// public IList Devices; /// /// 测试节点,表示当前测试程序含有的测试指标,绑定到界面的指标列表中 /// public IList TestNodes; /// /// 手工输入表 /// public DataTable ManualTable; /// /// 自动测试表 /// public DataTable TestTable; /// /// 测试值字典 /// public Dictionary TestValueDict; public event DltCellValueChanged ManualTableCellChanged; public event DltCellValueChanged TestTableCellChanged; DataTable InitTestTable,InitManualTable; //原始数据的界面,用于初始化或者重置 /// /// 测试指标的结构 /// List baseModelStructs; public MainTps() { Devices = new BindingList(); TestNodes = new BindingList(); baseModelStructs = new List(); LoadBaseModelStructs(); } #region 模板基础方法 /// /// 加载配置文件 /// /// /// public bool LoadConfigFile(string filePath) { bool ok = true; if (File.Exists(filePath) == false) { ShowMessage(MsgType.Error, string.Format("找不到配置文件:{0}", filePath)); return false; } this.FilePath = filePath; using (Spire.Xls.Workbook workbook = new Spire.Xls.Workbook()) { workbook.LoadFromFile(filePath); //处理Excel数据,更多请参考官方Demo Spire.Xls.Worksheet sheet = workbook.Worksheets["自动测试项总表"]; if(sheet == null) { ShowMessage(MsgType.Error, "文件中找不到‘自动测试项总表’"); return false; } int blankRows = 0; //避免出错 int num = 0; //默认最多两百行 while (num++ < 200) { //索引从1开始 string col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString():""; col1 = col1.Trim(); if (string.IsNullOrEmpty(col1)) { blankRows++; if(blankRows > 5) { //连续5个空行以上则退出 break; } } else { blankRows = 0; } if (col1.Equals("设备配置表")) { ok &= readDevices(sheet,num); //解析行数跳过,实际上还得再加上 num = num + this.Devices.Count+2; } else if (col1.Equals("测试指标配置表")) { ok &= readTestNodes(workbook,sheet,num); var items = (from p in TestNodes select p.Name).Distinct().ToArray(); //解析行数跳过,实际上还得再加上 num = num + items.Count() + 3; } } //加载人工测试项总表 sheet = workbook.Worksheets["人工测试项总表"]; if (sheet != null) { blankRows = 0; //避免出错 num = 0; //默认最多两百行 while (num++ < 200) { //索引从1开始 string col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : ""; col1 = col1.Trim(); if (string.IsNullOrEmpty(col1)) { blankRows++; if (blankRows > 5) { //连续5个空行以上则退出 break; } } else { blankRows = 0; } if (col1.Equals("人工测试项总表")) { this.ManualTable = readTable(sheet, num); if (this.ManualTable != null) { this.InitManualTable = this.ManualTable.Copy(); } } } } //加载人工测试项总表 sheet = workbook.Worksheets["自动测试记录表"]; if (sheet != null) { blankRows = 0; //避免出错 num = 0; //默认最多两百行 while (num++ < 200) { //索引从1开始 string col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : ""; col1 = col1.Trim(); if (string.IsNullOrEmpty(col1)) { blankRows++; if (blankRows > 5) { //连续5个空行以上则退出 break; } } else { blankRows = 0; } if (col1.Equals("自动测试记录表")) { this.TestTable = readTable(sheet, num); if(this.TestTable != null) { this.InitTestTable = this.TestTable.Copy(); } } } } } return ok; } /// /// 读设备配置表 /// /// 设备配置表的起始位置 bool readDevices(Spire.Xls.Worksheet sheet, int rowIndex) { //检查表的格式正确 string col1 = sheet.Range[rowIndex + 1, 1].Value2 != null ? sheet.Range[rowIndex + 1, 1].Value2.ToString() : ""; string col2 = sheet.Range[rowIndex + 1, 2].Value2 != null ? sheet.Range[rowIndex + 1, 2].Value2.ToString() : ""; string col3 = sheet.Range[rowIndex + 1, 3].Value2 != null ? sheet.Range[rowIndex + 1, 3].Value2.ToString() : ""; string col4 = sheet.Range[rowIndex + 1, 4].Value2 != null ? sheet.Range[rowIndex + 1, 4].Value2.ToString() : ""; if (!(col1 == "设备名称" && col2 == "设备类型" && col3 == "设备型号" && col4 == "控制句柄")) { ShowMessage(MsgType.Error, "'设备配置表'行首标题位置和格式不正确"); return false; } int num = rowIndex + 1; //默认最多30行 while (num++ < rowIndex + 30) { col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : ""; col2 = sheet.Range[num, 2].Value2 != null ? sheet.Range[num, 2].Value2.ToString() : ""; col3 = sheet.Range[num, 3].Value2 != null ? sheet.Range[num, 3].Value2.ToString() : ""; col4 = sheet.Range[num, 4].Value2 != null ? sheet.Range[num, 4].Value2.ToString() : ""; if (string.IsNullOrEmpty(col1) || string.IsNullOrEmpty(col2) || string.IsNullOrEmpty(col3)) { break; } DeviceNode dn = new DeviceNode(); dn.DeviceName = col1; dn.DeviceType = col2; dn.DeviceModel = col3; dn.DeviceHandle = col4; this.Devices.Add(dn); } return true; } /// /// 读测试指标配置表 /// /// 测试指标配置表的起始位置 bool readTestNodes(Spire.Xls.Workbook workbook,Spire.Xls.Worksheet sheet, int rowIndex) { List models = new List(); //检查表的格式正确 string col1 = sheet.Range[rowIndex + 2, 1].Value2 != null ? sheet.Range[rowIndex + 2, 1].Value2.ToString() : ""; string col2 = sheet.Range[rowIndex + 2, 2].Value2 != null ? sheet.Range[rowIndex + 2, 2].Value2.ToString() : ""; string col3 = sheet.Range[rowIndex + 2, 3].Value2 != null ? sheet.Range[rowIndex + 2, 3].Value2.ToString() : ""; string col4 = sheet.Range[rowIndex + 2, 4].Value2 != null ? sheet.Range[rowIndex + 2, 4].Value2.ToString() : ""; if (!(col1 == "测试指标" && col2 == "默认勾选" && col3 == "测试模板" && col4 == "测试顺序")) { ShowMessage(MsgType.Error, "'测试指标配置表'行首标题位置和格式不正确"); return false; } int num = rowIndex + 2; //默认最多100行,先解析测试指标个数 while (num++ < rowIndex + 100) { col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : ""; col2 = sheet.Range[num, 2].Value2 != null ? sheet.Range[num, 2].Value2.ToString() : ""; col3 = sheet.Range[num, 3].Value2 != null ? sheet.Range[num, 3].Value2.ToString() : ""; col4 = sheet.Range[num, 4].Value2 != null ? sheet.Range[num, 4].Value2.ToString() : ""; if (string.IsNullOrEmpty(col1) || string.IsNullOrEmpty(col3)) { break; } TestNode tn = new TestNode(); tn.Name = col1; if(col2 == "是") { tn.IsSelected = true; } else { tn.IsSelected = false; } tn.Template = col3; int order = Int32.MaxValue; if (Int32.TryParse(col4, out order)) tn.Order = order; models.Add(tn); } //再解析各通道的配置数据 int colIndex = 5; //通道数据从第5列开始 while(true) { col1 = sheet.Range[rowIndex + 3, colIndex].Value2 != null ? sheet.Range[rowIndex + 3, colIndex].Value2.ToString() : ""; col2 = sheet.Range[rowIndex + 3, colIndex + 1].Value2 != null ? sheet.Range[rowIndex + 3, colIndex + 1].Value2.ToString() : ""; //有新通道数据则继续,否则退出 if(string.IsNullOrEmpty(col1) || string.IsNullOrEmpty(col2) || col2 != "启用") { break; } string channel = sheet.Range[rowIndex + 1, colIndex].Value2 != null ? sheet.Range[rowIndex + 1, colIndex].Value2.ToString() : ""; //按指标个数来解析通道数据 for (int i = 0; i < models.Count; i++) { col1 = sheet.Range[rowIndex + 3 + i, colIndex].Value2 != null ? sheet.Range[rowIndex + 3 + i, colIndex].Value2.ToString() : ""; col2 = sheet.Range[rowIndex + 3 + i, colIndex + 1].Value2 != null ? sheet.Range[rowIndex + 3 + i, colIndex + 1].Value2.ToString() : ""; if (col2 != "启用") continue; TestNode newNode = models[i].Copy(); newNode.Channel = channel; //通道名 newNode.ParaConfigTable = col1; //测试配置表 //复制已有参数表,或者从文件解析参数表 TestNode preNode = TestNodes.FirstOrDefault(x => x.ParaConfigTable == col1); if(preNode != null) { //存在则复制,避免读文件费时间 newNode.Parameters = preNode.Parameters.Copy(); } else { //否则找到文件中对应的配置表 Spire.Xls.Worksheet paraSheet = workbook.Worksheets[col1]; if (paraSheet == null) { ShowMessage(MsgType.Error, "文件中找不到参数配置表:"+ col1); continue; } //解析参数配置表 newNode.Parameters = readTestParameter(paraSheet); } //如果已经创建了同名的处理对象,则直接使用,否则则新建,采用单例模式 //如果注释了下面的if,就是多例模式,即同名处理模块是不同的软件对象 TestNode tn = this.TestNodes.FirstOrDefault(x => x.Template == newNode.Template); if(tn != null && tn.TestModel != null) { newNode.TestModel = tn.TestModel; } else { //根据测试指标的名称,创建BaseModel指标处理对象 newNode.TestModel = CreateModel(newNode.Template); } this.TestNodes.Add(newNode); } colIndex += 2; //跳过2列 } return true; } BaseModel CreateModel(string template) { //如果没有这个名字的软件模块,则返回null BaseModelStruct bms = baseModelStructs.FirstOrDefault(x => x.ModelName == template); if (bms == null) { ShowMessage(MsgType.Error, "找不到名称为:" + template +" 的测试指标模块。"); return null; } BaseModel model = (BaseModel)Activator.CreateInstance(bms.type); model.tps = this; model.MessageEvent += ShowMessage; return model; } void LoadBaseModelStructs() { try { Type[] types = this.GetType().Assembly.GetTypes(); foreach (var item in types) { //排除接口本身 if (item.Name != "BaseModel") { if (typeof(BaseModel).IsAssignableFrom(item)) { BaseModel model = (BaseModel)Activator.CreateInstance(item); BaseModelStruct bms = new BaseModelStruct(); bms.ModelName = model.TemplateName; bms.type = item; this.baseModelStructs.Add(bms); model = null; } } } } catch(Exception e) { ShowMessage(MsgType.Error, "实例化BaseModel测试指标模块时出现错误,某个测试指标模块创建时发生错误,请检查代码!详细错误见程序日志文件!"); Bundle.log.WriteLog(AppLibs.Host.LogLevel.Error, "类:MainTps,方法:LoadBaseModelStructs", e.Message + e.StackTrace); } } /// /// 读参数配置表 /// /// TestParameters readTestParameter(Spire.Xls.Worksheet sheet) { TestParameters pars = new TestParameters(); int blankRows = 0; //避免出错 int num = 0; //默认最多两百行 while (num++ < 200) { //索引从1开始 string col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : ""; col1 = col1.Trim(); if (string.IsNullOrEmpty(col1)) { blankRows++; if (blankRows > 5) { //连续5个空行以上则退出 break; } } else { blankRows = 0; } if (col1.Equals("参数表")) { ///获取表中的参数 List nodes = readParameters(sheet,num); foreach (var item in nodes) { if(pars.Parameters.ContainsKey(item.Name)) { ShowMessage(MsgType.Error, string.Format("参数配置表:{0} 存在同名参数:{1},无法重复添加参数", sheet.Name, item.Name)); continue; } pars.Parameters.Add(item.Name, item); } //解析行数跳过,实际上还得再加上 num = num + nodes.Count +1; } else if (col1.Equals("测试显示表")) { //获取表中的原始显示界面 pars.InitialTable = readTable( sheet, num); //解析行数跳过,实际上还得再加上 num = num + pars.InitialTable.Rows.Count + 1; } } return pars; } /// /// 读参数表 /// /// /// List readParameters(Spire.Xls.Worksheet sheet,int rowIndex) { List nodes = new List(); string col1 = sheet.Range[rowIndex + 1, 1].Value2 != null ? sheet.Range[rowIndex + 1, 1].Value2.ToString() : ""; string col2 = sheet.Range[rowIndex + 1, 2].Value2 != null ? sheet.Range[rowIndex + 1, 2].Value2.ToString() : ""; string col3 = sheet.Range[rowIndex + 1, 3].Value2 != null ? sheet.Range[rowIndex + 1, 3].Value2.ToString() : ""; string col4 = sheet.Range[rowIndex + 1, 4].Value2 != null ? sheet.Range[rowIndex + 1, 4].Value2.ToString() : ""; if (!(col1 == "名称" && col2 == "类型" && col3 == "值")) { ShowMessage(MsgType.Error, "'参数表'行首标题位置和格式不正确"); return nodes; } int num = rowIndex + 1; //默认最多30行 while (num++ < rowIndex + 200) { col1 = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : ""; col2 = sheet.Range[num, 2].Value2 != null ? sheet.Range[num, 2].Value2.ToString() : ""; col3 = sheet.Range[num, 3].Value2 != null ? sheet.Range[num, 3].Value2.ToString() : ""; col4 = sheet.Range[num, 4].Value2 != null ? sheet.Range[num, 4].Value2.ToString() : ""; if (string.IsNullOrEmpty(col1) || string.IsNullOrEmpty(col2) || string.IsNullOrEmpty(col3)) { break; } ParameterNode pn = new ParameterNode(); pn.Name = col1; pn.Type = col2; pn.StrValue = col3; pn.Mark = col4; nodes.Add(pn); } return nodes; } /// /// 读表格,人工测试表和测试显示表 /// /// /// DataTable readTable(Spire.Xls.Worksheet sheet, int rowIndex) { //先创建列,再创建行 DataTable dt = new DataTable(); int num = 0; while (num++ < 50) { string col = sheet.Range[rowIndex + 1, num].Value2 != null ? sheet.Range[rowIndex + 1, num].Value2.ToString() : ""; if (string.IsNullOrEmpty(col)) break; dt.Columns.Add(col); } //再创建行 num = rowIndex + 1; //默认最多200行 while (num++ < rowIndex + 200) { //首列无值就认为表格结束 string val = sheet.Range[num, 1].Value2 != null ? sheet.Range[num, 1].Value2.ToString() : ""; if (string.IsNullOrEmpty(val.Trim())) break; DataRow dr = dt.NewRow(); dt.Rows.Add(dr); for (int i = 0; i < dt.Columns.Count; i++) { val = sheet.Range[num, i+1].Value2 != null ? sheet.Range[num, i+1].Value2.ToString() : ""; dr[i] = val; } } return dt; } /// /// 检查仪器是否正常配置 /// /// public bool CheckDevices() { bool ok = true; AppLibs.Devices.IDeviceHost devHost = Bundle.host.GetFirstOrDefaultService(); foreach (DeviceNode device in this.Devices) { DeviceParameter dev = devHost.GetFirstOrDefaultDeviceID(device.DeviceHandle); if (dev == null || !(device.DeviceType == dev.DeviceType && device.DeviceModel == dev.DeviceModel)) { device.State = false; ok = false; } else { device.State = true; continue; } } return ok; } /// /// /// /// 按照指标分组还是按照通道分组 public void Start(bool isOrderByChannel) { ShowMessage(MsgType.Info, string.Format("序列号:{0} 测试开始",Serial)); isStop = false; //清空测试数据 // BaseModel.TestResults.Clear(); //选择勾选项 List nodes = this.TestNodes.Where(x => x.IsSelected == true).ToList(); if(isOrderByChannel) { //按照通道分组 foreach (IGrouping group in nodes.GroupBy(x => x.Channel)) { //排序后执行 foreach (TestNode testnode in group.OrderBy(a => a.Order)) { if(isStop == false) { ShowMessage(MsgType.Info, string.Format("开始执行测试指标:{0}/{1}", testnode.Channel, testnode.Name)); if(testnode.TestModel != null) { //测试中途取消了勾选项 if(testnode.IsSelected) { currModel = testnode.TestModel; testnode.TestModel.Start(testnode); } } else { ShowMessage(MsgType.Error, string.Format("测试指标:{0}/{1} 没有实例化执行模块", testnode.Channel, testnode.Name)); } } else { break; } } } } else { //按照指标名称进行 foreach (IGrouping group in nodes.GroupBy(x => x.Name)) { //排序后执行 foreach (TestNode testnode in group.OrderBy(a => a.Order)) { if (isStop == false) { ShowMessage(MsgType.Info, string.Format("开始执行测试指标:{0}/{1}", testnode.Channel, testnode.Name)); if (testnode.TestModel != null) { currModel = testnode.TestModel; testnode.TestModel.Start(testnode); } else { ShowMessage(MsgType.Error, string.Format("测试指标:{0}/{1} 没有实例化执行模块", testnode.Channel, testnode.Name)); } } else { break; } } } } //保存自动测试记录表 SaveTestTable(); ShowMessage(MsgType.Info, string.Format("序列号:{0} 测试完成", Serial)); } bool isStop = false; BaseModel currModel = null; public void Stop() { isStop = true; if(currModel!= null) { currModel.Stop(); } ShowMessage(MsgType.Info, string.Format("序列号:{0} 测试中止", Serial)); } public event DltShowMsg MessageEvent; /// /// 本对象显示消息,以及测试指标显示消息都经过这个方法 /// /// /// void ShowMessage(MsgType msgType, string msg) { if(MessageEvent != null) { MessageEvent(msgType, msg); } } public void ResetTestTable() { if(this.InitTestTable != null) { TestTable = this.InitTestTable.Copy(); } } public void ResetManualTable() { if (this.InitManualTable != null) { ManualTable = this.InitManualTable.Copy(); } } public AppLibs.Devices.IVISA GetDevice(string name) { DeviceNode node = this.Devices.FirstOrDefault(x => x.DeviceName == name); //不存在或者状态不对,都返回空 if(node == null || node.State == false) { return null; } else { AppLibs.Devices.IDeviceHost devHost = Bundle.host.GetFirstOrDefaultService(); if (devHost == null) return null; DeviceParameter dev = devHost.GetFirstOrDefaultDeviceID(node.DeviceHandle); //要地址,名称,型号一致 if (dev == null || !(node.DeviceType == dev.DeviceType && node.DeviceModel == dev.DeviceModel)) { return null; } else { return (IVISA)dev; } } } public void SetManualTableCellValue(int row, int col, bool ok, object value) { if (ManualTableCellChanged != null) ManualTableCellChanged(row, col,ok, value); } public void SetTestTableCellValue(int row, int col, bool ok, object value) { if (TestTableCellChanged != null) TestTableCellChanged(row, col, ok, value); } void SaveTestTable() { if(string.IsNullOrEmpty(Serial)) { ShowMessage(MsgType.Info, "序列号为空,数据不保存"); return; } AppLibs.Function.IReportHost report = Bundle.host.GetFirstOrDefaultService(); if(report != null) { AppLibs.Models.TableInfo tableInfo = new AppLibs.Models.TableInfo(); tableInfo.data = TestTable; tableInfo.table = new AppLibs.Models.Table(); tableInfo.table.Result = "合格"; tableInfo.table.Temperature = Temperature; tableInfo.table.Tester = Tester; tableInfo.table.Time = DateTime.Now; tableInfo.table.Place = Place; tableInfo.table.Serial = Serial; tableInfo.table.Humidity = Humidity; tableInfo.table.Type = TestProject; tableInfo.table.ProductCode = Product; tableInfo.table.ProductName = Product; tableInfo.table.Name = TestProject + "#" + Product; if (report.WriteAndReplaceTable(tableInfo)) { ShowMessage(MsgType.Info, "自动测试记录表保存成功"); } else { ShowMessage(MsgType.Info, "自动测试记录表保存失败"); } } else { ShowMessage(MsgType.Info, "软件未包含数据存储模块"); } } //判断某个测试项是否勾选 public bool IsTestItemSelected(string channel , string name) { var node = this.TestNodes.FirstOrDefault(x => x.Channel == channel && x.Name == name); if (node == null) return false; return node.IsSelected; } #endregion #region 二次修改的方法 #endregion } }