1.读取文件全部单独拆分来读取，易于后期维护。

Jack.Peng

2021-03-25 e5bd758158da36fc8068cb6d686d8affc7f29639

 P066.Data/Form1.cs

@@ -19,8 +19,10 @@
        DirectoryInfo directoryInfo1;
        DirectoryInfo directoryInfo2;
        private P066RunParam runparam = new P066RunParam();
        private ReadFile readfile = new ReadFile();
        private WriteFile writefile = new WriteFile();
       

        
        public Form1()
        {
            InitializeComponent();
@@ -49,11 +51,12 @@
        private void btnAnalyze_Click(object sender, EventArgs e)
        {

            var fileinfos11 = directoryInfo1.GetFiles();
            //var fileinfos22 = directoryInfo2.GetFiles();
            #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.Length; i++)
            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") )
                {
@@ -63,11 +66,8 @@
                {
                    fileInfo2.Add(fileinfos11[i]);
                }


            }


            #endregion
            List<ResultData> DataListMerge = new List<ResultData>();
            var listSum = new List<ResultData>();
            var JudgeListSum = new List<ResultData>();
@@ -80,16 +80,11 @@
            int ChuNum = 0;
            int FuNum = 0;
            int GuaNum = 0;
            #region//获取时间戳并排序
            var allLines1 = File.ReadAllLines(fileInfo1[0].FullName, Encoding.Default);
            List<ResultData> dataList1 = new List<ResultData>();
            if (allLines1.Length > 1)
            {
                dataList1 = GetData(allLines1,GetDefactType(fileInfo1[0]));
            }
            var dataGroup111 = dataList1.GroupBy(a => a.TimeTip);
            #region 读取一个表格中所有时间戳并排序
            var dataList = GetFileData(fileInfo1[0]); 
            var dataGroup = dataList.GroupBy(a => a.TimeTip);
            var dataListSum22 = new List<string>();
            foreach (var item in dataGroup111)
            foreach (var item in dataGroup)
            {
                dataListSum22.Add(item.Key);
            }
@@ -97,14 +92,38 @@
            dataListSum22.Sort();
            #endregion

            //如果需要合并表格就执行
            if (fileInfo1.Count== fileInfo2.Count)
            #region 读取划伤、镀膜破损文件夹文件
            if (directoryInfo2 != null)
            {
             for (int i = 0; i < fileInfo1.Count; i++)
             {
                CompareFile(fileInfo1[i], fileInfo2[i], dataListSum22, out DataListMerge);
                var list = DataListMerge;      /*CompareFile(fileInfo1[i], fileInfo2[i],dataListSum22)*/
                var fileinfos22 = directoryInfo2.GetFiles().ToList().FindAll(a=>a.Extension==".csv");

            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);
                }
                else if (fileinfos22[i].Name.Contains("镀膜破损"))
                {
                    ZoomI++;
                    list.ForEach(a => a.Lensnumber = ZoomI);
                    listSum.AddRange(list);
                }

            }

                directoryInfo2 = null;
            }
            #endregion

            for (int i = 0; i < fileInfo1.Count; i++)
             {
                var list= CompareFile(fileInfo1[i], fileInfo2[i], dataListSum22);
                if (fileInfo1[i].Name.Contains("白点"))
                {
                    WhiteI++;
@@ -119,8 +138,9 @@

                }

                string currPath = "";

                #region//判断是初检文件夹还是复检文件夹
                string currPath = "";
                if (fileInfo1[i].Name.Contains("初检中框"))
                {
                    ChuNum++;
@@ -194,20 +214,7 @@

                }
             }
            }

            //不需要合并表格
            else if(fileInfo1.Count>0&& fileInfo2.Count==0)
            {
                for (int i = 0; i < fileInfo1.Count; i++)
                {
                    var allLines = File.ReadAllLines(fileInfo1[i].FullName, Encoding.Default);
                    var list = GetData(allLines,GetDefactType(fileInfo1[i]));      /*CompareFile(fileInfo1[i], fileInfo2[i],dataListSum22)*/

                }
            }


            

            #region//将设备判断结果输出到CSV报表中
            var title12 = $"时间戳,相机序号,设备判断结果,缺陷类型,设备后处理结果,最大尺寸,位置,X,Y,R,角度";
