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