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);
}
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);
}
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);
}
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);
}