private void DataPortal_Fetch(CriteriaEx criteria)
        {
            try
            {
                _base.Record.Oid = 0;
                SessionCode      = criteria.SessionCode;
                Childs           = criteria.Childs;

                if (nHMng.UseDirectSQL)
                {
                    Transporter.DoLOCK(Session());
                    IDataReader reader = nHMng.SQLNativeSelect(criteria.Query, Session());

                    if (reader.Read())
                    {
                        CopyValues(reader);
                    }

                    if (Childs)
                    {
                        string query = string.Empty;

                        ProductoProveedor.DoLOCK(Session());
                        query  = ProductoProveedores.SELECT(this);
                        reader = nHMng.SQLNativeSelect(query, Session());
                        _base.ProviderBase.Productos = ProductoProveedores.GetChildList(SessionCode, reader);

                        PrecioDestino.DoLOCK(Session());
                        query            = PrecioDestinos.SELECT(this);
                        reader           = nHManager.Instance.SQLNativeSelect(query, Session());
                        _precio_destinos = PrecioDestinos.GetChildList(SessionCode, reader);

                        PrecioOrigen.DoLOCK(Session());
                        query            = Store.PrecioOrigenes.SELECT(this);
                        reader           = nHManager.Instance.SQLNativeSelect(query, Session());
                        _precio_origenes = PrecioOrigenes.GetChildList(SessionCode, reader);

                        //Pago.DoLOCK(Session());
                        //query = Pagos.SELECT(this);
                        //reader = nHManager.Instance.SQLNativeSelect(query, Session());
                        //_proveedor_base._pagos = Pagos.GetChildList(SessionCode, reader);
                    }
                }
            }
            catch (Exception ex)
            {
                if (Transaction() != null)
                {
                    Transaction().Rollback();
                }
                iQExceptionHandler.TreatException(ex);
            }
        }
        private void DataPortal_Create(CriteriaCs criteria)
        {
            Random r = new Random();

            Oid = (long)r.Next();
            GetNewCode();

            ETipoAcreedor = ETipoAcreedor.TransportistaOrigen;
            EMedioPago    = EMedioPago.Efectivo;
            EFormaPago    = EFormaPago.Contado;

            _precio_destinos = PrecioDestinos.NewChildList();
            _precio_origenes = PrecioOrigenes.NewChildList();
        }