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));
}