@@ -217,14 +224,14 @@
            foreach (var item in dataListSum22)
            {
                var Lens1 = listSum.FindAll(a => a.TimeTip == item&&a.Lensnumber==1);
                WriteJR(Lens1,item,1,file12);
                writefile.WriteJR(Lens1,item,1,file12);
                var Lens2 = listSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 2);
                WriteJR(Lens2,"",2,file12);
                writefile.WriteJR(Lens2,"",2,file12);
                var Lens3 = listSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 3);
                WriteJR(Lens3,"",3,file12);
                writefile.WriteJR(Lens3,"",3,file12);
                var Lens4 = listSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 4);
                WriteJR(Lens4,"",4,file12);

                writefile.WriteJR(Lens4,"",4,file12);
               
            }
            #endregion

@@ -269,65 +276,28 @@

        }

        private void CompareFile(FileInfo fileInfo1, FileInfo fileInfo2,List<string> DataTipsor,out List<ResultData> DataListMerger)
        #region 两个表格进行比较,如果两个表格中有设备判断标准不统一，将该点变为NG，删除两个表格中NG点相近的最小尺寸点.
        private List<ResultData> CompareFile(FileInfo fileInfo1, FileInfo fileInfo2,List<string> DataTipsor)
        {
            var allLines1 = File.ReadAllLines(fileInfo1.FullName, Encoding.Default);
            var allLines2 = File.ReadAllLines(fileInfo2.FullName, Encoding.Default);
            List<ResultData> dataList1 = new List<ResultData>();
            List<ResultData> dataList2 = new List<ResultData>();
            string defectType1 = "";
            string defectType2 = "";
            defectType1 = GetDefactType(fileInfo1);
            defectType2 = GetDefactType(fileInfo2);

            if (allLines1.Length>1)
            {
                dataList1 = GetData(allLines1,defectType1);
            }
            if (allLines2.Length > 1)
            {
                dataList2 = GetData(allLines2,defectType2);
            }
            var dataList1 = GetFileData(fileInfo1);
            var dataList2 = GetFileData(fileInfo2);
            var dataList = new List<ResultData>();
            foreach (var item in DataTipsor)
            {
                var list1 = dataList1.FindAll(a => a.TimeTip == item && !a.Result);
                var list2 = dataList2.FindAll(a => a.TimeTip == item && !a.Result);
                var itemToRemove = new List<ResultData>();
                #region//计算表格2最大尺寸
                for (int ii = 0; ii < list2.Count; ii++)
                {
                    if (list2[ii].Width > list2[ii].Height)
                    {
                        list2[ii].ex = list2[ii].Width * 0.0043;
                    }
                    else
                    {
                        list2[ii].ex = list2[ii].Height * 0.0043;
                    }

                }
                #endregion  
                //计算表格1最大尺寸
                GetMaxSize(list1);
                //计算表格2最大尺寸
                GetMaxSize(list2);
                for (int i = 0; i < list1.Count; i++)
                {
                    #region//计算表格1最大尺寸
                    if (list1[i].Width > list1[i].Height)
                    {
                        list1[i].ex = list1[i].Width * 0.0043;
                    }
                    else
                    {
                        list1[i].ex = list1[i].Height * 0.0043;
                    }

                    #endregion
                    for (int j = 0; j < list2.Count; j++)
                    {
                        if (list1[i].JudgmentResult != list2[j].JudgmentResult)
                        {
                            list1[i].JudgmentResult = "NG";
                            list2[j].JudgmentResult = "NG";

                            list1[i].JudgmentResult = list2[j].JudgmentResult = "NG";
                        }
                        if (list1[i].PostTreatmentResults.Length<list2[j].PostTreatmentResults.Length)
                        {
@@ -337,7 +307,6 @@
                        {
                            list2[j].PostTreatmentResults = list1[i].PostTreatmentResults;
                        }

                        var distance = GetDistance(list1[i].X, list1[i].Y, list2[j].X, list2[j].Y);
                        if (distance < 20)
                        {
@@ -350,13 +319,9 @@
                            {
                                itemToRemove.Add(list1[i]);
                            }

                           

                        }
                    }
                }

                dataList.AddRange(list1);
                dataList.AddRange(list2);
                for (int i = 0; i < itemToRemove.Count; i++)
@@ -364,14 +329,13 @@
                    dataList.Remove(itemToRemove[i]);
                }
            }

            DataListMerger=dataList;

            return dataList;
        }
     
        #endregion

      
        //获取中框角度和位置


        #region   获取中框角度和位置
        private List<ResultData> GetMidLocation(List<ResultData> list)
        {
            var group = list.GroupBy(a => a.TimeTip);
@@ -484,7 +448,8 @@
            }
            return list;
        }
        //获取中框刮白角度和位置
        #endregion
        #region 获取中框刮白角度和位置
        private List<ResultData> GetWhiteLocation(List<ResultData> list)
        {
            var group = list.GroupBy(a => a.TimeTip);
@@ -613,7 +578,9 @@
            }
            return list;
        }
        //获取背板角度和位置
        #endregion
        
        #region 获取背板角度和位置
        private List<ResultData> GetBkLocation(List<ResultData> list)
        {
            var group = list.GroupBy(a => a.TimeTip);
@@ -712,71 +679,38 @@
            }
            return list;
        }

        //写入设备判断结果报表
        private void WriteJR(List<ResultData> 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},{Lens[0].PostTreatmentResults}";
                    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");
                    }
                }

            }
        }


        //计算两点之间距离
        #endregion
        #region  计算两点之间距离
        private double GetDistance(double x1, double y1, double x2, double y2)
        {
            return Math.Sqrt(Math.Pow((x2 - x1), 2) + Math.Pow((y2 - y1), 2));
        }
        //计算角度
        #endregion
          #region 计算角度
        private double GetAngle(double x1, double y1,double size)
        {
            return Math.Atan2((y1 - size), (x1 - size)) * (180 / Math.PI);
        }
        #endregion
         #region 计算最大尺寸
        private List<ResultData> GetMaxSize(List<ResultData> list)
        {
            for (int i = 0; i < list.Count; i++)
            {
                if (list[i].Width > list[i].Height)
                {
                    list[i].ex = list[i].Width * 0.0043;
                }
                else
                {
                    list[i].ex = list[i].Height * 0.0043;
                }


        //获取文件名称并确定缺陷类型
            }
            return list;
        }
        #endregion  
        #region 获取文件名称并确定缺陷类型
        private string GetDefactType(FileInfo fileinfo)
        {
            string defatType="";
@@ -802,151 +736,34 @@

            return defatType;
        }

        private List<ResultData> GetData(string[] allLines,string defectType)
        #endregion
        private List <ResultData> GetFileData(FileInfo fileInfos)
        {
            var dataList = new List<ResultData>();
            var nametemp = allLines[1].Split(',')[0];
            var resulttemp = allLines[1].Split(',')[1];
            string Ptr = "";
            for (int i = 1; i < allLines.Length; i++)
            var allLines = File.ReadAllLines(fileInfos.FullName, Encoding.Default);
            List<ResultData> dataList = new List<ResultData>();
            if (allLines.Length > 1)
            {

                var data = allLines[i].Split(',');


                if (data[0] == "")
                switch (GetDefactType(fileInfos))
                {
                    data[0] = nametemp;
                    data[1] = resulttemp;
                    if (defectType == "白点")
                    {
                        data[10] = Ptr;
                    }


                    case "白点":
                        dataList = readfile.GetWhiteFile(allLines);
                        break;
                    case "刮白":
                        dataList = readfile.GetWhiteningFile(allLines);
                        break;
                    case "划伤":
                        dataList = readfile.GetScratchPartFile(allLines);
                        break;
                    case "镀膜破损":
                        dataList = readfile.GetZoomPartFile(allLines);
                        break;
                    //default:
                    //    dataList1 = null;
                    //    break;
                }
                if (defectType == "刮白")
                {
                    Ptr = "刮白";
                }
                else if (defectType == "划伤")
                {
                    Ptr = "划伤";
                }
                else if (defectType == "白点")
                {
                    Ptr = data[10];
                }


                if (data[6] == "-")
                {

                    dataList.Add(new ResultData()
                    {
                        TimeTip = data[0].Split('-')[0],
                        ImageFileName = data[0],
                        JudgmentResult = data[1] == "OK" ? "OK" : "NG",
                        Result = data[3] == "OK",

                    }); ; ;

                    continue;

                }
               else if (data.Length<5)
                {
                    dataList.Add(new ResultData()
                    {
                        TimeTip = data[0].Split('-')[0],
                        ImageFileName = data[0],
                        JudgmentResult = data[1] == "OK" ? "OK" : "NG",
                        Result = data[3] == "OK",

                    }); ; ;

                    continue;
                }


                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 = data[1]=="OK" ? "OK" :"NG",
                    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;
        }


    }

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


    }