void CreateEmptyGrid()
{
m_Grid = new DataGridView();
m_Grid.ReadOnly = true;
m_Grid.Parent = this;
m_Grid.Dock = DockStyle.Fill;
m_Table = new DataTable();
m_Grid.DataSource = m_Table;
//Add base item attributes
Type ItemType = typeof(GameplayItem);
Type ItemAttrType = typeof(ItemAttributes);
System.Reflection.FieldInfo[] ItemFields = ItemType.GetFields();
System.Reflection.FieldInfo[] ItemAttrFields = ItemAttrType.GetFields();
List<string> FieldNames = new List<string>();
foreach (System.Reflection.FieldInfo Info in ItemFields)
{
FieldNames.Add(Info.Name);
DataGridViewColumn Col = new DataGridViewColumn(CreateCellTemplate(Info));
Col.Name = Info.Name;
//m_Grid.Columns.Add(Col);
m_Table.Columns.Add(Info.Name, Info.FieldType);
}
foreach (System.Reflection.FieldInfo Info in ItemAttrFields)
{
FieldNames.Add(Info.Name);
DataGridViewColumn Col = new DataGridViewColumn(CreateCellTemplate(Info));
Col.Name = Info.Name;
//m_Grid.Columns.Add(Col);
m_Table.Columns.Add(Info.Name, Info.FieldType);
}
}
public void SetColumnToDateFormat(DataGridViewColumn column, string format)
{
column.DefaultCellStyle = new DataGridViewCellStyle
{
Format = format
};
}
public void SetColumnToDateFormat(DataGridViewColumn column)
{
column.DefaultCellStyle = new DataGridViewCellStyle
{
Format = "MM/dd/yyyy"
};
}
/// ------------------------------------------------------------------------------------
/// <summary>
/// Constructor.
/// </summary>
/// ------------------------------------------------------------------------------------
public CheckBoxColumnHeaderHandler(DataGridViewColumn col)
{
Debug.Assert(col != null);
Debug.Assert(col is DataGridViewCheckBoxColumn);
Debug.Assert(col.DataGridView != null);
m_col = col;
m_grid = col.DataGridView;
m_grid.HandleDestroyed += HandleHandleDestroyed;
m_grid.CellPainting += HandleHeaderCellPainting;
m_grid.CellMouseMove += HandleHeaderCellMouseMove;
m_grid.ColumnHeaderMouseClick += HandleHeaderCellMouseClick;
m_grid.CellContentClick += HandleDataCellCellContentClick;
m_grid.Scroll += HandleGridScroll;
m_grid.RowsAdded += HandleGridRowsAdded;
m_grid.RowsRemoved += HandleGridRowsRemoved;
if (!Application.RenderWithVisualStyles)
{
m_szCheckBox = new Size(13, 13);
}
else
{
var element = VisualStyleElement.Button.CheckBox.CheckedNormal;
var renderer = new VisualStyleRenderer(element);
using (var g = m_grid.CreateGraphics())
m_szCheckBox = renderer.GetPartSize(g, ThemeSizeType.True);
}
m_stringFormat = new StringFormat(StringFormat.GenericTypographic);
m_stringFormat.Alignment = StringAlignment.Center;
m_stringFormat.LineAlignment = StringAlignment.Center;
m_stringFormat.Trimming = StringTrimming.EllipsisCharacter;
m_stringFormat.FormatFlags |= StringFormatFlags.NoWrap;
}
public void InitialDataGridView()
{
dataGridView.Rows.Clear();
dataGridView.Columns.Clear();
DataGridViewCell textCell = new DataGridViewTextBoxCell();
DataGridViewColumn timeColumn = new DataGridViewColumn();
timeColumn.HeaderText = "记录时间";
timeColumn.Width = 160;
timeColumn.CellTemplate = textCell;
DataGridViewColumn ipColumn = new DataGridViewColumn();
ipColumn.HeaderText = "IP地址";
ipColumn.Width = 120;
ipColumn.CellTemplate = textCell;
DataGridViewColumn portColumn = new DataGridViewColumn();
portColumn.HeaderText = "端口号";
portColumn.Width = 80;
portColumn.CellTemplate = textCell;
DataGridViewColumn statusColumn = new DataGridViewColumn();
statusColumn.HeaderText = "工作状态";
statusColumn.Width = 180;
statusColumn.CellTemplate = textCell;
dataGridView.Columns.Add(timeColumn);
dataGridView.Columns.Add(ipColumn);
dataGridView.Columns.Add(portColumn);
dataGridView.Columns.Add(statusColumn);
}
private void button1_Click(object sender, EventArgs e)
{
//создает переменную COL для хранения имени выбранного столбца таблицы
COL = new System.Windows.Forms.DataGridViewColumn();
switch (Сортировка.SelectedIndex)
{
case 0:
COL = dataGridViewTextBoxColumn2;
break;
case 1:
COL = dataGridViewTextBoxColumn4;
break;
case 2:
COL = dataGridViewTextBoxColumn6;
break;
}
if (radioButton1.Checked)
{
makerProdDataGridView.Sort(COL,
System.ComponentModel.ListSortDirection.Ascending);
}
else
{
makerProdDataGridView.Sort(COL,
System.ComponentModel.ListSortDirection.Descending);
}
}
private void AddTimestampColumns()
{
DataGridViewCell cell = new DataGridViewTextBoxCell();
DataGridViewColumn column = new DataGridViewColumn();
column.HeaderText = "Total Hours";
column.Name = "TotalHours";
column.CellTemplate = cell;
column.ReadOnly = true;
this.gridTimestamps.Columns.Add( column );
cell = new DataGridViewTextBoxCell();
column = new DataGridViewColumn();
column.HeaderText = "Hourly Rate";
column.Name = "HourlyRate";
column.CellTemplate = cell;
column.ReadOnly = true;
this.gridTimestamps.Columns.Add( column );
cell = new DataGridViewTextBoxCell();
column = new DataGridViewColumn();
column.HeaderText = "Amount";
column.Name = "Amount";
column.CellTemplate = cell;
column.ReadOnly = true;
this.gridTimestamps.Columns.Add( column );
}
private void _btnSelect_Click(object sender, EventArgs e)
{
foreach (string cl in _clbShowColumn.CheckedItems)
{
DataGridViewColumn _column = new DataGridViewColumn();
_column.CellTemplate = new DataGridViewTextBoxCell();
_column.Name = cl;
_column.HeaderText = cl;
_column.DataPropertyName = cl;
_column.SortMode = DataGridViewColumnSortMode.Automatic;
switch(_InsertionType)
{
case InsertionType.Before :
_Grid.Columns.Insert(_ColumnPosition, _column);
break;
case InsertionType.After :
_Grid.Columns.Insert(_ColumnPosition + 1, _column);
break;
}
}
this.Close();
}
private void BtnFilter_Click(object sender, EventArgs e)
{
System.Windows.Forms.DataGridViewColumn Col = default;
switch (LBoxFilter.SelectedIndex)
{
case 0:
Col = title;
break;
case 1:
Col = categoty;
break;
case 2:
Col = price;
break;
case 3:
Col = description;
break;
}
if (RBAsc.Checked)
{
DGVItem.Sort(Col, System.ComponentModel.ListSortDirection.Ascending);
}
else
{
DGVItem.Sort(Col, System.ComponentModel.ListSortDirection.Descending);
}
}
public TableForm(string name, IDataReader rdr)
{
DataGridView dgv = new DataGridView();
dgv.Dock = DockStyle.Fill;
DataGridViewTextBoxCell template = new DataGridViewTextBoxCell();
template.Style.Font = new Font("DejaVu Sans",10);
for (int i = 0;i < rdr.FieldCount;i++)
{
DataGridViewColumn col = new DataGridViewColumn(template);
col.Name = rdr.GetName(i);
dgv.Columns.Add(col);
}
while (rdr.Read())
{
DataGridViewRow row = new DataGridViewRow();
row.CreateCells(dgv);
for (int i = 0;i < rdr.FieldCount;i++)
{
object val = rdr[i];
if (val is byte[])
{
val = Encoding.UTF8.GetString((byte[])val);
}
row.Cells[i].Value = val;
}
dgv.Rows.Add(row);
}
Controls.Add(dgv);
}
private void button3_Click(object sender, EventArgs e)
{
System.Windows.Forms.DataGridViewColumn Col = dataGridViewTextBoxColumn2;
switch (listBox1.SelectedIndex)
{
case 0:
Col = dataGridViewTextBoxColumn1;
break;
case 1:
Col = dataGridViewTextBoxColumn2;
break;
case 2:
Col = dataGridViewTextBoxColumn4;
break;
}
if (radioButton1.Checked)
{
товарыDataGridView.Sort(Col, System.ComponentModel.ListSortDirection.Ascending);
}
else
{
товарыDataGridView.Sort(Col, System.ComponentModel.ListSortDirection.Descending);
}
}
private void button1_Click(object sender, EventArgs e)
{
COL = new System.Windows.Forms.DataGridViewColumn();
switch (listBox1.SelectedIndex)
{
case 0:
COL = dataGridViewTextBoxColumn2;
break;
case 1:
COL = dataGridViewTextBoxColumn4;
break;
case 2:
COL = dataGridViewTextBoxColumn6;
break;
}
if (radioButton1.Checked)
{
makerProdDataGridView.Sort(COL,
System.ComponentModel.ListSortDirection.Ascending);
}
else
{
makerProdDataGridView.Sort(COL,
System.ComponentModel.ListSortDirection.Descending);
}
}
private void button1_Click(object sender, EventArgs e)
{
NikePlus nikePlus = new NikePlus();
INikePlusData api = nikePlus.GetAPI(txtUsername.Text, txtPassword.Text);
api.Login();
userDetailsBindingSource.DataSource = api.getUserDetails();
List<IRun> runs = api.getRuns();
//iRunBindingSource.DataSource;
dataGridView2.DataSource = runs;
DataGridViewColumn mileColumn = new DataGridViewColumn(dataGridView2.Columns[0].CellTemplate);
dataGridView2.Columns.Add(mileColumn);
dataGridView2.Refresh();
}
/// <summary>
/// 增加列的事件
/// </summary>
/// <param name="ColumnName">用于填充这个ExDataGridView的DataTable的列名</param>
/// <param name="DisplayName">在界面上显示的名称</param>
/// <param name="DisplayWidth">列宽</param>
/// <param name="IFReadOnly">是否只读</param>
/// <param name="ColumnType">列的类型</param>
/// <param name="Aligment">对齐方式</param>
/// <param name="FormatString">显示格式</param>
/// <param name="Visable">是否可见</param>
public void AddColumn(string ColumnName, string DisplayName, Int16 DisplayWidth = 80, bool IFReadOnly = true,
System.Windows.Forms.DataGridViewColumn ColumnType = null, System.Windows.Forms.DataGridViewContentAlignment Aligment = DataGridViewContentAlignment.MiddleLeft,
string FormatString = null, bool Visable = true)
{
DataGridViewColumn obj = new DataGridViewColumn();
DataGridViewTextBoxColumn obj1 = new DataGridViewTextBoxColumn();
if (ColumnType == null)
{
obj = obj1;
}
else
{
obj = ColumnType;
}
obj.DataPropertyName = ColumnName;
obj.HeaderText = DisplayName;
obj.Name = ColumnName;
obj.Width = DisplayWidth;
obj.ReadOnly = IFReadOnly;
obj.Visible = Visable;
obj.CellTemplate.Style.Alignment = Aligment;
obj.CellTemplate.Style.Format = FormatString;
this.Columns.AddRange(obj);
}
public StockReaderForm()
{
InitializeComponent();
stockDataGridView.AutoGenerateColumns = false;
LoadConfigInfo();
BindColumns();
notifyIcon1.Visible = false;
dataList = new SortableBindingList<TickerData>();
portfolioPath = "";
if (portfolio != null)
ProcessTickers();
sortColumn = stockDataGridView.Columns[0];
sortOrder = stockDataGridView.SortOrder;
//int interval = info.TimerInterval;
if (config.ConfigData.Timer.interval <= 0)
{
tickerTimer.Interval = 60000; // default to 1 minute
}
else
{
tickerTimer.Interval = config.ConfigData.Timer.interval * 60000;
}
tickerTimer.Enabled = true;
}
public static void data_grid(DataGridView dgv_grid)
{
dgv_grid.AutoGenerateColumns = true;
DataGridViewCell Cell_1 = new DataGridViewTextBoxCell();
DataGridViewCell Cell_2 = new DataGridViewTextBoxCell();
DataGridViewCell Cell_3 = new DataGridViewTextBoxCell();
DataGridViewColumn col__from = new DataGridViewColumn();
DataGridViewColumn col__to = new DataGridViewColumn();
DataGridViewColumn col__length = new DataGridViewColumn();
col__from.HeaderText = "Откуда";
col__to.HeaderText = "Куда";
col__length.HeaderText = "Длина";
col__from.Width = 110;
col__to.Width = 110;
col__length.Width = 110;
col__from.CellTemplate = Cell_1;
col__to.CellTemplate = Cell_2;
col__length.CellTemplate = Cell_3;
dgv_grid.ReadOnly = false;
dgv_grid.AllowUserToAddRows = true;
dgv_grid.AllowUserToDeleteRows = true;
dgv_grid.Columns.Add(col__from);
dgv_grid.Columns.Add(col__to);
dgv_grid.Columns.Add(col__length);
}
/// <summary>
/// Constructor
/// </summary>
public PlayerSearchForm()
{
InitializeComponent();
SortedCol = DataTable.Columns[1];
SortedCol.HeaderCell.SortGlyphDirection = SortOrder.Ascending;
LimitSelect.SelectedIndex = 2;
}
private Column ApplyLayerStyling(Column top, IManualColumnLayer <object> layer)
{
if (top.Name.Contains("_CLayer") == false)
{
throw new ArgumentException("layer '" + top.Name + "' must contain '_CLayer' in it's name");
}
if (layer.LowerLayers.FirstOrDefault(c => c.DisplayIndex == 0) != null)
{
grid.HideFirstColumn();
top.DisplayIndex = 0;
}
if (grid._customNames.ContainsKey(top.Name)) //Apply Name
{
top.HeaderText = grid._customNames[top.Name];
}
if (grid._customizeColumns.ContainsKey(top.Name)) //Apply custom property
{
grid._customizeColumns[top.Name].ApplyProperties(top);
}
layer.LowerLayers.ForEach(l => l.Visible = layer.AreLowerVisible);
layer.LowerLayers.ForEach(l => l.ReadOnly = layer.IsReadOnly);
top.ReadOnly = layer.IsReadOnly;
return(top);
}
public override DataGridViewColumn[] GetColunas()
{
var colunas = new DataGridViewColumn[]
{
new DataGridViewTextBoxColumn
{
DataPropertyName = "Id",
HeaderText = "Id",
},
new DataGridViewTextBoxColumn
{
DataPropertyName = "Nome",
HeaderText = "Nome"
},
new DataGridViewTextBoxColumn
{
DataPropertyName = "Contato",
HeaderText = "Contato"
},
new DataGridViewTextBoxColumn
{
DataPropertyName = "Nota",
HeaderText = "Nota"
}
};
return colunas;
}
public DataGridViewSortCompareEventArgs (DataGridViewColumn dataGridViewColumn, object cellValue1, object cellValue2, int rowIndex1, int rowIndex2) {
this.dataGridViewColumn = dataGridViewColumn;
this.cellValue1 = cellValue1;
this.cellValue2 = cellValue2;
this.rowIndex1 = rowIndex1;
this.rowIndex2 = rowIndex2;
}
string GetColumnText(DataGridViewColumn column)
{
if (column.HeaderText == "" && column is DataGridViewButtonColumn)
return ((DataGridViewButtonColumn)column).Text;
return column.HeaderText;
}
void OnColumnFocus(int ColumnIndex)
{
// If the new cell is in the same column, do nothing:
if (ColumnIndex != _currentColumn.Index)
{
// Set up a custom font to represent the current column:
Font selectedFont = new Font(this.Font, FontStyle.Bold);
// Grab a reference to the current column:
var newColumn = this.Columns[ColumnIndex];
// Change the font to indicate status:
newColumn.HeaderCell.Style.Font = selectedFont;
// Change the color to a slightly darker shade of gray:
newColumn.HeaderCell.Style.BackColor = Color.LightGray;
// Set the font of the previous column back to normal:
_currentColumn.HeaderCell.Style.Font = this.Font;
// Change the color of the previous column back to the default:
_currentColumn.HeaderCell.Style.BackColor = Color.Empty;
// Set the current column placeholder to refer to the new column:
_currentColumn = newColumn;
}
}
public override DataGridViewColumn[] GetColunas()
{
var colunas = new DataGridViewColumn[]
{
new DataGridViewTextBoxColumn
{
DataPropertyName = "Id",
HeaderText = "Id",
},
new DataGridViewTextBoxColumn
{
DataPropertyName = "Nome",
HeaderText = "Nome"
},
new DataGridViewTextBoxColumn
{
DataPropertyName = "Validade",
HeaderText = "Validade"
},
new DataGridViewTextBoxColumn
{
DataPropertyName = "Quantidade",
HeaderText = "Quantidade"
},
};
return colunas;
}
/// <summary>
/// �\���Ώۂ̍s���ݒ肷��D
/// </summary>
/// <param name="m"></param>
public void SetMatrix(KrdLab.Lisys.Matrix m)
{
this.DataGridView.Rows.Clear();
this.DataGridView.Columns.Clear();
if (m == null)
{
return;
}
for (int c = 0; c < m.ColumnSize; ++c)
{
var gridCol = new DataGridViewColumn();
gridCol.HeaderText = String.Format("[ , {0}]", c);
gridCol.ReadOnly = true;
gridCol.SortMode = DataGridViewColumnSortMode.NotSortable;
this.DataGridView.Columns.Add(gridCol);
}
for (int r = 0; r < m.RowSize; ++r)
{
var gridRow = new DataGridViewRow();
gridRow.HeaderCell.Value = String.Format("[{0}, ]", r);
gridRow.ReadOnly = true;
var row = m.Rows[r];
foreach (var v in row)
{
var cell = new DataGridViewTextBoxCell();
cell.Value = v.ToString();
gridRow.Cells.Add(cell);
}
this.DataGridView.Rows.Add(gridRow);
}
this.DataGridView.RowHeadersWidth = 100;
}
// CONSTRUCTORS
public AlleleCheckPrefab(Allele allele, Series series, DataGridViewColumn column, int row)
{
_series = series;
_col = column;
build(allele, row);
}
//-------------------------------------------------------------------------------------
/// <summary>
/// Возвращает коллекцию столбцов как массив.
/// </summary>
/// <returns></returns>
public static DataGridViewColumn[] ToArray(this DataGridViewColumnCollection cols)
{
DataGridViewColumn[] res = new DataGridViewColumn[cols.Count];
for(int a = 0; a < cols.Count; a++)
res[a] = cols[a];
return res;
}
public static IList<DataGridViewColumn> GetColumnsSortedByDisplayIndex(DataGridView dataGridView)
{
var result = new DataGridViewColumn[dataGridView.Columns.Count];
dataGridView.Columns.CopyTo(result, 0);
Array.Sort(result, (a, b) => a.DisplayIndex.CompareTo(b.DisplayIndex));
return result;
}
/// ------------------------------------------------------------------------------------
public CheckBoxColumnHeaderHandler(DataGridViewColumn col)
{
Debug.Assert(col != null);
Debug.Assert(col is DataGridViewCheckBoxColumn);
Debug.Assert(col.DataGridView != null);
_col = col;
_owningGrid = col.DataGridView;
_owningGrid.HandleDestroyed += HandleHandleDestroyed;
_owningGrid.CellPainting += HandleHeaderCellPainting;
_owningGrid.CellMouseMove += HandleHeaderCellMouseMove;
_owningGrid.CellMouseClick += HandleHeaderCellMouseClick;
_owningGrid.CellContentClick += HandleDataCellCellContentClick;
_owningGrid.Scroll += HandleGridScroll;
_owningGrid.RowsAdded += HandleGridRowsAdded;
_owningGrid.RowsRemoved += HandleGridRowsRemoved;
if (!BetterGrid.CanPaintVisualStyle())
_szCheckBox = new Size(13, 13);
else
{
var element = VisualStyleElement.Button.CheckBox.CheckedNormal;
var renderer = new VisualStyleRenderer(element);
using (var g = _owningGrid.CreateGraphics())
_szCheckBox = renderer.GetPartSize(g, ThemeSizeType.True);
}
}
private void frmClientes_Load(object sender, EventArgs e)
{
try
{
ListaClientes();
DataGridViewColumn COL00 = new DataGridViewColumn();
COL00 = dgvMaestro.Columns["ID_CLIENTE"];
COL00.ReadOnly = true;
COL00.Visible = false;
COL00.HeaderText = "CODIGO";
DataGridViewColumn COL01 = new DataGridViewColumn();
COL01 = dgvMaestro.Columns["NOMBRE_CLIENTE"];
COL01.ReadOnly = true;
COL01.Visible = true;
COL01.HeaderText = "NOMBRE DEL CLIENTE";
COL01.Width = 350;
DataGridViewColumn COL02 = new DataGridViewColumn();
COL02 = dgvMaestro.Columns["DIRECCION"];
COL02.ReadOnly = true;
COL02.Visible = true;
COL02.HeaderText = "DIRECCION";
COL02.Width = 350;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void DataGridViewInitialize2()
{
var column1 = new DataGridViewColumn();
column1.HeaderText = "Назначение";
column1.Name = "Destination";
column1.CellTemplate = new DataGridViewTextBoxCell();
var column2 = new DataGridViewColumn();
column2.HeaderText = "Маска";
column2.Name = "Mask";
column2.CellTemplate = new DataGridViewTextBoxCell();
var column3 = new DataGridViewColumn();
column3.HeaderText = "Шлюз";
column3.Name = "Gateway";
column3.CellTemplate = new DataGridViewTextBoxCell();
var column4 = new DataGridViewColumn();
column4.HeaderText = "Интерфейс";
column4.Name = "Interface";
column4.CellTemplate = new DataGridViewTextBoxCell();
var column5 = new DataGridViewColumn();
column5.HeaderText = "Метрика";
column5.Name = "Metric";
column5.CellTemplate = new DataGridViewTextBoxCell();
dataGridView2.Columns.Add(column1);
dataGridView2.Columns.Add(column2);
dataGridView2.Columns.Add(column3);
dataGridView2.Columns.Add(column4);
dataGridView2.Columns.Add(column5);
}
public override DataGridViewColumn[] GetColunas()
{
var colunas = new DataGridViewColumn[]
{
new DataGridViewTextBoxColumn
{
DataPropertyName = "Id",
HeaderText = "Id",
},
new DataGridViewTextBoxColumn
{
DataPropertyName = "Descricao",
HeaderText = "Descricao da Despesa",
},
new DataGridViewTextBoxColumn
{
DataPropertyName = "Valor",
HeaderText = "Valor da Despesa",
},
new DataGridViewTextBoxColumn
{
DataPropertyName = "Categoria",
HeaderText = "Categoria da Despesa",
},
new DataGridViewTextBoxColumn
{
DataPropertyName = "Fornecedor",
HeaderText = "Fornecedor",
}
};
return colunas;
}
private DataGridViewColumn ReturnColumn()//выбор поля сортировки
{
System.Windows.Forms.DataGridViewColumn Col = dGV.Columns[0];
switch (lBFilters.SelectedIndex)
{
case 0:
Col = dGV.Columns[lBFilters.SelectedIndex];
break;
case 1:
Col = dGV.Columns[lBFilters.SelectedIndex];
break;
case 2:
Col = dGV.Columns[lBFilters.SelectedIndex];
break;
case 3:
Col = dGV.Columns[lBFilters.SelectedIndex];
break;
case 4:
Col = dGV.Columns[lBFilters.SelectedIndex];
break;
}
return(Col);
}
private DataGridViewColumn CreateNewColumn(string headText)
{
DataGridViewColumn column = new DataGridViewColumn(new DataGridViewTextBoxCell());
column.SortMode = DataGridViewColumnSortMode.NotSortable;
column.HeaderText = headText;
return column;
}
public DataGridViewColumnSpec(DataGridViewColumn column, Color backColor, Image image, bool useImage) : this(column, image)
{
Column = column;
this.Image = image;
BackColor = backColor;
UseImage = useImage;
}
public override DataGridViewColumn[] GetColunas()
{
var colunas = new DataGridViewColumn[]
{
new DataGridViewTextBoxColumn
{
DataPropertyName = "Id",
HeaderText = "Id",
},
new DataGridViewTextBoxColumn
{
DataPropertyName = "Descricao",
HeaderText = "Descricao"
},
new DataGridViewTextBoxColumn
{
DataPropertyName = "Valor",
HeaderText = "Valor"
},
new DataGridViewTextBoxColumn
{
DataPropertyName = "Categoria",
HeaderText = "Categoria"
},
new DataGridViewTextBoxColumn
{
DataPropertyName = "Cliente",
HeaderText = "Cliente"
}
};
return colunas;
}
public AFN(ArrayList transicio,string[] estadosA,string []sim, string [] esta, string ini)
{
InitializeComponent();
transiciones = transicio;
estadosAceptacion=estadosA;
simbolos=sim;
estados=esta;
inicio=ini;
for(int a=0;a<simbolos.Length;a++)
{
DataGridViewColumn columna = new DataGridViewColumn(new DataGridViewTextBoxCell());
columna.Name = (string)simbolos[a];
columna.Width = 30;
dataGridView1.Columns.Add(columna);
}
DataGridViewColumn columnaf = new DataGridViewColumn(new DataGridViewTextBoxCell());
columnaf.Name = "F";
dataGridView1.Columns.Add(columnaf);
for (int b = 0; b < estados.Length; b++)
{
dataGridView1.Rows.Add();
dataGridView1["QΣ", b].Value = estados[b];
}
agregarDatos();
}
public NgColumnExtention()
{
_column = new DataGridViewTextBoxColumn();
_column.Name = "ngSourceColumn";
_column.HeaderText = "NgSource";
_column.Width = 50;
_column.ReadOnly = true;
}
private void button1_Click(object sender, EventArgs e)
{
System.Windows.Forms.DataGridViewColumn Col = default(System.Windows.Forms.DataGridViewColumn);
switch (listBox1.SelectedIndex)
{
case 0:
Col = dataGridViewTextBoxColumn2;
break;
case 1:
Col = dataGridViewTextBoxColumn3;
break;
case 2:
Col = dataGridViewTextBoxColumn4;
break;
case 3:
Col = dataGridViewTextBoxColumn5;
break;
case 4:
Col = dataGridViewTextBoxColumn6;
break;
case 5:
Col = dataGridViewTextBoxColumn7;
break;
case 6:
Col = dataGridViewTextBoxColumn8;
break;
case 7:
Col = dataGridViewTextBoxColumn9;
break;
case 8:
Col = dataGridViewTextBoxColumn10;
break;
case 9:
Col = dataGridViewTextBoxColumn11;
break;
case 10:
Col = dataGridViewTextBoxColumn12;
break;
}
if (radioButton1.Checked)
{
студентыDataGridView.Sort(Col, System.ComponentModel.ListSortDirection.Ascending);
}
else
{
студентыDataGridView.Sort(Col, System.ComponentModel.ListSortDirection.Descending);
}
}
public ColumnInfo(System.Windows.Forms.DataGridViewColumn col, ColumnType type)
{
this.col = col;
this.imeMode = System.Windows.Forms.ImeMode.NoControl;
this.defaultVal = null;
this.sortComparison = null;
this.DBvalueSet = null;
this.CellvalueSet = null;
this.columnType = type;
}
private void button5_Click(object sender, EventArgs e)
{
COL = new System.Windows.Forms.DataGridViewColumn();
switch (listBox1.SelectedIndex)
{
case 0:
COL = dataGridViewTextBoxColumn2;
break;
case 1:
COL = dataGridViewTextBoxColumn3;
break;
case 2:
COL = dataGridViewTextBoxColumn4;
break;
case 3:
COL = dataGridViewTextBoxColumn5;
break;
case 4:
COL = dataGridViewTextBoxColumn6;
break;
case 5:
COL = dataGridViewTextBoxColumn7;
break;
case 6:
COL = dataGridViewTextBoxColumn8;
break;
case 7:
COL = dataGridViewTextBoxColumn9;
break;
case 8:
COL = dataGridViewTextBoxColumn10;
break;
}
if (radioButton1.Checked == true)
{
оборудованиеDataGridView.Sort(COL, System.ComponentModel.ListSortDirection.Ascending);
}
else
{
оборудованиеDataGridView.Sort(COL, System.ComponentModel.ListSortDirection.Descending);
}
}
public IRawElementProviderSimple GetItem(int row, int column)
{
//According to http://msdn.microsoft.com/en-us/library/ms743401.aspx
if (row < 0 || column < 0 || row >= RowCount || column >= ColumnCount)
{
throw new ArgumentOutOfRangeException();
}
DataGridViewProvider.DataGridDataItemProvider item
= (DataGridViewProvider.DataGridDataItemProvider)gridviewprovider.GetItemProviderFrom(gridviewprovider,
gridviewprovider.DataGridView.Rows [row],
false);
SWF.DataGridViewColumn viewColumn
= gridviewprovider.DataGridView.Columns [column];
return(item.GetChildItem(viewColumn));
}
//функция для разбиения поля на ячейки
public void Colums()
{
int k = this.dataGridView1.Size.Width / 30;
System.Windows.Forms.DataGridViewColumn[] f = new System.Windows.Forms.DataGridViewColumn[] { };
for (int i = 0; i < k; i++)
{
System.Windows.Forms.DataGridViewTextBoxColumn co = new System.Windows.Forms.DataGridViewTextBoxColumn();
co.Width = 30;
this.dataGridView1.Columns.Add(co);
}
k = this.dataGridView1.Size.Height / 30;
for (int i = 0; i < k - 1; i++)
{
this.dataGridView1.Rows.Add();
}
}
private void BtnFilter_Click(object sender, EventArgs e)
{
System.Windows.Forms.DataGridViewColumn Col = default;
switch (LBoxFilter.SelectedIndex)
{
case 0:
Col = Login;
break;
case 1:
Col = fio;
break;
case 2:
Col = address;
break;
case 3:
Col = position;
break;
case 4:
Col = phone;
break;
case 5:
Col = address;
break;
case 6:
Col = email;
break;
}
if (RBAsc.Checked)
{
DGVStaff.Sort(Col, System.ComponentModel.ListSortDirection.Ascending);
}
else
{
DGVStaff.Sort(Col, System.ComponentModel.ListSortDirection.Descending);
}
}
/// <summary>
/// 设置表格的宽度
/// </summary>
/// <param name="gridView">表格控件</param>
/// <param name="columnName">列名称</param>
/// <param name="width">宽度</param>
public static void SetGridColumWidth(this DataGridView gridView, string columnName, int width)
{
System.Windows.Forms.DataGridViewColumn column = null;
if (gridView.Columns.Contains(columnName))
{
column = gridView.Columns[columnName];
if (column != null)
{
column.Width = width;
}
}
else if (gridView.Columns.Contains(columnName.ToUpper()))
{
column = gridView.Columns[columnName.ToUpper()];
if (column != null)
{
column.Width = width;
}
}
}
protected virtual DataGridViewColumn[] RetornaArrayDeColunasDoDGV()
{
System.Windows.Forms.DataGridViewTextBoxColumn teste = new System.Windows.Forms.DataGridViewTextBoxColumn();
System.Windows.Forms.DataGridViewColumn[] result = new System.Windows.Forms.DataGridViewColumn[]
{
teste
};
// teste
teste.HeaderText = "Teste";
teste.MaxInputLength = 30;
teste.Name = "teste";
teste.ReadOnly = true;
teste.Resizable = System.Windows.Forms.DataGridViewTriState.True;
teste.Width = 100;
teste.DefaultCellStyle = dgv.ColumnHeadersDefaultCellStyle;
return(result);
}
public int GetColumnMaxWidth(System.Windows.Forms.DataGridViewColumn column)
{
int w = column.Width;
Size size = TextRenderer.MeasureText(column.HeaderText, this.Font);
if (size.Width > w)
{
w = size.Width;
}
for (int i = 0; i < this.Rows.Count; i++)
{
if (!(this.Rows[i].Cells[column.Name].Value.IsNullOrEmpty()))
{
size = TextRenderer.MeasureText(this.Rows[i].Cells[column.Name].Value.ToString(), this.Font);
if (size.Width > w)
{
w = size.Width;
}
}
}
return(w);
}
private void BtnFilter_Click(object sender, EventArgs e)
{
System.Windows.Forms.DataGridViewColumn Col = default;
switch (LBoxFilter.SelectedIndex)
{
case 0:
Col = staff_id;
break;
case 1:
Col = date1;
break;
case 2:
Col = date2;
break;
case 3:
Col = hours;
break;
case 4:
Col = payhours;
break;
case 5:
Col = sum;
break;
}
if (RBAsc.Checked)
{
DGVPay.Sort(Col, System.ComponentModel.ListSortDirection.Ascending);
}
else
{
DGVPay.Sort(Col, System.ComponentModel.ListSortDirection.Descending);
}
}
public int IndexOf(DataGridViewColumn dataGridViewColumn)
{
return(base.List.IndexOf(dataGridViewColumn));
}
public void Insert(int index, DataGridViewColumn dataGridViewColumn)
{
throw new NotSupportedException("Insert is not allowed.");
}
public bool Contains(DataGridViewColumn dataGridViewColumn)
{
return(base.List.Contains(dataGridViewColumn));
}
public ColumnInfo(System.Windows.Forms.DataGridViewColumn col)
: this(col, ColumnType.Unknown)
{
}
internal void InternalAdd(DataGridViewColumn dataGridViewColumn)
{
base.List.Add(dataGridViewColumn);
}
/// <summary>
/// Рекурсивно перевести элементы управления Windows-формы
/// </summary>
private static void TranslateWinControls(IList controls, WinForms.ToolTip toolTip,
Dictionary <string, ControlInfo> controlInfoDict)
{
if (controls == null)
{
return;
}
foreach (object elem in controls)
{
ControlInfo controlInfo;
if (elem is WinForms.Control)
{
// обработка обычного элемента управления
WinForms.Control control = (WinForms.Control)elem;
if (!string.IsNullOrEmpty(control.Name) /*например, поле ввода и кнопки NumericUpDown*/ &&
controlInfoDict.TryGetValue(control.Name, out controlInfo))
{
if (controlInfo.Text != null)
{
control.Text = controlInfo.Text;
}
if (controlInfo.ToolTip != null && toolTip != null)
{
toolTip.SetToolTip(control, controlInfo.ToolTip);
}
if (controlInfo.Items != null && elem is WinForms.ComboBox)
{
WinForms.ComboBox comboBox = (WinForms.ComboBox)elem;
int cnt = Math.Min(comboBox.Items.Count, controlInfo.Items.Count);
for (int i = 0; i < cnt; i++)
{
string itemText = controlInfo.Items[i];
if (itemText != null)
{
comboBox.Items[i] = itemText;
}
}
}
}
if (elem is WinForms.MenuStrip)
{
// запуск обработки элементов меню
WinForms.MenuStrip menuStrip = (WinForms.MenuStrip)elem;
TranslateWinControls(menuStrip.Items, toolTip, controlInfoDict);
}
else if (elem is WinForms.ToolStrip)
{
// запуск обработки элементов панели инструментов
WinForms.ToolStrip toolStrip = (WinForms.ToolStrip)elem;
TranslateWinControls(toolStrip.Items, toolTip, controlInfoDict);
}
else if (elem is WinForms.DataGridView)
{
// запуск обработки столбцов таблицы
WinForms.DataGridView dataGridView = (WinForms.DataGridView)elem;
TranslateWinControls(dataGridView.Columns, toolTip, controlInfoDict);
}
else if (elem is WinForms.ListView)
{
// запуск обработки столбцов списка
WinForms.ListView listView = (WinForms.ListView)elem;
TranslateWinControls(listView.Columns, toolTip, controlInfoDict);
}
// запуск обработки дочерних элементов
if (control.HasChildren)
{
TranslateWinControls(control.Controls, toolTip, controlInfoDict);
}
}
else if (elem is WinForms.ToolStripItem)
{
// обработка элемента меню или элемента панели инструментов
WinForms.ToolStripItem item = (WinForms.ToolStripItem)elem;
if (controlInfoDict.TryGetValue(item.Name, out controlInfo))
{
if (controlInfo.Text != null)
{
item.Text = controlInfo.Text;
}
if (controlInfo.ToolTip != null)
{
item.ToolTipText = controlInfo.ToolTip;
}
}
if (elem is WinForms.ToolStripMenuItem)
{
// запуск обработки элементов подменю
WinForms.ToolStripMenuItem menuItem = (WinForms.ToolStripMenuItem)elem;
if (menuItem.HasDropDownItems)
{
TranslateWinControls(menuItem.DropDownItems, toolTip, controlInfoDict);
}
}
}
else if (elem is WinForms.DataGridViewColumn)
{
// обработка столбца таблицы
WinForms.DataGridViewColumn column = (WinForms.DataGridViewColumn)elem;
if (controlInfoDict.TryGetValue(column.Name, out controlInfo) && controlInfo.Text != null)
{
column.HeaderText = controlInfo.Text;
}
}
else if (elem is WinForms.ColumnHeader)
{
// обработка столбца списка
WinForms.ColumnHeader columnHeader = (WinForms.ColumnHeader)elem;
if (controlInfoDict.TryGetValue(columnHeader.Name, out controlInfo) && controlInfo.Text != null)
{
columnHeader.Text = controlInfo.Text;
}
}
}
}
private void GetThemaByStockCode()
{
RichQuery richQuery = new RichQuery();
KiwoomQuery kiwoomQuery = new KiwoomQuery();
DataTable dt4 = new DataTable();
string strMaxDate = richQuery.p_TDATEQuery(query: "2", tradeDate: "", fromDate: "", toDate: "", bln3tier: false).Tables[0].Rows[0]["MAX_TRADE_DATE"].ToString();
richQuery = null;
richQuery = new RichQuery();
DataTable dt = richQuery.p_ThemaQuery(query: "1", THEMA_CODE: lblThema.Text, TGPSEQ_NO: lblThemaGroup.Text, THEMA_NAME: "", WORK_ID: "", bln3tier: false).Tables[0].Copy();
int row = 0;
_clsDataGridViewUtil.RemoveGridViewRow(dgvThemaPerStock);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
dgvThemaPerStock.Rows.Add();
dgvThemaPerStock.Rows[row].Cells["ThemaByStock_THEMA_NAME"].Value = dr["THEMA_NAME"].ToString().Trim();
dgvThemaPerStock.Rows[row].Cells["ThemaByStock_STOCK_NAME"].Value = dr["STOCK_NAME"].ToString().Trim();
dgvThemaPerStock.Rows[row].Cells["ThemaByStock_STOCK_CODE"].Value = dr["STOCK_CODE"].ToString().Trim();
dt4 = kiwoomQuery.p_StockCodeOptInfoQuery(query: "1", stockCode: dr["STOCK_CODE"].ToString().Trim(), stockDate: "", bln3tier: false).Tables[0].Copy();
if (dt4 != null)
{
if (dt4.Rows.Count > 0)
{
if (_firstCall == false)
{
foreach (DataColumn dc in dt4.Columns)
{
System.Windows.Forms.DataGridViewColumn dgvColumn = new System.Windows.Forms.DataGridViewColumn();
System.Windows.Forms.DataGridViewCell cell = new System.Windows.Forms.DataGridViewTextBoxCell();
if (dc.ColumnName.ToString() == "STOCK_CODE" || dc.ColumnName.ToString() == "CALL_TIME")
{
continue;
}
if (dc.ColumnName.ToString() == "CALL_DATE")
{
dgvColumn.CellTemplate = cell;
dgvColumn.HeaderText = "기준일자";
dgvColumn.Name = "OPT10001_CALL_DATE";
dgvThemaPerStock.Columns.Add(dgvColumn);
dgvColumn = null;
dgvColumn = new DataGridViewColumn();
dgvColumn.CellTemplate = cell;
dgvColumn.HeaderText = "대금대비시총";
dgvColumn.Name = "대금대비시총";
dgvThemaPerStock.Columns.Add(dgvColumn);
continue;
}
dgvColumn.CellTemplate = cell;
dgvColumn.HeaderText = dc.ColumnName.ToString();
dgvColumn.Name = dc.ColumnName.ToString();
dgvThemaPerStock.Columns.Add(dgvColumn);
}
_firstCall = true;
}
foreach (DataColumn dc in dt4.Columns)
{
if (dc.ColumnName.ToString() == "STOCK_CODE" || dc.ColumnName.ToString() == "CALL_TIME")
{
continue;
}
if (dc.ColumnName.ToString() == "CALL_DATE")
{
dgvThemaPerStock.Rows[row].Cells["OPT10001_CALL_DATE"].Value = dt4.Rows[0][dc.ColumnName.ToString()].ToString();
}
else
{
dgvThemaPerStock.Rows[row].Cells[columnName : dc.ColumnName.ToString()].Value = dt4.Rows[0][dc.ColumnName.ToString()].ToString();
}
}
}
}
dt = null;
dt = new DataTable();
row = row + 1;
}
SetDataGridView();
}
}
/// <include file='doc\DataGridViewAutoSizeColumnModeEventArgs.uex' path='docs/doc[@for="DataGridViewAutoSizeColumnModeEventArgs.DataGridViewAutoSizeColumnModeEventArgs"]/*' />
public DataGridViewAutoSizeColumnModeEventArgs(DataGridViewColumn dataGridViewColumn, DataGridViewAutoSizeColumnMode previousMode)
{
Debug.Assert(dataGridViewColumn != null);
this.dataGridViewColumn = dataGridViewColumn;
this.previousMode = previousMode;
}
public void Insert(int index, DataGridViewColumn dataGridViewColumn)
{
throw null;
}
public bool Contains(DataGridViewColumn dataGridViewColumn)
{
throw null;
}
public virtual void RemoveAt(int index)
{
DataGridViewColumn col = this [index];
Remove(col);
}
public virtual void Remove(DataGridViewColumn dataGridViewColumn)
{
DataGridView.OnColumnPreRemovedInternal(new DataGridViewColumnEventArgs(dataGridViewColumn));
base.List.Remove(dataGridViewColumn);
OnCollectionChanged(new CollectionChangeEventArgs(CollectionChangeAction.Remove, dataGridViewColumn));
}
internal void InternalRemove(DataGridViewColumn dataGridViewColumn)
{
base.List.Remove(dataGridViewColumn);
}
