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));
        }
Пример #2
0
        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));
        }
Пример #3
0
        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));
        }
Пример #4
0
 public DbCriteria CreateCriteria()
 {
     return(DbMgr.CreateCriteria());
 }