From 0a3000811b5d67ca94339af621e1f2ca176763a8 Mon Sep 17 00:00:00 2001
From: zrg <z1873@LAPTOP-EAVL132E>
Date: 星期三, 12 十一月 2025 11:31:39 +0800
Subject: [PATCH] 修改斯莫尔接口采集账户密码
---
WFormSynchronizeData_SMR/WFormReadData_SMR/JZ_ReadDate.cs | 15 ++++++++++-----
1 files changed, 10 insertions(+), 5 deletions(-)
diff --git a/WFormSynchronizeData_SMR/WFormReadData_SMR/JZ_ReadDate.cs b/WFormSynchronizeData_SMR/WFormReadData_SMR/JZ_ReadDate.cs
index c896195..94931f9 100644
--- a/WFormSynchronizeData_SMR/WFormReadData_SMR/JZ_ReadDate.cs
+++ b/WFormSynchronizeData_SMR/WFormReadData_SMR/JZ_ReadDate.cs
@@ -21,7 +21,7 @@
{
InitializeComponent();
}
-
+ //閾佽姱妫�娴媏xcel璇诲彇宸ヨ壓鍙傛暟
private void txtLzk_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
@@ -208,6 +208,7 @@
dataTable.Columns.Clear();
dataTable.Rows.Clear();
+ //鎶婅幏鍙栫殑鏁版嵁 杩涜鏁版嵁鏁寸悊 鍗曚綅涓嶄竴鏍风殑杩涜鎹㈢畻
for (int i = 0; i < ds.Tables.Count; i++)
{
DataTable dt = ds.Tables[i];
@@ -226,6 +227,7 @@
}
}
+ //瀛樺偍鏁版嵁鍒� dataTable
string[] str = { "Ls(uH)_10kHz", "Ls(uH)_100kHz", "Z(惟)_600kHz", "Ls(uH)_1MHz", "Ls(uH)_2MHz", "Z(惟)_2MHz", "Z(惟)_1MHz", "Z(惟)_10MHz", "Z(惟)_100kHz" };
for (int o = 0; o < str.Length; o++)
{
@@ -306,6 +308,7 @@
{
string HProcID = this.cmbPro.SelectedValue.ToString();
//淇敼鏄湪鍝釜璁惧涓婅繘琛岀殑鏁版嵁閲囬泦 men.HNumber CMR-E-026 LMJC 娴告笉 閾佽姱妫�娴� 璁惧
+ //鏌ヨ褰撳墠娴佽浆鍗� 褰撳墠宸ュ簭 鏈夋病鏈夊搴旂殑妫�楠屾柟妗�
DataSet dataSet = oCN.RunProcReturn(@"select b.HAnalysisMethod,b.HInspectInstruMentID,a.HInterID HQCSchemeID,b.HQCCheckItemID, ch.HNumber HQCCheckItemNumber,m.HNumber,HUpLimit,HDownLimit,HTargetVal
from Sc_ProcessExchangeBillMain pr with(nolock)
inner join Gy_QCCheckProjectMain a with(nolock) on pr.HMaterID=a.HMaterID and a.HProcID="+ HProcID + @"
@@ -318,6 +321,7 @@
//淇濆瓨鏁版嵁
if (dataSet.Tables[0].Rows.Count > 0)
{
+ //鍒ゆ柇鏁版嵁鏈夋病鏈夋淳宸�
DataSet ds = oCN.RunProcReturn(@"select staus.HSourceID,a.HICMOInterID,a.HICMOEntryID,a.HICMOBillNo,a.HPlanQty,a.HInterID HProcExchInterID,
staus.HSourceEntryID HProcExchEntryID,a.HBillNo HProcExchBillNo,a.HQty,a.HMaterID,staus.HProcID
from Sc_ProcessExchangeBillMain a with(nolock)
@@ -414,8 +418,9 @@
HInSpectResult = (HInSpectValue > HUpLimit || HDownLimit > HInSpectValue) ? 2 : 1;
}
}
+ //鏃ュ織
DBHelper.CustomWriteLog("Insert into QC_ProcessCheckBillSub " +
- " (HInterID,HBillNo_bak,HEntryID,HCloseMan" +
+ " (HInterID,HBillNo_bak,HEntryID,HSNO,HCloseMan" +
",HEntryCloseDate,HCloseType,HRemark,HSourceInterID" +
",HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
",HQCCheckClassID,HQCCheckItemID,HQCStd,HQCRelValue,HResult" +
@@ -423,7 +428,7 @@
",HRejectQty,HSampleUnRightQty,HStatus,HUnitID,HInspectVal,HTargetVal" +
",HUpLimit,HDownLimit,HUpOffSet,HDownOffSet,HKeyInspect,HAnalysisMethod,HInspectInstruMentID,HInspectResult" +
",HQCNote) values("
- + HInterID + ",'" + HBillNo + "'," + num + ",''" +
+ + HInterID + ",'" + HBillNo + "'," + num + "," + (k -10) + "''" +
",getdate(),0,''," + HProcExchInterID +
"," + HProcExchEntryID + ",'" + HProcExchBillNo + "','',0,0" +
",0," + dataSet.Tables[0].Rows[i]["HQCCheckItemID"].ToString() + ",'" + dataSet.Tables[0].Rows[i]["HTargetVal"].ToString() + "','','" + HInSpectResult + "'" +
@@ -435,7 +440,7 @@
num += 1;
oCN.RunProc("Insert into QC_ProcessCheckBillSub " +
- " (HInterID,HBillNo_bak,HEntryID,HCloseMan" +
+ " (HInterID,HBillNo_bak,HEntryID,HSNO,HCloseMan" +
",HEntryCloseDate,HCloseType,HRemark,HSourceInterID" +
",HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
",HQCCheckClassID,HQCCheckItemID,HQCStd,HQCRelValue,HResult" +
@@ -443,7 +448,7 @@
",HRejectQty,HSampleUnRightQty,HStatus,HUnitID,HInspectVal,HTargetVal" +
",HUpLimit,HDownLimit,HUpOffSet,HDownOffSet,HKeyInspect,HAnalysisMethod,HInspectInstruMentID,HInspectResult" +
",HQCNote) values("
- + HInterID + ",'" + HBillNo + "'," + num + ",''" +
+ + HInterID + ",'" + HBillNo + "'," + num + "," + (k - 10) + ",''" +
",getdate(),0,''," + HProcExchInterID +
"," + HProcExchEntryID + ",'" + HProcExchBillNo + "','',0,0" +
",0," + dataSet.Tables[0].Rows[i]["HQCCheckItemID"].ToString() + ",'" + dataSet.Tables[0].Rows[i]["HTargetVal"].ToString() + "','','" + HInSpectResult + "'" +
--
Gitblit v1.9.1