From 65803a6e5864ea62822f08be2a6ebf3a1af00b3a Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期五, 01 十二月 2023 15:29:01 +0800
Subject: [PATCH] 1
---
WFormSynchronizeData_SMR/WFormReadData_SMR/ReadyDataForm.cs | 199 +++++++++++++++++++++++++++++++------------------
1 files changed, 126 insertions(+), 73 deletions(-)
diff --git a/WFormSynchronizeData_SMR/WFormReadData_SMR/ReadyDataForm.cs b/WFormSynchronizeData_SMR/WFormReadData_SMR/ReadyDataForm.cs
index 7ce3e9f..4f91b32 100644
--- a/WFormSynchronizeData_SMR/WFormReadData_SMR/ReadyDataForm.cs
+++ b/WFormSynchronizeData_SMR/WFormReadData_SMR/ReadyDataForm.cs
@@ -20,87 +20,101 @@
{
InitializeComponent();
}
+ public static int num = 0;
//璇诲彇鏁版嵁
private void btnReadData_Click(object sender, EventArgs e)
{
- if (this.HEmpCode.Text == "") {
-
- MessageBox.Show("璇疯緭鍏ュ憳宸ョ紪鐮�");
- }
- else
+ if (num == 0) {
+ this.btnReadData.Text = "鏆傚仠";
+ this.timer1.Enabled = true;
+ num = 1;
+ }else if (num == 1)
{
- 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"));
- }
- }
- }
+ this.btnReadData.Text = "鍚姩";
+ this.timer1.Enabled = false;
+ num = 0;
}
+
+
+
+// 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"));
+// }
+// }
+// }
+// }
}
- //杈撳叆鍛樺伐缂栫爜
+ //鍛樺伐缂栫爜鍥炶溅
private void HEmpCode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter) {
@@ -140,6 +154,11 @@
this.HEmpCode.Focus();
this.HEmpCode.Text = "";
this.HEmpCodeName.Text = "";
+
+ this.HSouce.ReadOnly = false;
+ this.HSouce.Focus();
+ this.HSouce.Text = "";
+ this.HSouceName.Text = "";
}
private void timer1_Tick(object sender, EventArgs e)
@@ -220,5 +239,39 @@
}
}
}
+
+ //鐢熶骇璧勬簮鍥炶溅
+ private void HSouce_KeyDown(object sender, KeyEventArgs e)
+ {
+ if (e.KeyCode == Keys.Enter)
+ {
+ SelectHSouc(this.HSouce.Text);
+ }
+ }
+
+ //鏌ヨ鐢熶骇璧勬簮
+ public void SelectHSouc(string HNumber)
+ {
+ try
+ {
+ DataSet ds = oCN.RunProcReturn("select * from Gy_Source where HNumber='" + HNumber + "' ", "Gy_Source");
+ if (ds.Tables[0].Rows.Count == 0)
+ {
+ MessageBox.Show("鏌ユ棤鏁版嵁!");
+ }
+ else
+ {
+ string HSouceName = ds.Tables[0].Rows[0]["HName"].ToString();
+ string HSouceNumber = ds.Tables[0].Rows[0]["HNumber"].ToString();
+ this.HSouceName.Text = HSouceName;
+ this.HSouce.Text = HSouceNumber;
+ this.HSouce.ReadOnly = true;
+ }
+ }
+ catch (Exception e)
+ {
+ MessageBox.Show(this, e.Message, "鎻愮ず");
+ }
+ }
}
}
--
Gitblit v1.9.1