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