/// <summary>
///
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <param name="serial"></param>
/// <returns></returns>
public static NistData GetNistData(SqlConnection conn, string model, string serial)
{
try
{
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
string cmdText = string.Format("SELECT TOP 1 * FROM [VpdOF].[dbo].[NistCalLeak] WHERE Model = '{0}' AND Serial = '{1}' order by CalibrationDate DESC", model, serial);
SqlCommand cmd = new SqlCommand(cmdText, conn);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
NistData nistData = new NistData();
rdr.Read();
nistData.Id = rdr[0] as int? ?? default(int);
nistData.Model = rdr[1].ToString();
nistData.Serial = rdr[2].ToString();
nistData.CalibrationDate = rdr[3] as DateTime? ?? default(DateTime);
nistData.CalibrationDueDate = rdr[4] as DateTime? ?? default(DateTime);
nistData.Temp15Leak = rdr[5] as double? ?? default(double);
nistData.Temp16Leak = rdr[6] as double? ?? default(double);
nistData.Temp17Leak = rdr[7] as double? ?? default(double);
nistData.Temp18Leak = rdr[8] as double? ?? default(double);
nistData.Temp19Leak = rdr[9] as double? ?? default(double);
nistData.Temp20Leak = rdr[10] as double? ?? default(double);
nistData.Temp21Leak = rdr[11] as double? ?? default(double);
nistData.Temp22Leak = rdr[12] as double? ?? default(double);
nistData.Temp23Leak = rdr[13] as double? ?? default(double);
nistData.Temp24Leak = rdr[14] as double? ?? default(double);
nistData.Temp25Leak = rdr[15] as double? ?? default(double);
nistData.Temp26Leak = rdr[16] as double? ?? default(double);
nistData.Temp27Leak = rdr[17] as double? ?? default(double);
nistData.Temp28Leak = rdr[18] as double? ?? default(double);
nistData.Temp29Leak = rdr[19] as double? ?? default(double);
nistData.Temp30Leak = rdr[20] as double? ?? default(double);
rdr.Close();
return(nistData);
}
else
{
rdr.Close();
return(null);
}
}
catch (Exception)
{
throw;
}
}
public static double GetLeakRateFromTempMap(int temperature, NistData nistData)
{
try
{
double leakRate = 0;
switch (temperature)
{
case 15: leakRate = nistData.Temp15Leak; break;
case 16: leakRate = nistData.Temp16Leak; break;
case 17: leakRate = nistData.Temp17Leak; break;
case 18: leakRate = nistData.Temp18Leak; break;
case 19: leakRate = nistData.Temp19Leak; break;
case 20: leakRate = nistData.Temp20Leak; break;
case 21: leakRate = nistData.Temp21Leak; break;
case 22: leakRate = nistData.Temp22Leak; break;
case 23: leakRate = nistData.Temp23Leak; break;
case 24: leakRate = nistData.Temp24Leak; break;
case 25: leakRate = nistData.Temp25Leak; break;
case 26: leakRate = nistData.Temp26Leak; break;
case 27: leakRate = nistData.Temp27Leak; break;
case 28: leakRate = nistData.Temp28Leak; break;
case 29: leakRate = nistData.Temp29Leak; break;
case 30: leakRate = nistData.Temp30Leak; break;
default:
break;
}
return(leakRate);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// This method is called to execute performance testing of the UUT for each test cases
/// </summary>
/// <param name="myTestInfo"></param>
/// <param name="myUUTData"></param>
/// <param name="myCommonData"></param>
/// <returns></returns>
public TestInfo DoTests(TestInfo myTestInfo, ref UUTData myUUTData, ref CommonData myCommonData)
{
try
{
if (myCommonData.IsFailureExist)
{
return(myTestInfo);
}
switch (myTestInfo.GroupLabel)
{
case "InitStation":
{
myInitStationTest.Execute(ref myTestInfo, ref myUUTData, ref myCommonData);
myNistData = myInitStationTest.myNistData; // store NIST Data
//YS Wong added to stop if fail 26 Jul 2018
if (myCommonData.IsFailureExist)
{
MessageBox.Show("Fail test", "Fail", MessageBoxButtons.OK);
myCommonData.Mode = "Abort";
}
}
break;
case "SystemCalibration1":
case "SystemCalibration2":
case "SystemCalibration3":
{
mySystemCalTest.Execute(ref myTestInfo, ref myUUTData, ref myCommonData);
if (myCommonData.IsFailureExist)
{
MessageBox.Show("Fail test", "Fail", MessageBoxButtons.OK);
myCommonData.Mode = "Abort";
}
}
break;
case "CalLeakTest1":
case "CalLeakTest2":
case "CalLeakTest3":
{
myCalLeakTest.Execute(ref myTestInfo, ref myUUTData, ref myCommonData);
if (myCommonData.IsFailureExist)
{
MessageBox.Show("Fail test", "Fail", MessageBoxButtons.OK);
myCommonData.Mode = "Abort";
}
}
break;
case "ButtonUp":
{
myButtonUpTest.Execute(ref myTestInfo, ref myUUTData, ref myCommonData, ListOfUUTLeakRate, ListOfUUTTempFactor, ListOfUUTTemp);
if (myCommonData.IsFailureExist)
{
MessageBox.Show("Fail test", "Fail", MessageBoxButtons.OK);
myCommonData.Mode = "Abort";
}
}
break;
case "SystemMaintenance":
{
mySysMaintenance.Execute(ref myTestInfo, ref myUUTData, ref myCommonData);
if (myCommonData.IsFailureExist)
{
MessageBox.Show("Fail test", "Fail", MessageBoxButtons.OK);
myCommonData.Mode = "Abort";
}
}
break;
default:
break;
}
return(myTestInfo);
}
catch (Exception)
{
throw;
}
}
