public override void OnFiltersChanged(Lazaro.Pres.Filters.FilterCollection filters) { this.CustomFilters.Clear(); if (((Lazaro.Pres.Filters.SetFilter)(filters["pvs.tipo"])).CurrentValue != "*") CustomFilters.AddWithValue("pvs.tipo", Lfx.Types.Parsing.ParseInt(filters[0].Value.ToString())); base.OnFiltersChanged(filters); }
public override void OnFiltersChanged(Lazaro.Pres.Filters.FilterCollection filters) { this.CustomFilters.Clear(); if (((Lazaro.Pres.Filters.SetFilter)(filters["articulos_categorias.cache_stock_actual"])).CurrentValue == "f") CustomFilters.AddWithValue("articulos_categorias.stock_minimo>0 AND articulos_categorias.stock_minimo>(SELECT SUM(articulos.stock_actual) FROM articulos WHERE articulos_categorias.id_categoria=id_categoria)"); base.OnFiltersChanged(filters); }
public ImpresorListado(Lazaro.Pres.Spreadsheet.Sheet sheet, IDbTransaction transaction) : base(transaction) { this.Sheet = sheet; // Calculo el ancho de todas las columnas HeaderTotalWidth = 0; for (int i = 0; i < Sheet.ColumnHeaders.Count; i++) { if (i != this.Sheet.ColumnHeaders.DetailColumn && this.Sheet.ColumnHeaders[i].Printable) HeaderTotalWidth += Sheet.ColumnHeaders[i].Width; } this.DefaultPageSettings.Landscape = HeaderTotalWidth > 1600; this.DefaultPageSettings.Margins = new System.Drawing.Printing.Margins((int)(10 * mm), (int)(10 * mm), (int)(10 * mm), (int)(10 * mm)); }
public void FromSheet(Lazaro.Pres.Spreadsheet.Sheet sheet) { this.SuspendLayout(); this.BeginUpdate(); this.Items.Clear(); this.View = System.Windows.Forms.View.Details; this.FullRowSelect = true; this.GridLines = true; this.Groups.Clear(); if (sheet.BackColor != System.Drawing.Color.Empty) this.BackColor = sheet.BackColor; if (sheet.ForeColor != System.Drawing.Color.Empty) this.ForeColor = sheet.ForeColor; if (sheet.ColumnHeaders != null) { this.Columns.Clear(); foreach (Lazaro.Pres.Spreadsheet.ColumnHeader ch in sheet.ColumnHeaders) { System.Windows.Forms.ColumnHeader Col = this.Columns.Add(ch.Text, ch.Width); switch (ch.TextAlignment) { case Lfx.Types.StringAlignment.Near: Col.TextAlign = System.Windows.Forms.HorizontalAlignment.Left; break; case Lfx.Types.StringAlignment.Far: Col.TextAlign = System.Windows.Forms.HorizontalAlignment.Right; break; } } } System.Windows.Forms.ListViewGroup LastGroup = null; foreach (Lazaro.Pres.Spreadsheet.Row rw in sheet.Rows) { if (rw is Lazaro.Pres.Spreadsheet.HeaderRow) { LastGroup = new System.Windows.Forms.ListViewGroup(rw.Cells[0].Content.ToString()); this.Groups.Add(LastGroup); } else { System.Windows.Forms.ListViewItem Itm = new System.Windows.Forms.ListViewItem(); if (rw is Lazaro.Pres.Spreadsheet.AggregationRow) { //Itm.BackColor = System.Drawing.Color.LightGray; Itm.Font = new System.Drawing.Font(Itm.Font, System.Drawing.FontStyle.Bold); } if (LastGroup != null) { Itm.Group = LastGroup; } if (rw.BackColor != System.Drawing.Color.Empty) Itm.BackColor = rw.BackColor; if (rw.ForeColor != System.Drawing.Color.Empty) Itm.ForeColor = rw.ForeColor; int i = 0; foreach (Lazaro.Pres.Spreadsheet.Cell cl in rw.Cells) { string CellString = ""; if (cl.Content != null) { switch (cl.Content.GetType().ToString()) { case "System.Single": case "System.Double": case "System.Decimal": CellString += Lfx.Types.Formatting.FormatNumber(System.Convert.ToDecimal(cl.Content), 4); break; case "System.Integer": case "System.Int16": case "System.Int32": case "System.Int64": CellString += cl.Content.ToString(); break; case "System.DateTime": DateTime clContent = (DateTime)cl.Content; if (clContent.Hour == 0 && clContent.Minute == 0 && clContent.Second == 0) CellString += clContent.ToString(Lfx.Types.Formatting.DateTime.ShortDatePattern); else CellString += clContent.ToString(Lfx.Types.Formatting.DateTime.FullDateTimePattern); break; case "System.String": CellString += cl.Content.ToString(); break; } } if (i == 0) Itm.Text = CellString; else Itm.SubItems.Add(CellString); i++; } this.Items.Add(Itm); } } this.EndUpdate(); this.ResumeLayout(); }
public static Lui.Forms.ListView NewListViewFromSheet(Lazaro.Pres.Spreadsheet.Sheet sheet) { Lui.Forms.ListView Result = new Lui.Forms.ListView(); Result.HeaderStyle = System.Windows.Forms.ColumnHeaderStyle.Nonclickable; Result.LabelEdit = false; Result.LabelWrap = false; Result.FromSheet(sheet); return Result; }
public void FromFilters(Lazaro.Pres.Filters.FilterCollection filters) { this.SuspendLayout(); this.TablaFiltros.SuspendLayout(); this.ColFiltros = filters; this.TablaFiltros.RowCount = filters.Count; while (TablaFiltros.RowStyles.Count < TablaFiltros.RowCount) TablaFiltros.RowStyles.Add(new System.Windows.Forms.RowStyle(SizeType.AutoSize)); int i = 0; foreach (Lazaro.Pres.Filters.IFilter Filtro in this.ColFiltros) { Label Etiqueta = new Label(); Etiqueta.Name = "etiqueta" + i.ToString(); Etiqueta.Text = Filtro.Label; Etiqueta.TextAlign = System.Drawing.ContentAlignment.TopLeft; Etiqueta.Margin = new System.Windows.Forms.Padding(0, 4, 4, 0); Etiqueta.Dock = DockStyle.Fill; this.TablaFiltros.Controls.Add(Etiqueta, 0, i); Control Entrada; if (Filtro is Lazaro.Pres.Filters.NumericRangeFilter) { Lcc.Entrada.RangoNumerico EntradaRangoNumerico = new Lcc.Entrada.RangoNumerico(); Lazaro.Pres.Filters.NumericRangeFilter FiltroNumerico = Filtro as Lazaro.Pres.Filters.NumericRangeFilter; EntradaRangoNumerico.DecimalPlaces = FiltroNumerico.DecimalPlaces; EntradaRangoNumerico.Valule1 = System.Convert.ToDecimal(FiltroNumerico.Value); EntradaRangoNumerico.Valule2 = System.Convert.ToDecimal(FiltroNumerico.Value2); EntradaRangoNumerico.Dock = DockStyle.Top; Entrada = EntradaRangoNumerico; } else if (Filtro is Lazaro.Pres.Filters.SetFilter) { Lazaro.Pres.Filters.SetFilter FiltroSet = Filtro as Lazaro.Pres.Filters.SetFilter; Lui.Forms.ComboBox EntradaSet = new Lui.Forms.ComboBox(); EntradaSet.SetData = FiltroSet.SetData; EntradaSet.TextKey = FiltroSet.CurrentValue; EntradaSet.Size = new System.Drawing.Size(200, 24); EntradaSet.AlwaysExpanded = EntradaSet.SetData != null && (EntradaSet.SetData.Length <= 4 || TablaFiltros.RowCount <= 6); EntradaSet.AutoSize = EntradaSet.AlwaysExpanded; EntradaSet.Dock = DockStyle.Top; Entrada = EntradaSet; } else if (Filtro is Lazaro.Pres.Filters.DateRangeFilter) { Lazaro.Pres.Filters.DateRangeFilter FiltroFechas = Filtro as Lazaro.Pres.Filters.DateRangeFilter; Lcc.Entrada.RangoFechas EntradaRangoFechas = new Lcc.Entrada.RangoFechas(); EntradaRangoFechas.Rango = FiltroFechas.DateRange; EntradaRangoFechas.Size = new System.Drawing.Size(160, 46); EntradaRangoFechas.AutoSize = true; EntradaRangoFechas.Dock = DockStyle.Top; Entrada = EntradaRangoFechas; } else if (Filtro is Lazaro.Pres.Filters.RelationFilter) { Lazaro.Pres.Filters.RelationFilter FiltroRelacion = Filtro as Lazaro.Pres.Filters.RelationFilter; Lcc.Entrada.CodigoDetalle EntradaRelacion = new Lcc.Entrada.CodigoDetalle(); EntradaRelacion.Required = false; EntradaRelacion.Size = new System.Drawing.Size(160, 24); EntradaRelacion.Relation = FiltroRelacion.Relation; if (FiltroRelacion.Filter != null) EntradaRelacion.Filter = FiltroRelacion.Filter.ToString(); EntradaRelacion.Elemento = (Lbl.IElementoDeDatos)FiltroRelacion.Elemento; EntradaRelacion.Dock = DockStyle.Top; Entrada = EntradaRelacion; } else { Entrada = new Label(); Entrada.Text = Filtro.GetType().ToString(); Etiqueta.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; } Entrada.Name = "entrada" + i.ToString(); Filtro.Control = Entrada; this.TablaFiltros.Controls.Add(Entrada, 1, i); i++; } this.TablaFiltros.ResumeLayout(); this.ResumeLayout(); }
public virtual void OnFiltersChanged(Lazaro.Pres.Filters.FilterCollection filters) { }
private string FormatValue(object cellValue, Lazaro.Pres.Field formField) { string FieldValueAsText; if (cellValue == null) return ""; if (formField == null) return cellValue.ToString(); switch (formField.DataType) { case Lfx.Data.InputFieldTypes.Integer: case Lfx.Data.InputFieldTypes.Serial: if (cellValue == null || cellValue is DBNull) FieldValueAsText = ""; else if (formField.Format != null) FieldValueAsText = Lfx.Types.Parsing.ParseInt(cellValue.ToString()).ToString(formField.Format); else FieldValueAsText = Lfx.Types.Parsing.ParseInt(cellValue.ToString()).ToString(); break; case Lfx.Data.InputFieldTypes.Text: case Lfx.Data.InputFieldTypes.Memo: case Lfx.Data.InputFieldTypes.Relation: if (cellValue == null) FieldValueAsText = ""; else if (cellValue is System.Byte[]) FieldValueAsText = System.Text.Encoding.Default.GetString(((System.Byte[])(cellValue))); else FieldValueAsText = cellValue.ToString(); break; case Lfx.Data.InputFieldTypes.Currency: decimal ValorCur = (cellValue == null || cellValue is DBNull) ? 0 : System.Convert.ToDecimal(cellValue); if (ValorCur == 0) FieldValueAsText = "-"; else FieldValueAsText = Lfx.Types.Formatting.FormatCurrency(ValorCur, Lfx.Workspace.Master.CurrentConfig.Moneda.Decimales); break; case Lfx.Data.InputFieldTypes.Numeric: if (cellValue == null || cellValue is DBNull) FieldValueAsText = ""; else FieldValueAsText = Lfx.Types.Formatting.FormatNumber(System.Convert.ToDecimal(cellValue), 2); break; case Lfx.Data.InputFieldTypes.Date: if (cellValue != null) { if (formField.Format != null) FieldValueAsText = System.Convert.ToDateTime(cellValue).ToString(formField.Format).ToTitleCase(); else FieldValueAsText = System.Convert.ToDateTime(cellValue).ToString(Lfx.Types.Formatting.DateTime.ShortDatePattern); } else { FieldValueAsText = ""; } break; case Lfx.Data.InputFieldTypes.DateTime: if (cellValue != null) { if (formField.Format != null) FieldValueAsText = System.Convert.ToDateTime(cellValue).ToString(formField.Format).ToTitleCase(); else FieldValueAsText = System.Convert.ToDateTime(cellValue).ToString(Lfx.Types.Formatting.DateTime.FullDateTimePattern); } else { FieldValueAsText = ""; } break; case Lfx.Data.InputFieldTypes.YearMonth: if (cellValue != null) { if (formField.Format != null) FieldValueAsText = System.Convert.ToDateTime(cellValue).ToString(formField.Format).ToTitleCase(); else FieldValueAsText = System.Convert.ToDateTime(cellValue).ToString(Lfx.Types.Formatting.DateTime.ShortMonthAndYearPattern); } else { FieldValueAsText = ""; } break; case Lfx.Data.InputFieldTypes.Bool: if (System.Convert.ToBoolean(cellValue)) FieldValueAsText = "Sí"; else FieldValueAsText = "No"; break; case Lfx.Data.InputFieldTypes.Set: int SetValue = System.Convert.ToInt32(cellValue); if (formField != null && formField.SetValues != null & formField.SetValues.ContainsKey(SetValue)) FieldValueAsText = formField.SetValues[SetValue]; else FieldValueAsText = "???"; break; default: switch (cellValue.GetType().ToString()) { case "System.Single": case "System.Double": if (System.Convert.ToDouble(cellValue) == 0) FieldValueAsText = "-"; else FieldValueAsText = Lfx.Types.Formatting.FormatNumber(System.Convert.ToDecimal(cellValue), 2); break; case "System.Decimal": if (System.Convert.ToDecimal(cellValue) == 0) FieldValueAsText = "-"; else FieldValueAsText = Lfx.Types.Formatting.FormatNumber(System.Convert.ToDecimal(cellValue), 4); break; case "System.Integer": case "System.Int16": case "System.Int32": case "System.Int64": if (System.Convert.ToInt32(cellValue) == 0) FieldValueAsText = "-"; else FieldValueAsText = Lfx.Types.Formatting.FormatNumber(System.Convert.ToDecimal(cellValue), 0); break; case "System.DateTime": FieldValueAsText = Lfx.Types.Formatting.FormatDate(cellValue); break; case "System.String": FieldValueAsText = System.Convert.ToString(cellValue); break; case "System.Byte[]": FieldValueAsText = System.Text.Encoding.Default.GetString((byte[])cellValue); break; case "System.DBNull": FieldValueAsText = ""; break; default: FieldValueAsText = cellValue.ToString(); break; } break; } return FieldValueAsText; }
public void FromSection(Lazaro.Pres.Forms.Section section) { this.EliminarCampos(); this.Text = section.Label; foreach (Lazaro.Pres.Field Fld in section.Fields) { Lui.Forms.EditableControl Ctrl; switch (Fld.DataType) { case Lfx.Data.InputFieldTypes.Bool: Lui.Forms.YesNo BoolField = new Lui.Forms.YesNo(); //BoolField.SetData = new string[] { "Sí|1", "No|0" }; //BoolField.AlwaysExpanded = false; //BoolField.AutoSize = false; BoolField.Value = m_Elemento.GetFieldValue<bool>(Fld.Name); Ctrl = BoolField; break; case Lfx.Data.InputFieldTypes.Set: Lui.Forms.ComboBox SetField = new Lui.Forms.ComboBox(); SetField.FromDictionary(Fld.SetValues); SetField.TextKey = m_Elemento.GetFieldValue<string>(Fld.Name); SetField.AlwaysExpanded = true; SetField.AutoSize = true; Ctrl = SetField; break; case Lfx.Data.InputFieldTypes.Relation: Entrada.CodigoDetalle RelationField = new Entrada.CodigoDetalle(); RelationField.Relation = Fld.Relation; RelationField.ValueInt = m_Elemento.GetFieldValue<int>(Fld.Name); RelationField.PlaceholderText = Fld.Label; RelationField.Required = false; RelationField.ElementoTipo = Fld.LblType; Ctrl = RelationField; break; default: Lui.Forms.TextBox TextField = new Lui.Forms.TextBox(); switch (Fld.DataType) { case Lfx.Data.InputFieldTypes.Currency: TextField.DataType = Lui.Forms.DataTypes.Currency; TextField.ValueDecimal = m_Elemento.GetFieldValue<decimal>(Fld.Name); break; case Lfx.Data.InputFieldTypes.Date: TextField.DataType = Lui.Forms.DataTypes.Date; TextField.Text = m_Elemento.GetFieldValue<DateTime>(Fld.Name).ToString(Lfx.Types.Formatting.DateTime.ShortDatePattern); break; case Lfx.Data.InputFieldTypes.DateTime: TextField.DataType = Lui.Forms.DataTypes.DateTime; TextField.Text = m_Elemento.GetFieldValue<DateTime>(Fld.Name).ToString(Lfx.Types.Formatting.DateTime.FullDateTimePattern); break; case Lfx.Data.InputFieldTypes.Numeric: TextField.DataType = Lui.Forms.DataTypes.Float; TextField.ValueDecimal = m_Elemento.GetFieldValue<decimal>(Fld.Name); break; case Lfx.Data.InputFieldTypes.Integer: TextField.DataType = Lui.Forms.DataTypes.Integer; TextField.ValueInt = m_Elemento.GetFieldValue<int>(Fld.Name); break; case Lfx.Data.InputFieldTypes.Text: TextField.Text = m_Elemento.GetFieldValue<string>(Fld.Name); break; case Lfx.Data.InputFieldTypes.Memo: TextField.MultiLine = true; TextField.Size = new Size(this.FieldContainer.ClientSize.Width, 72); TextField.Text = m_Elemento.GetFieldValue<string>(Fld.Name); break; } TextField.PlaceholderText = Fld.Label; Ctrl = TextField; break; } Ctrl.ReadOnly = Fld.ReadOnly; if (Ctrl.Size == System.Drawing.Size.Empty) Ctrl.Size = new Size(this.FieldContainer.ClientSize.Width, 24); Ctrl.Anchor = AnchorStyles.Top | AnchorStyles.Right | AnchorStyles.Top; Ctrl.FieldName = Fld.Name; this.AgregarCampo(Fld.Label, Ctrl); } }
public void ConFiscal_EventoConexion(object sender, Lazaro.Impresion.Comprobantes.Fiscal.ImpresoraEventArgs e) { UltimoEvento = e; switch (e.EventType) { case Lazaro.Impresion.Comprobantes.Fiscal.ImpresoraEventArgs.EventTypes.Inicializada: FormEstado.MostrarEstado("Inicializado"); break; case Lazaro.Impresion.Comprobantes.Fiscal.ImpresoraEventArgs.EventTypes.Estado: FormEstado.MostrarEstado(e.MensajeEstado); break; case Lazaro.Impresion.Comprobantes.Fiscal.ImpresoraEventArgs.EventTypes.InicioImpresion: FormEstado.MostrarEstado("Se inició el proceso de impresión"); break; case Lazaro.Impresion.Comprobantes.Fiscal.ImpresoraEventArgs.EventTypes.FinImpresion: FormEstado.MostrarEstado("Finalizó el proceso de impresión"); break; } }
public override void OnFiltersChanged(Lazaro.Pres.Filters.FilterCollection filters) { if (Lbl.Sys.Config.Actual.UsuarioConectado.TienePermiso(typeof(Lbl.CuentasCorrientes.CuentaCorriente), Lbl.Sys.Permisos.Operaciones.Ver)) { this.Cliente = filters["ctacte.id_cliente"].Value as Lbl.Personas.Persona; } Tipo = System.Convert.ToInt32(((Lazaro.Pres.Filters.SetFilter)(filters["personas.tipo"])).Value); Grupo = ((Lazaro.Pres.Filters.RelationFilter)(filters["personas.id_grupo"])).Elemento as Lbl.Personas.Grupo; Localidad = ((Lazaro.Pres.Filters.RelationFilter)(filters["personas.id_ciudad"])).Elemento as Lbl.Entidades.Localidad; Fechas = ((Lazaro.Pres.Filters.DateRangeFilter)(filters["ctacte.fecha"])).DateRange; base.OnFiltersChanged(filters); }
public override void OnFiltersChanged(Lazaro.Pres.Filters.FilterCollection filters) { this.Tipo = this.Definicion.Filters["comprob.tipo_fac"].Value as string; this.Estado = Lfx.Types.Parsing.ParseInt(this.Definicion.Filters["comprob.estado"].Value as string); this.Proveedor = this.Definicion.Filters["comprob.id_cliente"].Value as Lbl.Personas.Persona; this.Fechas = this.Definicion.Filters["comprob.fecha"].Value as Lfx.Types.DateRange; base.OnFiltersChanged(filters); }
public override void OnFiltersChanged(Lazaro.Pres.Filters.FilterCollection filters) { this.Tipo = Lfx.Types.Parsing.ParseInt(this.Definicion.Filters["personas.tipo"].Value as string); this.Grupo = this.Definicion.Filters["personas.id_grupo"].Value as Lbl.Personas.Grupo; this.SubGrupo = this.Definicion.Filters["personas.id_subgrupo"].Value as Lbl.Personas.Grupo; this.Localidad = this.Definicion.Filters["personas.id_ciudad"].Value as Lbl.Entidades.Localidad; this.Estado = Lfx.Types.Parsing.ParseInt(this.Definicion.Filters["personas.estado"].Value as string); this.EstadoCredito = Lfx.Types.Parsing.ParseInt(this.Definicion.Filters["personas.estadocredito"].Value as string); this.FechaAlta = this.Definicion.Filters["personas.fechaalta"].Value as Lfx.Types.DateRange; this.FechaBaja = this.Definicion.Filters["personas.fechabaja"].Value as Lfx.Types.DateRange; base.OnFiltersChanged(filters); }
public override void OnFiltersChanged(Lazaro.Pres.Filters.FilterCollection filters) { this.Cliente = this.Definicion.Filters["tickets.id_persona"].Value as Lbl.Personas.Persona; this.Tipo = this.Definicion.Filters["tickets.id_tipo_ticket"].Value as Lbl.Tareas.Tipo; this.Localidad = this.Definicion.Filters["personas.id_ciudad"].Value as Lbl.Entidades.Localidad; this.Estado = this.Definicion.Filters["tickets.estado"].Value as string; this.Definicion.OrderBy = this.Definicion.Filters["ORDER BY"].Value as string; base.OnFiltersChanged(filters); }
public void FromFilters(Lazaro.Pres.Filters.FilterCollection filtros) { this.ControlFiltros.FromFilters(filtros); }
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; }
private void MostrarErrorFiscal(Lazaro.Impresion.Comprobantes.Fiscal.Respuesta Res) { FormError FormFiscalError = new FormError(); FormFiscalError.Mostrar(Res); FormFiscalError.ShowDialog(); }
private void PrintRow(PrintPageEventArgs e, Lazaro.Pres.Spreadsheet.Row row) { Graphics g = e.Graphics; float CursorX = BodyRect.Left; float ThisRowHeight = RowHeight; // Imprimo primero la columna de detalle principal if (this.Sheet.ColumnHeaders.DetailColumn >= 0) { ThisRowHeight = RowHeight / 2; RectangleF ChRect = new RectangleF(CursorX, CursorY, BodyRect.Width, RowHeight / 2); g.DrawString(row.Cells[this.Sheet.ColumnHeaders.DetailColumn].ToString(), new Font(RowFont, FontStyle.Bold), Brushes.Black, ChRect, ColumnFormats[this.Sheet.ColumnHeaders.DetailColumn]); CursorY += ThisRowHeight; } for (int i = 0; i < row.Cells.Count; i++) { if (i != this.Sheet.ColumnHeaders.DetailColumn && this.Sheet.ColumnHeaders[i].Printable) { RectangleF ChRect = new RectangleF(CursorX, CursorY, ColumnWidths[i], ThisRowHeight); g.DrawString(row.Cells[i].ToString(), RowFont, Brushes.Black, ChRect, ColumnFormats[i]); g.DrawLine(Pens.LightGray, ChRect.X, ChRect.Bottom, ChRect.Right, ChRect.Bottom); CursorX += ColumnWidths[i]; } } CursorY += ThisRowHeight; }
public FormularioListado(Lazaro.Pres.Listings.Listing definicion) : this() { this.Definicion = definicion; }
protected virtual 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 = Lfx.Data.Field.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 (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; 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 void OnFiltersChanged(Lazaro.Pres.Filters.FilterCollection filters) { this.Caja = this.Definicion.Filters["cajas_movim.id_caja"].Value as Lbl.Cajas.Caja; this.Cliente = this.Definicion.Filters["cajas_movim.id_cliente"].Value as Lbl.Personas.Persona; this.Concepto = this.Definicion.Filters["cajas_movim.id_concepto"].Value as Lbl.Cajas.Concepto; TipoConcepto = Lfx.Types.Parsing.ParseInt(this.Definicion.Filters["conceptos.grupo"].Value.ToString()); Direccion = Lfx.Types.Parsing.ParseInt(this.Definicion.Filters["conceptos.es"].Value.ToString()); this.Fechas = this.Definicion.Filters["cajas_movim.fecha"].Value as Lfx.Types.DateRange; BotonArqueo.Visible = !(this.Caja == null || this.Cliente != null || Concepto != null || Direccion != 0 || this.Fechas.To < System.DateTime.Now); base.OnFiltersChanged(filters); }
public virtual 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 = Lfx.Data.Field.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()); foreach (System.Data.DataRow DtRow in Tabla.Rows) { Lfx.Data.Row Registro = (Lfx.Data.Row)DtRow; string NombreCampoId = Lfx.Data.Field.GetNameOnly(this.Definicion.KeyColumn.Name); int ItemId = Registro.Fields[NombreCampoId].ValueInt; Lazaro.Pres.Spreadsheet.Row Reng = this.FormatRow(ItemId, Registro, Sheet, useFields); Sheet.Rows.Add(Reng); } if (OrderColumn >= 0) { if (m_GroupingColumnName != null) { Sheet.SortByGroupAndColumn(OrderColumn, true); } else { if (OrderColumn >= 0) Sheet.Sort(OrderColumn, true); } } return Res; }
internal void Mostrar(Lazaro.Impresion.Comprobantes.Fiscal.Respuesta Res) { switch (Res.Error) { case Lazaro.Impresion.Comprobantes.Fiscal.ErroresFiscales.Ok: EtiquetaError.Text = "OK???"; break; case Lazaro.Impresion.Comprobantes.Fiscal.ErroresFiscales.ErrorBCC: EtiquetaError.Text = "BCC"; break; case Lazaro.Impresion.Comprobantes.Fiscal.ErroresFiscales.Error: EtiquetaError.Text = "Error genérico"; break; case Lazaro.Impresion.Comprobantes.Fiscal.ErroresFiscales.ErrorFiscal: EtiquetaError.Text = "Error fiscal"; break; case Lazaro.Impresion.Comprobantes.Fiscal.ErroresFiscales.ErrorImpresora: EtiquetaError.Text = "Error impresora"; break; case Lazaro.Impresion.Comprobantes.Fiscal.ErroresFiscales.NAK: EtiquetaError.Text = "NAK"; break; case Lazaro.Impresion.Comprobantes.Fiscal.ErroresFiscales.TimeOut: EtiquetaError.Text = "Timeout"; break; } EtiquetaLugar.Text = Res.Lugar; EtiquetaMensaje.Text = Res.Mensaje; EtiquetaComando.Text = Res.CodigoComando.ToString(); if (Res.Campos != null) EtiquetaCampos.Text = string.Join(Environment.NewLine, Res.Campos.ToArray()); EtiquetaEstadoImpresora.Text = Res.ExplicarEstadoImpresora(); EtiquetaEstadoFiscal.Text = Res.ExplicarEstadoFiscal(); CancelCommandButton.Visible = false; }
private string ExplicarFiltros(Lazaro.Pres.Filters.FilterCollection filters) { System.Text.StringBuilder Res = new System.Text.StringBuilder(); foreach (Lazaro.Pres.Filters.IFilter filter in filters) { if (filter is Lazaro.Pres.Filters.RelationFilter) { if (filter.Value != null) Res.Append(", " + filter.Label + " es " + filter.Value.ToString()); } else if (filter is Lazaro.Pres.Filters.NumericRangeFilter) { if (Lfx.Types.Parsing.ParseDecimal(filter.Value as string) != 0) Res.Append(", " + filter.Label + " es " + filter.Value.ToString()); } else if (filter is Lazaro.Pres.Filters.DateRangeFilter) { Lfx.Types.DateRange Rng = filter.Value as Lfx.Types.DateRange; if (Rng != null && Rng.HasRange) Res.Append(", " + filter.Label + " es " + Rng.ToString()); } else if (filter is Lazaro.Pres.Filters.SetFilter) { if (Lfx.Types.Parsing.ParseDecimal(filter.Value as string) > 0) Res.Append(", " + filter.Label + " es " + filter.Value.ToString()); } } return Res.ToString(); }
public override void OnFiltersChanged(Lazaro.Pres.Filters.FilterCollection filters) { m_Rubro = filters["id_rubro"].Value as Lbl.Articulos.Rubro; m_Categoria = filters["id_categoria"].Value as Lbl.Articulos.Categoria; m_Marca = filters["id_marca"].Value as Lbl.Articulos.Marca; m_Proveedor = filters["id_proveedor"].Value as Lbl.Personas.Persona; m_Situacion = filters["id_situacion"].Value as Lbl.Articulos.Situacion; m_Stock = filters["stock_actual"].Value as string; base.OnFiltersChanged(filters); }