/// <summary> /// 创建DataGridView扩展的ComboBox列 /// </summary> /// <param name="_dgv">要创建列的DataGridView</param> /// <param name="_alignment">设置列的对齐方式</param> /// <param name="_columnName">列名</param> /// <param name="_headerText">标题名</param> /// <param name="_dataPropertyName">绑定数据源的字段名称</param> /// <param name="_toolTipText">TipText提示</param> /// <param name="_readOnly">设置列是否只读,true 只读,false 读写</param> /// <param name="_visible">设置列是否可见,true 显示,false 隐藏</param> /// <param name="_cboDataSource">绑定ComboBox的数据源</param> /// <param name="_displayMember">用于显示的字段名</param> /// <param name="_valueMember">绑定Value的字段名</param> /// <param name="_maxDropDownItems">设置显示最大的下拉项条数</param> /// <param name="_dropDownStyle">设置显示类型</param> /// <param name="_notEmpty">设置列是否为必填列,true 必填,false 非必填</param> /// <param name="_backColor">设置列的背景色,当_notEmpty为true时,此项为必需值,为false,此项可以为Color.Empty</param> /// <param name="_columnState">装载DataGridView可写可读、只读列的数据字典</param> public static void InitDgvComboBoxExColumn(DataGridView _dgv, DataGridViewContentAlignment _alignment, string _columnName, string _headerText, string _dataPropertyName, string _toolTipText, bool _readOnly, bool _visible, DataTable _cboDataSource, string _displayMember, string _valueMember, int _maxDropDownItems, ComboBoxStyle _dropDownStyle, bool _notEmpty, Color _backColor, ref Dictionary <string, bool> _columnState) { DataGridViewComboBoxExColumn comboBoxExCol = new DataGridViewComboBoxExColumn(); comboBoxExCol.HeaderCell.Style.Alignment = _alignment == 0 ? DataGridViewContentAlignment.MiddleLeft : _alignment; comboBoxExCol.Name = _columnName; comboBoxExCol.HeaderText = _headerText; comboBoxExCol.DataPropertyName = _dataPropertyName; comboBoxExCol.ToolTipText = _toolTipText; comboBoxExCol.Visible = _visible; comboBoxExCol.ReadOnly = _readOnly; comboBoxExCol.DataSource = _cboDataSource; comboBoxExCol.DisplayMember = _displayMember; comboBoxExCol.ValueMember = _valueMember; comboBoxExCol.MaxDropDownItems = _maxDropDownItems; comboBoxExCol.DropDownStyle = _dropDownStyle; if (_notEmpty == true) { comboBoxExCol.DefaultCellStyle.BackColor = _backColor; } _columnState.Add(_columnName, _readOnly); _dgv.Columns.Add(comboBoxExCol); }
public void BindComboBox(object obj, List <HR_EmployeeResult> empList) { if (obj is Controls.UcComboBox) { Controls.UcComboBox c = obj as Controls.UcComboBox; c.ValueMember = "EmpID"; c.DisplayMember = "EmpName"; c.DataSource = empList; } else if (obj is DataGridViewComboBoxColumn) { DataGridViewComboBoxColumn c = obj as DataGridViewComboBoxColumn; c.ValueMember = "EmpID"; c.DisplayMember = "EmpName"; c.DataSource = empList; } else if (obj is DataGridViewComboBoxExColumn) { DataGridViewComboBoxExColumn c = obj as DataGridViewComboBoxExColumn; c.ValueMember = "EmpID"; c.DisplayMember = "EmpName"; c.DataSource = empList; } else if (obj is GridComboBoxExEditControl) { GridComboBoxExEditControl c = obj as GridComboBoxExEditControl; c.ValueMember = "EmpID"; c.DisplayMember = "EmpName"; c.DataSource = empList; } }
public DataGridViewColumn[] ColumnasGrid() { DataGridViewTextBoxColumn colId = new DataGridViewTextBoxColumn() { Name = "colId", HeaderText = "Id", DataPropertyName = "Id", Width = 60 }; colId.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewTextBoxColumn colNombre = new DataGridViewTextBoxColumn() { Name = "colNombre", HeaderText = "Parroquia.", DataPropertyName = "Nombre", Width = 450 }; DataGridViewComboBoxExColumn colIdCanton = new DataGridViewComboBoxExColumn() { Name = "colIdCanton", HeaderText = "Canton.", DataPropertyName = "fkcantone", ValueMember = "Objeto", DisplayMember = "nombrecompleto", FlatStyle = FlatStyle.Flat, Width = 250, DropDownStyle = ComboBoxStyle.DropDownList }; DataGridViewCheckBoxColumn colEsUrbano = new DataGridViewCheckBoxColumn() { Name = "colEsUrbano", HeaderText = "Urbano", DataPropertyName = "EsUrbano", Width = 60 }; DataGridViewCheckBoxColumn colModificado = new DataGridViewCheckBoxColumn() { Name = "colModificado", HeaderText = "Modificado", DataPropertyName = "Modificado", Visible = false }; DataGridViewColumn[] listaColumnas = new DataGridViewColumn[] { colId, colNombre, colIdCanton, colEsUrbano, colModificado }; return(listaColumnas); }
public static DataGridViewComboBoxExColumn setGridComboBox(DataTable dt, String DisplayMember, String ValueMember, AutoCompleteSource AutoSource, AutoCompleteMode AutoMode, ComboBoxStyle DropStyle) { DataGridViewComboBoxExColumn cboCol = new DataGridViewComboBoxExColumn(); cboCol.DataSource = dt; cboCol.DisplayMember = DisplayMember; cboCol.ValueMember = ValueMember; cboCol.AutoCompleteSource = AutoSource; cboCol.AutoCompleteMode = AutoMode; cboCol.DropDownStyle = DropStyle; return(cboCol); }
public DataGridViewColumn[] ColumnasGrid() { DataGridViewComboBoxExColumn colOperadora = new DataGridViewComboBoxExColumn() { Name = "colOperadora", HeaderText = "Operadora.", DataPropertyName = "fkoperadorastelefonia", ValueMember = "Objeto", DisplayMember = "nombre", FlatStyle = FlatStyle.Flat, Width = 200, DropDownStyle = ComboBoxStyle.DropDownList }; DataGridViewTextBoxColumn colTelefono = new DataGridViewTextBoxColumn() { Name = "colTelefono", HeaderText = "Telefono.", DataPropertyName = "Telefono", MaxInputLength = 13, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewCheckBoxColumn colActivo = new DataGridViewCheckBoxColumn() { Name = "colActivo", HeaderText = "Activo", DataPropertyName = "activo", Visible = false, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewCheckBoxColumn colModificado = new DataGridViewCheckBoxColumn() { Name = "colModificado", HeaderText = "Modificado", DataPropertyName = "Modificado", Visible = false }; DataGridViewColumn[] listaColumnas = new DataGridViewColumn[] { colOperadora, colTelefono, colActivo, colModificado }; return(listaColumnas); }
public DataGridViewColumn[] ColumnasGrid() { DataGridViewTextBoxColumn colAnio = new DataGridViewTextBoxColumn() { Name = "colAnio", HeaderText = "Año", DataPropertyName = "anio", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colAnio.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewComboBoxExColumn colMes = new DataGridViewComboBoxExColumn() { Name = "colMes", HeaderText = "Mes.", DataPropertyName = "Mes", ValueMember = "Objeto", DisplayMember = "Objeto", FlatStyle = FlatStyle.Flat, DropDownStyle = ComboBoxStyle.DropDownList, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewCheckBoxColumn colCerrado = new DataGridViewCheckBoxColumn() { Name = "colCerrado", HeaderText = "Cerrado", DataPropertyName = "cerrado", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewCheckBoxColumn colModificado = new DataGridViewCheckBoxColumn() { Name = "colModificado", HeaderText = "Modificado", DataPropertyName = "Modificado", Visible = false }; DataGridViewColumn[] listaColumnas = new DataGridViewColumn[] { colAnio, colMes, colCerrado, colModificado }; return(listaColumnas); }
private void LoadProductGrid() { grid.Columns.Clear(); grid.Rows.Clear(); DataGridViewComboBoxExColumn cbo = new DataGridViewComboBoxExColumn(); cbo.DropDownStyle = ComboBoxStyle.DropDown; cbo.DataSource = DataSupport.RunDataSet("SELECT * FROM PRODUCTS").Tables[0]; cbo.DisplayMember = "product_id"; cbo.ValueMember = "product_id"; cbo.AutoCompleteSource = AutoCompleteSource.ListItems; cbo.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cbo.DropDownHeight = 100; cbo.Name = "gridcol_product"; cbo.HeaderText = "Product"; grid.Columns.Add(cbo); DataGridViewComboBoxColumn cbo1 = new DataGridViewComboBoxColumn(); cbo1.Name = "gridcol_uom"; cbo1.HeaderText = "UOM"; grid.Columns.Add(cbo1); cbo1 = new DataGridViewComboBoxColumn(); cbo1.Name = "gridcol_lotno"; cbo1.HeaderText = "Lot Number"; grid.Columns.Add(cbo1); cbo1 = new DataGridViewComboBoxColumn(); cbo1.Name = "gridcol_expiry"; cbo1.HeaderText = "Expiry Date"; grid.Columns.Add(cbo1); DataGridViewTextBoxColumn cbo2 = new DataGridViewTextBoxColumn(); cbo2.Name = "gridcol_qty"; cbo2.HeaderText = "Quantity"; cbo2.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; grid.Columns.Add(cbo2); cbo1 = new DataGridViewComboBoxColumn(); cbo1.Name = "gridcol_whatuom"; cbo1.HeaderText = "To What UOM?"; grid.Columns.Add(cbo1); }
private void FrShangchuan_Load(object sender, EventArgs e) { string sql = "select 部门 from tb_bumen"; DataTable aaaa = SQLhelp.GetDataTable(sql, CommandType.Text); List <string> spaceminute = new List <string>(); for (int i = 0; i < aaaa.Rows.Count; i++) { string n = aaaa.Rows[i]["部门"].ToString(); spaceminute.Add(n); } foreach (string s in spaceminute) { comboBox1.Items.Add(s); } DataGridViewComboBoxExColumn column = new DataGridViewComboBoxExColumn(); column.Name = "完成责任人"; column.DataPropertyName = "用户名"; column.HeaderText = "完成责任人"; column.DropDownStyle = ComboBoxStyle.DropDownList; this.dataGridViewX1.Columns.Add(column); string sql1 = "select 用户名 from tb_operator"; DataTable aaaaa = SQLhelp.GetDataTable(sql1, CommandType.Text); List <string> spaceminute1 = new List <string>(); for (int i = 0; i < aaaaa.Rows.Count; i++) { string n = aaaaa.Rows[i]["用户名"].ToString(); spaceminute1.Add(n); } foreach (string s in spaceminute1) { column.Items.Add(s); } }
public static DataGridViewComboBoxExColumn AddGridColumnComboEditable(String HeaderText, DataTable DataSource, String Displaymember, String ValueMember, Int32 DisplayIndex, ComboBoxStyle DropDownStyle, Int32 MaxInput, Int32 DropWidth) { DataGridViewComboBoxExColumn cbCol = new DataGridViewComboBoxExColumn(); cbCol.HeaderText = HeaderText; cbCol.Name = HeaderText; cbCol.DataSource = DataSource; cbCol.DisplayMember = Displaymember; cbCol.DisplayIndex = DisplayIndex; cbCol.ValueMember = ValueMember; cbCol.AutoCompleteSource = AutoCompleteSource.ListItems; cbCol.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cbCol.DropDownStyle = DropDownStyle; cbCol.MaxLength = MaxInput; cbCol.ReadOnly = false; cbCol.DropDownWidth = DropWidth; return(cbCol); }
public DataGridViewColumn[] ColumnasGrid() { DataGridViewTextBoxColumn colOrden = new DataGridViewTextBoxColumn() { Name = "colOrden", HeaderText = "Orden", DataPropertyName = "orden", MaxInputLength = 2, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colIdentificador = new DataGridViewTextBoxColumn() { Name = "colIdentificador", HeaderText = "Identificador", DataPropertyName = "identificador", Width = 80 }; DataGridViewTextBoxColumn colColumna = new DataGridViewTextBoxColumn() { Name = "colColumna", HeaderText = "Columna.", DataPropertyName = "nombre", Width = 200 }; DataGridViewButtonXColumn colColumnaBoton = new DataGridViewButtonXColumn() { Name = "colNombreBoton", HeaderText = "<-", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells, Tag = "colColumna", Image = General.Imagenes.Images["Listar.ico"], ColorTable = DevComponents.DotNetBar.eButtonColor.Blue }; DataGridViewComboBoxExColumn colTipoColumna = new DataGridViewComboBoxExColumn() { Name = "colTipoColumna", HeaderText = "Tipo columna.", DataPropertyName = "fktiposcolumna", ValueMember = "Objeto", DisplayMember = "nombre", FlatStyle = FlatStyle.Flat, Width = 200, DropDownStyle = ComboBoxStyle.DropDownList }; DataGridViewTextBoxColumn colCabecera = new DataGridViewTextBoxColumn() { Name = "colCabecera", HeaderText = "Texto Cabecera.", DataPropertyName = "cabecera", MaxInputLength = 255, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colFormatoFecha = new DataGridViewTextBoxColumn() { Name = "colFormatoFecha", HeaderText = "Formato Fecha", DataPropertyName = "formatofecha", MaxInputLength = 255, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewDateTimeInputColumn colFechaMinima = new DataGridViewDateTimeInputColumn() { Name = "colFechaMinima", HeaderText = "Fecha minima", DataPropertyName = "fechaminima", Format = DevComponents.Editors.eDateTimePickerFormat.Custom, CustomFormat = "yyyy-MM-dd", MinDate = new DateTime(1901, 02, 01), AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colPropertyName = new DataGridViewTextBoxColumn() { Name = "colPropertyName", HeaderText = "PropertyName", DataPropertyName = "propertyname", MaxInputLength = 255, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colValueMember = new DataGridViewTextBoxColumn() { Name = "colValueMember", HeaderText = "ValueMember", DataPropertyName = "valuemember", MaxInputLength = 255, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colDisplayMember = new DataGridViewTextBoxColumn() { Name = "colDisplayMember", HeaderText = "DisplayMember", DataPropertyName = "displaymember", MaxInputLength = 255, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colTag = new DataGridViewTextBoxColumn() { Name = "colTag", HeaderText = "Tag", DataPropertyName = "tag", MaxInputLength = 255, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewComboBoxExColumn colAlineacion = new DataGridViewComboBoxExColumn() { Name = "colAlineacion", HeaderText = "Alineacion.", DataPropertyName = "fkalineacion", ValueMember = "Objeto", DisplayMember = "nombre", FlatStyle = FlatStyle.Flat, Width = 100, DropDownStyle = ComboBoxStyle.DropDownList }; DataGridViewTextBoxColumn colWidth = new DataGridViewTextBoxColumn() { Name = "colWidth", HeaderText = "Width", DataPropertyName = "width", MaxInputLength = 100, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colMaxLength = new DataGridViewTextBoxColumn() { Name = "colMaxLength", HeaderText = "MaxLength", DataPropertyName = "maxlength", MaxInputLength = 100, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewCheckBoxColumn colReadOnly = new DataGridViewCheckBoxColumn() { Name = "colReadOnly", HeaderText = "ReadOnly", DataPropertyName = "sololectura", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewCheckBoxColumn colVisible = new DataGridViewCheckBoxColumn() { Name = "colVisible", HeaderText = "Visible", DataPropertyName = "visible", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewCheckBoxColumn colModificado = new DataGridViewCheckBoxColumn() { Name = "colModificado", HeaderText = "Modificado", DataPropertyName = "Modificado", Visible = false }; DataGridViewColumn[] listaColumnas = new DataGridViewColumn[] { colIdentificador, colOrden, colColumna, //colColumnaBoton, colTipoColumna, colCabecera, colFormatoFecha, colFechaMinima, colPropertyName, colValueMember, colDisplayMember, colTag, colAlineacion, colWidth, colMaxLength, colReadOnly, colVisible, colModificado }; return(listaColumnas); }
public DataGridViewColumn[] ColumnasGrid() { DataGridViewTextBoxColumn colId = new DataGridViewTextBoxColumn() { Name = "colId", HeaderText = "Id", DataPropertyName = "Id", ReadOnly = true, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colId.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewComboBoxExColumn colEmpresa = new DataGridViewComboBoxExColumn() { Name = "colEmpresa", HeaderText = "Empresa", DataPropertyName = "fkempresa", ValueMember = "Objeto", DisplayMember = "nombre", FlatStyle = FlatStyle.Flat, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells, DropDownStyle = ComboBoxStyle.DropDownList }; DataGridViewTextBoxColumn colNombre = new DataGridViewTextBoxColumn() { Name = "colNombre", HeaderText = "Nombre.", DataPropertyName = "Nombre", MaxInputLength = 100, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colCodigoEstablecimiento = new DataGridViewTextBoxColumn() { Name = "colCodigoEstablecimiento", HeaderText = "CodigoEstablecimiento.", DataPropertyName = "CodigoEstablecimiento", MaxInputLength = 3, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colCodigoEstablecimiento.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewTextBoxColumn colBarrio = new DataGridViewTextBoxColumn() { Name = "colBarrio", HeaderText = "Barrio.", DataPropertyName = "fkbarrio", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colBarrio.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewButtonXColumn colBarrioBoton = new DataGridViewButtonXColumn() { Name = "colBarrioBoton", HeaderText = "<-", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells, Tag = "colBarrio", Image = General.Imagenes.Images["Listar.ico"], ColorTable = DevComponents.DotNetBar.eButtonColor.Blue }; colBarrioBoton.DefaultCellStyle.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192))))); DataGridViewTextBoxColumn colDireccion = new DataGridViewTextBoxColumn() { Name = "colDireccion", HeaderText = "Direccion.", DataPropertyName = "Direccion", MaxInputLength = 255, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colEncargado = new DataGridViewTextBoxColumn() { Name = "colEncargado", HeaderText = "Encargado.", DataPropertyName = "fkpersona", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewButtonXColumn colEncargadoBoton = new DataGridViewButtonXColumn() { Name = "colEncargadoBoton", HeaderText = "<-", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells, Tag = "colEncargado", Image = General.Imagenes.Images["Listar.ico"], ColorTable = DevComponents.DotNetBar.eButtonColor.Blue }; colEncargadoBoton.DefaultCellStyle.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192))))); DataGridViewTextBoxColumn colCorreo = new DataGridViewTextBoxColumn() { Name = "colCorreo", HeaderText = "Correo", DataPropertyName = "Correo", MaxInputLength = 250, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colTelefono = new DataGridViewTextBoxColumn() { Name = "colTelefono", HeaderText = "Telefono", DataPropertyName = "telefono", MaxInputLength = 13, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewCheckBoxColumn colModificado = new DataGridViewCheckBoxColumn() { Name = "colModificado", HeaderText = "Modificado", DataPropertyName = "Modificado", Visible = false }; DataGridViewColumn[] listaColumnas = new DataGridViewColumn[] { colId, colEmpresa, colNombre, colCodigoEstablecimiento, colBarrio, colBarrioBoton, colDireccion, colEncargado, colEncargadoBoton, colCorreo, colTelefono, colModificado }; return(listaColumnas); }
public void display_NUDColums() { nudgrid.Rows.Clear(); nudgrid.Columns.Clear(); DataGridViewLabelXColumn colno = new DataGridViewLabelXColumn(); colno.HeaderText = "Row #"; colno.Name = "numberIncrement"; colno.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; nudgrid.Columns.Add(colno); DataGridViewTextBoxColumn colinvoice = new DataGridViewTextBoxColumn(); colinvoice.HeaderText = "sdrrno"; colinvoice.Name = "sdrrno"; colinvoice.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; nudgrid.Columns.Add(colinvoice); colinvoice = new DataGridViewTextBoxColumn(); colinvoice.HeaderText = "Invoice #"; colinvoice.Name = "invoice_no"; colinvoice.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; nudgrid.Columns.Add(colinvoice); DataGridViewTextBoxColumn colInvoiceValue = new DataGridViewTextBoxColumn(); colInvoiceValue.HeaderText = "NUD Amount"; colInvoiceValue.Name = "nudvalue"; colInvoiceValue.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; nudgrid.Columns.Add(colInvoiceValue); DataGridViewDateTimeInputColumn colnumber = new DataGridViewDateTimeInputColumn(); colnumber.HeaderText = "Invoice Date"; colnumber.Name = "invoice_date"; colnumber.MinDate = new System.DateTime(2017, 1, 1, 0, 0, 0, 0); colnumber.ButtonClear.Checked = true; colnumber.ButtonClear.Visible = true; colnumber.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; colnumber.ReadOnly = true; nudgrid.Columns.Add(colnumber); DataGridViewComboBoxExColumn colreason = new DataGridViewComboBoxExColumn(); colreason.HeaderText = "Reason"; colreason.Name = "reason"; colreason.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; nudgrid.Columns.Add(colreason); DataGridViewComboBoxExColumn colstat = new DataGridViewComboBoxExColumn(); colstat.HeaderText = "Delivery Status"; colstat.Name = "delstat"; colstat.Items.Add("CANCELLED"); colstat.Items.Add("CUT-ITEMS"); colstat.Items.Add("FULL-RETURN"); colstat.Items.Add("RE-DELIVERY"); colstat.DropDownStyle = ComboBoxStyle.DropDownList; colstat.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; nudgrid.Columns.Add(colstat); colstat = new DataGridViewComboBoxExColumn(); colstat.HeaderText = "Accountability"; colstat.Name = "account"; colstat.Items.Add("CLIENT"); colstat.Items.Add("VGL"); colstat.DropDownStyle = ComboBoxStyle.DropDownList; colstat.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; nudgrid.Columns.Add(colstat); DataGridViewTextBoxColumn colzone = new DataGridViewTextBoxColumn(); colzone.HeaderText = "zone"; colzone.Name = "zone"; colzone.Visible = false; colzone.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; nudgrid.Columns.Add(colzone); DataGridViewTextBoxColumn colTindex = new DataGridViewTextBoxColumn(); colTindex.HeaderText = "Index"; colTindex.Name = "index"; colTindex.Visible = false; colTindex.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; nudgrid.Columns.Add(colTindex); nudgrid.Columns["numberIncrement"].Width = 35; nudgrid.Columns["invoice_date"].Width = 80; nudgrid.Columns["delstat"].Width = 160; nudgrid.Columns["account"].Width = 130; nudgrid.Columns["reason"].Width = 250; }
public DataGridViewColumn[] ColumnasGrid() { DataGridViewTextBoxColumn colId = new DataGridViewTextBoxColumn() { Name = "colId", HeaderText = "Id", DataPropertyName = "id", ReadOnly = true, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colId.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewComboBoxExColumn colPadre = new DataGridViewComboBoxExColumn() { Name = "colPadre", HeaderText = "Padre", DataPropertyName = "Padre", ValueMember = "Objeto", DisplayMember = "NombreCompleto", FlatStyle = FlatStyle.Flat, Width = 200, DropDownStyle = ComboBoxStyle.DropDownList }; DataGridViewTextBoxColumn colNombre = new DataGridViewTextBoxColumn() { Name = "colNombre", HeaderText = "Menú", DataPropertyName = "nombre", MaxInputLength = 50, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colTitulo = new DataGridViewTextBoxColumn() { Name = "colTitulo", HeaderText = "Titulo", DataPropertyName = "titulo", MaxInputLength = 50, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewCheckBoxColumn colVisible = new DataGridViewCheckBoxColumn() { Name = "colVisible", HeaderText = "Visible", DataPropertyName = "visible", SortMode = DataGridViewColumnSortMode.Automatic, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewCheckBoxColumn colContenedor = new DataGridViewCheckBoxColumn() { Name = "colContenedor", HeaderText = "Contenedor", DataPropertyName = "contenedor", SortMode = DataGridViewColumnSortMode.Automatic, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colFormulario = new DataGridViewTextBoxColumn() { Name = "colFormulario", HeaderText = "Formulario", DataPropertyName = "formulario", MaxInputLength = 50, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colModulo = new DataGridViewTextBoxColumn() { Name = "colModulo", HeaderText = "Modulo", DataPropertyName = "modulo", MaxInputLength = 50, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colBusqueda = new DataGridViewTextBoxColumn() { Name = "colBusqueda", HeaderText = "Busqueda", DataPropertyName = "busqueda", MaxInputLength = 50, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colPieDetalle = new DataGridViewTextBoxColumn() { Name = "colPieDetalle", HeaderText = "PieDetalle", DataPropertyName = "piedetalle", MaxInputLength = 50, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewComboBoxExColumn colIcono = new DataGridViewComboBoxExColumn() { Name = "colIcono", HeaderText = "Icono", DataPropertyName = "icono", ValueMember = "ImageIndex", DisplayMember = "Etiqueta", FlatStyle = System.Windows.Forms.FlatStyle.Flat, DropDownStyle = ComboBoxStyle.DropDownList, Width = 150, }; colIcono.DataSource = General.ListaImagenes(); DataGridViewImageColumn colImagen = new DataGridViewImageColumn() { Name = "colImagen", HeaderText = "Imagen", DataPropertyName = "Imagen", SortMode = DataGridViewColumnSortMode.Automatic, Width = 50 }; DataGridViewCheckBoxColumn colModificado = new DataGridViewCheckBoxColumn() { Name = "colModificado", HeaderText = "Modificado", DataPropertyName = "Modificado", SortMode = DataGridViewColumnSortMode.Automatic, Visible = false }; DataGridViewColumn[] listaColumnas = new DataGridViewColumn[] { colId, colNombre, colTitulo, colPadre, colVisible, colContenedor, colFormulario, colModulo, colBusqueda, colPieDetalle, colIcono, colImagen, colModificado }; return(listaColumnas); }
public void BindComboBox(object obj, string itemCode, List <SYS_DictItemLineResult> rst) { DataValueType valueType = DataValueType.String; if (obj is Controls.UcComboBox) { Controls.UcComboBox c = obj as Controls.UcComboBox; if (c != null && !string.IsNullOrEmpty(itemCode)) { List <KeyValuePair <string, object> > kvList = new List <KeyValuePair <string, object> >(); List <SYS_DictItemLineResult> list = rst.Where(a => a.ItemCode == itemCode).ToList(); if (list != null && list.Count > 0) { kvList = list.Select(a => new KeyValuePair <string, object>(a.ItemValue, a.ItemValue2)).ToList(); valueType = list[0].ValueType; } kvList.Insert(0, new KeyValuePair <string, object>("", "")); c.ValueMember = "Value"; c.DisplayMember = "Key"; if (valueType == DataValueType.Int32) { c.DataSource = kvList.Select(a => new KeyValuePair <string, int?>(a.Key, (a.Value == null || a.Value.ToStringHasNull() == "" ? null : (int?)a.Value.ToInt32()))).ToList(); } else if (valueType == DataValueType.Decimal) { c.DataSource = kvList.Select(a => new KeyValuePair <string, decimal?>(a.Key, (a.Value == null || a.Value.ToStringHasNull() == ""?null:(decimal?)a.Value.ToDecimal()))).ToList(); } else if (valueType == DataValueType.Boolean) { c.DataSource = kvList.Select(a => new KeyValuePair <string, bool?>(a.Key, (a.Value == null || a.Value.ToStringHasNull() == ""?null:(bool?)a.Value.ToBooleanHasNull()))).ToList(); } else { c.DataSource = kvList; } } } else if (obj is DataGridViewComboBoxColumn) { DataGridViewComboBoxColumn c = obj as DataGridViewComboBoxColumn; if (c != null && !string.IsNullOrEmpty(itemCode)) { List <KeyValuePair <string, object> > kvList = new List <KeyValuePair <string, object> >(); List <SYS_DictItemLineResult> list = rst.Where(a => a.ItemCode == itemCode).ToList(); if (list != null && list.Count > 0) { kvList = list.Select(a => new KeyValuePair <string, object>(a.ItemValue, a.ItemValue2)).ToList(); valueType = list[0].ValueType; } kvList.Insert(0, new KeyValuePair <string, object>("", "")); c.ValueMember = "Value"; c.DisplayMember = "Key"; if (valueType == DataValueType.Int32) { c.DataSource = kvList.Select(a => new KeyValuePair <string, int?>(a.Key, (a.Value == null || a.Value.ToStringHasNull() == "" ? null : (int?)a.Value.ToInt32()))).ToList(); } else if (valueType == DataValueType.Decimal) { c.DataSource = kvList.Select(a => new KeyValuePair <string, decimal?>(a.Key, (a.Value == null || a.Value.ToStringHasNull() == "" ? null : (decimal?)a.Value.ToDecimal()))).ToList(); } else if (valueType == DataValueType.Boolean) { c.DataSource = kvList.Select(a => new KeyValuePair <string, bool?>(a.Key, (a.Value == null || a.Value.ToStringHasNull() == "" ? null : (bool?)a.Value.ToBooleanHasNull()))).ToList(); } else { c.DataSource = kvList; } } } else if (obj is DataGridViewComboBoxExColumn) { DataGridViewComboBoxExColumn c = obj as DataGridViewComboBoxExColumn; if (c != null && !string.IsNullOrEmpty(itemCode)) { List <KeyValuePair <string, object> > kvList = new List <KeyValuePair <string, object> >(); List <SYS_DictItemLineResult> list = rst.Where(a => a.ItemCode == itemCode).ToList(); if (list != null && list.Count > 0) { kvList = list.Select(a => new KeyValuePair <string, object>(a.ItemValue, a.ItemValue2)).ToList(); valueType = list[0].ValueType; } kvList.Insert(0, new KeyValuePair <string, object>("", "")); c.ValueMember = "Value"; c.DisplayMember = "Key"; if (valueType == DataValueType.Int32) { c.DataSource = kvList.Select(a => new KeyValuePair <string, int?>(a.Key, (a.Value == null || a.Value.ToStringHasNull() == "" ? null : (int?)a.Value.ToInt32()))).ToList(); } else if (valueType == DataValueType.Decimal) { c.DataSource = kvList.Select(a => new KeyValuePair <string, decimal?>(a.Key, (a.Value == null || a.Value.ToStringHasNull() == "" ? null : (decimal?)a.Value.ToDecimal()))).ToList(); } else if (valueType == DataValueType.Boolean) { c.DataSource = kvList.Select(a => new KeyValuePair <string, bool?>(a.Key, (a.Value == null || a.Value.ToStringHasNull() == "" ? null : (bool?)a.Value.ToBooleanHasNull()))).ToList(); } else { c.DataSource = kvList; } } } else if (obj is GridComboBoxExEditControl) { GridComboBoxExEditControl c = obj as GridComboBoxExEditControl; if (c != null && !string.IsNullOrEmpty(itemCode)) { List <KeyValuePair <string, object> > kvList = new List <KeyValuePair <string, object> >(); List <SYS_DictItemLineResult> list = rst.Where(a => a.ItemCode == itemCode).ToList(); if (list != null && list.Count > 0) { kvList = list.Select(a => new KeyValuePair <string, object>(a.ItemValue, a.ItemValue2)).ToList(); valueType = list[0].ValueType; } kvList.Insert(0, new KeyValuePair <string, object>("", "")); c.ValueMember = "Value"; c.DisplayMember = "Key"; if (valueType == DataValueType.Int32) { c.DataSource = kvList.Select(a => new KeyValuePair <string, int?>(a.Key, (a.Value == null || a.Value.ToStringHasNull() == "" ? null : (int?)a.Value.ToInt32()))).ToList(); } else if (valueType == DataValueType.Decimal) { c.DataSource = kvList.Select(a => new KeyValuePair <string, decimal?>(a.Key, (a.Value == null || a.Value.ToStringHasNull() == "" ? null : (decimal?)a.Value.ToDecimal()))).ToList(); } else if (valueType == DataValueType.Boolean) { c.DataSource = kvList.Select(a => new KeyValuePair <string, bool?>(a.Key, (a.Value == null || a.Value.ToStringHasNull() == "" ? null : (bool?)a.Value.ToBooleanHasNull()))).ToList(); } else { c.DataSource = kvList; } } } }
public DataGridViewColumn[] ColumnasGrid() { DataGridViewTextBoxColumn colId = new DataGridViewTextBoxColumn() { Name = "colId", HeaderText = "Id", DataPropertyName = "id", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colId.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewTextBoxColumn colApellido = new DataGridViewTextBoxColumn() { Name = "colApellido", HeaderText = "Apellidos.", DataPropertyName = "apellido", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colNombre = new DataGridViewTextBoxColumn() { Name = "colNombre", HeaderText = "Nombres.", DataPropertyName = "nombre", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewComboBoxExColumn colTipoPersona = new DataGridViewComboBoxExColumn() { Name = "colTipoPersona", HeaderText = "Tipo persona.", DataPropertyName = "fktipospersona", ValueMember = "Objeto", DisplayMember = "descripcion", FlatStyle = FlatStyle.Flat, Width = 100, DropDownStyle = ComboBoxStyle.DropDownList }; DataGridViewComboBoxExColumn colTipoDocumento = new DataGridViewComboBoxExColumn() { Name = "colTipoDocumento", HeaderText = "Documento.", DataPropertyName = "fktiposdocumento", ValueMember = "Objeto", DisplayMember = "descripcion", FlatStyle = FlatStyle.Flat, Width = 100, DropDownStyle = ComboBoxStyle.DropDownList }; DataGridViewTextBoxColumn colIdentificacion = new DataGridViewTextBoxColumn() { Name = "colIdentificacion", HeaderText = "Identificación.", DataPropertyName = "identificacion", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colIdentificacion.MaxInputLength = 13; DataGridViewComboBoxExColumn colGenero = new DataGridViewComboBoxExColumn() { Name = "colGenero", HeaderText = "Genero.", DataPropertyName = "fkgenero", ValueMember = "Objeto", DisplayMember = "descripcion", FlatStyle = FlatStyle.Flat, Width = 100, DropDownStyle = ComboBoxStyle.DropDownList }; DataGridViewTextBoxColumn colCorreo = new DataGridViewTextBoxColumn() { Name = "colCorreo", HeaderText = "Correo", DataPropertyName = "correo", Width = 200 }; DataGridViewTextBoxColumn colEstadoPersona = new DataGridViewTextBoxColumn() { Name = "colEstadoPersona", HeaderText = "Estado", DataPropertyName = "fkestadospersona", Width = 100, }; DataGridViewTextBoxColumn colParroquiaDocumento = new DataGridViewTextBoxColumn() { Name = "colParroquiaDocumento", HeaderText = "Parroquia", DataPropertyName = "fkparroquia", Width = 300 }; DataGridViewButtonXColumn colParroquiaBoton = new DataGridViewButtonXColumn() { Name = "colParroquiaBoton", HeaderText = "<-", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells, Tag = "colParroquiaDocumento", Image = General.Imagenes.Images["Listar.ico"], ColorTable = DevComponents.DotNetBar.eButtonColor.Blue }; colParroquiaBoton.DefaultCellStyle.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192))))); DataGridViewTextBoxColumn colReferenciaDireccion = new DataGridViewTextBoxColumn() { Name = "colReferenciaDireccion", HeaderText = "Dirección", DataPropertyName = "referenciadireccion", Width = 300 }; DataGridViewTextBoxColumn colFechaServidor = new DataGridViewTextBoxColumn() { Name = "colFechaServidor", HeaderText = "Creado", DataPropertyName = "fechaservidor", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colFechaServidor.ReadOnly = true; DataGridViewCheckBoxColumn colModificado = new DataGridViewCheckBoxColumn() { Name = "colModificado", HeaderText = "Modificado", DataPropertyName = "Modificado", Visible = false }; DataGridViewColumn[] listaColumnas = new DataGridViewColumn[] { colId, colApellido, colNombre, colTipoPersona, colTipoDocumento, colIdentificacion, colGenero, colCorreo, colParroquiaDocumento, colParroquiaBoton, colReferenciaDireccion, colEstadoPersona, colFechaServidor, colModificado }; return(listaColumnas); }
public DataGridViewColumn[] ColumnasGrid() { DataGridViewTextBoxColumn colId = new DataGridViewTextBoxColumn() { Name = "colId", HeaderText = "Id", DataPropertyName = "Id", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colId.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewTextBoxColumn colDescripcion = new DataGridViewTextBoxColumn() { Name = "colDescripcion", HeaderText = "Descripción.", DataPropertyName = "Descripcion", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colPrecio = new DataGridViewTextBoxColumn() { Name = "colPrecio", HeaderText = "Precio", DataPropertyName = "Precio", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colPrecio.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewComboBoxExColumn colTipo = new DataGridViewComboBoxExColumn() { Name = "colTipo", HeaderText = "Tipo.", DataPropertyName = "Tipo", ValueMember = "IdChr", DisplayMember = "Texto", FlatStyle = FlatStyle.Flat, Width = 100, DropDownStyle = ComboBoxStyle.DropDownList }; DataGridViewCheckBoxColumn colGrabaIva = new DataGridViewCheckBoxColumn() { Name = "colGrabaIva", HeaderText = "Graba Iva", DataPropertyName = "GrabaIva", Width = 50 }; DataGridViewCheckBoxColumn colModificado = new DataGridViewCheckBoxColumn() { Name = "colModificado", HeaderText = "Modificado", DataPropertyName = "Modificado", Visible = false }; DataGridViewColumn[] listaColumnas = new DataGridViewColumn[] { colId, colTipo, colDescripcion, colPrecio, colGrabaIva, colModificado }; return(listaColumnas); }
public static DataGridViewColumn[] GeneraColumnasGrid(object unColumnasGrid, short unIdentificador = 0) { List <columnasgrid> columnas = unColumnasGrid as List <columnasgrid>; List <DataGridViewColumn> lista = new List <DataGridViewColumn>(); DataGridViewColumn columna = null; if (columnas != null) { foreach (columnasgrid item in columnas.Where(x => x.identificador == unIdentificador)) { switch (item.idtipocolumna) { case 0: columna = new DataGridViewTextBoxColumn() { MaxInputLength = item.maxlength }; break; case 1: columna = new DataGridViewComboBoxExColumn() { ValueMember = item.valuemember, DisplayMember = item.displaymember, FlatStyle = FlatStyle.Flat, DropDownStyle = ComboBoxStyle.DropDownList }; break; case 2: columna = new DataGridViewButtonXColumn() { Image = item.nombre.ToLower().Contains("borrar") ? General.Imagenes.Images["Eliminar.ico"] : General.Imagenes.Images["Listar.ico"], ColorTable = DevComponents.DotNetBar.eButtonColor.Blue }; break; case 3: columna = new DataGridViewCheckBoxColumn() { SortMode = DataGridViewColumnSortMode.Automatic, }; break; case 4: columna = new DataGridViewDateTimeInputColumn() { Format = DevComponents.Editors.eDateTimePickerFormat.Custom, CustomFormat = item.formatofecha, MinDate = item.fechaminima, }; break; } columna.Name = "col" + item.nombre.ToUpper() /* + (columna.GetType().ToString() == "DataGridViewButtonXColumn" ? "Boton" : "")*/; //columna.Name = "col" + item.nombre.ToUpper() + (item.idtipocolumna == 3 ? "Boton" : ""); columna.DefaultCellStyle.Format = item.formatofecha; columna.HeaderText = item.cabecera; columna.Visible = item.visible; columna.ReadOnly = item.sololectura; columna.Tag = item.tag; columna.DataPropertyName = item.idtipocolumna == 2 ? "" : item.propertyname; if (item.width == 0) { columna.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; } else { columna.Width = item.width; } columna.DefaultCellStyle.Alignment = (DataGridViewContentAlignment)Enum.Parse(typeof(DataGridViewContentAlignment), item.fkalineacion.nombre, true); lista.Add(columna); } } return(lista.ToArray()); }
private void SetupDotNetGrid() { int startColIndex = 3; for (int i = 0; i < 6; i++) { DataGridViewComboBoxExColumn col = (DataGridViewComboBoxExColumn)dataGridViewCSharp.Columns[i + startColIndex]; col.DropDownStyle = ComboBoxStyle.DropDownList; col.DropDownWidth = 200; string[] dbTypes; switch (i) { case 0: dbTypes = ArchAngel.Interfaces.ProjectOptions.TypeMappings.Utility.SqlServerTypes.Select(t => t.TypeName).OrderBy(t => t).ToArray(); break; case 1: dbTypes = ArchAngel.Interfaces.ProjectOptions.TypeMappings.Utility.OracleTypes.Select(t => t.TypeName).OrderBy(t => t).ToArray(); break; case 2: dbTypes = ArchAngel.Interfaces.ProjectOptions.TypeMappings.Utility.MySqlTypes.Select(t => t.TypeName).OrderBy(t => t).ToArray(); break; case 3: dbTypes = ArchAngel.Interfaces.ProjectOptions.TypeMappings.Utility.PostgreSqlTypes.Select(t => t.TypeName).OrderBy(t => t).ToArray(); break; case 4: dbTypes = ArchAngel.Interfaces.ProjectOptions.TypeMappings.Utility.FirebirdTypes.Select(t => t.TypeName).OrderBy(t => t).ToArray(); break; case 5: dbTypes = ArchAngel.Interfaces.ProjectOptions.TypeMappings.Utility.SQLiteTypes.Select(t => t.TypeName).OrderBy(t => t).ToArray(); break; default: throw new NotImplementedException(string.Format("Column {0} not handled yet", i)); } col.Items.Add(""); col.Items.AddRange(dbTypes); } foreach (var x in Utility.DotNetTypes.OrderBy(o => o.Name)) { DataGridViewRow row = new DataGridViewRow(); row.Cells.Add(new DataGridViewTextBoxCell()); row.Cells.Add(new DataGridViewTextBoxCell()); row.Cells.Add(new DataGridViewTextBoxCell()); row.Cells.Add(new DataGridViewComboBoxExCell()); row.Cells.Add(new DataGridViewComboBoxExCell()); row.Cells.Add(new DataGridViewComboBoxExCell()); row.Cells.Add(new DataGridViewComboBoxExCell()); row.Cells.Add(new DataGridViewComboBoxExCell()); row.Cells.Add(new DataGridViewComboBoxExCell()); row.Cells.Add(new DataGridViewButtonXCell()); row.Cells[0].Value = x.Name; row.Cells[1].Value = x.CSharpName; row.Cells[2].Value = x.VbName; row.Cells[3].Value = x.SqlServerName; row.Cells[4].Value = x.OracleName; row.Cells[5].Value = x.MySqlName; row.Cells[6].Value = x.PostgreSqlName; row.Cells[7].Value = x.FirebirdName; row.Cells[8].Value = x.SQLiteName; row.Tag = x; dataGridViewCSharp.Rows.Add(row); } }
public DataGridViewColumn[] ColumnasGrid() { DataGridViewTextBoxColumn colId = new DataGridViewTextBoxColumn() { Name = "colId", HeaderText = "Id", DataPropertyName = "id", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colId.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewTextBoxColumn colDescripcion = new DataGridViewTextBoxColumn() { Name = "colDescripcion", HeaderText = "Descripción.", DataPropertyName = "descripcion", MaxInputLength = 25, Width = 250, //AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colNumeroCuenta = new DataGridViewTextBoxColumn() { Name = "colNumeroCuenta", HeaderText = "Cuenta.", DataPropertyName = "numerocuenta", MaxInputLength = 25, Width = 100, //AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewComboBoxExColumn colIdBanco = new DataGridViewComboBoxExColumn() { Name = "colIdBanco", HeaderText = "Banco.", DataPropertyName = "fkbanco", ValueMember = "Objeto", DisplayMember = "Objeto", FlatStyle = FlatStyle.Flat, Width = 250, DropDownStyle = ComboBoxStyle.DropDownList }; DataGridViewDateTimeInputColumn colFechaApertura = new DataGridViewDateTimeInputColumn() { Name = "colFechaApertura", HeaderText = "Aperturada", DataPropertyName = "fechaapertura", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colFechaApertura.ButtonDropDown.Visible = true; colFechaApertura.ButtonDropDown.Shortcut = DevComponents.DotNetBar.eShortcut.F4; colFechaApertura.AutoAdvance = true; colFechaApertura.MonthCalendar.TodayButtonVisible = true; DataGridViewDoubleInputColumn colSaldoCuenta = new DataGridViewDoubleInputColumn() { Name = "colSaldoCuenta", HeaderText = "Saldo", DataPropertyName = "saldocuenta", Width = 100 }; colSaldoCuenta.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; colSaldoCuenta.DefaultCellStyle.Format = "C5"; DataGridViewCheckBoxColumn colActivo = new DataGridViewCheckBoxColumn() { Name = "colActivo", HeaderText = "Activo", DataPropertyName = "activo", Visible = false }; DataGridViewCheckBoxColumn colModificado = new DataGridViewCheckBoxColumn() { Name = "colModificado", HeaderText = "Modificado", DataPropertyName = "Modificado", Visible = false }; DataGridViewColumn[] listaColumnas = new DataGridViewColumn[] { colId, colDescripcion, colNumeroCuenta, colIdBanco, colFechaApertura, colSaldoCuenta, colActivo, colModificado }; return(listaColumnas); }
public DataGridViewColumn[] ColumnasGrid() { DataGridViewTextBoxColumn colId = new DataGridViewTextBoxColumn() { Name = "colId", HeaderText = "Id", DataPropertyName = "Id", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colId.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewTextBoxColumn colDescripcion = new DataGridViewTextBoxColumn() { Name = "colDescripcion", HeaderText = "Descripción.", DataPropertyName = "Descripcion", MaxInputLength = 100, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewComboBoxExColumn colIdUnidadDeMedida = new DataGridViewComboBoxExColumn() { Name = "colIdUnidadDeMedida", HeaderText = "Medida.", DataPropertyName = "fkunidadesdemedida", ValueMember = "Objeto", DisplayMember = "descripcion", FlatStyle = FlatStyle.Flat, Width = 150, DropDownStyle = ComboBoxStyle.DropDownList }; DataGridViewButtonXColumn colMarcaBoton = new DataGridViewButtonXColumn() { Name = "colMarcaBoton", HeaderText = "<-", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells, Tag = "colMarca", Image = General.Imagenes.Images["Listar.ico"], ColorTable = DevComponents.DotNetBar.eButtonColor.Blue }; colMarcaBoton.DefaultCellStyle.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192))))); DataGridViewTextBoxColumn colMarca = new DataGridViewTextBoxColumn() { Name = "colMarca", HeaderText = "Marca", DataPropertyName = "fkmarca", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colMarca.ReadOnly = true; DataGridViewTextBoxColumn colUtilidadPrecio1 = new DataGridViewTextBoxColumn() { Name = "colUtilidadPrecio1", HeaderText = "Utilidad 01", DataPropertyName = "UtilidadPrecio1", MaxInputLength = 10, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colUtilidadPrecio1.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewTextBoxColumn colPrecio1 = new DataGridViewTextBoxColumn() { Name = "colPrecio1", HeaderText = "Precio 01", DataPropertyName = "Precio1", MaxInputLength = 10, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colPrecio1.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewTextBoxColumn colUtilidadPrecio2 = new DataGridViewTextBoxColumn() { Name = "colUtilidadPrecio2", HeaderText = "Utilidad 02", DataPropertyName = "UtilidadPrecio2", MaxInputLength = 10, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colUtilidadPrecio2.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewTextBoxColumn colPrecio2 = new DataGridViewTextBoxColumn() { Name = "colPrecio2", HeaderText = "Precio 02", DataPropertyName = "Precio2", MaxInputLength = 10, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colPrecio2.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewTextBoxColumn colUtilidadPrecio3 = new DataGridViewTextBoxColumn() { Name = "colUtilidadPrecio3", HeaderText = "Utilidad 03", DataPropertyName = "UtilidadPrecio3", MaxInputLength = 10, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colUtilidadPrecio3.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewTextBoxColumn colPrecio3 = new DataGridViewTextBoxColumn() { Name = "colPrecio3", HeaderText = "Precio 03", DataPropertyName = "Precio3", MaxInputLength = 10, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colPrecio3.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewTextBoxColumn colUtilidadPrecio4 = new DataGridViewTextBoxColumn() { Name = "colUtilidadPrecio4", HeaderText = "Utilidad 04", DataPropertyName = "UtilidadPrecio4", MaxInputLength = 10, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colUtilidadPrecio4.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewTextBoxColumn colPrecio4 = new DataGridViewTextBoxColumn() { Name = "colPrecio4", HeaderText = "Precio 04", DataPropertyName = "Precio4", MaxInputLength = 10, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colPrecio4.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewTextBoxColumn colUltimoCosto = new DataGridViewTextBoxColumn() { Name = "colUltimoCosto", HeaderText = "UltimoCosto", DataPropertyName = "UltimoCosto", MaxInputLength = 8, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; colUltimoCosto.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; DataGridViewCheckBoxColumn colCheque = new DataGridViewCheckBoxColumn() { Name = "colCheque", HeaderText = "Cheque", DataPropertyName = "Cheque", }; DataGridViewCheckBoxColumn colMonedero = new DataGridViewCheckBoxColumn() { Name = "colMonedero", HeaderText = "Monedero", DataPropertyName = "Monedero", }; DataGridViewCheckBoxColumn colCorriente = new DataGridViewCheckBoxColumn() { Name = "colCorriente", HeaderText = "Corriente", DataPropertyName = "Corriente", }; DataGridViewCheckBoxColumn colDiferido = new DataGridViewCheckBoxColumn() { Name = "colDiferido", HeaderText = "Diferido", DataPropertyName = "Diferido", }; DataGridViewCheckBoxColumn colCreditoEmpresarial = new DataGridViewCheckBoxColumn() { Name = "colCreditoEmpresarial", HeaderText = "Empresarial", DataPropertyName = "CreditoEmpresarial", }; DataGridViewCheckBoxColumn colCreditoPersonal = new DataGridViewCheckBoxColumn() { Name = "colCreditoPersonal", HeaderText = "Personal", DataPropertyName = "CreditoPersonal", }; DataGridViewCheckBoxColumn colModificado = new DataGridViewCheckBoxColumn() { Name = "colModificado", HeaderText = "Modificado", DataPropertyName = "Modificado", Visible = false }; DataGridViewColumn[] listaColumnas = new DataGridViewColumn[] { colId, colMarca, colMarcaBoton, colDescripcion, colIdUnidadDeMedida, colUtilidadPrecio1, colPrecio1, colUtilidadPrecio2, colPrecio2, colUtilidadPrecio3, colPrecio3, colUtilidadPrecio4, colPrecio4, colUltimoCosto, colCheque, colMonedero, colCorriente, colDiferido, colCreditoEmpresarial, colCreditoPersonal, colModificado }; return(listaColumnas); }