网上SourceGrid相关的资料很少,使用过程中做了下记录,以便日后查用

1:初始化

this.grid = new SourceGrid.Grid();
this.grid.Size = new System.Drawing.Size(552, 224);
this.grid.Location = new System.Drawing.Point(0, 0);
this.tabPage1.Controls.Add(this.grid);

2:设置行列

方法1: grid.Redim(20,12);
方法2: grid.ColumnsCount = 3;
grid.RowsCount = 3;
方法3: 在属性中设置 ColumnsCount和RowsCount的值

grid.Rows.Insert(3);

3:固定行列

grid.FixedRows = 2;
grid.FixedColumns = 3;

4:标题列赋值及标题样式(标题是否自带排序)

grid[0, 0] = new SourceGrid.Cells.ColumnHeader("序号");
grid[0, 1] = new SourceGrid.Cells.ColumnHeader("区块名称");

对标题样式进行修改
grid1[0, 0] = new MyHeader("序号");

private class MyHeader : SourceGrid.Cells.ColumnHeader
{
public MyHeader(object value) : base(value)
{
//1 Header Row
SourceGrid.Cells.Views.ColumnHeader view = new SourceGrid.Cells.Views.ColumnHeader();
view.Font = new Font(FontFamily.GenericSansSerif, 10, FontStyle.Bold);
view.TextAlignment = DevAge.Drawing.ContentAlignment.MiddleCenter;
View = view;
　　　　　　//自带排序true;不实现排序false
AutomaticSortEnabled = false;
}
}

5:内容列赋值

字符串类型: grid[1, 3] = new SourceGrid.Cells.Cell("Hello " + r.ToString(), typeof(string));
复选框类型: grid[1, 5] = new SourceGrid.Cells.CheckBox(null, true);
按钮类型: grid[62, 2] = new SourceGrid.Cells.Button("删除");
时间类型: grid[1, 4] = new SourceGrid.Cells.Cell(DateTime.Today, typeof(DateTime));
grid[1, 2] = new SourceGrid.Cells.Cell(12121);

获取:var aa=grid[1, 4].Value.ToString();
重新赋值: grid[r + i, 4].Value = "2";

注意:单元格格式用上面形式,赋值用Value可以避免多次赋值无效的问题

6:单元格宽高设置

单元格根据内容自动变化:
(不包含标题列,只对内容有效,我感觉不好用,还是根据自己需求设置宽度)
grid.AutoSizeCells();

grid.Columns[0].Width = 100;(要在AutoSizeCells()方法后使用,否则无效)
grid.Rows[0].Height = 30;

7:删除某行某列

grid.Rows.Remove(3);//删除下标为3的行
grid.Columns.Remove(3);

8:设置单元格文本/图片居中及背景色(斑马线即隔行换色)

///

/// 设置表头字体及样式 ///

public class MyHeader : SourceGrid.Cells.ColumnHeader
{
　　public MyHeader(object value) : base(value)
　　{
　　//1 Header Row
　　SourceGrid.Cells.Views.ColumnHeader view = new SourceGrid.Cells.Views.ColumnHeader();
　　view.Font = new Font(FontFamily.GenericSansSerif, 9, FontStyle.Bold);
　　view.TextAlignment = DevAge.Drawing.ContentAlignment.MiddleCenter;
　　View = view;

　　AutomaticSortEnabled = false;
　　}
}

//使用grid[0, 0] = new MyHeader("序号");

SourceGrid.Cells.Views.Cell transparentView = new SourceGrid.Cells.Views.Cell();
transparentView.BackColor = Color.White;
　//字体
//transparentView.Font = new Font(FontFamily.GenericSansSerif, 9, FontStyle.Bold);
transparentView.TextAlignment = DevAge.Drawing.ContentAlignment.MiddleCenter;
transparentView.ImageAlignment = DevAge.Drawing.ContentAlignment.MiddleCenter;
SourceGrid.Cells.Views.Cell semiTransparentView = new SourceGrid.Cells.Views.Cell();
semiTransparentView.BackColor = Color.LightCyan;
semiTransparentView.TextAlignment = DevAge.Drawing.ContentAlignment.MiddleCenter;
semiTransparentView.ImageAlignment = DevAge.Drawing.ContentAlignment.MiddleCenter;
CheckBoxBackColorAlternate viewCheckBox = new CheckBoxBackColorAlternate(Color.LightCyan, Color.White);

