protected void setTrayActive(String strDir) {
String strTray;
String strStudy;
String strActive = "Active";
String cmd =
"SELECT vrack_,studystatus from study WHERE (autodir=\'"
+ strDir
+ "\') AND (hostname=\'"
+ getHost()
+ "\')";
m_dbResult = null;
try {
m_dbResult = getdbmanager().executeQuery(cmd);
} catch (Exception e) {
return;
}
if (m_dbResult == null) return;
int nTray = 0;
try {
while (m_dbResult.next()) {
strTray = m_dbResult.getString(1);
strStudy = m_dbResult.getString(2);
if (strStudy != null && strStudy.equalsIgnoreCase(strActive)) {
try {
nTray = Integer.parseInt(strTray);
} catch (Exception e) {
}
if (nTray > 0) {
m_pnlVast[nTray - 1].setbackground(Color.blue);
m_pnlVast[nTray - 1].setToolTipText(Util.getTooltipString(TRAYACTIVE));
break;
}
}
}
} catch (Exception e) {
// e.printStackTrace();
Messages.writeStackTrace(e);
}
}
protected String getSampleName(String strDir, String strTray) {
String strSampleName = "";
String strSample;
int nTray = 0;
try {
nTray = Integer.parseInt(strTray);
} catch (Exception e) {
}
if (nTray <= 0) return strSampleName;
String cmd =
"SELECT loc_,studystatus from study WHERE (autodir=\'"
+ strDir
+ "\') AND (hostname=\'"
+ getHost()
+ "\')";
// NB: bArrSample[0] is not used; array implicitly initialized false
boolean[] bArrSample = new boolean[nTray + 1];
m_dbResult = null;
try {
m_dbResult = getdbmanager().executeQuery(cmd);
} catch (Exception e) {
return strSampleName;
}
if (m_dbResult == null) return strSampleName;
try {
while (m_dbResult.next()) {
strSample = m_dbResult.getString(1);
int nSample = 0;
nSample = Integer.parseInt(strSample);
try {
bArrSample[nSample] = true;
} catch (IndexOutOfBoundsException ioobe) {
Messages.postDebug("getSampleName: index out of bounds: " + nSample);
}
}
for (int i = 1; i < bArrSample.length; i++) {
if (!bArrSample[i]) {
strSampleName = String.valueOf(i);
break;
}
}
} catch (Exception e) {
// e.printStackTrace();
Messages.writeStackTrace(e);
}
return strSampleName;
}