using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using System.IO; using Bro.Common; using Bro.Common.Util; using System.Configuration; namespace P066.Data { public partial class Form1 : Form { DirectoryInfo directoryInfo1; DirectoryInfo directoryInfo2; private P066RunParam runparam = new P066RunParam(); private ReadFile readfile = new ReadFile(); private WriteFile writefile = new WriteFile(); public Form1() { InitializeComponent(); //ConfigHelper.Save(@"D:\P066-Data\P066XML\1.xml", runparam); var configuraPath = Environment.CurrentDirectory+ "\\Config\\Jin_Mid.xml"; runparam = ConfigHelper.Load(configuraPath); } private void btnLoadData1_Click(object sender, EventArgs e) { if (folderBrowserDialog1.ShowDialog() != DialogResult.OK) return; directoryInfo1 = new DirectoryInfo(folderBrowserDialog1.SelectedPath); } private void btnLoadData2_Click(object sender, EventArgs e) { if (folderBrowserDialog1.ShowDialog() != DialogResult.OK) return; directoryInfo2 = new DirectoryInfo(folderBrowserDialog1.SelectedPath); } private void btnAnalyze_Click(object sender, EventArgs e) { #region 读取文件夹下的所有文件,并将文件按照上下进行区分;上表格为fileInfo1,下表格为fileInfo2 var fileinfos11 = directoryInfo1.GetFiles().ToList().FindAll(a => a.Extension == ".csv"); List fileInfo1 = new List(); List fileInfo2 = new List(); for (int i = 0; i < fileinfos11.Count; i++) { if (fileinfos11[i].Name.Contains("1_1") || fileinfos11[i].Name.Contains("2_1") || fileinfos11[i].Name.Contains("3_1") || fileinfos11[i].Name.Contains("4_1") ) { fileInfo1.Add(fileinfos11[i]); } else { fileInfo2.Add(fileinfos11[i]); } } #endregion List DataListMerge = new List(); var listSum = new List(); var JudgeListSum = new List(); string filename = ""; string filenameDir = ""; int WhiteI = 0; int WhiteningI = 0; int ScratchI = 0; int ZoomI = 0; int ChuNum = 0; int FuNum = 0; int GuaNum = 0; #region 读取一个表格中所有时间戳并排序 var dataList = GetFileData(fileInfo1[0]); var dataGroup = dataList.GroupBy(a => a.TimeTip); var dataListSum22 = new List(); foreach (var item in dataGroup) { dataListSum22.Add(item.Key); } dataListSum22 = dataListSum22.Distinct().ToList(); dataListSum22.Sort(); #endregion #region 读取划伤、镀膜破损文件夹文件 if (directoryInfo2 != null) { var fileinfos22 = directoryInfo2.GetFiles().ToList().FindAll(a=>a.Extension==".csv"); for (int i = 0; i < fileinfos22.Count; i++) { var list = GetFileData(fileinfos22[i]); GetMaxSize(list); if (fileinfos22[i].Name.Contains("划伤")) { ScratchI++; list.ForEach(a => a.Lensnumber = ScratchI); listSum.AddRange(list); list = GetBkLocation(list); } else if (fileinfos22[i].Name.Contains("镀膜破损")) { ZoomI++; list.ForEach(a => a.Lensnumber = ZoomI); listSum.AddRange(list); } } directoryInfo2 = null; } #endregion for (int i = 0; i < fileInfo1.Count; i++) { var list= CompareFile(fileInfo1[i], fileInfo2[i], dataListSum22); if (fileInfo1[i].Name.Contains("白点")) { WhiteI++; list.ForEach(a => a.Lensnumber = WhiteI); listSum.AddRange(list); } if (fileInfo1[i].Name.Contains("刮白")) { WhiteningI++; list.ForEach(a => a.Lensnumber = WhiteningI); listSum.AddRange(list); } #region//判断是初检文件夹还是复检文件夹 string currPath = ""; if (fileInfo1[i].Name.Contains("初检中框")) { ChuNum++; filenameDir = "初检中框白点"; filename = "初检中框白点" + ChuNum; //给镜头区分位置及角度 list = GetMidLocation(list); } else if (fileInfo1[i].Name.Contains("复检中框")&& fileInfo1[i].Name.Contains("白点")) { FuNum=FuNum+1; filenameDir = "复检中框白点"; filename = "复检中框白点" + FuNum; //给镜头区分位置及角度 list = GetMidLocation(list); } else if (fileInfo1[i].Name.Contains("复检中框") && fileInfo1[i].Name.Contains("刮白")) { GuaNum=GuaNum+1; filenameDir = "复检中框刮白"; filename = "复检中框刮白" + GuaNum; //给镜头区分位置及角度 list = GetWhiteLocation(list); } else if (fileInfo1[i].Name.Contains("初检背板")) { ChuNum++; filenameDir = "初检背板白点"; filename = "初检背板白点" + ChuNum; //给镜头区分位置及角度 list = GetBkLocation(list); } else if (fileInfo1[i].Name.Contains("复检背板") && fileInfo1[i].Name.Contains("白点")) { FuNum = FuNum + 1; filenameDir = "复检背板白点"; filename = "复检背板白点" + FuNum; //给镜头区分位置及角度 list = GetBkLocation(list); } currPath = directoryInfo1.Parent.FullName; string subPath = currPath + "/" + filenameDir + "合并后" + "/"; if (false==Directory.Exists(subPath)) { Directory.CreateDirectory(subPath); } #endregion var title1 = $"时间戳,文件名,判断,可能性,不确定性,高,宽,X,Y,最大尺寸,位置,R,角度"; var file1 = $"{subPath}\\{filename}.csv"; File.AppendAllText(file1, title1, Encoding.UTF8); File.AppendAllText(file1, "\r\n"); foreach (var item in dataListSum22) { var list11 = list.FindAll(a =>a.TimeTip==item&&!a.Result); for (int q = 0; q < list11.Count; q++) { string result = list11[q].Result ? "OK" : "NG"; var content = $"{list11[q].TimeTip},{list11[q].ImageFileName},{result},{list11[q].Probability},{list11[q].Uncertainty},{list11[q].Height},{list11[q].Width},{list11[q].X},{list11[q].Y},{list11[q].ex},{list11[q].location},{ Convert.ToInt32(list11[q].R)},{ Convert.ToInt32(list11[q].angle)}"; File.AppendAllText(file1, content, Encoding.UTF8); File.AppendAllText(file1, "\r\n"); } } } #region//将设备判断结果输出到CSV报表中 var title12 = $"时间戳,相机序号,设备判断结果,缺陷类型,设备后处理结果,最大尺寸,位置,X,Y,R,角度"; var file12 = $"{directoryInfo1.Parent.FullName}\\{filenameDir + "设备判断结果"}.csv"; File.AppendAllText(file12, title12, Encoding.UTF8); File.AppendAllText(file12, "\r\n"); foreach (var item in dataListSum22) { var Lens1 = listSum.FindAll(a => a.TimeTip == item&&a.Lensnumber==1); writefile.WriteJR(Lens1,item,1,file12); var Lens2 = listSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 2); writefile.WriteJR(Lens2,"",2,file12); var Lens3 = listSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 3); writefile.WriteJR(Lens3,"",3,file12); var Lens4 = listSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 4); writefile.WriteJR(Lens4,"",4,file12); } #endregion #region//根据产品编号输出总缺陷报表 var title = $"产品编号,镜头编号,总缺陷数量"; var file = $"{directoryInfo1.Parent.FullName}\\{filenameDir + "缺陷总数报表"}.csv"; File.AppendAllText(file, title, Encoding.UTF8); File.AppendAllText(file, "\r\n"); foreach (var item in dataListSum22) { var listLensnumber1 = listSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 1); var listLensnumberCount1 = listLensnumber1.Count; var listLensnumber2 = listSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 2); var listLensnumberCount2 = listLensnumber2.Count; var listLensnumber3 = listSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 3); var listLensnumberCount3 = listLensnumber3.Count; var listLensnumber4 = listSum.FindAll(a => a.TimeTip == item&& a.Lensnumber == 4); var listLensnumberCount4 = listLensnumber4.Count; //第一行 var content1 = $"{item},{1},{listLensnumberCount1}"; File.AppendAllText(file, content1, Encoding.UTF8); File.AppendAllText(file, "\r\n"); //第二行 var content2 = $"{""},{2},{listLensnumberCount2}"; File.AppendAllText(file, content2, Encoding.UTF8); File.AppendAllText(file, "\r\n"); //第三行 var content3 = $"{""},{3},{listLensnumberCount3}"; File.AppendAllText(file, content3, Encoding.UTF8); File.AppendAllText(file, "\r\n"); //第四行 var content4 = $"{""},{4},{listLensnumberCount4}"; File.AppendAllText(file, content4, Encoding.UTF8); File.AppendAllText(file, "\r\n"); } #endregion } #region 两个表格进行比较,如果两个表格中有设备判断标准不统一,将该点变为NG,删除两个表格中NG点相近的最小尺寸点. private List CompareFile(FileInfo fileInfo1, FileInfo fileInfo2,List DataTipsor) { var dataList1 = GetFileData(fileInfo1); var dataList2 = GetFileData(fileInfo2); var dataList = new List(); foreach (var item in DataTipsor) { var list1 = dataList1.FindAll(a => a.TimeTip == item && !a.Result); var list2 = dataList2.FindAll(a => a.TimeTip == item && !a.Result); var itemToRemove = new List(); //计算表格1最大尺寸 GetMaxSize(list1); //计算表格2最大尺寸 GetMaxSize(list2); for (int i = 0; i < list1.Count; i++) { for (int j = 0; j < list2.Count; j++) { if (list1[i].JudgmentResult != list2[j].JudgmentResult) { list1[i].JudgmentResult = list2[j].JudgmentResult = "NG"; } if (list1[i].PostTreatmentResults.Lengthlist2[j].ex) { itemToRemove.Add(list2[j]); } else { itemToRemove.Add(list1[i]); } } } } dataList.AddRange(list1); dataList.AddRange(list2); for (int i = 0; i < itemToRemove.Count; i++) { dataList.Remove(itemToRemove[i]); } } return dataList; } #endregion #region 获取中框角度和位置 private List GetMidLocation(List list) { var group = list.GroupBy(a => a.TimeTip); foreach (var item in group) { //计算镜头1缺陷位置及角度 var listLensnumber1 = list.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 1); for (int k = 0; k < listLensnumber1.Count; k++) { var lenAngle = GetAngle(listLensnumber1[k].X, listLensnumber1[k].Y,1050); if (lenAngle < 0) { lenAngle = 360 + lenAngle; } listLensnumber1[k].angle = lenAngle; var distance = GetDistance(1050, 1050, listLensnumber1[k].X, listLensnumber1[k].Y); listLensnumber1[k].R = distance; if (distance <= runparam.MidLens1R1) { listLensnumber1[k].location = "镜头"; } else if (runparam.MidLens1R1 < distance && distance <= runparam.MidLens1R2) { listLensnumber1[k].location = "斜面"; } else { listLensnumber1[k].location = "平面"; } } //计算镜头2位置及角度 var listLensnumber2 = list.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 2); for (int k = 0; k < listLensnumber2.Count; k++) { var lenAngle = GetAngle(listLensnumber2[k].X, listLensnumber2[k].Y,1050); if (lenAngle < 0) { lenAngle = 360 + lenAngle; } listLensnumber2[k].angle = lenAngle; var distance = GetDistance(1050, 1050, listLensnumber2[k].X, listLensnumber2[k].Y); listLensnumber2[k].R = distance; if (distance <= runparam.MidLens2R1) { listLensnumber2[k].location = "镜头"; } else if (runparam.MidLens2R1 < distance && distance <= runparam.MidLens2R2) { listLensnumber2[k].location = "斜面"; } else { listLensnumber2[k].location = "平面"; } } //计算镜头3位置及角度 var listLensnumber3 = list.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 3); for (int k = 0; k < listLensnumber3.Count; k++) { var lenAngle = GetAngle(listLensnumber3[k].X, listLensnumber3[k].Y,1050); if (lenAngle < 0) { lenAngle = 360 + lenAngle; } listLensnumber3[k].angle = lenAngle; var distance = GetDistance(1050, 1050, listLensnumber3[k].X, listLensnumber3[k].Y); listLensnumber3[k].R = distance; if (distance <= runparam.MidLens3R1) { listLensnumber3[k].location = "镜头"; } else if ( runparam.MidLens3R1< distance && distance <= runparam.MidLens3R2) { listLensnumber3[k].location = "斜面"; } else { listLensnumber3[k].location = "平面"; } } //计算镜头4位置及角度 var listLensnumber4 = list.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 4); for (int k = 0; k < listLensnumber4.Count; k++) { var lenAngle = GetAngle(listLensnumber4[k].X, listLensnumber4[k].Y,1050); if (lenAngle < 0) { lenAngle = 360 + lenAngle; } listLensnumber4[k].angle = lenAngle; var distance = GetDistance(1050, 1050, listLensnumber4[k].X, listLensnumber4[k].Y); listLensnumber4[k].R = distance; if (distance <= runparam.MidLens4R1) { listLensnumber4[k].location = "镜头"; } else if (runparam.MidLens4R1 < distance && distance <= runparam.MidLens4R2) { listLensnumber4[k].location = "斜面"; } else { listLensnumber4[k].location = "平面"; } } } return list; } #endregion #region 获取中框刮白角度和位置 private List GetWhiteLocation(List list) { var group = list.GroupBy(a => a.TimeTip); foreach (var item in group) { //计算镜头1缺陷位置及角度 var listLensnumber1 = list.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 1); for (int k = 0; k < listLensnumber1.Count; k++) { var lenAngle = GetAngle(listLensnumber1[k].X, listLensnumber1[k].Y,1050); if (lenAngle < 0) { lenAngle = 360 + lenAngle; } listLensnumber1[k].angle = lenAngle; var distance = GetDistance(1050, 1050, listLensnumber1[k].X, listLensnumber1[k].Y); listLensnumber1[k].R = distance; if (distance <= runparam.MidLens1R1) { listLensnumber1[k].location = "镜头"; } else if (runparam.MidLens1R1 < distance && distance <= runparam.MidLens1R2) { listLensnumber1[k].location = "斜面"; } else if(runparam.MidLens1R2 < distance && distance <= runparam.BkLens1R1) { listLensnumber1[k].location = "平面可视区"; } else { listLensnumber1[k].location = "平面非可视区"; } } //计算镜头2位置及角度 var listLensnumber2 = list.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 2); for (int k = 0; k < listLensnumber2.Count; k++) { var lenAngle = GetAngle(listLensnumber2[k].X, listLensnumber2[k].Y,1050); if (lenAngle < 0) { lenAngle = 360 + lenAngle; } listLensnumber2[k].angle = lenAngle; var distance = GetDistance(1050, 1050, listLensnumber2[k].X, listLensnumber2[k].Y); listLensnumber2[k].R = distance; if (distance <= runparam.MidLens2R1) { listLensnumber2[k].location = "镜头"; } else if (runparam.MidLens2R1 < distance && distance <= runparam.MidLens2R2) { listLensnumber2[k].location = "斜面"; } else if (runparam.MidLens2R2 < distance && distance <= runparam.BkLens2R1) { listLensnumber2[k].location = "平面可视区"; } else { listLensnumber2[k].location = "平面非可视区"; } } //计算镜头3位置及角度 var listLensnumber3 = list.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 3); for (int k = 0; k < listLensnumber3.Count; k++) { var lenAngle = GetAngle(listLensnumber3[k].X, listLensnumber3[k].Y,1050); if (lenAngle < 0) { lenAngle = 360 + lenAngle; } listLensnumber3[k].angle = lenAngle; var distance = GetDistance(1050, 1050, listLensnumber3[k].X, listLensnumber3[k].Y); listLensnumber3[k].R = distance; if (distance <= runparam.MidLens3R1) { listLensnumber3[k].location = "镜头"; } else if (runparam.MidLens3R1 < distance && distance <= runparam.MidLens3R2) { listLensnumber3[k].location = "斜面"; } else if (runparam.MidLens3R2 < distance && distance <= runparam.BkLens3R1) { listLensnumber3[k].location = "平面可视区"; } else { listLensnumber3[k].location = "平面非可视区"; } } //计算镜头4位置及角度 var listLensnumber4 = list.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 4); for (int k = 0; k < listLensnumber4.Count; k++) { var lenAngle = GetAngle(listLensnumber4[k].X, listLensnumber4[k].Y,1050); if (lenAngle < 0) { lenAngle = 360 + lenAngle; } listLensnumber4[k].angle = lenAngle; var distance = GetDistance(1050, 1050, listLensnumber4[k].X, listLensnumber4[k].Y); listLensnumber4[k].R = distance; if (distance <= runparam.MidLens4R1) { listLensnumber4[k].location = "镜头"; } else if (runparam.MidLens4R1 < distance && distance <= runparam.MidLens4R2) { listLensnumber4[k].location = "斜面"; } else if (runparam.MidLens4R2 < distance && distance <= runparam.BkLens4R1) { listLensnumber4[k].location = "平面可视区"; } else { listLensnumber4[k].location = "平面非可视区"; } } } return list; } #endregion #region 获取背板角度和位置 private List GetBkLocation(List list) { var group = list.GroupBy(a => a.TimeTip); foreach (var item in group) { //计算镜头1缺陷位置及角度 var listLensnumber1 = list.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 1); for (int k = 0; k < listLensnumber1.Count; k++) { var lenAngle = GetAngle(listLensnumber1[k].X, listLensnumber1[k].Y,1350); if (lenAngle < 0) { lenAngle = 360 + lenAngle; } listLensnumber1[k].angle = lenAngle; var distance = GetDistance(1350, 1350, listLensnumber1[k].X, listLensnumber1[k].Y); listLensnumber1[k].R = distance; if (distance <= runparam.BkLens1R1) { listLensnumber1[k].location = "可视区"; } else { listLensnumber1[k].location = "非可视区"; } } //计算镜头2位置及角度 var listLensnumber2 = list.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 2); for (int k = 0; k < listLensnumber2.Count; k++) { var lenAngle = GetAngle(listLensnumber2[k].X, listLensnumber2[k].Y,1350); if (lenAngle < 0) { lenAngle = 360 + lenAngle; } listLensnumber2[k].angle = lenAngle; var distance = GetDistance(1350, 1350, listLensnumber2[k].X, listLensnumber2[k].Y); listLensnumber2[k].R = distance; if (distance <= runparam.BkLens2R1) { listLensnumber2[k].location = "可视区"; } else { listLensnumber2[k].location = "非可视区"; } } //计算镜头3位置及角度 var listLensnumber3 = list.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 3); for (int k = 0; k < listLensnumber3.Count; k++) { var lenAngle = GetAngle(listLensnumber3[k].X, listLensnumber3[k].Y,1350); if (lenAngle < 0) { lenAngle = 360 + lenAngle; } listLensnumber3[k].angle = lenAngle; var distance = GetDistance(1350, 1350, listLensnumber3[k].X, listLensnumber3[k].Y); listLensnumber3[k].R = distance; if (distance <= runparam.BkLens3R1) { listLensnumber3[k].location = "可视区"; } else { listLensnumber3[k].location = "非可视区"; } } //计算镜头4位置及角度 var listLensnumber4 = list.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 4); for (int k = 0; k < listLensnumber4.Count; k++) { var lenAngle = GetAngle(listLensnumber4[k].X, listLensnumber4[k].Y,1350); if (lenAngle < 0) { lenAngle = 360 + lenAngle; } listLensnumber4[k].angle = lenAngle; var distance = GetDistance(1350, 1350, listLensnumber4[k].X, listLensnumber4[k].Y); listLensnumber4[k].R = distance; if (distance <= runparam.BkLens4R1) { listLensnumber4[k].location = "可视区"; } else { listLensnumber4[k].location = "非可视区"; } } } return list; } #endregion #region 计算两点之间距离 private double GetDistance(double x1, double y1, double x2, double y2) { return Math.Sqrt(Math.Pow((x2 - x1), 2) + Math.Pow((y2 - y1), 2)); } #endregion #region 计算角度 private double GetAngle(double x1, double y1,double size) { return Math.Atan2((y1 - size), (x1 - size)) * (180 / Math.PI); } #endregion #region 计算最大尺寸 private List GetMaxSize(List list) { for (int i = 0; i < list.Count; i++) { if (list[i].Width > list[i].Height) { list[i].ex = list[i].Width * 0.0043; } else { list[i].ex = list[i].Height * 0.0043; } } return list; } #endregion #region 获取文件名称并确定缺陷类型 private string GetDefactType(FileInfo fileinfo) { string defatType=""; if (fileinfo.Name.Contains("白点")) { defatType= "白点"; } else if (fileinfo.Name.Contains("刮白")) { defatType = "刮白"; } else if (fileinfo.Name.Contains("镀膜破损")) { defatType = "镀膜破损"; } else if (fileinfo.Name.Contains("划伤")) { defatType = "划伤"; } return defatType; } #endregion private List GetFileData(FileInfo fileInfos) { var allLines = File.ReadAllLines(fileInfos.FullName, Encoding.Default); List dataList = new List(); if (allLines.Length > 1) { switch (GetDefactType(fileInfos)) { case "白点": dataList = readfile.GetWhiteFile(allLines); break; case "刮白": dataList = readfile.GetWhiteningFile(allLines); break; case "划伤": dataList = readfile.GetScratchPartFile(allLines); break; case "镀膜破损": dataList = readfile.GetZoomPartFile(allLines); break; //default: // dataList1 = null; // break; } } return dataList; } } }