Install-Package ReoGrid.Mvvm

 1 [WorksheetAttribute(Title = "Books")]
 2 public class Book: IRecordModel
 3 {
 4     [ColumnHeader(Index = 10, IsVisible = false)]
 5     public int Id { get; set; }
 6 
 7     [ColumnHeader(Index = 20, Text = "Name", Width = 150)]
 8     public string Title { get; set; }
 9 
10     [ColumnHeader(Index = 30)]
11     public string Author { get; set; }
12 
13     [ColumnHeader(Index = 35, Text = "Type")]
14     public BindingType BindingType { get; set; }
15 
16     [ColumnHeader(Index = 36, Text = "OnSale")]
17     public bool IsOnSale { get; set; }
18 
19     [NumberFormat(DecimalPlaces = 2)]
20     [ColumnHeader(Index = 40)]
21     public decimal Price { get; set; }
22 
23     [DateTimeFormat( CultureName = "en-US")]
24     [ColumnHeader(Index = 45, Text = "Publish Date", Width = 200)]
25     public DateTime Pubdate { get; set; }
26 
27     public int RowIndex { get; set; }
28 }

1 private ObservableCollection<IRecordModel> _Books;
2 private WorksheetModel _WorksheetModel;

 1 _Books = new ObservableCollection<IRecordModel>();
 2 for (int i = 0; i < 10; i++)
 3 {
 4     Book book = new Book();
 5     book.Id = i;
 6     book.Title = string.Format("Title {0}", i);
 7     book.Author = string.Format("Author {0}", i);
 8     book.BindingType = BindingType.Hardback;
 9     book.IsOnSale = true;
10     book.Price = (decimal)(i * 10.1);
11     book.Pubdate = DateTime.Now;
12     _Books.Add(book);
13 }
14 // 變量 reoGridControl 是 ReoGridControl 的控件元素實(shí)例
15 _WorksheetModel = new WorksheetModel(reoGridControl, typeof(Book), _Books);
16 //如果需要在輸入值前檢查變量的有效性，那么就實(shí)現(xiàn)該函數(shù)
17 _WorksheetModel.OnBeforeChangeRecord += OnBeforeChangeRecord;

 1 private bool? OnBeforeChangeRecord(IRecordModel record, PropertyInfo propertyInfo, object newProperyValue)
 2 {
 3     if (propertyInfo.Name.Equals("Price"))
 4     {
 5         decimal price = Convert.ToDecimal(newProperyValue);
 6         if (price > 100m) //假設(shè)最大價(jià)格是100
 7         {
 8             MessageBox.Show("最大價(jià)格是 100， 請(qǐng)重新輸入！.", "Alert", 
 9                             MessageBoxButton.OK, MessageBoxImage.Warning);
10             return true; // 返回 true 則取消本次輸入
11         }
12     }
13 
14     return null;
15 }

 1 // 增加一條書(shū)目信息
 2 int count = _Books.Count;
 3 Book book = new Book();
 4 book.Id = count;
 5 book.Title = string.Format("Title {0}", count);
 6 book.Author = string.Format("Author {0}", count);
 7 book.BindingType = BindingType.Hardback;
 8 book.IsOnSale = true;
 9 book.Price = (decimal)(count * 10.11) > 100m ? 100m :(decimal)(count * 10.11);
10 book.Pubdate = DateTime.Now;
11 _Books.Add(book);
12 
13 // 移除一條書(shū)目信息
14 if (_Books.Count > 0)
15 {
16     _Books.RemoveAt(_Books.Count - 1);
17 }
18 
19 // 移動(dòng)一條書(shū)目信息
20 if (_Books.Count > 2)
21 {
22     _Books.Move(0, _Books.Count - 1);
23 }
24 
25 // 編輯一條書(shū)目信息
26 (_Books[0] as Book).Price = new Random(DateTime.Now.Millisecond).Next(1,100);
27 // 編輯完 模型（Model） 之后要調(diào)用 UpadteRecord 函數(shù)將模型（Model）的變化同步到視圖（View）中
28 _WorksheetModel.UpadteRecord(_Books[0]);