void OnNextPage(PageData p_pd)
{
INotifyList ls;
if (_isTbl)
{
ls = SampleData.CreatePersonsTbl(p_pd.PageSize);
}
else
{
ls = SampleData.CreatePersonsList(p_pd.PageSize);
}
p_pd.LoadPageData(ls);
}
void InitializeSpread()
{
_excel.ValueChanged += gcSpreadSheet1_ValueChanged;
_excel.TabStripVisibility = Visibility.Collapsed;
_excel.AutoClipboard = false;
_excel.CanCellOverflow = false;
_excel.CanUserDragFill = false;
_excel.CanUserDragDrop = false;
_excel.ColumnSplitBoxPolicy = SplitBoxPolicy.Never;
_excel.RowSplitBoxPolicy = SplitBoxPolicy.Never;
var sheet = _excel.ActiveSheet;
sheet.SelectionPolicy = SelectionPolicy.Single;
//sheet.SelectionUnit = SelectionUnit.Row;
sheet.RowFilter = new HideRowFilter(new CellRange(-1, -1, -1, -1));
//sheet.Protect = true;
//sheet.DataSource = GetDataSource();
//sheet.AddSelection(0, 0, 1, 1);
//sheet.Columns[0].Locked = false;
//sheet.Columns[1].Locked = false;
//sheet.Columns[2].Locked = false;
//sheet.Columns[3].Locked = false;
//sheet.Columns[4].Locked = false;
//sheet.Columns[0].Width = 100;
//sheet.Columns[1].Width = 100;
//sheet.Columns[2].Width = 200;
//sheet.Columns[3].Width = 100;
//sheet.Columns[4].Width = 300;
sheet.DataSource = SampleData.CreatePersonsList(5000);
sheet.Columns[0].Width = 150;
sheet.Columns[1].Width = 100;
sheet.Columns[2].Width = 60;
sheet.Columns[3].Width = 100;
sheet.Columns[4].Width = 200;
sheet.Columns[5].Width = 60;
sheet.Columns[6].Width = 60;
sheet.Columns[7].Width = 80;
sheet.Columns[8].Width = 80;
sheet.Columns[9].Width = 150;
sheet.Columns[10].Width = 100;
}
void OnInsertRows(object sender, RoutedEventArgs e)
{
if (_lv.Data is Table)
{
var data = SampleData.CreatePersonsTbl(10);
foreach (var row in data)
{
row.InitVal("xm", "新行");
}
_lv.Data.InsertRange(0, data);
}
else
{
var ls = SampleData.CreatePersonsList(10);
foreach (var per in ls)
{
per.Xm = "新对象行";
}
_lv.Data.InsertRange(0, ls);
}
}
void OnLoadObjs(object sender, RoutedEventArgs e)
{
_lv.Data = SampleData.CreatePersonsList(int.Parse(((Button)sender).Tag.ToString()));
}
void OnLoadPersons(object sender, AsyncEventArgs e)
{
((CList)sender).Data = SampleData.CreatePersonsList(20);
}
