コード例 #1
0
 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);
     }
 }
コード例 #2
0
        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();
            }
        }