public Example()
{
this.InitializeComponent();
try
{
DataContext = new VirtualQueryableCollectionView(new NorthwindEntities().Order_Details.OrderBy(o => o.OrderID)) { LoadSize = 5 };
}
catch
{
}
}
private void Load()
{
var context = new TestContext();
if (File.Exists("Test.db"))
{
File.Delete("Test.db");
}
File.Copy(@"..\..\Test.db", "Test.db");
view = new VirtualQueryableCollectionView(context.Cities);
view.FilterDescriptors.Add(new FilterDescriptor("Id", FilterOperator.IsEqualTo, 123));
GV.ItemsSource = view;
File.Delete("Test.db");
}
public VirtualQueryableCollectionView SetDataSource()
{
this.DataServiceCollection.Load((DataServiceQuery <Trust>)
this.Context.trust
.IncludeTotalCount()
// .Where(this.trusts.FilterDescriptors)
// .Sort(this.trusts.SortDescriptors)
.Skip(0).Take(10));
this.trusts = new VirtualQueryableCollectionView(this.DataServiceCollection)
{
LoadSize = 10
};
return(this.trusts);
}
public void ClearLoadedCustomers()
{
this.Customers = null;
}
public DocumntsFlowWindow(AccDocumentItemDTO sender, string state)
{
InitializeComponent();
//var _uow = SmObjectFactory.Container.GetInstance<SainaDbContext>();
//gridViewGrid.DataContext = new VirtualQueryableCollectionView(ctx.DocItems.OrderBy(x => x.Id)) { LoadSize = 10 };
Loaded += (s, e) =>
{
accDocumentItemsGridView.IsBusy = true;
var _uow = SmObjectFactory.Container.GetInstance <SainaDbContext>();
switch (state)
{
case "OnGLGrouped":
case "OnGLDetailed":
var cc = _uow.AccDocumentItems
.Where(x => x.SL.TL.GL.GLId == sender.Id)
.OrderBy(x => x.AccDocumentHeaderId);
DataContext = new VirtualQueryableCollectionView(_uow.AccDocumentItems
.Where(x => x.SL.TL.GL.GLId == sender.Id)
.OrderBy(x => x.AccDocumentHeaderId))
{
LoadSize = 10
};
break;
case "OnTLGrouped":
case "OnTLDetailed":
DataContext = new VirtualQueryableCollectionView(_uow.AccDocumentItems
.Where(x => x.SL.TLId == sender.Id)
.OrderBy(x => x.AccDocumentHeaderId))
{
LoadSize = 10
};
break;
case "OnSLGrouped":
case "OnSLDetailed":
accDocumentItemsGridView.DataContext = new VirtualQueryableCollectionView(_uow.AccDocumentItems
.OrderBy(x => x.AccDocumentHeaderId)
.Where(x => x.SLId == sender.Id)
)
{
LoadSize = 10
};
break;
case "OnDL1Grouped":
case "OnDL1Detailed":
DataContext = new VirtualQueryableCollectionView(_uow.AccDocumentItems
.Where(x => x.SL.SLCode == sender.Code)
.OrderBy(x => x.AccDocumentHeaderId))
{
LoadSize = 10
};
break;
case "OnDL2Grouped":
case "OnDL2Detailed":
DataContext = new VirtualQueryableCollectionView(_uow.AccDocumentItems
.Where(x => x.SL.SLCode == sender.Code)
.OrderBy(x => x.AccDocumentHeaderId))
{
LoadSize = 10
};
break;
case "OnCurrencyGrouped":
case "OnCurrencyDetailed":
DataContext = new VirtualQueryableCollectionView(_uow.AccDocumentItems
.Where(x => x.SL.SLCode == sender.Code)
.OrderBy(x => x.AccDocumentHeaderId))
{
LoadSize = 10
};
break;
case "OnTrackingGrouped":
case "OnTrackingDetailed":
DataContext = new VirtualQueryableCollectionView(_uow.AccDocumentItems
.Where(x => x.SL.SLCode == sender.Code)
.OrderBy(x => x.AccDocumentHeaderId))
{
LoadSize = 10
};
break;
default:
break;
}
accDocumentItemsGridView.IsBusy = false;
};
}
