From a239a07d5ba48791a20af5d1b4473c61c62eb95e Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期二, 09 七月 2024 16:04:46 +0800
Subject: [PATCH] 1
---
WFormSynchronizeData_SMR/WFormReadData_SMR/ReadyDataForm.cs | 331 ++++++++++++++++++++++++++++++------------------------
1 files changed, 182 insertions(+), 149 deletions(-)
diff --git a/WFormSynchronizeData_SMR/WFormReadData_SMR/ReadyDataForm.cs b/WFormSynchronizeData_SMR/WFormReadData_SMR/ReadyDataForm.cs
index 4f91b32..e432e06 100644
--- a/WFormSynchronizeData_SMR/WFormReadData_SMR/ReadyDataForm.cs
+++ b/WFormSynchronizeData_SMR/WFormReadData_SMR/ReadyDataForm.cs
@@ -1,4 +1,7 @@
-锘縰sing Newtonsoft.Json;
+锘縰sing HslCommunication;
+using HslCommunication.Profinet.Melsec;
+using Microsoft.VisualBasic.FileIO;
+using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
@@ -25,93 +28,26 @@
//璇诲彇鏁版嵁
private void btnReadData_Click(object sender, EventArgs e)
{
- if (num == 0) {
- this.btnReadData.Text = "鏆傚仠";
- this.timer1.Enabled = true;
- num = 1;
- }else if (num == 1)
+ if (this.HEmpCode.Text == "")
{
- this.btnReadData.Text = "鍚姩";
- this.timer1.Enabled = false;
- num = 0;
+
+ MessageBox.Show("璇疯緭鍏ュ憳宸ョ紪鐮�");
}
-
-
-
-// if (this.HEmpCode.Text == "") {
-
-// MessageBox.Show("璇疯緭鍏ュ憳宸ョ紪鐮�");
-// }
-// else
-// {
-// int year = DateTime.Now.Year;
-// string month = DateTime.Now.Month.ToString();
-// string day = DateTime.Now.Day.ToString();
-
-// string dataTime = DateTime.Now.ToString("yyyyMMdd");
-// ////鍒ゆ柇鏄惁鏈夎繖涓枃浠�
-// //bool flag = File.Exists($@"D:\{year}\{month}\{day}\{dataTime}.txt");
-// bool flag = File.Exists($@"C:\Users\admin\Desktop\鏂板缓鏂囦欢澶� (2)\20231123.txt");
-
-// if (flag)
-// {
-// //StreamReader stream = new StreamReader($@"D:\{year}\{month}\{day}\{dataTime}.txt", Encoding.GetEncoding("gb2312"));
-// StreamReader stream = new StreamReader($@"C:\Users\admin\Desktop\鏂板缓鏂囦欢澶� (2)\20231123.txt", Encoding.GetEncoding("gb2312"));
-
-// string FileData = stream.ReadToEnd();
-// stream.Close();
-// FileData = FileData.Substring(0, FileData.Length - 1);
-// FileData = "[" + FileData + "]";
-// //JSON搴忓垪鍖栬浆鎹㈠瓧鍏搁泦鍚�
-// List<Dictionary<string, string>> list = new List<Dictionary<string, string>>();
-// List<object> DataList = JsonConvert.DeserializeObject<List<object>>(FileData);
-// foreach (JObject item in DataList)
-// {
-// Dictionary<string, string> dic = new Dictionary<string, string>();
-// foreach (var itm in item.Properties())
-// {
-// dic.Add(itm.Name, itm.Value.ToString());
-// }
-// list.Add(dic);
-// }
-// //鑾峰彇褰撳墠鏃堕棿
-// DateTime ActionTime = DateTime.Parse(DateTime.Now.AddMinutes(-1).ToString("yyyy-MM-dd HH:mm:ss"));
-// DateTime EndTime = DateTime.Parse(DateTime.Now.AddMinutes(1).ToString("yyyy-MM-dd HH:mm:00"));
-// //寰幆闆嗗悎
-// for (int i = 0; i < list.Count; i++)
-// {
-// DateTime NowTime = DateTime.Parse(list[i]["HDate"].ToString());
-// if (NowTime >= ActionTime && NowTime < EndTime)
-// {
-// string HSourceCode = list[i]["HSouceNumber"].ToString();
-// string HEmpCode = this.HEmpCode.Text;
-// //string HEmpCode = "";
-// string HType = list[i]["HBadReason"].ToString();
-// string HBarCode = list[i]["HBadCodeSN"].ToString();
-// int HCount = 1;
-// string HCreateTime = list[i]["HDate"].ToString();
-// string HDate = DateTime.Parse(list[i]["HDate"].ToString()).ToString("yyyy-MM-dd");
-// string HResult = list[i]["HResult"].ToString();
-// string HProcNumber = list[i]["HProcNumber"].ToString();
-// int HFlag = 0;
-
-// DataSet ds = oCN.RunProcReturn(@"select * from Sb_EquipMentCollection_SN where HBarCode='" + HBarCode + "' and HCreateTime='" + HCreateTime + "'", "Sb_EquipMentCollection_SN");
-
-// if (ds.Tables[0].Rows.Count == 0)
-// {
-// string sql = $@"insert into Sb_EquipMentCollection_SN(HSourceCode,HEmpCode,HType,HBarCode,HCount,HCreateTime,HDate,HResult,HProcNumber,HFlag)
-//values('{HSourceCode}','{HEmpCode}','{HType}','{HBarCode}','{HCount}','{HCreateTime}','{HDate}','{HResult}','{HProcNumber}','{HFlag}')";
-// oCN.RunProc(sql);
-// ListSelect.Items.Add("鏉＄爜:" + HBarCode + ",鏃ユ湡:" + HCreateTime + ",缁撴灉:" + HResult);
-// }
-// }
-// else
-// {
-// //CustomWriteLog("鏃堕棿涓嶅湪淇濆瓨鑼冨洿鍐�", DateTime.Now.ToString("yyyy-MM-dd"));
-// }
-// }
-// }
-// }
+ else
+ {
+ if (num == 0)
+ {
+ this.btnReadData.Text = "鏆傚仠";
+ this.timer1.Enabled = true;
+ num = 1;
+ }
+ else if (num == 1)
+ {
+ this.btnReadData.Text = "鍚姩";
+ this.timer1.Enabled = false;
+ num = 0;
+ }
+ }
}
//鍛樺伐缂栫爜鍥炶溅
@@ -170,75 +106,49 @@
}
else
{
- int year = DateTime.Now.Year;
- string month = DateTime.Now.Month.ToString();
- string day = DateTime.Now.Day.ToString();
+ Read_Txt();
- string dataTime = DateTime.Now.ToString("yyyyMMdd");
- ////鍒ゆ柇鏄惁鏈夎繖涓枃浠�
- //bool flag = File.Exists($@"D:\{year}\{month}\{day}\{dataTime}.txt");
- bool flag = File.Exists($@"C:\Users\admin\Desktop\鏂板缓鏂囦欢澶� (2)\20231123.txt");
+ }
+ }
- if (flag)
+
+ //鏂囨湰璇诲彇鏁版嵁
+ public void Read_Txt() {
+
+ int year = DateTime.Now.Year;
+ string month = DateTime.Now.Month.ToString();
+ string day = DateTime.Now.Day.ToString();
+
+ string dataTime = DateTime.Now.ToString("yyyyMMdd");
+ ////鍒ゆ柇鏄惁鏈夎繖涓枃浠�
+ bool flag = File.Exists($@"D:\{year}\{month}\{day}\{dataTime}.txt");
+ //bool flag = File.Exists($@"C:\Users\admin\Desktop\鏂板缓鏂囦欢澶� (2)\20231123.txt");
+
+ if (flag)
+ {
+ StreamReader stream = new StreamReader($@"D:\{year}\{month}\{day}\{dataTime}.txt", Encoding.GetEncoding("gb2312"));
+ //StreamReader stream = new StreamReader($@"C:\Users\admin\Desktop\鏂板缓鏂囦欢澶� (2)\20231123.txt", Encoding.GetEncoding("gb2312"));
+
+ string FileData = stream.ReadToEnd();
+ stream.Close();
+
+ //鑾峰彇鏉＄爜淇℃伅
+ Xt_ReadText(FileData);
+
+ bool flag2 = File.Exists($@"D:\{year}\{month}\{day}\{dataTime}gy.txt");
+ //bool flag2 = File.Exists($@"C:\Users\admin\Desktop\鏂板缓鏂囦欢澶� (2)\20231123gy.txt");
+
+ if (flag2)
{
- //StreamReader stream = new StreamReader($@"D:\{year}\{month}\{day}\{dataTime}.txt", Encoding.GetEncoding("gb2312"));
- StreamReader stream = new StreamReader($@"C:\Users\admin\Desktop\鏂板缓鏂囦欢澶� (2)\20231123.txt", Encoding.GetEncoding("gb2312"));
-
- string FileData = stream.ReadToEnd();
- stream.Close();
- FileData = FileData.Substring(0, FileData.Length - 1);
- FileData = "[" + FileData + "]";
- //JSON搴忓垪鍖栬浆鎹㈠瓧鍏搁泦鍚�
- List<Dictionary<string, string>> list = new List<Dictionary<string, string>>();
- List<object> DataList = JsonConvert.DeserializeObject<List<object>>(FileData);
- foreach (JObject item in DataList)
- {
- Dictionary<string, string> dic = new Dictionary<string, string>();
- foreach (var itm in item.Properties())
- {
- dic.Add(itm.Name, itm.Value.ToString());
- }
- list.Add(dic);
- }
- //鑾峰彇褰撳墠鏃堕棿
- DateTime ActionTime = DateTime.Parse(DateTime.Now.AddMinutes(-1).ToString("yyyy-MM-dd HH:mm:ss"));
- DateTime EndTime = DateTime.Parse(DateTime.Now.AddMinutes(1).ToString("yyyy-MM-dd HH:mm:00"));
- //寰幆闆嗗悎
- for (int i = 0; i < list.Count; i++)
- {
- DateTime NowTime = DateTime.Parse(list[i]["HDate"].ToString());
- if (NowTime >= ActionTime && NowTime < EndTime)
- {
- string HSourceCode = list[i]["HSouceNumber"].ToString();
- string HEmpCode = this.HEmpCode.Text;
- //string HEmpCode = "";
- string HType = list[i]["HBadReason"].ToString();
- string HBarCode = list[i]["HBadCodeSN"].ToString();
- int HCount = 1;
- string HCreateTime = list[i]["HDate"].ToString();
- string HDate = DateTime.Parse(list[i]["HDate"].ToString()).ToString("yyyy-MM-dd");
- string HResult = list[i]["HResult"].ToString();
- string HProcNumber = list[i]["HProcNumber"].ToString();
- int HFlag = 0;
-
- DataSet ds = oCN.RunProcReturn(@"select * from Sb_EquipMentCollection_SN where HBarCode='" + HBarCode + "' and HCreateTime='" + HCreateTime + "'", "Sb_EquipMentCollection_SN");
-
- if (ds.Tables[0].Rows.Count == 0)
- {
- string sql = $@"insert into Sb_EquipMentCollection_SN(HSourceCode,HEmpCode,HType,HBarCode,HCount,HCreateTime,HDate,HResult,HProcNumber,HFlag)
-values('{HSourceCode}','{HEmpCode}','{HType}','{HBarCode}','{HCount}','{HCreateTime}','{HDate}','{HResult}','{HProcNumber}','{HFlag}')";
- oCN.RunProc(sql);
- ListSelect.Items.Add("鏉＄爜:" + HBarCode + ",鏃ユ湡:" + HCreateTime + ",缁撴灉:" + HResult);
- }
- }
- else
- {
- //CustomWriteLog("鏃堕棿涓嶅湪淇濆瓨鑼冨洿鍐�", DateTime.Now.ToString("yyyy-MM-dd"));
- }
- }
+ stream = new StreamReader($@"D:\{year}\{month}\{day}\{dataTime}gy.txt", Encoding.GetEncoding("gb2312"));
+ //stream = new StreamReader($@"C:\Users\admin\Desktop\鏂板缓鏂囦欢澶� (2)\20231123gy.txt", Encoding.GetEncoding("gb2312"));
+ FileData = stream.ReadToEnd();
+ //鑾峰彇绯荤粺鍙傛暟
+ Xt_Gy_RoutBill(FileData);
}
}
}
+
//鐢熶骇璧勬簮鍥炶溅
private void HSouce_KeyDown(object sender, KeyEventArgs e)
@@ -273,5 +183,128 @@
MessageBox.Show(this, e.Message, "鎻愮ず");
}
}
+
+ public void Xt_ReadText(string FileData)
+ {
+ FileData = FileData.Substring(0, FileData.Length - 1);
+ FileData = "[" + FileData + "]";
+ //JSON搴忓垪鍖栬浆鎹㈠瓧鍏搁泦鍚�
+ List<Dictionary<string, string>> list = new List<Dictionary<string, string>>();
+ List<object> DataList = JsonConvert.DeserializeObject<List<object>>(FileData);
+ foreach (JObject item in DataList)
+ {
+ Dictionary<string, string> dic = new Dictionary<string, string>();
+ foreach (var itm in item.Properties())
+ {
+ dic.Add(itm.Name, itm.Value.ToString());
+ }
+ list.Add(dic);
+ }
+ //鑾峰彇褰撳墠鏃堕棿
+ DateTime ActionTime = DateTime.Parse(DateTime.Now.AddMinutes(-1).ToString("yyyy-MM-dd HH:mm:ss"));
+ DateTime EndTime = DateTime.Parse(DateTime.Now.AddMinutes(1).ToString("yyyy-MM-dd HH:mm:00"));
+
+ //寰幆闆嗗悎
+ for (int i = 0; i < list.Count; i++)
+ {
+ DateTime NowTime = DateTime.Parse(list[i]["HDate"].ToString());
+ if (NowTime >= ActionTime && NowTime < EndTime && list[i]["HBadCodeSN"].ToString() != "")
+ {
+ string HSourceCode = list[i]["HSouceNumber"].ToString();
+ string HEmpCode = this.HEmpCode.Text;
+ //string HEmpCode = "";
+ string HType = list[i]["HBadReason"].ToString();
+ string HBarCode = list[i]["HBadCodeSN"].ToString();
+ int HCount = 1;
+ string HCreateTime = list[i]["HDate"].ToString();
+ string HDate = DateTime.Parse(list[i]["HDate"].ToString()).ToString("yyyy-MM-dd");
+ string HResult = list[i]["HResult"].ToString();
+ string HProcNumber = list[i]["HProcNumber"].ToString();
+ int HFlag = 0;
+
+ DataSet ds = oCN.RunProcReturn(@"select * from Sb_EquipMentCollection_SN where HBarCode='" + HBarCode + "' and HCreateTime='" + HCreateTime + "'", "Sb_EquipMentCollection_SN");
+
+ if (ds.Tables[0].Rows.Count == 0)
+ {
+ string sql = $@"insert into Sb_EquipMentCollection_SN(HSourceCode,HEmpCode,HType,HBarCode,HCount,HCreateTime,HDate,HResult,HProcNumber,HFlag)
+values('{HSourceCode}','{HEmpCode}','{HType}','{HBarCode}','{HCount}','{HCreateTime}','{HDate}','{HResult}','{HProcNumber}','{HFlag}')";
+ oCN.RunProc(sql);
+ ListSelect.Items.Add("鏉＄爜:" + HBarCode + ",鏃ユ湡:" + HCreateTime + ",缁撴灉:" + HResult);
+ }
+ }
+ else
+ {
+ //CustomWriteLog("鏃堕棿涓嶅湪淇濆瓨鑼冨洿鍐�", DateTime.Now.ToString("yyyy-MM-dd"));
+ }
+ }
+ }
+
+ //璇诲彇绯荤粺鍙傛暟
+ public void Xt_Gy_RoutBill(string FileData)
+ {
+ FileData = FileData.Substring(0, FileData.Length - 1);
+ FileData = "[" + FileData + "]";
+ //JSON搴忓垪鍖栬浆鎹㈠瓧鍏搁泦鍚�
+ List<Dictionary<string, string>> list = new List<Dictionary<string, string>>();
+ List<object> DataList = JsonConvert.DeserializeObject<List<object>>(FileData);
+ foreach (JObject item in DataList)
+ {
+ Dictionary<string, string> dic = new Dictionary<string, string>();
+ foreach (var itm in item.Properties())
+ {
+ dic.Add(itm.Name, itm.Value.ToString());
+ }
+ list.Add(dic);
+ }
+ //鑾峰彇褰撳墠鏃堕棿
+ DateTime ActionTime = DateTime.Parse(DateTime.Now.AddMinutes(-1).ToString("yyyy-MM-dd HH:mm:ss"));
+ DateTime EndTime = DateTime.Parse(DateTime.Now.AddMinutes(1).ToString("yyyy-MM-dd HH:mm:00"));
+ //寰幆闆嗗悎
+ for (int i = 0; i < list.Count; i++)
+ {
+ DateTime NowTime = DateTime.Parse(list[i]["HDate"].ToString());
+ if (NowTime >= ActionTime && NowTime < EndTime)
+ {
+ string HSourceCode = list[i]["HSouceNumber"].ToString();
+ string HEmpCode = this.HEmpCode.Text;
+ //string HEmpCode = "";
+ string HType = list[i]["HType"].ToString();
+ string HBarCode = list[i]["HBadCodeSN"].ToString();
+ double HCount = double.Parse(list[i]["HCount"].ToString());
+ string HCreateTime = list[i]["HDate"].ToString();
+ string HDate = DateTime.Parse(list[i]["HDate"].ToString()).ToString("yyyy-MM-dd");
+ string HResult = list[i]["HResult"].ToString();
+ string HProcNumber = list[i]["HProcNumber"].ToString();
+ int HFlag = 0;
+
+ DataSet ds = oCN.RunProcReturn(@"select * from Sb_EquipMentCollectionTechParam_SN where HBarCode='" + HBarCode + "' and HCreateTime='" + HCreateTime + "'", "Sb_EquipMentCollectionTechParam_SN");
+
+ if (ds.Tables[0].Rows.Count == 0)
+ {
+ string sql = $@"insert into Sb_EquipMentCollectionTechParam_SN(HSourceCode,HEmpCode,HType,HBarCode,HCount,HCreateTime,HDate,HResult,HProcNumber,HFlag)
+values('{HSourceCode}','{HEmpCode}','{HType}','{HBarCode}','{HCount}','{HCreateTime}','{HDate}','{HResult}','{HProcNumber}','{HFlag}')";
+ oCN.RunProc(sql);
+ //ListSelect.Items.Add("鏉＄爜:" + HBarCode + ",鏃ユ湡:" + HCreateTime + ",缁撴灉:" + HResult);
+ }
+ }
+ else
+ {
+ //CustomWriteLog("鏃堕棿涓嶅湪淇濆瓨鑼冨洿鍐�", DateTime.Now.ToString("yyyy-MM-dd"));
+ }
+ }
+
+ }
+
+ private void ReadyDataForm_FormClosing(object sender, FormClosingEventArgs e)
+ {
+ if (num == 1) {
+ MessageBox.Show("褰撳墠鎸夐挳鏈殏鍋�,涓嶅厑璁稿叧闂�!");
+ e.Cancel = true;
+ }
+ else if (MessageBox.Show("纭畾瑕佸叧闂悧锛�", "纭", MessageBoxButtons.YesNo) == DialogResult.No)
+ {
+ e.Cancel = true;
+ }
+ }
}
}
--
Gitblit v1.9.1