protected QueryViewModelCommandable(TParamViewModel paramViewModel, QueryDbService <TDbModel> dbService)
{
ParamViewModel = paramViewModel;
DbService = dbService;
PagerControlViewModel = new PagerControlViewModel();
PagerControlViewModel.LoadPager(Pub.PageLineCount);
}
public List <int> ReadIds(StackAppContext appContext, FilterExpression filter)
{
var q = new DbQuery(this);
q.AddField(this.IDField, true);
q.SetFixedFilter(filter);
var data = QueryDbService.ExecuteEntityQuery(appContext, q);
var list = new List <int>();
if (data.Count() > 0)
{
foreach (var d in data)
{
list.Add(d.Get(this.IDField, 0));
}
}
return(list);
}
public List <DBModelBase> ReadAll(StackAppContext appContext, List <string> fields, FilterExpression filter)
{
var q = new DbQuery(this);
foreach (var f in fields)
{
q.AddField(f, true);
}
q.AddField(this.IDField, true);
q.SetFixedFilter(filter);
var data = QueryDbService.ExecuteEntityQuery(appContext, q);
var models = new List <DBModelBase>();
foreach (var d in data)
{
var m = new DBModelBase(this);
m.BuiltWithDB(d);
models.Add(m);
}
return(models);
}
public static IEnumerable <DbObject> ExecuteData(StackAppContext appContext, DbQuery query)
{
var data = QueryDbService.ExecuteEntityQuery(appContext, query);
return(data);
}
