コード例 #1
0
    private void PasteCell(DataGridView dataGridView, string clipboardStr)
    {
        m_CsvForm.BeforeChangeCellValue();
        TextBox             textBox = dataGridView.EditingControl as TextBox;
        CellValueChangeItem change  = new CellValueChangeItem();

        try
        {
            change.OldValue = textBox.Text;
            change.Row      = dataGridView.CurrentCell.RowIndex;
            change.Column   = dataGridView.CurrentCell.ColumnIndex;

            int    selectionStart = textBox.SelectionStart;
            string newValue       = textBox.Text;
            newValue = newValue.Remove(selectionStart, textBox.SelectionLength);
            newValue = newValue.Insert(selectionStart, clipboardStr);
            // 在这之后不会抛出异常
            textBox.Text           = newValue;
            textBox.SelectionStart = selectionStart + clipboardStr.Length;

            change.NewValue = newValue;
            DidCellValueChange(change);
        }
        catch (Exception ex)
        {
            textBox.Text = change.OldValue;
            DebugUtility.ShowExceptionMessageBox("粘贴到Cell失败", ex);
        }
        finally
        {
            m_CsvForm.AfterChangeCellValue();
        }
    }
コード例 #2
0
    private void OnReplaceAllButton_Click(object sender, EventArgs e)
    {
        if (!MainForm.Instance.SelCsvFormInitialized())
        {
            MessageBox.Show("当前没有打开Csv文件", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            return;
        }

        DataGridView dataGridView = MainForm.Instance.GetCsvForm().GetDataGridView();

        MainForm.Instance.GetCsvForm().BeforeChangeCellValue();
        List <CellValueChangeItem> ChangeList = new List <CellValueChangeItem>();
        DataGridViewCell           cell       = Searching(dataGridView, 0, 0);

        while (cell != null)
        {
            CellValueChangeItem changeItem = new CellValueChangeItem();
            changeItem.OldValue = (string)cell.Value;
            changeItem.NewValue = Replacing(changeItem.OldValue);
            changeItem.Row      = cell.RowIndex;
            changeItem.Column   = cell.ColumnIndex;
            ChangeList.Add(changeItem);

            cell.Value = changeItem.NewValue;
            cell       = Searching(dataGridView, cell.RowIndex, cell.ColumnIndex);
        }
        MainForm.Instance.GetCsvForm().EditManager.DidCellsValueChange(ChangeList);
        MainForm.Instance.GetCsvForm().AfterChangeCellValue();
    }
コード例 #3
0
 public void Undo(DataGridView dataGridView, DataTable dataTable)
 {
     for (int changeIdx = 0; changeIdx < ChangeList.Count; changeIdx++)
     {
         CellValueChangeItem changeItem = ChangeList[changeIdx];
         dataGridView.Rows[changeItem.Row].Cells[changeItem.Column].Value = changeItem.OldValue;
     }
 }
コード例 #4
0
    public void DidCellValueChange(CellValueChangeItem change)
    {
        DoCellsValueChangeEvent doCellsValueChangeEvent = new DoCellsValueChangeEvent();

        doCellsValueChangeEvent.ChangeList = new List <CellValueChangeItem>();
        doCellsValueChangeEvent.ChangeList.Add(change);

        Did(doCellsValueChangeEvent);
    }
コード例 #5
0
    public void DidCellValueChange(int column, int row, string oldValue, string newValue)
    {
        CellValueChangeItem change = new CellValueChangeItem();

        change.Column   = column;
        change.Row      = row;
        change.OldValue = oldValue;
        change.NewValue = newValue;
        DidCellValueChange(change);
    }
コード例 #6
0
    private void PasetCells(DataGridView dataGridView, string clipboardStr)
    {
        // 引用下面两个链接
        // https://stackoverflow.com/questions/22833327/pasting-excel-data-into-a-blank-datagridview-index-out-of-range-exception
        // https://stackoverflow.com/questions/1679778/is-it-possible-to-paste-excel-csv-data-from-clipboard-to-datagridview-in-c
        List <CellValueChangeItem> changeList = new List <CellValueChangeItem>();

        try
        {
            m_CsvForm.BeforeChangeCellValue();
            string[] lines = Regex.Split(clipboardStr.TrimEnd("\r\n".ToCharArray()), "\r\n");
            // 当前行
            int currentRow = dataGridView.CurrentCell.RowIndex;
            // 当前列
            int currentCol = dataGridView.CurrentCell.ColumnIndex;
            DataGridViewCell currentCell;
            for (int lineIdx = 0; lineIdx < lines.Length; lineIdx++)
            {
                string line = lines[lineIdx];
                // 行超过表格限制,默认不添加新行
                if (currentRow >= dataGridView.RowCount)
                {
                    throw (new ArgumentOutOfRangeException(null,
                                                           string.Format("粘贴数据({0})行的第({1})行到表中第({2})行失败\n表一共有({3})行",
                                                                         lines.Length,
                                                                         lineIdx + 1,
                                                                         currentRow + 1,
                                                                         dataGridView.RowCount)));
                }

                string[] cells = line.Split('\t');
                for (int cellIdx = 0; cellIdx < cells.Length; ++cellIdx)
                {
                    // 列超过表格限制,默认不添加新列
                    if (currentCol + cellIdx >= dataGridView.ColumnCount)
                    {
                        throw (new ArgumentOutOfRangeException(null,
                                                               string.Format("粘贴数据({0})列的第({1})列到表中第({2})列失败\n表一共有({3})列",
                                                                             cells.Length,
                                                                             cellIdx + 1,
                                                                             ConvertUtility.NumberToLetter(currentCol + cellIdx + 1),
                                                                             ConvertUtility.NumberToLetter(dataGridView.ColumnCount))));
                    }
                    currentCell = dataGridView.Rows[currentRow].Cells[currentCol + cellIdx];
                    string cell = cells[cellIdx];
                    if (currentCell.Value == null || currentCell.Value.ToString() != cell)
                    {
                        // 如果cell是多行数据,去除两侧的引号
                        if (cell.Contains("\n") && cell[0] == '"' && cell[cell.Length - 1] == '"')
                        {
                            cell = cell.Substring(1, cell.Length - 2);
                        }

                        CellValueChangeItem change = new CellValueChangeItem();
                        change.Row      = currentCell.RowIndex;
                        change.Column   = currentCell.ColumnIndex;
                        change.OldValue = (string)currentCell.Value;
                        change.NewValue = cell;

                        currentCell.Value = cell;
                        changeList.Add(change);
                    }
                }
                currentRow++;
            }
        }
        catch (ArgumentOutOfRangeException ex)
        {
            MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK);
            // 粘贴失败,还原到粘贴前
#if !DEBUG
            if (changeList.Count > 0)
            {
                DoCellsValueChangeEvent doCellsValueChangeEvent = new DoCellsValueChangeEvent
                {
                    ChangeList = changeList
                };
                doCellsValueChangeEvent.Undo(dataGridView, null);
            }
            changeList = null;
#endif
        }
        catch (Exception ex)
        {
            DebugUtility.ShowExceptionMessageBox("粘贴到DataGridView失败", ex);
        }
        finally
        {
            DidCellsValueChange(changeList);
            m_CsvForm.AfterChangeCellValue();
        }
    }
