public SearchResult <ConsumableUsage> GetByCriteria(int page, int limit, DateTime?start = null, DateTime?end = null) { var searchInfo = new ConsumableUsageSearchInfo { Start = start, End = end, PageIndex = page, PageSize = limit }; return(service.Search(searchInfo)); }
void OnRefreshList(object param) { var searchInfo = new ConsumableUsageSearchInfo { Start = startDate, End = endDate, PageIndex = pageIndex, PageSize = pageSize }; var result = usageService.Search(searchInfo); UsageList = new ObservableCollection <ConsumableUsage>(result.Items); TotalRecords = result.Total; DeleteCommand.EntityId = Guid.Empty; }
public void Can_SearchByDate() { Models.Data.ConsumableUsage usage1, usage2; using (var conn = factory.OpenDbConnection()) { var id1 = Guid.NewGuid(); var id2 = Guid.NewGuid(); usage1 = new Models.Data.ConsumableUsage { Id = id1, Date = DateTime.Today.AddDays(-1), Total = 10000 }; usage2 = new Models.Data.ConsumableUsage() { Id = id2, Date = DateTime.Today, Total = 5000 }; using (var tx = conn.OpenTransaction()) { conn.InsertParam(usage1); conn.InsertParam(usage2); tx.Commit(); } } var searchInfo = new ConsumableUsageSearchInfo { Start = DateTime.Today.AddDays(-2), End = DateTime.Today.AddDays(1), PageIndex = 1, PageSize = 1 }; var result = service.Search(searchInfo); Assert.Equal(2, result.Total); Assert.Equal(usage2.Id, result.Items[0].Id); }