示例#1
0
        /// <summary>
        /// 获取数据
        /// </summary>
        /// <param name="db"></param>
        /// <param name="query"></param>
        /// <param name="pageNum"></param>
        /// <returns></returns>
        public DataTable GetDataTable(string db, string query, int pageNum)
        {
            if (!PageConfig.isMemory)
            {
                return(null);
            }
            Dictionary <string, PageSQL> pageSQL = null;
            PageSQL page = null;

            if (dicPageQuery.TryGetValue(db, out pageSQL))
            {
                if (pageSQL.TryGetValue(query, out page))
                {
                    var dt = queryCache.GetDataTable(db, page.ID, pageNum);
                    if (dt == null && PageConfig.IsCacheFile)
                    {
                        return((DataTable)GetFile(db, page.ID, pageNum, true));
                    }
                    return(dt);
                }
            }
            else
            {
                Dictionary <string, DBQueryCache> cur = null;
                DBQueryCache cache = null;
                if (dicSQL.TryGetValue(db, out cur))
                {
                    if (cur.TryGetValue(query, out cache))
                    {
                        return(cache.GetDataTable(pageNum));
                    }
                }
            }
            return(null);
        }
示例#2
0
        public DataTable GetDataTable(long queryID, int pageNum)
        {
            DBQueryCache queryCache = null;

            if (dicQuery.TryGetValue(queryID, out queryCache))
            {
                return(queryCache.GetDataTable(pageNum));
            }
            return(null);
        }