public Object editarCargar(Jpo jpo, HttpServletRequest request, HttpServletResponse response)
throws Exception {
Map<String, Object> elementos = new HashMap<String, Object>();
elementos.put("ATRIBUTO", jpo.tabla("ATRIBUTO", "ATR").obtener("*"));
elementos.put("ATRIBUTO_SQL", jpo.tabla("ATRIBUTO_SQL", "ADB").obtener("*"));
return elementos;
}
public Object listarDependencias(
Jpo jpo, HttpServletRequest request, HttpServletResponse response) throws Exception {
Map<String, Object> elementos = new HashMap<String, Object>();
elementos.put("OBJ_BPM", jpo.tabla("OBJ_BPM", "OBJ").seleccionar("*"));
elementos.put("TABLA", jpo.tabla("TABLA", "TAB").seleccionar("*"));
return elementos;
}
public Object eliminar(Jpo jpo, HttpServletRequest request, HttpServletResponse response)
throws Exception {
// jpo.autoCommit(false);
jpo.tabla("ATRIBUTO_SQL", "ADB").eliminar();
jpo.tabla("ATRIBUTO", "ATR").eliminar();
jpo.commitear();
return true;
}
public Object registrar(Jpo jpo, HttpServletRequest request, HttpServletResponse response)
throws Exception {
// jpo.autoCommit(false);
jpo.tabla("ATRIBUTO", "ATR").registrar();
if (request.getParameter("FLG_sql") != null && request.getParameter("FLG_sql").equals("true")) {
jpo.tabla("ATRIBUTO_SQL", "ADB").registrar();
}
jpo.commitear();
return true;
}
public Object editar(Jpo jpo, HttpServletRequest request, HttpServletResponse response)
throws Exception {
String flg_sql = request.getParameter("FLG_sql");
String flg_sqlEsEdicion = request.getParameter("FLG_sqlEsEdicion");
// jpo.autoCommit(false);
jpo.tabla("ATRIBUTO", "ATR").editar();
Tabla atributoSQL = jpo.tabla("ATRIBUTO_SQL", "ADB");
if (flg_sql != null && flg_sql.equals("true")) {
if (flg_sqlEsEdicion != null && flg_sqlEsEdicion.equals("true")) {
atributoSQL.editar();
} else {
atributoSQL.registrar();
}
} else {
atributoSQL.eliminar();
}
jpo.commitear();
return true;
}
public Object listaAtributoxPK(Jpo jpo, HttpServletRequest request, HttpServletResponse response)
throws Exception {
return jpo.tabla("ATRIBUTO", "ATR").seleccionar("COD_ATRIBUTO,NOMBRE");
}
public Object listar(Jpo jpo, HttpServletRequest request, HttpServletResponse response)
throws Exception {
return jpo.tabla("ATRIBUTO", "ATR").seleccionar("*");
}