Exemplo n.º 1
0
        public static InputDeliveryLineList GetByExpedienteStockList(long oid, bool childs, InputDeliveryInfo albaran)
        {
            QueryConditions conditions = new QueryConditions
            {
                Expedient    = ExpedientInfo.New(oid),
                TipoAcreedor = new ETipoAcreedor[1] {
                    ETipoAcreedor.Proveedor
                }
            };

            InputDeliveryLineList list = GetList(InputDeliveryLineSQL.SELECT_STOCK(conditions, false), childs);

            List <InputDeliveryLineInfo> merge = new List <InputDeliveryLineInfo>();

            foreach (InputDeliveryLineInfo ca in albaran.ConceptoAlbaranes)
            {
                if (ca.OidExpediente == oid)
                {
                    merge.Add(ca);
                }
            }

            foreach (InputDeliveryLineInfo ca in list)
            {
                if (ca.OidAlbaran != albaran.Oid)
                {
                    merge.Add(ca);
                }
            }

            return(InputDeliveryLineList.GetChildList(merge));
        }
Exemplo n.º 2
0
        public static InputDeliveryLineList GetByExpedienteStockList(long oid, bool childs)
        {
            QueryConditions conditions = new QueryConditions
            {
                Expedient    = ExpedientInfo.New(oid),
                TipoAcreedor = new ETipoAcreedor[1] {
                    ETipoAcreedor.Proveedor
                }
            };

            return(GetList(InputDeliveryLineSQL.SELECT_STOCK(conditions, false), childs));
        }
Exemplo n.º 3
0
 public static string SELECT_BY_EXPEDIENTE_STOCK(QueryConditions conditions)
 {
     return(InputDeliveryLineSQL.SELECT_STOCK(conditions, false));
 }