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; namespace P066.Data { public partial class Form1 : Form { DirectoryInfo directoryInfo1; DirectoryInfo directoryInfo2; public Form1() { InitializeComponent(); } 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) { var fileinfos1 = directoryInfo1.GetFiles(); var fileinfos2 = directoryInfo2.GetFiles(); var listSum = new List(); var JudgeListSum = new List(); string filename = ""; int WhiteI = 0; int WhiteningI = 0; for (int i = 0; i < fileinfos1.Length; i++) { var list = CompareFile(fileinfos1[i], fileinfos2[i]); var judgeList = JudgeCompareFile(fileinfos1[i], fileinfos2[i]); if (fileinfos1[i].Name.Contains("白点")) { WhiteI++; list.ForEach(a => a.Lensnumber = WhiteI); listSum.AddRange(list); judgeList.ForEach(a => a.Lensnumber = WhiteI); JudgeListSum.AddRange(judgeList); } if (fileinfos1[i].Name.Contains("刮白")) { WhiteningI++; list.ForEach(a => a.Lensnumber = WhiteningI); listSum.AddRange(list); judgeList.ForEach(a => a.Lensnumber = WhiteningI); JudgeListSum.AddRange(judgeList); } judgeList = GetLocation(judgeList); //给镜头区分位置及角度 list = GetLocation(list); string currPath = ""; #region//判断是初检文件夹还是复检文件夹 if (fileinfos1[i].Name.Contains("初检")) { filename = "初检"; } if (fileinfos1[i].Name.Contains("复检")) { filename = "复检"; } if (fileinfos1[i].Name.Contains("刮白")) { filename = "刮白"; } currPath = directoryInfo1.Parent.Parent.FullName; string subPath = currPath + "/" + filename + "合并后" + "/"; if (false==Directory.Exists(subPath)) { Directory.CreateDirectory(subPath); } #endregion #region//测试输出设备判断结果 //var title12 = $"时间戳,设备判断结果"; //var file12 = $"{directoryInfo1.Parent.FullName}\\{filename + (i + 111)}.csv"; //File.AppendAllText(file12, title12, Encoding.UTF8); //File.AppendAllText(file12, "\r\n"); //foreach (var item in JudgeListSum) //{ // var conrent12 = $"{item.TimeTip},{item.JudgmentResult}"; // File.AppendAllText(file12, conrent12, Encoding.UTF8); // File.AppendAllText(file12, "\r\n"); //} #endregion var title1 = $"时间戳,文件名,判断,可能性,不确定性,高,宽,X,Y,最大尺寸,位置,R,角度,缺陷类型"; var file1 = $"{subPath}\\{filename + (i+1)}.csv"; File.AppendAllText(file1, title1, Encoding.UTF8); File.AppendAllText(file1, "\r\n"); #region//计算总数 //var group1 = list.GroupBy(a => a.TimeTip); //var title2 = $"时间戳,总数"; //var file2 = $"{directoryInfo1.Parent.FullName}\\{ "总数" +( i+1)}.csv"; //File.AppendAllText(file2, title2, Encoding.UTF8); //File.AppendAllText(file2, "\r\n"); //foreach (var item in group1) //{ // var content = $"{item.Key},{item.ToList().Count}"; // File.AppendAllText(file2, content, Encoding.UTF8); // File.AppendAllText(file2, "\r\n"); //} #endregion var list11 = list.FindAll(a => !a.Result); foreach (var item in list11) { string result = item.Result ? "OK" : "NG"; var content = $"{item.TimeTip},{item.ImageFileName},{result},{item.Probability},{item.Uncertainty},{item.Height},{item.Width},{item.X},{item.Y},{item.ex},{item.location},{ Convert.ToInt32(item.R)},{ Convert.ToInt32(item.angle)},{item.DefectType}"; File.AppendAllText(file1, content, Encoding.UTF8); File.AppendAllText(file1, "\r\n"); } } var dataGroup1 = listSum.GroupBy(a => a.TimeTip); var dataListSum = new List(); foreach (var item in dataGroup1) { dataListSum.Add(item.Key); } dataListSum = dataListSum.Distinct().ToList(); dataListSum.Sort(); var dataList = new List(); #region//将设备判断结果输出到CSV报表中 var title12 = $"时间戳,相机序号,设备判断结果,缺陷类型,最大尺寸,位置,X,Y,R,角度"; var file12 = $"{directoryInfo1.Parent.FullName}\\{filename+"设备判断结果"}.csv"; File.AppendAllText(file12, title12, Encoding.UTF8); File.AppendAllText(file12, "\r\n"); foreach (var item in dataListSum) { var Lens1 = JudgeListSum.FindAll(a => a.TimeTip == item&&a.Lensnumber==1); WriteJR(Lens1,item,1,file12); var Lens2 = JudgeListSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 2); WriteJR(Lens2,"",2,file12); var Lens3 = JudgeListSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 3); WriteJR(Lens3,"",3,file12); var Lens4 = JudgeListSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 4); WriteJR(Lens4,"",4,file12); } #endregion #region//根据产品编号输出总缺陷报表 var title = $"产品编号,镜头编号,总缺陷数量"; var file = $"{directoryInfo1.Parent.FullName}\\{filename+ "缺陷总数报表"}.csv"; File.AppendAllText(file, title, Encoding.UTF8); File.AppendAllText(file, "\r\n"); var listSumGroup = listSum.GroupBy(a => a.TimeTip); foreach (var item in listSumGroup) { var listLensnumber1 = listSum.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 1); var listLensnumberCount1 = listLensnumber1.Count; var listLensnumber2 = listSum.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 2); var listLensnumberCount2 = listLensnumber2.Count; var listLensnumber3 = listSum.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 3); var listLensnumberCount3 = listLensnumber3.Count; var listLensnumber4 = listSum.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 4); var listLensnumberCount4 = listLensnumber4.Count; //第一行 var content1 = $"{item.Key},{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 } private List CompareFile(FileInfo fileInfo1, FileInfo fileInfo2) { var allLines1 = File.ReadAllLines(fileInfo1.FullName, Encoding.Default); var allLines2 = File.ReadAllLines(fileInfo2.FullName, Encoding.Default); List dataList1 = new List(); List dataList2 = new List(); if (allLines1.Length>1) { dataList1 = GetData(allLines1); } if (allLines2.Length > 1) { dataList2 = GetData(allLines2); } #region //将时间戳相同的分为一组并排序 var dataGroup1 = dataList1.GroupBy(a => a.TimeTip); var dataGroup2 = dataList2.GroupBy(a => a.TimeTip); var dataListSum = new List(); foreach (var item in dataGroup1) { dataListSum.Add(item.Key); } foreach (var item in dataGroup2) { dataListSum.Add(item.Key); } dataListSum = dataListSum.Distinct().ToList(); dataListSum.Sort(); #endregion var dataList = new List(); var dataList11 = new List(); var dataList22 = new List(); foreach (var item in dataListSum) { var list1 = dataList1.FindAll(a => a.TimeTip == item && !a.Result); var list2 = dataList2.FindAll(a => a.TimeTip == item && !a.Result); var itemToRemove = new List(); #region//计算表格2最大尺寸 for (int ii = 0; ii < list2.Count; ii++) { if (list2[ii].Width > list2[ii].Height) { list2[ii].ex = list2[ii].Width * 0.0042; } else { list2[ii].ex = list2[ii].Height * 0.0042; } var distance = GetDistance(1050, 1050, list2[ii].X, list2[ii].Y); list2[ii].R = distance; } #endregion for (int i = 0; i < list1.Count; i++) { #region//计算表格1最大尺寸 if (list1[i].Width > list1[i].Height) { list1[i].ex = list1[i].Width * 0.0042; } else { list1[i].ex = list1[i].Height * 0.0042; } var distance1 = GetDistance(1050, 1050, list1[i].X, list1[i].Y); list1[i].R = distance1; #endregion for (int j = 0; j < list2.Count; j++) { var distance = GetDistance(list1[i].X, list1[i].Y, list2[j].X, list2[j].Y); if (distance < 20) { itemToRemove.Add(list2[j]); } } } for (int i = 0; i < itemToRemove.Count; i++) { list2.Remove(itemToRemove[i]); } dataList11.AddRange(list1); dataList22.AddRange(list2); } dataList.AddRange(dataList1); dataList.AddRange(dataList2); return dataList; } //统计设备判断结果 private List JudgeCompareFile(FileInfo fileInfo1, FileInfo fileInfo2) { #region //屏蔽 //var allLines1 = File.ReadAllLines(fileInfo1.FullName,Encoding.Default); //var allLines2 = File.ReadAllLines(fileInfo2.FullName, Encoding.Default); ////var dataJudgeList1 = GetJudgeData(allLines1); ////var dataJudgeList2 = GetJudgeData(allLines2); //List dataJudgeList1 = new List(); //List dataJudgeList2 = new List(); //if (allLines1.Length > 1) //{ // dataJudgeList1 = GetData(allLines1); //} //if (allLines2.Length > 1) //{ // dataJudgeList2 = GetData(allLines2); //} //var dataGroup1 = dataJudgeList1.GroupBy(a => a.TimeTip); //var dataGroup2 = dataJudgeList2.GroupBy(a => a.TimeTip); //var dataListSum = new List(); //foreach (var item in dataGroup1) //{ // dataListSum.Add(item.Key); //} //foreach (var item in dataGroup2) //{ // dataListSum.Add(item.Key); //} //dataListSum = dataListSum.Distinct().ToList(); //dataListSum.Sort(); //var dataList = new List(); //var itemToRemove = new List(); //foreach (var item in dataListSum) //{ // var list1 = dataJudgeList1.FindAll(a => a.TimeTip == item && a.JudgmentResult=="NG"&&!a.Result); // var list2 = dataJudgeList2.FindAll(a => a.TimeTip == item && a.JudgmentResult == "NG"&&!a.Result); // 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 = "NG"; // list2[j].JudgmentResult = "NG"; // itemToRemove.Add(list2[j]); // } // if (list1[i].JudgmentResult == list2[j].JudgmentResult) // { // itemToRemove.Add(list2[j]); // } // } // } // //if (list1.Count ==0&&list2.Count==0) // //{ // // dataList.Add(new ResultData() // // { // // TimeTip = item, // // JudgmentResult = "OK", // // }); ; ; // //} // dataList.AddRange(list1); // dataList.AddRange(list2); //} //for (int i = 0; i < itemToRemove.Count; i++) //{ // dataList.Remove(itemToRemove[i]); //} #endregion var allLines1 = File.ReadAllLines(fileInfo1.FullName, Encoding.Default); var allLines2 = File.ReadAllLines(fileInfo2.FullName, Encoding.Default); List dataList1 = new List(); List dataList2 = new List(); if (allLines1.Length > 1) { dataList1 = GetData(allLines1); } if (allLines2.Length > 1) { dataList2 = GetData(allLines2); } #region //将时间戳相同的分为一组并排序 var dataGroup1 = dataList1.GroupBy(a => a.TimeTip); var dataGroup2 = dataList2.GroupBy(a => a.TimeTip); var dataListSum = new List(); foreach (var item in dataGroup1) { dataListSum.Add(item.Key); } foreach (var item in dataGroup2) { dataListSum.Add(item.Key); } dataListSum = dataListSum.Distinct().ToList(); dataListSum.Sort(); #endregion var dataList = new List(); var dataList11 = new List(); var dataList22 = new List(); foreach (var item in dataListSum) { var list1 = dataList1.FindAll(a => a.TimeTip == item && !a.Result); var list2 = dataList2.FindAll(a => a.TimeTip == item && !a.Result); var itemToRemove1 = new List(); #region//计算表格2最大尺寸 for (int ii = 0; ii < list2.Count; ii++) { if (list2[ii].Width > list2[ii].Height) { list2[ii].ex = list2[ii].Width * 0.0042; } else { list2[ii].ex = list2[ii].Height * 0.0042; } var distance = GetDistance(1050, 1050, list2[ii].X, list2[ii].Y); list2[ii].R = distance; } #endregion for (int i = 0; i < list1.Count; i++) { #region//计算表格1最大尺寸 if (list1[i].Width > list1[i].Height) { list1[i].ex = list1[i].Width * 0.0042; } else { list1[i].ex = list1[i].Height * 0.0042; } var distance1 = GetDistance(1050, 1050, list1[i].X, list1[i].Y); list1[i].R = distance1; #endregion for (int j = 0; j < list2.Count; j++) { var distance = GetDistance(list1[i].X, list1[i].Y, list2[j].X, list2[j].Y); if (distance < 20) { itemToRemove1.Add(list2[j]); if (list1[i].JudgmentResult!=list2[j].JudgmentResult) { list1[i].JudgmentResult = "NG"; list2[j].JudgmentResult = "NG"; } } } } for (int i = 0; i < itemToRemove1.Count; i++) { list2.Remove(itemToRemove1[i]); } dataList11.AddRange(list1); dataList22.AddRange(list2); } //var itemToRemove = new List(); foreach (var item in dataListSum) { var list1 = dataList11.FindAll(a => a.TimeTip == item/* && a.JudgmentResult == "NG"*/ ); //不管OK、NG都要输出 var list2 = dataList22.FindAll(a => a.TimeTip == item /*&& a.JudgmentResult == "NG"*/); //不管OK、NG都要输出 //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 = "NG"; // list2[j].JudgmentResult = "NG"; // itemToRemove.Add(list2[j]); // } // if (list1[i].JudgmentResult == list2[j].JudgmentResult) // { // itemToRemove.Add(list2[j]); // } // } //} dataList.AddRange(list1); dataList.AddRange(list2); } //for (int i = 0; i < itemToRemove.Count; i++) //{ // dataList.Remove(itemToRemove[i]); //} return dataList; } private List GetData(string[] allLines) { var dataList = new List(); var nametemp = allLines[1].Split(',')[0]; var resulttemp = allLines[1].Split(',')[1]; string Ptr = ""; //if (allLines[1].Split(',')[10].Length>3) //{ // Ptr = allLines[1].Split(',')[10]; //} for (int i = 1; i < allLines.Length; i++) { var data = allLines[i].Split(','); if (data.Length>10) { Ptr = data[10]; } if (data[6]=="-") { continue; } string defectType = ""; string bbb = ""; //string Ptr = ""; if (data[0] == "") { data[0] = nametemp; data[1] = resulttemp; //data[10] = Ptr; } if (data[1]== "刮白") { defectType = "刮白"; bbb = "NG"; Ptr = ""; } else { defectType = "白点"; bbb = data[1]; } var data6 = data[6].Split('#').ToList(); data6.Remove(""); var temp6 = Convert.ToInt32(data6[0]); for (int a6 = 0; a6 < data6.Count; a6++) { if (Convert.ToInt32(data6[a6]) > temp6) { temp6 = Convert.ToInt32(data6[a6]); } } data[6] = Convert.ToString(temp6); var data7 = data[7].Split('#').ToList(); data7.Remove(""); var temp7 = Convert.ToInt32(data7[0]); for (int a7 = 0; a7 < data7.Count; a7++) { if (Convert.ToInt32(data7[a7]) > temp7) { temp7 = Convert.ToInt32(data7[a7]); } } data[7] = Convert.ToString(temp7); dataList.Add(new ResultData() { TimeTip = data[0].Split('-')[0], ImageFileName = data[0], JudgmentResult = bbb, Result = data[3] == "OK", Probability = Convert.ToDouble(data[4]), Uncertainty = Convert.ToDouble(data[5]), //Height = Convert.ToDouble(data[6].Replace("#", "").Replace("-", "")), //Width = Convert.ToDouble(data[7].Replace("#", "").Replace("-", "")), Height = Convert.ToDouble(data[6]), Width = Convert.ToDouble(data[7]), X = Convert.ToDouble(data[8].Replace("#", "").Replace("-", "")), Y = Convert.ToDouble(data[9].Replace("#", "").Replace("-", "")), DefectType = defectType, PostTreatmentResults = Ptr, }) ; ; ; nametemp = data[0]; resulttemp= data[1]; //Ptr = data[10]; } return dataList; } //private List GetJudgeData(string[] allLines) //{ // var dataList = new List(); // for (int i = 1; i < allLines.Length; i++) // { // var data = allLines[i].Split(','); // string defectType = ""; // string aaa = ""; // if (data[0] != "") // { // try // { // defectType = data[10]; // } // catch (Exception) // { // defectType = "刮白"; // aaa = "NG"; // } // dataList.Add(new ResultData() // { // TimeTip = data[0].Split('-')[0], // JudgmentResult = aaa, // DefectType= defectType, // }); ; ; // } // } // return dataList; //} private List GetLocation(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); if (lenAngle < 0) { lenAngle = 360 + lenAngle; } listLensnumber1[k].angle = lenAngle; var distance = GetDistance(1050, 1050, listLensnumber1[k].X, listLensnumber1[k].Y); if (distance <= 298.022) { listLensnumber1[k].location = "镜头"; } else if (298.022 < distance && distance <= 521.171) { 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); if (lenAngle < 0) { lenAngle = 360 + lenAngle; } listLensnumber2[k].angle = lenAngle; var distance = GetDistance(1050, 1050, listLensnumber2[k].X, listLensnumber2[k].Y); if (distance <= 367.696) { listLensnumber2[k].location = "镜头"; } else if (367.696 < distance && distance <= 653.911) { 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); if (lenAngle < 0) { lenAngle = 360 + lenAngle; } listLensnumber3[k].angle = lenAngle; var distance = GetDistance(1050, 1050, listLensnumber3[k].X, listLensnumber3[k].Y); if (distance <= 339.246) { listLensnumber3[k].location = "镜头"; } else if (distance < 339.246 && distance <= 520.584) { 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); if (lenAngle < 0) { lenAngle = 360 + lenAngle; } listLensnumber4[k].angle = lenAngle; var distance = GetDistance(1050, 1050, listLensnumber4[k].X, listLensnumber4[k].Y); if (distance <= 104.895) { listLensnumber4[k].location = "镜头"; } else if (104.895 < distance && distance <= 239.48) { listLensnumber4[k].location = "斜面"; } else { listLensnumber4[k].location = "平面"; } } } return list; } private void WriteJR(List Lens,string item,int LensNumb, string file12) { if (Lens.Count == 0) { var content11 = $"{item},{LensNumb},{"OK"}"; File.AppendAllText(file12, content11, Encoding.UTF8); File.AppendAllText(file12, "\r\n"); } else { if (Lens[0].DefectType == "刮白") { var content11 = $"{item},{LensNumb},{Lens[0].JudgmentResult},{Lens[0].DefectType}"; File.AppendAllText(file12, content11, Encoding.UTF8); File.AppendAllText(file12, "\r\n"); for (int i = 0; i < Lens.Count; i++) { if (Lens[i].DefectType == "刮白") { var content111 = $"{""},{""},{""},{""},{Lens[i].ex},{Lens[i].location},{Lens[i].X},{Lens[i].Y},{(int)(Lens[i].R)},{(int)(Lens[i].angle)}"; File.AppendAllText(file12, content111, Encoding.UTF8); File.AppendAllText(file12, "\r\n"); } else { var content111 = $"{""},{""},{""},{Lens[i].DefectType},{Lens[i].ex},{Lens[i].location},{Lens[i].X},{Lens[i].Y},{(int)(Lens[i].R)},{(int)(Lens[i].angle)}"; File.AppendAllText(file12, content111, Encoding.UTF8); File.AppendAllText(file12, "\r\n"); } } } else { var content11 = $"{item},{LensNumb},{Lens[0].JudgmentResult},{Lens[0].DefectType}"; File.AppendAllText(file12, content11, Encoding.UTF8); File.AppendAllText(file12, "\r\n"); for (int i = 0; i < Lens.Count; i++) { var content111 = $"{""},{""},{""},{""},{Lens[i].ex},{Lens[i].location},{Lens[i].X},{Lens[i].Y},{(int)(Lens[i].R)},{(int)(Lens[i].angle)}"; File.AppendAllText(file12, content111, Encoding.UTF8); File.AppendAllText(file12, "\r\n"); } } } } private double GetDistance(double x1, double y1, double x2, double y2) { return Math.Sqrt(Math.Pow((x2 - x1), 2) + Math.Pow((y2 - y1), 2)); } private double GetAngle(double x1, double y1) { return Math.Atan2((y1 - 1050), (x1 - 1050)) * (180 / Math.PI); } } public class ResultData { public string TimeTip = ""; public string JudgmentResult = ""; public string ImageFileName = ""; public bool Result = true; public int Lensnumber = 0; public double Probability = 0; public double Uncertainty = 0; public double Height = 0; public double Width = 0; public double X = 0; public double Y = 0; public double ex = 0; public string location = ""; public double angle = 0; public double R = 0; public string DefectType = ""; public string PostTreatmentResults = ""; } }