From e9046aea8de84c7b82167f4c05d82d2702203195 Mon Sep 17 00:00:00 2001
From: zrg <z1873@LAPTOP-EAVL132E>
Date: 星期三, 17 九月 2025 22:04:28 +0800
Subject: [PATCH] 数据采集优化，三坐标轮廓仪增加日志，过站增加生产质量汇报单日志
---
WFormSynchronizeData_SMR/WFormReadData_SMR/ReadCSV_New.cs | 8 +++-----
1 files changed, 3 insertions(+), 5 deletions(-)
diff --git a/WFormSynchronizeData_SMR/WFormReadData_SMR/ReadCSV_New.cs b/WFormSynchronizeData_SMR/WFormReadData_SMR/ReadCSV_New.cs
index 1318674..0924076 100644
--- a/WFormSynchronizeData_SMR/WFormReadData_SMR/ReadCSV_New.cs
+++ b/WFormSynchronizeData_SMR/WFormReadData_SMR/ReadCSV_New.cs
@@ -262,9 +262,8 @@
string HType = "";
int HCount = 1;
- //DataSet ds = oCN.RunProcReturn(@"select * from Sb_EquipMentCollection_SN where HBarCode='" + HBarCode + "' and HCreateTime='" + HCreateTime + "'", "Sb_EquipMentCollection_SN");
-
- if (true)
+ DataSet ds = oCN.RunProcReturn(@"select * from Sb_EquipMentCollection_SN with(nolock) where HBarCode='" + HBarCode + "' and HProcNumber='" + HProcNumber + "'", "Sb_EquipMentCollection_SN");
+ if (ds.Tables[0].Rows.Count == 0)
{
if (Get_AllowLoadData(HBarCode, HProcNumber, flag_1, out flag_2))
{
@@ -289,8 +288,7 @@
{
string sql1 = $@"insert into Sb_EquipMentCollectionTechParam_SN(HSourceCode,HEmpCode,HType,HBarCode,HCount,HCreateTime,HDate,HResult,HProcNumber,HFlag)
values('{HSourceCode}','{HEmpCode}','{HType}','{HBarCode}','{HCount_1}','{HCreateTime}',GETDATE(),'{HResult}','{HProcNumber}','{HFlag}')";
- oCN.RunProc(sql1);
- //ListSelect.Items.Add("鏉＄爜:" + HBarCode + ",鏃ユ湡:" + HCreateTime + ",缁撴灉:" + HResult);
+ oCN.RunProc(sql1);
}
}
}
--
Gitblit v1.9.1