/// <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));
}
}
}
}
