1. 优化gts板卡回原点操作 2. 添加数据精度配置 3. 添加HalconTool异常捕捉分类和部分非空判断

xcd

2020-08-19 e54c5a471c372e314f89c340644ddda98ab063bb

 src/Bro.M071.Process/M071Process.cs

@@ -5,13 +5,17 @@
using Bro.M071.DBManager;
using Bro.M071.Model;
using Bro.M071.Model.Model;
using Bro.M071.Process.UI;
using Bro.Process;
using HalconDotNet;
using Newtonsoft.Json;
using OfficeOpenXml;
using OfficeOpenXml.Style;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Drawing.Imaging;
using System.IO;
using System.Linq;
using System.Text;
@@ -44,6 +48,9 @@
        public event Action OnFullResetDone;
        #endregion

        string _precision = "f3";


        public override void Open()
        {
            InitialSetting();
@@ -59,6 +66,11 @@

            Reset(null, null, null);
            FullReset(null);

            if (Config.Precision > 0)
            {
                _precision = "f" + Config.Precision;
            }
        }

        private void InitialMotionCardBaseAxisAlarm()
@@ -72,14 +84,14 @@

        private void MotionCard_OnAxisAlarmRaised(int axisIndex, string alarmMsg)
        {
            RaisedAlarm(alarmMsg); 
            RaisedAlarm(alarmMsg);
            MachineState = MachineState.Alarm;
        }

        private void InitialSetting()
        {
            //数据库迁移检查
            DatabaseInitialize.Initialize();
            //DatabaseInitialize.Initialize();

            MotionCardSettingCheck();

@@ -178,6 +190,11 @@
        [ProcessMethod("", "StartJob", "开始扫描", InvokeType.TestInvoke)]
        public ProcessResponse StartJob(IOperationConfig opConfig, IDevice invokeDevice, IDevice sourceDevice)
        {
            if (!IsAllowedWork)
            {
                throw new ProcessException(SafetyMsg, null, ExceptionLevel.Fatal);
            }

            if (MachineState != MachineState.Ready)
                throw new ProcessException("机台未就绪，请勿开始测量", null, ExceptionLevel.Fatal);

@@ -188,7 +205,7 @@
            }

            MachineState = MachineState.Running;
            OnMeasureStart?.BeginInvoke(null, null);
            OnMeasureStart?.Invoke();

            var measurements = Config.MeasurementUnitCollection.Where(u => u.IsEnabled).ToList().DeepSerializeClone();
            measurements.ForEach(m =>
@@ -218,9 +235,12 @@

            Config.SnapshotPointCollection.Where(u => u.IsEnabled).ToList().ForEach(s =>
                  {
                      _pauseHandle.WaitHandle.WaitOne();
                      _pausedHandle.Wait();

                      if (MachineState != MachineState.Running)
                      if (MachineState == MachineState.Ready)
                          return;

                      if (MachineState != MachineState.Running && MachineState != MachineState.Pause)
                      {
                          throw new ProcessException("机台状态不在运行中，退出检测");
                      }
@@ -260,7 +280,7 @@
                          return;
                      }

                      RunImageHandle(camera, s.CameraOp.OpConfig, set, s.Id, s.Name, pMeasure.Measurements);
                      RunImageHandle(s.CameraOp.OpConfig, set, s.Id, s.Name, pMeasure.Measurements);
                  });

            BarCode = "";
@@ -328,10 +348,14 @@
        {
            if (sender is ProductionMeasurement pMeasure)
            {
                lock (pMeasure)
                var production = productionList.FirstOrDefault(u => u.Barcode == pMeasure.Barcode);
                if (production == null)
                    return;

                lock (production)
                {
                    //检查是否全部完成
                    pMeasure.Measurements.ForEach(m =>
                    pMeasure.Measurements?.ForEach(m =>
                    {
                        if (m.KeyUnitCollection.All(k => k.IsDone != null))
                        {
@@ -351,27 +375,40 @@
                                    }
                                    else
                                    {
                                        var array = m.KeyUnitCollection.SelectMany(u => u.MeasureValueDict.Values.ToList().ConvertAll(v => v ?? -999)).ToArray();
                                        _halconToolDict[toolKey].InputTupleDic["INPUT_Params"] = new HTuple(array);
                                        if (!_halconToolDict[toolKey].RunProcedure(out string error))
                                        //var array = m.KeyUnitCollection.SelectMany(u => u.MeasureValueDict.Values.ToList().ConvertAll(v => v ?? -999)).ToArray();
                                        var array = m.KeyUnitCollection.SelectMany(u => u.MeasureValueDict.Values.Select(v => v ?? -999)).ToArray();

                                        if (array == null || array.Length == 0)
                                        {
                                            LogAsync(DateTime.Now, $"{m.GetDisplayText()}{m.Spec.Code}算法异常,{error}", "");
                                            LogAsync(DateTime.Now, $"{m.GetDisplayText()}{m.Spec.Code}未能获取对应检测值", "");
                                            m.Spec.ActualValue = -999;
                                        }
                                        else
                                        {
                                            m.Spec.ActualValue = _halconToolDict[toolKey].GetResultTuple("OUTPUT_Result").D;
                                            LogAsync(DateTime.Now, $"{m.GetDisplayText()}数据{m.Spec.ActualValue}，结果{(m.Spec.MeasureResult == null ? "TBD" : (m.Spec.MeasureResult == true ? "OK" : "NG"))}", "");

                                            _halconToolDict[toolKey].InputTupleDic["INPUT_Params"] = new HTuple(array);
                                            if (!_halconToolDict[toolKey].RunProcedure(out string error))
                                            {
                                                LogAsync(DateTime.Now, $"{m.GetDisplayText()}{m.Spec.Code}算法异常,{error}", "");
                                                m.Spec.ActualValue = -999;
                                            }
                                            else
                                            {
                                                m.Spec.ActualValue = double.Parse(_halconToolDict[toolKey].GetResultTuple("OUTPUT_Result").D.ToString(_precision));
                                                //LogAsync(DateTime.Now, $"{m.GetDisplayText()}数据{m.Spec.ActualValue}，结果{(m.Spec.MeasureResult == null ? "TBD" : (m.Spec.MeasureResult == true ? "OK" : "NG"))}", "");
                                            }
                                        }
                                    }
                                }

                                LogAsync(DateTime.Now, $"{m.GetDisplayText()}检测结果", $"{((m.Spec.MeasureResult ?? false) ? "OK" : "NG")}");
                                //LogAsync(DateTime.Now, $"{m.GetDisplayText()}检测结果", $"{((m.Spec.MeasureResult ?? false) ? "OK" : "NG")}");

                                IShapeElement indicator = null;
                                KeyIndicator indicator = new KeyIndicator(m.Id, m.DisplayLocation);
                                indicator.Text = (m.Spec.ActualValue == null || m.Spec.ActualValue == -999) ? "NA" : m.Spec.ActualValue.Value.ToString(_precision);
                                indicator.ResultState = m.Spec.MeasureResult;
                                pMeasure.ElementList.Add(indicator);
                                //输出图形基元到界面 
                                OnElementUpdated?.BeginInvoke(indicator, null, null);
                                OnElementUpdated?.Invoke(indicator);

                                SaveKeyImages(pMeasure.Barcode, m);

@@ -405,9 +442,11 @@
                }

                //Excel报表输出 （单个产品的excel导出）
                ExportProductionExcel(measurementUnitResultAndKeyUnitDataSet);
                //数据库保存 
                SaveProductionData(measurementUnitResultAndKeyUnitDataSet);
                //ExportProductionExcel(measurementUnitResultAndKeyUnitDataSet);

                ExportProductionInColumns(measurementUnitResultAndKeyUnitDataSet);
                ////数据库保存 
                //SaveProductionData(measurementUnitResultAndKeyUnitDataSet);

                SaveWholeImage(pMeasure);

@@ -479,18 +518,30 @@

                measurementUnitResultAndKeyUnitDataSet.ProductionMeasurementRecord = productionMeasurementRecords;

                foreach (var MeasurementUnitResult in pData.Measurements)//获取到单个测量项结果
                foreach (var measurementUnit in pData.Measurements)//获取到单个测量项结果
                {
                    MeasurementUnitResult measurementUnitResult = new MeasurementUnitResult();
                    measurementUnitResult.ProductionMeasurementRecordsId = productionMeasurementRecords.ID;
                    measurementUnitResult.MeasurementName = MeasurementUnitResult.Name;
                    measurementUnitResult.MeasurementType = MeasurementUnitResult.MeasureType;
                    measurementUnitResult.MeasurementValue = MeasurementUnitResult.Spec.ActualValue.ToString();
                    measurementUnitResult.MeasurementResult = MeasurementUnitResult.Spec.MeasureResult.Value ? "OK" : "NG";
                    measurementUnitResult.ProductionBarcode = productionMeasurementRecords.ProductionBarcode;
                    measurementUnitResult.MeasurementName = measurementUnit.GetDisplayText();

                    if (measurementUnit.MeasureType == "Alignment" || measurementUnit.MeasureType == "Slant")
                    {
                        measurementUnitResult.Keys = string.Join("-", measurementUnit.KeyUnitCollection.Select(u => u.Key));
                        measurementUnitResult.Positions = string.Join("-", measurementUnit.KeyUnitCollection.Select(u => u.KeyResultId));
                    }
                    else if (measurementUnit.MeasureType == "RowAlignment")
                    {
                        measurementUnitResult.Keys = measurementUnit.KeyUnitCollection[0].Key + "~" + measurementUnit.KeyUnitCollection[measurementUnit.KeyUnitCollection.Count() - 1].Key;
                        measurementUnitResult.Keys = measurementUnit.KeyUnitCollection[0].KeyResultId + "~" + measurementUnit.KeyUnitCollection[measurementUnit.KeyUnitCollection.Count() - 1].KeyResultId;
                    }
                    measurementUnitResult.MeasurementType = measurementUnit.MeasureType;
                    measurementUnitResult.MeasurementValue = measurementUnit.Spec.ActualValue == null ? "NA" : measurementUnit.Spec.ActualValue.Value.ToString(_precision);
                    measurementUnitResult.MeasurementResult = measurementUnit.Spec.MeasureResult.Value ? "OK" : "NG";

                    measurementUnitResults.Add(measurementUnitResult);

                    foreach (var keyUnit in MeasurementUnitResult.KeyUnitCollection)//获取单个键的测量结果
                    foreach (var keyUnit in measurementUnit.KeyUnitCollection)//获取单个键的测量结果
                    {
                        foreach (var keyValue in keyUnit.MeasureValueDict)//获取单个键的单个测量item 结果
                        {
@@ -498,9 +549,10 @@
                            if (!isExist)//已存在 不重复添加原始数据
                            {
                                KeyUnitData keyUnitData = new KeyUnitData();
                                keyUnitData.ProductionBarcode = productionMeasurementRecords.ProductionBarcode;
                                keyUnitData.Key = keyUnit.Key;
                                keyUnitData.MeasurementItem = keyValue.Key;
                                keyUnitData.ItemValue = keyValue.Value.ToString();
                                keyUnitData.ItemValue = keyValue.Value == null ? "NA" : keyValue.Value.Value.ToString(_precision);
                                keyUnitDatas.Add(keyUnitData);

                                MeasurementAndKeyDataRelation measurementAndKeyDataRelation = new MeasurementAndKeyDataRelation();
@@ -534,12 +586,14 @@
                excelExportDto.Worksheets = new List<string>() { "原始数据", "检测结果" };
                var keyUnitColumns = new Dictionary<string, string>()
                {
                    {"ProductionBarcode", "产品条码"},
                    {"Key", "键"},
                    {"MeasurementItem", "检测项"},
                    {"ItemValue", "检测值"}
                };
                var measurementUnitResultColumns = new Dictionary<string, string>()
                {
                    {"ProductionBarcode", "产品条码"},
                    {"MeasurementName", "检测名称"},
                    {"MeasurementType", "检测类型"},
                    {"MeasurementValue", "检测值"},
@@ -551,18 +605,366 @@
                excelExportDto.WorksheetDataTable[excelExportDto.Worksheets[0]] = ExcelExportHelper.ListToDataTable(measurementUnitResultAndKeyUnitDataSet.KeyUnitDataList, keyUnitColumns);
                excelExportDto.WorksheetDataTable[excelExportDto.Worksheets[1]] = ExcelExportHelper.ListToDataTable(measurementUnitResultAndKeyUnitDataSet.MeasurementUnitResultList, measurementUnitResultColumns); ;

                byte[] filecontent = ExcelExportHelper.ExportExcel(excelExportDto, false);
                string dir = Path.Combine(Config.LogPath, DateTime.Now.ToString("yyyyMMdd"));
                if (!Directory.Exists(dir))
                if (!Directory.Exists(Config.LogPath))
                {
                    Directory.CreateDirectory(dir);
                    Directory.CreateDirectory(Config.LogPath);
                }
                var fileName = Path.Combine(Config.LogPath, $"ProductionData_{DateTime.Now.ToString("yyyyMMdd")}.xlsx");

                FileStream fs = new FileStream(Path.Combine(dir, $"{measurementUnitResultAndKeyUnitDataSet.ProductionMeasurementRecord.ProductionBarcode}_{DateTime.Now.ToString("HHmmss")}.xlsx"), FileMode.Create, FileAccess.Write);
                byte[] filecontent = ExcelExportHelper.CreateOrAppendExcel(excelExportDto, fileName);
                FileStream fs = new FileStream(fileName, FileMode.Create, FileAccess.Write);
                fs.Write(filecontent, 0, filecontent.Length);
                fs.Flush();
                fs.Close();
            });
        }

        static object excelExportLock = new object();
        private async void ExportProductionInColumns(ProductionMeasurementUnitResultAndKeyUnitDataSet exportData)
        {
            if (!Config.IsCSVOutputEnabled)
                return;

            await Task.Run(() =>
            {
                lock (excelExportLock)
                {
                    if (!Directory.Exists(Config.LogPath))
                    {
                        Directory.CreateDirectory(Config.LogPath);
                    }
                    var fileName = Path.Combine(Config.LogPath, $"LDSData_{DateTime.Now.ToString("yyyyMMdd")}.xlsx");
                    //bool isExisted = File.Exists(fileName);
                    using (ExcelPackage package = new ExcelPackage(new FileInfo(fileName)))
                    {
                        ExcelWorksheet rawDataSheet = null;
                        ExcelWorksheet slantSheet = null;
                        ExcelWorksheet alignmentSheet = null;
                        ExcelWorksheet rowAlignmentSheet = null;

                        if (!package.Workbook.Worksheets.Any(s => s.Name == "RawData"))
                        {
                            package.Workbook.Worksheets.Add("RawData");
                            rawDataSheet = package.Workbook.Worksheets["RawData"];
                            for (int i = 0; i < Config.KeyNameCollection.Count; i++)
                            {
                                var cell = rawDataSheet.Cells[i + 3, 1];
                                cell.Value = Config.KeyNameCollection[i];
                                SetTitleCell(cell, false);
                            }
                        }
                        rawDataSheet = package.Workbook.Worksheets["RawData"];

                        if (!package.Workbook.Worksheets.Any(s => s.Name == "Slant"))
                        {
                            package.Workbook.Worksheets.Add("Slant");
                            slantSheet = package.Workbook.Worksheets["Slant"];

                            var keyCell = slantSheet.Cells[2, 1];
                            keyCell.Value = "Key";
                            SetTitleCell(keyCell);

                            for (int i = 0; i < Config.KeyNameCollection.Count; i++)
                            {
                                var cell = slantSheet.Cells[i + 3, 1];
                                cell.Value = Config.KeyNameCollection[i];
                                SetTitleCell(cell, false);
                            }
                        }
                        slantSheet = package.Workbook.Worksheets["Slant"];

                        if (!package.Workbook.Worksheets.Any(s => s.Name == "Alignment"))
                        {
                            package.Workbook.Worksheets.Add("Alignment");
                            alignmentSheet = package.Workbook.Worksheets["Alignment"];

                            var keysCell = alignmentSheet.Cells[2, 1];
                            keysCell.Value = "Keys";
                            SetTitleCell(keysCell);

                            var positionCell = alignmentSheet.Cells[2, 2];
                            positionCell.Value = "Positions";
                            SetTitleCell(positionCell);

                            var alignmentMeasures = exportData.MeasurementUnitResultList.Where(u => u.MeasurementType == "Alignment").ToList();
                            for (int i = 0; i < alignmentMeasures.Count(); i++)
                            {
                                var cellKeys = alignmentSheet.Cells[i + 3, 1];
                                cellKeys.Value = alignmentMeasures[i].Keys;
                                SetTitleCell(cellKeys, false);

                                var cellPosition = alignmentSheet.Cells[i + 3, 2];
                                cellPosition.Value = alignmentMeasures[i].Positions;
                                SetTitleCell(cellPosition, false);
                            }
                        }
                        alignmentSheet = package.Workbook.Worksheets["Alignment"];

                        if (!package.Workbook.Worksheets.Any(s => s.Name == "RowAlignment"))
                        {
                            package.Workbook.Worksheets.Add("RowAlignment");
                            rowAlignmentSheet = package.Workbook.Worksheets["RowAlignment"];

                            var keysCell = rowAlignmentSheet.Cells[2, 1];
                            keysCell.Value = "Keys";
                            SetTitleCell(keysCell);

                            var positionCell = rowAlignmentSheet.Cells[2, 2];
                            positionCell.Value = "Positions";
                            SetTitleCell(positionCell);

                            var rowAlignmentMeasures = exportData.MeasurementUnitResultList.Where(u => u.MeasurementType == "RowAlignment").ToList();
                            for (int i = 0; i < rowAlignmentMeasures.Count(); i++)
                            {
                                var cellKeys = rowAlignmentSheet.Cells[i + 3, 1];
                                cellKeys.Value = rowAlignmentMeasures[i].Keys;
                                SetTitleCell(cellKeys, false);

                                var cellPosition = rowAlignmentSheet.Cells[i + 3, 2];
                                cellPosition.Value = rowAlignmentMeasures[i].Positions;
                                SetTitleCell(cellPosition, false);
                            }
                        }
                        rowAlignmentSheet = package.Workbook.Worksheets["RowAlignment"];

                        #region RawData
                        {
                            //rawDataSheet = package.Workbook.Worksheets["RawData"];

                            int rowDataStartCol = rawDataSheet.Dimension.Columns;
                            var barcodeCell = rawDataSheet.Cells[1, rowDataStartCol + 1, 1, rowDataStartCol + 4];
                            barcodeCell.Merge = true;
                            barcodeCell.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
                            barcodeCell.Value = exportData.ProductionMeasurementRecord.ProductionBarcode;
                            SetTitleCell(barcodeCell);

                            var z1Cell = rawDataSheet.Cells[2, rowDataStartCol + 1];
                            z1Cell.Value = "Z1";
                            SetTitleCell(z1Cell);

                            var z2Cell = rawDataSheet.Cells[2, rowDataStartCol + 2];
                            z2Cell.Value = "Z2";
                            SetTitleCell(z2Cell);

                            var z3Cell = rawDataSheet.Cells[2, rowDataStartCol + 3];
                            z3Cell.Value = "Z3";
                            SetTitleCell(z3Cell);

                            var z4Cell = rawDataSheet.Cells[2, rowDataStartCol + 4];
                            z4Cell.Value = "Z4";
                            SetTitleCell(z4Cell);

                            exportData.KeyUnitDataList.ForEach(k =>
                            {
                                int keyIndex = Config.KeyNameCollection.IndexOf(k.Key);
                                if (keyIndex < 0)
                                {
                                    LogAsync(DateTime.Now, "Excel导出错误", $"{k.Key}的RawData未能获取行信息，未导出");
                                    return;
                                }

                                int zIndex = int.Parse(k.MeasurementItem.Substring(1));

                                var cell = rawDataSheet.Cells[keyIndex + 1 + 2, rowDataStartCol + zIndex];
                                cell.Value = string.IsNullOrWhiteSpace(k.ItemValue) ? "NA" : k.ItemValue;
                            });
                        }
                        #endregion

                        #region Slant
                        var slantMeasures = exportData.MeasurementUnitResultList.Where(u => u.MeasurementType == "Slant").ToList();
                        if (slantMeasures.Count > 0)
                        {
                            int slantStartCol = slantSheet.Dimension.Columns;

                            //var barcodeCell = slantSheet.Cells[1, slantStartCol + 1, 1, slantStartCol + 2];
                            //barcodeCell.Merge = true;
                            //barcodeCell.Value = exportData.ProductionMeasurementRecord.ProductionBarcode;
                            //SetTitleCell(barcodeCell);

                            var barcodeCell = slantSheet.Cells[1, slantStartCol + 1];
                            barcodeCell.Value = exportData.ProductionMeasurementRecord.ProductionBarcode;
                            SetTitleCell(barcodeCell);

                            var valueCell = slantSheet.Cells[2, slantStartCol + 1];
                            valueCell.Value = "Value";
                            SetTitleCell(valueCell);

                            //var resultCell = slantSheet.Cells[2, slantStartCol + 2];
                            //resultCell.Value = "Result";
                            //SetTitleCell(resultCell);

                            slantMeasures.ForEach(m =>
                            {
                                int rowIndex = Config.KeyNameCollection.IndexOf(m.Keys);
                                if (rowIndex < 0)
                                {
                                    LogAsync(DateTime.Now, "Excel导出错误", $"{m.Keys}的Slant未能获取行信息，未导出");
                                    return;
                                }

                                var cellValue = slantSheet.Cells[rowIndex + 1 + 2, slantStartCol + 1];
                                //var cellResult = slantSheet.Cells[rowIndex + 1 + 2, slantStartCol + 2];

                                cellValue.Value = m.MeasurementValue;
                                //cellResult.Value = m.MeasurementResult;

                                if (m.MeasurementResult != "OK")
                                {
                                    SetNGCell(cellValue);
                                    //SetNGCell(cellResult);
                                }
                            });
                        }
                        #endregion

                        #region Alignment
                        {
                            var alignmentMeasures = exportData.MeasurementUnitResultList.Where(u => u.MeasurementType == "Alignment").ToList();
                            if (alignmentMeasures.Count > 0)
                            {
                                List<string> keysList = new List<string>();
                                int allRowNums = alignmentSheet.Dimension.Rows;
                                int aligneStartCol = alignmentSheet.Dimension.Columns;

                                for (int i = 3; i <= alignmentSheet.Dimension.End.Row; i++)
                                {
                                    string keys = alignmentSheet.Cells[i, 1].Value.ToString();
                                    string position = alignmentSheet.Cells[i, 2].Value.ToString();

                                    keysList.Add($"{keys}_{position}");
                                }

                                //var barcodeCell = alignmentSheet.Cells[1, aligneStartCol + 1, 1, aligneStartCol + 2];
                                //barcodeCell.Merge = true;
                                //barcodeCell.Value = exportData.ProductionMeasurementRecord.ProductionBarcode;
                                //SetTitleCell(barcodeCell);

                                var barcodeCell = alignmentSheet.Cells[1, aligneStartCol + 1];
                                barcodeCell.Value = exportData.ProductionMeasurementRecord.ProductionBarcode;
                                SetTitleCell(barcodeCell);

                                var valueCell = alignmentSheet.Cells[2, aligneStartCol + 1];
                                valueCell.Value = "Value";
                                SetTitleCell(valueCell);

                                //var resultCell = alignmentSheet.Cells[2, aligneStartCol + 2];
                                //resultCell.Value = "Result";
                                //SetTitleCell(resultCell);

                                alignmentMeasures.ForEach(a =>
                                {
                                    int rowIndex = keysList.IndexOf($"{a.Keys}_{a.Positions}");
                                    if (rowIndex < 0)
                                    {
                                        LogAsync(DateTime.Now, "Excel导出错误", $"{a.Keys}_{a.Positions}的Alignment未能获取行信息，未导出");
                                        return;
                                    }

                                    var cellValue = alignmentSheet.Cells[rowIndex + 1 + 2, aligneStartCol + 1];
                                    //var cellResult = alignmentSheet.Cells[rowIndex + 1 + 2, aligneStartCol + 2];

                                    cellValue.Value = a.MeasurementValue;
                                    //cellResult.Value = a.MeasurementResult;

                                    if (a.MeasurementResult != "OK")
                                    {
                                        SetNGCell(cellValue);
                                        //SetNGCell(cellResult);
                                    }
                                });
                            }
                        }
                        #endregion

                        #region RowAlignment
                        {
                            var rowAlignmentMeasures = exportData.MeasurementUnitResultList.Where(u => u.MeasurementType == "RowAlignment").ToList();
                            if (rowAlignmentMeasures.Count > 0)
                            {
                                List<string> keysList = new List<string>();
                                int allRowNums = rowAlignmentSheet.Dimension.Rows;
                                int aligneStartCol = rowAlignmentSheet.Dimension.Columns;

                                for (int i = 3; i <= allRowNums; i++)
                                {
                                    string keys = alignmentSheet.Cells[i, 1].Value.ToString();
                                    string position = alignmentSheet.Cells[i, 2].Value.ToString();

                                    keysList.Add($"{keys}_{position}");
                                }

                                //var barcodeCell = rowAlignmentSheet.Cells[1, aligneStartCol + 1, 1, aligneStartCol + 2];
                                //barcodeCell.Merge = true;
                                //barcodeCell.Value = exportData.ProductionMeasurementRecord.ProductionBarcode;
                                //SetTitleCell(barcodeCell);

                                var barcodeCell = rowAlignmentSheet.Cells[1, aligneStartCol + 1];
                                barcodeCell.Value = exportData.ProductionMeasurementRecord.ProductionBarcode;
                                SetTitleCell(barcodeCell);

                                var valueCell = rowAlignmentSheet.Cells[2, aligneStartCol + 1];
                                valueCell.Value = "Value";
                                SetTitleCell(valueCell);

                                //var resultCell = rowAlignmentSheet.Cells[2, aligneStartCol + 2];
                                //resultCell.Value = "Result";
                                //SetTitleCell(resultCell);

                                rowAlignmentMeasures.ForEach(a =>
                                {
                                    int rowIndex = keysList.IndexOf($"{a.Keys}_{a.Positions}");
                                    if (rowIndex < 0)
                                    {
                                        LogAsync(DateTime.Now, "Excel导出错误", $"{a.Keys}_{a.Positions}的RowAlignment未能获取行信息，未导出");
                                        return;
                                    }

                                    var cellValue = rowAlignmentSheet.Cells[rowIndex + 1 + 2, aligneStartCol + 1];
                                    //var cellResult = rowAlignmentSheet.Cells[rowIndex + 1 + 2, aligneStartCol + 2];

                                    cellValue.Value = a.MeasurementValue;
                                    //cellResult.Value = a.MeasurementResult;

                                    if (a.MeasurementResult != "OK")
                                    {
                                        SetNGCell(cellValue);
                                        //SetNGCell(cellResult);
                                    }
                                });
                            }
                        }
                        #endregion

                        package.Save();
                    };
                }
            });
        }

        private void SetNGCell(ExcelRange cell)
        {
            cell.Style.Font.Color.SetColor(Color.Red);
            cell.Style.Font.Bold = true;
            //cell.Style.Fill.PatternType = ExcelFillStyle.Solid;
            //cell.Style.Fill.BackgroundColor.SetColor(Color.Red);
        }

        private void SetTitleCell(ExcelRange cell, bool isCenterAlign = true)
        {
            cell.Style.Font.Color.SetColor(Color.White);
            cell.Style.Font.Bold = true;
            cell.Style.Fill.PatternType = ExcelFillStyle.Solid;
            cell.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(31, 73, 125));
            cell.AutoFitColumns();
            if (isCenterAlign)
            {
                cell.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
            }
            else
            {
                cell.Style.HorizontalAlignment = ExcelHorizontalAlignment.Left;
            }
        }

        #region 图像保存
@@ -589,7 +991,7 @@
                    Directory.CreateDirectory(dir);
                }

                map.Save(Path.Combine(dir, $"{pMeasure.Barcode}_{DateTime.Now.ToString("HHmmss")}.bmp"));
                map.Save(Path.Combine(dir, $"{pMeasure.Barcode}_{pMeasure.PResult}_{DateTime.Now.ToString("HHmmss")}.png"), ImageFormat.Png);
            }
            catch (Exception ex)
            {
@@ -637,8 +1039,16 @@
                    int i = 0;
                    u.KeyImages?.ForEach(image =>
                    {
                        string fileName = Path.Combine(dir, $"{measureName}_{u.Key}{(i == 0 ? "" : $"-{i}")}_{DateTime.Now.ToString("HHmmss")}.tiff");
                        image.WriteImage("tiff", 0, fileName);
                        string fileName = "";
                        try
                        {
                            fileName = Path.Combine(dir, $"{measureName}_{u.Key}{(i == 0 ? "" : $"-{i}")}_{DateTime.Now.ToString("HHmmss")}.tiff");
                            image.WriteImage("tiff", 0, fileName);
                        }
                        catch (Exception)
                        {
                            LogAsync(DateTime.Now, "切图保存失败", fileName);
                        }
                        i++;
                    });

@@ -648,7 +1058,7 @@
        }
        #endregion

        private async void RunImageHandle(CameraBase camera, IOperationConfig opConfig, IImageSet imgSet, string snapshotId, string snapshotName, List<MeasurementUnit> measureList)
        private async void RunImageHandle(IOperationConfig opConfig, IImageSet imgSet, string snapshotId, string snapshotName, List<MeasurementUnit> measureList)
        {
            await Task.Run(() =>
             {
@@ -656,8 +1066,11 @@
                 var keyBindCollection = measureList.SelectMany(u => u.KeyUnitCollection).Where(u => keys.Any(k => k.Key == u.Key)).ToList();

                 string toolKey = (opConfig as CameraOprerationConfigBase).AlgorithemPath;
                 HObject images = imgSet.HImage;
                 //HObject images = imgSet.HImage;

                 HObject images = new HObject();
                 LaserScanParam scanParam = JsonConvert.DeserializeObject<LaserScanParam>(imgSet.ImageData);
                 LogAsync(DateTime.Now, $"扫描参数:{imgSet.ImageData}", "");

                 if (!string.IsNullOrWhiteSpace(toolKey))
                 {
@@ -668,6 +1081,9 @@
                         keyBindCollection.ForEach(k => k.FillKeyValues(null));
                         return;
                     }

                     //string fileName = Path.Combine(Config.ImageSaveFolder, "BeforeRun", $"{DateTime.Now.ToString("yyyyMMddHHmmssfff")}.tif");
                     //imgSet.HImage.WriteImage("tiff", 0, fileName);

                     _halconToolDict[toolKey].InputImageDic["INPUT_Image"] = imgSet.HImage;
                     if (!_halconToolDict[toolKey].RunProcedure(out string error))
@@ -681,6 +1097,7 @@
                 }

                 HOperatorSet.CountObj(images, out HTuple count);
                 LogAsync(DateTime.Now, $"{snapshotName}切图{count.I}张", "");

                 if (count == 0)
                 {
@@ -689,7 +1106,7 @@
                     return;
                 }

                 var excludeKeys = keys.Where(u => u.ImageSeq > count).ToList();
                 var excludeKeys = keys.Where(u => u.ImageSeq > count.I).ToList();
                 if (excludeKeys.Count > 0)
                 {
                     LogAsync(DateTime.Now, $"{string.Join(" ", excludeKeys.Select(u => u.AliasName))}未在图片获取序列中", "");
@@ -699,9 +1116,22 @@
                          });
                 }

                 Parallel.For(1, count.I, (i) =>
                 //string dir = Path.Combine(Config.ImageSaveFolder, "Clips", $"{DateTime.Now.ToString("yyyyMMdd")}", $"{snapshotName}_{DateTime.Now.ToString("HHmmss")}");
                 //if (!Directory.Exists(dir))
                 //{
                 //    Directory.CreateDirectory(dir);
                 //}

                 //Parallel.For(1, count.I + 1, (i) =>
                 for (int i = 1; i <= count.I; i++)
                 {
                     HOperatorSet.SelectObj(images, out HObject image, i);

                     //string fileName = Path.Combine(dir, $"{i}.tif");
                     //using (HImage temp = image.ConvertHObjectToHImage())
                     //{
                     //    temp.WriteImage("tiff", 0, fileName);
                     //}

                     keys.Where(u => u.ImageSeq == i).ToList().ForEach(k =>
                         {
@@ -717,21 +1147,26 @@
                             else
                             {
                                 _halconToolDict[keyToolKey].InputImageDic["INPUT_Image"] = image;
                                 _halconToolDict[keyToolKey].InputTupleDic["INPUT_Resolution_X"] = scanParam.Resolution_X;
                                 _halconToolDict[keyToolKey].InputTupleDic["INPUT_Resolution_Z"] = scanParam.Resolution_Z;
                                 _halconToolDict[keyToolKey].InputTupleDic["INPUT_Resolution_X"] = scanParam.Resolution_X / 1000000.0;
                                 _halconToolDict[keyToolKey].InputTupleDic["INPUT_Resolution_Y"] = scanParam.Resolution_Y / 1000000.0;
                                 _halconToolDict[keyToolKey].InputTupleDic["INPUT_Resolution_Z"] = scanParam.Resolution_Z / 1000000.0;
                                 _halconToolDict[keyToolKey].InputTupleDic["INPUT_ImageId"] = $"{k.AliasName}_{DateTime.Now.ToString("HHmmssfff")}.tif";
                                 if (!_halconToolDict[keyToolKey].RunProcedure(out string error))
                                 {
                                     LogAsync(DateTime.Now, $"{k.AliasName}检测算法异常，{error}", "");
                                 }
                                 else
                                 {
                                     var results = _halconToolDict[keyToolKey].GetResultTuple("OUTPUT_Results").HTupleToDouble();
                                     var results = _halconToolDict[keyToolKey].GetResultTuple("OUTPUT_Results").DArr.ToList();
                                     if (results.Count == 0 || results.Any(u => u < 0))
                                     {
                                         LogAsync(DateTime.Now, $"{k.AliasName}检测结果异常", "");
                                         LogAsync(DateTime.Now, $"{k.AliasName}原始数据异常", "");
                                     }
                                     else
                                     {
                                         //LogAsync(DateTime.Now, $"{k.AliasName}原始数据", $"{string.Join(" ", results)}");

                                         results = results.Select(u => u - Config.PlanCompensation).ToList();
                                         resultDict = k.KeyResultList.ToDictionary(u => u, u =>
                                              {
                                                  int index = k.KeyResultList.IndexOf(u);
@@ -743,14 +1178,16 @@

                             keyBindList.ForEach(kb =>
                             {
                                 kb.KeyImages.Add(image.Clone() as HImage);
                                 kb.KeyImages.Add(image.ConvertHObjectToHImage());
                                 kb.FillKeyValues(resultDict);
                             });
                         });

                     image.Dispose();
                 });
                 }
                 //);

                 images.Dispose();
                 //if (count.I != 1)
                 //{
                 //    hImage?.Dispose();