整改

liuying

2024-10-15 f93c5eb2ac7b0673f4b92105af963760995de00c

 DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_FormTest/Form1.cs

@@ -1,4 +1,5 @@
using iWare_SCADA_BusinessLogical.Utils;
using iWare_SCADA_BusinessLogical;
using iWare_SCADA_BusinessLogical.Utils;
using iWare_SCADA_Model;
using System;
using System.Collections.Generic;
@@ -102,7 +103,10 @@

        private void button4_Click(object sender, EventArgs e)
        {
            string paht = "C:\\Users\\Administrator\\Desktop\\临时\\aa\\FO_000006966558.txt";

            DataCaptureHandler_02 dataCaptureHandler_02 = new DataCaptureHandler_02();
            dataCaptureHandler_02.GetCH5InfoForOP30(paht, new WorkPieceLogMiddle());
        }

        private void btn_TongJi_Click(object sender, EventArgs e)
@@ -195,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>() {
@@ -203,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 =>
@@ -212,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)
@@ -263,7 +269,7 @@
                            WorkPieceID = _key
                        });
                        js_strList.Add(item);
                        allPlacesCount++;
                        allPlaces_QueShi_Count++;

                    }

@@ -279,18 +285,29 @@
                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).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;
        }
@@ -313,5 +330,29 @@
            }
            return new_strList;
        }

        private void button6_Click(object sender, EventArgs e)
        {
            try
            {
                string path = @"U:\\NutrunnerData\\FO\\SEQ_24";

                var newFiles = FileHelper.DetectNewFiles(path, "*.dfq", 300, DateTime.Now.AddDays(-100), DateTime.Now.AddDays(1));

                foreach (System.IO.FileInfo file in newFiles)
                {
                    //MessageBox.Show("找到文件:" + file.FullName);
                    var toPath = file.FullName.Replace("Measuring_Data_df_Test", "Measuring_Data_df_Copy");
                    //MessageBox.Show("要移动到:" + file.FullName);
                    File.Move(file.FullName, toPath);//移动
                }

                MessageBox.Show("成功");
            }
            catch (Exception ex)
            {
                MessageBox.Show("异常:" + ex.Message);
            }
        }
    }
}