protected EntityList FetchBy(TimeSpanCriteria criteria)
{
return(this.QueryList(q =>
{
q.Constrain(PurchaseOrder.DateProperty).GreaterEqual(criteria.From)
.And().Constrain(PurchaseOrder.DateProperty).LessEqual(criteria.To);
}));
}
public PurchaseOrderList GetBy(TimeSpanCriteria criteria)
{
return((PurchaseOrderList)this.GetBy(new CommonQueryCriteria
{
new PropertyMatch(PurchaseOrder.DateProperty, PropertyOperator.GreaterEqual, criteria.From),
new PropertyMatch(PurchaseOrder.DateProperty, PropertyOperator.LessEqual, criteria.To),
}));
}
public StorageMoveList GetBy(TimeSpanCriteria criteria)
{
return(this.GetBy(new CommonQueryCriteria
{
new PropertyMatch(StorageMove.DateProperty, PropertyOperator.GreaterEqual, criteria.From),
new PropertyMatch(StorageMove.DateProperty, PropertyOperator.LessEqual, criteria.To),
}));
}
protected EntityList FetchBy(TimeSpanCriteria criteria)
{
var f = QueryFactory.Instance;
var t = f.Table(this.Repository);
var q = f.Query(
selection: t.Star(),
from: t,
where : f.And(
t.Column(StorageOutBill.DateProperty).GreaterEqual(criteria.From),
t.Column(StorageOutBill.DateProperty).LessEqual(criteria.To)
)
);
return(this.QueryList(q));
}
public virtual StorageInBillList GetBy(TimeSpanCriteria criteria)
{
var f = QueryFactory.Instance;
var t = f.Table(this.Repository);
var q = f.Query(
selection: t.Star(),
from: t,
where : f.And(
t.Column(StorageInBill.DateProperty).GreaterEqual(criteria.From),
t.Column(StorageInBill.DateProperty).LessEqual(criteria.To)
)
);
return((StorageInBillList)this.QueryData(q));
}
public virtual StorageOutBillList GetBy(TimeSpanCriteria criteria)
{
throw new NotSupportedException();
//return (this.DataProvider as StorageInBillDataProvider).GetBy(criteria);
}