From 3b3e3bcf1345197670c82988ceb3e8d34be3b5f1 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周一, 02 9月 2024 18:24:58 +0800
Subject: [PATCH] 界面战士
---
DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_FormTest/Form1.cs | 300 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 299 insertions(+), 1 deletions(-)
diff --git a/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_FormTest/Form1.cs b/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_FormTest/Form1.cs
index f8ac998..39894ab 100644
--- a/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_FormTest/Form1.cs
+++ b/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_FormTest/Form1.cs
@@ -1,4 +1,6 @@
-锘縰sing iWare_SCADA_BusinessLogical.Utils;
+锘縰sing iWare_SCADA_BusinessLogical;
+using iWare_SCADA_BusinessLogical.Utils;
+using iWare_SCADA_Model;
using System;
using System.Collections.Generic;
using System.ComponentModel;
@@ -9,6 +11,7 @@
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
+using static System.Windows.Forms.VisualStyles.VisualStyleElement.TaskbarClock;
namespace iWare_SCADA_FormTest
{
@@ -43,5 +46,300 @@
}
}
+
+ private void button2_Click(object sender, EventArgs e)
+ {
+ try
+ {
+ string path = ConfigHelper.GetConfigString("OP60QualityData_Test");
+
+ 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);
+ }
+ }
+
+ 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)
+ {
+ 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)
+ {
+ //缁熻
+
+ //鏌愭鏃堕棿鐨勭粺璁�
+ 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;
+ }
+
+ private void button5_Click(object sender, EventArgs e)
+ {
+ //鍒嗘瀽缂哄伐搴�
+ this.tb_TongJi.Text = "";
+
+ //鏌愭鏃堕棿鐨勭粺璁�
+ 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<WorkPieceProcess> workPieceProcessList = new List<WorkPieceProcess>();
+ List<string> js_strList = new List<string>();
+ 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 pieces = edm.WorkPieceInfo.AsNoTracking().Where(x =>
+ (x.CreatedTime >= start && x.CreatedTime <= end)).ToList();
+
+ var queryIds = pieces.Select(x => x.WorkPieceID).ToList();
+
+ var allPlaces = edm.WorkPieceProcess.AsNoTracking().Where(x => queryIds.Contains(x.WorkPieceID)).ToList();
+
+ var groups = allPlaces.GroupBy(x => x.WorkPieceID).OrderBy(x => x.Key);
+ foreach (var gg in groups)
+ {
+ var _key = gg.Key;
+ if (_key.Length != 22)
+ {
+ continue;
+ }
+ if (!(_key.IndexOf("DZ") > -1))
+ {
+ continue;
+ }
+
+ //閲嶆柊璇诲彇鏁版嵁搴�
+ var _list = gg.ToList().OrderByDescending(x => x.CreatedTime);
+
+
+ if (_key == "DZ045L2408290100451PAS")
+ {
+ var zz = "";
+ }
+
+ var fisrt = _list.FirstOrDefault();
+ var first_pr = fisrt.WorkingProcedureCurrent;
+
+ var bb = first_pr.Substring(2, 2);
+ int ii = Convert.ToInt32(bb);
+
+ List<string> new_strList = GetListForOP(ii);//鍏ㄩ儴鐨�
+ var curList = _list.Select(x => x.WorkingProcedureCurrent).ToList();
+ var cur_new_strList = new_strList.Where(x => !curList.Contains(x)).ToList();
+ if (cur_new_strList.Count > 0)
+ {
+ // //鍐嶈涓嬫暟鎹簱
+ // _list = edm.WorkPieceProcess.AsNoTracking().Where(x =>
+ //x.WorkPieceID == _key).ToList().OrderByDescending(x => x.CreatedTime);
+ // curList = _list.Select(x => x.WorkingProcedureCurrent).ToList();
+ // cur_new_strList = new_strList.Where(x => !curList.Contains(x)).ToList();
+ }
+ //鐪嬬湅鍓嶉潰鐨勫伐搴忔槸鍚﹂兘鏈�
+ foreach (var item in cur_new_strList)
+ {
+
+
+ workPieceProcessList.Add(new WorkPieceProcess()
+ {
+ WorkingProcedureCurrent = item,
+ WorkPieceID = _key
+ });
+ js_strList.Add(item);
+ allPlacesCount++;
+
+ }
+
+ }
+
+ }
+
+ var hzStr = "";
+ //var groups22 = js_strList.GroupBy(x => x).OrderBy(x => x.Count());
+ var groups22 = js_strList.GroupBy(x => x).OrderBy(x => x.Key);
+ foreach (var gg in groups22)
+ {
+ hzStr += $"宸ュ簭缂哄け{gg.Key} 鍏眥gg.ToList().Count()}涓�" + "\r\n";
+ }
+
+ var total = $"鎬昏缂哄け:{allPlacesCount}銆�";
+ total += "\r\n";
+ total += hzStr;
+ total += "\r\n";
+
+ //澶勭悊
+ workPieceProcessList = workPieceProcessList.OrderBy(x => x.WorkingProcedureCurrent).ThenBy(x=>x.WorkPieceID).ToList();
+ foreach (var item in workPieceProcessList)
+ {
+ str += $"缂哄皯{item.WorkingProcedureCurrent}宸ュ簭锛學orkPieceID: {item.WorkPieceID} \r\n";
+ }
+ str += "\r\n";
+
+ this.tb_TongJi.Text = total + str;
+ }
+
+
+ private List<string> GetListForOP(int ii)
+ {
+ List<string> new_strList = new List<string>() { };
+ List<string> strList = new List<string>() {
+ "OP05","OP10","OP20","OP30","OP35","OP40","OP50","OP60","OP70","OP80"
+ };
+ foreach (var item in strList)
+ {
+ var bb = item.Substring(2, 2);
+ int dd = Convert.ToInt32(bb);
+ if (dd <= ii)
+ {
+ new_strList.Add(item);
+ }
+ }
+ 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);
+ }
+ }
}
}
--
Gitblit v1.9.3