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