public Vector buscar(String pidConsulta) throws java.sql.SQLException, Exception {
Medicina medicina = null;
Vector medicinas;
java.sql.ResultSet rs;
String sql;
sql =
"SELECT id, nombre,dosis, numDias, FK_idConsulta, fechaInicio, fechaFinal, precauciones "
+ "FROM TMedicina "
+ "WHERE FK_idConsulta='"
+ pidConsulta
+ "';";
rs = Conector.getConector().ejecutarSQL(sql, true);
medicinas = new Vector<Medicina>();
if (rs.next()) {
do {
medicina =
new Medicina(
rs.getString("nombre"),
rs.getString("dosis"),
rs.getString("numDias"),
rs.getString("FK_idConsulta"),
rs.getString("fechaInicio"),
rs.getString("fechaFinal"),
rs.getString("precauciones"));
medicinas.add(medicina);
} while (rs.next());
} else {
throw new Exception("No hay examenes de ese paciente.");
}
rs.close();
return medicinas;
}
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;
}
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);
}
}