///<summary>Returns a list of MedLabs containing one MedLab object which has a list of MedLabResults containing one MedLabResult as a field. ///This will test whether or not we can handle a return value that is a list of objects with lists of objects as fields. ///Both the MedLab and the MedLabResult contain longs, the DirtyString, the NewLineString, an enum, and Date/DateTime fields.</summary> public static List <MedLab> GetListMedLabsSpecialChars() { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { return(Meth.GetObject <List <MedLab> >(MethodBase.GetCurrentMethod())); } MedLab medLabCur = new MedLab { MedLabNum = 1, NoteLab = DirtyString, NotePat = NewLineString, ResultStatus = ResultStatus.P, DateTimeEntered = DateTodayTest, DateTimeReported = DateTEntryTest }; MedLabResult medLabResultCur = new MedLabResult { MedLabResultNum = 2, MedLabNum = 1, Note = DirtyString, ObsText = NewLineString, ObsSubType = DataSubtype.PDF, DateTimeObs = DateTEntryTest }; medLabCur.ListMedLabResults.Add(medLabResultCur); return(new List <MedLab> { medLabCur }); }
///<summary></summary> public static void Update(MedLabResult medLabResult) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { Meth.GetVoid(MethodBase.GetCurrentMethod(), medLabResult); return; } Crud.MedLabResultCrud.Update(medLabResult); }
///<summary></summary> public static long Insert(MedLabResult medLabResult) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { medLabResult.MedLabResultNum = Meth.GetLong(MethodBase.GetCurrentMethod(), medLabResult); return(medLabResult.MedLabResultNum); } return(Crud.MedLabResultCrud.Insert(medLabResult)); }
///<summary>Gets a list of all MedLabResult objects for this patient with the same ObsID and ObsIDSub as the supplied medLabResult, ///and for the same SpecimenID and SpecimenIDFiller. Ordered by ResultStatus,DateTimeObs descending, MedLabResultNum descending. ///Used to display the history of a result as many statuses may be received.</summary> public static List <MedLabResult> GetResultHist(MedLabResult medLabResult, long patNum, string specimenID, string specimenIDFiller) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { return(Meth.GetObject <List <MedLabResult> >(MethodBase.GetCurrentMethod(), medLabResult, patNum, specimenID, specimenIDFiller)); } List <MedLabResult> retval = new List <MedLabResult>(); if (medLabResult == null) { return(retval); } string command = "SELECT medlabresult.* FROM medlabresult " + "INNER JOIN medlab ON medlab.MedLabNum=medlabresult.MedLabNum " + "AND medlab.PatNum=" + POut.Long(patNum) + " " + "AND medlab.SpecimenID='" + POut.String(specimenID) + "' " + "AND medlab.SpecimenIDFiller='" + POut.String(specimenIDFiller) + "' " + "WHERE medlabresult.ObsID='" + POut.String(medLabResult.ObsID) + "' " + "AND medlabresult.ObsIDSub='" + POut.String(medLabResult.ObsIDSub) + "' " + "ORDER BY medlabresult.ResultStatus,medlabresult.DateTimeObs DESC,medlabresult.MedLabResultNum DESC"; return(Crud.MedLabResultCrud.SelectMany(command)); }
///<summary>Sort by MedLabResult.MedLabResultNum.</summary> private static int SortByMedLabNum(MedLabResult medLabResultX,MedLabResult medLabResultY) { if(medLabResultX.MedLabNum!=medLabResultY.MedLabNum) { return medLabResultX.MedLabNum.CompareTo(medLabResultY.MedLabNum); } return medLabResultX.MedLabResultNum.CompareTo(medLabResultY.MedLabResultNum); }
///<summary>Gets a list of all MedLabResult objects for this patient with the same ObsID and ObsIDSub as the supplied medLabResult, ///and for the same SpecimenID and SpecimenIDFiller. Ordered by ResultStatus,DateTimeObs descending, MedLabResultNum descending. ///Used to display the history of a result as many statuses may be received.</summary> public static List<MedLabResult> GetResultHist(MedLabResult medLabResult,long patNum,string specimenID,string specimenIDFiller) { if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { return Meth.GetObject<List<MedLabResult>>(MethodBase.GetCurrentMethod(),medLabResult,patNum,specimenID,specimenIDFiller); } List<MedLabResult> retval=new List<MedLabResult>(); if(medLabResult==null) { return retval; } string command="SELECT medlabresult.* FROM medlabresult " +"INNER JOIN medlab ON medlab.MedLabNum=medlabresult.MedLabNum " +"AND medlab.PatNum="+POut.Long(patNum)+" " +"AND medlab.SpecimenID='"+POut.String(specimenID)+"' " +"AND medlab.SpecimenIDFiller='"+POut.String(specimenIDFiller)+"' " +"WHERE medlabresult.ObsID='"+POut.String(medLabResult.ObsID)+"' " +"AND medlabresult.ObsIDSub='"+POut.String(medLabResult.ObsIDSub)+"' " +"ORDER BY medlabresult.ResultStatus,medlabresult.DateTimeObs DESC,medlabresult.MedLabResultNum DESC"; return Crud.MedLabResultCrud.SelectMany(command); }
///<summary></summary> public static void Update(MedLabResult medLabResult) { if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { Meth.GetVoid(MethodBase.GetCurrentMethod(),medLabResult); return; } Crud.MedLabResultCrud.Update(medLabResult); }
///<summary></summary> public static long Insert(MedLabResult medLabResult) { if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { medLabResult.MedLabResultNum=Meth.GetLong(MethodBase.GetCurrentMethod(),medLabResult); return medLabResult.MedLabResultNum; } return Crud.MedLabResultCrud.Insert(medLabResult); }