/// <summary>
/// This method is called when the Performance test is started
/// </summary>
/// <param name="_uutData"></param>
/// <param name="_commonData"></param>
public void UserSetups(ref UUTData _uutData, ref CommonData _commonData)
{
try
{
if (_uutData == null)
{
_uutData = this.g_UUTData;
}
if (_commonData == null)
{
_commonData = this.g_CommonData;
}
// Initialize Test Equipments
mySw = new DirectIO("GPIB0::9::INSTR"); mySw.Timeout = 10000;
myScope = new DirectIO("GPIB0::7::INSTR"); myScope.Timeout = 10000;
//myScope = new DirectIO("USB0::2391::6056::MY53280249::0::INSTR"); myScope.Timeout = 10000;
//ResourceManager rmc = new ResourceManager();
//var rs = rmc.FindRsrc("USB?*");
//foreach (var item in rs)
//{
// Trace.WriteLine(item);
//}
string comPort = CalLeakConfigs.Default.ComPort;
myLD = new VSLeakDetector(comPort, 9600, System.IO.Ports.Parity.None, 8, System.IO.Ports.StopBits.One);
myLD.UnlockFullCommand();
myLD.NoSniff(); // Set the LD HighPressure test to OFF
InstrumentIO.SetupBoardTempMeasRoute(mySw, myScope, TestPort);
// Initialize list
ListOfUUTLeakRate = new List <double>();
ListOfUUTTempFactor = new List <double>();
ListOfUUTTemp = new List <double>();
// Initialize CalLeakData
myCalLeakData = new CalLeakData();
myCalLeakData.PartNumber = _uutData.Model;
myCalLeakData.SerialNumber = _uutData.SerNum;
myCalLeakData.TestPortId = Convert.ToInt32(_commonData.Slot);
}
catch (Exception)
{
throw;
}
}
internal static object SubmitFinalCalLeakData(SqlConnection conn, ref CalLeakData myCalLeakData)
{
try
{
string cmdText = "INSERT INTO [VpdOF].[dbo].[CalLeakData] (PartNumber,SerialNumber,TestPort,LeakRate,UUTTemp,BoardTemp,Factor" +
",TestDate,TestedBy,NISTSerialNumber,NISTDescription,NISTPartNumber,NISTReportNumber" +
",NISTCalDate,NISTCalDueDate,StationSerialNumber,StationDescription" +
",StationModelNumber,StationReportNumber,StationCalDate,StationCalDueDate,IsPass) " +
"VALUES (@PartNumber,@SerialNumber,@TestPort,@LeakRate,@UUTTemp,@BoardTemp,@Factor" +
",@TestDate,@TestedBy,@NISTSerialNumber,@NISTDescription,@NISTPartNumber,@NISTReportNumber" +
",@NISTCalDate,@NISTCalDueDate,@StationSerialNumber,@StationDescription" +
",@StationModelNumber,@StationReportNumber,@StationCalDate,@StationCalDueDate,@IsPass);" +
"SELECT SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(cmdText, conn);
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PartNumber", myCalLeakData.PartNumber);
cmd.Parameters.AddWithValue("@SerialNumber", myCalLeakData.SerialNumber);
cmd.Parameters.AddWithValue("@TestPort", myCalLeakData.TestPortId);
cmd.Parameters.AddWithValue("@LeakRate", myCalLeakData.LeakRate);
cmd.Parameters.AddWithValue("@UUTTemp", myCalLeakData.UUTTemp);
cmd.Parameters.AddWithValue("@BoardTemp", myCalLeakData.BoardTemp);
cmd.Parameters.AddWithValue("@Factor", myCalLeakData.Factor);
cmd.Parameters.Add(new SqlParameter("@TestDate", System.Data.SqlDbType.DateTime));
cmd.Parameters["@TestDate"].Value = myCalLeakData.TestDate;
cmd.Parameters.AddWithValue("@TestedBy", myCalLeakData.TestedBy);
cmd.Parameters.AddWithValue("@NISTSerialNumber", myCalLeakData.NISTSerialNumber);
cmd.Parameters.AddWithValue("@NISTDescription", myCalLeakData.NISTDescription);
cmd.Parameters.AddWithValue("@NISTPartNumber", myCalLeakData.NISTPartNumber);
cmd.Parameters.AddWithValue("@NISTReportNumber", myCalLeakData.NISTReportNumber);
cmd.Parameters.Add(new SqlParameter("@NISTCalDate", System.Data.SqlDbType.DateTime));
cmd.Parameters["@NISTCalDate"].Value = myCalLeakData.NISTCalDate;
cmd.Parameters.Add(new SqlParameter("@NISTCalDueDate", System.Data.SqlDbType.DateTime));
cmd.Parameters["@NISTCalDueDate"].Value = myCalLeakData.NISTCalDueDate;
cmd.Parameters.AddWithValue("@StationSerialNumber", myCalLeakData.StationSerialNumber);
cmd.Parameters.AddWithValue("@StationDescription", myCalLeakData.StationDescription);
cmd.Parameters.AddWithValue("@StationModelNumber", myCalLeakData.StationModelNumber);
cmd.Parameters.AddWithValue("@StationReportNumber", myCalLeakData.StationReportNumber);
cmd.Parameters.Add(new SqlParameter("@StationCalDate", System.Data.SqlDbType.DateTime));
cmd.Parameters["@StationCalDate"].Value = myCalLeakData.StationCalDate;
cmd.Parameters.Add(new SqlParameter("@StationCalDueDate", System.Data.SqlDbType.DateTime));
cmd.Parameters["@StationCalDueDate"].Value = myCalLeakData.StationCalDueDate;
cmd.Parameters.AddWithValue("@IsPass", myCalLeakData.IsPass);
return(cmd.ExecuteScalar());
}
catch (Exception)
{
throw;
}
}
