public SIT_ADM_AREAORG dmlSelectID(SIT_ADM_AREAORG oDatos) { String sSQL = " SELECT * FROM SIT_ADM_AREAORG WHERE agnclave = :P0 AND araclave = :P1 "; return(CrearListaMDL <SIT_ADM_AREAORG>(ConsultaDML(sSQL, oDatos.agnclave, oDatos.araclave) as DataTable)[0]); }
public int dmlEditar(SIT_ADM_AREAORG oDatos) { String sSQL = " UPDATE SIT_ADM_AREAORG SET orgorden = :P0, orgclavereporta = :P1 WHERE agnclave = :P2 AND araclave = :P3 "; return((int)EjecutaDML(sSQL, oDatos.orgorden, oDatos.orgclavereporta, oDatos.agnclave, oDatos.araclave)); }
public int dmlBorrar(SIT_ADM_AREAORG oDatos) { String sSQL = " DELETE FROM SIT_ADM_AREAORG WHERE agnclave = :P0 AND araclave = :P1 "; return((int)EjecutaDML(sSQL, oDatos.agnclave, oDatos.araclave)); }
public Object dmlAgregar(SIT_ADM_AREAORG oDatos) { String sSQL = " INSERT INTO SIT_ADM_AREAORG( agnclave, araclave, orgorden, orgclavereporta) VALUES ( :P0, :P1, :P2, :P3) "; return(EjecutaDML(sSQL, oDatos.agnclave, oDatos.araclave, oDatos.orgorden, oDatos.orgclavereporta)); }