1

schangxiang@126.com

2024-09-13 5573ddf8f8b977d25561529b1ee912aca9b93801

1

 DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_FormTest/Form1.cs

@@ -199,7 +199,8 @@
            var start = Convert.ToDateTime(str_start);
            var end = Convert.ToDateTime(str_end);

            int allPlacesCount = 0;
            int allNum = 0;
            int allPlaces_QueShi_Count = 0;
            List<WorkPieceProcess> workPieceProcessList = new List<WorkPieceProcess>();
            List<string> js_strList = new List<string>();
            List<string> strList = new List<string>() {
@@ -207,7 +208,7 @@
            };
            var q_strList = string.Join(",", strList);
            var str = "";
            str += "时间范围: " + str_start + "至" + str_end + " \r\n";
           
            using (DbModel edm = new DbModel())
            {
                var pieces = edm.WorkPieceInfo.AsNoTracking().Where(x =>
@@ -216,6 +217,7 @@
                var queryIds = pieces.Select(x => x.WorkPieceID).ToList();

                var allPlaces = edm.WorkPieceProcess.AsNoTracking().Where(x => queryIds.Contains(x.WorkPieceID)).ToList();
                allNum = allPlaces.Count();

                var groups = allPlaces.GroupBy(x => x.WorkPieceID).OrderBy(x => x.Key);
                foreach (var gg in groups)
@@ -267,7 +269,7 @@
                            WorkPieceID = _key
                        });
                        js_strList.Add(item);
                        allPlacesCount++;
                        allPlaces_QueShi_Count++;

                    }

@@ -283,19 +285,30 @@
                hzStr += $"工序缺失{gg.Key} 共{gg.ToList().Count()}个" + "\r\n";
            }

            var total = $"总计缺失:{allPlacesCount}。";
            var total = $"总计缺失:{allPlaces_QueShi_Count}。";
            total += "\r\n";
            //汇总数据
            //计算有效数据率

            total += $"总工序数量:{allNum},有工序数据{(allNum - allPlaces_QueShi_Count)};";
            total += "\r\n";
            total += $"有效数据率:{((double)(allNum - allPlaces_QueShi_Count) / (double)allNum * 100).ToString("0.0")}%";
            total += "\r\n";
            total += "时间范围: " + str_start + "至" + str_end + " \r\n";
            total += hzStr;
            total += "\r\n";

            //处理
            workPieceProcessList = workPieceProcessList.OrderBy(x => x.WorkingProcedureCurrent).ThenBy(x=>x.WorkPieceID).ToList();
            workPieceProcessList = workPieceProcessList.OrderBy(x => x.WorkingProcedureCurrent).ThenBy(x => x.WorkPieceID).ToList();
            foreach (var item in workPieceProcessList)
            {
                str += $"缺少{item.WorkingProcedureCurrent}工序，WorkPieceID: {item.WorkPieceID}  \r\n";
            }
            str += "\r\n";




            this.tb_TongJi.Text = total + str;
        }