コード例 #7
0
    public void Cut()
    {
        if (!CanCut())
        {
            return;
        }
        Copy();


        if (m_CsvForm.GetDataGridView().IsCurrentCellInEditMode)
        {
            m_CsvForm.BeforeChangeCellValue();
            TextBox             textBox = m_CsvForm.GetDataGridView().EditingControl as TextBox;
            CellValueChangeItem change  = new CellValueChangeItem();
            try
            {
                int selectionStart = textBox.SelectionStart;
                change.OldValue = textBox.Text;
                change.Row      = m_CsvForm.GetDataGridView().CurrentCell.RowIndex;
                change.Column   = m_CsvForm.GetDataGridView().CurrentCell.ColumnIndex;
                change.NewValue = change.OldValue.Remove(textBox.SelectionStart, textBox.SelectionLength);

                textBox.Text           = change.NewValue;
                textBox.SelectionStart = selectionStart;
                DidCellValueChange(change);
            }
            catch (Exception ex)
            {
                textBox.Text = change.OldValue;
                DebugUtility.ShowExceptionMessageBox("剪切DataGridViewCell数据到剪切板失败", ex);
            }
            finally
            {
                m_CsvForm.AfterChangeCellValue();
            }
        }
        else if (MainForm.Instance.GetCellEditTextBox().Focused)
        {
            TextBox textBox        = MainForm.Instance.GetCellEditTextBox();
            int     selectionStart = textBox.SelectionStart;
            textBox.Text           = textBox.Text.Remove(textBox.SelectionStart, textBox.SelectionLength);
            textBox.SelectionStart = selectionStart;
        }
        else if (m_CsvForm.GetDataGridView().SelectedCells.Count > 0)
        {
            m_CsvForm.BeforeChangeCellValue();

            // 转换为Array
            IList selectedCellList           = m_CsvForm.GetDataGridView().SelectedCells;
            DataGridViewCell[] selectedCells = new DataGridViewCell[selectedCellList.Count];
            selectedCellList.CopyTo(selectedCells, 0);
            CellValueChangeItem[] changes = new CellValueChangeItem[selectedCells.Length];

            for (int cellIdx = 0; cellIdx < selectedCells.Length; cellIdx++)
            {
                DataGridViewCell cell = selectedCells[cellIdx];

                CellValueChangeItem change = new CellValueChangeItem();
                change.Row       = cell.RowIndex;
                change.Column    = cell.ColumnIndex;
                change.OldValue  = (string)cell.Value;
                change.NewValue  = "";
                changes[cellIdx] = change;

                cell.Value = "";
            }
            DidCellsValueChange(changes.ToList());
            m_CsvForm.AfterChangeCellValue();
        }
    }
