OPPO镜头检测数据分析
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
Administrator
2021-05-11 b685b6734263b1669d4d9790eb3e5a2d6faaa04f 
 P066.Data/Form1.cs


@@ -18,6 +18,8 @@


        DirectoryInfo directoryInfo1;


        DirectoryInfo directoryInfo2;


        DirectoryInfo directoryInfo3;


        DirectoryInfo directoryInfo4;




        private P066RunParam runparam = new P066RunParam();


        private ReadFile readfile = new ReadFile();


        private WriteFile writefile = new WriteFile();


@@ -44,6 +46,7 @@


                return;




            directoryInfo2 = new DirectoryInfo(folderBrowserDialog1.SelectedPath);




        }




        private void btnLoadData3_Click(object sender, EventArgs e)


@@ -54,9 +57,91 @@


            }


            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)


        {






                //读取全部表格


            var fileinfos1 = directoryInfo1.GetFiles().ToList().FindAll(a => a.Extension == ".csv");


            var listAllSum = new List<ResultData>();


            List<Task> listTask = new List<Task>();


            var DataTipsort = new List<string>();


            for (int i = 0; i < fileinfos1.Count; i++)


            {


                int index = i;


                var task = Task.Run(() =>


                {


                    listAllSum.AddRange(GetFileData(fileinfos1[index]));


                });


                listTask.Add(task);


            }


            DataTipsort = readfile.TimeStamp(fileinfos1[0]);//读取一个文件夹的时间戳


            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++)


                {


                    int index = i;


                    Task task = Task.Run(() =>


                    {


                        listCompareSum.AddRange(CompareFile(listAllSum.FindAll(a => a.FileName == dictionary[indexMax] + index + "_" + 1 + "白点"),


                                                            listAllSum.FindAll(a => a.FileName == dictionary[indexMax] + index + "_" + 2 + "白点"), DataTipsort));


                    });




                    listTask.Add(task);


                }


            }


            List<ResultData> listWhiteningCompareSum=new    List<ResultData>();


            for (int i = 1; i < 5; i++)


            {


                int index = i;       


                Task task = Task.Run(() =>


                {


                    listWhiteningCompareSum.AddRange(GetWhiteLocation(CompareFile(listAllSum.FindAll(a => a.FileName == dictionary[2] + index + "_" + 1 + "刮白"),


                                                                                  listAllSum.FindAll(a => a.FileName == dictionary[2] + index + "_" + 2 + "刮白"),                                                                                                                DataTipsort)));


                });




                listTask.Add(task);


            }




            Task.WaitAll(listTask.ToArray());


































            var Start = DateTime.Now;


            #region 读取文件夹下的所有文件，并将文件按照上下进行区分;上表格为fileInfo1，下表格为fileInfo2


            List<FileInfo> fileInfo1 = new List<FileInfo>();


@@ -85,18 +170,34 @@


            var ListReexaminationSum = new List<ResultData>();          //复检报表数据


            var ListPreliminarySum = new List<ResultData>();          //初检报表数据


            string filenameDir = "";


            int ScratchI = 0;


            int ZoomI = 0;




            #region 读取一个表格中所有时间戳并排序


            var dataList = GetFileData(fileInfo1[0]); 


            var dataGroup = dataList.GroupBy(a => a.TimeTip);


            var DataTipsor = new List<string>();


            var DataTipsor = new List<string>();        //白夜班总时间戳


            var DataNightTipsor = new List<string>();   //夜班时间戳


            var DataDayTipsor = new List<string>();     //白天时间戳






            foreach (var item in dataGroup)


            {


                int.TryParse(item.Key, out int start);


                DataTipsor.Add(item.Key);


                if (start > 80000)


                {


                    DataDayTipsor.Add(item.Key);


                }


                else


                {


                    DataNightTipsor.Add(item.Key);


                }


            }


            DataTipsor = DataTipsor.Distinct().ToList();


            DataTipsor.Sort();


            DataTipsor.Distinct().ToList().Sort();


            DataDayTipsor.Distinct().ToList().Sort();


            DataNightTipsor.Distinct().ToList().Sort();








            #endregion




            #region 读取划伤、镀膜破损文件夹文件


@@ -109,16 +210,16 @@


               var list = GetFileData(fileinfos22[i]);


                if (fileinfos22[i].Name.Contains("划伤"))


                {


                    ScratchI++;


                    list.ForEach(a => a.Lensnumber = ScratchI);


                    //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);


                    //ZoomI++;


                    //list.ForEach(a => a.Lensnumber = ZoomI);


                    ListReexaminationSum.AddRange(list);


                }




