/// <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; } }