protected override void ExportToCsv()
{
var csv = new GridToCSVBuilder(Usuario.CsvSeparator);
csv.GenerateHeader(CultureManager.GetMenu(VariableName), GetFilterValues());
var g = Grid;
var allowPaging = Grid.AllowPaging;
g.AllowPaging = false;
Bind();
GenerateCSVColumns(csv);
GenerateCSVSubColumns(csv);
GenerateCSVFields(csv);
SetCsvSessionVars(csv.Build());
OpenWin(string.Concat(ApplicationPath, "Common/exportCSV.aspx"), CultureManager.GetSystemMessage("EXPORT_CSV_DATA"));
g.AllowPaging = allowPaging;
}
protected override void ExportToCsv()
{
var builder = new GridToCSVBuilder(Usuario.CsvSeparator);
var g = Grid;
g.AllowPaging = false;
g.DataSource = GetResults();
g.DataBind();
builder.GenerateHeader(CultureManager.GetMenu("COMB_CONSISTENCIA_STOCK"), GetFilterValues());
builder.GenerateColumns(/*new List<string>(),*/ g);
builder.GenerateFields(g);
builder.GenerateColumns(/*null, */ gridSubTotales);
builder.GenerateFields(gridSubTotales);
SetCsvSessionVars(builder.Build());
OpenWin(string.Concat(ApplicationPath, "Common/exportCSV.aspx"), CultureManager.GetSystemMessage("EXPORT_CSV_DATA"));
g.AllowPaging = true;
}
protected override void ExportToCsv()
{
var builder = new GridToCSVBuilder(Usuario.CsvSeparator);
var g = gridResumen;
var allowPaging = gridResumen.AllowPaging;
var distribuciones = GetDistribuciones(new[] { -1 });
var controladas = distribuciones.Where(d => d.Controlado).Select(d => new ViajeDistribucionVo(d)).ToList();
g.AllowPaging = false;
g.DataSource = controladas;
g.DataBind();
builder.GenerateHeader(CultureManager.GetMenu(VariableName), GetFilterValues());
builder.GenerateColumns(g);
builder.GenerateFields(g);
Session["CSV_EXPORT"] = builder.Build();
Session["CSV_FILE_NAME"] = CultureManager.GetMenu(Module.Name);
OpenWin(String.Concat(ApplicationPath, "Common/exportCSV.aspx"), CultureManager.GetSystemMessage("EXPORT_CSV_DATA"));
g.AllowPaging = allowPaging;
}
/// <summary>
/// Exports the Grid to CSV.
/// Cuidado con esto porque rebindea la grilla sacandole el paging.
/// </summary>
protected override void ExportToCsv()
{
var builder = new GridToCSVBuilder(Usuario.CsvSeparator);
builder.GenerateHeader(CultureManager.GetMenu("COMB_REMITOS"), GetFilterValues());
GenerateCSVBody(builder);
SetCsvSessionVars(builder.Build());
OpenWin(string.Concat(ApplicationPath, "Common/exportCSV.aspx"), CultureManager.GetSystemMessage("EXPORT_CSV_DATA"));
}
/// <summary>
/// Exports the Grid to CSV.
/// Cuidado con esto porque rebindea la grilla sacandole el paging.
/// </summary>
protected override void ExportToCsv()
{
var builder = new GridToCSVBuilder(Usuario.CsvSeparator);
builder.GenerateHeader(CultureManager.GetMenu("COMB_INGRESOS_POZO"), GetFilterValues());
GenerateCSVBody(builder);
Session["CSV_EXPORT"] = builder.Build();
Session["CSV_FILE_NAME"] = "report";
OpenWin(string.Concat(ApplicationPath, "Common/exportCSV.aspx"), CultureManager.GetSystemMessage("EXPORT_CSV_DATA"));
}
protected override void ExportToCsv()
{
var builder = new GridToCSVBuilder(Usuario.CsvSeparator);
BtnSearchClick(null, null);
builder.GenerateHeader(CultureManager.GetMenu(VariableName), GetFilterValues());
builder.GenerateColumns(gridViajes);
builder.GenerateFields(gridViajes);
SetCsvSessionVars(builder.Build());
OpenWin(String.Concat(ApplicationPath, "Common/exportCSV.aspx"), CultureManager.GetSystemMessage("EXPORT_CSV_DATA"));
}
/// <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));
}
}
}
}
/// <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>
/// Exports the Grid to CSV.
/// Cuidado con esto porque rebindea la grilla sacandole el paging.
/// </summary>
protected virtual void ExportToCsv()
{
var builder = new GridToCSVBuilder(Usuario.CsvSeparator);
var g = Grid;
var allowPaging = Grid.AllowPaging;
g.AllowPaging = false;
g.DataSource = Data;
g.DataBind();
GenerateCsvHeader(builder);
builder.GenerateColumns(/*null, */ g);
builder.GenerateFields(g);
SetCsvSessionVars(builder.Build());
OpenWin(string.Concat(ApplicationPath, "Common/exportCSV.aspx"), CultureManager.GetSystemMessage("EXPORT_CSV_DATA"));
g.AllowPaging = allowPaging;
}
/// <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>
/// Exports the Grid to CSV.
/// Cuidado con esto porque rebindea la grilla sacandole el paging.
/// </summary>
protected override void ExportToCsv()
{
var builder = new GridToCSVBuilder(Usuario.CsvSeparator);
var g = Grid;
var allowPaging = Grid.AllowPaging;
var list = GridUtils.Search(Data, SearchString);
g.AllowPaging = false;
g.DataSource = list;
g.DataBind();
builder.GenerateHeader(CultureManager.GetMenu(VariableName), GetFilterValues());
builder.GenerateColumns(g);
builder.GenerateFields(g);
SetCsvSessionVars(builder.Build());
OpenWin(String.Concat(ApplicationPath, "Common/exportCSV.aspx"), CultureManager.GetSystemMessage("EXPORT_CSV_DATA"));
g.AllowPaging = allowPaging;
}
protected override void ExportToCsv()
{
var builder = new GridToCSVBuilder(Usuario.CsvSeparator);
var g = Grid;
g.AllowPaging = false;
g.DataSource = GetResults();
g.DataBind();
builder.GenerateHeader(CultureManager.GetMenu("COMB_CONSISTENCIA_STOCK"), GetFilterValues());
builder.GenerateColumns(/*null,*/ g);
builder.GenerateFields(g);
builder.GenerateColumns(/*null,*/ gridSubTotales);
builder.GenerateFields(gridSubTotales);
Session["CSV_EXPORT"] = builder.Build();
Session["CSV_FILE_NAME"] = "report";
g.AllowPaging = true;
}
/// <summary>
/// Generates the header for the builder
/// </summary>
/// <param name="builder"></param>
protected virtual void GenerateCsvHeader(GridToCSVBuilder builder)
{
}