@@ -129,35 +230,40 @@


            #endregion




            var tt1 =DateTime.Now;


           var task2= Task.Run (() =>


           var taskReexamination = Task.Run (() =>


            {




                    ListReexaminationSum.AddRange(GetClassificationLens(fileInfo1, fileInfo2, DataTipsor));


                //复检报表


                //ListReexaminationSum.AddRange(GetClassificationLens(fileInfo1, fileInfo2, DataTipsor));             


                






            });


            var task3= Task.Run(() =>


            var taskPreliminary = Task.Run(() =>


            {




                    ListPreliminarySum.AddRange(GetClassificationLens(fileInfo3, fileInfo4, DataTipsor));       //合并初检上下报表，输出合并后数据


                //初检报表


                /*    ListPreliminarySum.AddRange(GetClassificationLens(fileInfo3, fileInfo4, DataTipsor));  */     //合并初检上下报表，输出合并后数据




                


            });


          


            //Task.WaitAll(task2, task3);




            task2.Wait();


            var task5 = Task.Run(() =>


            taskReexamination.Wait();














            //夜班


            var taskNight= Task.Run(() =>


            {




                #region//将设备判断结果输出到CSV报表中


                #region//将夜班设备判断结果输出到CSV报表中


                //ListReexaminationSum.AddRange(GetClassificationLens(fileInfo1, fileInfo2, DataTipsor));


                var title12 = $"时间戳,相机序号,设备判断结果,缺陷类型,设备后处理结果,最大尺寸,位置,X,Y,R,角度";


                var file12 = $"{directoryInfo1.Parent.FullName}\\{filenameDir + "设备判断结果"}.csv";


                var file12 = $"{directoryInfo1.Parent.FullName}\\{filenameDir + "夜班设备判断结果"}.csv";


                File.AppendAllText(file12, title12, Encoding.UTF8);


                File.AppendAllText(file12, "\r\n");


                foreach (var item in DataTipsor)


                foreach (var item in DataNightTipsor)


                {


                    var Lens1 = ListReexaminationSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 1);


                    writefile.WriteJR(Lens1, item, 1, file12);


@@ -172,23 +278,95 @@






            });


            task3.Wait();


            //白班


            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






            });






            if (directoryInfo4!=null)


            {


                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);


                        }




                    }


          






                });


             


            }


















            taskPreliminary.Wait();






            var task6 = Task.Run(() =>


            {




                #region//根据产品编号输出总缺陷报表


                if (directoryInfo3 != null)


                {


                    //GentClassificationFile(directoryInfo3, out List<FileInfo> fileInfo3, out List<FileInfo> fileInfo4);     //fileInfo3初检上文件夹，fileInfo4初检下文件夹


                    //ListPreliminarySum.AddRange(GetClassificationLens(fileInfo3, fileInfo4, DataTipsor));       //合并初检上下报表，输出合并后数据


                    List<ResultData> ListNoClearNub = new List<ResultData>();       //清除失败数


                    List<ResultData> ListMayNub = new List<ResultData>();       //复检多检出数数


                    CompareFile2(ListReexaminationSum, ListPreliminarySum, DataTipsor, out ListNoClearNub, out ListMayNub);


                    CompareFile2(ListReexaminationSum, ListPreliminarySum, DataNightTipsor, out ListNoClearNub, out ListMayNub);


                    var title = $"产品编号,镜头编号,总缺陷数量,设备清除数,未清除数,复检多检出数";


                    var file = $"{directoryInfo1.Parent.FullName}\\{filenameDir + "缺陷总数报表"}.csv";


                    var file = $"{directoryInfo1.Parent.FullName}\\{filenameDir + "夜班缺陷总数报表"}.csv";


                    File.AppendAllText(file, title, Encoding.UTF8);


                    File.AppendAllText(file, "\r\n");


                    foreach (var item in DataTipsor)




                    #region 夜班


                    foreach (var item in DataNightTipsor)


                    {


                        //总缺陷数


                        var ListLenSum1 = ListPreliminarySum.FindAll(a => a.TimeTip == item && a.Lensnumber == 1 && a.DefectType == "白点" && !a.Result);


@@ -225,7 +403,7 @@


                        }


                    }


                    var title1 = $"镜头编号,总缺陷数量,设备清除数,清除率";


                    var file1 = $"{directoryInfo1.Parent.FullName}\\{filenameDir + "缺陷总数报表"}.csv";


                    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++)


@@ -244,20 +422,117 @@


                        var defectClearSum = listlensum1 - listlennoclearsum1;






                        var content1 = $"{i},{defectSum},{defectClearSum},{(double)(defectSum / defectSum)}";


                        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[]{ task5, task6});


            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 });








@@ -278,15 +553,14 @@


        }




        #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);


@@ -764,59 +1038,47 @@


        #endregion




        #region  获取白点、刮白数据并按镜头输出


        private List<ResultData> GetClassificationLens(List<FileInfo> fileInfo1, List<FileInfo> fileInfo2, List<string> DataTipsor)


        {


            List<ResultData> ListReexaminationSum = new List<ResultData>();


            int WhiteI = 0;


            int WhiteningI = 0;


            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);


                    if (fileInfo1[index].Name.Contains("白点"))


                    {


                        WhiteI++;


                        list.ForEach(a => a.Lensnumber = WhiteI);


                        ListReexaminationSum.AddRange(list);


                    }


                    else if (fileInfo1[index].Name.Contains("刮白"))


                    {


                        WhiteningI++;


                        list.ForEach(a => a.Lensnumber = WhiteningI);


                        ListReexaminationSum.AddRange(list);


        //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);


        //            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;


        }


        //    }


        //    Task.WaitAll(listTask.ToArray());


        //    return ListReexaminationSum;


        //}


        #endregion




        #region   //统计设备未清除数、复检多检出数


@@ -890,3 +1152,5 @@






}




#endregion