Jack.Peng
2021-04-27 4a1b63744d07e8644891eacb96f192bd38705c24
P066.Data/Form1.cs
@@ -102,13 +102,30 @@
            #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 读取划伤、镀膜破损文件夹文件
@@ -141,35 +158,65 @@
            #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));       //合并初检上下报表,输出合并后数据
                
            });
            //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);
                    for (int i = 2; i < 5; i++)
                    {
                        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);
@@ -185,18 +232,18 @@
            });
            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();
            if (listPicyreSor.Count!=0)
            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));
@@ -219,8 +266,8 @@
                });
            }
@@ -228,23 +275,26 @@
            task3.Wait();
            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);
@@ -281,7 +331,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++)
@@ -304,16 +354,113 @@
                        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 });