public static InputInvoiceList 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, FechaIni = from, FechaFin = till, Step = step, }; string query = InputInvoiceSQL.SELECT(conditions); if (criteria != null) { criteria.PagingInfo = conditions.PagingInfo; } return(GetList(query, criteria, childs)); }
public static InputInvoiceList GetList(ETipoAcreedor providerType, long oidProvider, long oidSerie, ETipoFacturas invoicesType, ETipoFactura invoiceType, DateTime from, DateTime till, bool childs) { QueryConditions conditions = new QueryConditions { Acreedor = (oidProvider != 0) ? ProviderBaseInfo.New(oidProvider, providerType) : null, TipoAcreedor = new ETipoAcreedor[1] { providerType }, Serie = (oidSerie != 0) ? Serie.Serie.New().GetInfo() : null, TipoFacturas = invoicesType, TipoFactura = invoiceType, FechaIni = from, FechaFin = till, }; if (oidSerie != 0) { conditions.Serie.Oid = oidSerie; } return(GetList(InputInvoiceSQL.SELECT(conditions), childs)); }
public static InputInvoiceList GetListByAcreedor(long oid, ETipoAcreedor providerType, bool childs) { QueryConditions conditions = new QueryConditions { TipoAcreedor = new ETipoAcreedor[1] { providerType }, Acreedor = ProviderBaseInfo.New(oid, providerType) }; return(GetList(InputInvoiceSQL.SELECT(conditions), childs)); }
public static InputInvoiceList GetPendientesList(long oidProvider, ETipoAcreedor providerType, bool childs) { QueryConditions conditions = new QueryConditions { TipoFacturas = ETipoFacturas.Pendientes, Acreedor = ProviderBaseInfo.New(oidProvider, providerType), TipoAcreedor = new ETipoAcreedor[1] { providerType } }; return(GetList(InputInvoiceSQL.SELECT(conditions), childs)); }
public static InputInvoiceList GetPendientesList(DateTime expirationFrom, DateTime expirationTill, EMedioPago paymentMethod, bool childs) { QueryConditions conditions = new QueryConditions { TipoFacturas = ETipoFacturas.Pendientes, FechaAuxIni = expirationFrom, FechaAuxFin = expirationTill, MedioPago = paymentMethod }; return(GetList(InputInvoiceSQL.SELECT(conditions), childs)); }
/// <summary> /// Retrieve the complete list from db /// </summary> /// <param name="get_childs">retrieving the childs</param> /// <returns>FacturaRecibidaList</returns> public static InputInvoiceList GetChildList(bool childs) { CriteriaEx criteria = InputInvoice.GetCriteria(InputInvoice.OpenSession()); criteria.Childs = childs; if (nHManager.Instance.UseDirectSQL) { criteria.Query = InputInvoiceSQL.SELECT(); } InputInvoiceList list = DataPortal.Fetch <InputInvoiceList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public static InputInvoiceList GetList(QueryConditions conditions, bool childs) { return(GetList(InputInvoiceSQL.SELECT(conditions), childs)); }
public static InputInvoices GetList(Library.Store.QueryConditions conditions, bool childs, int sessionCode) { return(GetList(childs, InputInvoiceSQL.SELECT(conditions), sessionCode)); }
public static InputInvoices GetList(bool childs = true) { return(GetList(childs, InputInvoiceSQL.SELECT())); }
public static InputInvoices GetChildList(int sessionCode, List <long> oid_list, bool childs) { return(GetChildList(sessionCode, InputInvoiceSQL.SELECT(new QueryConditions { OidList = oid_list }), childs)); }