隔行显示

for (int r = 1; r < grid.RowsCount; r++)
  {
   for (int j = 0; j < grid.ColumnsCount; j++)
   {
    if ((r - 1) % 2 == 0) grid[r, j].View = transparentView;
    else grid[r, j].View = semiTransparentView;
   }
  }

9:按钮button的相关设置

SourceGrid.Cells.Views.Cell buttonView = new SourceGrid.Cells.Views.Button();
buttonView.TextAlignment = DevAge.Drawing.ContentAlignment.MiddleCenter;
buttonView.Padding = new DevAge.Drawing.Padding(2, 30, 2, 5);
使用:

grid[1, 20] = new SourceGrid.Cells.Button("删除");

grid[1,20].View=buttonView;

10:复选框checkBox的相关设置

    //使用:  
    grid\[r, 16\] = new SourceGrid.Cells.CheckBox(null, true);  

　　　　　CheckBoxBackColorAlternate viewCheckBox = new CheckBoxBackColorAlternate(Color.LightCyan, Color.White);
grid[1, 3].View = viewCheckBox;
///

/// 复选框CheckBox的相关设置 ///

public class CheckBoxBackColorAlternate : SourceGrid.Cells.Views.CheckBox
{
public CheckBoxBackColorAlternate(Color firstColor, Color secondColor)
{
FirstBackground = new DevAge.Drawing.VisualElements.BackgroundSolid(firstColor);
SecondBackground = new DevAge.Drawing.VisualElements.BackgroundSolid(secondColor);
}

        private DevAge.Drawing.VisualElements.IVisualElement mFirstBackground;  
        public DevAge.Drawing.VisualElements.IVisualElement FirstBackground  
        {  
            get { return mFirstBackground; }  
            set { mFirstBackground = value; }  
        }

        private DevAge.Drawing.VisualElements.IVisualElement mSecondBackground;  
        public DevAge.Drawing.VisualElements.IVisualElement SecondBackground  
        {  
            get { return mSecondBackground; }  
            set { mSecondBackground = value; }  
        }

        protected override void PrepareView(SourceGrid.CellContext context)  
        {  
            base.PrepareView(context);

            if (Math.IEEERemainder(context.Position.Row, 2) == 0)  
                Background = FirstBackground;  
            else  
                Background = SecondBackground;  
        }  
    }

注意:SourceGrid中不知道为什么没有单选按钮Radio,我为了实现效果直接用了CheckBox复选框,在单元格的点击事件中实现单选效果

private void clickEvent_Click(object sender, EventArgs e)
{
SourceGrid.CellContext context = (SourceGrid.CellContext)sender;
if (context.Position.Column == 1)//选择事件
{
for (int r = 1; r < grid.RowsCount; r++)
{
if (r == context.Position.Row)
{
grid[r, 1].Value = true;
}
else
{
grid[r, 1].Value = false;
}
}
}
}

11:复制粘贴

1.grid.ClipboardMode = SourceGrid.ClipboardMode.All;
2.也可在属性中设置

若要实现单元格不可编辑但是可以复制功能的话需要注意:(不能使用14中的单元格不可操作代码)
上述设置实现后,在赋值地方

grid[1, 3] = new SourceGrid.Cells.Cell("Hello " + r.ToString(), typeof(string));改为

grid[1, 3] = new SourceGrid.Cells.Cell("Hello " + r.ToString());即不要带赋值类型就可实现不可编辑

12:单元格添加事件(点击事件/修改编辑后触发的事件)(点击/鼠标进入单元格显示手型,离开现实默认样式)

SourceGrid.Cells.Controllers.CustomEvents clickEvent = new SourceGrid.Cells.Controllers.CustomEvents();
clickEvent.Click += new EventHandler(clickEvent_Click);//点击(单击)
clickEvent.DoubleClick += new EventHandler(clickEvent_DoubleClick);//双击
clickEvent.EditEnded += new EventHandler(editEvent_EditEnded);//编辑后
//鼠标进入和离开
clickEvent.MouseEnter += new EventHandler(mouseEvent_MouseEnter);
clickEvent.MouseLeave += new EventHandler(mouseEvent_MouseLeave);
//绑定事件
grid[r, 8].AddController(clickEvent);
//单击事件
private void clickEvent_Click(object sender, EventArgs e)
{
SourceGrid.CellContext context = (SourceGrid.CellContext)sender;
MessageBox.Show(this, context.Position.ToString());
}
//双击事件

