private void FormatReport(InformeCarteraClientesRpt rpt, FormatConfCarteraClientesReport conf) { switch (conf.campo_ordenacion) { case "Nombre": { rpt.GHNumeroCliente.SectionFormat.EnableSuppress = true; rpt.GFNumero.SectionFormat.EnableSuppress = true; rpt.GHNombre.SectionFormat.EnableSuppress = false; rpt.GFNombre.SectionFormat.EnableSuppress = false; FieldDefinition fdes = rpt.Database.Tables[0].Fields["Nombre"]; rpt.DataDefinition.SortFields[0].Field = fdes; rpt.DataDefinition.SortFields[0].SortDirection = conf.orden_ascendente ? CrystalDecisions.Shared.SortDirection.AscendingOrder : CrystalDecisions.Shared.SortDirection.DescendingOrder; } break; case "Numero de Cliente": { rpt.GHNumeroCliente.SectionFormat.EnableSuppress = false; rpt.GFNumero.SectionFormat.EnableSuppress = false; rpt.GHNombre.SectionFormat.EnableSuppress = true; rpt.GFNombre.SectionFormat.EnableSuppress = true; FieldDefinition fdes = rpt.Database.Tables[0].Fields["Codigo"]; rpt.DataDefinition.SortFields[0].Field = fdes; rpt.DataDefinition.SortFields[0].SortDirection = conf.orden_ascendente ? CrystalDecisions.Shared.SortDirection.AscendingOrder : CrystalDecisions.Shared.SortDirection.DescendingOrder; } break; } rpt.Detalles.SectionFormat.EnableSuppress = conf.resumido; }
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 InformeCarteraClientesRpt GetCarteraClientesReport(ClienteInfo cliente, SerieInfo serie, FormatConfCarteraClientesReport conf) { InformeCarteraClientesRpt doc = new InformeCarteraClientesRpt(); List <CarteraClientesPrint> pList = new List <CarteraClientesPrint>(); List <CobroFacturaPrint> pCobroList = new List <CobroFacturaPrint>(); QueryConditions conditions = new QueryConditions { Cliente = cliente, Serie = serie, FechaIni = conf.inicio, FechaFin = conf.final }; GetFacturas(cliente, conditions, conf, pList, pCobroList); doc.SetDataSource(pList); if (pCobroList.Count != 0) { doc.Subreports["CobroFacturasRpt"].SetDataSource(pCobroList); } else { conf.verCobros = false; } doc.SetParameterValue("VerCobros", conf.verCobros); FormatReport(doc, conf); FormatHeader(doc); return(doc); }
public InformeCarteraClientesRpt GetCarteraClientesReport(ClienteList lista, SerieInfo serie, FormatConfCarteraClientesReport conf) { if (lista == null || lista.Count == 0) { return(null); } InformeCarteraClientesRpt doc = new InformeCarteraClientesRpt(); List <CarteraClientesPrint> pList = new List <CarteraClientesPrint>(); List <CobroFacturaPrint> pCobroList = new List <CobroFacturaPrint>(); QueryConditions conditions = new QueryConditions { Serie = serie, FechaIni = conf.inicio, FechaFin = conf.final }; foreach (ClienteInfo item in lista) { conditions.Cliente = item; GetFacturas(item, conditions, conf, pList, pCobroList); } doc.SetDataSource(pList); if (pCobroList.Count != 0) { doc.Subreports["CobroFacturasRpt"].SetDataSource(pCobroList); } else { conf.verCobros = false; } doc.SetParameterValue("VerCobros", conf.verCobros); FormatReport(doc, conf); FormatHeader(doc); return(doc); }