Esempio n. 1
0
 /// <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);
 }
Esempio n. 2
0
        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;
        }
Esempio n. 3
0
        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;
        }
Esempio n. 4
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);
 }
Esempio n. 5
0
 /// <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);
 }