Пример #1
0
        internal void CopyValues(PrecioOrigen source)
        {
            if (source == null)
            {
                return;
            }

            _record.CopyValues(source._base.Record);
        }
Пример #2
0
        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);
            }
        }
        public static PrecioOrigenList GetList(bool childs)
        {
            CriteriaEx criteria = PrecioOrigen.GetCriteria(PrecioOrigen.OpenSession());

            criteria.Childs = childs;

            criteria.Query = SELECT();

            PrecioOrigenList list = DataPortal.Fetch <PrecioOrigenList>(criteria);

            CloseSession(criteria.SessionCode);
            return(list);
        }
 public static string SELECT(QueryConditions conditions)
 {
     return(PrecioOrigen.SELECT(conditions, false));
 }