public void ShowUsers(DataGridView gv, DataGridViewColumn UserIdGv, DataGridViewColumn UseNameGv, DataGridViewColumn UserPasswordGv, DataGridViewColumn UserContactGv, DataGridViewColumn UserEmailGv, DataGridViewColumn Role, DataGridViewColumn RoleId, string Data = null)
{
try
{
SqlCommand cmd; //= new SqlCommand();
if (Data == null)
{
cmd = new SqlCommand("Usp_GetUserDetails", MainClass.con);
}
else
{
cmd = new SqlCommand("Usp_SearchUserDetails", MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Data", Data);
}
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
UserIdGv.DataPropertyName = dt.Columns["ID"].ToString();
UseNameGv.DataPropertyName = dt.Columns["Username"].ToString();
UserPasswordGv.DataPropertyName = dt.Columns["Password"].ToString();
UserContactGv.DataPropertyName = dt.Columns["Contact Number"].ToString();
UserEmailGv.DataPropertyName = dt.Columns["Email Id"].ToString();
Role.DataPropertyName = dt.Columns["Role"].ToString();
RoleId.DataPropertyName = dt.Columns["RoleId"].ToString();
gv.DataSource = dt;
}
catch (Exception exp)
{
MainClass.ShowMessage("Unable to Load users data", "Error", "Error");
}
}
private String CreateFilterString()
{
StringBuilder sb = new StringBuilder("");
foreach (string name in this.filterOrder)
{
DataGridViewColumn column = this.Columns[name];
if (column != null)
{
ADGVColumnHeaderCell cell = column.HeaderCell as ADGVColumnHeaderCell;
if (cell != null && cell.ActiveFilterType != ADGVFilterType.None)
{
sb.AppendFormat("(" + cell.FilterString + ") AND ", column.DataPropertyName);
}
}
}
if (sb.Length > 4)
{
sb.Length -= 4;
}
return(sb.ToString());
}
} // method
/// <summary>
/// Correct formatting to show object name for columns trying
/// to bind to EF objects.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public static void FormatDoubles(DataGridView dgv, DataGridViewCellFormattingEventArgs e)
{
string dpn = "??";
try
{
DataGridViewRow row = dgv.Rows[e.RowIndex];
DataGridViewColumn col = dgv.Columns[e.ColumnIndex];
if (row.DataBoundItem != null)
{
dpn = col.DataPropertyName;
//if ( dpn.ToLower() == "state" )
// { bool stopHere = true; }
var obj = row.DataBoundItem;
//string name = row.DataBoundItem.ToString();
// You could check for what the databound item is here
//string firstPart = row.DataBoundItem.GetType().Name;
//if (firstPart.Length > 15)
// firstPart = firstPart.Substring(0, 14) + "...";
string colType = col.ValueType.FullName;
if (colType == "System.Double")
{
e.Value = Math.Round((double)e.Value, 2);
}
}
}
catch (Exception ex)
{
throw new ApplicationException(string.Format("Err={0}", ex.ToString()));
}
} // method
private void Wrapping_Load(object sender, EventArgs e)
{
dataGridView1.DataSource = Program.StoreDB.GetProducts();
foreach (DataGridViewColumn col in dataGridView1.Columns)
{
col.Visible = false;
}
// Retrieve the columns you need to work with.
DataGridViewColumn colID = dataGridView1.Columns["ProductID"];
DataGridViewColumn colModel = dataGridView1.Columns["ModelName"];
DataGridViewColumn colDesc = dataGridView1.Columns["Description"];
colID.Visible = true;
colModel.Visible = true;
colDesc.Visible = true;
colID.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
colModel.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
colDesc.DefaultCellStyle.WrapMode = DataGridViewTriState.True;
colDesc.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.DisplayedCells;
}
private void btnDelete_Click(object sender, EventArgs e)
{
DataGridView gv = dataGridView1;
if (gv.SelectedCells.Count > 0)
{
DataGridViewColumn col = gv.Columns[gv.SelectedCells[0].ColumnIndex];
if (col.DataGridView.SelectedCells.Count > 0 && gv.SelectedCells[0].Selected)
{
DataGridViewRow dr = gv.SelectedCells[0].OwningRow;
int id = -1;
id = int.Parse(dr.Cells[ChequeReplyEntity.FIELD_ID].Value.ToString());
DialogResult dres = MessageBox.Show("آیا مایلید حذف کنید ؟", "", MessageBoxButtons.YesNo);
if (dres.Equals(DialogResult.Yes))
{
_chequeReplyBL.delete(id);
checkColorOFCheque();
fillGrid();
}
}
}
}
protected override void OnKeyDown(KeyEventArgs e)
{
try {
if (e.Control && (e.KeyCode == Keys.Add || e.KeyCode == Keys.Subtract))
{
DataGridViewColumn c = this.Columns[this.CurrentCell.ColumnIndex];
if (!c.ReadOnly)
{
grid_cell_type ct = c.Tag != null && c.Tag is grid_cell_type ? (grid_cell_type)c.Tag : grid_cell_type.none;
if (ct == grid_cell_type.date)
{
this.BeginEdit(true);
DateTime dt = Convert.ToDateTime(this.CurrentCell.Value);
this.CurrentCell.Value = dt.AddDays(e.KeyCode == Keys.Add ? 1 : -1);
this.EndEdit();
}
}
}
else
{
base.OnKeyDown(e);
}
} catch { }
}
//Função que Carrega os usuários logados da Ferramenta no GRID
#region USUARIOS LOGADOS
void carrega_logados()
{
DataTable dt1 = new DataTable();
Connection con1 = new Connection();
string contagem = "select COUNT(*) as valor from login";
string Str1 = "select id_user,fullname as NOME,USERNAME as 'LOGIN' from login where status_logon =1";
SqlCommand cmd = new SqlCommand(Str1, con1.cone());
SqlCommand cmd1 = new SqlCommand(contagem, con1.cone());
SqlDataReader read_contagem;
read_contagem = cmd1.ExecuteReader();
read_contagem.Read();
sb_valor.Text = read_contagem["valor"].ToString();
cmd.CommandTimeout = 0;
dt1.Load(cmd.ExecuteReader());
dataGridView2.DataSource = null;
dataGridView2.DataSource = dt1;
this.dataGridView2.Columns["id_user"].Visible = false;
DataGridViewColumn column = dataGridView2.Columns[1];
DataGridViewColumn column3 = dataGridView2.Columns[2];
column.Width = 200;
column3.Width = 200;
}
private void configuracionGrilla(DataTable dt)
{
if (dt.Rows.Count == 0)
{
MessageBox.Show("No se han encontrado publicaciones con estos criterios");
}
else
{
String espectaculo = dt.Rows[0]["Espectáculo"].ToString(); //0
String Asiento = dt.Rows[0]["Asiento"].ToString(); //1
String Fila = dt.Rows[0]["Fila"].ToString(); //2
String Precio = dt.Rows[0]["Precio"].ToString(); //3
String fecha = dt.Rows[0]["Fecha de evento"].ToString(); //4
String Categoria = dt.Rows[0]["Categoría"].ToString(); //5
dataGridView1.DataSource = null;
dataGridView1.DataSource = dt;
DataGridViewColumn column = dataGridView1.Columns[1];
column.Width = 250;
DataGridViewColumn column1 = dataGridView1.Columns[2];
column1.Width = 50;
DataGridViewColumn column2 = dataGridView1.Columns[3];
column2.Width = 50;
DataGridViewColumn column3 = dataGridView1.Columns[4];
column3.Width = 80;
DataGridViewColumn column4 = dataGridView1.Columns[5];
column4.Width = 100;
DataGridViewColumn column5 = dataGridView1.Columns[6];
column4.Width = 90;
labelPaginas.Text = paginaActual.ToString() + " de " + ultimaHoja.ToString();
}
return;
}
private void FilterOutNaN(DocumentGridForm documentGrid)
{
var columnIdCv = new ColumnId(AggregateOperation.Cv.QualifyColumnCaption(new ColumnCaption("NormalizedArea")));
DataGridViewColumn columnCv = null;
RunUI(() =>
{
var pdCv = documentGrid.DataboundGridControl.BindingListSource.ItemProperties
.FirstOrDefault(pd => ColumnId.GetColumnId(pd).Equals(columnIdCv));
Assert.IsNotNull(pdCv);
columnCv = documentGrid.DataboundGridControl.DataGridView.Columns.OfType <DataGridViewColumn>()
.FirstOrDefault(col => col.DataPropertyName == pdCv.Name);
});
Assert.IsNotNull(columnCv);
var quickFilterForm =
ShowDialog <QuickFilterForm>(() => documentGrid.DataboundGridControl.QuickFilter(columnCv));
RunUI(() =>
{
quickFilterForm.SetFilterOperation(0, FilterOperations.OP_NOT_EQUALS);
quickFilterForm.SetFilterOperand(0, double.NaN.ToString(CultureInfo.CurrentCulture));
});
OkDialog(quickFilterForm, quickFilterForm.OkDialog);
}
private void RefreshSummaryTextBoxCache()
{
if (this._SummaryColumns == null || this._SummaryColumns.Length == 0)
{
this._SummaryContainer.Visible = false;
return;
}
this._SummaryContainer.Visible = this._SummaryRowVisible;
//统计列
for (int i = 0; i < this._SummaryColumns.Length; i++)
{
if (this.GridViewColumns.ContainsKey(_SummaryColumns[i]))
{
SummaryTextBox sumTextBox = new SummaryTextBox();
DataGridViewColumn currCol = this.GridViewColumns[_SummaryColumns[i]];
sumTextBox.Name = currCol.DataPropertyName.Trim() == "" ? currCol.Name : currCol.DataPropertyName;
sumTextBox.IsSummary = true;
sumTextBox.IsHeaderLabel = false;
if (!this._SummaryTextHashTable.ContainsKey(currCol))
{
this._SummaryTextHashTable.Add(currCol, sumTextBox);
}
if (currCol.DisplayIndex == 0)
{
_FirstColSumTextType = SummaryTextType.Number;
}
}
}
//非统计列
foreach (DataGridViewColumn currCol in this.GridViewColumns.Values)
{
if (!_SummaryTextHashTable.ContainsKey(currCol))
{
SummaryTextBox sumTextBox = new SummaryTextBox();
sumTextBox.Name = currCol.DataPropertyName.Trim() == "" ? currCol.Name : currCol.DataPropertyName;
sumTextBox.IsSummary = false;
sumTextBox.IsHeaderLabel = false;
this._SummaryTextHashTable.Add(currCol, sumTextBox);
}
}
foreach (DataGridViewColumn currCol in this.GridViewColumns.Values)
{
if (_FirstColSumTextType == SummaryTextType.None)
{
//取得当前列的下一列
DataGridViewColumn NextCol = this.Columns.GetNextColumn(currCol, DataGridViewElementStates.None, DataGridViewElementStates.None);
if (NextCol == null)
{
break;
}
if (NextCol.Name.Trim() == "")
{
continue;
}
SummaryTextBox nextSumTextBox = this._SummaryTextHashTable[NextCol] as SummaryTextBox;
SummaryTextBox currSumTextBox = this._SummaryTextHashTable[currCol] as SummaryTextBox;
currSumTextBox.Name = currCol.DataPropertyName.Trim() == "" ? currCol.Name : currCol.DataPropertyName;
//如果下一列对应是SummaryTextBox实例是合计，且第一列不是头列时设置第一列为头列类型
if (nextSumTextBox.IsSummary && _FirstColSumTextType != SummaryTextType.Text)
{
currSumTextBox.IsHeaderLabel = true;
currSumTextBox.IsSummary = false;
currSumTextBox.Visible = true;
_FirstColSumTextType = SummaryTextType.Text;
}
else
{
currSumTextBox.IsHeaderLabel = false;
currSumTextBox.IsSummary = false;
currSumTextBox.Visible = false;
}
}
}
}
private void checkUsingDotNetDataTable()
{
string commandText;
try
{
if (GlobalVariables.SourceIsTableOrViewMode == true)
{
commandText = "SELECT * FROM " + GlobalVariables.SourceObjectName;
}
else
{
commandText = GlobalVariables.SourceCommandText;
}
DbDataAdapter adapter = GlobalVariables.SourceConnection.CreateAdapter(commandText); // new DbDataAdapter(commandText, GlobalVariables.SourceConnection.GetConn());
DataTable dt = new DataTable();
adapter.Fill(dt);
string[] columnNames = GlobalVariables.ColumnMappings.Where(cm => cm.TransformationCode == ETransformationCode.BUSINESS_KEY).Select(c => c.SourceColumn.Substring(1, c.SourceColumn.Length - 2)).ToArray();
DataView dv = new DataView(dt);
//getting distinct values for group column
DataTable dtGroup = dv.ToTable(true, columnNames);
//adding column for the row count
dtGroup.Columns.Add("Count", typeof(int));
//looping thru distinct values for the group, counting
foreach (DataRow dr in dtGroup.Rows)
{
string filter = "";
for (int i = 0; i < columnNames.Length; i++)
{
if (!string.IsNullOrEmpty(filter))
{
filter += " AND ";
}
MyDbColumn c1 = GlobalVariables.SourceColumns.Find(sc => sc.ColumnName.Equals("[" + columnNames[i] + "]"));
filter += c1.ColumnName + " = ";
if (!c1.IsNumeric)
{
filter += "'";
}
filter += dr[columnNames[i]].ToString();
if (!c1.IsNumeric)
{
filter += "'";
}
}
string func = string.Format("Count({0})", GlobalVariables.ColumnMappings.Where(cm => cm.TransformationCode != ETransformationCode.SKIP && cm.TransformationCode != ETransformationCode.BUSINESS_KEY && cm.IsSourceColumnDefined).First().SourceColumn);
dr["Count"] = dt.Compute(func, filter);
}
dt.Dispose();
DataRow[] rows = (from r in dtGroup.AsEnumerable()
where r.Field <int>("Count") > 1
select r).ToArray();
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
if (rows.Length > 0)
{
for (int i = 0; i < rows[0].Table.Columns.Count; i++)
{
DataGridViewColumn col = new DataGridViewColumn();
DataGridViewCell cell = new DataGridViewTextBoxCell();
col.CellTemplate = cell;
col.Name = rows[0].Table.Columns[i].ColumnName;
dataGridView1.Columns.Add(col);
}
foreach (var row in rows)
{
dataGridView1.Rows.Add(row.ItemArray);
}
MessageBox.Show("Unfortunately, there are some duplicate Business Keys found. Check table for details.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("Congratulations, no duplicate Business Keys found", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
dataGridView1.Rows.Clear();
MyExceptionHandler.NewEx(ex);
}
}
private DataGridViewCellStyle GetOldStyle(DataGridViewColumn col)
{
return((DataGridViewCellStyle)m_stylesColHead[col]);
}
public static DataGridView GetDataGridPortfolios()
{
DataGridView _gridPosition = DataGridFactory.GetDataGridView(DataGridViewSelectionMode.FullRowSelect, DataGridViewAutoSizeRowsMode.None);
DataGridViewTextBoxCell cell0 = new DataGridViewTextBoxCell();
cell0.Style = _gridPosition.DefaultCellStyle;
DataGridViewColumn column0 = new DataGridViewColumn();
column0.CellTemplate = cell0;
column0.HeaderText = OsLocalization.Entity.ColumnPortfolio1;
column0.ReadOnly = true;
column0.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
_gridPosition.Columns.Add(column0);
DataGridViewColumn column = new DataGridViewColumn();
column.CellTemplate = cell0;
column.HeaderText = OsLocalization.Entity.ColumnPortfolio2;
column.ReadOnly = true;
column.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
_gridPosition.Columns.Add(column);
DataGridViewColumn column1 = new DataGridViewColumn();
column1.CellTemplate = cell0;
column1.HeaderText = OsLocalization.Entity.ColumnPortfolio3;
column1.ReadOnly = true;
column1.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
_gridPosition.Columns.Add(column1);
DataGridViewColumn column3 = new DataGridViewColumn();
column3.CellTemplate = cell0;
column3.HeaderText = OsLocalization.Entity.ColumnPortfolio4;
column3.ReadOnly = true;
column3.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
_gridPosition.Columns.Add(column3);
DataGridViewColumn column4 = new DataGridViewColumn();
column4.CellTemplate = cell0;
column4.HeaderText = OsLocalization.Entity.ColumnPortfolio5;
column4.ReadOnly = true;
column4.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
_gridPosition.Columns.Add(column4);
DataGridViewColumn column5 = new DataGridViewColumn();
column5.CellTemplate = cell0;
column5.HeaderText = OsLocalization.Entity.ColumnPortfolio6;
column5.ReadOnly = true;
column5.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
_gridPosition.Columns.Add(column5);
DataGridViewColumn column6 = new DataGridViewColumn();
column6.CellTemplate = cell0;
column6.HeaderText = OsLocalization.Entity.ColumnPortfolio7;
column6.ReadOnly = true;
column6.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
_gridPosition.Columns.Add(column6);
DataGridViewColumn column7 = new DataGridViewColumn();
column7.CellTemplate = cell0;
column7.HeaderText = OsLocalization.Entity.ColumnPortfolio8;
column7.ReadOnly = true;
column7.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
_gridPosition.Columns.Add(column7);
return(_gridPosition);
}
public static DataGridView GetDataGridMyTrade(bool readOnly = true)
{
DataGridView newGrid = GetDataGridView(DataGridViewSelectionMode.FullRowSelect,
DataGridViewAutoSizeRowsMode.AllCells);
newGrid.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize;
DataGridViewTextBoxCell cell0 = new DataGridViewTextBoxCell();
cell0.Style = newGrid.DefaultCellStyle;
// 0 Id
DataGridViewColumn colum0 = new DataGridViewColumn();
colum0.CellTemplate = cell0;
colum0.HeaderText = OsLocalization.Entity.TradeColumn1;
colum0.ReadOnly = true;
colum0.Width = 50;
newGrid.Columns.Add(colum0);
// 1 Order Id
DataGridViewColumn colum03 = new DataGridViewColumn();
colum03.CellTemplate = cell0;
colum03.HeaderText = OsLocalization.Entity.TradeColumn2;
colum03.ReadOnly = true;
colum03.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum03);
// 2 Security
DataGridViewColumn colum01 = new DataGridViewColumn();
colum01.CellTemplate = cell0;
colum01.HeaderText = OsLocalization.Entity.TradeColumn3;
colum01.ReadOnly = true;
colum01.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum01);
// 3 Time
if (readOnly)
{
DataGridViewColumn colum02 = new DataGridViewColumn();
colum02.CellTemplate = cell0;
colum02.HeaderText = OsLocalization.Entity.TradeColumn4;
colum02.ReadOnly = true;
colum02.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum02);
}
else
{
DataGridViewButtonColumn colum02 = new DataGridViewButtonColumn();
colum02.HeaderText = OsLocalization.Entity.TradeColumn4;
colum02.ReadOnly = true;
colum02.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum02);
}
// 4 Price
DataGridViewColumn colu = new DataGridViewColumn();
colu.CellTemplate = cell0;
colu.HeaderText = OsLocalization.Entity.TradeColumn5;
colu.ReadOnly = readOnly;
colu.Width = 60;
newGrid.Columns.Add(colu);
// 5 Volume
DataGridViewColumn colum1 = new DataGridViewColumn();
colum1.CellTemplate = cell0;
colum1.HeaderText = OsLocalization.Entity.TradeColumn6;
colum1.ReadOnly = readOnly;
colum1.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum1);
// 6 Direction
if (readOnly)
{
DataGridViewColumn colum2 = new DataGridViewColumn();
colum2.CellTemplate = cell0;
colum2.HeaderText = OsLocalization.Entity.TradeColumn7;
colum2.ReadOnly = true;
colum2.Width = 40;
newGrid.Columns.Add(colum2);
}
else
{
DataGridViewComboBoxColumn dirColumn = new DataGridViewComboBoxColumn();
dirColumn.HeaderText = OsLocalization.Entity.TradeColumn7;
dirColumn.ReadOnly = readOnly;
dirColumn.Width = 60;
newGrid.Columns.Add(dirColumn);
}
return(newGrid);
}
public static DataGridView GetDataGridPosition(bool readOnly = true)
{
DataGridView newGrid = GetDataGridView(DataGridViewSelectionMode.FullRowSelect,
DataGridViewAutoSizeRowsMode.AllCells);
newGrid.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize;
DataGridViewCellStyle style = newGrid.DefaultCellStyle;
DataGridViewTextBoxCell cell0 = new DataGridViewTextBoxCell();
cell0.Style = style;
DataGridViewColumn colum0 = new DataGridViewColumn();
colum0.CellTemplate = cell0;
colum0.HeaderText = OsLocalization.Entity.PositionColumn1;
colum0.ReadOnly = true;
colum0.Width = 50;
newGrid.Columns.Add(colum0);
DataGridViewColumn colum01 = new DataGridViewColumn();
colum01.CellTemplate = cell0;
colum01.HeaderText = OsLocalization.Entity.PositionColumn2;
colum01.ReadOnly = true;
colum01.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum01);
DataGridViewColumn colum02 = new DataGridViewColumn();
colum02.CellTemplate = cell0;
colum02.HeaderText = OsLocalization.Entity.PositionColumn3;
colum02.ReadOnly = true;
colum02.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum02);
DataGridViewColumn colu = new DataGridViewColumn();
colu.CellTemplate = cell0;
colu.HeaderText = OsLocalization.Entity.PositionColumn4;
colu.ReadOnly = readOnly;
colu.Width = 70;
newGrid.Columns.Add(colu);
DataGridViewColumn colum1 = new DataGridViewColumn();
colum1.CellTemplate = cell0;
colum1.HeaderText = OsLocalization.Entity.PositionColumn5;
colum1.ReadOnly = readOnly;
colum1.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum1);
// position SIDE
if (readOnly == true)
{
DataGridViewColumn colum2 = new DataGridViewColumn();
colum2.CellTemplate = cell0;
colum2.HeaderText = OsLocalization.Entity.PositionColumn6;
colum2.ReadOnly = readOnly;
colum2.Width = 60;
newGrid.Columns.Add(colum2);
}
else
{
DataGridViewComboBoxColumn dirColumn = new DataGridViewComboBoxColumn();
dirColumn.HeaderText = OsLocalization.Entity.PositionColumn6;
dirColumn.ReadOnly = readOnly;
dirColumn.Width = 60;
newGrid.Columns.Add(dirColumn);
}
// position STATE
if (readOnly == true)
{
DataGridViewColumn colum3 = new DataGridViewColumn();
colum3.CellTemplate = cell0;
colum3.HeaderText = OsLocalization.Entity.PositionColumn7;
colum3.ReadOnly = readOnly;
colum3.Width = 100;
newGrid.Columns.Add(colum3);
}
else
{
DataGridViewComboBoxColumn stateColumn = new DataGridViewComboBoxColumn();
stateColumn.HeaderText = OsLocalization.Entity.PositionColumn7;
stateColumn.ReadOnly = readOnly;
stateColumn.Width = 100;
newGrid.Columns.Add(stateColumn);
}
DataGridViewColumn colum4 = new DataGridViewColumn();
colum4.CellTemplate = cell0;
colum4.HeaderText = OsLocalization.Entity.PositionColumn8;
colum4.ReadOnly = true;
colum4.Width = 60;
newGrid.Columns.Add(colum4);
DataGridViewColumn colum45 = new DataGridViewColumn();
colum45.CellTemplate = cell0;
colum45.HeaderText = OsLocalization.Entity.PositionColumn9;
colum45.ReadOnly = true;
colum45.Width = 60;
newGrid.Columns.Add(colum45);
DataGridViewColumn colum5 = new DataGridViewColumn();
colum5.CellTemplate = cell0;
colum5.HeaderText = OsLocalization.Entity.PositionColumn10;
colum5.ReadOnly = true;
colum5.Width = 60;
newGrid.Columns.Add(colum5);
DataGridViewColumn colum6 = new DataGridViewColumn();
colum6.CellTemplate = cell0;
colum6.HeaderText = OsLocalization.Entity.PositionColumn11;
colum6.ReadOnly = true;
colum6.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum6);
DataGridViewColumn colum61 = new DataGridViewColumn();
colum61.CellTemplate = cell0;
colum61.HeaderText = OsLocalization.Entity.PositionColumn12;
colum61.ReadOnly = true;
colum61.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum61);
DataGridViewColumn colum8 = new DataGridViewColumn();
colum8.CellTemplate = cell0;
colum8.HeaderText = OsLocalization.Entity.PositionColumn13;
colum8.ReadOnly = true;
colum8.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum8);
DataGridViewColumn colum9 = new DataGridViewColumn();
colum9.CellTemplate = cell0;
colum9.HeaderText = OsLocalization.Entity.PositionColumn14;
colum9.ReadOnly = readOnly;
colum9.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum9);
DataGridViewColumn colum10 = new DataGridViewColumn();
colum10.CellTemplate = cell0;
colum10.HeaderText = OsLocalization.Entity.PositionColumn15;
colum10.ReadOnly = readOnly;
colum10.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum10);
DataGridViewColumn colum11 = new DataGridViewColumn();
colum11.CellTemplate = cell0;
colum11.HeaderText = OsLocalization.Entity.PositionColumn16;
colum11.ReadOnly = readOnly;
colum11.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum11);
DataGridViewColumn colum12 = new DataGridViewColumn();
colum12.CellTemplate = cell0;
colum12.HeaderText = OsLocalization.Entity.PositionColumn17;
colum12.ReadOnly = readOnly;
colum12.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum12);
DataGridViewColumn colum13 = new DataGridViewColumn();
colum13.CellTemplate = cell0;
colum13.HeaderText = OsLocalization.Entity.PositionColumn18;
colum13.ReadOnly = readOnly;
colum13.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum13);
DataGridViewColumn colum14 = new DataGridViewColumn();
colum14.CellTemplate = cell0;
colum14.HeaderText = OsLocalization.Entity.PositionColumn19;
colum14.ReadOnly = readOnly;
colum14.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
colum14.Width = 60;
newGrid.Columns.Add(colum14);
return(newGrid);
}
public virtual void AddRange(DataGridViewColumn[] dataGridViewColumns) {}
public virtual void Remove(DataGridViewColumn dataGridViewColumn) {}
private void Display(uint?mcl) // update display. mcl can be null
{
last_mcl = mcl;
DataGridViewColumn sortcolprev = dataGridViewMC.SortedColumn != null ? dataGridViewMC.SortedColumn : dataGridViewMC.Columns[0];
SortOrder sortorderprev = dataGridViewMC.SortedColumn != null ? dataGridViewMC.SortOrder : SortOrder.Ascending;
int firstline = dataGridViewMC.SafeFirstDisplayedScrollingRowIndex();
dataGridViewMC.Rows.Clear();
textBoxItems1.Text = textBoxItems2.Text = "";
if (mcl == null)
{
return;
}
//System.Diagnostics.Debug.WriteLine("Display mcl " + mcl.GetHashCode());
string filters = GetSetting(dbFilter, "All");
//System.Diagnostics.Debug.WriteLine("Filter is " + filters);
string[] filter = filters.SplitNoEmptyStartFinish(';');
bool all = filter.Length > 0 && filter[0] == "All";
bool showzeros = checkBoxShowZeros.Checked;
dataViewScrollerPanel.SuspendLayout();
MaterialCommodityMicroResourceType[] allitems = PanelMode == PanelType.Materials ? MaterialCommodityMicroResourceType.GetMaterials(true) : PanelMode == PanelType.MicroResources ? MaterialCommodityMicroResourceType.GetMicroResources(true) : MaterialCommodityMicroResourceType.GetCommodities(true);
foreach (MaterialCommodityMicroResourceType mcd in allitems) // we go thru all items..
{
if (all || filter.Contains(mcd.FDName)) // and see if they are in the filter
{
object[] rowobj;
MaterialCommodityMicroResource m = discoveryform.history.MaterialCommoditiesMicroResources.Get(mcl.Value, mcd.FDName); // at generation mcl, find fdname.
if (showzeros || (m != null && m.NonZero)) // if display zero, or we have some..
{
string s = "";
if (PanelMode == PanelType.Materials)
{
s = Recipes.UsedInRecipesByFDName(mcd.FDName, Environment.NewLine);
int limit = mcd.MaterialLimit() ?? 0;
rowobj = new[] { mcd.Name, mcd.Shortname, mcd.TranslatedCategory,
mcd.TranslatedType + (limit > 0 ? " (" + limit.ToString() + ")" : ""),
m != null?m.Count.ToString() : "0", s };
}
else if (PanelMode == PanelType.MicroResources)
{
rowobj = new[] { mcd.Name, mcd.Shortname, mcd.TranslatedCategory,
m != null ? m.Counts[0].ToString() : "0", m != null ? m.Counts[1].ToString() : "0" };
}
else
{
s = Recipes.UsedInRecipesByFDName(mcd.FDName, Environment.NewLine);
rowobj = new[] { mcd.Name, mcd.TranslatedType,
m != null?m.Count.ToString() : "0",
m != null?m.Price.ToString("0.#") : "-", s };
}
dataGridViewMC.Rows.Add(rowobj);
dataGridViewMC.Rows[dataGridViewMC.RowCount - 1].Cells[dataGridViewMC.ColumnCount - 1].ToolTipText = s;
dataGridViewMC.Rows[dataGridViewMC.RowCount - 1].Tag = s;
}
}
}
dataViewScrollerPanel.ResumeLayout();
dataGridViewMC.Sort(sortcolprev, (sortorderprev == SortOrder.Descending) ? ListSortDirection.Descending : ListSortDirection.Ascending);
dataGridViewMC.Columns[sortcolprev.Index].HeaderCell.SortGlyphDirection = sortorderprev;
if (firstline >= 0 && firstline < dataGridViewMC.RowCount)
{
dataGridViewMC.SafeFirstDisplayedScrollingRowIndex(firstline);
}
var mcllist = discoveryform.history.MaterialCommoditiesMicroResources.Get(mcl.Value);
var counts = MaterialCommoditiesMicroResourceList.Count(mcllist);
if (PanelMode == PanelType.Materials)
{
textBoxItems1.Text = counts[(int)MaterialCommodityMicroResourceType.CatType.Encoded].ToString();
textBoxItems2.Text = (counts[(int)MaterialCommodityMicroResourceType.CatType.Raw] + counts[(int)MaterialCommodityMicroResourceType.CatType.Manufactured]).ToString();
}
else if (PanelMode == PanelType.MicroResources)
{
textBoxItems1.Text = (counts[(int)MaterialCommodityMicroResourceType.CatType.Data] + counts[(int)MaterialCommodityMicroResourceType.CatType.Component] +
counts[(int)MaterialCommodityMicroResourceType.CatType.Item] + counts[(int)MaterialCommodityMicroResourceType.CatType.Consumable]).ToString();
}
else
{
textBoxItems1.Text = counts[(int)MaterialCommodityMicroResourceType.CatType.Commodity].ToString();
}
}
public COH_ToolTipObject(Control ctl, string nameStr)
{
this.ttControl = ctl;
this.ttDataGridViewColumn = null;
this.ttControlName = nameStr;
}
public void Sort(DataGridViewColumn dataGridViewColumn, ListSortDirection direction)
{
((IBindingList) this.List).ApplySort(this.props[dataGridViewColumn.BoundColumnIndex], direction);
}
public DataGridViewColumn[] GetCollectionOfBoundDataGridViewColumns()
{
if (this.props == null)
{
return null;
}
ArrayList list = new ArrayList();
for (int i = 0; i < this.props.Count; i++)
{
if (!typeof(IList).IsAssignableFrom(this.props[i].PropertyType) || TypeDescriptor.GetConverter(typeof(Image)).CanConvertFrom(this.props[i].PropertyType))
{
DataGridViewColumn dataGridViewColumnFromType = GetDataGridViewColumnFromType(this.props[i].PropertyType);
dataGridViewColumnFromType.IsDataBoundInternal = true;
dataGridViewColumnFromType.BoundColumnIndex = i;
dataGridViewColumnFromType.DataPropertyName = this.props[i].Name;
dataGridViewColumnFromType.Name = this.props[i].Name;
dataGridViewColumnFromType.BoundColumnConverter = this.props[i].Converter;
dataGridViewColumnFromType.HeaderText = !string.IsNullOrEmpty(this.props[i].DisplayName) ? this.props[i].DisplayName : this.props[i].Name;
dataGridViewColumnFromType.ValueType = this.props[i].PropertyType;
dataGridViewColumnFromType.IsBrowsableInternal = this.props[i].IsBrowsable;
dataGridViewColumnFromType.ReadOnly = this.props[i].IsReadOnly;
list.Add(dataGridViewColumnFromType);
}
}
DataGridViewColumn[] array = new DataGridViewColumn[list.Count];
list.CopyTo(array);
return array;
}
private void Parse()
{
var sb = new StringBuilder();
int countToFix = 0;
DataGridViewColumn column = null;
try
{
dgv.Invoke((MethodInvoker)(() => column = dgv.Columns[cbSourceColumn.SelectedItem.ToString()]));
pbProgress.Invoke((MethodInvoker)(() => pbProgress.Maximum = dgv.Rows.Count));
DateTime startTime = DateTime.Now;
for (int i = 0; i < dgv.Rows.Count; i++)
{
try
{
var cell = dgv[column.Index, i];
string value = cell.Value?.ToString();
if (string.IsNullOrWhiteSpace(value))
{
continue;
}
lblCurrentAddress.Invoke((MethodInvoker)(() => lblCurrentAddress.Text = value));
foreach (Replacement r in lbReplace.Items)
{
value = value.Replace(r.source, r.replace);
}
var parsed = parser.Parse(value);
if (parsed?.Count > 0)
{
var lastNode = parsed[0];
parser.MakeActualHierarchy(lastNode);
ObjectNode region = null;
while (lastNode != null)
{
sb.Clear();
if (lastNode.Type == TableType.Object)
{
sb.Append(lastNode.ShortNameType);
sb.Append(" ");
}
sb.Append(lastNode.Name);
var name = sb.ToString();
//регион
if (lastNode.AOLevel > 0 && lastNode.AOLevel < 3)
{
dgv[MainForm.REGION_FIELD, i].Value = name;
region = lastNode;
}
//город
else if (lastNode.AOLevel == 4 || lastNode.AOLevel == 6)
{
dgv[MainForm.CITY_FIELD, i].Value = name;
}
//улица
else if (lastNode.AOLevel == 7 || lastNode.AOLevel == 91)
{
dgv[MainForm.STREET_FIELD, i].Value = name;
}
//дом
else if (lastNode.Type == TableType.House)
{
dgv[MainForm.HOUSE_FIELD, i].Value = name;
}
lastNode = lastNode.Parent;
}
if (region != null)
{
dgv[MainForm.DISTRICT_FIELD, i].Value = parser.GetDistrictByRegion(region.Name);
}
if (!string.IsNullOrEmpty(dgv[MainForm.REGION_FIELD, i].Value?.ToString()) &&
!string.IsNullOrEmpty(dgv[MainForm.STREET_FIELD, i].Value?.ToString()) &&
string.IsNullOrEmpty(dgv[MainForm.CITY_FIELD, i].Value?.ToString()))
{
dgv[MainForm.CITY_FIELD, i].Value = dgv[MainForm.REGION_FIELD, i].Value;
}
}
//Progress
///lblProgress
sb.Clear();
sb.Append(i + 1);
sb.Append("/");
sb.Append(dgv.Rows.Count);
lblProgress.Invoke((MethodInvoker)(() => lblProgress.Text = sb.ToString()));
///lblRemained
TimeSpan timeRemained = TimeSpan.FromTicks(DateTime.Now.Subtract(startTime).Ticks *
(dgv.Rows.Count - (i + 1)) / (i + 1));
lblRemained.Invoke((MethodInvoker)(() => lblRemained.Text = "Осталось: " + timeRemained.ToString()));
///pbProgress
pbProgress.Invoke((MethodInvoker)(() => pbProgress.Increment(1)));
///StatusField, lblCountToFix
if (MainForm.IsHasEmptyField(dgv, i))
{
dgv[MainForm.STATUS_FIELD, i].Value = "PROBLEMS";
countToFix++;
}
else
{
dgv[MainForm.STATUS_FIELD, i].Value = "GOOD";
}
sb.Clear();
sb.Append("Cтрок со статусом PROBLEMS: ");
sb.Append(countToFix);
sb.Append(" из ");
sb.Append(i + 1);
lblCountToFix.Invoke((MethodInvoker)(() => lblCountToFix.Text = sb.ToString()));
}
catch
{
dgv[MainForm.STATUS_FIELD, i].Value = "PROBLEMS";
countToFix++;
}
}
Parsed = true;
MessageBox.Show("Обработка завершена.");
SwitchGUI(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
// Constructors
public DataGridViewAutoSizeColumnModeEventArgs(DataGridViewColumn dataGridViewColumn, DataGridViewAutoSizeColumnMode previousMode) {}
public ColumnHeaderCellEventArgs(MenuStrip filterMenu, DataGridViewColumn column)
{
FilterMenu = filterMenu;
Column = column;
}
// Constructors
public DataGridViewColumnStateChangedEventArgs(DataGridViewColumn dataGridViewColumn, DataGridViewElementStates stateChanged) {}
public virtual void Insert(int columnIndex, DataGridViewColumn dataGridViewColumn) {}
// Methods
public virtual void Sort(DataGridViewColumn dataGridViewColumn, System.ComponentModel.ListSortDirection direction) {}
public virtual int Add(DataGridViewColumn dataGridViewColumn) {}
/// <summary>
/// Constructor for <see cref="DataGridViewColumnVWG"/>
/// </summary>
/// <param name="dataGridViewColumn"></param>
public DataGridViewColumnVWG(DataGridViewColumn dataGridViewColumn)
{
_dataGridViewColumn = dataGridViewColumn;
}
private void dataGridView_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView sortDgv = (DataGridView)sender;
int fx = 0;
if (sortDgv.AccessibleDescription == null)
{
fx = 1;
}
else
{
fx = int.Parse(sortDgv.AccessibleDescription);
fx = (fx == 0 ? 1 : 0);
}
sortDgv.AccessibleDescription = fx.ToString();
if (sortDgv.Columns[e.ColumnIndex].Name == xh_field)
{
return;
}
DataGridViewColumn nCol = sortDgv.Columns[e.ColumnIndex];
if (nCol.DataPropertyName == string.Empty)
{
return;
}
if (nCol != null)
{
sortDgv.Sort(nCol, fx == 0 ? ListSortDirection.Ascending : ListSortDirection.Descending);
}
//--
DataRow dr = (DataRow)sortDgv.Tag;
DataTable dt = (DataTable)sortDgv.DataSource;
DataRow ndr = dt.NewRow();
ndr.BeginEdit();
for (int i = 0; i < dt.Columns.Count; i++)
{
ndr[i] = dr[i];
}
dt.Rows.Remove(dr);
//if (e.ColumnIndex != 0)
{
int n = 1;
for (int i = 0; i < sortDgv.Rows.Count; i++)
{
DataGridViewRow dgRow = sortDgv.Rows[i];
DataRowView drv = (DataRowView)dgRow.DataBoundItem;
DataRow tdr = drv.Row;
tdr.BeginEdit();
tdr[xh_field] = n;
n++;
tdr.EndEdit();
}
sortDgv.Refresh();
sortDgv.RefreshEdit();
}
ndr[xh_field] = ((int)(dt.Rows.Count + 1)).ToString();
ndr.EndEdit();
dt.Rows.Add(ndr);
sortDgv.Tag = ndr;
//--
sortDgv.Sort(sortDgv.Columns[xh_field], ListSortDirection.Ascending);
sortDgv.Columns[xh_field].HeaderCell.SortGlyphDirection = SortOrder.None;
nCol.HeaderCell.SortGlyphDirection = fx == 0 ? SortOrder.Ascending : SortOrder.Descending;
sortDgv.Rows[sortDgv.Rows.Count - 1].DefaultCellStyle.BackColor = Color.FromArgb(255, 255, 210);
}
public bool Contains(DataGridViewColumn dataGridViewColumn) {}
public static DataGridView GetDataGridOrder(bool readOnly = true)
{
DataGridView newGrid = GetDataGridView(DataGridViewSelectionMode.FullRowSelect,
DataGridViewAutoSizeRowsMode.AllCells);
newGrid.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize;
DataGridViewTextBoxCell cell0 = new DataGridViewTextBoxCell();
cell0.Style = newGrid.DefaultCellStyle;
// User ID
DataGridViewColumn colum0 = new DataGridViewColumn();
colum0.CellTemplate = cell0;
colum0.HeaderText = OsLocalization.Entity.OrderColumn1;
colum0.ReadOnly = true;
colum0.Width = 50;
newGrid.Columns.Add(colum0);
// Market ID
DataGridViewColumn colum01 = new DataGridViewColumn();
colum01.CellTemplate = cell0;
colum01.HeaderText = OsLocalization.Entity.OrderColumn2;
colum01.ReadOnly = readOnly;
colum01.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum01);
// Time Create
if (readOnly)
{
DataGridViewColumn colum02 = new DataGridViewColumn();
colum02.CellTemplate = cell0;
colum02.HeaderText = OsLocalization.Entity.OrderColumn3;
colum02.ReadOnly = true;
colum02.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum02);
}
else
{
DataGridViewButtonColumn colum02 = new DataGridViewButtonColumn();
colum02.HeaderText = OsLocalization.Entity.OrderColumn3;
colum02.ReadOnly = true;
colum02.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum02);
}
// Security
DataGridViewColumn colu = new DataGridViewColumn();
colu.CellTemplate = cell0;
colu.HeaderText = OsLocalization.Entity.OrderColumn4;
colu.ReadOnly = true;
colu.Width = 60;
newGrid.Columns.Add(colu);
// Portfolio
DataGridViewColumn colum1 = new DataGridViewColumn();
colum1.CellTemplate = cell0;
colum1.HeaderText = OsLocalization.Entity.OrderColumn5;
colum1.ReadOnly = readOnly;
colum1.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum1);
// Direction
if (readOnly)
{
DataGridViewColumn colum2 = new DataGridViewColumn();
colum2.CellTemplate = cell0;
colum2.HeaderText = OsLocalization.Entity.OrderColumn6;
colum2.ReadOnly = true;
colum2.Width = 40;
newGrid.Columns.Add(colum2);
}
else
{
DataGridViewComboBoxColumn dirColumn = new DataGridViewComboBoxColumn();
dirColumn.HeaderText = OsLocalization.Entity.OrderColumn6;
dirColumn.ReadOnly = readOnly;
dirColumn.Width = 60;
newGrid.Columns.Add(dirColumn);
}
// State
if (readOnly)
{
DataGridViewColumn colum3 = new DataGridViewColumn();
colum3.CellTemplate = cell0;
colum3.HeaderText = OsLocalization.Entity.OrderColumn7;
colum3.ReadOnly = true;
colum3.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum3);
}
else
{
DataGridViewComboBoxColumn stateColumn = new DataGridViewComboBoxColumn();
stateColumn.HeaderText = OsLocalization.Entity.OrderColumn7;
stateColumn.ReadOnly = readOnly;
stateColumn.Width = 100;
newGrid.Columns.Add(stateColumn);
}
// Price
DataGridViewColumn colum4 = new DataGridViewColumn();
colum4.CellTemplate = cell0;
colum4.HeaderText = OsLocalization.Entity.OrderColumn8;
colum4.ReadOnly = readOnly;
colum4.Width = 60;
newGrid.Columns.Add(colum4);
// Execution price
DataGridViewColumn colum45 = new DataGridViewColumn();
colum45.CellTemplate = cell0;
colum45.HeaderText = OsLocalization.Entity.OrderColumn9;
colum45.ReadOnly = true;
colum45.Width = 60;
newGrid.Columns.Add(colum45);
// Volume
DataGridViewColumn colum5 = new DataGridViewColumn();
colum5.CellTemplate = cell0;
colum5.HeaderText = OsLocalization.Entity.OrderColumn10;
colum5.ReadOnly = readOnly;
colum5.Width = 60;
newGrid.Columns.Add(colum5);
// Type
if (readOnly)
{
DataGridViewColumn colum6 = new DataGridViewColumn();
colum6.CellTemplate = cell0;
colum6.HeaderText = OsLocalization.Entity.OrderColumn11;
colum6.ReadOnly = true;
colum6.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum6);
}
else
{
DataGridViewComboBoxColumn typeColumn = new DataGridViewComboBoxColumn();
typeColumn.HeaderText = OsLocalization.Entity.OrderColumn11;
typeColumn.ReadOnly = readOnly;
typeColumn.Width = 70;
newGrid.Columns.Add(typeColumn);
}
// RoundTrip
DataGridViewColumn colum7 = new DataGridViewColumn();
colum7.CellTemplate = cell0;
colum7.HeaderText = OsLocalization.Entity.OrderColumn12;
colum7.ReadOnly = true;
colum7.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
newGrid.Columns.Add(colum7);
return(newGrid);
}
public void Insert(int index, DataGridViewColumn dataGridViewColumn) {}
public static DataGridView GetDataGridSecurities()
{
DataGridView grid = GetDataGridView(DataGridViewSelectionMode.FullRowSelect,
DataGridViewAutoSizeRowsMode.AllCellsExceptHeaders);
DataGridViewTextBoxCell cell0 = new DataGridViewTextBoxCell();
cell0.Style = grid.DefaultCellStyle;
DataGridViewColumn column0 = new DataGridViewColumn();
column0.CellTemplate = cell0;
column0.HeaderText = OsLocalization.Entity.SecuritiesColumn1;
column0.ReadOnly = true;
column0.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
grid.Columns.Add(column0);
DataGridViewColumn column = new DataGridViewColumn();
column.CellTemplate = cell0;
column.HeaderText = OsLocalization.Entity.SecuritiesColumn2;
column.ReadOnly = true;
column.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
grid.Columns.Add(column);
DataGridViewColumn column1 = new DataGridViewColumn();
column1.CellTemplate = cell0;
column1.HeaderText = OsLocalization.Entity.SecuritiesColumn3;
column1.ReadOnly = false;
column1.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
grid.Columns.Add(column1);
DataGridViewColumn column3 = new DataGridViewColumn();
column3.CellTemplate = cell0;
column3.HeaderText = OsLocalization.Entity.SecuritiesColumn4;
column3.ReadOnly = false;
column3.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
grid.Columns.Add(column3);
DataGridViewColumn column4 = new DataGridViewColumn();
column4.CellTemplate = cell0;
column4.HeaderText = OsLocalization.Entity.SecuritiesColumn5;
column4.ReadOnly = false;
column4.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
grid.Columns.Add(column4);
DataGridViewColumn column8 = new DataGridViewColumn();
column8.CellTemplate = cell0;
column8.HeaderText = "";
column8.ReadOnly = true;
column8.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
grid.Columns.Add(column8);
return(grid);
}
public DataGridViewAutoSizeColumnModeEventArgs (DataGridViewColumn dataGridViewColumn, DataGridViewAutoSizeColumnMode previousMode) {
this.dataGridViewColumn = dataGridViewColumn;
this.previousMode = previousMode;
}
public static DataGridView GetDataGridDataSource()
{
DataGridView myGridView = DataGridFactory.GetDataGridView(DataGridViewSelectionMode.FullRowSelect, DataGridViewAutoSizeRowsMode.None);
DataGridViewTextBoxCell cell0 = new DataGridViewTextBoxCell();
cell0.Style = myGridView.DefaultCellStyle;
DataGridViewColumn column2 = new DataGridViewColumn();
column2.CellTemplate = cell0;
column2.HeaderText = OsLocalization.Entity.ColumnDataSource1;
column2.ReadOnly = true;
column2.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
myGridView.Columns.Add(column2);
DataGridViewColumn column0 = new DataGridViewColumn();
column0.CellTemplate = cell0;
column0.HeaderText = OsLocalization.Entity.ColumnDataSource2;
column0.ReadOnly = true;
column0.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
myGridView.Columns.Add(column0);
DataGridViewColumn column = new DataGridViewColumn();
column.CellTemplate = cell0;
column.HeaderText = OsLocalization.Entity.ColumnDataSource3;
column.ReadOnly = false;
column.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
myGridView.Columns.Add(column);
DataGridViewColumn column1 = new DataGridViewColumn();
column1.CellTemplate = cell0;
column1.HeaderText = OsLocalization.Entity.ColumnDataSource4;
column1.ReadOnly = true;
column1.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
myGridView.Columns.Add(column1);
DataGridViewColumn column3 = new DataGridViewColumn();
column3.CellTemplate = cell0;
column3.HeaderText = OsLocalization.Entity.ColumnDataSource5;
column3.ReadOnly = true;
column3.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
myGridView.Columns.Add(column3);
DataGridViewColumn column4 = new DataGridViewColumn();
column4.CellTemplate = cell0;
column4.HeaderText = OsLocalization.Entity.ColumnDataSource6;
column4.ReadOnly = true;
column4.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
myGridView.Columns.Add(column4);
return(myGridView);
}
// Constructors
public DataGridViewColumnEventArgs(DataGridViewColumn dataGridViewColumn) {}
//A faire à l'occasion
private List <ToolStripMenuItem> GetDistinctOnColumn(DataGridViewColumn col)
{
List <ToolStripMenuItem> itms = new List <ToolStripMenuItem>();
return(itms);
}
public DataGridViewColumnStateChangedEventArgs (DataGridViewColumn dataGridViewColumn, DataGridViewElementStates stateChanged) {
this.dataGridViewColumn = dataGridViewColumn;
this.stateChanged = stateChanged;
}
private void checkUsingSourceQuery()
{
string commandText = "";
var initialCursor = this.Cursor;
object[] meta = new object[GlobalVariables.ColumnMappings.Count(cm => cm.TransformationCode == ETransformationCode.BUSINESS_KEY) + 1];
this.Cursor = Cursors.WaitCursor;
try
{
DbCommand cmd = GlobalVariables.SourceConnection.GetConn().CreateCommand();
string businessKeysCsv = string.Join(",", GlobalVariables.ColumnMappings.Where(cm => cm.TransformationCode == ETransformationCode.BUSINESS_KEY).Select(c => c.SourceColumn).ToArray());
commandText += string.Format("WITH cte as ( SELECT {0} FROM {1} ) SELECT {0}, COUNT(*) AS [COUNT] FROM cte GROUP BY {0} HAVING COUNT(*) > 1", businessKeysCsv, GlobalVariables.SourceObjectName);
cmd.CommandText = commandText;
DbDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
if (reader.FieldCount > 0)
{
for (int i = 0; i < reader.FieldCount; i++)
{
DataGridViewColumn col = new DataGridViewColumn();
DataGridViewCell cell = new DataGridViewTextBoxCell();
col.CellTemplate = cell;
col.Name = reader.GetName(i);
dataGridView1.Columns.Add(col);
}
int rowsCount = 0;
while (reader.Read())
{
reader.GetValues(meta);
dataGridView1.Rows.Add(meta);
rowsCount++;
if (rowsCount >= MAX_ROWS)
{
break;
}
}
reader.Close();
MessageBox.Show("Unfortunately, there are some duplicate Business Keys found. Check table for details.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
reader.Close();
MessageBox.Show("Congratulations, no duplicate Business Keys found", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
this.Cursor = initialCursor;
MyExceptionHandler.NewEx(ex);
}
this.Cursor = initialCursor;
}
public DataGridViewColumnEventArgs (DataGridViewColumn dataGridViewColumn) {
this.dataGridViewColumn = dataGridViewColumn;
}
public void FormInit()
{
SQLUtilEvent sQLUtilEvent = new SQLUtilEvent("select * from users");
sQLUtilEvent.OnRunWorkerCompleted += new EventHandler <RunWorkerCompletedEventArgs>((object senders, RunWorkerCompletedEventArgs es) =>
{
DataSet ds = (DataSet)es.Result;
ArrayList processor = new ArrayList();
foreach (DataRow dr in ds.Tables[0].Rows)
{
User u = new User();
u.Id = int.Parse(dr["id"].ToString());
u.UserId = dr["UserId"].ToString();
u.UserName = dr["UserName"].ToString();
u.Ty = int.Parse(dr["ty"].ToString());
if (u.Ty == 0)
{
processor.Add(u.UserName);
}
Users.Add(u);
}
SetComBoxDataSource(cbprocessor, (string[])processor.ToArray(typeof(string)), Login.Username);
processor.Add("全部");
SetComBoxDataSource(cbsearchprocessor, (string[])processor.ToArray(typeof(string)), "全部");
});
sQLUtilEvent.Run("sql");
Console.WriteLine("Init");
//loadpc.Visible = false;
ProcessBarStop();
if (!Directory.Exists(FilePath))
{
Directory.CreateDirectory(FilePath);
}
//dtsearchbegin.Format = DateTimePickerFormat.Custom;
//dtsearchbegin.CustomFormat = "yyyy-MM-dd";
DateTime dt = DateTime.Now;
dtsearchbegin.Text = dt.AddMonths(-1).ToString("yyy-MM-dd");
dtsearchend.Text = dt.ToString("yyy-MM-dd");
estimateDate.Text = dt.ToString("yyy-MM-dd");
//dtsearchend.Format = DateTimePickerFormat.Custom;
//dtsearchend.CustomFormat = "yyyy-MM-dd";
//estimateDate.Format = DateTimePickerFormat.Custom;
//estimateDate.CustomFormat = "yyyy-MM-dd";
StatusDataList = new Dictionary <string, string>()
{
{ "0", "进行中" }, { "1", "完成" }, { "4", "取消" }
};
SetComBoxDataSource(cbstatus, StatusDataList, "0");
//SetCB(cbprocessor, new string[] { "张茂洪", "高嘉富", "林自强", "钟少杰" }, loginDto.Username);
//SetCB(cbsearchprocessor, new string[] { "张茂洪", "高嘉富", "林自强", "钟少杰", "全部" }, "全部");
SetComBoxDataSource(cbsearchstatus, new Dictionary <string, string>()
{
{ "0", "进行中" }, { "1", "完成" }, { "4", "取消" }, { "-1", "全部" }
}, "-1");
//planlist.View = View.Details;
//planlist.CheckBoxes = false;
//planlist.FullRowSelect = true;
//PlanListColumn.Add(new ListColumn("日期", 135, "BizDate"));
//PlanListColumn.Add(new ListColumn("标题", 120, "title"));
//PlanListColumn.Add(new ListColumn("业务", 100, "relor"));
//PlanListColumn.Add(new ListColumn("预计完成", 100, "estimate"));
//PlanListColumn.Add(new ListColumn("状态", 100, "Status"));
//PlanListColumn.Add(new ListColumn("内容", 200, "Content"));
//PlanListColumn.Add(new ListColumn("完结人", 120, "compor"));
//PlanListColumn.Add(new ListColumn("完结日期", 120, "compDate"));
//PlanListColumn.Add(new ListColumn("修改人", 120, "modior"));
//PlanListColumn.Add(new ListColumn("修改日期", 120, "modidate"));
//PlanListColumn.Add(new ListColumn("文件名", 120, "filename"));
//PlanListColumn.Add(new ListColumn("制单人", 100, "creator"));
//PlanListColumn.Add(new ListColumn("备注", 200, "remark"));
//PlanListColumn.Add(new ListColumn("id", 0, "id"));
//foreach (ListColumn l in PlanListColumn)
//{
// ColumnHeader ch = new ColumnHeader();
// ch.Text = l.Text;
// ch.Width = l.Width;
// ch.TextAlign = l.M;
// planlist.Columns.Add(ch); //将列头添加到ListView控件。
//}
uiDataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
uiDataGridView1.AutoGenerateColumns = false;
//uiDataGridView1.AddColumn("日期", "BizDate", 135);
//uiDataGridView1.AddColumn("标题", "title", 120);
//uiDataGridView1.AddColumn("业务", "relor", 100);
//uiDataGridView1.AddColumn("预计完成", "estimate", 100);
//uiDataGridView1.AddColumn("状态", "Status", 100);
//uiDataGridView1.AddColumn("内容", "Content", 200);
//uiDataGridView1.AddColumn("完结人", "Compor", 120);
//uiDataGridView1.AddColumn("完结日期", "compDate", 120);
//uiDataGridView1.AddColumn("修改人", "modior", 120);
//uiDataGridView1.AddColumn("修改日期", "modidate", 120);
//uiDataGridView1.AddColumn("文件名", "filename", 120);
//uiDataGridView1.AddColumn("制单人", "creator", 100);
//uiDataGridView1.AddColumn("备注", "remark", 200);
uiDataGridView1.ReadOnly = true;
uiDataGridView1.CellFormatting +=
(object sen, DataGridViewCellFormattingEventArgs ev) =>
{
DataGridView dgv = (DataGridView)sen;
//得到当前要进行格式化设置的列
DataGridViewColumn column = uiDataGridView1.Columns[ev.ColumnIndex];
if (ev.Value == null)
{
return;
}
if (column.Name.EqualsIgnoreCase("Status"))
{
ev.Value = (ev.Value.ToString() == "0" ? "" : "√");
}
else if (column.Name.EqualsIgnoreCase("modior") || column.Name.EqualsIgnoreCase("creator"))
{
for (int i = 0; i < Users.Count; i++)
{
if (Users[i].UserId.EqualsIgnoreCase(ev.Value.ToString()))
{
ev.Value = Users[i].UserName;
}
}
}
};
for (int j = 0; j < uiDataGridView1.Columns.Count; j++)
{
string colName = uiDataGridView1.Columns[j].DataPropertyName;
if (colName.EqualsIgnoreCase("Status"))
{
uiDataGridView1.Columns[j].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
uiDataGridView1.Columns[j].Width = 50;
}
else if (colName.EqualsIgnoreCase("BizDate") || colName.EqualsIgnoreCase("estimate") || colName.EqualsIgnoreCase("compDate") || colName.EqualsIgnoreCase("modidate"))
{
uiDataGridView1.Columns[j].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
uiDataGridView1.Columns[j].Width = 100;
}
else if (colName.EqualsIgnoreCase("relor") || colName.EqualsIgnoreCase("Compor") || colName.EqualsIgnoreCase("modior") || colName.EqualsIgnoreCase("creator"))
{
uiDataGridView1.Columns[j].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
uiDataGridView1.Columns[j].Width = 70;
}
}
}
// Constructors
public DataGridViewSortCompareEventArgs(DataGridViewColumn dataGridViewColumn, object cellValue1, object cellValue2, int rowIndex1, int rowIndex2) {}
public COH_ToolTipObject(DataGridViewColumn dgvc, string nameStr)
{
this.ttControl = null;
this.ttDataGridViewColumn = dgvc;
this.ttControlName = nameStr;
}
public virtual bool Contains(DataGridViewColumn dataGridViewColumn) {}
public FormMasterItem()
{
InitializeComponent();
DataGridViewColumn grid_Col;
//add kolom kode
grid_Col = new DataGridViewColumn();
grid_Col.CellTemplate = new DataGridViewTextBoxCell();
grid_Col.DataPropertyName = MItem.ColumnNames.ItemId;
grid_Col.HeaderText = "Kode Barang";
grid_Master.Columns.Add(grid_Col);
//add kolom nama
grid_Col = new DataGridViewColumn();
grid_Col.CellTemplate = new DataGridViewTextBoxCell();
grid_Col.DataPropertyName = MItem.ColumnNames.ItemName;
grid_Col.HeaderText = "Nama Barang";
grid_Master.Columns.Add(grid_Col);
////add kolom satuan
//grid_Col = new DataGridViewColumn();
//grid_Col.CellTemplate = new DataGridViewTextBoxCell();
//grid_Col.DataPropertyName = MItem.ColumnNames.ItemSatuan;
//grid_Col.HeaderText = "Satuan";
//grid_Master.Columns.Add(grid_Col);
//add kolom harga per satuan
grid_Col = new DataGridViewColumn();
grid_Col.CellTemplate = new DataGridViewTextBoxCell();
grid_Col.DataPropertyName = MItem.ColumnNames.ItemPricePurchase;
grid_Col.HeaderText = "Harga Beli";
grid_Col.DefaultCellStyle.Format = "N";
grid_Col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
grid_Master.Columns.Add(grid_Col);
//add kolom harga per jual
grid_Col = new DataGridViewColumn();
grid_Col.CellTemplate = new DataGridViewTextBoxCell();
grid_Col.DataPropertyName = MItem.ColumnNames.ItemPriceMax;
grid_Col.HeaderText = "Harga Jual Retail";
grid_Col.DefaultCellStyle.Format = "N";
grid_Col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
grid_Master.Columns.Add(grid_Col);
//add kolom harga per jual grosir
grid_Col = new DataGridViewColumn();
grid_Col.CellTemplate = new DataGridViewTextBoxCell();
grid_Col.DataPropertyName = MItem.ColumnNames.ItemPriceMaxVip;
grid_Col.HeaderText = "Harga Jual Grosir";
grid_Col.DefaultCellStyle.Format = "N";
grid_Col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
grid_Master.Columns.Add(grid_Col);
bindingSource_Master.PositionChanged += new EventHandler(bindingSource_Master_PositionChanged);
bindingNavigatorAddNewItem.Click += new EventHandler(bindingNavigatorAddNewItem_Click);
bindingNavigatorEditItem.Click += new EventHandler(bindingNavigatorEditItem_Click);
bindingNavigatorDeleteItem.Click += new EventHandler(bindingNavigatorDeleteItem_Click);
bindingNavigatorSaveItem.Click += new EventHandler(bindingNavigatorSaveItem_Click);
bindingNavigatorRefresh.Click += new EventHandler(bindingNavigatorRefresh_Click);
//set numeric updown
ModuleControlSettings.SetNumericUpDown(itemPricePurchaseNumericUpDown);
ModuleControlSettings.SetNumericUpDown(itemPriceMaxNumericUpDown);
ModuleControlSettings.SetNumericUpDown(itemPricePurchaseAvgNumericUpDown, true);
ModuleControlSettings.SetNumericUpDown(itemPriceMaxVipNumericUpDown);
mItemTypeBindingSource.DataSource = DataMaster.GetAll(typeof(MItemType));
}
public void CopyTo(DataGridViewColumn[] array, int index) {}
public override void Init()
{
DBBaseName = PanelMode == PanelType.Materials ? "MaterialsGrid" : PanelMode == PanelType.Commodities ? "CommoditiesGrid" : "MicroResourcesGrid";
dataGridViewMC.MakeDoubleBuffered();
extCheckBoxWordWrap.Checked = GetSetting(dbWrapText, false);
UpdateWordWrap();
extCheckBoxWordWrap.Click += extCheckBoxWordWrap_Click;
var enumlist = new Enum[] { EDTx.UserControlMaterialCommodities_NameCol, EDTx.UserControlMaterialCommodities_ShortName, EDTx.UserControlMaterialCommodities_Category, EDTx.UserControlMaterialCommodities_Type, EDTx.UserControlMaterialCommodities_Number, EDTx.UserControlMaterialCommodities_Price };
var enumlisttt = new Enum[] { EDTx.UserControlMaterialCommodities_buttonFilter_ToolTip, EDTx.UserControlMaterialCommodities_textBoxItems1_ToolTip, EDTx.UserControlMaterialCommodities_textBoxItems2_ToolTip, EDTx.UserControlMaterialCommodities_checkBoxShowZeros_ToolTip, EDTx.UserControlMaterialCommodities_extCheckBoxWordWrap_ToolTip };
BaseUtils.Translator.Instance.TranslateControls(this, enumlist, null, "UserControlMaterialCommodities");
BaseUtils.Translator.Instance.TranslateTooltip(toolTip, enumlisttt, this, "UserControlMaterialCommodities");
cfs = new JournalFilterSelector();
cfs.AddAllNone();
MaterialCommodityMicroResourceType[] items;
Tuple <MaterialCommodityMicroResourceType.ItemType, string>[] types;
Price.Tag = Number.Tag = "Num"; // these tell the sorter to do numeric sorting
if (PanelMode == PanelType.Materials)
{
dataGridViewMC.Columns[5].HeaderText = "Recipes".T(EDTx.UserControlMaterialCommodities_Recipes);
labelItems1.Text = "Data".T(EDTx.UserControlMaterialCommodities_Data);
labelItems2.Text = "Mats".T(EDTx.UserControlMaterialCommodities_Mats);
items = MaterialCommodityMicroResourceType.GetMaterials(true);
types = MaterialCommodityMicroResourceType.GetTypes((x) => x.IsMaterial, true);
var cats = MaterialCommodityMicroResourceType.GetCategories((x) => x.IsMaterial, true);
foreach (var t in cats)
{
string[] members = MaterialCommodityMicroResourceType.GetFDNameMembersOfCategory(t.Item1, true);
cfs.AddGroupOption(String.Join(";", members) + ";", t.Item2);
}
}
else if (PanelMode == PanelType.MicroResources)
{
dataGridViewMC.ContextMenuStrip = null;
dataGridViewMC.Columns.Remove(Type);
Number.HeaderText = "Ship Locker".T(EDTx.UserControlMaterialCommodities_ShipLocker);
Price.HeaderText = "BackPack".T(EDTx.UserControlMaterialCommodities_BackPack);
labelItems1.Text = "Total".T(EDTx.UserControlMaterialCommodities_Total);
textBoxItems2.Visible = labelItems2.Visible = false;
items = MaterialCommodityMicroResourceType.GetMicroResources(true);
types = MaterialCommodityMicroResourceType.GetTypes((x) => x.IsMicroResources, true);
var cats = MaterialCommodityMicroResourceType.GetCategories((x) => x.IsMicroResources, true);
foreach (var t in cats)
{
string[] members = MaterialCommodityMicroResourceType.GetFDNameMembersOfCategory(t.Item1, true);
cfs.AddGroupOption(String.Join(";", members) + ";", t.Item2);
}
}
else
{
dataGridViewMC.Columns.Remove(dataGridViewMC.Columns[1]); //remove cat
DataGridViewColumn c = dataGridViewMC.Columns[1]; // reassign column 1 to end and call recipes
c.HeaderText = "Recipes".T(EDTx.UserControlMaterialCommodities_Recipes);
c.DisplayIndex = 4; // need to change its display pos
dataGridViewMC.Columns.Remove(c); // and to place it at the end otherwise it does not fill in the right order
dataGridViewMC.Columns.Add(c);
labelItems1.Text = "Total".T(EDTx.UserControlMaterialCommodities_Total);
textBoxItems2.Visible = labelItems2.Visible = false;
checkBoxShowZeros.Location = new Point(textBoxItems1.Right + 8, checkBoxShowZeros.Top);
items = MaterialCommodityMicroResourceType.GetCommodities(true);
types = MaterialCommodityMicroResourceType.GetTypes((x) => x.IsCommodity, true);
MaterialCommodityMicroResourceType[] rare = items.Where(x => x.IsRareCommodity).ToArray();
cfs.AddGroupOption(String.Join(";", rare.Select(x => x.FDName).ToArray()) + ";", "Rare".T(EDTx.UserControlMaterialCommodities_Rare));
}
foreach (var t in types)
{
string[] members = MaterialCommodityMicroResourceType.GetFDNameMembersOfType(t.Item1, true);
cfs.AddGroupOption(String.Join(";", members) + ";", t.Item2);
}
foreach (var x in items)
{
cfs.AddStandardOption(x.FDName, x.Name);
}
checkBoxShowZeros.Checked = !GetSetting(dbClearZero, true); // used to be clear zeros, now its show zeros, invert
checkBoxShowZeros.CheckedChanged += CheckBoxClear_CheckedChanged;
cfs.SaveSettings += FilterChanged;
}
public DataGridViewColumn GetPreviousColumn(DataGridViewColumn dataGridViewColumnStart, DataGridViewElementStates includeFilter, DataGridViewElementStates excludeFilter) {}
void CreateGridPatternsGrid(DataGridView grid, WindowsFormsHost host)
{
grid.AllowUserToOrderColumns = true;
grid.AllowUserToResizeRows = true;
grid.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
grid.AllowUserToDeleteRows = false;
grid.AllowUserToAddRows = false;
grid.RowHeadersVisible = false;
grid.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
grid.MultiSelect = false;
DataGridViewCellStyle style = new DataGridViewCellStyle();
style.Alignment = DataGridViewContentAlignment.TopLeft;
style.WrapMode = DataGridViewTriState.True;
grid.DefaultCellStyle = style;
DataGridViewTextBoxCell cell0 = new DataGridViewTextBoxCell();
cell0.Style = style;
DataGridViewComboBoxCell cellComboBox = new DataGridViewComboBoxCell();
cellComboBox.Style = style;
DataGridViewColumn column0 = new DataGridViewColumn();
column0.CellTemplate = cell0;
column0.HeaderText = @"№";
column0.ReadOnly = true;
column0.Width = 40;
grid.Columns.Add(column0);
DataGridViewColumn column1 = new DataGridViewColumn();
column1.CellTemplate = cell0;
column1.HeaderText = @"Кол-во входов";
column1.ReadOnly = true;
column1.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
grid.Columns.Add(column1);
DataGridViewColumn column2 = new DataGridViewColumn();
column2.CellTemplate = cell0;
column2.HeaderText = @"Прибыльность";
column2.ReadOnly = true;
column2.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
grid.Columns.Add(column2);
DataGridViewColumn column4 = new DataGridViewColumn();
column4.CellTemplate = cell0;
column4.HeaderText = @"МО";
column4.ReadOnly = true;
column4.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
grid.Columns.Add(column4);
grid.Rows.Add(null, null);
host.Child = grid;
grid.Click += grid_Click;
}
public int IndexOf(DataGridViewColumn dataGridViewColumn) {}
