public TCP_ADM_AREAHIST dmlSelectID(TCP_ADM_AREAHIST oDatos)
{
String sSQL = " SELECT * FROM TCP_ADM_AREAHIST WHERE araclave = :P0 AND arhfecfin = :P1 AND arhfecini = :P2 ";
return(CrearListaMDL <TCP_ADM_AREAHIST>(ConsultaDML(sSQL, oDatos.araclave, oDatos.arhfecfin, oDatos.arhfecini) as DataTable)[0]);
}
public int dmlEditar(TCP_ADM_AREAHIST oDatos)
{
String sSQL = " UPDATE TCP_ADM_AREAHIST SET atpclave = :P0, anlclave = :P1, arhreporta = :P2, arhsiglas = :P3, arhdescripcion = :P4, arhclaveua = :P5 WHERE araclave = :P6 AND arhfecfin = :P7 AND arhfecini = :P8 ";
return((int)EjecutaDML(sSQL, oDatos.atpclave, oDatos.anlclave, oDatos.arhreporta, oDatos.arhsiglas, oDatos.arhdescripcion, oDatos.arhclaveua, oDatos.araclave, oDatos.arhfecfin, oDatos.arhfecini));
}
public int dmlBorrar(TCP_ADM_AREAHIST oDatos)
{
String sSQL = " DELETE FROM TCP_ADM_AREAHIST WHERE araclave = :P0 AND arhfecfin = :P1 AND arhfecini = :P2 ";
return((int)EjecutaDML(sSQL, oDatos.araclave, oDatos.arhfecfin, oDatos.arhfecini));
}
public Object dmlAgregar(TCP_ADM_AREAHIST oDatos)
{
String sSQL = " INSERT INTO TCP_ADM_AREAHIST( atpclave, anlclave, araclave, arhreporta, arhsiglas, arhdescripcion, arhclaveua, arhfecfin, arhfecini) VALUES ( :P0, :P1, :P2, :P3, :P4, :P5, :P6, :P7, :P8) ";
return(EjecutaDML(sSQL, oDatos.atpclave, oDatos.anlclave, oDatos.araclave, oDatos.arhreporta, oDatos.arhsiglas, oDatos.arhdescripcion, oDatos.arhclaveua, oDatos.arhfecfin, oDatos.arhfecini));
}
