public IDictionary <string, object>[] take(int count)
{
var query = new IndexedDB.Dynamic.Query(this.ktable.table);
if (!string.IsNullOrEmpty(this.SearchCondition))
{
var filter = query.ParserFilter(this.SearchCondition);
query.items = filter;
}
else
{
//throw new Exception("You do not any search condition");
}
if (!string.IsNullOrEmpty(this.OrderByField))
{
if (this.Ascending)
{
query.OrderByAscending(this.OrderByField);
}
else
{
query.OrderByDescending(this.OrderByField);
}
}
return(query.Skip(this.skipcount).Take(count).ToArray());
}
public DynamicTableObject[] take(int count)
{
var query = new IndexedDB.Dynamic.Query(this.ktable.table);
if (!string.IsNullOrEmpty(this.SearchCondition))
{
var filter = query.ParserFilter(this.SearchCondition);
query.items = filter;
}
else
{
//throw new Exception("You do not any search condition");
}
if (!string.IsNullOrEmpty(this.OrderByField))
{
if (this.Ascending)
{
query.OrderByAscending(this.OrderByField);
}
else
{
query.OrderByDescending(this.OrderByField);
}
}
var result = query.Skip(this.skipcount).Take(count).ToArray();
return(DynamicTableObject.CreateList(result, this.ktable.table, this.ktable.context));
}
public int count()
{
var query = new IndexedDB.Dynamic.Query(this.ktable.table);
if (!string.IsNullOrEmpty(this.SearchCondition))
{
var filter = query.ParserFilter(this.SearchCondition);
query.items = filter;
}
return(query.Count());
}
