C#、devExpress 的 给bandedGrid加菜单功能 ：复制、粘贴的例子

功能函数：

CopyFromGrid

PasteToGrid

PasteNewRowsToGrid

 

private void mnuPaste_Click(object sender, EventArgs e)
        {
            this.Cursor = Cursors.WaitCursor;
            //if(bandedGridView1.GetSelectedRows)
            int[] iSelRowIndexs=bandedGridView1.GetSelectedRows();
            if(iSelRowIndexs==null || iSelRowIndexs.Length==0)
            {
                Common.DisplayMsg(this.Text,"先请选择需要范围");
            }else
            {
                string sFieldName = bandedGridView1.FocusedColumn.FieldName;
                if(sFieldName !=null)
                {
                    if (sFieldName == "Discount" || sFieldName == "ProjectRating")
                        PasteToGrid(bandedGridView1, iSelRowIndexs[0], iSelRowIndexs.Length, sFieldName);
                }
            }
            this.Cursor = Cursors.Default;
        }

        private void CopyFromGrid(DevExpress.XtraGrid.Views.BandedGrid.BandedGridView bandedGrid)
        {
            int[] iSelRowIndexs = bandedGridView1.GetSelectedRows();
            if(iSelRowIndexs ==null || iSelRowIndexs.Length==0)
            {
                Common.DisplayMsg(this.Text,"请先选择需要复制的内容");
                return;
            }
 
            DevExpress.XtraGrid.Columns.GridColumn[] gcs = null;

            Clipboard.Clear();
            StringBuilder sb = new StringBuilder();
            int iRow = 0;
            for (int iTemp = 0; iTemp < iSelRowIndexs.Length; iTemp++)
            {
                iRow = iSelRowIndexs[iTemp];
                gcs = bandedGridView1.GetSelectedCells(iRow);
                foreach(DevExpress.XtraGrid.Columns.GridColumn gc in gcs)
                {
                    sb.Append(bandedGridView1.GetRowCellValue(iRow, gc));
 
                    if (gc != gcs[gcs.Length - 1]) // 加上 tab符,除了最后一列外
                        sb.Append(Convert.ToChar(Keys.Tab));
                }

                if (iRow != iSelRowIndexs[iSelRowIndexs.Length - 1]) // 加上换行符。除了最后一行外
                    sb.Append(Convert.ToChar(Keys.Return));
            }

            Clipboard.SetText(sb.ToString()); 
        }

        // 这里暂时只有 decimal型数据,并且每次粘贴只有一列的
        // 要么是折扣列，要么是评估收视率列
        private void PasteToGrid(DevExpress.XtraGrid.Views.BandedGrid.BandedGridView bandedGrid,int iStartRowIndex,int iSelRowCount,string sFieldName)
        {
            string sClipBoard = Clipboard.GetText().TrimEnd('\n').TrimEnd('\r'); // 去掉最后一个\r\n;
            string[] aRow = sClipBoard.Split(Convert.ToChar(Keys.Return)); // 取得行
            string[] aCell = new string[1];

            if (aRow == null || aRow.Length == 0)
            {
                Common.DisplayMsg(this.Text,"粘贴板没有数据");
                return;
            }

            if (iSelRowCount != aRow.Length)
            {
                Common.DisplayMsg(this.Text, "选择的数据行数与粘贴板的行数不匹配\r\n\r\n选择行数: " + iSelRowCount + "\r\n粘贴板行数: " + aRow.Length);
                return;
            }

            decimal dTemp=0.0M;
            bool bResult = false;
            for (int i = 0; i < aRow.Length; i++)
            {
                aCell = aRow[i].Split(Convert.ToChar(Keys.Tab));// 取得列
                if (!Common.IsNullOrEmptyObject(aCell[0]))
                {
                    bResult = Decimal.TryParse(aCell[0], out dTemp);
                    if (dTemp < 0) dTemp = 0;
                    if (sFieldName == "Discount")
                    {
                        if (dTemp == 0) dTemp = 100;
                        if (dTemp > 100) dTemp = 100;
                        if (dTemp > 0 && dTemp <= 1) dTemp = dTemp * 100;
                    }
                    bandedGrid.SetRowCellValue(iStartRowIndex + i, sFieldName, dTemp);
                }
                else
                {
                    bandedGrid.SetRowCellValue(iStartRowIndex + i, sFieldName, 0);
                }
            }
        }
 
        private void PasteNewRowsToGrid(DevExpress.XtraGrid.Views.BandedGrid.BandedGridView bandedGrid, string[] sFieldNames)
        {
            string sClipBoard = Clipboard.GetText().TrimEnd('\n').TrimEnd('\r'); // 去掉最后一个\r\n;
            string[] aRow = sClipBoard.Split(Convert.ToChar(Keys.Return)); // 取得行
            string[] aCell = new string[1];

            if (aRow == null || aRow.Length == 0)
            {
                Common.DisplayMsg(this.Text,"粘贴板没有数据");
                return;
            }

            if (sFieldNames.Length != aRow[0].Split(Convert.ToChar(Keys.Tab)).Length)
            {
                Common.DisplayMsg(this.Text, "需要的列数与粘贴板的列数不匹配\r\n\r\n需要的列数: " + sFieldNames.Length + "\r\n粘贴板行数: " + aRow.Length);
                return;
            }
 
            decimal dTemp=0.0M;
            int iTemp = 0;
            bool bResult = false;
            int iRowIndex = 0;

            int iMaxDaypartID = Common.GetMaxTableID(sqlHelper.ConnStringCPRP, "DaypartID", "Daypart");

            for (int i = 0; i < aRow.Length; i++)
            {
                bandedGridView1.AddNewRow();
                bandedGridView1.UpdateCurrentRow();
                iRowIndex = bandedGridView1.RowCount - 1;

                bandedGridView1.SetRowCellValue(iRowIndex, "DaypartID", ++ iMaxDaypartID);

                if (! arrAddedDaypartID.Contains(iMaxDaypartID))
                {
                    arrAddedDaypartID.Add(iMaxDaypartID);
                }
 
                aCell = aRow[i].Split(Convert.ToChar(Keys.Tab));// 取得列
                for (int j = 0; j < aCell.Length; j++)
                {
                    bResult = int.TryParse(aCell[0], out iTemp);
                    if (bResult)
                    {
                        bandedGridView1.SetRowCellValue(iRowIndex, bandedGridView1.Columns[sFieldNames[j]], iTemp);
                    }
                    else
                    {
                        bResult = Decimal.TryParse(aCell[0], out dTemp);
                        if (bResult)
                        {
                            bandedGridView1.SetRowCellValue(iRowIndex, bandedGridView1.Columns[sFieldNames[j]], dTemp);
                        }
                        else
                        {
                            bandedGridView1.SetRowCellValue(iRowIndex, bandedGridView1.Columns[sFieldNames[j]], aCell[j].Trim('\n'));
                        }
                    }
                }
            }
        }

        // 
        private void mnuPaste2_Click(object sender, EventArgs e)
        {
             this.Cursor = Cursors.WaitCursor;

            string[] sFieldNames = new string[] { "MediaName","StartTime","EndTime","Dayofweek","ProgramName","Position","Cost1","Cost2","Cost3" };
            PasteNewRowsToGrid(bandedGridView1,sFieldNames);

            this.Cursor = Cursors.Default;
        }