///<summary>Returns text used in WHERE clause of query for tempehrlist.</summary> private static string GetFilteringText(EhrPatListElement element) { string filter = ""; string compStr = POut.String(element.CompareString); string labStr = POut.String(element.LabValue); switch (element.Restriction) { case EhrRestrictionType.Birthdate: filter = "DATE_SUB(CURDATE(),INTERVAL " + compStr + " YEAR)" + GetOperandText(element.Operand) + "Birthdate "; break; case EhrRestrictionType.Problem: filter = "`" + compStr + "`" + " IS NOT NULL "; //Has the disease. break; case EhrRestrictionType.LabResult: filter = "`" + compStr + "`" + GetOperandText(element.Operand) + labStr + " "; break; case EhrRestrictionType.Medication: filter = "`" + compStr + "`" + ">0 "; //Count greater than 0 (is taking the med). break; case EhrRestrictionType.Gender: filter = "Gender>-1 "; //Just so WHERE clause won't fail. break; } return(filter); }
///<summary>Returns text used in WHERE clause of query for tempehrlist.</summary> private static string GetFilteringText(EhrPatListElement element) { string filter=""; string compStr=POut.String(element.CompareString); string labStr=POut.String(element.LabValue); switch(element.Restriction) { case EhrRestrictionType.Birthdate: filter="DATE_SUB(CURDATE(),INTERVAL "+compStr+" YEAR)"+GetOperandText(element.Operand)+"Birthdate "; break; case EhrRestrictionType.Problem: filter="`"+compStr+"`"+" IS NOT NULL ";//Has the disease. break; case EhrRestrictionType.LabResult: filter="`"+compStr+"`"+GetOperandText(element.Operand)+labStr+" "; break; case EhrRestrictionType.Medication: filter="`"+compStr+"`"+">0 ";//Count greater than 0 (is taking the med). break; case EhrRestrictionType.Gender: filter="Gender>-1 ";//Just so WHERE clause won't fail. break; } return filter; }