private void clickEvent_DoubleClick(object sender, EventArgs e)

{ 　　　　SourceGrid.CellContext context = (SourceGrid.CellContext)sender; 　　　　MessageBox.Show(this, context.Position.ToString()); 　　　　//要执行的操作

　　}

///

/// 进入单元格鼠标显示手型 ///

///
///
private void mouseEvent_MouseEnter(object sender, EventArgs e)
{
　　SourceGrid.CellContext context = (SourceGrid.CellContext)sender;
　　if (context.Position.Column == 8)
　　{
　　　　this.Cursor = Cursors.Hand;
　　}
}
///

/// 离开单元格鼠标显示默认状态 ///

///
///
private void mouseEvent_MouseLeave(object sender, EventArgs e)
{
　　SourceGrid.CellContext context = (SourceGrid.CellContext)sender;
　　if (context.Position.Column == 8)
　　{
　　　　this.Cursor = Cursors.Default;
　　}
}

    /// <summary>  
    /// 单元格编辑结束  
    /// </summary>  
    /// <param name="sender"></param>  
    /// <param name="e"></param>  
    private void editEvent\_EditEnded(object sender, EventArgs e)  
    {  
        SourceGrid.CellContext context = (SourceGrid.CellContext)sender;  
        //进行保存等相关操作  
    }    

13:隐藏/显示行/列

grid1.Columns[0].Visible=true;
grid1.Rows[1].Visible = false;

14:使单元格不可操作(不可编辑)

grid[1, 2].AddController(SourceGrid.Cells.Controllers.Unselectable.Default);

15:ComboBox下拉框的使用

SourceGrid.Cells.Editors.ComboBox cbKFJD = new SourceGrid.Cells.Editors.ComboBox(typeof(string));
cbKFJD.StandardValues = new string[] { "老区","新区" };
cbKFJD.EditableMode = SourceGrid.EditableMode.Focus | SourceGrid.EditableMode.SingleClick | SourceGrid.EditableMode.AnyKey;
grid[1, 2] = new SourceGrid.Cells.Cell("老区", cbKFJD);

16:报错索引超出界限的特殊性情况处理:

在代码中设置了足够的行数和列数但是在colspan或rowspan的时候依然报错可能原因是在属性设置中Columnscout或Rowscount设置了值但是值不够大,

解决办法:1.属性设置Columnscout和Rowscount不要设值默认值0(推荐)

　　　　2.属性设置Columnscout或Rowscount设置一个足够大的值就行

17:进入页面不显示焦点:grid.Selection.FocusStyle = FocusStyle.None;

18:以Excel格式导出当前SourceGrid表格

　　　　　///

/// 导出计算报表 ///

///
///
private void materialButton2_Click(object sender, EventArgs e)
{
try
{
SaveFileDialog sfd = new SaveFileDialog();
string tradeTime = DateTime.Now.ToString("yyyyMMddHHmmss", DateTimeFormatInfo.InvariantInfo);
sfd.FileName = "计算报表" + tradeTime;
if (sfd.ShowDialog() != DialogResult.OK) return;
//保存
var exportFileName = System.IO.Path.Combine(sfd.FileName.Substring(0, sfd.FileName.Length - 18), sfd.FileName.Substring(sfd.FileName.Length - 18) + ".csv");

            using (var writer = new System.IO.StreamWriter(exportFileName, false, System.Text.Encoding.Default))  
            {  
                var csv = new SourceGrid.Exporter.CsvExporter();  
                csv.Export(grid, writer);  
                writer.Close();  
                MessageBox.Show("导出成功!");  
            }

            DevAge.Shell.Utilities.OpenFile(exportFileName);  
        }  
        catch (Exception ex)  
        {  
            MessageBox.Show("导出失败!" + ex.Message);  
        }