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