| | |
| | | using Bro.Common; |
| | | using Bro.Common.Util; |
| | | using System.Configuration; |
| | | |
| | | namespace P066.Data |
| | | { |
| | | public partial class Form1 : Form |
| | | { |
| | | DirectoryInfo directoryInfo1; |
| | | DirectoryInfo directoryInfo2; |
| | | DirectoryInfo directoryInfo3; |
| | | DirectoryInfo directoryInfo4; |
| | | |
| | | private P066RunParam runparam = new P066RunParam(); |
| | | private ReadFile readfile = new ReadFile(); |
| | | private WriteFile writefile = new WriteFile(); |
| | |
| | | return; |
| | | |
| | | directoryInfo2 = new DirectoryInfo(folderBrowserDialog1.SelectedPath); |
| | | |
| | | } |
| | | |
| | | private void btnLoadData3_Click(object sender, EventArgs e) |
| | | { |
| | | if (folderBrowserDialog1.ShowDialog()!=DialogResult.OK) |
| | | { |
| | | return; |
| | | } |
| | | directoryInfo3 = new DirectoryInfo(folderBrowserDialog1.SelectedPath); |
| | | } |
| | | private void butPictur_Click(object sender, EventArgs e) |
| | | { |
| | | if (folderBrowserDialog1.ShowDialog()!=DialogResult.OK) |
| | | { |
| | | return; |
| | | } |
| | | directoryInfo4 = 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<FileInfo> fileInfo1 = new List<FileInfo>(); |
| | | List<FileInfo> fileInfo2 = new List<FileInfo>(); |
| | | for (int i = 0; i < fileinfos11.Count; i++) |
| | | //读取全部表格 |
| | | var fileinfos1 = directoryInfo1.GetFiles().ToList().FindAll(a => a.Extension == ".csv"&& (a.Name.Contains("刮白") || a.Name.Contains("白点毛丝")) ); |
| | | var listAllSum = new List<ResultData>(); //存放所有表格数据 |
| | | List<Task> listTask = new List<Task>(); |
| | | var DataTipsortBack = readfile.TimeStamp(fileinfos1.Find(a=>a.Name.Contains("初检背板镜头")));//读取背板时间戳 |
| | | var DataTipsotMidle = readfile.TimeStamp(fileinfos1.Find(a => a.Name.Contains("初检中框镜头")));//读取中框时间戳 |
| | | Dictionary<string, List<string>> dictionarData = new Dictionary<string, List<string>>(); |
| | | dictionarData.Add("背板", DataTipsortBack); |
| | | dictionarData.Add("中框", DataTipsotMidle); |
| | | for (int i = 0; i < fileinfos1.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") ) |
| | | int index = i; |
| | | var task = Task.Run(() => |
| | | { |
| | | fileInfo1.Add(fileinfos11[i]); |
| | | } |
| | | else |
| | | listAllSum.AddRange(GetFileData(fileinfos1[index])); |
| | | }); |
| | | listTask.Add(task); |
| | | } |
| | | Task.WaitAll(listTask.ToArray());//等全部读取完后再进行下一步 |
| | | Dictionary<int, string> dictionary = new Dictionary<int, string>(); |
| | | dictionary.Add(1, "初检背板镜头"); |
| | | dictionary.Add(2, "初检中框镜头"); |
| | | dictionary.Add(3, "复检中框镜头"); |
| | | dictionary.Add(4, "复检背板镜头"); |
| | | List<ResultData> listCompareSum = new List<ResultData>(); |
| | | for (int j = 1; j < 5; j++) |
| | | { |
| | | int indexMax = j; |
| | | for (int i = 1; i < 5; i++) |
| | | { |
| | | fileInfo2.Add(fileinfos11[i]); |
| | | int index = i; |
| | | Task task = Task.Run(() => |
| | | { |
| | | if (dictionary[indexMax].Substring (2,2)=="中框") |
| | | { |
| | | listCompareSum.AddRange(GetMidLocation((CompareFile(listAllSum.FindAll(a => a.FileName == dictionary[indexMax] + index + "_" + 1 + "白点"), |
| | | listAllSum.FindAll(a => a.FileName == dictionary[indexMax] + index + "_" + 2 + "白点"), dictionarData[dictionary[indexMax].Substring(2, 2)])))); |
| | | } |
| | | else |
| | | { |
| | | listCompareSum.AddRange(GetBkLocation((CompareFile(listAllSum.FindAll(a => a.FileName == dictionary[indexMax] + index + "_" + 1 + "白点"), |
| | | listAllSum.FindAll(a => a.FileName == dictionary[indexMax] + index + "_" + 2 + "白点"), dictionarData[dictionary[indexMax].Substring(2, 2)])))); |
| | | } |
| | | |
| | | }); |
| | | |
| | | listTask.Add(task); |
| | | } |
| | | } |
| | | for (int i = 1; i < 5; i++) |
| | | { |
| | | int index = i; |
| | | Task task = Task.Run(() => |
| | | { |
| | | listCompareSum.AddRange(GetWhiteLocation(CompareFile(listAllSum.FindAll(a => a.FileName == dictionary[3] + index + "_" + 1 + "刮白"), |
| | | listAllSum.FindAll(a => a.FileName == dictionary[3] + index + "_" + 2 + "刮白"), dictionarData[dictionary[3].Substring(2, 2)]))); |
| | | }); |
| | | |
| | | listTask.Add(task); |
| | | } |
| | | |
| | | Task.WaitAll(listTask.ToArray()); |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | var back = listCompareSum.FindAll(a => a.FileName.Contains("初检背板")); |
| | | var midle = listCompareSum.FindAll(a => a.FileName.Contains("初检中框")); |
| | | var back1 = listCompareSum.FindAll(a => a.FileName.Contains("复检背板")); |
| | | var midle1 = listCompareSum.FindAll(a => a.FileName.Contains("复检中框")); |
| | | |
| | | |
| | | |
| | | |
| | | #region//将夜班设备判断结果输出到CSV报表中 |
| | | //ListReexaminationSum.AddRange(GetClassificationLens(fileInfo1, fileInfo2, DataTipsor)); |
| | | var title112 = $"时间戳,相机序号,设备判断结果,缺陷类型,设备后处理结果,最大尺寸,位置,X,Y,R,角度"; |
| | | var file112 = $"{directoryInfo1.Parent.FullName}\\{"夜班设备判断结果"}.csv"; |
| | | File.AppendAllText(file112, title112, Encoding.UTF8); |
| | | File.AppendAllText(file112, "\r\n"); |
| | | foreach (var item in DataTipsotMidle) |
| | | { |
| | | var Lens1 = midle1.FindAll(a => a.TimeTip == item && a.Lensnumber == 1); |
| | | writefile.WriteJR(Lens1, item, 1, file112); |
| | | for (int i = 2; i < 5; i++) |
| | | { |
| | | var Lens = midle1.FindAll(a => a.TimeTip == item && a.Lensnumber == i); |
| | | writefile.WriteJR(Lens, "", i, file112); |
| | | } |
| | | |
| | | } |
| | | #endregion |
| | | List<ResultData> DataListMerge = new List<ResultData>(); |
| | | var listSum = new List<ResultData>(); |
| | | var JudgeListSum = new List<ResultData>(); |
| | | string filename = ""; |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | var Start = DateTime.Now; |
| | | #region 读取文件夹下的所有文件,并将文件按照上下进行区分;上表格为fileInfo1,下表格为fileInfo2 |
| | | List<FileInfo> fileInfo1 = new List<FileInfo>(); |
| | | List<FileInfo> fileInfo2 = new List<FileInfo>(); |
| | | List<FileInfo> fileInfo3 = new List<FileInfo>(); |
| | | List<FileInfo> fileInfo4 = new List<FileInfo>(); |
| | | Task task1 = new Task(() => |
| | | { |
| | | if (directoryInfo1 != null) |
| | | { |
| | | GentClassificationFile(directoryInfo1, out List<FileInfo> FileInfo1, out List<FileInfo> FileInfo2); //fileInfo1复检上文件夹,fileInfo2复检下文件夹 |
| | | fileInfo1 = FileInfo1; |
| | | fileInfo2 = FileInfo2; |
| | | } |
| | | if (directoryInfo3 != null) |
| | | { |
| | | GentClassificationFile(directoryInfo3, out List<FileInfo> FileInfo3, out List<FileInfo> FileInfo4); //fileInfo3初检上文件夹,fileInfo4初检下文件夹 |
| | | fileInfo3 = FileInfo3; |
| | | fileInfo4 = FileInfo4; |
| | | } |
| | | }); |
| | | task1.Start(); |
| | | task1.Wait(); |
| | | |
| | | #endregion |
| | | var ListReexaminationSum = new List<ResultData>(); //复检报表数据 |
| | | var ListPreliminarySum = new List<ResultData>(); //初检报表数据 |
| | | 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<string>(); |
| | | var DataTipsor = new List<string>(); //白夜班总时间戳 |
| | | var DataNightTipsor = new List<string>(); //夜班时间戳 |
| | | var DataDayTipsor = new List<string>(); //白天时间戳 |
| | | |
| | | |
| | | foreach (var item in dataGroup) |
| | | { |
| | | dataListSum22.Add(item.Key); |
| | | int.TryParse(item.Key, out int start); |
| | | DataTipsor.Add(item.Key); |
| | | if (start > 80000) |
| | | { |
| | | DataDayTipsor.Add(item.Key); |
| | | } |
| | | else |
| | | { |
| | | DataNightTipsor.Add(item.Key); |
| | | } |
| | | } |
| | | dataListSum22 = dataListSum22.Distinct().ToList(); |
| | | dataListSum22.Sort(); |
| | | DataTipsor.Distinct().ToList().Sort(); |
| | | DataDayTipsor.Distinct().ToList().Sort(); |
| | | DataNightTipsor.Distinct().ToList().Sort(); |
| | | |
| | | |
| | | |
| | | #endregion |
| | | |
| | | #region 读取划伤、镀膜破损文件夹文件 |
| | |
| | | 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); |
| | | //ScratchI++; |
| | | //list.ForEach(a => a.Lensnumber = ScratchI); |
| | | GetMaxSize(list); |
| | | GetBkLocation(list); |
| | | ListReexaminationSum.AddRange(list); |
| | | } |
| | | else if (fileinfos22[i].Name.Contains("镀膜破损")) |
| | | { |
| | | ZoomI++; |
| | | list.ForEach(a => a.Lensnumber = ZoomI); |
| | | listSum.AddRange(list); |
| | | //ZoomI++; |
| | | //list.ForEach(a => a.Lensnumber = ZoomI); |
| | | ListReexaminationSum.AddRange(list); |
| | | } |
| | | |
| | | } |
| | |
| | | } |
| | | #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); |
| | | |
| | | } |
| | | var tt1 =DateTime.Now; |
| | | var taskReexamination = Task.Run (() => |
| | | { |
| | | //复检报表 |
| | | //ListReexaminationSum.AddRange(GetClassificationLens(fileInfo1, fileInfo2, DataTipsor)); |
| | | |
| | | |
| | | |
| | | #region//判断是初检文件夹还是复检文件夹 |
| | | string currPath = ""; |
| | | if (fileInfo1[i].Name.Contains("初检中框")) |
| | | }); |
| | | var taskPreliminary = Task.Run(() => |
| | | { |
| | | //初检报表 |
| | | /* ListPreliminarySum.AddRange(GetClassificationLens(fileInfo3, fileInfo4, DataTipsor)); */ //合并初检上下报表,输出合并后数据 |
| | | |
| | | |
| | | }); |
| | | |
| | | taskReexamination.Wait(); |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | //夜班 |
| | | var taskNight= Task.Run(() => |
| | | { |
| | | |
| | | #region//将夜班设备判断结果输出到CSV报表中 |
| | | //ListReexaminationSum.AddRange(GetClassificationLens(fileInfo1, fileInfo2, DataTipsor)); |
| | | 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 DataNightTipsor) |
| | | { |
| | | 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("刮白")) |
| | | var Lens1 = ListReexaminationSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 1); |
| | | writefile.WriteJR(Lens1, item, 1, file12); |
| | | for (int i = 2; i < 5; i++) |
| | | { |
| | | 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"); |
| | | var Lens = ListReexaminationSum.FindAll(a => a.TimeTip == item && a.Lensnumber == i); |
| | | writefile.WriteJR(Lens, "", i, file12); |
| | | } |
| | | |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | }); |
| | | //白班 |
| | | var taskDay = Task.Run(() => |
| | | { |
| | | |
| | | #region//将夜班设备判断结果输出到CSV报表中 |
| | | //ListReexaminationSum.AddRange(GetClassificationLens(fileInfo1, fileInfo2, DataTipsor)); |
| | | 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 DataDayTipsor) |
| | | { |
| | | var Lens1 = ListReexaminationSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 1); |
| | | writefile.WriteJR(Lens1, item, 1, file12); |
| | | for (int i = 2; i < 5; i++) |
| | | { |
| | | var Lens = ListReexaminationSum.FindAll(a => a.TimeTip == item && a.Lensnumber == i); |
| | | writefile.WriteJR(Lens, "", i, file12); |
| | | } |
| | | |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #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) |
| | | |
| | | }); |
| | | |
| | | |
| | | if (directoryInfo4!=null) |
| | | { |
| | | 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); |
| | | |
| | | Task.Run(() => |
| | | { |
| | | List<string> listPicyreSor = new List<string>(); //加载图片时间戳 |
| | | var directoties = directoryInfo4.GetDirectories(); |
| | | for (int i = 0; i < directoties.Length; i++) |
| | | { |
| | | listPicyreSor.Add(directoties[i].Name); |
| | | } |
| | | listPicyreSor.Sort(); |
| | | |
| | | #region//将设备判断结果输出到CSV报表中 |
| | | //ListReexaminationSum.AddRange(GetClassificationLens(fileInfo1, fileInfo2, DataTipsor)); |
| | | 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 listPicyreSor) |
| | | { |
| | | var Lens1 = ListReexaminationSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 1); |
| | | writefile.WriteJR(Lens1, item, 1, file12); |
| | | for (int i = 2; i < 5; i++) |
| | | { |
| | | var Lens = ListReexaminationSum.FindAll(a => a.TimeTip == item && a.Lensnumber == i); |
| | | writefile.WriteJR(Lens, "", i, 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) |
| | | |
| | | |
| | | |
| | | |
| | | taskPreliminary.Wait(); |
| | | |
| | | |
| | | var task6 = Task.Run(() => |
| | | { |
| | | 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//根据产品编号输出总缺陷报表 |
| | | if (directoryInfo3 != null) |
| | | { |
| | | List<ResultData> ListNoClearNub = new List<ResultData>(); //清除失败数 |
| | | List<ResultData> ListMayNub = new List<ResultData>(); //复检多检出数数 |
| | | CompareFile2(ListReexaminationSum, ListPreliminarySum, DataNightTipsor, out ListNoClearNub, out ListMayNub); |
| | | var title = $"产品编号,镜头编号,总缺陷数量,设备清除数,未清除数,复检多检出数"; |
| | | var file = $"{directoryInfo1.Parent.FullName}\\{filenameDir + "夜班缺陷总数报表"}.csv"; |
| | | File.AppendAllText(file, title, Encoding.UTF8); |
| | | File.AppendAllText(file, "\r\n"); |
| | | |
| | | #region 夜班 |
| | | foreach (var item in DataNightTipsor) |
| | | { |
| | | //总缺陷数 |
| | | var ListLenSum1 = ListPreliminarySum.FindAll(a => a.TimeTip == item && a.Lensnumber == 1 && a.DefectType == "白点" && !a.Result); |
| | | var listlensum1 = ListLenSum1.Count; |
| | | //未清除数 |
| | | var ListLenNoClearSum1 = ListNoClearNub.FindAll(a => a.TimeTip == item && a.Lensnumber == 1 && a.DefectType == "白点" && !a.Result); |
| | | var listlennoclearsum1 = ListLenNoClearSum1.Count; |
| | | //设备清除数 |
| | | var listlenclearsum1 = listlensum1 - listlennoclearsum1; |
| | | //复检多检出数 |
| | | var ListLenMaySum1 = ListMayNub.FindAll(a => a.TimeTip == item && a.Lensnumber == 1 && a.DefectType == "白点" && !a.Result); |
| | | var listlenmaysum1 = ListLenMaySum1.Count; |
| | | |
| | | var content1 = $"{item},{1},{listlensum1},{listlenclearsum1},{listlennoclearsum1},{listlenmaysum1}"; |
| | | File.AppendAllText(file, content1, Encoding.UTF8); |
| | | File.AppendAllText(file, "\r\n"); |
| | | |
| | | for (int i = 2; i < 5; i++) |
| | | { |
| | | //总缺陷数 |
| | | var ListLenSum = ListPreliminarySum.FindAll(a => a.TimeTip == item && a.Lensnumber == i && a.DefectType == "白点" && !a.Result); |
| | | var listlensum = ListLenSum.Count; |
| | | //未清除数 |
| | | var ListLenNoClearSum = ListNoClearNub.FindAll(a => a.TimeTip == item && a.Lensnumber == i && a.DefectType == "白点" && !a.Result); |
| | | var listlennoclearsum = ListLenNoClearSum.Count; |
| | | //设备清除数 |
| | | var listlenclearsum = listlensum - listlennoclearsum; |
| | | //复检多检出数 |
| | | var ListLenMaySum = ListMayNub.FindAll(a => a.TimeTip == item && a.Lensnumber == i && a.DefectType == "白点" && !a.Result); |
| | | var listlenmaysum = ListLenMaySum.Count; |
| | | var content = $"{""},{i},{listlensum},{listlenclearsum},{listlennoclearsum},{listlenmaysum}"; |
| | | File.AppendAllText(file, content, Encoding.UTF8); |
| | | File.AppendAllText(file, "\r\n"); |
| | | } |
| | | } |
| | | var title1 = $"镜头编号,总缺陷数量,设备清除数,清除率"; |
| | | var file1 = $"{directoryInfo1.Parent.FullName}\\{filenameDir + "夜班缺陷总数报表"}.csv"; |
| | | File.AppendAllText(file1, title1, Encoding.UTF8); |
| | | File.AppendAllText(file1, "\r\n"); |
| | | for (int i =1; i < 5; i++) |
| | | { |
| | | //初检缺陷数 |
| | | var ListLenSum1 = ListPreliminarySum.FindAll(a => a.Lensnumber ==i && a.DefectType == "白点" && !a.Result); |
| | | var listlensum1 = ListLenSum1.Count; |
| | | //复检多检出数 |
| | | var ListLenMaySum1 = ListMayNub.FindAll(a=> a.Lensnumber ==i&& a.DefectType == "白点" && !a.Result); |
| | | var listlenmaysum1 = ListLenMaySum1.Count; |
| | | //总缺陷数 |
| | | var defectSum = listlenmaysum1 + listlensum1; |
| | | //除尘数 |
| | | var ListLenNoClearSum1 = ListNoClearNub.FindAll(a => a.Lensnumber == i && a.DefectType == "白点" && !a.Result); |
| | | var listlennoclearsum1 = ListLenNoClearSum1.Count; |
| | | var defectClearSum = listlensum1 - listlennoclearsum1; |
| | | |
| | | |
| | | var content1 = $"{i},{defectSum},{defectClearSum},{(double)(defectSum / defectClearSum)}"; |
| | | File.AppendAllText(file1, content1, Encoding.UTF8); |
| | | File.AppendAllText(file1, "\r\n"); |
| | | } |
| | | #endregion |
| | | |
| | | directoryInfo3 = null; |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | |
| | | |
| | | |
| | | }); |
| | | |
| | | |
| | | var task7 = Task.Run(() => |
| | | { |
| | | |
| | | #region//根据产品编号输出总缺陷报表 |
| | | if (directoryInfo3 != null) |
| | | { |
| | | List<ResultData> ListNoClearNub = new List<ResultData>(); //清除失败数 |
| | | List<ResultData> ListMayNub = new List<ResultData>(); //复检多检出数数 |
| | | CompareFile2(ListReexaminationSum, ListPreliminarySum, DataDayTipsor, out ListNoClearNub, out ListMayNub); |
| | | var title = $"产品编号,镜头编号,总缺陷数量,设备清除数,未清除数,复检多检出数"; |
| | | var file = $"{directoryInfo1.Parent.FullName}\\{filenameDir + "白班缺陷总数报表"}.csv"; |
| | | File.AppendAllText(file, title, Encoding.UTF8); |
| | | File.AppendAllText(file, "\r\n"); |
| | | |
| | | #region 夜班 |
| | | foreach (var item in DataDayTipsor) |
| | | { |
| | | //总缺陷数 |
| | | var ListLenSum1 = ListPreliminarySum.FindAll(a => a.TimeTip == item && a.Lensnumber == 1 && a.DefectType == "白点" && !a.Result); |
| | | var listlensum1 = ListLenSum1.Count; |
| | | //未清除数 |
| | | var ListLenNoClearSum1 = ListNoClearNub.FindAll(a => a.TimeTip == item && a.Lensnumber == 1 && a.DefectType == "白点" && !a.Result); |
| | | var listlennoclearsum1 = ListLenNoClearSum1.Count; |
| | | //设备清除数 |
| | | var listlenclearsum1 = listlensum1 - listlennoclearsum1; |
| | | //复检多检出数 |
| | | var ListLenMaySum1 = ListMayNub.FindAll(a => a.TimeTip == item && a.Lensnumber == 1 && a.DefectType == "白点" && !a.Result); |
| | | var listlenmaysum1 = ListLenMaySum1.Count; |
| | | |
| | | var content1 = $"{item},{1},{listlensum1},{listlenclearsum1},{listlennoclearsum1},{listlenmaysum1}"; |
| | | File.AppendAllText(file, content1, Encoding.UTF8); |
| | | File.AppendAllText(file, "\r\n"); |
| | | |
| | | for (int i = 2; i < 5; i++) |
| | | { |
| | | //总缺陷数 |
| | | var ListLenSum = ListPreliminarySum.FindAll(a => a.TimeTip == item && a.Lensnumber == i && a.DefectType == "白点" && !a.Result); |
| | | var listlensum = ListLenSum.Count; |
| | | //未清除数 |
| | | var ListLenNoClearSum = ListNoClearNub.FindAll(a => a.TimeTip == item && a.Lensnumber == i && a.DefectType == "白点" && !a.Result); |
| | | var listlennoclearsum = ListLenNoClearSum.Count; |
| | | //设备清除数 |
| | | var listlenclearsum = listlensum - listlennoclearsum; |
| | | //复检多检出数 |
| | | var ListLenMaySum = ListMayNub.FindAll(a => a.TimeTip == item && a.Lensnumber == i && a.DefectType == "白点" && !a.Result); |
| | | var listlenmaysum = ListLenMaySum.Count; |
| | | var content = $"{""},{i},{listlensum},{listlenclearsum},{listlennoclearsum},{listlenmaysum}"; |
| | | File.AppendAllText(file, content, Encoding.UTF8); |
| | | File.AppendAllText(file, "\r\n"); |
| | | } |
| | | } |
| | | var title1 = $"镜头编号,总缺陷数量,设备清除数,清除率"; |
| | | var file1 = $"{directoryInfo1.Parent.FullName}\\{filenameDir + "白班缺陷总数报表"}.csv"; |
| | | File.AppendAllText(file1, title1, Encoding.UTF8); |
| | | File.AppendAllText(file1, "\r\n"); |
| | | for (int i = 1; i < 5; i++) |
| | | { |
| | | //初检缺陷数 |
| | | var ListLenSum1 = ListPreliminarySum.FindAll(a => a.Lensnumber == i && a.DefectType == "白点" && !a.Result); |
| | | var listlensum1 = ListLenSum1.Count; |
| | | //复检多检出数 |
| | | var ListLenMaySum1 = ListMayNub.FindAll(a => a.Lensnumber == i && a.DefectType == "白点" && !a.Result); |
| | | var listlenmaysum1 = ListLenMaySum1.Count; |
| | | //总缺陷数 |
| | | var defectSum = listlenmaysum1 + listlensum1; |
| | | //除尘数 |
| | | var ListLenNoClearSum1 = ListNoClearNub.FindAll(a => a.Lensnumber == i && a.DefectType == "白点" && !a.Result); |
| | | var listlennoclearsum1 = ListLenNoClearSum1.Count; |
| | | var defectClearSum = listlensum1 - listlennoclearsum1; |
| | | |
| | | |
| | | var content1 = $"{i},{defectSum},{defectClearSum},{(double)(defectSum / defectClearSum)}"; |
| | | File.AppendAllText(file1, content1, Encoding.UTF8); |
| | | File.AppendAllText(file1, "\r\n"); |
| | | } |
| | | #endregion |
| | | |
| | | directoryInfo3 = null; |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | |
| | | |
| | | |
| | | }); |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | Task.WaitAll(new Task[]{ taskNight, taskDay, task6, task7 }); |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | var tt2 =DateTime.Now; |
| | | var sumtt = tt2 - tt1; |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | var End = DateTime.Now; |
| | | var Time = Start - End; |
| | | MessageBox.Show("处理完毕,用时"+Convert.ToString(Time)); |
| | | } |
| | | |
| | | #region 两个表格进行比较,如果两个表格中有设备判断标准不统一,将该点变为NG,删除两个表格中NG点相近的最小尺寸点. |
| | | private List<ResultData> CompareFile(FileInfo fileInfo1, FileInfo fileInfo2,List<string> DataTipsor) |
| | | private List<ResultData> CompareFile(List<ResultData> listOne, List<ResultData> listTwo,List<string> DataTipsort) |
| | | { |
| | | var dataList1 = GetFileData(fileInfo1); |
| | | var dataList2 = GetFileData(fileInfo2); |
| | | |
| | | var dataList = new List<ResultData>(); |
| | | foreach (var item in DataTipsor) |
| | | foreach (var item in DataTipsort) |
| | | { |
| | | var list1 = dataList1.FindAll(a => a.TimeTip == item && !a.Result); |
| | | var list2 = dataList2.FindAll(a => a.TimeTip == item && !a.Result); |
| | | var list1 = listOne.FindAll(a => a.TimeTip == item && !a.Result); |
| | | var list2 = listTwo.FindAll(a => a.TimeTip == item && !a.Result); |
| | | var itemToRemove = new List<ResultData>(); |
| | | //计算表格1最大尺寸 |
| | | GetMaxSize(list1); |
| | |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | #region 获取中框角度和位置 |
| | | private List<ResultData> GetMidLocation(List<ResultData> list) |
| | |
| | | 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 ListLenSum1 = list.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 1); |
| | | for (int k = 0; k < ListLenSum1.Count; k++) |
| | | { |
| | | var lenAngle = GetAngle(listLensnumber1[k].X, listLensnumber1[k].Y,1050); |
| | | var lenAngle = GetAngle(ListLenSum1[k].X, ListLenSum1[k].Y,1050); |
| | | if (lenAngle < 0) |
| | | { |
| | | lenAngle = 360 + lenAngle; |
| | | } |
| | | listLensnumber1[k].angle = lenAngle; |
| | | ListLenSum1[k].angle = lenAngle; |
| | | |
| | | var distance = GetDistance(1050, 1050, listLensnumber1[k].X, listLensnumber1[k].Y); |
| | | listLensnumber1[k].R = distance; |
| | | var distance = GetDistance(1050, 1050, ListLenSum1[k].X, ListLenSum1[k].Y); |
| | | ListLenSum1[k].R = distance; |
| | | if (distance <= runparam.MidLens1R1) |
| | | { |
| | | listLensnumber1[k].location = "镜头"; |
| | | ListLenSum1[k].location = "镜头"; |
| | | } |
| | | else if (runparam.MidLens1R1 < distance && distance <= runparam.MidLens1R2) |
| | | { |
| | | listLensnumber1[k].location = "斜面"; |
| | | ListLenSum1[k].location = "斜面"; |
| | | } |
| | | else |
| | | { |
| | | listLensnumber1[k].location = "平面"; |
| | | ListLenSum1[k].location = "平面"; |
| | | } |
| | | |
| | | } |
| | |
| | | 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 ListLenSum1 = list.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 1); |
| | | for (int k = 0; k < ListLenSum1.Count; k++) |
| | | { |
| | | var lenAngle = GetAngle(listLensnumber1[k].X, listLensnumber1[k].Y,1050); |
| | | var lenAngle = GetAngle(ListLenSum1[k].X, ListLenSum1[k].Y,1050); |
| | | if (lenAngle < 0) |
| | | { |
| | | lenAngle = 360 + lenAngle; |
| | | } |
| | | listLensnumber1[k].angle = lenAngle; |
| | | ListLenSum1[k].angle = lenAngle; |
| | | |
| | | var distance = GetDistance(1050, 1050, listLensnumber1[k].X, listLensnumber1[k].Y); |
| | | listLensnumber1[k].R = distance; |
| | | var distance = GetDistance(1050, 1050, ListLenSum1[k].X, ListLenSum1[k].Y); |
| | | ListLenSum1[k].R = distance; |
| | | if (distance <= runparam.MidLens1R1) |
| | | { |
| | | listLensnumber1[k].location = "镜头"; |
| | | ListLenSum1[k].location = "镜头"; |
| | | } |
| | | else if (runparam.MidLens1R1 < distance && distance <= runparam.MidLens1R2) |
| | | { |
| | | listLensnumber1[k].location = "斜面"; |
| | | ListLenSum1[k].location = "斜面"; |
| | | } |
| | | else if(runparam.MidLens1R2 < distance && distance <= runparam.BkLens1R1) |
| | | { |
| | | listLensnumber1[k].location = "平面可视区"; |
| | | ListLenSum1[k].location = "平面可视区"; |
| | | } |
| | | else |
| | | { |
| | | listLensnumber1[k].location = "平面非可视区"; |
| | | ListLenSum1[k].location = "平面非可视区"; |
| | | } |
| | | |
| | | } |
| | |
| | | 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 ListLenSum1 = list.FindAll(a => a.TimeTip == item.Key && a.Lensnumber == 1); |
| | | for (int k = 0; k < ListLenSum1.Count; k++) |
| | | { |
| | | var lenAngle = GetAngle(listLensnumber1[k].X, listLensnumber1[k].Y,1350); |
| | | var lenAngle = GetAngle(ListLenSum1[k].X, ListLenSum1[k].Y,1350); |
| | | if (lenAngle < 0) |
| | | { |
| | | lenAngle = 360 + lenAngle; |
| | | } |
| | | listLensnumber1[k].angle = lenAngle; |
| | | ListLenSum1[k].angle = lenAngle; |
| | | |
| | | var distance = GetDistance(1350, 1350, listLensnumber1[k].X, listLensnumber1[k].Y); |
| | | listLensnumber1[k].R = distance; |
| | | var distance = GetDistance(1350, 1350, ListLenSum1[k].X, ListLenSum1[k].Y); |
| | | ListLenSum1[k].R = distance; |
| | | if (distance <= runparam.BkLens1R1) |
| | | { |
| | | listLensnumber1[k].location = "可视区"; |
| | | ListLenSum1[k].location = "可视区"; |
| | | } |
| | | |
| | | else |
| | | { |
| | | listLensnumber1[k].location = "非可视区"; |
| | | ListLenSum1[k].location = "非可视区"; |
| | | } |
| | | |
| | | } |
| | |
| | | return defatType; |
| | | } |
| | | #endregion |
| | | |
| | | #region 将文件夹进行区分上表格、下表格 |
| | | private void GentClassificationFile(DirectoryInfo directoryInfo,out List<FileInfo> fileinfo1, out List<FileInfo> fileinfo2) |
| | | { |
| | | var fileinfos11 = directoryInfo.GetFiles().ToList().FindAll(a => a.Extension == ".csv"); |
| | | List<FileInfo> fileInfo1 = new List<FileInfo>(); |
| | | List<FileInfo> fileInfo2 = new List<FileInfo>(); |
| | | 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]); |
| | | } |
| | | } |
| | | fileinfo1 = fileInfo1; |
| | | fileinfo2 = fileInfo2; |
| | | |
| | | |
| | | } |
| | | #endregion |
| | | |
| | | #region 获取白点、刮白数据并按镜头输出 |
| | | //private List<ResultData> GetClassificationLens(List<FileInfo> fileInfo1, List<FileInfo> fileInfo2, List<string> DataTipsor) |
| | | //{ |
| | | // List<ResultData> ListReexaminationSum = new List<ResultData>(); |
| | | // List<Task> listTask = new List<Task>(); |
| | | // for (int i = 0; i < fileInfo1.Count; i++) |
| | | // { |
| | | // int index = i; |
| | | // Task task = new Task(() => { |
| | | // var list = CompareFile(fileInfo1[index], fileInfo2[index], DataTipsor); |
| | | |
| | | // ListReexaminationSum.AddRange(list); |
| | | |
| | | // if (fileInfo1[index].Name.Contains("初检中框")) |
| | | // { |
| | | // list = GetMidLocation(list); |
| | | // } |
| | | // else if (fileInfo1[index].Name.Contains("复检中框") && fileInfo1[index].Name.Contains("白点")) |
| | | // { |
| | | // list = GetMidLocation(list); |
| | | // } |
| | | // else if (fileInfo1[index].Name.Contains("复检中框") && fileInfo1[index].Name.Contains("刮白")) |
| | | // { |
| | | // list = GetWhiteLocation(list); |
| | | // } |
| | | // else if (fileInfo1[index].Name.Contains("初检背板")) |
| | | // { |
| | | // //给镜头区分位置及角度 |
| | | // list = GetBkLocation(list); |
| | | // } |
| | | // else if (fileInfo1[index].Name.Contains("复检背板") && fileInfo1[index].Name.Contains("白点")) |
| | | // { |
| | | // list = GetBkLocation(list); |
| | | // } |
| | | // }); |
| | | // task.Start(); |
| | | // listTask.Add(task); |
| | | |
| | | // } |
| | | // Task.WaitAll(listTask.ToArray()); |
| | | // return ListReexaminationSum; |
| | | //} |
| | | #endregion |
| | | |
| | | #region //统计设备未清除数、复检多检出数 |
| | | private void CompareFile2(List<ResultData> ListReexaminationSum, List<ResultData> ListPreliminarySum,List<string> DataTipsor, out List<ResultData> ListNoClearNub, out List<ResultData> ListMayNub) //ListReexaminationSum是复检数据,ListPreliminarySum是初检数据 |
| | | { |
| | | var listNCN = new List<ResultData>(); |
| | | //var listmany = new List<ResultData>(); |
| | | var itemToRemove = new List<ResultData>(); |
| | | for (int i = 0; i < DataTipsor.Count; i++) |
| | | { |
| | | for (int j = 1; j < 5; j++) |
| | | { |
| | | var ListReexaminationLens = ListReexaminationSum.FindAll(a => a.TimeTip == DataTipsor[i] && a.Lensnumber == j&&a.DefectType=="白点"&&!a.Result); |
| | | var ListPreliminaryLens = ListPreliminarySum.FindAll(a => a.TimeTip == DataTipsor[i] && a.Lensnumber == j && a.DefectType == "白点" && !a.Result); |
| | | |
| | | |
| | | for (int k = 0; k < ListPreliminaryLens.Count; k++) |
| | | { |
| | | for (int L = 0; L < ListReexaminationLens.Count; L++) |
| | | { |
| | | var distance = GetDistance(ListPreliminaryLens[k].X, ListPreliminaryLens[k].Y, ListReexaminationLens[L].X, ListReexaminationLens[L].Y); |
| | | if (distance<20) |
| | | { |
| | | listNCN.Add(ListReexaminationLens[L]); //未清除数 |
| | | } |
| | | |
| | | } |
| | | } |
| | | |
| | | } |
| | | |
| | | } |
| | | var listmany = ListReexaminationSum.FindAll(a => a.DefectType == "白点" && !a.Result); |
| | | for (int M = 0; M < listNCN.Count; M++) |
| | | { |
| | | listmany.Remove(listNCN[M]); |
| | | } |
| | | ListNoClearNub = listNCN; |
| | | ListMayNub = listmany; |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | private List <ResultData> GetFileData(FileInfo fileInfos) |
| | | { |
| | | var allLines = File.ReadAllLines(fileInfos.FullName, Encoding.Default); |
| | |
| | | case "镀膜破损": |
| | | dataList = readfile.GetZoomPartFile(allLines); |
| | | break; |
| | | //default: |
| | | // dataList1 = null; |
| | | // break; |
| | | } |
| | | } |
| | | return dataList; |
| | |
| | | |
| | | |
| | | } |
| | | |
| | | #endregion |