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