public List<EntityObject> GetEntities(string entityType)
{
using (BudgetAccountBLL bll = new BudgetAccountBLL())
{
DateTime dtStart = DateTime.Parse(this.tbStart.Text);
DateTime dtEnd = DateTime.Parse(this.tbEnd.Text);
QueryExpression qeStart = new QueryExpression();
qeStart.PropertyName = FieldName.UpdateDate;
qeStart.PropertyValue = this.tbStart.Text;
qeStart.Operation = QueryExpression.Operations.GreaterThanOrEqual;
QueryExpression qeEnd = new QueryExpression();
qeEnd.PropertyName = FieldName.UpdateDate;
qeEnd.PropertyValue = this.tbEnd.Text;
qeEnd.Operation = QueryExpression.Operations.LessThanOrEqual;
QueryExpression qeCheckStatesPass = QueryExpression.Equal(FieldName.CheckStates, "2");
QueryExpression qeCheckStatesPassing = QueryExpression.Equal(FieldName.CheckStates, "1");
qeStart.RelatedExpression = qeEnd;
qeEnd.RelatedExpression = qeCheckStatesPass;
qeCheckStatesPass.RelatedType = QueryExpression.RelationType.Or;
qeCheckStatesPass.RelatedExpression = qeCheckStatesPassing;
qeStart.QueryType = entityType;
qeStart.OrderByExpression = new OrderByExpression { OrderByType = OrderByType.Asc, PropertyName = FieldName.UpdateDate };
qeStart.IsNoTracking = true;
return qeStart.Query(bll);
}
}
