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