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();
}
}
