public static InputDeliveryList GetListByProducto(bool childs, long oidProduct) { QueryConditions conditions = new QueryConditions { Producto = ProductInfo.New(oidProduct) }; return(GetList(childs, SELECT(conditions))); }
public static Batchs GetChildListByProducto(Almacen parent, long oidProduct, bool childs) { CriteriaEx criteria = Batch.GetCriteria(parent.SessionCode); criteria.Childs = childs; QueryConditions conditions = new QueryConditions { Almacen = parent.GetInfo(false), Producto = ProductInfo.New(oidProduct) }; criteria.Query = Batchs.SELECT(conditions); return(DataPortal.Fetch <Batchs>(criteria)); }
public static BatchList GetByProductStockList(long oidProduct, long oidProvider, ETipoAcreedor providerType, bool childs) { CriteriaEx criteria = Batch.GetCriteria(Batch.OpenSession()); criteria.Childs = childs; QueryConditions conditions = new QueryConditions { Acreedor = (oidProvider != 0) ? ProviderBaseInfo.New(oidProvider, providerType) : null, Producto = ProductInfo.New(oidProduct) }; criteria.Query = Batch.SELECT_STOCK(conditions, false); BatchList list = DataPortal.Fetch <BatchList>(criteria); CloseSession(criteria.SessionCode); return(list); }