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