public static ModeloList GetList(QueryConditions conditions, bool childs) { return(GetList(SELECT(conditions), childs)); }
public static string SELECT(QueryConditions conditions) { return(InterestRate.SELECT(conditions, true)); }
public static string SELECT(QueryConditions conditions) { return(Traspaso.SELECT(conditions, true)); }
private void GetFacturas(ClienteInfo cliente, QueryConditions conditions, FormatConfCarteraClientesReport conf, List <CarteraClientesPrint> pList, List <CobroFacturaPrint> pCobroList) { OutputInvoiceList facturas; conditions.Cliente = cliente; switch (conf.tipo) { case ETipoFacturas.Cobradas: { facturas = OutputInvoiceList.GetCobradasList(conditions, false); if (facturas.Count > 0) { foreach (OutputInvoiceInfo f in facturas) { f.LoadChilds(typeof(CobroFacturaInfo), false); pList.Add(cliente.GetCarteraPrintObject(f)); foreach (CobroFacturaInfo cobro in f.CobroFacturas) { pCobroList.Add(CobroFacturaPrint.New(cobro)); } } } } break; case ETipoFacturas.Pendientes: { facturas = OutputInvoiceList.GetNoCobradasList(conditions, false); if (facturas.Count > 0) { foreach (OutputInvoiceInfo f in facturas) { f.LoadChilds(typeof(CobroFacturaInfo), false); pList.Add(cliente.GetCarteraPrintObject(f)); foreach (CobroFacturaInfo cobro in f.CobroFacturas) { pCobroList.Add(CobroFacturaPrint.New(cobro)); } } } } break; case ETipoFacturas.Todas: { facturas = OutputInvoiceList.GetList(conditions, false); if (facturas.Count == 0) { pList.Add(cliente.GetCarteraPrintObject(null)); } else { foreach (OutputInvoiceInfo f in facturas) { f.LoadChilds(typeof(CobroFacturaInfo), false); if (f.CobroFacturas.Count > 0) { pList.Add(cliente.GetCarteraPrintObject(f)); foreach (CobroFacturaInfo cobro in f.CobroFacturas) { pCobroList.Add(CobroFacturaPrint.New(cobro)); } } else { pList.Add(cliente.GetCarteraPrintObject(f)); } } } } break; } }
public static string SELECT(QueryConditions conditions) { return(AlbaranTicket.SELECT(conditions, true)); }
public static Transactiones GetList(QueryConditions conditions, bool childs) { return(GetList(Transactiones.SELECT(conditions), childs)); }
public static OutputInvoiceLineList GetList(QueryConditions conditions, bool childs) { return(GetList(OutputInvoiceLineList.SELECT(conditions), childs)); }
public static OutputInvoiceList GetDudosoCobroList(QueryConditions conditions, bool childs) { conditions.TipoFacturas = ETipoFacturas.DudosoCobro; return(GetList(conditions, childs)); }
public static OutputInvoiceList GetBeneficioList(QueryConditions conditions, bool childs) { return(GetList(OutputInvoice.SELECT_BENEFICIO(conditions, false), childs)); }
public static OutputInvoiceList GetCobradasList(QueryConditions conditions, bool childs) { conditions.TipoFacturas = ETipoFacturas.Cobradas; return(GetList(OutputInvoiceList.SELECT(conditions), false)); }
public static OutputInvoiceList GetNoCobradasList(QueryConditions conditions, bool childs) { conditions.TipoFacturas = ETipoFacturas.Pendientes; return(GetList(conditions, childs)); }
public static string SELECT(QueryConditions conditions) { return(BankLine.SELECT(conditions, true)); }
public static string SELECT(QueryConditions conditions) { return(FinancialCash.SELECT(conditions, true)); }
public static string SELECT(QueryConditions conditions) { return(ModeloInfo.SELECT(conditions)); }
public static Charges GetList(QueryConditions conditions, bool childs) { conditions.Order = System.ComponentModel.ListSortDirection.Descending; return(GetList(childs, Charges.SELECT(conditions))); }
public static string SELECT(QueryConditions conditions) { return(OutputInvoice.SELECT(conditions, false)); }
public static string SELECT(QueryConditions conditions) { return(Invoice.Transaction.SELECT(conditions, true)); }
public static CashLineList GetList(QueryConditions conditions, bool childs) { return(GetList(CashLineList.SELECT(conditions), childs)); }
public static string SELECT(QueryConditions conditions) { return(OutputDelivery.SELECT(conditions, false)); }
public static string SELECT(QueryConditions conditions) { return(CashLine.SELECT(conditions, false)); }
internal static string WHERE(QueryConditions conditions) { string query; query = " WHERE (F.\"FECHA\" BETWEEN '" + conditions.FechaIniLabel + "' AND '" + conditions.FechaFinLabel + "')"; switch (conditions.Estado) { case EEstado.Todos: break; case EEstado.NoAnulado: query += " AND C.\"ESTADO\" != " + (long)EEstado.Anulado; break; default: query += " AND C.\"ESTADO\" = " + (long)conditions.Estado; break; } if (conditions.Cliente != null) { query += " AND F.\"OID_CLIENTE\" = " + conditions.Cliente.Oid; } if (conditions.Cobro != null) { query += " AND CF.\"OID_COBRO\" = " + conditions.Cobro.Oid; } if (conditions.Serie != null) { query += " AND F.\"OID_SERIE\" = " + conditions.Serie.Oid; } if (conditions.Factura != null) { query += " AND CF.\"OID_FACTURA\" = " + conditions.Factura.Oid; } switch (conditions.MedioPago) { case EMedioPago.NoEfectivo: query += " AND C.\"MEDIO_PAGO\" != " + (long)EMedioPago.Efectivo; break; default: if (conditions.MedioPago != EMedioPago.Todos) { query += " AND C.\"MEDIO_PAGO\" = " + (long)conditions.MedioPago; } break; } if (conditions.MedioPagoList != null && conditions.MedioPagoList.Count > 0) { query += EntityBase.GET_IN_LIST_CONDITION(conditions.MedioPagoList, "C", "MEDIO_PAGO"); } return(query); }
public static string SELECT(QueryConditions conditions) { return(ChargeSummary.SELECT(conditions)); }
public static string SELECT_PENDIENTES(QueryConditions conditions) { return(LineaPedido.SELECT_PENDIENTES(conditions, false)); }
public static string SELECT_PENDIENTES(QueryConditions conditions) { return(ChargeSummary.SELECT_PENDIENTES(conditions)); }
public static string SELECT(QueryConditions conditions) { return(Cliente.SELECT(Cliente.EQueryType.GENERAL, conditions, false)); }
public static string SELECT_DUDOSO_COBRO(QueryConditions conditions) { return(ChargeSummary.SELECT_DUDOSO_COBRO(conditions)); }
public static Traspasos GetList(QueryConditions conditions, bool childs) { return(GetList(childs, Traspasos.SELECT(conditions))); }
public static ChargeList GetListByVencimientoSinApunte(QueryConditions conditions, bool childs) { return(GetList(Charge.SELECT_VENCIMIENTO_SIN_APUNTE(conditions), childs)); }
public static string SELECT(QueryConditions conditions) { return(CobroFactura.SELECT(conditions, true)); }
internal static string SELECT(QueryConditions conditions, bool lock_table) { return(SELECT(0, conditions, lock_table)); }