public frmPostsAC(SqlConnection con, string fun, DataGridView d, DataGridViewSelectedCellCollection _selcells) { InitializeComponent(); myConnection = con; selcells = _selcells; con2 = con; dgvP = d; switch (fun) { case "add": this.Text = "Добавить должность"; break; case "change": this.Text = "Изменить должность"; break; } }
public frmEmployeesAC(SqlConnection con, string fun, DataGridView d, DataGridViewSelectedCellCollection _selcells) { InitializeComponent(); myConnection = con; selcells = _selcells; con2 = con; dgvP = d; fillPostsBox(); switch (fun) { case "add": this.Text = "Добавить сотрудника"; break; case "change": this.Text = "Изменить данные о сотруднике"; break; } }
public frmPets(SqlConnection conn, string fun, DataGridView dgv, DataGridViewSelectedCellCollection _selcells) { InitializeComponent(); myConnection = conn; selcells = _selcells; dgvP = dgv; fillCombo(cbSpecies, "GET_SPECIES_LIST");//Species switch (fun) { case "add": this.Text = "Добавить животное"; btnAddMore.Visible = true; break; case "change": this.Text = "Изменить данные о животном"; cbSpecies.Text = selcells[6].Value.ToString(); pictureBox1.Image = ByteArrayToImage((byte[])selcells[8].Value); break; } }
public frmProvidersACD(SqlConnection con, string fun, DataGridView d, DataGridViewSelectedCellCollection _selcells) { InitializeComponent(); myConnection = con; selcells = _selcells; con2 = con; dgvP = d; fillCityBox(); switch (fun) { case "add": this.Text = "Добавить поставщика"; butAddNext.Visible = true; break; case "change": this.Text = "Изменить данные"; butAddNext.Visible = false; break; } }
public history(DataGridViewSelectedCellCollection dgvsc) { //Variable declaration & initialization\\ InitializeComponent(); metroLabel1.Text = "History - " + dgvsc[0].Value; this.dgvsc = dgvsc; query = "SELECT TOP 1 * FROM [CSS].[dbo].[historyIndex] order by historyID DESC"; sqlConnection(); sqlCon.Open(); dt = new DataTable(); command = new SqlCommand(); command.CommandText = query; command.CommandType = CommandType.Text; command.Connection = sqlCon; sa = new SqlDataAdapter(command); sa.Fill(dt); query2 = "SELECT [clusterIndex] ,[recencyCentroid],[frequencyCentroid],[monetaryCentroid],[recencyDOM],[frequencyDOM],[monetaryDOM],[rfmScore],[clusterSegment] from [CSS].[dbo].historyDetail where historyID ='" + dgvsc[0].Value.ToString() + "'"; command = new SqlCommand(query2, sqlCon); command.CommandText = query2; command.CommandType = CommandType.Text; command.Connection = sqlCon; sa = new SqlDataAdapter(command); ds = new DataSet(); sa.Fill(ds, "history"); //History detail grid filled with records from database\\ historyDetailGrid.DataSource = ds.Tables[0].DefaultView; sqlCon.Close(); //History detail grid properties setting\\ historyDetailGrid.Columns[0].HeaderText = "Cluster"; historyDetailGrid.Columns[1].HeaderText = "Recency Centroid"; historyDetailGrid.Columns[2].HeaderText = "Frequency Centroid"; historyDetailGrid.Columns[3].HeaderText = "Monetary Centroid"; historyDetailGrid.Columns[4].HeaderText = "Recency DOM"; historyDetailGrid.Columns[5].HeaderText = "Frequency DOM"; historyDetailGrid.Columns[6].HeaderText = "Monetary DOM"; historyDetailGrid.Columns[7].HeaderText = "RFM Score"; historyDetailGrid.Columns[8].HeaderText = "Cluster Segment"; historyDetailGrid.Columns[1].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; historyDetailGrid.Columns[2].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; historyDetailGrid.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; historyDetailGrid.Columns[4].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; historyDetailGrid.Columns[5].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; historyDetailGrid.Columns[6].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; historyDetailGrid.Columns[7].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; historyDetailGrid.Columns[1].DefaultCellStyle.Format = "0.0#####"; historyDetailGrid.Columns[2].DefaultCellStyle.Format = "0.0#####"; historyDetailGrid.Columns[3].DefaultCellStyle.Format = "0.0#####"; historyDetailGrid.Columns[4].DefaultCellStyle.Format = "0.0#####"; historyDetailGrid.Columns[5].DefaultCellStyle.Format = "0.0#####"; historyDetailGrid.Columns[6].DefaultCellStyle.Format = "0.0#####"; historyDetailGrid.Columns[7].DefaultCellStyle.Format = "0.0#####"; historyDetailGrid.Columns[0].Width = 35; historyDetailGrid.Columns[1].Width = 60; historyDetailGrid.Columns[2].Width = 60; historyDetailGrid.Columns[3].Width = 60; historyDetailGrid.Columns[4].Width = 60; historyDetailGrid.Columns[5].Width = 60; historyDetailGrid.Columns[6].Width = 60; historyDetailGrid.Columns[7].Width = 70; historyDetailGrid.Columns[8].MinimumWidth = 100; historyDetailGrid.Columns[8].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; string criteriaFilePath = "../screenshot/" + dgvsc[0].Value.ToString() + "_Criteria.jpg"; criteriaPictureBox.ImageLocation = criteriaFilePath; string chartFilePath = "../screenshot/" + dgvsc[0].Value.ToString() + "_Chart.jpg"; chartPictureBox.ImageLocation = chartFilePath; }
private DataGridViewCell GetLeftTopMostCell(DataGridViewSelectedCellCollection cells) { List<DataGridViewCell> leftMostCells = this.GetLeftMostCells(cells); return this.GetTopMostCell(leftMostCells); }
private List<DataGridViewCell> GetLeftMostCells(DataGridViewSelectedCellCollection cells) { List<DataGridViewCell> leftMostCells = new List<DataGridViewCell>(); int columnIndex = cells[0].ColumnIndex; leftMostCells.Add(cells[0]); foreach (DataGridViewCell cell in cells) { AddLeftCell(leftMostCells, columnIndex, cell); } return leftMostCells; }
private void FillSelectedCells(DataGridViewCell leftTopMostCell, DataGridViewSelectedCellCollection selectedCells) { string str = (leftTopMostCell.Value == null) ? string.Empty : leftTopMostCell.Value.ToString(); int columnIndex = leftTopMostCell.ColumnIndex; this.FillColumn(leftTopMostCell, selectedCells); while (++columnIndex < this.m_GridCellService.ColumnCount) { DataGridViewCell topestCell = this.m_GridCellService.Rows[leftTopMostCell.RowIndex].Cells[columnIndex]; this.FillColumn(topestCell, selectedCells); } }
private void FillColumn(DataGridViewCell topestCell, DataGridViewSelectedCellCollection selectedCells) { string str = (topestCell.Value == null) ? string.Empty : topestCell.Value.ToString(); int rowIndex = topestCell.RowIndex; while (++rowIndex < this.m_GridCellService.RowCount) { DataGridViewCell dataGridViewCell = this.m_GridCellService.Rows[rowIndex].Cells[topestCell.ColumnIndex]; if (!selectedCells.Contains(dataGridViewCell)) { break; } dataGridViewCell.Value = str; } }
protected override void OnMouseDown(MouseEventArgs e) { DataGridView.HitTestInfo info = base.HitTest(e.X, e.Y); this._selectCells = base.SelectedCells; if ((!this._isControlKey && (info.RowIndex >= 0)) && (info.ColumnIndex >= 0)) { this._firstSelectedCell = base[info.ColumnIndex, info.RowIndex]; } base.OnMouseDown(e); }
private int GetSmallestColumnIndex(DataGridViewSelectedCellCollection cells) { int minColumnIndex = ActiveWS.Spreadsheet.ColumnCount - 1; foreach (DataGridViewCell cell in cells) { if (cell.ColumnIndex < minColumnIndex) minColumnIndex = cell.ColumnIndex; } return minColumnIndex; }
private void SetSelectionWish(Teacher teacher, int wishValue, DataGridViewSelectedCellCollection collection, CancellationToken cToken) { for (int i = 0; i < collection.Count; i++) { var cell = collection[i]; var dow = cell.ColumnIndex - 1; if (cell.ColumnIndex <= 1) { continue; } var calendars = _repo.Calendars.GetDowCalendars(dow); cToken.ThrowIfCancellationRequested(); var ring = _repo.Rings.GetRing(((List<RingWeekView>)wishesView.DataSource)[cell.RowIndex].RingId); cToken.ThrowIfCancellationRequested(); foreach (var calendar in calendars) { cToken.ThrowIfCancellationRequested(); var teacherWish = new TeacherWish(teacher, calendar, ring, wishValue); _repo.TeacherWishes.AddOrUpdateTeacherWish(teacherWish); } } }
private void FS_MultiFiles(DataGridViewSelectedCellCollection collections) { string dir; using (FolderBrowserDialog fbd = new FolderBrowserDialog()) { fbd.Description = "Select folder where you want to extract selected files"; if (fbd.ShowDialog() == DialogResult.OK) dir = fbd.SelectedPath; else return; } for (int i = 0; i != collections.Count; i++) saveFSfile(dir, //collections[i].Cells[2].Value.ToString().Substring(16), collections[i].Value.ToString().Substring(16), ArchiveWorker.GetBinaryFile( $"{Path.GetDirectoryName(aWorker._path)}\\{Path.GetFileNameWithoutExtension(aWorker._path)}", collections[i].Value.ToString())); }