コード例 #8
0
ファイル: CSVEditManager.cs プロジェクト: huangwwmm/CSVEditor
    /// <summary>
    /// UNDONE 这个方法是复制了PasetCells后修改的,应该想办法把这两个方法封装一下
    /// </summary>
    public void InsertFromClipboard(DataGridView dataGridView, DataTable dataTable, int rowIndex)
    {
        if (!CanInsertFromClipboard())
        {
            return;
        }

        if (!GetclipboardText(out string clipboardText))
        {
            return;
        }

        List <IUndoRedo> didManyThings = new List <IUndoRedo>();

        try
        {
            m_CSVForm.BeforeChangeCellValue();
            string[] lines = Regex.Split(clipboardText.TrimEnd("\r\n".ToCharArray()), "\r\n");
            // 当前行
            int currentRow = rowIndex;
            // 当前列
            int currentCol = 0;
            DataGridViewCell currentCell;
            for (int lineIdx = 0; lineIdx < lines.Length; lineIdx++)
            {
                // 插入行
                DataGridViewUtility.InsertNewRow(dataGridView, dataTable, currentRow);
                DoAddRowEvent doAddRowEvent = new DoAddRowEvent
                {
                    Row = currentRow
                };
                didManyThings.Add(doAddRowEvent);

                string line = lines[lineIdx];
                // 行超过表格限制,默认不添加新行
                if (currentRow >= dataGridView.RowCount)
                {
                    throw (new ArgumentOutOfRangeException(null,
                                                           string.Format("插入数据({0})行的第({1})行到表中第({2})行失败\n表一共有({3})行",
                                                                         lines.Length,
                                                                         lineIdx + 1,
                                                                         currentRow + 1,
                                                                         dataGridView.RowCount)));
                }

                string[] cells = line.Split('\t');
                List <CellValueChangeItem> cellChangeList = new List <CellValueChangeItem>();
                for (int cellIdx = 0; cellIdx < cells.Length; ++cellIdx)
                {
                    // 列超过表格限制,默认不添加新列
                    if (currentCol + cellIdx >= dataGridView.ColumnCount)
                    {
                        throw (new ArgumentOutOfRangeException(null,
                                                               string.Format("插入数据({0})列的第({1})列到表中第({2})列失败\n表一共有({3})列",
                                                                             cells.Length,
                                                                             cellIdx + 1,
                                                                             ConvertUtility.NumberToLetter(currentCol + cellIdx + 1),
                                                                             ConvertUtility.NumberToLetter(dataGridView.ColumnCount))));
                    }
                    currentCell = dataGridView.Rows[currentRow].Cells[currentCol + cellIdx];
                    string cell = cells[cellIdx];
                    if (currentCell.Value == null || currentCell.Value.ToString() != cell)
                    {
                        // 如果cell是多行数据,去除两侧的引号
                        if (cell.Contains("\n") && cell[0] == '"' && cell[cell.Length - 1] == '"')
                        {
                            cell = cell.Substring(1, cell.Length - 2);
                        }

                        CellValueChangeItem change = new CellValueChangeItem();
                        change.Row      = currentCell.RowIndex;
                        change.Column   = currentCell.ColumnIndex;
                        change.OldValue = (string)currentCell.Value;
                        change.NewValue = cell;

                        currentCell.Value = cell;
                        cellChangeList.Add(change);
                    }
                }
                DoCellsValueChangeEvent cellChangListEvent = new DoCellsValueChangeEvent
                {
                    ChangeList = cellChangeList
                };
                didManyThings.Add(cellChangListEvent);
                currentRow++;
            }
        }
        catch (ArgumentOutOfRangeException ex)
        {
            MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK);
            // 粘贴失败,还原到粘贴前
#if !DEBUG
            if (didManyThings.Count > 0)
            {
                DoManyThingsEvent doManyThings = new DoManyThingsEvent
                {
                    ThingsList = didManyThings
                };

                doManyThings.Undo(dataGridView, null);
            }
            didManyThings = null;
#endif
        }
        catch (Exception ex)
        {
            DebugUtility.ShowExceptionMessageBox("粘贴到DataGridView失败", ex);
        }
        finally
        {
            DidManyThings(didManyThings);
            m_CSVForm.UpdateGridHeader();
            m_CSVForm.AfterChangeCellValue();
        }
    }