public static Int32 AccessionCount(String accessionNumber)
{
String selectStatement = "SELECT COUNT(*) FROM ORD_Accession WHERE ACC_Accession = '" + accessionNumber + "'";
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return((Int32)cache.CacheExScalar(selectStatement));
}
public static Int32 getCorrectedResultsCount(String accessionNumber, String workListID, String testCode)
{
#region Prepare Query
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("SELECT COUNT(*) FROM ");
sb.Append("ORD_ARPTCorrectedResultValue ");
sb.Append("WHERE ");
sb.Append("ARCRV_ARPTC_ParRef='" + accessionNumber + "||" + workListID + "||" + testCode + "'");
#endregion Prepare Query
string selectStatement = sb.ToString();
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(Int32.Parse(cache.CacheExScalar(selectStatement).ToString()));
}
