/// <summary> /// Generates the CSV Body adding the Grid and all the Details for the selected Motores. /// </summary> /// <param name="builder"></param> private void GenerateCsvBody(GridToCSVBuilder builder) { var separator = Usuario.CsvSeparator; builder.GenerateColumns(/*new List<string>{"Vehiculo"},*/ Grid); builder.GenerateFields(Grid); var desde = dpDesde.SelectedDate.GetValueOrDefault(); var hasta = dpHasta.SelectedDate.GetValueOrDefault(); var consumos = DAOFactory.MovimientoDAO.FindConsumosBetweenDatesAndMotores(lbMotores.SelectedValues, desde, hasta); var consumosVo = consumos.Select(d => new ConsumoVO(d)).ToList(); foreach (var consumosPorMotor in lbMotores.SelectedValues.Select(motor => (from c in consumosVo where c.IDCaudalimetro == motor orderby c.Fecha descending select c))) { if (consumosPorMotor.Count().Equals(0)) { return; } builder.GenerateRow(String.Empty); builder.GenerateRow(String.Empty); /*Generates the Motor Description for its consumes datail.*/ builder.GenerateRow(String.Concat(CultureManager.GetEntity("PARENTI39"), ":", consumosPorMotor.First().Motor)); /*Genarates the columns headers*/ builder.GenerateRow(String.Concat(CultureManager.GetEntity("PARENTI37"), separator, CultureManager.GetLabel("FECHA"), separator, CultureManager.GetLabel("INTERNO"), separator, CultureManager.GetLabel("PATENTE"), separator, CultureManager.GetLabel("VOLUMEN"), separator , CultureManager.GetLabel("CHOFER"))); /*Genearates all the datails for the Motor*/ foreach (var c in consumosPorMotor) { builder.GenerateRow(String.Concat(c.Fecha, separator, c.CentroDeCostos, separator, c.Volumen, separator, c.HsEnMarcha, separator, c.Caudal)); } } }
/// <summary> /// Generates the CSV Body adding the Grid and all the Details for the selected Motores. /// </summary> /// <param name="builder"></param> private void GenerateCSVBody(GridToCSVBuilder builder) { var separator = Usuario.CsvSeparator; builder.GenerateColumns(/*null,*/ Grid); builder.GenerateFields(Grid); var movimientos = DAOFactory.MovimientoDAO.FindIngresosByDate(dpDesde.SelectedDate.GetValueOrDefault(), dpHasta.SelectedDate.GetValueOrDefault()); var remitos = movimientos.Select(m => new IngresoVO(m)).ToList(); var e = ddlEquipo.Selected; builder.GenerateRow(String.Empty); builder.GenerateRow(String.Empty); var ingresosPorEquipo = (from i in remitos where i.IDEquipo == e orderby i.Fecha descending select i); if (ingresosPorEquipo.Count().Equals(0)) { return; } /*Generates the Motor Description for its consumes datail.*/ builder.GenerateRow(String.Concat(CultureManager.GetEntity("PARENTI19"), ":", ingresosPorEquipo.First().NombreEquipo)); /*Genarates the columns headers*/ builder.GenerateRow(String.Concat(CultureManager.GetEntity("PARENTI36"), separator, CultureManager.GetLabel("FECHA"), separator, CultureManager.GetEntity("OPECOMB01"), separator, CultureManager.GetLabel("VOLUMEN"))); /*Genearates all the datails for the Motor*/ foreach (var i in ingresosPorEquipo) { builder.GenerateRow(String.Concat(i.Tanque, separator, i.Fecha, separator, i.DescriTipo, separator, i.Volumen)); } }
/// <summary> /// Generates the CSV Body adding the Grid and all the Details for the selected Motores. /// </summary> /// <param name="builder"></param> private void GenerateCSVBody(GridToCSVBuilder builder) { var separator = Usuario.CsvSeparator; builder.GenerateColumns(/*new List<string>(),*/ Grid); builder.GenerateFields(Grid); var despachos = DAOFactory.MovimientoDAO.FindDespachosBetweenDatesAndMobiles(selectedVehicles, dpDesde.SelectedDate.GetValueOrDefault(), dpHasta.SelectedDate.GetValueOrDefault()); var despachosVO = despachos.Select(d => new DespachoVO(d)).ToList(); foreach (var c in (from d in despachosVO select d.CentroDeCarga).Distinct()) { var center = c; builder.GenerateRow(String.Empty); builder.GenerateRow(String.Empty); /*Generates the Center Description for its dispatchs datail.*/ builder.GenerateRow(String.Concat(CultureManager.GetLabel("CENTRO_CARGA"), ":", center)); /*Genarates the columns headers*/ builder.GenerateRow(String.Concat(CultureManager.GetLabel("FECHA"), separator, CultureManager.GetEntity("PARENTI37"), separator, CultureManager.GetLabel("INTERNO"), separator, CultureManager.GetLabel("PATENTE"), separator, CultureManager.GetLabel("VOLUMEN"), separator , CultureManager.GetLabel("CHOFER"))); foreach (var v in (from d in despachosVO select d.Vehiculo).Distinct()) { var vehicle = v; builder.GenerateRow(String.Concat(CultureManager.GetEntity("PARENTI03"), vehicle)); var despachosPorCentroYVehiculo = (from d in despachosVO where d.CentroDeCarga.Equals(center) && d.Vehiculo.Equals(vehicle) orderby d.Fecha descending select d); /*Genearates all the datails for the Motor*/ foreach (var d in despachosPorCentroYVehiculo) { builder.GenerateRow(String.Concat(d.Fecha, separator, d.CentroDeCostos, separator, d.InternoVehiculo, separator, d.Patente, separator, d.Volumen, separator, d.Operador)); } } } }
/// <summary> /// Generates the CSV Body adding the Grid and all the Details for the selected Motores. /// </summary> /// <param name="builder"></param> private void GenerateCSVBody(GridToCSVBuilder builder) { var separator = Usuario.CsvSeparator; builder.GenerateColumns(/*new List<string>(), */ Grid); builder.GenerateFields(Grid); var movimientos = DAOFactory.MovimientoDAO.FindRemitosByDate(dpDesde.SelectedDate.GetValueOrDefault(), dpHasta.SelectedDate.GetValueOrDefault()); var remitos = movimientos.Select(m => new RemitoVO(m)).ToList(); foreach (var c in (from d in remitos select d.CentroDeCostos).Distinct()) { var center = c; builder.GenerateRow(String.Empty); builder.GenerateRow(String.Empty); /*Generates the Center Description for its dispatchs datail.*/ builder.GenerateRow(String.Concat(CultureManager.GetLabel("CENTRO_CARGA"), ":", center)); /*Genarates the columns headers*/ builder.GenerateRow(String.Concat(CultureManager.GetLabel("FECHA"), separator, CultureManager.GetLabel("TIPO_INGRESO"), separator, CultureManager.GetLabel("NRO_REMITO"), separator, CultureManager.GetLabel("VOLUMEN"))); foreach (var t in (from d in remitos select d.Tanque).Distinct()) { var tank = t; builder.GenerateRow(String.Concat(CultureManager.GetEntity("PARENTI36"), tank)); var cargasPorCentroYTanque = (from d in remitos where d.CentroDeCostos.Equals(center) && d.Tanque.Equals(tank) orderby d.Fecha descending select d); /*Genearates all the datails for the Remitos*/ foreach (var d in cargasPorCentroYTanque) { builder.GenerateRow(String.Concat(d.Fecha, separator, d.DescriTipo, separator, d.NroRemito, separator, d.Volumen)); } } } }