public Inicio() { ElementoTipo = typeof(Lbl.Pagos.FormaDePago); TableName = "formaspago"; KeyColumn = new Lazaro.Pres.Field("formaspago.id_formapago", "Cód.", Lfx.Data.InputFieldTypes.Serial, 0); Columns = new Lazaro.Pres.FieldCollection() { new Lazaro.Pres.Field("formaspago.nombre", "Nombre", Lfx.Data.InputFieldTypes.Text, 320), new Lazaro.Pres.Field("formaspago.tipo", "Tipo", 240, new Dictionary<int, string>() { { 1, "Efectivo" }, { 2, "Cheque (propio)" }, { 3, "Cuenta corriente" }, { 4, "Tarjeta" }, { 6, "Caja" }, { 7, "Otro" }, { 8, "Cheque (terceros)" } }), new Lazaro.Pres.Field("formaspago.id_caja", "Caja", Lfx.Data.InputFieldTypes.Relation, 320), new Lazaro.Pres.Field("formaspago.descuento", "Desc./Recargo", Lfx.Data.InputFieldTypes.Numeric, 120), new Lazaro.Pres.Field("formaspago.retencion", "Retención", Lfx.Data.InputFieldTypes.Numeric, 120), new Lazaro.Pres.Field("formaspago.pagos", "Pagos", Lfx.Data.InputFieldTypes.Bool, 96), new Lazaro.Pres.Field("formaspago.cobros", "Cobros", Lfx.Data.InputFieldTypes.Bool, 96), }; OrderBy = "formaspago.nombre"; }
public Inicio() { ElementoTipo = typeof(Lbl.Bancos.Banco); TableName = "bancos"; KeyColumn = new Lazaro.Pres.Field("bancos.id_banco", "Cód.", Lfx.Data.InputFieldTypes.Serial, 0); Columns = new Lazaro.Pres.FieldCollection() { new Lazaro.Pres.Field("bancos.nombre", "Nombre", Lfx.Data.InputFieldTypes.Text, 320), new Lazaro.Pres.Field("bancos.url", "Página", Lfx.Data.InputFieldTypes.Text, 320) }; OrderBy = "bancos.nombre"; }
public Inicio() { ElementoTipo = typeof(Lbl.Impuestos.Alicuota); TableName = "alicuotas"; OrderBy = "nombre"; KeyColumn = new Lazaro.Pres.Field("id_alicuota", "Cód.", Lfx.Data.InputFieldTypes.Serial, 0); Columns = new Lazaro.Pres.FieldCollection() { new Lazaro.Pres.Field("nombre", "Nombre", Lfx.Data.InputFieldTypes.Text, 240), new Lazaro.Pres.Field("porcentaje", "Porcentaje", Lfx.Data.InputFieldTypes.Numeric, 160), new Lazaro.Pres.Field("importe_minimo", "Imp. Mín.", Lfx.Data.InputFieldTypes.Currency, 160) }; }
public Inicio() { ElementoTipo = typeof(Lbl.Pagos.Plan); TableName = "tarjetas_planes"; KeyColumn = new Lazaro.Pres.Field("tarjetas_planes.id_plan", "Cód.", Lfx.Data.InputFieldTypes.Serial, 0); Columns = new Lazaro.Pres.FieldCollection() { new Lazaro.Pres.Field("tarjetas_planes.nombre", "Nombre", Lfx.Data.InputFieldTypes.Text, 320), new Lazaro.Pres.Field("tarjetas_planes.cuotas", "Cuotas", Lfx.Data.InputFieldTypes.Integer, 96), new Lazaro.Pres.Field("tarjetas_planes.interes", "Desc./Recargo", Lfx.Data.InputFieldTypes.Numeric, 120), new Lazaro.Pres.Field("tarjetas_planes.comision", "Retención", Lfx.Data.InputFieldTypes.Numeric, 120) }; OrderBy = "tarjetas_planes.nombre"; }
private Lazaro.Pres.Spreadsheet.Row FormatRowSum(Lazaro.Pres.Spreadsheet.Sheet sheet, Lazaro.Pres.FieldCollection useFields) { Lazaro.Pres.Spreadsheet.Row Reng = new Lazaro.Pres.Spreadsheet.Row(sheet); if (this.Definicion.KeyColumn != null && this.Definicion.KeyColumn.Printable) { Lazaro.Pres.Spreadsheet.Cell KeyCell = Reng.Cells.Add(); KeyCell.Content = "-->"; } for (int FieldNum = 0; FieldNum < useFields.Count; FieldNum++) { if (useFields[FieldNum].Printable) { string FieldName = Lazaro.Orm.Data.ColumnValue.GetNameOnly(useFields[FieldNum].Name); if (FieldNum >= 0) { Lazaro.Pres.Spreadsheet.Cell NewCell = Reng.Cells.Add(); if (FieldName == "total") { NewCell.Content = totalRenglon; } else { NewCell.Content = ""; } } } } return(Reng); }
protected override Lazaro.Pres.Spreadsheet.Row FormatRow(int itemId, Lfx.Data.Row row, Lazaro.Pres.Spreadsheet.Sheet sheet, Lazaro.Pres.FieldCollection useFields) { Lazaro.Pres.Spreadsheet.Row Reng = new Lazaro.Pres.Spreadsheet.Row(sheet); if (this.Definicion.KeyColumn != null && this.Definicion.KeyColumn.Printable) { Lazaro.Pres.Spreadsheet.Cell KeyCell = Reng.Cells.Add(); KeyCell.Content = itemId; } for (int FieldNum = 0; FieldNum < useFields.Count; FieldNum++) { if (useFields[FieldNum].Printable) { string FieldName = Lazaro.Orm.Data.ColumnValue.GetNameOnly(useFields[FieldNum].Name); if (FieldNum >= 0) { Lazaro.Pres.Spreadsheet.Cell NewCell = Reng.Cells.Add(); switch (useFields[FieldNum].DataType) { case Lfx.Data.InputFieldTypes.Integer: case Lfx.Data.InputFieldTypes.Serial: if (row[FieldName] == null || row[FieldName] is DBNull) { NewCell.Content = null; } else if (useFields[FieldNum].Format != null) { NewCell.Content = System.Convert.ToInt32(row[FieldName]).ToString(useFields[FieldNum].Format); } else { NewCell.Content = row[FieldName].ToString(); } break; case Lfx.Data.InputFieldTypes.Relation: case Lfx.Data.InputFieldTypes.Text: case Lfx.Data.InputFieldTypes.Memo: if (row[FieldName] == null) { NewCell.Content = null; } else if (FieldName == "comprob.id_formapago") { Lfx.Data.Row formPago = Lfx.Workspace.Master.Tables["formaspago"].FastRows[System.Convert.ToInt32(row[FieldName])]; if (formPago != null) { NewCell.Content = formPago.Fields["nombre"].Value.ToString(); } else { NewCell.Content = row.Fields[FieldName].Value.ToString(); } } else if (row[FieldName] is System.Byte[]) { NewCell.Content = System.Text.Encoding.Default.GetString(((System.Byte[])(row[FieldName]))); } else { NewCell.Content = row.Fields[FieldName].Value.ToString(); } break; case Lfx.Data.InputFieldTypes.Currency: double ValorCur = (row[FieldName] == null || row[FieldName] is DBNull) ? 0 : System.Convert.ToDouble(row[FieldName]); NewCell.Content = ValorCur; if (FieldName == "total") { totalRenglon += ValorCur; } break; case Lfx.Data.InputFieldTypes.Numeric: if (row[FieldName] == null || row[FieldName] is DBNull) { NewCell.Content = null; } else { NewCell.Content = System.Convert.ToDouble(row[FieldName]); } break; case Lfx.Data.InputFieldTypes.Date: if (row.Fields[FieldName].Value != null) { NewCell.Content = row.Fields[FieldName].ValueDateTime; } break; case Lfx.Data.InputFieldTypes.DateTime: NewCell.Content = row[FieldName]; break; case Lfx.Data.InputFieldTypes.Bool: if (System.Convert.ToBoolean(row[FieldName])) { NewCell.Content = "Sí"; } else { NewCell.Content = "No"; } break; case Lfx.Data.InputFieldTypes.Set: int SetValue = System.Convert.ToInt32(row[FieldName]); if (useFields[FieldNum] != null && useFields[FieldNum].SetValues != null & useFields[FieldNum].SetValues.ContainsKey(SetValue)) { NewCell.Content = useFields[FieldNum].SetValues[SetValue]; } else { NewCell.Content = "???"; } break; default: NewCell.Content = row[FieldName]; break; } } } } return(Reng); }
public override Lazaro.Pres.Spreadsheet.Workbook ToWorkbook(Lazaro.Pres.FieldCollection useFields) { Lazaro.Pres.Spreadsheet.Workbook Res = new Lazaro.Pres.Spreadsheet.Workbook(); Lazaro.Pres.Spreadsheet.Sheet Sheet = new Lazaro.Pres.Spreadsheet.Sheet(this.Text); Res.Sheets.Add(Sheet); // Exporto los encabezados de columna if (this.Definicion.KeyColumn.Printable) { Sheet.ColumnHeaders.Add(new Lazaro.Pres.Spreadsheet.ColumnHeader(this.Definicion.KeyColumn.Label, this.Definicion.KeyColumn.Width)); Sheet.ColumnHeaders[0].DataType = this.Definicion.KeyColumn.DataType; Sheet.ColumnHeaders[0].Format = this.Definicion.KeyColumn.Format; Sheet.ColumnHeaders[0].Printable = this.Definicion.KeyColumn.Printable; } int OrderColumn = -1; if (useFields != null) { for (int i = 0; i <= useFields.Count - 1; i++) { if (useFields[i].Printable) { Lazaro.Pres.Spreadsheet.ColumnHeader ColHead = new Lazaro.Pres.Spreadsheet.ColumnHeader(useFields[i].Label, useFields[i].Width); ColHead.Name = Lazaro.Orm.Data.ColumnValue.GetNameOnly(useFields[i].Name); ColHead.TextAlignment = useFields[i].Alignment; ColHead.DataType = useFields[i].DataType; ColHead.Format = useFields[i].Format; ColHead.TotalFunction = useFields[i].TotalFunction; ColHead.Printable = useFields[i].Printable; Sheet.ColumnHeaders.Add(ColHead); if (ColHead.Name == this.Definicion.OrderBy) { OrderColumn = Sheet.ColumnHeaders.Count - 1; } if (ColHead.Name == this.GroupingColumnName) { Sheet.ColumnHeaders.GroupingColumn = Sheet.ColumnHeaders.Count - 1; } } } } // Exporto los renglones System.Data.DataTable Tabla = this.Connection.Select(this.SelectCommand()); int lastItemId = -1; foreach (System.Data.DataRow DtRow in Tabla.Rows) { Lfx.Data.Row Registro = (Lfx.Data.Row)DtRow; string NombreCampoId = Lazaro.Orm.Data.ColumnValue.GetNameOnly(this.Definicion.KeyColumn.Name); int ItemId = Registro.Fields[NombreCampoId].ValueInt; lastItemId = ItemId; Lazaro.Pres.Spreadsheet.Row Reng = this.FormatRow(ItemId, Registro, Sheet, useFields); Sheet.Rows.Add(Reng); } Lazaro.Pres.Spreadsheet.Row RengSum = this.FormatRowSum(Sheet, useFields); Sheet.Rows.Add(RengSum); if (OrderColumn >= 0) { if (m_GroupingColumnName != null) { Sheet.SortByGroupAndColumn(OrderColumn, true); } else { if (OrderColumn >= 0) { Sheet.Sort(OrderColumn, true); } } } //Sheet.Workbook.Sheets.Find("").Rows.tot return(Res); }
protected override Lazaro.Pres.Spreadsheet.Row FormatRow(int itemId, Lfx.Data.Row row, Lazaro.Pres.Spreadsheet.Sheet sheet, Lazaro.Pres.FieldCollection useFields) { Lazaro.Pres.Spreadsheet.Row Res = base.FormatRow(itemId, row, sheet, useFields); switch (row.Fields["tipo_fac"].ValueString) { case "NCA": case "NCB": case "NCC": case "NCE": case "NCM": row.Fields["gravado"].Value = -row.Fields["gravado"].ValueDecimal; row.Fields["total"].Value = -row.Fields["total"].ValueDecimal; break; } if (row.Fields["anulada"].ValueInt != 0) { Res.Cells[4].Content = "ANULADA"; } return(Res); }