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
}
}