public Configuration getConfiguration(String tool, String part)
{
Configuration config = new Configuration();
using (SQLiteConnection conn = new SQLiteConnection(connString))
{
StringBuilder query = new StringBuilder();
query.Append("SELECT ");
query.Append("program,part,tool,leak1,leak2,leak3,leak4,flow1,flow2,flow3,flow4,lotsize ");
query.Append("FROM torch_settings WHERE ");
query.Append("tool = @1 and part = @2 ORDER BY program");
//MessageBox.Show(query.ToString());
using (SQLiteCommand cmd = new SQLiteCommand(query.ToString(), conn))
{
conn.Open();
SQLiteCommand command = conn.CreateCommand();
command.CommandText = query.ToString();
SQLiteParameter prm_tool = new SQLiteParameter();
prm_tool.ParameterName = "@1";
prm_tool.Value = tool;
SQLiteParameter prm_part = new SQLiteParameter();
prm_part.ParameterName = "@2";
prm_part.Value = part;
command.Parameters.Add(prm_tool);
command.Parameters.Add(prm_part);
SQLiteDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
config.program = reader[0].ToString();
config.part = reader[1].ToString();
config.tool = reader[2].ToString();
config.leak1 = reader[3].ToString();
config.leak2 = reader[4].ToString();
config.leak3 = reader[5].ToString();
config.leak4 = reader[6].ToString();
config.flow1 = reader[7].ToString();
config.flow2 = reader[8].ToString();
config.flow3 = reader[9].ToString();
config.flow4 = reader[10].ToString();
config.lotsize = reader[11].ToString();
}
}
reader.Close();
}
}
return config;
//result = s == null || s == String.Empty;
}
private void bVerify_Click(object sender, EventArgs e)
{
Configuration data = new Configuration();
data.program = tProgramNo.Text;
data.part = tPartNo.Text;
data.tool = tToolNo.Text;
data.leak1 = tLeak1.Text;
data.leak2 = tLeak2.Text;
data.leak3 = tLeak3.Text;
data.leak4 = tLeak4.Text;
data.flow1 = tFlow1.Text;
data.flow2 = tFlow2.Text;
data.flow3 = tFlow3.Text;
data.flow4 = tFlow4.Text;
data.lotsize = txtLotSize.Text;
tData.Add(data);
data_new.Add(data);
dataGridControl.EndEdit();
dataGridControl.DataSource = null;
dataGridControl.DataSource = tData;
}
private void setup()
{
List<List<String>> d = new List<List<String>>();
d = conf.get_all();
foreach (List<String> l in d)
{
Configuration data = new Configuration();
data.program = l[0];
data.part = l[1];
data.tool = l[2];
data.leak1 =l[3];
data.leak2 = l[4];
data.leak3 = l[5];
data.leak4 = l[6];
data.flow1 = l[7];
data.flow2 = l[8];
data.flow3 = l[9];
data.flow4 = l[10];
data.lotsize = l[11];
tData.Add(data);
}
dataGridControl.DataSource = null;
dataGridControl.DataSource = tData;
}
private void new_test()
{
if (current_test_number == NULL_PROG_NUMBER)
{
Configuration configuration;
while (true)
{
String tool = "";
String temp = "";
String part = "";
if (InputDialogBox.Show("Part",
"&Enter or Scan Part Number(Type 'exit' to exit, or enter Password)", ref temp) == DialogResult.OK)
{
int index = temp.IndexOf("*");
part = index >= 0 ? temp.Substring(0, index) : temp;
}
if (temp == "exit")
{
Environment.Exit(0);
} else if (temp == "configure") {
frmConfig frm = new frmConfig();
frm.ShowDialog();
}
temp = "";
if (InputDialogBox.Show("tool",
"&Enter tool (Type 'exit' in the box to exit):", ref temp) == DialogResult.OK)
{
int index = temp.IndexOf("*");
tool = index >= 0 ? temp.Substring(0, index) : temp;
}
if (temp == "exit")
{
Environment.Exit(0);
} else if (temp == "configure") {
frmConfig frm = new frmConfig();
frm.ShowDialog();
}
if (!(tool == null || tool == String.Empty) &&
!(part == null || part == String.Empty))
{
configuration = DATABASE.getConfiguration(tool, part);
if (configuration.program == null || configuration.program == String.Empty) {
MessageBox.Show("No configuration exists with those parameters. Please Scan again");
continue;
}
CURRENT_RUNNING_CONFIG = configuration;
break;
}
}
//Done loop
}
//done checking if null test.
String pgm = CURRENT_RUNNING_CONFIG.program;
txtLotSize.Text = CURRENT_RUNNING_CONFIG.lotsize;
TESTS_IN_LOT = int.Parse(CURRENT_RUNNING_CONFIG.lotsize);
change_program(pgm);
//comOptions.comPort.Write("M\\S1TCAP="+pgm + ENDL);
}
public void reset()
{
TESTS_IN_LOT = int.Parse(txtLotSize.Text);
bmpBlank = new Bitmap(Torch2.Properties.Resources.blank);
bmpFail = new Bitmap(Torch2.Properties.Resources.fail);
bmpPass = new Bitmap(Torch2.Properties.Resources.pass);
firstTests = true;
RUNNING = false;
READY_TO_TEST = true;
failures = false;
testResults = new Dictionary<int, double>();
runResults = new Dictionary<int, double>();
runResultsDates = new Dictionary<int, string>();
queue = new List<List<string>>();
thresholds = new List<double>();
lotFailures = new List<int>();
BUFFER = "";
testNumber = 0;
NULL_PROG = "M\\S1TCAP=" + NULL_PROG_NUMBER.ToString() + ENDL;
current_test_number = NULL_PROG_NUMBER;
CURRENT_RUNNING_CONFIG = null;
}
