private void GenerateColumns(BaseCsvBuilder builder) { builder.GenerateRow(String.Concat(Separator, Separator, Separator, Separator, CultureManager.GetLabel("TOTALES"), Separator, Separator, Separator, Separator, CultureManager.GetLabel("INFRACCIONES"))); builder.GenerateRow(String.Concat(CultureManager.GetLabel("CHOFER"), Separator, CultureManager.GetLabel("LEGAJO"), Separator, CultureManager.GetEntity("PARENTI37"), Separator, CultureManager.GetEntity("PARENTI04"), Separator, Separator, CultureManager.GetLabel("KILOMETROS"), Separator, CultureManager.GetLabel("MOVIMIENTO"), Separator, CultureManager.GetLabel("PUNTAJE"), Separator, Separator, CultureManager.GetLabel("LEVES"), Separator, CultureManager.GetLabel("MEDIAS"), Separator, CultureManager.GetLabel("GRAVES"), Separator, CultureManager.GetLabel("TOTALES"), Separator)); }
/// <summary> /// Fills the report with the Items of the grid*/ /// </summary> private void GenerateCSVFields(BaseCsvBuilder csv) { var separator = Usuario.CsvSeparator; foreach (C1GridViewRow row in Grid.Rows) { var data = string.Concat(row.Cells[0].Text, separator, row.Cells[1].Text, separator, row.Cells[2].Text, separator, row.Cells[3].Text, separator); for (var i = _PRIMER_ESTADO; i < Grid.Columns.Count; i += 3) { data = String.Concat(data, String.Format("{0}", row.Cells[i + 1].Text.Equals(_EMPTY_STRING) ? string.Concat(separator, separator, separator, separator, separator) : row.Cells[i + 1].Text)); } csv.GenerateRow(data.TrimEnd(separator)); } csv.GenerateRow(""); }
/// <summary> /// Generates the CSV data of the Stadistic Iframe. /// </summary> /// <param name="builder"></param> private void GenerateStadisticsColumns(BaseCsvBuilder builder) { if (Stadistics == null) { return; } var separator = Usuario.CsvSeparator; builder.GenerateRow(CultureManager.GetLabel("DETALLE_VEHICULO")); builder.GenerateRow(String.Concat(CultureManager.GetLabel("RECORRIDO"), separator, CultureManager.GetLabel("TOTAL"), ":", Stadistics.KilometrosTotales, separator, CultureManager.GetLabel("PROMEDIO_DIARIO"), ":", Stadistics.KilometrosPromedio, separator)); builder.GenerateRow(String.Concat(CultureManager.GetLabel("DIAS"), separator, CultureManager.GetLabel("TOTALES"), ":", Stadistics.Dias, separator, CultureManager.GetLabel("CON_ACTIVIDAD"), ":", Stadistics.DiasActivo, separator, CultureManager.GetLabel("SIN_ACTIVIDAD"), ":", Stadistics.Dias - Stadistics.DiasActivo, separator)); builder.GenerateRow(String.Concat(CultureManager.GetLabel("VELOCIDAD"), separator, CultureManager.GetLabel("MAXIMA_ALCANZADA"), ":", Stadistics.VelocidadMaxima, separator, CultureManager.GetLabel("PROMEDIO"), ":", Stadistics.VelocidadPromedio, separator)); builder.GenerateRow(String.Concat(CultureManager.GetLabel("TIEMPOS"), separator, CultureManager.GetLabel("MOVIMIENTO"), ":", Stadistics.HorasMovimiento, separator, CultureManager.GetLabel("DETENCION"), ":", Stadistics.HorasDetenido, separator, CultureManager.GetLabel("SIN_REPORTAR"), ":", Stadistics.HorasSinReportar, separator)); builder.GenerateRow(String.Concat(CultureManager.GetLabel("INFRACCIONES"), separator, CultureManager.GetLabel("CANTIDAD"), ":", Stadistics.Infracciones, separator, CultureManager.GetLabel("TIEMPO"), ":", Stadistics.HsInfraccion, separator)); builder.GenerateRow(""); }
protected override void ExportToCsv() { var builder = new BaseCsvBuilder(Usuario.CsvSeparator); GenerateCsvHeader(builder); GenerateColumns(builder); GenerateFields(builder); builder.GenerateRow(string.Empty); builder.GenerateRow(CultureManager.GetLabel("TOTALES")); builder.GenerateRow(string.Format(CultureManager.GetLabel("PONDERACION_GRAVES_RANKING"), TransportistasGraves)); builder.GenerateRow(string.Format(CultureManager.GetLabel("PONDERACION_MEDIAS_RANKING"), TransportistasMedios)); builder.GenerateRow(string.Format(CultureManager.GetLabel("PONDERACION_LEVES_RANKING"), TransportistasLeves)); SetCsvSessionVars(builder.Build()); OpenWin(string.Concat(ApplicationPath, "Common/exportCSV.aspx"), CultureManager.GetSystemMessage("EXPORT_CSV_DATA")); }
/// <summary> /// Generates the CSV data of the Mobiles Iframe. /// </summary> /// <param name="builder"></param> private void GenerateOperatorsColumns(BaseCsvBuilder builder) { if (MobileDrivers == null) { return; } var separator = Usuario.CsvSeparator; builder.GenerateRow(CultureManager.GetEntity("PARENTI09")); builder.GenerateRow(String.Concat(CultureManager.GetLabel("LEGAJO"), separator, CultureManager.GetLabel("NAME"), separator, CultureManager.GetEntity("TARJETA"), separator, CultureManager.GetLabel("INFRACCIONES"), separator, CultureManager.GetLabel("KILOMETROS"), separator, CultureManager.GetLabel("MOVIMIENTO"), separator)); foreach (var o in MobileDrivers) { builder.GenerateRow(String.Concat(o.Legajo, separator, o.Nombre, separator, o.Tarjeta, separator, o.Infracciones, separator, o.Kilometros, separator, o.TiempoConduccion, separator)); } }
private void GenerateMobilesColumns(BaseCsvBuilder builder) { if (OperatorMobiles == null) { return; } var separator = Usuario.CsvSeparator; builder.GenerateRow(CultureManager.GetEntity("PARENTI03")); builder.GenerateRow(String.Concat(CultureManager.GetLabel("PATENTE"), separator, CultureManager.GetLabel("INTERNO"), separator, CultureManager.GetLabel("INFRACCIONES"), separator, CultureManager.GetLabel("KILOMETROS"), separator, CultureManager.GetLabel("TIEMPO_CONDUCCION"), separator)); foreach (var o in OperatorMobiles) { builder.GenerateRow(String.Concat(o.Patente, separator, o.Interno, separator, o.Infracciones, separator, o.Kilometros, separator, o.Movimiento, separator)); } }
private void GenerateMaximumSpeedColumns(BaseCsvBuilder builder) { if (ReportObjectsList == null) { return; } var separator = Usuario.CsvSeparator; builder.GenerateRow(CultureManager.GetLabel("MAXIMAS_DIARIAS")); builder.GenerateRow(String.Concat(CultureManager.GetLabel("DIA"), separator, CultureManager.GetLabel("VELOCIDAD"), separator, CultureManager.GetLabel("ALCANZADA_POR"), separator)); foreach (var o in ReportObjectsList) { builder.GenerateRow(String.Concat(o.Dia, separator, o.Velocidad, separator, o.CometidoPor, separator)); } builder.GenerateRow(string.Empty); }
/// <summary> /// Generates the sub-columns Programado,Manual y Automatico /// </summary> /// <param name="csv"></param> private void GenerateCSVSubColumns(BaseCsvBuilder csv) { var separator = Usuario.CsvSeparator; var subheaders = string.Concat(separator, separator, separator, separator); for (var i = _PRIMER_ESTADO; i < Grid.Columns.Count; i += 3) { subheaders = String.Concat(subheaders, "Programado", separator, "Manual", separator, "Dif.Manual", separator, "Automatico", separator, "Dif.Automatico", separator); } csv.GenerateRow(subheaders); }
private void GenerateColumns(BaseCsvBuilder builder) { builder.GenerateRow(String.Concat(CultureManager.GetEntity("PARENTI07"), Separator, CultureManager.GetMenu("PAR_VEHICULOS"), Separator, CultureManager.GetLabel("KILOMETROS"), Separator, CultureManager.GetLabel("MOVIMIENTO"), Separator, CultureManager.GetLabel("PUNTAJE"), Separator, CultureManager.GetLabel("LEVES"), Separator, CultureManager.GetLabel("MEDIAS"), Separator, CultureManager.GetLabel("GRAVES"), Separator, CultureManager.GetLabel("TOTALES"), Separator)); }
/// <summary> /// Generates the columns of the report*/ /// </summary> private void GenerateCSVColumns(BaseCsvBuilder csv) { var separator = Usuario.CsvSeparator; var headers = string.Concat("Ticket", separator, "Interno", separator, "Transportista", separator, "Fecha"); for (var i = _PRIMER_ESTADO; i < Grid.Columns.Count; i += 3) { var str = Grid.Columns[i].HeaderText; var columName = str.Remove(str.IndexOf('<')); /*removes the html used in the grid*/ headers = String.Concat(headers, string.Concat(separator, columName, separator, separator, separator, separator)); } csv.GenerateRow(headers); }
private void GenerateFields(BaseCsvBuilder builder) { foreach (var o in GetResults()) { var str = string.Concat(o.Transportista, Separator, o.Vehiculos, Separator, string.Format("{0:F}", o.Kilometros), Separator, string.Format("{0:00}.{1:00}:{2:00}:{3:00}", o.HorasMovimiento.Days, o.HorasMovimiento.Hours, o.HorasMovimiento.Minutes, o.HorasMovimiento.Seconds), Separator, string.Format("{0:F}", o.Puntaje), Separator, o.InfraccionesLeves, Separator, o.InfraccionesMedias, Separator, o.InfraccionesGraves, Separator, o.InfraccionesTotales); builder.GenerateRow(str); } }
private void GenerateFields(BaseCsvBuilder builder) { foreach (var o in GetResults()) { var str = String.Concat(o.Operador, Separator, o.Legajo, Separator, o.CentroCosto, Separator, o.Departamento, Separator, Separator, String.Format("{0:F}", o.Kilometros), Separator, String.Format("{0:00}.{1:00}:{2:00}:{3:00}", o.HorasMovimiento.Days, o.HorasMovimiento.Hours, o.HorasMovimiento.Minutes, o.HorasMovimiento.Seconds), Separator, String.Format("{0:F}", o.Puntaje), Separator, Separator, o.InfraccionesLeves, Separator, o.InfraccionesMedias, Separator, o.InfraccionesGraves, Separator, o.InfraccionesTotales); builder.GenerateRow(str); } }