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", "");
}
}