public DUT_Str read(string path) { string temp; DUT_Str dut = new DUT_Str(); dut.RawCountX = new List<string>(); dut.NoiseX = new List<string>(); dut.StdDevX = new List<string>(); dut.RawCountY = new List<string>(); dut.NoiseY = new List<string>(); dut.StdDevY = new List<string>(); dut.IDAC = new List<string>(); dut.IDACGain = new List<string>(); dut.Global_IDAC = new List<string>(); dut.Local_IDAC = new List<string>(); dut.SignalX = new List<string>(); dut.SNRX = new List<string>(); XmlTextReader reader; try { reader = new XmlTextReader(path); reader.MoveToContent(); reader.ReadStartElement("Trackpad"); reader.ReadStartElement("Serial_Number"); temp = reader.ReadString(); dut.SerailNumber = temp; dut.PartType = temp.Substring(0, 8); //Console.WriteLine("The Serial_Number is: {0}", temp); reader.ReadEndElement(); reader.ReadStartElement("Test_Station"); temp = reader.ReadString(); dut.TestStation = temp; //Console.WriteLine("The Test_Station is: {0}", temp); reader.ReadEndElement(); reader.ReadStartElement("Error_Code"); temp = reader.ReadString(); dut.ErrorCode = temp; //Console.WriteLine("The Error_Code is: {0}", temp); reader.ReadEndElement(); reader.ReadStartElement("Test_Time"); temp = reader.ReadString().Substring(0, 19); dut.TestTime = temp; //Console.WriteLine("The Test_Time is: {0}", temp); reader.ReadEndElement(); reader.ReadStartElement("IDD_Value"); temp = reader.ReadString(); dut.IDDValue = temp; //Console.WriteLine("The IDD_Value is: {0}", temp); reader.ReadEndElement(); reader.ReadStartElement("Firmware_Revision"); temp = reader.ReadString(); dut.FwRev = temp; //Console.WriteLine("The Firmware_Revision is: {0}", temp); reader.ReadEndElement(); //reader.ReadStartElement("IDD_Sleep1_Value"); //temp = reader.ReadString(); //dut.IDDValueSleep1 = temp; ////Console.WriteLine("The IDD_Value is: {0}", temp); //reader.ReadEndElement(); //reader.ReadStartElement("IDD_Deep_Sleep_Value"); //temp = reader.ReadString(); //dut.IDDValueDeepSleep = temp; ////Console.WriteLine("The Firmware_Revision is: {0}", temp); //reader.ReadEndElement(); reader.ReadStartElement("Raw_Count_Averages"); int i = 1; while (reader.ReadToNextSibling("D" + i.ToString())) { temp = reader.ReadString(); dut.RawCountX.Add(temp); //Console.WriteLine("Raw_Count_Averages" + i.ToString() + ": {0}", temp); i++; } reader.ReadEndElement(); reader.ReadStartElement("Raw_Count_Noise"); i = 1; while (reader.ReadToNextSibling("D" + i.ToString())) { temp = reader.ReadString(); dut.NoiseX.Add(temp); //Console.WriteLine("Raw_Count_Noise" + i.ToString() + ": {0}", temp); i++; } reader.ReadEndElement(); reader.ReadStartElement("IDAC_Value"); i = 1; while (reader.ReadToNextSibling("D" + i.ToString())) { temp = reader.ReadString(); dut.IDAC.Add(temp); //Console.WriteLine("IDAC_Value" + i.ToString() + ": {0}", temp); i++; } reader.ReadEndElement(); reader.ReadStartElement("IDAC_Gain_Value"); i = 1; while (reader.ReadToNextSibling("D" + i.ToString())) { temp = reader.ReadString(); dut.IDACGain.Add(temp); //Console.WriteLine("IDAC_Value" + i.ToString() + ": {0}", temp); i++; } reader.ReadEndElement(); reader.ReadStartElement("Local_IDAC_Value"); i = 1; while (reader.ReadToNextSibling("D" + i.ToString())) { temp = reader.ReadString(); dut.Local_IDAC.Add(temp); //Console.WriteLine("IDAC_Value" + i.ToString() + ": {0}", temp); i++; } reader.ReadEndElement(); reader.ReadStartElement("Signal_Data"); i = 1; while (reader.ReadToNextSibling("D" + i.ToString())) { temp = reader.ReadString(); dut.SignalX.Add(temp); //Console.WriteLine("IDAC_Value" + i.ToString() + ": {0}", temp); i++; } reader.ReadEndElement(); reader.ReadStartElement("SNR_Data"); i = 1; while (reader.ReadToNextSibling("D" + i.ToString())) { temp = reader.ReadString(); dut.SNRX.Add(temp); //Console.WriteLine("IDAC_Value" + i.ToString() + ": {0}", temp); i++; } reader.ReadEndElement(); reader.ReadEndElement(); reader.Close(); } catch { } return dut; }
public bool insert_into_table(DUT_Str dut) { try { MySql.Data.MySqlClient.MySqlDataReader myData; string dut_id = "0"; //get dut_id from serial_number and test_time. bool dataExist = false; cmd.CommandText = string.Format("SELECT Id FROM dut WHERE SerialNumber='{0}' AND TestTime='{1}'", dut.SerailNumber, dut.TestTime); myData = cmd.ExecuteReader(); while (myData.Read()) { //Trace.WriteLine("DUT ID: ", myData[0].ToString()); dut_id = myData[0].ToString(); dataExist = true; } myData.Close(); if (dataExist) { LastError = "DUT already exists"; return false; } //foreach (string rawCount in dut.RawCountX) //{ // string SQL_insert_query = string.Format("INSERT INTO rawcountaverage (DUTID, ValueIndex, RawCountAverage) VALUES ({0},{1},{2})", dut_id, index, rawCount); // index++; // cmd.CommandText = SQL_insert_query; // cmd.ExecuteNonQuery(); //} //index = 1; //foreach (string noise in dut.NoiseX) //{ // string SQL_insert_query = string.Format("INSERT INTO rawcountnoise (DUTID, ValueIndex, RawCountNoise) VALUES ({0},{1},{2})", dut_id, index, noise); // index++; // cmd.CommandText = SQL_insert_query; // cmd.ExecuteNonQuery(); //} //index = 1; //foreach (string idac in dut.IDAC) //{ // string SQL_insert_query = string.Format("INSERT INTO idacvalue (DUTID, ValueIndex, IDACValue) VALUES ({0},{1},{2})", dut_id, index, idac); // index++; // cmd.CommandText = SQL_insert_query; // cmd.ExecuteNonQuery(); //} //insert into dut table. string SQL_insert_query_dut = "INSERT INTO dut (SerialNumber,TestStation,PartType,ErrorCode,IDDValue,FirmwareVersion,TestTime) "; SQL_insert_query_dut += "VALUES ('" + dut.SerailNumber + "'," + "'" + dut.TestStation + "'," + "'" + dut.PartType + "'," + dut.ErrorCode + "," + dut.IDDValue + "," + dut.FwRev + ",'" + dut.TestTime + "')"; cmd.CommandText = SQL_insert_query_dut; cmd.ExecuteNonQuery(); //get DUTid from current record cmd.CommandText = string.Format("SELECT Id FROM dut WHERE SerialNumber='{0}' AND TestTime='{1}'", dut.SerailNumber, dut.TestTime); myData = cmd.ExecuteReader(); while (myData.Read()) { //Trace.WriteLine("DUT ID: ", myData[0].ToString()); dut_id = myData[0].ToString(); } myData.Close(); int index; //insert RawCount Value if (dut.RawCountX.Capacity > 0) { index = 1; string SQL_insert_query_rawcount = "INSERT INTO rawcountaverage (DUTID, ValueIndex, RawCountAverage) VALUES "; foreach (string rawcount in dut.RawCountX) { SQL_insert_query_rawcount += "(" + dut_id + "," + index.ToString() + "," + rawcount + "),"; index++; } SQL_insert_query_rawcount = SQL_insert_query_rawcount.Substring(0, SQL_insert_query_rawcount.Length - 1); SQL_insert_query_rawcount += ";"; //Trace.WriteLine(SQL_insert_query_rawcount); cmd.CommandText = SQL_insert_query_rawcount; cmd.ExecuteNonQuery(); } //insert Noise Value if (dut.NoiseX.Capacity > 0) { index = 1; string SQL_insert_query_noise = "INSERT INTO rawcountnoise (DUTID, ValueIndex, RawCountNoise) VALUES "; foreach (string noise in dut.NoiseX) { SQL_insert_query_noise += "(" + dut_id + "," + index.ToString() + "," + noise + "),"; index++; } SQL_insert_query_noise = SQL_insert_query_noise.Substring(0, SQL_insert_query_noise.Length - 1); SQL_insert_query_noise += ";"; //Trace.WriteLine(SQL_insert_query_noise); cmd.CommandText = SQL_insert_query_noise; cmd.ExecuteNonQuery(); } //insert IDAC Value if (dut.IDAC.Capacity > 0) { index = 1; string SQL_insert_query_idac = "INSERT INTO idacvalue (DUTID, ValueIndex, IDACValue) VALUES "; foreach (string idac in dut.IDAC) { SQL_insert_query_idac += "(" + dut_id + "," + index.ToString() + "," + idac + "),"; index++; } SQL_insert_query_idac = SQL_insert_query_idac.Substring(0, SQL_insert_query_idac.Length - 1); SQL_insert_query_idac += ";"; //Trace.WriteLine(SQL_insert_query_idac); cmd.CommandText = SQL_insert_query_idac; cmd.ExecuteNonQuery(); } return true; } catch (Exception ex) { LastError = ex.Message; Trace.WriteLine(ex.Message); return false; } }
public DUT_Str read(string path) { string temp; DUT_Str dut = new DUT_Str(); dut.RawCountX = new List <string>(); dut.NoiseX = new List <string>(); dut.StdDevX = new List <string>(); dut.RawCountY = new List <string>(); dut.NoiseY = new List <string>(); dut.StdDevY = new List <string>(); dut.IDAC = new List <string>(); dut.IDACGain = new List <string>(); dut.Global_IDAC = new List <string>(); dut.Local_IDAC = new List <string>(); dut.SignalX = new List <string>(); dut.SNRX = new List <string>(); XmlTextReader reader; try { reader = new XmlTextReader(path); reader.MoveToContent(); reader.ReadStartElement("Trackpad"); reader.ReadStartElement("Serial_Number"); temp = reader.ReadString(); dut.SerailNumber = temp; dut.PartType = temp.Substring(0, 8); //Console.WriteLine("The Serial_Number is: {0}", temp); reader.ReadEndElement(); reader.ReadStartElement("Test_Station"); temp = reader.ReadString(); dut.TestStation = temp; //Console.WriteLine("The Test_Station is: {0}", temp); reader.ReadEndElement(); reader.ReadStartElement("Error_Code"); temp = reader.ReadString(); dut.ErrorCode = temp; //Console.WriteLine("The Error_Code is: {0}", temp); reader.ReadEndElement(); reader.ReadStartElement("Test_Time"); temp = reader.ReadString().Substring(0, 19); dut.TestTime = temp; //Console.WriteLine("The Test_Time is: {0}", temp); reader.ReadEndElement(); reader.ReadStartElement("IDD_Value"); temp = reader.ReadString(); dut.IDDValue = temp; //Console.WriteLine("The IDD_Value is: {0}", temp); reader.ReadEndElement(); reader.ReadStartElement("Firmware_Revision"); temp = reader.ReadString(); dut.FwRev = temp; //Console.WriteLine("The Firmware_Revision is: {0}", temp); reader.ReadEndElement(); //reader.ReadStartElement("IDD_Sleep1_Value"); //temp = reader.ReadString(); //dut.IDDValueSleep1 = temp; ////Console.WriteLine("The IDD_Value is: {0}", temp); //reader.ReadEndElement(); //reader.ReadStartElement("IDD_Deep_Sleep_Value"); //temp = reader.ReadString(); //dut.IDDValueDeepSleep = temp; ////Console.WriteLine("The Firmware_Revision is: {0}", temp); //reader.ReadEndElement(); reader.ReadStartElement("Raw_Count_Averages"); int i = 1; while (reader.ReadToNextSibling("D" + i.ToString())) { temp = reader.ReadString(); dut.RawCountX.Add(temp); //Console.WriteLine("Raw_Count_Averages" + i.ToString() + ": {0}", temp); i++; } reader.ReadEndElement(); reader.ReadStartElement("Raw_Count_Noise"); i = 1; while (reader.ReadToNextSibling("D" + i.ToString())) { temp = reader.ReadString(); dut.NoiseX.Add(temp); //Console.WriteLine("Raw_Count_Noise" + i.ToString() + ": {0}", temp); i++; } reader.ReadEndElement(); reader.ReadStartElement("IDAC_Value"); i = 1; while (reader.ReadToNextSibling("D" + i.ToString())) { temp = reader.ReadString(); dut.IDAC.Add(temp); //Console.WriteLine("IDAC_Value" + i.ToString() + ": {0}", temp); i++; } reader.ReadEndElement(); reader.ReadStartElement("IDAC_Gain_Value"); i = 1; while (reader.ReadToNextSibling("D" + i.ToString())) { temp = reader.ReadString(); dut.IDACGain.Add(temp); //Console.WriteLine("IDAC_Value" + i.ToString() + ": {0}", temp); i++; } reader.ReadEndElement(); reader.ReadStartElement("Local_IDAC_Value"); i = 1; while (reader.ReadToNextSibling("D" + i.ToString())) { temp = reader.ReadString(); dut.Local_IDAC.Add(temp); //Console.WriteLine("IDAC_Value" + i.ToString() + ": {0}", temp); i++; } reader.ReadEndElement(); reader.ReadStartElement("Signal_Data"); i = 1; while (reader.ReadToNextSibling("D" + i.ToString())) { temp = reader.ReadString(); dut.SignalX.Add(temp); //Console.WriteLine("IDAC_Value" + i.ToString() + ": {0}", temp); i++; } reader.ReadEndElement(); reader.ReadStartElement("SNR_Data"); i = 1; while (reader.ReadToNextSibling("D" + i.ToString())) { temp = reader.ReadString(); dut.SNRX.Add(temp); //Console.WriteLine("IDAC_Value" + i.ToString() + ": {0}", temp); i++; } reader.ReadEndElement(); reader.ReadEndElement(); reader.Close(); } catch { } return(dut); }