public IDynamicTableObject[] take(int count)
{
var query = new Kooboo.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 IDynamicTableObject GetByLog(long LogId)
{
var log = this.table.OwnerDatabase.Log.Get(LogId);
if (log != null)
{
var logdata = this.table.GetLogData(log);
return(DynamicTableObject.Create(logdata, this.table, this.context));
}
return(null);
}
public static DynamicTableObject[] CreateList(IDictionary <string, object>[] list, Table TargetTable, RenderContext context)
{
int len = list.Length;
DynamicTableObject[] result = new DynamicTableObject[len];
for (int i = 0; i < len; i++)
{
result[i] = Create(list[i], TargetTable, context);
}
return(result);
}
public IDynamicTableObject[] all()
{
var all = this.table.All();
return(DynamicTableObject.CreateList(all.ToArray(), this.table, this.context));
}
public IDynamicTableObject get(object id)
{
var obj = this.table.Get(id);
return(DynamicTableObject.Create(obj, this.table, this.context));
}
public IDynamicTableObject[] findAll(string query)
{
var list = this.table.Query.FindAll(query);
return(DynamicTableObject.CreateList(list.ToArray(), this.table, this.context));
}
public IDynamicTableObject[] findAll(string field, object value)
{
var list = this.table.Query.Where(field, Kooboo.IndexedDB.Query.Comparer.EqualTo, value).SelectAll();
return(DynamicTableObject.CreateList(list.ToArray(), this.table, this.context));
}
public IDynamicTableObject find(string fieldName, object matchValue)
{
var obj = this.table.Query.Where(fieldName, Kooboo.IndexedDB.Query.Comparer.EqualTo, matchValue).FirstOrDefault();
return(DynamicTableObject.Create(obj, this.table, this.context));
}
public IDynamicTableObject find(string query)
{
var result = this.table.Query.Find(query);
return(DynamicTableObject.Create(result, this.table, this.context));
}