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);
}
public int GetCurves(string primID, int crvSeqNo, string worklistID, int worklistNumber)
{
if (crvSeqNo > 0)
{
//var condition = new ParadoxCondition.Compare(ParadoxCompareOperator.Equal, mainTestID, 8, 0);
//QueryArgs q = new QueryArgs("HRRuns", condition, "CrvSeqNum", "");
//return GetSimpleRowInfos(q, false);
}
if (!String.IsNullOrEmpty(primID))
{
}
if (!String.IsNullOrEmpty(worklistID) && worklistNumber > 0)
{
var condition =
new ParadoxCondition.LogicalAnd(
new ParadoxCondition.Compare(
ParadoxCompareOperator.Equal, worklistID, 4, 0),
new ParadoxCondition.Compare(
ParadoxCompareOperator.Equal, worklistNumber, 0, 0)
);
QueryArgs q = new QueryArgs("HRRuns", condition, "", "");
return(GetResultInfos(q, false));
}
return(0);
}
static void Main(string[] args)
{
var dbPath = Path.Combine(Path.GetDirectoryName(Assembly.GetEntryAssembly().Location), "data");
Console.WriteLine("Test 1: sequential read first 10 records from start");
Console.WriteLine("==========================================================");
var table = new ParadoxTable(dbPath, "zakazky");
var recIndex = 1;
foreach (var rec in table.Enumerate())
{
Console.WriteLine("Record #{0}", recIndex++);
for (int i = 0; i < table.FieldCount; i++)
{
Console.WriteLine(" {0} = {1}", table.FieldNames[i], rec.DataValues[i]);
}
if (recIndex > 10)
{
break;
}
}
Console.WriteLine("-- press [enter] to continue --");
Console.ReadKey();
Console.Clear();
Console.WriteLine("Test 2: read 10 records by index (key range: 1750 -> 1760)");
Console.WriteLine("==========================================================");
var index = new ParadoxPrimaryKey(table, Path.Combine(dbPath, "zakazky.PX"));
var condition =
new ParadoxCondition.LogicalAnd(
new ParadoxCondition.Compare(ParadoxCompareOperator.GreaterOrEqual, 1750, 0, 0),
new ParadoxCondition.Compare(ParadoxCompareOperator.LessOrEqual, 1760, 0, 0));
var qry = index.Enumerate(condition);
var rdr = new ParadoxDataReader(table, qry);
recIndex = 1;
while (rdr.Read())
{
Console.WriteLine("Record #{0}", recIndex++);
for (int i = 0; i < rdr.FieldCount; i++)
{
Console.WriteLine(" {0} = {1}", rdr.GetName(i), rdr[i]);
}
}
Console.WriteLine("-- press [enter] to continue --");
Console.ReadKey();
}
/// <summary>
/// 获取Curve Sequence Number列表
/// </summary>
public List <SimpleRowInfo> CrvSeqNos(int testTypeTag, int mainRunType, string mainTestID)
{
var condition =
new ParadoxCondition.LogicalAnd(
new ParadoxCondition.Compare(
ParadoxCompareOperator.Greater, 0, 0, 0),
new ParadoxCondition.Compare(
ParadoxCompareOperator.Equal, testTypeTag, 7, 0),
new ParadoxCondition.Compare(
ParadoxCompareOperator.Equal, (short)mainRunType, 5, 0),
new ParadoxCondition.Compare(
ParadoxCompareOperator.Equal, mainTestID, 8, 0)
);
QueryArgs q = new QueryArgs("HRRuns", condition, "CrvSeqNum", "");
return(GetSimpleRowInfos(q, false));
}
/// <summary>
/// 4 获取Worklist列表
/// </summary>
/// <param name="testTypeTag"></param>
/// <param name="mainRunType"></param>
/// <param name="mainTestID"></param>
/// <returns></returns>
public List <SimpleRowInfo> HRWorkLists(int testTypeTag, int mainRunType, int procTag, bool useMainTest)
{
int dataIndex = useMainTest ? 9 : 8;
var condition =
new ParadoxCondition.LogicalAnd(
new ParadoxCondition.Compare(
ParadoxCompareOperator.Greater, 0, 0, 0),
new ParadoxCondition.Compare(
ParadoxCompareOperator.Equal, testTypeTag, 7, 0),
new ParadoxCondition.Compare(
ParadoxCompareOperator.Equal, (short)mainRunType, 5, 0),
new ParadoxCondition.Compare(
ParadoxCompareOperator.Equal, procTag, dataIndex, 0)
);
QueryArgs q = new QueryArgs("HRRuns", condition, "WrkLstNum", "WrkLstID");
return(GetSimpleRowInfos(q, false));
}
internal AggRamDbState GetSampleInfoByCrvSeqNum(int crvSeqNum)
{
var condition =
new ParadoxCondition.LogicalAnd(
new ParadoxCondition.Compare(
ParadoxCompareOperator.Greater, 0, 0, 0),
new ParadoxCondition.Compare(
ParadoxCompareOperator.Equal, crvSeqNum, 3, 0));
var sr = _Connection.ExecuteQuery("HRRuns", condition, false);
if (sr.Read())
{
AggRamDbState result = new AggRamDbState();
// 基本信息
result.WrkLstNum = (int)sr["WrkLstNum"];
result.ChnlNum = (short)((short)sr["ChnlNum"] + 1);
result.CrvSeqNum = (int)sr["CrvSeqNum"];
result.StartTime = ((DateTime)sr["StartTime"]).ToString("yyyy/MM/dd HH:mm:ss");
// 创建曲线点信息
int lblChnNum = (short)sr["ChnlNum"] + 1;
string label = "Channel " + lblChnNum.ToString();
AggRamCurve crv = new AggRamCurve(
label,
(int)sr["InitialMax"], (int)sr["InitialMin"],
(int)sr["ScaleSet1Rd"], (int)sr["MaxPCPoint"], (double)sr["ScaleSetResult"],
(int)sr["DataPoints"], (byte[])sr["Data"]);
Curve c = new Curve();
c.Label = crv.Label;
c.InitialMin = (int)sr["InitialMin"];
c.InitialMax = (int)sr["InitialMax"];
c.ZeroODPoint = crv.ZeroODPoint;
c.MaxPCPoint = crv.MaxPCPoint;
c.PointUnit = crv.PointUnit;
c.CurvePoints = crv.CurvePoints;
c.Count = crv.Count;
result.Curve = c;
// Add Report Row
ReportInfo reportRow = new ReportInfo();
reportRow.ChnlNum = lblChnNum;
reportRow.StartTime = (DateTime)sr["StartTime"];
int selectedProcTag = (int)sr["ProcTag"];
var procInfo = GetTestParams(selectedProcTag);
if (procInfo != null)
{
reportRow.ProcID = procInfo.ProcID;
reportRow.Abbrev = procInfo.Abbrev;
}
reportRow.Unit = (string)sr["Unit"];
reportRow.Conc = (double)sr["Conc"];
reportRow.PRP = FloatPS(crv.PRP, 3);
reportRow.PPP = FloatPS(crv.PPP, 3);
reportRow.MaxPercent = FloatPS(crv.MaxPercent * 100, 1);
reportRow.MaxPCTime = FloatPS((int)sr["MaxPCTime"] / 1000.0, 0);
reportRow.LagTime = FloatPS((int)sr["LagTime"] / 1000.0, 1);
reportRow.Slope = FloatPS((double)sr["Slope"], 1);
result.Report = reportRow;
string selectedPrimID = (string)sr["PrimID"];
result.Patient = GetPatientInfo(selectedPrimID);
return(result);
}
return(null);
}
