public List <Definitions.Status> ListPurchaseStatus() { DbSelectStatement clause = DbMgr.CreateSelectClause(); clause .SelectDistinct() .SelectColumn("RecurringPurchases", "PurchaseStatusID") .From("RecurringPurchases"); DbCriteria criteria = DbMgr.CreateCriteria(); DbCommand _cmd = CreateDbCommand(clause); DbDataReader _reader = _cmd.ExecuteReader(); while (_reader.Read()) { criteria.IsEqual("Status", "StatusID", GetString(_reader, ("PurchaseStatusID")), DbCriteria.ConcatMode.OR); } _reader.Close(); _cmd.Dispose(); return(RepositoryMgr.StatusMgr.List(criteria)); }
protected virtual IList <Status> _FindSaleStatusCollection() { DbCriteria criteria = DbMgr.CreateCriteria(); criteria .IsEqual("Status", "StatusID", "O", DbCriteria.ConcatMode.OR) .IsEqual("Status", "StatusID", "C", DbCriteria.ConcatMode.OR) .IsEqual("Status", "StatusID", "OR", DbCriteria.ConcatMode.OR) .IsEqual("Status", "StatusID", "CR", DbCriteria.ConcatMode.OR) .IsEqual("Status", "StatusID", "Q", DbCriteria.ConcatMode.OR); return(List(criteria)); }
public List <Status> ListPurchaseStatus() { DbCriteria criteria = DbMgr.CreateCriteria(); criteria .IsEqual("Status", "StatusID", "O", DbCriteria.ConcatMode.OR) .IsEqual("Status", "StatusID", "C", DbCriteria.ConcatMode.OR) .IsEqual("Status", "StatusID", "OR", DbCriteria.ConcatMode.OR) .IsEqual("Status", "StatusID", "DR", DbCriteria.ConcatMode.OR) .IsEqual("Status", "StatusID", "Q", DbCriteria.ConcatMode.OR); return(List(criteria)); }
public DbCriteria CreateCriteria() { return(DbMgr.CreateCriteria()); }