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