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; }