From a3e2b38a895b32ac08bb4acf18a4e57f65651c4a Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周日, 18 8月 2024 08:14:51 +0800
Subject: [PATCH] 清洗机获取采集数据
---
DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_FormTest/Form1.cs | 115 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 115 insertions(+), 0 deletions(-)
diff --git a/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_FormTest/Form1.cs b/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_FormTest/Form1.cs
index 1b28878..1d8b48c 100644
--- a/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_FormTest/Form1.cs
+++ b/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_FormTest/Form1.cs
@@ -1,4 +1,5 @@
锘縰sing iWare_SCADA_BusinessLogical.Utils;
+using iWare_SCADA_Model;
using System;
using System.Collections.Generic;
using System.ComponentModel;
@@ -68,5 +69,119 @@
MessageBox.Show("寮傚父:" + ex.Message);
}
}
+
+ private void button3_Click(object sender, EventArgs e)
+ {
+ try
+ {
+ string path = ConfigHelper.GetConfigString("OP60QualityData_Zhengshi");
+
+ var newFiles = FileHelper.DetectNewFiles(path, "*.dfq", 300, DateTime.Now.AddDays(-100), DateTime.Now.AddDays(1));
+
+ foreach (System.IO.FileInfo source_doFile in newFiles)
+ {
+ //MessageBox.Show("鎵惧埌FullName:" + source_doFile.FullName+ ",Name:" + source_doFile.Name);
+
+ //鐩爣鏂囦欢鐨勫畬鏁寸洰褰�
+ string destFileName = source_doFile.FullName.Replace("Measuring_Data_dfq", "Measuring_Data_df_Copy");
+ string source_file_name = source_doFile.Name.Replace(".dfq", "");//涓嶅甫鎵╁睍鍚嶇殑鏂囦欢鍚嶅瓧
+ destFileName = destFileName.Replace(source_file_name, source_file_name + "_" + "_" + DateTime.Now.ToString("yyyyMMddHHmmss"));
+ File.Copy(source_doFile.FullName, destFileName, true);
+
+ //FileInfo destFile = new FileInfo(destFileName);
+ //MessageBox.Show("鏂版枃浠舵壘鍒癋ullName:" + destFile.FullName + ",Name:" + destFile.Name);
+ }
+
+ MessageBox.Show("鎴愬姛");
+ }
+ catch (Exception ex)
+ {
+ MessageBox.Show("寮傚父:" + ex.Message);
+ }
+ }
+
+ private void button4_Click(object sender, EventArgs e)
+ {
+
+ }
+
+ private void btn_TongJi_Click(object sender, EventArgs e)
+ {
+ //缁熻
+
+ //鏌愭鏃堕棿鐨勭粺璁�
+ var str_start = this.dateTimePicker_Start.Value.ToString("yyyy-MM-dd" + " " + "00:00:00");
+ var str_end = this.dateTimePicker_End.Value.ToString("yyyy-MM-dd" + " " + "23:59:59");
+ var start = Convert.ToDateTime(str_start);
+ var end = Convert.ToDateTime(str_end);
+
+ int allPlacesCount = 0;
+
+ List<string> strList = new List<string>() {
+ "OP05","OP10","OP20","OP30","OP35","OP40","OP50","OP60","OP70","OP80"
+ };
+ var q_strList = string.Join(",", strList);
+ var str = "";
+ str += "鏃堕棿鑼冨洿: " + str_start + "鑷�" + str_end + " \r\n";
+ using (DbModel edm = new DbModel())
+ {
+ var allPlaces = edm.WorkPieceLog.Where(x =>
+ (x.CreatedTime >= start && x.CreatedTime <= end)).ToList();
+
+
+
+
+ var groups = allPlaces.GroupBy(x => x.WorkingProcedure).OrderBy(x => x.Key);
+ foreach (var gg in groups)
+ {
+ var _key = gg.Key;
+ var _list = gg.ToList();
+ var emtype = " ";
+ var _list_youzhi = _list.Where(x => x.WorkPieceID.Length > 20 && x.WorkPieceID != emtype).ToList();
+ var _list_empty = _list.Where(x => string.IsNullOrEmpty(x.WorkPieceID) || x.WorkPieceID == emtype).ToList();
+ var _list_other = _list.Where(x => !((x.WorkPieceID.Length > 20 && x.WorkPieceID != emtype) || (string.IsNullOrEmpty(x.WorkPieceID) || x.WorkPieceID == emtype))).ToList();
+ var _list_other_str_list = _list_other.Select(x => x.WorkPieceID).Distinct().ToList();
+ var _list_other_str = string.Join("|", _list_other_str_list);
+ str += $"==================銆恵_key}銆�========================= \r\n";
+ str += $"鎬婚噺: {_list.Count()},姝ｇ‘浜岀淮鐮佹暟:{_list_youzhi.Count()},绌哄��:{_list_empty.Count},鍏朵粬:{_list_other.Count},鍒嗗埆鏄瘂_list_other_str} \r\n";
+
+ //鍐嶈繘琛屽垎缁�,缁熻 浜岀淮鐮佷笉瀵圭殑鏁版嵁
+ var _list_qc_error = _list.Where(x => string.IsNullOrEmpty(x.WorkPieceID) || x.WorkPieceID.Length <= 20).ToList();
+ var group_qc_error = _list_qc_error.GroupBy(x => new { x.WorkPieceID, x.CreatedUserName });
+ str += $"浜岀淮鐮佷笉瀵圭殑鏁版嵁锛屾�婚噺: {_list_qc_error.Count()} \r\n";
+ foreach (var item in group_qc_error)
+ {
+ str += $"浜岀淮鐮佷笉瀵圭殑鏁版嵁锛學orkPieceID: {item.Key.WorkPieceID}锛孋reatedUserName: {item.Key.CreatedUserName},鏁伴噺:{item.ToList().Count()} \r\n";
+ }
+
+
+ //鍐嶈繘琛屽垎缁�,缁熻 浜岀淮鐮佸鐨勬暟鎹�
+ var group_qc_ok = _list_youzhi.GroupBy(x => new { x.CreatedUserName });
+ str += $"浜岀淮鐮佹纭殑鏁版嵁锛屾�婚噺: {_list_youzhi.Count()} \r\n";
+ foreach (var item in group_qc_ok)
+ {
+ str += $"浜岀淮鐮佹纭殑鏁版嵁锛孋reatedUserName: {item.Key.CreatedUserName},鏁伴噺:{item.ToList().Count()} \r\n";
+ }
+
+ //鍐嶈繘琛屽垎缁�,缁熻 浜岀淮鐮佸鐨勬暟鎹�-鍘婚噸
+ var _list_youzhi_quchong = _list_youzhi.Select(x => new { x.CreatedUserName }).Distinct().ToList();
+ var group_qc_ok_quchong = _list_youzhi_quchong.GroupBy(x => new { x.CreatedUserName });
+ str += $"锛堝幓閲嶅悗锛変簩缁寸爜姝ｇ‘鐨勬暟鎹紝鎬婚噺: {_list_youzhi_quchong.Count()} \r\n";
+ foreach (var item in group_qc_ok_quchong)
+ {
+ str += $"锛堝幓閲嶅悗锛変簩缁寸爜姝ｇ‘鐨勬暟鎹紝CreatedUserName: {item.Key.CreatedUserName},鏁伴噺:{item.ToList().Count()} \r\n";
+ }
+
+
+ str += "\r\n";
+
+ }
+
+ }
+
+ str += "\r\n";
+
+ this.tb_TongJi.Text = str;
+ }
}
}
--
Gitblit v1.9.3