P066.Data.git - Gitblit

			@@ -61,20 +61,13 @@

			#region 读取文件夹下的所有文件，并将文件按照上下进行区分;上表格为fileInfo1，下表格为fileInfo2
			GentClassificationFile(directoryInfo1, out List<FileInfo> fileInfo1, out List<FileInfo> fileInfo2); //fileInfo1复检上文件夹，fileInfo2复检下文件夹
			GentClassificationFile(directoryInfo3, out List<FileInfo> fileInfo3, out List<FileInfo> fileInfo4); //fileInfo3初检上文件夹，fileInfo4初检下文件夹
			#endregion
			List<ResultData> DataListMerge = new List<ResultData>();
			var listSum = new List<ResultData>();
			var JudgeListSum = new List<ResultData>();
			string filename = "";
			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);
			@@ -101,13 +94,13 @@
			list.ForEach(a => a.Lensnumber = ScratchI);
			GetMaxSize(list);
			GetBkLocation(list);
			listSum.AddRange(list);
			ListReexaminationSum.AddRange(list);
			}
			else if (fileinfos22[i].Name.Contains("镀膜破损"))
			{
			ZoomI++;
			list.ForEach(a => a.Lensnumber = ZoomI);
			listSum.AddRange(list);
			ListReexaminationSum.AddRange(list);
			}

			}
			@@ -115,116 +108,24 @@
			directoryInfo2 = null;
			}
			#endregion
			listSum.AddRange(GetClassificationLens(fileInfo1, fileInfo2, DataTipsor));
			for (int i = 0; i < fileInfo1.Count; i++)
			{
			//var list = CompareFile(fileInfo1[i], fileInfo2[i], DataTipsor);
			//if (fileInfo1[i].Name.Contains("白点"))
			//{
			// WhiteI++;
			// list.ForEach(a => a.Lensnumber = WhiteI);
			// listSum.AddRange(list);
			//}
			//else if (fileInfo1[i].Name.Contains("刮白"))
			//{
			// WhiteningI++;
			// list.ForEach(a => a.Lensnumber = WhiteningI);
			// listSum.AddRange(list);

			//}


			#region//判断是初检文件夹还是复检文件夹
			string currPath = "";
			//if (fileInfo1[i].Name.Contains("初检中框"))
			//{
			// 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("刮白"))
			//{
			// 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 DataTipsor)
			//{
			// 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");
			// }


			//}
			}


			#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 Lens1 = listSum.FindAll(a => a.TimeTip == item&&a.Lensnumber==1);
			var Lens1 = ListReexaminationSum.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);
			var Lens2 = ListReexaminationSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 2);
			writefile.WriteJR(Lens2,"",2,file12);
			var Lens3 = listSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 3);
			var Lens3 = ListReexaminationSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 3);
			writefile.WriteJR(Lens3,"",3,file12);
			var Lens4 = listSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 4);
			var Lens4 = ListReexaminationSum.FindAll(a => a.TimeTip == item && a.Lensnumber == 4);
			writefile.WriteJR(Lens4,"",4,file12);

			}
			@@ -234,38 +135,57 @@


			#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 DataTipsor)
			if (directoryInfo3!=null)
			{
			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");
			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


			@@ -337,29 +257,29 @@
			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 = "平面";
			}

			}
			@@ -451,33 +371,33 @@
			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 = "平面非可视区";
			}

			}
			@@ -582,26 +502,26 @@
			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 = "非可视区";
			}

			}
			@@ -760,7 +680,7 @@
			#region 获取白点、刮白数据并按镜头输出
			private List<ResultData> GetClassificationLens(List<FileInfo> fileInfo1, List<FileInfo> fileInfo2, List<string> DataTipsor)
			{
			List<ResultData> listsum = new List<ResultData>();
			List<ResultData> ListReexaminationSum = new List<ResultData>();
			int WhiteI = 0;
			int WhiteningI = 0;
			for (int i = 0; i < fileInfo1.Count; i++)
			@@ -770,13 +690,13 @@
			{
			WhiteI++;
			list.ForEach(a => a.Lensnumber = WhiteI);
			listsum.AddRange(list);
			ListReexaminationSum.AddRange(list);
			}
			else if (fileInfo1[i].Name.Contains("刮白"))
			{
			WhiteningI++;
			list.ForEach(a => a.Lensnumber = WhiteningI);
			listsum.AddRange(list);
			ListReexaminationSum.AddRange(list);

			}
			if (fileInfo1[i].Name.Contains("初检中框"))
			@@ -801,9 +721,51 @@
			list = GetBkLocation(list);
			}
			}
			return listsum;
			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);