public ArrayList lista_gestion_contacto(
String id_codper, String c_nrodoc, String c_nombre, String id_codtges) throws Exception {
Conexion co = new Conexion();
ArrayList lista = new ArrayList();
ResultSet rs =
co.listar(
" select * from USP_QRY_GESTION_CONTACTO('"
+ id_codper
+ "','"
+ c_nrodoc
+ "','"
+ c_nombre
+ "','"
+ id_codtges
+ "') ");
Gestion ges = new Gestion();
while (rs.next()) {
ges = new Gestion();
ges.setC_codcent(rs.getString("c_codcent"));
ges.setC_tipodoc(rs.getString("c_tipodoc"));
ges.setC_nrodoc(rs.getString("c_nrodoc"));
ges.setC_nombre(rs.getString("c_nombre"));
ges.setC_direccion(rs.getString("c_direccion"));
ges.setC_distprov(rs.getString("c_distprov"));
ges.setC_telefono(rs.getString("c_telefono"));
ges.setF_fproceso(rs.getString("f_fproceso"));
ges.setF_fecasig(rs.getString("f_fecasig"));
ges.setC_destges(rs.getString("c_destges"));
ges.setN_idxges(rs.getString("n_idxges"));
ges.setId_codusu(rs.getString("id_codusu"));
ges.setId_codtges(rs.getString("id_codtges"));
lista.add(ges);
}
return lista;
}
public ArrayList gestion_llamada_quitar(
String f_fproceso, String id_codper, String id_codtcon, String id_codtres, String id_codusu)
throws Exception {
Conexion co = new Conexion();
ArrayList lista = new ArrayList();
String cadena =
" SELECT * FROM USP_QRY_GESTION_LLM_QUITAR('"
+ f_fproceso
+ "','"
+ id_codper
+ "','"
+ id_codtcon
+ "','"
+ id_codtres
+ "','"
+ id_codusu
+ "') ";
ResultSet rs = co.listar(cadena);
Gestion ges = new Gestion();
while (rs.next()) {
ges = new Gestion();
ges.setF_fproceso(rs.getString("f_fproceso"));
ges.setC_codcent(rs.getString("c_codcent"));
ges.setC_nrodoc(rs.getString("c_nrodoc"));
ges.setC_nombre(rs.getString("c_nombre"));
ges.setC_contrato(rs.getString("c_contrato"));
ges.setN_idxges(rs.getString("n_idxges"));
ges.setC_destcon(rs.getString("c_destcon"));
ges.setC_destres(rs.getString("c_destres"));
ges.setF_fecresp(rs.getString("f_fecresp"));
ges.setC_destres_sub(rs.getString("c_destres_sub"));
ges.setC_obsges(rs.getString("c_obsges"));
ges.setC_nomusu(rs.getString("c_nomusu"));
ges.setId_codusu(rs.getString("id_codusu"));
ges.setId_codtcon(rs.getString("id_codtcon"));
ges.setId_codtres(rs.getString("id_codtres"));
lista.add(ges);
}
return lista;
}