void RefreshProgramSettings(SySal.OperaDb.OperaDbConnection conn) { SySal.OperaDb.OperaDbDataReader rd2 = null; try { lvProgramSettings.Items.Clear(); string sql = ""; if (chkFavorites.Checked) { sql = "select to_number(value), substr(name, length('PROGSET') + 2) as description from opera.lz_sitevars where name like 'PROGSET %' and exists (select * from tb_programsettings where id = to_number(value) and driverlevel = 2 and instr(upper(executable), 'TOTALSCAN') > 0) order by value"; } else { sql = "select id, description from tb_programsettings where driverlevel = 2 and instr(upper(executable), 'TOTALSCAN') > 0 order by id"; } rd2 = new SySal.OperaDb.OperaDbCommand(sql, conn).ExecuteReader(); while (rd2.Read()) { ListViewItem lvi = new ListViewItem(rd2.GetInt64(0).ToString()); lvi.Tag = rd2.GetInt64(0); lvi.SubItems.Add(rd2.GetString(1)); lvProgramSettings.Items.Add(lvi); } } catch (Exception x) { MessageBox.Show(x.ToString(), "Error Accessing DB", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (rd2 != null) { rd2.Close(); } } }
private void OnLoad(object sender, EventArgs e) { SySal.OperaDb.OperaDbConnection conn = null; SySal.OperaDb.OperaDbDataReader rd1 = null; SySal.OperaDb.OperaDbDataReader rd3 = null; SySal.OperaDb.OperaDbDataReader rd4 = null; try { conn = SySal.OperaDb.OperaDbCredentials.CreateFromRecord().Connect(); conn.Open(); rd1 = new SySal.OperaDb.OperaDbCommand("select id, name from tb_machines where id_site = (select value from opera.lz_sitevars where name = 'ID_SITE') and isscanningserver > 0 order by name", conn).ExecuteReader(); while (rd1.Read()) { ListViewItem lvi = new ListViewItem(rd1.GetInt64(0).ToString()); lvi.Tag = rd1.GetString(1) /*rd1.GetInt64(0)*/; lvi.SubItems.Add(rd1.GetString(1)); lvMachines.Items.Add(lvi); } rd1.Close(); rd3 = new SySal.OperaDb.OperaDbCommand("select value from opera.lz_sitevars where name = 'BM_AutoStartFile'", conn).ExecuteReader(); if (rd3.Read()) { m_AutoStartPath = rd3.GetString(0); } else { MessageBox.Show("AutoStart file path not set in LZ_SITEVARS.\r\nCannot continue.", "Infrastructure Setup Error", MessageBoxButtons.OK, MessageBoxIcon.Error); Close(); return; } System.Collections.ArrayList pa = new System.Collections.ArrayList(); rd4 = new SySal.OperaDb.OperaDbCommand("select id, z from tb_plates where id_eventbrick = " + BrickId + " order by z desc", conn).ExecuteReader(); while (rd4.Read()) { pa.Add(new PlateRecord(rd4.GetInt32(0), rd4.GetDouble(1))); } if (pa.Count == 0) { throw new Exception("No plates registered in your DB for this brick.\r\nPlease check and retry."); } Plates = (PlateRecord[])pa.ToArray(typeof(PlateRecord)); int i; for (i = 0; i < Plates.Length && Plates[i].Id != VolStart.Plate; i++) { ; } cmbPlates.Items.Add(i + "/0"); cmbPlates.Items.Add("0/" + (Plates.Length - 1 - i)); cmbSkew.Items.Add(VolStart.Slope.X.ToString("F4", System.Globalization.CultureInfo.InvariantCulture) + "/" + VolStart.Slope.Y.ToString("F4", System.Globalization.CultureInfo.InvariantCulture)); rd4.Close(); cmbNotes.Items.Add("TotalScan on brick " + BrickId); cmbNotes.Items.Add("TotalScan on brick " + BrickId + " around vertex point"); cmbNotes.Items.Add("TotalScan on brick " + BrickId + " around stopping point"); cmbNotes.SelectedIndex = VolumeStartsFromTrack ? 2 : 1; RefreshProgramSettings(conn); cmbWidthHeight.SelectedIndex = 0; cmbPlates.SelectedIndex = 0; cmbSkew.SelectedIndex = 0; OnWidthHeightLeave(this, null); OnPlatesLeave(this, null); OnSkewLeave(this, null); } catch (Exception x) { MessageBox.Show(x.ToString(), "Initialization Error", MessageBoxButtons.OK, MessageBoxIcon.Error); Close(); } finally { if (rd1 != null) { rd1.Close(); } if (rd3 != null) { rd3.Close(); } if (rd4 != null) { rd3.Close(); } if (conn != null) { conn.Close(); } } }