Ejemplo n.º 1
0
        public static PaymentList GetList(ETipoAcreedor providerType,
                                          long oidProvider,
                                          DateTime from,
                                          DateTime till,
                                          EStepGraph step,
                                          CriteriaEx criteria,
                                          bool childs)
        {
            QueryConditions conditions = new QueryConditions()
            {
                PagingInfo   = (criteria != null) ? criteria.PagingInfo : null,
                Filters      = (criteria != null) ? criteria.Filters : null,
                Orders       = (criteria != null) ? criteria.Orders : null,
                TipoAcreedor = new ETipoAcreedor[1] {
                    providerType
                },
                Acreedor    = (oidProvider != 0) ? ProviderBaseInfo.New(oidProvider, providerType) : null,
                PaymentType = providerType == ETipoAcreedor.Empleado ? ETipoPago.Nomina : ETipoPago.Factura,
                FechaIni    = from,
                FechaFin    = till,
                Step        = step,
            };

            string query = SELECT(conditions);

            if (criteria != null)
            {
                criteria.PagingInfo = conditions.PagingInfo;
            }

            return(GetList(query, criteria, childs));
        }
Ejemplo n.º 2
0
        public static OutputInvoiceList GetByBranchList(long oidPartner, long oidBranch, DateTime from, DateTime till, EStepGraph step, CriteriaEx criteria, bool childs)
        {
            QueryConditions conditions = new QueryConditions()
            {
                PagingInfo = (criteria != null) ? criteria.PagingInfo : null,
                Filters    = (criteria != null) ? criteria.Filters : null,
                Orders     = (criteria != null) ? criteria.Orders : null,
                IAcreedor  = ProviderBaseInfo.New(oidPartner, ETipoAcreedor.Partner),
                OidEntity  = oidBranch,
                FechaIni   = from,
                FechaFin   = till,
                Step       = step,
            };

            string query = OutputInvoice.SELECT_BY_BRANCH(conditions, false);

            if (criteria != null)
            {
                criteria.PagingInfo = conditions.PagingInfo;
            }

            return(GetList(query, criteria, childs));
        }
Ejemplo n.º 3
0
        public static OutputInvoiceList GetList(long oidClient, DateTime from, DateTime till, EStepGraph step, CriteriaEx criteria, bool childs)
        {
            QueryConditions conditions = new QueryConditions()
            {
                PagingInfo = (criteria != null) ? criteria.PagingInfo : null,
                Filters    = (criteria != null) ? criteria.Filters : null,
                Orders     = (criteria != null) ? criteria.Orders : null,
                Cliente    = ClienteInfo.New(oidClient),
                FechaIni   = from,
                FechaFin   = till,
                Step       = step,
            };

            string query = OutputInvoice.SELECT(conditions, false);

            if (criteria != null)
            {
                criteria.PagingInfo = conditions.PagingInfo;
            }

            return(GetList(query, criteria, childs));
        }