| | |
|---|
| | | dataTable.Columns.Clear(); |
|---|
| | | dataTable.Rows.Clear(); |
|---|
| | | |
|---|
| | | //把获取的数据 进行数据整理 单位不一样的进行换算 |
|---|
| | | for (int i = 0; i < ds.Tables.Count; i++) |
|---|
| | | { |
|---|
| | | DataTable dt = ds.Tables[i]; |
|---|
| | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | //存储数据到 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++) |
|---|
| | | { |
|---|
| | |
|---|
| | | { |
|---|
| | | 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 + @" |
|---|
| | |
|---|
| | | //保存数据 |
|---|
| | | 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) |
|---|
| | |
|---|
| | | HInSpectResult = (HInSpectValue > HUpLimit || HDownLimit > HInSpectValue) ? 2 : 1; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | //日志 |
|---|
| | | DBHelper.CustomWriteLog("Insert into QC_ProcessCheckBillSub " + |
|---|
| | | " (HInterID,HBillNo_bak,HEntryID,HSNO,HCloseMan" + |
|---|
| | | ",HEntryCloseDate,HCloseType,HRemark,HSourceInterID" + |
|---|
