修改斯莫尔接口采集账户密码

zrg

2025-11-12 0a3000811b5d67ca94339af621e1f2ca176763a8

 WFormSynchronizeData_SMR/WFormReadData_SMR/JZ_ReadDate.cs

@@ -21,7 +21,7 @@
        {
            InitializeComponent();
        }

        //铁芯检测excel读取工艺参数
        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 + "'" +