public void searchTratamiento(Conexion conn, System.Windows.Forms.ListView listView, String textdata) { try { string stringSQL = "SELECT nombre_tratamiento AS Nombre, precio AS Precio" + " FROM tbl_tratamiento" + " WHERE (UPPER(nombre_tratamiento) LIKE UPPER('" + textdata + "%'))"; func.fillListView(conn, listView, stringSQL); } catch (Exception ex) { mssg.showMessage(ex.Message, "error", ""); } }
public void searchOdontograma(Conexion conn, System.Windows.Forms.ListView listView, String textdata) { try { string stringSQL = "SELECT cedula_paciente AS Cedula, categoria_odontograma AS Categoria, imagen_odontograma AS Imagen" + "FROM tbl_odontograma" + " WHERE (UPPER(cedula_paciente) LIKE UPPER('" + textdata + "%')"; func.fillListView(conn, listView, stringSQL); } catch (Exception ex) { mssg.showMessage(ex.Message, "error", ""); } }
public void searchAnamnesis(Conexion conn, System.Windows.Forms.ListView listView, String textdata) { try { string stringSQL = "SELECT cedula_paciente AS Cedula, medico_cabecera AS Medico, tipo_sangre AS Tipo, persona_avisar AS Persona, telefono_emergencia AS Telefono," + " direccion AS Direccion, parentesco AS Parentesco, queja_principal AS Queja, historia_queja_historia AS Queja_Historiar" + " FROM tbl_anamnesis " + " WHERE (UPPER(cedula_paciente) LIKE UPPER('" + textdata + "%')" + " OR UPPER(nombre_paciente) LIKE UPPER('" + textdata + "%'))"; func.fillListView(conn, listView, stringSQL); } catch (Exception ex) { mssg.showMessage(ex.Message, "error", ""); } }
public void searchExpediente(Conexion conn, System.Windows.Forms.ListView listView, String textdata) { try { string stringSQL = "SELECT cedula_paciente AS Cedula, nombre_paciente AS Nombre,apellido_paciente AS Apellido, telefono_paciente AS Telefono," + " sexo_paciente AS Sexo, lugar_nacimiento AS Lugar, enfermedad_padecimiento AS Enfermedad," + " problema_presion AS Presion, fiebre_reumatica AS Fiebre," + " medico_cabecera AS Medico, tipo_sangre AS Tipo, telefono_emergencia AS Telefono, parentesco AS Parentesco, historia_queja_medica AS Historia" + " FROM tbl_paciente " + " WHERE (UPPER(cedula_paciente) LIKE UPPER('" + textdata + "%')" + " OR UPPER(nombre_paciente) LIKE UPPER('" + textdata + "%'))"; func.fillListView(conn, listView, stringSQL); } catch (Exception ex) { mssg.showMessage(ex.Message, "error", ""); } }