using Bro.M141.Process;
|
using Bro.UI.Model.Winform;
|
using NPOI.SS.Formula.Functions;
|
using NPOI.SS.UserModel;
|
using NPOI.Util;
|
using Org.BouncyCastle.Asn1.X509;
|
using Sunny.UI;
|
using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.IO;
|
using System.Linq;
|
using System.Reflection;
|
using System.Text;
|
using System.Threading.Tasks;
|
using System.Windows.Forms;
|
using static Bro.Common.Helper.EnumHelper;
|
using static NPOI.HSSF.Util.HSSFColor;
|
using static System.Windows.Forms.AxHost;
|
|
namespace Bro.M135.Process.UI
|
{
|
//[MenuNode("点检", "点检", 2, TopMenu.SystemInfo, MenuNodeType.Form)]
|
public partial class SpotCheck : MenuFormBase
|
{
|
M141Process prM141Process => Process as M141Process;
|
public SpotCheck()
|
{
|
InitializeComponent();
|
}
|
private void initGrid(List<Produre> DataModelList)
|
{
|
M141Config eM141Config = prM141Process.Config as M141Config;
|
double CheckInfo = 0.1;// eM141Config.Check;
|
|
//var SpectList = eM141Config.GetSpecList();
|
foreach (Produre produre in DataModelList)
|
{
|
produre.CheckValue = "OK";
|
foreach (var item in produre.Value)
|
{
|
if (!double.TryParse(item.Value, out double Number1))
|
{
|
if (item.Value != item.ProValue)
|
{
|
produre.CheckValue = "NG";
|
break;
|
}
|
}
|
else
|
{
|
|
//var spc = SpectList.FirstOrDefault(ss => ss.Code == item.Name);
|
double standardVlaue = double.Parse(item.Value);
|
if (item.ProValue != null)
|
{
|
if (Math.Abs(double.Parse(item.ProValue) - standardVlaue) / standardVlaue < CheckInfo)
|
{
|
produre.CheckValue = "OK";
|
break;
|
}
|
else
|
{
|
produre.CheckValue = "NG";
|
break;
|
}
|
}
|
else
|
{
|
if (item.ProValue == null)
|
{
|
rTLog.AppendText("生产数据中无" + item.Name + "列\r\n");
|
}
|
}
|
}
|
}
|
}
|
Produre Fristprodure = DataModelList.FirstOrDefault();
|
grid.Redim(DataModelList.Count() + 2, Fristprodure.Value.Count() * 2 + 3);
|
SourceGrid.Cells.Views.Cell titleModel = new SourceGrid.Cells.Views.Cell();
|
titleModel.BackColor = Color.SteelBlue;
|
titleModel.ForeColor = Color.White;
|
titleModel.TextAlignment = DevAge.Drawing.ContentAlignment.MiddleCenter;
|
SourceGrid.Cells.Views.Cell captionModel = new SourceGrid.Cells.Views.Cell();
|
captionModel.BackColor = grid.BackColor;
|
int currentRow = 0;
|
|
grid[currentRow, 2] = new SourceGrid.Cells.Cell("标准值");
|
grid[currentRow, 2].View = captionModel;
|
grid[currentRow, 2].ColumnSpan = Fristprodure.Value.Count();
|
|
|
grid[currentRow, Fristprodure.Value.Count() + 2] = new SourceGrid.Cells.Cell("检测值");
|
grid[currentRow, Fristprodure.Value.Count() + 2].View = captionModel;
|
grid[currentRow, Fristprodure.Value.Count() + 2].ColumnSpan = Fristprodure.Value.Count();
|
|
currentRow = 1;
|
grid[currentRow, 2 * Fristprodure.Value.Count() + 2] = new SourceGrid.Cells.Cell("点检结果");
|
grid[currentRow, 2 * Fristprodure.Value.Count() + 2].View = captionModel;
|
|
|
|
grid[currentRow, 0] = new SourceGrid.Cells.Cell("时间");
|
grid[currentRow, 0].View = titleModel;
|
grid[currentRow, 1] = new SourceGrid.Cells.Cell("条码");
|
grid[currentRow, 1].View = titleModel;
|
|
int CloumnIndex = 2;
|
|
|
if (Fristprodure != null)
|
{
|
var ListModel = Fristprodure.Value;
|
foreach (var item in ListModel)
|
{
|
grid[currentRow, CloumnIndex] = new SourceGrid.Cells.Cell(item.Name);
|
grid[currentRow, CloumnIndex].View = titleModel;
|
CloumnIndex++;
|
}
|
foreach (var item in ListModel)
|
{
|
grid[currentRow, CloumnIndex] = new SourceGrid.Cells.Cell(item.Name);
|
grid[currentRow, CloumnIndex].View = titleModel;
|
CloumnIndex++;
|
}
|
}
|
|
foreach (Produre eProdure in DataModelList)
|
{
|
currentRow++;
|
|
grid[currentRow, 0] = new SourceGrid.Cells.Cell(eProdure.DateTime);
|
grid[currentRow, 0].View = captionModel;
|
|
grid[currentRow, 1] = new SourceGrid.Cells.Cell(eProdure.Code);
|
grid[currentRow, 1].View = captionModel;
|
int CloumnIndexinfo = 2;
|
foreach (var item in eProdure.Value)
|
{
|
grid[currentRow, CloumnIndexinfo] = new SourceGrid.Cells.Cell(item.Value);
|
grid[currentRow, CloumnIndexinfo].View = captionModel;
|
CloumnIndexinfo++;
|
}
|
foreach (var item in eProdure.Value)
|
{
|
grid[currentRow, CloumnIndexinfo] = new SourceGrid.Cells.Cell(item.ProValue);
|
grid[currentRow, CloumnIndexinfo].View = captionModel;
|
CloumnIndexinfo++;
|
}
|
|
grid[currentRow, CloumnIndexinfo] = new SourceGrid.Cells.Cell(eProdure.CheckValue);
|
grid[currentRow, CloumnIndexinfo].View = captionModel;
|
}
|
grid.AutoSizeCells();
|
grid.AutoStretchColumnsToFitWidth = true;
|
grid.Columns.StretchToFit();
|
|
}
|
private void btLoadprodure_Click(object sender, EventArgs e)
|
{
|
OpenFileDialog dialog = new OpenFileDialog();
|
if (dialog.ShowDialog() == DialogResult.OK)
|
{
|
this.tbProdure.Text = dialog.FileName;
|
}
|
|
}
|
|
private void btLoadTmp_Click(object sender, EventArgs e)
|
{
|
OpenFileDialog dialog = new OpenFileDialog();
|
if (dialog.ShowDialog() == DialogResult.OK)
|
{
|
this.tbCheck.Text = dialog.FileName;
|
}
|
}
|
|
private void BtCompensate_Click(object sender, EventArgs e)
|
{
|
List<Produre> DataModelList = new List<Produre>();
|
int proNumber = 0;
|
using (var stream = File.OpenRead(tbCheck.Text))
|
{
|
IWorkbook FileIWorkbook = WorkbookFactory.Create(stream);
|
ISheet eISheet = FileIWorkbook.GetSheetAt(0);
|
|
int rowCount = eISheet.LastRowNum;
|
int fristrowindex = 1;
|
IRow fristrow = eISheet.GetRow(fristrowindex);
|
for (int i = 2; i < rowCount; i++)
|
{
|
IRow Row = eISheet.GetRow(i);
|
|
if (Row != null)
|
{
|
Produre eProdure = new Produre();
|
eProdure.DateTime = DateTime.Now.ToString("yyyy-MM-dd HH:MM:SS");
|
if (Row.GetCell(1).CellType == CellType.Numeric)
|
{
|
eProdure.Code = Row.GetCell(1).NumericCellValue.ToString();
|
}
|
else
|
{
|
eProdure.Code = Row.GetCell(1).StringCellValue;
|
}
|
if (!string.IsNullOrEmpty(eProdure.Code))
|
{
|
List<Module> eModuleList = new List<Module>();
|
for (int cloumn = 2; cloumn < Row.Count(); cloumn++)
|
{
|
Module eModule = new Module();
|
|
eModule.Name = fristrow.GetCell(cloumn).StringCellValue;
|
|
if (!eModule.Name.Contains("FAI"))
|
{
|
eModule.ProValue = "OK";
|
}
|
if (Row.GetCell(cloumn).CellType == CellType.Numeric)
|
{
|
eModule.Value = Row.GetCell(cloumn).NumericCellValue.ToString();
|
}
|
else
|
{
|
eModule.Value = Row.GetCell(cloumn).StringCellValue.ToString();
|
}
|
if (eModuleList.FirstOrDefault(x => x.Name == eModule.Name) == null)
|
{
|
|
eModuleList.Add(eModule);
|
}
|
}
|
eProdure.Value = eModuleList;
|
DataModelList.Add(eProdure);
|
}
|
|
}
|
|
}
|
if (File.Exists(tbProdure.Text))
|
{
|
proNumber = DataModelList.Count();
|
string[] ProData = File.ReadAllLines(tbProdure.Text);
|
if (proNumber > ProData.Count())
|
{
|
rTLog.AppendText("生产数据小于模板数据");
|
return;
|
}
|
int StratProRowIndex = ProData.Count() - proNumber;
|
int Rowid = 0;
|
string[] Head = ProData[0].Split(',');
|
int i = 0;
|
for (int End = StratProRowIndex; End < ProData.Count(); End++)
|
{
|
string[] proData = ProData[End].Split(',');
|
string Code = proData[1];
|
var ModelInfo = DataModelList.Get(i);
|
i++;
|
for (int ProInde = 3; ProInde < proData.Length - 1; ProInde++)
|
{
|
var ModelVar = ModelInfo.Value.FirstOrDefault(model => model.Name == Head[ProInde]);
|
if (ModelVar != null)
|
{
|
ModelVar.ProValue = proData[ProInde];
|
}
|
else
|
{
|
rTLog.AppendText("生产数据中无" + Head[ProInde] + "列\r\n");
|
}
|
|
}
|
|
}
|
}
|
initGrid(DataModelList);
|
}
|
}
|
|
private void btLoadFilePath_Click(object sender, EventArgs e)
|
{
|
M141Config eM141Config = prM141Process.Config as M141Config;
|
if (eM141Config.TmpPath != null)
|
tbCheck.Text = eM141Config.TmpPath;
|
|
string YYYYMMDD = DateTime.Now.ToString("yyyyMMdd");
|
string filepath = eM141Config.LogPath + "\\" + YYYYMMDD + "\\ProductRecord_" + YYYYMMDD + ".csv";
|
if (File.Exists(filepath))
|
{
|
this.tbProdure.Text = filepath;
|
}
|
}
|
|
private void btExport_Click(object sender, EventArgs e)
|
{
|
FileSave.ShowDialog(this);
|
string l_Path = FileSave.FileName;
|
if (!string.IsNullOrEmpty(l_Path))
|
{
|
try
|
{
|
using (System.IO.StreamWriter writer = new System.IO.StreamWriter(l_Path, false, System.Text.Encoding.Default))
|
{
|
SourceGrid.Exporter.CSV csv = new SourceGrid.Exporter.CSV();
|
csv.Export(grid, writer);
|
writer.Close();
|
}
|
|
DevAge.Shell.Utilities.OpenFile(l_Path);
|
}
|
catch (Exception err)
|
{
|
DevAge.Windows.Forms.ErrorDialog.Show(this, err, "CSV Export Error");
|
}
|
}
|
|
}
|
}
|
public class Produre
|
{
|
public string Code { get; set; }
|
public string DateTime { get; set; }
|
public List<Module> Value { get; set; }
|
|
public string CheckValue { get; set; }
|
}
|
public class Module
|
{
|
public string Name { get; set; }
|
public string Value { get; set; }
|
|
public string ProValue { get; set; }
|
}
|
}
|
