private void LoadTestSpec(object sender, EventArgs e) { TestDataCommon = new CTestDataCommon(); TestSpec = new CTestSpec(); this.lstViewTestData.Items.Clear(); this.lstViewLog.Items.Clear(); TestDataCommon.lstTestData.Clear(); if (this.cbxPN.SelectedIndex != -1) { PN = this.cbxPN.SelectedItem.ToString(); TestSpec = db.GetTestSpec(PN); TestDataCommon.Spec_id = TestSpec.ID; ReadTestPlan(PN); } }
public CTestSpec GetTestSpec(string pn) { CTestSpec testSpec = new CTestSpec(); testSpec.PN = pn; try { string sql = string.Format($"select * from dbo.spec_tx_rftest_pam4 where pn='{pn}'and id=(select Max(id) from dbo.spec_tx_rftest_pam4 where pn='{pn}')"); DataSet ds = ReadRawSQL(sql); DataTable dt = ds.Tables[0]; if (ds.Tables != null && ds.Tables.Count == 1) { DataRow row = dt.Rows[0]; testSpec.ID = Convert.ToInt32(row["id"]); testSpec.CWL_Min = Convert.ToDouble(row["cwl_min"]); testSpec.CWL_Max = Convert.ToDouble(row["cwl_max"]); testSpec.SMSR_Min = Convert.ToDouble(row["smsr_min"]); testSpec.SMSR_Max = Convert.ToDouble(row["smsr_max"]); testSpec.TDECQ_Min = Convert.ToDouble(row["tdecq_min"]); testSpec.TDECQ_Max = Convert.ToDouble(row["tdecq_max"]); testSpec.Outer_OMA_Min = Convert.ToDouble(row["outer_oma_min"]); testSpec.Outer_OMA_Max = Convert.ToDouble(row["outer_oma_max"]); testSpec.Outer_ER_Min = Convert.ToDouble(row["outer_er_min"]); testSpec.Outer_ER_Max = Convert.ToDouble(row["outer_er_max"]); testSpec.Lanch_Power_Min = Convert.ToDouble(row["lanch_power_min"]); testSpec.Lanch_Power_Max = Convert.ToDouble(row["lanch_power_max"]); testSpec.Linearity_Min = Convert.ToDouble(row["linearity_min"]); testSpec.Linearity_Max = Convert.ToDouble(row["linearity_max"]); } return(testSpec); } catch (Exception ex) { throw new Exception($"Fail to get spec for pn{pn}, {ex.Message}"); } finally { conn.Close(); } }