Example #1
0
        internal List <ShowBase> GetSampleByFilterDate(DateTime filterDate)
        {
            var condition =
                new ParadoxCondition.LogicalAnd(
                    new ParadoxCondition.Compare(
                        ParadoxCompareOperator.Greater, 0, 0, 0),
                    new ParadoxCondition.Compare(
                        ParadoxCompareOperator.GreaterOrEqual, filterDate.Date, 2, 0),
                    new ParadoxCondition.Compare(
                        ParadoxCompareOperator.Less, filterDate.AddDays(1).Date, 2, 0)
                    );
            var c = new ParadoxCondition.LogicalAnd(
                new ParadoxCondition.Compare(
                    ParadoxCompareOperator.Greater, 0, 0, 0));
            var             rdr    = _Connection.ExecuteQuery("HRRuns", condition, false);
            List <ShowBase> result = new List <ShowBase>();

            while (rdr.Read())
            {
                SimpleResult r = new SimpleResult();
                r.CrvSeqNum = rdr.GetInt32(rdr.GetOrdinal("CrvSeqNum"));
                r.PrimId    = rdr.GetString(rdr.GetOrdinal("PrimId"));
                r.StartTime = rdr.GetDateTime(rdr.GetOrdinal("StartTime"));
                result.Add((ShowBase)r);
            }
            return(result);
            // return GetSimpleRowInfos(q, false);
        }
Example #2
0
        internal List <SimpleResult> GetAllDates()
        {
            var condition =
                new ParadoxCondition.Compare(
                    ParadoxCompareOperator.Greater, 0, 0, 0);
            var rdr = _Connection.ExecuteQuery("HRRuns", condition, false);
            List <SimpleResult> result = new List <SimpleResult>();

            while (rdr.Read())
            {
                SimpleResult r = new SimpleResult();
                r.CrvSeqNum = rdr.GetInt32(rdr.GetOrdinal("CrvSeqNum"));
                r.PrimId    = rdr.GetString(rdr.GetOrdinal("PrimId"));
                r.StartTime = rdr.GetDateTime(rdr.GetOrdinal("StartTime"));
                result.Add(r);
            }
            return(result);
            // return GetSimpleRowInfos(q, false);
        }
Example #3
0
 internal List<ShowBase> GetSampleByFilterDate(DateTime filterDate)
 {
     var condition =
     new ParadoxCondition.LogicalAnd(
         new ParadoxCondition.Compare(
             ParadoxCompareOperator.Greater, 0, 0, 0),
         new ParadoxCondition.Compare(
             ParadoxCompareOperator.GreaterOrEqual, filterDate.Date, 2, 0),
             new ParadoxCondition.Compare(
             ParadoxCompareOperator.Less, filterDate.AddDays(1).Date, 2, 0)
             );
     var c = new ParadoxCondition.LogicalAnd(
         new ParadoxCondition.Compare(
             ParadoxCompareOperator.Greater, 0, 0, 0));
     var rdr = _Connection.ExecuteQuery("HRRuns", condition, false);
     List<ShowBase> result = new List<ShowBase>();
     while (rdr.Read())
     {
         SimpleResult r = new SimpleResult();
         r.CrvSeqNum = rdr.GetInt32(rdr.GetOrdinal("CrvSeqNum"));
         r.PrimId = rdr.GetString(rdr.GetOrdinal("PrimId"));
         r.StartTime = rdr.GetDateTime(rdr.GetOrdinal("StartTime"));
         result.Add((ShowBase)r);
     }
     return result;
     // return GetSimpleRowInfos(q, false);
 }
Example #4
0
 internal List<SimpleResult> GetAllDates()
 {
     var condition =
         new ParadoxCondition.Compare(
             ParadoxCompareOperator.Greater, 0, 0, 0);
     var rdr = _Connection.ExecuteQuery("HRRuns", condition, false);
     List<SimpleResult> result = new List<SimpleResult>();
     while (rdr.Read())
     {
         SimpleResult r = new SimpleResult();
         r.CrvSeqNum = rdr.GetInt32(rdr.GetOrdinal("CrvSeqNum"));
         r.PrimId = rdr.GetString(rdr.GetOrdinal("PrimId"));
         r.StartTime = rdr.GetDateTime(rdr.GetOrdinal("StartTime"));
         result.Add(r);
     }
     return result;
     // return GetSimpleRowInfos(q, false);
 }