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);
}
