OPPO镜头检测数据分析
parent: 7eb14a00 | 补丁 | 提交 | ignore whitespace
Jack.Peng
2021-04-12 93897305bd1c0abeab2588fac214b545d959f232 
1.新增多线程。
1个文件已添加
1个文件已修改
202 ■■■■■ 已修改文件
P066.Data/Form1.cs 202 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
TP/对标产品IMEI_2020-04-09.xlsx 补丁 | 查看 | 原始文档 | blame | 历史 
 P066.Data/Form1.cs


@@ -11,7 +11,6 @@


using Bro.Common;


using Bro.Common.Util;


using System.Configuration;




namespace P066.Data


{


    public partial class Form1 : Form


@@ -58,11 +57,31 @@




        private void btnAnalyze_Click(object sender, EventArgs e)


        {




            var Start = DateTime.Now;


            #region è¯»å–文件夹下的所有文件，并将文件按照上下进行区分;上表格为fileInfo1，下表格为fileInfo2


            GentClassificationFile(directoryInfo1, out List<FileInfo> fileInfo1, out List<FileInfo> fileInfo2);     //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


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


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


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


            string filenameDir = "";


@@ -109,86 +128,127 @@


            }


            #endregion








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


            var tt1 =DateTime.Now;


           var task2= Task.Run (() =>


            {


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


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


                var Lens2 = ListReexaminationSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 2);


                writefile.WriteJR(Lens2,"",2,file12);


                var Lens3 = ListReexaminationSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 3);


                writefile.WriteJR(Lens3,"",3,file12);


                var Lens4 = ListReexaminationSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 4);


                writefile.WriteJR(Lens4,"",4,file12);


               


            }


            #endregion




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


                










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


            if (directoryInfo3!=null)


            });


            var task3= Task.Run(() =>


            {


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




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


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


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


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


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




                


            });


          


            Task.WaitAll(task2, task3);






            var task5 = 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 DataTipsor)


                {


                    //总缺陷数


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




                    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 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 Lens = ListReexaminationSum.FindAll(a => a.TimeTip == item && a.Lensnumber == i);


                        writefile.WriteJR(Lens, "", i, file12);


                    }




                }


                directoryInfo3 = null;


            }




            #endregion


                #endregion






            });


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




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


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


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


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


                    foreach (var item in DataTipsor)


                    {


                        //总缺陷数


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


                        }


                    }


                    directoryInfo3 = null;


                }




                #endregion


            });






            Task.WaitAll(new Task[]{ task5, task6});












            var tt2 =DateTime.Now;


            var sumtt = tt2 - tt1;




          


          






     




            var End = DateTime.Now;


            var Time = Start - End;


            MessageBox.Show("处理完毕，用时"+Convert.ToString(Time));


        }




        #region ä¸¤ä¸ªè¡¨æ ¼è¿›è¡Œæ¯”较,如果两个表格中有设备判断标准不统一，将该点变为NG，删除两个表格中NG点相近的最小尺寸点.




 TP/¶Ô±ê²úÆ·IMEI_2020-04-09.xlsx

Binary files differ