petshop4中GetCachedParameters方法不解

[lanr8847]

小弟第一次发帖~~
在这里困扰很久没弄明白

        public IList<ProductInfo> GetProductsBySearch(string[] keywords) {

            IList<ProductInfo> productsBySearch = new List<ProductInfo>();

            int numKeywords = keywords.Length;

            //Create a new query string
            StringBuilder sql = new StringBuilder(SQL_SELECT_PRODUCTS_BY_SEARCH1);

            //Add each keyword to the query
            for (int i = 0; i < numKeywords; i++) {
                sql.Append(string.Format(SQL_SELECT_PRODUCTS_BY_SEARCH2, PARM_KEYWORD + i));
                sql.Append(i + 1 < numKeywords ? SQL_SELECT_PRODUCTS_BY_SEARCH3 : SQL_SELECT_PRODUCTS_BY_SEARCH4);
            }

            string sqlProductsBySearch = sql.ToString();
            SqlParameter[] parms = SqlHelper.GetCachedParameters(sqlProductsBySearch);
            
            // .......
     }

SqlHelper.GetCachedParameters(sqlProductsBySearch) 获取的哈希表里的值到底什么时候写进去的？
没找到SqlHelper.CacheParameters（）的调用。。哪位大大来解惑下

[weixiaolong]

我还真没具体看过

[sh1618]

 /// <summary>
        /// add parameter array to the cache
        /// </summary>
        /// <param name="cacheKey">Key to the parameter cache</param>
        /// <param name="cmdParms">an array of SqlParamters to be cached</param>
        public static void CacheParameters(string cacheKey, params SqlParameter[] commandParameters) {
            parmCache[cacheKey] = commandParameters;
        }

        /// <summary>
        /// Retrieve cached parameters
        /// </summary>
        /// <param name="cacheKey">key used to lookup parameters</param>
        /// <returns>Cached SqlParamters array</returns>
        public static SqlParameter[] GetCachedParameters(string cacheKey) {
            SqlParameter[] cachedParms = (SqlParameter[])parmCache[cacheKey];

            if (cachedParms == null)
                return null;

            SqlParameter[] clonedParms = new SqlParameter[cachedParms.Length];

            for (int i = 0, j = cachedParms.Length; i < j; i++)
                clonedParms[i] = (SqlParameter)((ICloneable)cachedParms[i]).Clone();

            return clonedParms;
        }

[lanr8847]

感谢2L吧代码贴全了
我也是认为CacheParameters() 是用来写进哈希表的，可没看见用它写，直接就Get了，问题是还真读出来了，我真的搞不懂了，什么时候写进去的？